One of the most tedious things about marking is having to work calculate students’ overall scores. When my students do a past paper (be it unit 1 or 3) I like to give them a breakdown by skill (listening, reading and writing) so that they can see where they need to focus their efforts. I created an Excel document which I (and my students) have found useful for working out their grades and for giving feedback.
All you need to do it to add the grade boundaries to the spreadsheet, and then add the score for each question on the exam paper. The percentage score and the overall score will be calculated automatically. I save a copy as PDF which I email to my students, but you could also print out each student’s results.
Click here to download a copy.
I hope that you find it useful. Happy marking!