Phonics & Phonological Awareness Data Tracker (Excel & Google Sheets)

This Individual Student Phonics and Phonological Awareness Data Tracking (OG Aligned) resource is a comprehensive tool designed to monitor and record student progress throughout the academic year. Provided in both Microsoft Excel and Google Sheets formats, it allows for seamless digital tracking across your preferred platform or easy single-page printing for physical records.

It helps inform targeted intervention groups, small-group work, or whole-class instruction. The summary page can easily be printed for discussions with parents, guardians, school leadership, or support specialists.

Track student progress across key foundational areas:

Standardised Assessments: DIBELS / MAP / Local Benchmark Tests (editable to match your school’s framework)
High-Frequency & Sight Words

Phonics Screener:
Lowercase Letter Names
Uppercase Letter Names
Letter Sounds
CVC
Digraphs
Blends
Long Vowels 1 (silent e/final y)
Advanced Consonants
Long Vowels 2 (vowel teams)
Variant Vowels
Mixed Syllable 1
R-Controlled Vowels / schwa / 3 consonant blends
Diphthongs
Diphthongs 2
Mixed Syllable 2

Phonemic Awareness:
Word count
Rhyme Recognition
Rhyme Production
Syllable Segmentation
Syllable Blending
Phoneme Blending
Syllable Deletion
Phoneme Isolation of Initial Sounds
Phoneme Isolation of Final Sounds
Phoneme Segmentation
Phoneme Deletion of Initial Sound
Phoneme Deletion of Final Sound
Phoneme Deletion of First Sound in Consonant Blend
Phoneme Substitution

Key Benefits:
Parent-Teacher Consultations: Provides a clear, single-page snapshot of student attainment over time.
Data-Driven Teaching: Helps identify learning gaps to guide differentiated instruction.
Intervention & Support: Suitable for SEND (Special Educational Needs & Disabilities), Inclusion Frameworks, Wave Provision (Waves 1–3), and Universal / Tiered Interventions.
Flexible Format: Easily printed for physical records or managed digitally.

If you find this product helpful, I’d love to hear from you!