web design

timer Asked: Jul 4th, 2018
account_balance_wallet $20

Question description

for this assignment we are creating a personal quiz that will provide a grade depending on the responses given. The quiz should contain at least three questions of the true/false and/or multiple-choice nature.

I have attached the file for details. please let know if you have any question.

Lab Practicum | String Manipulation, Files, Arrays, Structured Query Language, MySQL Online Quizzing You will be creating a personal quiz that will provide a grade depending on the responses given. The quiz should contain at least three questions of the true/false and/or multiple-choice nature. These questions should originate from Comprehension Check in your textbook (noting the chapter and page number). These questions and the correct answer identifier should be stored in a text file. A second table should contain the possible answers for the questions along with a unique identifier for each possible answer. You should pre-populate the text files with the questions or answers (depending on the text file). Design Requirements Creating the Text Files When you create your text files, you should put one question on each line. Each question in the question text file should have a unique identifier in addition to the question text. The identifier will be used in the answer text file to denote which question that possible answer corresponds to. The question table will also have a denotation of the unique identifier of the correct answer. The answer text file will have unique identifier for each possible answer (one of which will correspond to the correct answer for the question in the question text file). In addition to the identifier you will need to provide the text of the possible answer along with the identifier of the question that the answer belongs to in the question text file. This will help you correspond the question with the answers when working with the two files. Creating the Functionality The quiz must display in a form by pulling all the questions and their corresponding possible answers from the text file. Upon submission, your code should compare the response given for the question to the question’s correct answer that is stored in the question text file. This will allow your code to compute a quiz grade. Your code should display all quiz questions regardless of how many questions are stored in the text file. Below is an example of an initial quiz display with questions and possible answers pulled from the text file: Based upon the number of correct answers given, a grade should be computer through a user-defined function and provided to the user. If the score is:  80% or better, the score output should display in green  60% to 80% (not inclusive) the score output should display in yellow  50% to 60% (not inclusive) the score output should display in red  Less than a 50% the output should display in black Color specifications should be provided through the use of an external cascading style sheet. Below is an example the graded quiz, displayed below the quiz questions: Finally, even though not shown, you should include Last Modified Date information on your page. This should be provided dynamically by using the built-in date()function within the getlastmod() function. This page should also include a link to get back to your home page. You should use XHTML for the content of your application, and CSS for the stylizing of your page. Note that you do not need to implement your web site’s common navigation and structural components (header and footer) or its CSS file into the practicum. Rather your application should be aesthetically consistent throughout and use a new external CSS file to make the output more aesthetically pleasing than shown. The file should be uploaded to your Practicum 2 directory. Your XHTML file should be well-formed and created using a strict XHTML DTD. You can create the web page using any text editor (Microsoft Notepad, RogSoft Notepad+, Adobe Homesite, etc) that is not WYSIWYG capable (Adobe Dreamweaver, Microsoft Word, etc). Approach Begin by determining the structure of how you should store information in the text files to both meet the requirements given and ease the retrieval of information. Once determined, create the text files and place the quiz data in their respective files using the format determined. Then begin to retrieve the questions for display in an web form that submits to itself. Once you have the web form retrieving all the questions from the text files, you can add the logic needed to process the form. This should include creating the function needed to do the calculation and setting up the CSS file to handle the stylization and coloring of the grade output. Once working like the output given, you can add additional CSS formatting. Validate all the pages and correct any ill-formed tags where necessary. Submission To be eligible for grading you must submit your files to Blackboard. For your Blackboard submission, you need to submit all the files you created. You should also upload all files to your Lab Practicum 2 directory within your Zeus/Helios server space. Verify that the uploaded page works in the browser, as this may assist in grading (if also uploaded to Blackboard). Make sure that you can get to this page from your main IT207 home page. Extra Credit After fully completing the basic requirements of the practicum, choose only one extra credit option: Option A (for extra points on your Quiz Grade) Add completely new and original questions to the quiz in addition to the ones you chose form the Comprehension Check. The questions should come in pairs (one true/false and one multiple-choice) and should indicate the topic areas that each corresponds to. In order to be eligible to receive the extra points, the quiz questions should be contained in the question text file and the possible answers in answer text file like the basic requirements. The new questions must be fully functional and follow the basic practicum requirements. Note: Each course content related question deemed appropriate by the instructors in both rigor and structure will be eligible for points on your overall quiz grade. Each pair will replace one question you got wrong on an earlier quiz allowing you to receive a higher score. Option B (for extra points on the Practicum) You should modify the base practicum to implement the same requirements but now using a database. These modified files should be saved using new file names so you don’t overwrite the base solution to the practicum. You should have a link from the text file practicum approach to the extra credit files demonstrating you database-based solution. The questions and the correct answer should be stored in a MySQL table. A second table should contain the possible answers for the question. Through the MySQL command line interface, you should create the tables needed. While you can create a set of tables using whatever attributes/columns and data types you feel necessary, the following SQL statements may provide a starting guide for you: CREATE TABLE question ( ID INT PRIMARY KEY AUTO_INCREMENT , question VARCHAR(200) NOT NULL , answer_ID INT NOT NULL); CREATE TABLE answer ( answer_ID INT PRIMARY KEY AUTO_INCREMENT , ID INT NOT NULL , answer VARCHAR(200) NOT NULL); Note that the answer_ID in the question table should refer to the correct answer record in the answer table. The ID field in the answer table is the ID of the question in the question table so you know which question each of the possible answer choices refers to when you present the question and its possible answers. The only relationship between the tables is with the answer_ID where it is the foreign key in the question table and the primary key in the answer table. Through a series of INSERT statements in the MySQL command line interface, you should add the questions, the correct answer, and the possible answers to their respective tables. As part of your final Blackboard submission you should include a text file that contains a copy your database table creation scripts that you used in the console window. This will allow us to understand how your tables are laid out. Using the functionality listed in the original requirements, adapt it to work with the database while meeting all the basic requirements given.

Tutor Answer

Prof Befly
School: Boston College

hey there 🙌 I think I have followed all the instructions. Download the rar f...

flag Report DMCA

Outstanding Job!!!!

Similar Questions
Hot Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors