Stop rebuilding phonemic-awareness data sheets at BOY, MOY, and EOY. Track 12 skills across three checkpoints, see individual growth, identify areas needing support, and review class trends from one organized Excel workbook.

The Phonemic Awareness Progress Tracker K–2 organizes 12 phonological and phonemic awareness skills in a developmentally sequenced progression, moving from word and rhyme awareness through syllables, onset-rime, phoneme isolation, and phoneme manipulation.

Rate each skill at Beginning of Year (BOY), Middle of Year (MOY), and End of Year (EOY). The tracker automatically calculates mastery, growth, student status, and class-level trends.

No formulas to write. No manual tallying. No rebuilding your assessment grid three times a year.

---

★ 12 PHONEMIC AWARENESS SKILLS IN 4 STRANDS ★ WORD & RHYME AWARENESS

• Rhyme Recognition
• Rhyme Production
• Sentence Segmentation / Word Awareness

SYLLABLE AWARENESS

• Syllable Blending
• Syllable Segmentation
• Syllable Deletion

ONSET-RIME & PHONEME ISOLATION

• Onset-Rime Blending
• Onset-Rime Segmentation
• Phoneme Isolation / Initial Sound

PHONEME MANIPULATION

• Phoneme Blending
• Phoneme Segmentation
• Phoneme Deletion

---

★ SIMPLE 4-LEVEL MASTERY SCALE ★

Use the same rating system across all 12 skills and all three checkpoints:

Not Assessed — Skill has not yet been assessed

Beginning — Performs the skill with significant support

Developing — Performs the skill inconsistently or with some prompting

Mastered — Performs the skill independently and consistently

Using one consistent scale makes it easier to compare student performance from BOY → MOY → EOY.

---

★ 7 TABS INCLUDED ★ 1. How to Use

A quick-start guide explaining:

• How to set up the tracker
• The 12 skills
• The 4 developmental strands
• The mastery scale
• How BOY, MOY, and EOY assessments work
• How growth and status are calculated

2. Student Roster

Track up to 32 students.

Enter:

• Student Name
• Grade
• Teacher
• Group
• Notes

Add students once and use the roster throughout the workbook.

3. BOY Assessment

Record Beginning-of-Year performance across all 12 skills.

Automatic calculations show:

• Skills Assessed
• Skills Mastered
• % Mastered

4. MOY Assessment

Record Middle-of-Year performance using the same 12 skills and mastery scale.

Compare progress from BOY to MOY without creating a new spreadsheet.

5. EOY Assessment

Record End-of-Year performance across all 12 skills.

Automatic calculations show:

• Skills Assessed
• Skills Mastered
• % Mastered

6. Growth Summary

See each student's:

• BOY Mastery %
• MOY Mastery %
• EOY Mastery %
• BOY → EOY Growth
• Skills Mastered
• Current Status

The tracker automatically categorizes students as:

On Track — 80% or more mastered at EOY

Developing — 50–79% mastered

Needs Support — below 50% mastered

7. Dashboard

Get a classroom-level view of phonemic awareness progress.

See:

• BOY class mastery
• MOY class mastery
• EOY class mastery
• Mastery by developmental strand
• Students by status
• Skill-by-skill class performance
• Areas of strength
• Skills that may need additional instructional attention

---

★ HOW IT WORKS ★

1. Add your students on the Student Roster tab.
2. At BOY, rate each skill using the dropdown menu.
3. Repeat the process at MOY.
4. Complete the EOY assessment.
5. Review automatic growth calculations.
6. Use the Growth Summary to review individual students.
7. Use the Dashboard to identify classroom-level patterns.

The tracker handles the calculations for you.

---

★ BUILT FOR EASY DATA ENTRY ★

• Dropdown menus for mastery levels
• Automatic mastery percentages
• Automatic BOY → EOY growth
• Automatic student status
• Color-coded performance levels
• Class-level dashboard
• Skill-level summaries
• Up to 32 students
• 12 phonemic awareness skills
• 3 assessment checkpoints
• Fully editable
• No manual formulas required

Only the designated input cells need data entry.

---

★ EXCEL + GOOGLE SHEETS ★

The tracker is designed for use in Microsoft Excel and can also be used in Google Sheets.

Upload the Excel workbook to Google Drive and open it with Google Sheets. Standard spreadsheet formulas allow the core calculations to carry over.

---

★ PERFECT FOR ★

• Kindergarten teachers
• 1st grade teachers
• 2nd grade teachers
• Reading interventionists
• Literacy teachers
• Special education teachers
• Title I teachers
• RTI / MTSS progress monitoring
• Small-group reading instruction
• Beginning-, middle-, and end-of-year data collection

---

★ PAIRS WITH THE KOCO KYO PHONICS TRACKER ★

This tracker uses the same Not Assessed → Beginning → Developing → Mastered scale as the Phonics Skills Mastery Tracker K–2.

Use them together to monitor two connected parts of early reading development:

Phonemic Awareness → Phonics Skills

This makes them natural companion products and gives teachers a more complete view of foundational reading development.

---

Note: This is a teacher-created progress-monitoring tool. It is not a standardized, diagnostic, or norm-referenced assessment and does not replace school or district assessment procedures.

Files Included

• Phonemic-Awareness-Progress-Tracker-K-2.xlsx
• Excel workbook with 7 tabs
• Google Sheets compatible
• No PDF included

License: Single classroom use. Please purchase an additional license for another classroom or teacher.