Decodable and High-Frequency Word Assessment in Google Sheets™ - Editable Template

✅ Collect quarterly data on your students' decodable and high-frequency word skills!  Track your students’ word reading skills specific to your curriculum or scope and sequence with this editable quarterly benchmark assessment in Google Sheets™!

✅ Graphs demonstrate average and median growth for your whole class!

✅ Share at data meetings or demonstrate student growth for end-of-year teacher evaluations!

✅ Words read incorrectly are copied to the student summary sheet!

✅ Use the data to inform your instruction and provide students with the support they need to be successful readers.

✅ Simply enter up to 90 decodable words and 45 high frequency words for each quarter into the template and generate digital assessor probes and printable student probes to assess up to 30 students. Enter different words for each quarter, or use the same words each time. 

The all-in-one Google Sheets™ Workbook includes the following:

• A template for entering words from your curriculum or scope and sequence. You can use different words each quarter or the same. Changes to the title, headings, and categories are automatically copied to the probes, data sheet, and graph.
• 30 assessor probes with 4 (quarterly) assessments per probe, automatically generated from the words entered on the template.
• Student summary at the bottom of each assessor probe, showing raw score, percent correct, and specific words read incorrectly.
• Student probes for each quarter, with shading either horizontally or vertically depending on which direction you would like students to read the words.
• Data sheet showing decodable and high-frequency word percentages for each student, each quarter.
• Two graphs demonstrating whole class average and median growth throughout the year!

How to use this template:

• Enter the decodable and high-frequency words you want to assess on the user-friendly template.
• Print the student probes with shading either horizontal or vertical.
• Administer the probes in Google Sheets™. Check each incorrect response to automatically calculate a raw score and percentage.
• Scores and words read incorrectly are copied to the student summary.
• Percentage scores for each student are copied to the data sheet and median and average growth graphed!

✅ See complete directions within the preview for a full explanation of the process.

You may also be interested in this Letter Name and Sound Class Benchmark Assessment in Google Sheets!

⭐ If you found this resource helpful, please leave a review to earn credits toward future TeachShare purchases!