Track 16 core phonics skills across the year — from Not Assessed to Mastered — and quickly see which students and skills may need additional support.

This K–2 progress-monitoring tracker organizes 16 phonics skills across five instructional strands and gives you a simple way to record BOY (Beginning of Year), MOY (Middle of Year) and EOY (End of Year) status.

Track 4 Mastery Levels

Not Assessed → Beginning → Developing → Mastered

Leave a skill as Not Assessed until it has been taught or evaluated. Not Assessed is not counted against the student when mastery percentage is calculated.

16 Phonics Skills

Alphabet & Letter-Sound Knowledge

• Letter Names

• Letter Sounds

Short Vowels

• Short A

• Short E

• Short I

• Short O

• Short U

Basic Decoding

• CVC Words

• Digraphs

• Beginning Blends

• Ending Blends

Advanced Phonics

• CVCe

• Vowel Teams

• R-Controlled Vowels

• Diphthongs

Word Reading

• Multisyllabic Words

BOY • MOY • EOY Progress Tracking

Record each student's status at three points during the year and use the automatic calculations to see growth over time.

The Excel workbook calculates:

• Students assessed

• Mastered / Developing / Beginning counts

• Mastery % based on assessed skills

• Current status

• Class average mastery

• Per-skill mastery

• Skills needing review

• Students below the built-in 50% mastery flag

• Lowest-mastery skills

What's Included — 6 Tabs

1. Start Here

Quick-start instructions, mastery definitions and teacher/school/grade fields.

2. Student Roster

Track up to 50 students across all 16 skills and three assessment points.

3. Phonics Skills

Reference page showing the complete K–2 skill ladder.

4. Student Progress

Select a student and view all 16 skills across BOY, MOY and EOY, including mastery percentage.

5. Class Overview

Automatic dashboard with class statistics, student mastery levels, skill-level summaries and lowest-mastery skills.

6. Printable Sheet

One-page Phonics Skills Progress Report designed for printing and parent communication.

Built for Fast Data Entry

• Dropdown menus for consistent status entry

• Automatic colour coding

• Automatic calculations

• Freeze panes for easier navigation

• Up to 50 students

• Clean, teacher-friendly layout

• Hidden helper calculations keep formulas organized

Perfect For

• K–2 phonics progress monitoring

• BOY / MOY / EOY benchmarking

• MTSS / RTI data meetings

• Small-group planning

• Identifying skills for additional instruction

• Parent conferences

• Report-card evidence

• Phonics intervention planning

Printable Parent Report

The included US Letter Phonics Skills Progress Report gives you a simple way to communicate a student's current phonics profile and growth.

Compatibility

Microsoft Excel: Desktop Excel and Microsoft 365. Desktop Excel is recommended for full workbook functionality and recalculation.

Printable: US Letter.

Important Note

This resource is a progress-monitoring and instructional tracking tool. It is not a standardized diagnostic assessment and should not be used as a substitute for formal evaluation or professional judgment.

License

Single-classroom use only. Do not resell, redistribute, share publicly or upload the resource to file-sharing sites.