Comparing and scoring 2 workbooks for students quiz

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