Tracking Bundle: Whole Class and Single Subject GSCE Tracker
Track every pupil’s GCSE progress from target to final grade with this two-file Excel bundle designed by a teacher, for teachers. Enter your data once and let the spreadsheets do the rest, with automatic RAG status, grade gaps, and whole-cohort summaries updating instantly.
This bundle includes two trackers:
1. Whole Class GCSE Tracker
A bird’s-eye view of your entire cohort across 12 subjects. Track target, predicted, and actual grades for every pupil side by side, with an automatic overall RAG status flagging pupils who need attention across multiple subjects. Perfect for Heads of Year, form tutors, and senior leaders monitoring whole-cohort performance.
2. Single Subject GCSE Tracker
A deeper, subject-level tracker for classroom teachers and Heads of Department. Track target, predicted, and actual grades alongside percentages, automatic grade gap, and RAG status per pupil. A colour scaled grade gap column instantly highlights who is above, on, or below target, ideal for identifying intervention priorities.
Both files include:
Target, predicted, and actual grades (1–9) with percentage columns
Automatic RAG status : GREEN Above Target, YELLOW On Target, RED Below Target
Class/cohort summary tab with averages and percentage breakdowns
Built-in user guide tab — no instruction sheet needed
5.Formula-protected cells — pupils and colleagues can’t break it
Up to 50 pupils per tracker
No macros, works on any version of Excel
Instant download, open and use today
Perfect for:
Classroom teachers, Heads of Department, Heads of Year, and Data Managers in English secondary schools tracking GCSE cohorts.



