Ths is a detailed explanation of what i really want to do.
When a student logs into my system, they will access the chapter page which has a list of chapters. Each chapter will then be linked to the lesson page where each chapter has more than one lesson stored. So in my database, i have the Chapter Table which stores the ChapterID and ChapterName. While the Lesson Table will store the LessonID, and Lesson Name.
Then the student will click on the lesson wanted and the lesson/quiz will then be displayed in the next page based on the questions in the database. So therefor there will be the Lesson Question Table which stores the QuestionID, Question, Image, and Answer.
So now, i have related these tables and there will be another table which is the Marks Table that stores IDMark,Marks, IDStudent and Date. The problem lies here where im not sure how can i relate the marks table to the lesson questions table. Coz as u can see, i need 3 primary keys for my lesson question table which is the ChapterID,LessonID and QuestionID. The Marks Table has one primary key which is the MarksID. and the StudentID is related to the StudentInfo Table which stores the students infomation.
so, basically the quiz inteface will have the question number, question and the student is required to type in the answer, thus it is a fill-in-the-blank quiz. each question will have one texbox for the answer to be filled in. what i am doing now is that im displaying the textbox together with the question using the For loop and that is another problem that im facing which is how can i code to distinguish the first textbox with the following ones...i know i have to place some sort of an identifier but im not sure how. Then the answer will be validated according to the answers in the database and the next page will display the answers in the database with the answers from the student plus the marks obtained. I am also creating a chart progress report that displays the performance of each student for each set of lessons in each chapter. Ive not started that as i havent finished the quiz module which im explaining to u abt now.
i hope my explanation is good enough for u to figure how my online quiz looks like...its basically database driven and the admin is able to add, delete and edit the question (that part is settled). hope u could reply as soon as possible. thanks a lot Sachin.
PS: Im using ASP VB
Script, developing in Macromedia Dreamweaver MX