Online Quiz

[peter11]

I am creating an online quiz system for my school district. Teachers will be able to log on and create a quiz.
Students will then be able to go on-line and search under the teachers name or department and take the quiz.

This my first quiz program, so if anyone has any code or pseudo code or even a database structure I would greatly appreciate it.

Thanks

 

[calista]

I haven't look at these, but they might get you started:

http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=quiz&search=search

Calista :-X
Jedi Knight,
Champion of the Force

 

[Arion23]

Hi Peter,

I've been working on and off on an exam system in ColdFusion for some time, and it's starting to shape up nicely (still missing heaps of features, but the bare-bones of it works pretty well) - at the moment I'm working on a user access systems that allows registered users to contribute exams and questions to the database.

I'm happy to help out with code, ideas and advice from my own experiences while working on this - let me know.

 

[peter11]

Arion23
I am not sure how to contact you. I would like to know how your database is set up regarding questions, possible answers and correct answers. I might be able to help with the logon, I have something already set up.

 

[Arion23]

Basically, I have three tables in the database that are used for each exam/question/answer set (there are other tables but they are used for various other things):

tableExam
ExamID - Unique identifier
+ Exam title, info etc

tableQuestion
QuestionID - Unique identifier
ExamID - links to tableExam (1-many relationship)
+ Question, references etc

tableAnswer
AnswerID - Unique identifier
QuestionID - links to tableQuestion (1-many relationship)
IsCorrect - bit field (1 or 0) that defines if the answer is correct
+ Answer text etc

It might not be the most efficient way, but I find it is fairly easy for me to understand the relationships. By seperating the exam/question/answer tables, I've been able to easily implement questions like True/False, (virtually) unlimited numbers of answer for each question, and questions for each exam.

Setting the IsCorrect flag in the answer table has let me implement questions which have multiple correct answers, as well as questions with only one correct answer.

If you want any more info, you can contact me at dgrubb@iprimus.com.au