Progress 8 Tracker
Save hours of admin with this ready-to-use Progress 8 Tracker for Excel, just enter your pupil data and let the spreadsheet do the rest. Designed by a teacher for busy secondary school educators, this tracker automatically calculates Attainment 8 and Progress 8 scores for up to 50 pupils based on their KS2 starting points and GCSE grades.
What’s included:
Tracker sheet enter KS2 scores and GCSE grades (1–9) and Progress 8 calculates instantly
Automatic colour-coded status Above Expected (GREEN), On Track (YELLOW), Below Expected (RED)
Summary sheet whole cohort averages, breakdown, and percentage above/below expected progress
Full user guide tab step-by-step instructions built into the file
Formula protected cells, pupils and colleagues can’t accidentally break it
Perfect for:
Secondary teachers, Heads of Department, Heads of Year, and Data Managers tracking GCSE cohort progress in English schools.
Key features:
Covers all 8 GCSE slots with correct double weighting for English and Maths
EBacc and open slot buckets clearly labelled
Works for both actual results and predicted/estimated grades
No macros works on any version of Excel
Instant download open and use today



