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







