Student Test Tracking spreadsheet - single test

This spreadsheet will allow you to greater analyse the performance of your students in a test. It will automatically calculate totals, percentages, grades (according to grade boundaries that you specify) etc. It will also colour-code performances on questions against the maximum marks available and provide you with the opportunity to print out individually tailored feedback sheets to your students.

I have found that this gives me an excellent method for communicating with students about their relative performance, rather than simply telling them that they have achieved 58% for example.

The file will come to you as a password protected document. The reason for this is so that it is not possible to make changes to the formulae and thus make it so that it does not work. You do not need to unprotect it to make full use of it, but just in case you wish to make changes, the password for the file is “table”.

I have made a video demonstrating it and telling you how to use it, which can be found at:

https://youtu.be/G0_WWFINHqM

I also have a larger version available, also on the TES website, for the analysis of up to ten tests, allowing you to compare a student or class throughout those tests.