Assessment Tracker (RAG)
Red-amber-green progress grid.
The Assessment Tracker (RAG) is a blank red-amber-green progress grid that turns a class-worth of assessment data into an instant colour-coded overview. Each cell in the grid represents one pupil against one objective or assessment point; the teacher shades or writes R, A, or G to indicate whether the learner is below, approaching, or meeting the expected standard. The RAG system is language-neutral and works at a glance, making it a favourite for department meetings, pupil progress reviews, and SLT data conversations. Because the template is entirely blank, it is equally at home tracking end-of-unit quiz results in Year 2, GCSE mock grades across a tutor group, or termly assessment milestones for a Reception class. No software or spreadsheet skill is required — just a grid, three colours, and a pen.
Learning objectives
- Produce an instant visual class overview of attainment across multiple objectives
- Identify Red students who need urgent intervention before they fall further behind
- Spot patterns where a whole-class Amber or Red signal that reteaching is needed
- Prepare concise, visually clear data for pupil progress review meetings
- Track whether RAG ratings shift over time as a measure of teaching impact
- Share accessible progress snapshots with parents, TAs, or senior leaders
How to use this template
- Print the blank grid and label columns with assessment objectives or learning outcomes.
- Write student names down the left column — one row per pupil.
- After an assessment or observation window, shade or initial each cell R, A, or G.
- Scan the completed grid to identify patterns: who needs support, who is ready to extend.
- Reprint a fresh copy at the next assessment checkpoint and compare side by side to measure progress.
Classroom & home ideas
- Use at the end of each maths unit to decide which pupils join a same-day intervention group before the class moves on.
- Bring a completed RAG grid to every pupil progress meeting — it communicates more in five seconds than a page of prose.
- Project the anonymised grid on a whiteboard during a department planning session to agree shared next steps for the cohort.
- Give each pupil their own personal RAG row in a learning journal so they can self-assess against the same objectives.
- Overlay two grids — one from the start of term and one from now — to show growth at a parent or governor presentation.
Skills & curriculum links
Frequently asked questions
What exactly do Red, Amber, and Green mean?
The definitions are yours to set, but a common convention is: Red = below expected standard and at risk of falling further behind; Amber = approaching expected standard with some gaps; Green = meeting or exceeding expected standard.
Can I use this template for whole-school or year-group data days?
Yes. Print one tracker per class and line them up to see patterns across year groups. The blank format means it scales from a five-pupil intervention group to a 200-pupil year cohort.
Is it GDPR-compliant to carry this sheet around school?
The template itself contains no personal data until you fill it in. Once completed with pupil names, apply your school's data-handling policy — store securely, do not leave unattended, and anonymise before sharing beyond your team.
How is this different from a plain mastery checklist?
A mastery checklist typically uses tick or date to record skill attainment. The RAG tracker adds a third, provisional state (Amber) that captures emerging understanding — useful for ongoing assessment rather than binary mastery judgements.
Make it your own in the Worksheet Studio
Combine this with other worksheets, duplicate it, or generate a fresh version for any grade and language — free, no sign-up.
Open the Worksheet Studio