New GCSE Tracker  1-9 for all subjects - interventions, predictions and QA analysis

password protected to ensure colleagues in teams cannot alter your data by accident and leave you trying to work out information!!!- password is Summer2016.
A tracker / mark book for classroom teachers, heads of department and heads of faculty, which allows colleagues to enter a % for any student assessment, piece of work, exam question, automatically converting to a grade 1-9 - these grades are based on boundaries offered as guidance from OCR, AQA and Edexcel for History, Geography and RS, but are editable for any teacher and course / subject.
Tracker colour codes students assessment against their target grades which can be whole numbers or + and - also. The tracker sheet takes all the hard work out of the data for colleagues, but averaging student performance for Y10 and Y11 separately and combined, as well as incorporating any mock exams. The tracker automatically generates intervention groups based on students who are currently off target, predicted to be off target, are borderline grades and / or are in key groups such as PP, SEN and Boy/Girl. The tracker has the ability to assume where students will be in 6-8 assessments time if the rate of progress remains the same, and can also visually show in tabular and graphical form if the measured gaps are closing or widening. For a head of faculty, there is the tab which allows any students studying in more than one area to be seen on a comparative level across the subjects. Takes the stress and time consuming data trawls away - simply enter a % and let the work be done for you! There is a full guide written and within the tracker. It is an absolute MUST for any department which can be used for KS4 and KS3.

Save for later
  • final-locked-humanities-gcse-tracker-with-tab-for-all-groups-to-show.xlsm

About this resource


Created: Mar 2, 2017

Updated: Nov 28, 2018


xlsm, 2 MB


Report a problem

Tes Paid Licence

How can I re-use this?