Comparing and scoring 2 workbooks for students quiz

Closed
Report
Posts
1
Registration date
Sunday December 25, 2016
Status
Member
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