Anurag
|
| Posted: 02/13/2002, 1:07 AM |
|
we are going to develop a quiz system for the students.
The Table sturcture of Question Table is :
Q_ID(AutoNumber)
Chapter_no (Number)
Question (Text)
Option_1 (Text)
Option_2 (Text)
Option_3 (Text)
Option_4 (Text)
Correct_Answer (Number)
We are using a Grid form to display the Question One at a Time
Our problems are:
1. In multiple type/True-False question , Only one option can be choosen by user .
2. On submit (Next) the question , The result will be calculated and stored in a seprate table "ATTEMPT".Whose structure is as follows :
User_ID
Chapter_No
Question_ID
Option_Choose
Result(Right/Wrong)
( The correct answer for this question is already stored in the MS-Access database table)
3. When the user finished his test the total result will be displayed on the screen with all answers given by the User.
How Can we do this in CC
Thanks in advance
Anurag
|
|
|
 |
Teodor Drizer
|
| Posted: 02/13/2002, 4:35 AM |
|
Checkout hotscripts.com , it contains a lot of such scripts.
Learn from them.
|
|
|
|
Tom
|
| Posted: 02/13/2002, 6:51 AM |
|
I'm working on a similar project (but to do surveys). I haven't gotten very far yet and my approach may be different than yours. (I'm also using ColdFusion). My tables may also be normalized different than yours. I have a questions table (pk questionId), results table(pk resultId) and customer table (pk customerId). The results table has foreign keys of questionId and CustomerId)
Logically, the student 'registers' with a record form (this is my customer table that assigns a unique id to each person. On submit(insert) of that person record, I have an after insert event that populates my results table table with all of question Ids and the customer Id. Now I have a grid that looks at the results table looking up that customerId. The results table also has a field for their answer. Now with CC I'm making this grid into an editable grid (see their tips) so you can just select answers to store into the result table.
Perhaps I've confused you more .... but fyi
|
|
|
|
|
