Subject tracker - perfect for data capture

This is set up currently for a KS4 Science set up, but if you change the names of the columns this would work for any subject. If you use different assessments than us (which you will) then you would need to edit the formulas for the assessments. (I have set it up so that the formulas do not generate a % until the end column, so you would only need to change the score divisor so that it is indicative of your assessment.) And your grade look ups may need to be edited, but again its all ready for you to edit as you see fit. if you add ‘abs’ into each test score it will not count that score and remove that from the average, therefore giving you nice and robust data which will allow you to look up the performance of classes, year groups or cohorts. I have also provided a look up table at the bottom to show you the distribution of grades in the set of data. (All of these functions can be tweaked to suit your school, number and the like, but will need your input once downloaded.)

We used this to help with assessing for our TAGs recently to help take the pressure off.