Letter and Sound Identification Growth Tracker | Automated Google Sheets Data Tracker
Take the guesswork — and the manual maths — out of monitoring early literacy growth! This fully automated, editable Google Sheet tracks your Foundation students' letter and sound knowledge across the whole year, and does the calculating for you.
Simply enter each student's scores at your testing points throughout Term One to Term Four, and the tracker instantly works out their growth. No formulas to build, no manual comparisons — just enter your data and watch the results appear.
What makes this tracker special:
-
Eye-catching sparklines — each student gets their own Growth Chart sparkline, giving you an instant visual snapshot of their progress trajectory. Perfect for data meetings, handover notes or parent-teacher interviews, when you need to show growth at a glance rather than talk through a table of numbers.
-
Automatic growth calculations — Mid Growth, Year Growth and Total Growth Points are all calculated automatically from your Semester One and Semester Two data, updating in real time as you add new results.
-
Colour-coded growth key — students are automatically flagged as Limited, Medium or Great growth, so you can spot who needs extra support in seconds.
-
Three ready-made tracking tabs — separate sheets for Uppercase Letter Identification, Lowercase Letter Identification and Sound Identification.
-
Curriculum-aligned — mapped to the Victorian Curriculum Foundation outcome VCELA146 (recognise all upper- and lower-case letters and the most common sound that each letter represents).
-
100% editable Google Sheet — make your own copy, personalise student names and testing dates, and you're ready to go.
Perfect for: classroom teachers, literacy leaders, intervention teachers and coordinators who want a low-prep, high-impact way to monitor early literacy growth — with visual, ready-to-share evidence for reports, PLCs and parent conversations.
How it works:
- Make your own copy of the Google Sheet.
- Add student names and testing dates for each term.
- Enter scores at each testing round.
- Sit back and watch the sparklines and growth figures calculate automatically!
