Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Multiple Choice Test, Using SQL.

Author  Topic 

Amberrosereynolds
Starting Member

9 Posts

Posted - 2012-01-12 : 12:11:03
I am trying to create a multiple choice test using SQL, and I can not figure out a way to make it so that it detects which answers are right or wrong, I need to be able to do this, and add up the final score that the test taker has achieved.
They also need to be able to view their scores at the end, and be able to see which answers they got right or wrong, any suggestions would be grateful!

This is for a website which users will be taking tests on which will be up and running in a few days (hopefully)

Thanks!

X002548
Not Just a Number

15586 Posts

Posted - 2012-01-12 : 12:14:19
Table1
Users (Test Takers)
Table 2
Questions (with correct answer "letter" i.e a,or b)
Table 3
Question Choices (Q1, a. you can lead a horse, b. Camels, c. Tequila)
Table 4
Answers (UserID, QuestionId, Answer)

Is that what you have?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

Amberrosereynolds
Starting Member

9 Posts

Posted - 2012-01-12 : 12:17:26
Thank you, this is brilliant, is there any way you could make the tables add up and come with a percentage out of 100 for the right answers?
Go to Top of Page
   

- Advertisement -