Forum Discussion
chart
HI! I am in MSN school and want to make a chart to keep track of true/false answers to a pre/post test that has 15 questions. There will be about 200 of each pre and post-test. I need to calculate...
I have a test with 15 questions, answered true/false. The test is given prior to and after a class, same questions to see what participants have learned in the class. 18 classes with about 25 people in each class. I want to be able to document each answer with a running total for each question...what is best way to do this via excel
18 class x 25 people = 450 students
meaning each will have a test of 15 questions answerable with true/false.
(same questionnaire for all 450 students).
it will be cumbersome if you will input all that 450 test papers into the spreadsheet - unless they will answer them on a spreadsheet - in that case you will have to compile them into one workbook. You would grade each test paper (sheet) then put them all (score) in a summary sheet. To ease the work - it should be done by VBA.
there are many good people here who can help you with that.
thanks..
meaning each will have a test of 15 questions answerable with true/false.
(same questionnaire for all 450 students).
it will be cumbersome if you will input all that 450 test papers into the spreadsheet - unless they will answer them on a spreadsheet - in that case you will have to compile them into one workbook. You would grade each test paper (sheet) then put them all (score) in a summary sheet. To ease the work - it should be done by VBA.
there are many good people here who can help you with that.
thanks..