Monty
|
| Posted: 01/02/2002, 1:13 AM |
|
Dear Sir,
I want to make a on line test system like http://www.brainbench.com for my school where many students login simultanesouly and questions come 20 questions RANDOMLY come from the database and appeared one question at a time on a page with next question button. when 20 question complete the result will be appeared instantly with the right answer where the student give wrong answer.
How Can I Make This with CC.
|
|
|
 |
junaid
|
| Posted: 01/02/2002, 8:34 AM |
|
hello!
i am also doing the same project. i didnt know the solution but i am guite interested to do that project. why not work together? u can mail me at
junaid_chaudhary@yahoo.com
|
|
|
|
DPS
|
| Posted: 01/02/2002, 9:33 AM |
|
I think you could tackle it by seperating the two issues. The first issue is how you want to display any question. That's probably the easier task.
Assuming a simple table structure:
Question_Id
Question_LastUsed
Question_Description
Question_Active
You could do a query on _LastUsed and _Active
the second task is a bit more complex, but doable. if you are using a sql backend, then you could call a stored procedure that would return a randomly selected question_id that you would then use to populate your form. The stored procedure (assuming the above table structure) would randomly select a question based on the total number of active questions and based on the last time the question was used (to your threashold).
I've sketched out this type of logic for a SQL backend using CF, it was a while ago, I'd be happy to share some of the ins and outs with you. I'm not a CC guru, but if you can break it up into those two pieves I think you can get what you want out of CC.
Doug
dsmith@savantpartners.com
|
|
|
|
rclayh
|
| Posted: 05/02/2003, 8:51 AM |
|
I did an online test system one time and found it easiest to write a routine to pull the 20 questions up front and write them to an answers table. Then the student works through the list. It was a lot easier to make sure you didn't get duplicates etc.
What you'll need is a quiz database (for the amount of questions to pull), a questions database, and a results database. When the student decides to take the quiz populate the results database with 20 id records from the questions database and leave the answer null. Then keep pulling where student=student and quiz=quiz and answer=null. When there's no more records, run the results etc.
Hope this helps,
Clay
http://www.netfishbowl.com - home of the $8.75 domain name.
|
|
|
|
rclayh
|
| Posted: 05/02/2003, 9:01 AM |
|
Forgot to mention, by prefilling, the student had the option to skip the question and it would still come up later.
Clay
|
|
|
|
|
