A free Excel tracker for Year 6 writing against the KS2 English writing teacher assessment framework, which only asks you to record the gaps.

How it works
Choose a best-fit standard for each child (working towards, expected or greater depth). Then type N for any statement that isn’t secure yet, or W for a particular weakness you are allowing. Blank means secure, so most children need just one choice, and a class takes about ten minutes.

What it shows

• Nearly there: children who are one or two statements from the next standard, and exactly which statements they are missing.
• Class gaps: for every statement, how many children it applies to aren’t secure yet, so you can see what to teach the whole class next. Filter by class.
• Particular weaknesses: a one-line note for each, so the reason is written down.
• Checks: flags judgements that don’t agree with the gaps you have marked.

Statement guide
Every “pupil can” statement in the framework’s own words, with what it means in plain English, what it looks like in a child’s writing, where to find it and what to watch out for. The PDF has one page for each standard, ready to print.

What’s included

• The tracker (Excel), ready for your class
• A copy with an example Year 6 cohort
• Quick guide and statement guide (PDF, 5 pages)

Please note
The tracker is for teaching decisions. It doesn’t make the judgement for you, it isn’t moderation evidence and it doesn’t ask you to count or store pieces of writing. It needs Microsoft Excel (desktop, or Excel for the web, free with a Microsoft account). Google Sheets is not supported. No macros.

Statement wording: Teacher assessment frameworks at the end of key stage 2, Standards and ����Vlogting Agency. Crown copyright, Open Government Licence v3.0.