Forum Discussion

Denise Walsburger's avatar
Denise Walsburger
Copper Contributor
Oct 02, 2018

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 the differences in the tests results.  how do I do this? 

Charting
excel
Formulas and Functions
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Oct 03, 2018

    it would be easier for the people here at the forum to help you if you provide a sample of what you need - kindly elaborate every aspect.

    thanks..

    • Denise Walsburger's avatar
      Denise Walsburger
      Copper Contributor
      Oct 03, 2018

      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

       

      • Lorenzo Kim's avatar
        Lorenzo Kim
        Bronze Contributor
        Oct 03, 2018
        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..

Resources