Phonics Screening 2023 Data Tracker – Automatic Scores & Class Analysis

This easy-to-use spreadsheet for the 2023 Phonics Screening Check instantly calculates pupil scores, breaks down real vs. pseudo words, and shows class trends at a glance – giving you clear, accurate data in seconds.

Make analysing your class’s 2023 Phonics Screening Check results quick and easy with this ready-to-use spreadsheet.
Teachers simply enter a 1 (correct) or 0 (incorrect) beside each word, and the spreadsheet automatically generates:

• Individual pupil scores (total percentage, plus breakdown into real words and pseudo words)
• Whole-class word analysis - see at a glance which words most children found tricky
• Instant percentages for each child and for each word across the cohort
• Clear, accurate data that can be shared with SLT, used for pupil progress meetings, or to inform phonics interventions

This tool removes the need for manual calculations, saving you valuable time and giving you clear insights into strengths and gaps in phonics knowledge.
Perfect for:

• Year 1 teachers preparing for or analysing the 2023 Phonics Screen
• Year 2 teachers re-testing children
• Literacy/phonics leads monitoring progress across the school

No macros, no fuss - just a simple, effective, Excel-based tracker that does the hard work for you.

What you’ll receive:

• 1x Excel spreadsheet pre-formatted for the 2023 Phonics Screening Check
• Easy-to-follow instructions for use