How to put test questions then student answers and get % correct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A Student asks a question 3
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Student loan formula 8
How can I use Excel to mark student's tests? 1
Return text not excel address 2
Shutting off all calculations 7
Compare multiple rows for duplicated values in individual columns 1
SUM Formula and Logical Values 3

Back
Top