Progress & Attainment Tracker | RAG-Rated | Gaps, Trends & Summary Dashboard

Prove progress. Identify gaps. Show impact.

This Progress & Attainment Tracker is a fully automated Excel spreadsheet designed for teachers and leaders who need clear, defensible evidence of progress — now.

Used weekly or half-termly, it replaces manual calculations with instant insight, helping you identify underperformance early and demonstrate improvement over time.

What this tracker does

✔ Tracks student progress over time
✔ Compares attainment vs expected automatically
✔ Identifies gaps, trends and movement (improving / stagnant / declining)
✔ Uses RAG colour-coding for instant accountability
✔ Produces a one-page summary dashboard for meetings and inspections

Key features

• Automatic totals and averages
• % progress towards target calculated instantly
• RAG-rated student and group outcomes
• Gap analysis by key groups (e.g. PP, Gender, SEND, EAL)
• Trend tracking across multiple assessment points
• Clear identification of at-risk students
• Fully editable thresholds (to match school expectations)

Why teachers and leaders use this

• Used constantly (weekly / half-termly)
• Linked directly to outcomes and accountability
• Removes guesswork — replaces it with evidence
• Simple, familiar spreadsheet layout — no training required

This is the tracker you open before line management, progress reviews or inspections.

Ideal for

• Classroom teachers
• Heads of Department
• Progress leads
• SLT and middle leaders
• Intervention and tracking meetings

Technical details
✔ Microsoft Excel (Windows & Mac / iOS compatible)
✔ No macros — safe for school systems
✔ Works with Excel Online
✔ Google Sheets compatible (minor formatting differences only)