Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to put test questions then student answers and get % correct
I need to make a sheet with test questions and answers. Then I need to put
in all students and their answers. Afterwards I need it to caluate the percentage that was correct. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to put test questions then student answers and get % correct
How are questions distributed to students? And returned to you?
Do the questions have multiple choice answers? If Yes, then you could have a table of questions and correct answers and use VLOOKUP to check a students answer, putting 1 if correct, 0 if incorrect. Then use SUM to get a student's mark and then calculate %. The multiple choice selections for a question could be done using Data Validation. HTH "Kathy" wrote: I need to make a sheet with test questions and answers. Then I need to put in all students and their answers. Afterwards I need it to caluate the percentage that was correct. Can anyone help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to put test questions then student answers and get % correct
Assuming student names in column A, and column B their scores, and column C
either have "y" for correct answer, "n" for wrong answer In D2: =COUNTIF(C2:C10,"y")/COUNTA(C2:C10) "Kathy" wrote: I need to make a sheet with test questions and answers. Then I need to put in all students and their answers. Afterwards I need it to caluate the percentage that was correct. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customizing help questions/answers | Excel Discussion (Misc queries) | |||
Why do I get correct answers to formula then #NAME for some no's | Excel Worksheet Functions | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
Correct answers like a quiz | Excel Worksheet Functions | |||
Saving Posts Questions & Answers In My Computer | Excel Discussion (Misc queries) |