The template of the quiz is all set up. The result that was shown is exactly what I need. I need you to modify this and use the database to keep all of these data.
Store in the Database
Questions
Question ID – it is unique number to identify
question – a question
level – which level it should be
media – the name of the video or audio
type – which it is? Video or audio?
correct – the number of the correct answer
answer 1 – choice of the answer
answer 2 – choice of the answer
answer 3 – choice of the answer
answer 4 – choice of the answer
answer 5 – choice of the answer
answer 6 – choice of the answer
answer 7 – choice of the answer
answer 8 – choice of the answer
answer 9 – choice of the answer
answer 10 – choice of the answer
picture – an image show only for audio
title (varchar 255) – the title of this question
second – need number that will pop up the answers.
Answers
Sid - it is unique number to identify
studentid – student id
question_asked – keep record of all questions that was asked
question_response – keep record of all questions that was response
answer – keep record of all correct and incorrect answer
level – The result of the level
time_response – Keep track of time for each question
time_total – Keep track of total time for each question
taken – 1 is done with the exam -- 0 for new exam or resume to the exam
date – need the date of when the quiz was taken.
Students
First_name – first name of the student
Last_name – last name of the student
Student_ID – student ID or number
Error during the Quiz
If there is no video or audio show during the exam, it goes to next page that display the warning message. The message says “Missing Video or Audio”. Save the result in the database and exit the exam. The user has to log in again to resume the exam where it stops at.
If the exam was not complete, the user has accidentally closed the exam. It should save the result in the database. The user has to log in again to resume the exam where it was stops at.
If there is any error during the process, it goes to next page that display “Error in the exam, please contact your professor” Then the professor click to close the exam. The user has to log in to retake the exam again.
Back-End Quiz
Need to edit/update/add question
Need to able to change the rules. I need to create many different templates that able to use different kind of rules.
Need to have nice table of result for each student that taken my quiz. I need to click any student and it displays the result of the chart.
Front-End Quiz Update
I need you to make it pop up in full screen. I don’t want the user able to control anything else but only to this quiz. There should be no toolbar, menu or anything.
Make it nice and big that fill out the screen of the monitor.
I need you to set up a page that check student id in the database before process this quiz. Also check if the quiz already taken then cannot take the quiz again. The admin panel should have a switch or something that allow the user able to take the quiz again.
There are some questions related to media or audio. Either media or audio, it should loop only twice. After the first loop, the answers will show.
There are some questions that related to timer. I need the answer show up at specific seconds. For example, on question #22, the answers show up in 10 seconds.
Please store everything in the database that I can look back to see the result and questions.