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?