Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customizing help questions/answers awakening2lite Excel Discussion (Misc queries) 0 June 10th 07 10:25 PM
Why do I get correct answers to formula then #NAME for some no's James W. Excel Worksheet Functions 1 April 20th 07 10:25 AM
Calculate mean of test scores from rows of test answers RiotLoadTime Excel Discussion (Misc queries) 1 July 26th 06 05:14 PM
Correct answers like a quiz Penny Freeman Excel Worksheet Functions 1 April 18th 06 09:52 AM
Saving Posts Questions & Answers In My Computer Enrique Excel Discussion (Misc queries) 3 November 9th 05 10:40 AM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"