Finding who got 80% right on questionaire? Need fast HELP!

[Shadez]

Scenario:

25 Multiple Choice Questions. Stored in a table each question has it's on cell.

25 Answers stored in another table

I need to determine who got over 80% right

 

[DougP]

First you have to figure out if an answer is right or wrong then just use a query to "Count()" that field.

If the count is greater than what ever 80% of 25 is then they got 80% or better. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Shadez]

Thanks Dougp, this much I know. I have 25 fields though. 25 answers / to check against 25 questions.

So each table has 25 fields . Plus the identifier. what I need to know id the best way to determine the correct ones

 

[PPSAG]

Create a table with the correct answers to each question, then do a join query to compare each answer to the "correct table" then you'll have a count of each score, then it's just a matter of doing the math to see who got at least 20 right.

 

[THoey]

I think the best way is to have one table with the following fields:

tblQ_A
QuestionID
Question
CorrectAnswer

Then have another table with your responses:

tblResponses
PersonID (foreign key to some other "person" table)
QuestionID (foreign key to tblQ_A)
Answer

Then you can create a query which will provide a list of names of all the testee's (?) that have scored 80% or more.

I know, this doesn't work with your structure, but as you can see, having the design as you do makes it really difficult to "process".


Terry M. Hoey

 

[tlbroadbent]

Assumptions -

Questions table columns:
TestID Number Primary Key
Ans1 Text(1) values? ("A" thru "E&quot
thru
Ans25

Answers table column:
AnswerID Number Primary Key
TestID Number
PersonID Number
Ans1 Text(1)
thru
Ans25

Query to determine percent correct:

Select
a.TestId, a.PersonID,
Abs((a.Ans1=q.Ans1) +
(a.Ans2=q.Ans2) +
(a.Ans3=q.Ans3) +
.
. insert the remaining expressions here
.
(a.Ans24=q.Ans24) +
(a.Ans25=q.Ans25)) As TotalCorrect,
100.0*TotalCorrect/25.0 As PercentCorrect
From Answers As a Inner Join Questions As q
On a.TestId=q.TestId
Where TestID=[Enter TestID to Summarize] Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.