Comparing and scoring 2 workbooks for students quiz [Closed]

Registration date
Sunday December 25, 2016
Last seen
December 25, 2016
Hi all

I am teaching students basic Excel skills and they have a quiz to do where they do certain basic tasks on a spreadsheet.

I have a workbook with all the correct answers and then when the students complete their quiz they have their workbook. At the moment I use spreadsheet compare in office 2013 to compare the 2 workbooks so the students can see what they have got right and wrong.

This means though that I have to go round every student and run this which obviously takes a considerable amount of time.

So my question is - is there an automatic way I can check the students workbooks and give them some sort of score depending on how close they got to completing their workbook to the correct answers?

Thanks in advance

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!