Elementary phonics professional documents for Microsoft Excel

[Grade 1] CKLA Beginning-of-Year Assessment Tracker (Unit 1)

Created by

So many items here! First of all, (1) a tracker for entering assessment scores for CKLA Skills, Grade 1, Unit 1. (2) Within that tracker, I set up automatic calculations to figure out the group assignments. This was one of the most confusing parts of the assessment analysis, I found! But it's all automatic now. I added two "wild card" labels for the combinations of scores CKLA did not account for.(3) The tracker also contains several tabs for Pseudoword Scoring Sheet analysis. This level of anal

Subjects:

Grades:

1st

Types:

CCSS:

, RF.1.2

, RF.1.2b

[Grade 3] CKLA Word Reading in Isolation Tracker (Unit 1)

Created by

This is a tracker that compiles and analyzes data from the CKLA Skills Grade 3, Unit 1 Word Reading in Isolation Assessment. This assessment is part of the whole beginning-of-year battery of tests (see the entire Unit 1 tracker here), but it requires such detailed analysis, I had to make it its own spreadsheet.All you need to do is enter an X for each sound the student reads incorrectly (just like you do on paper), and 4 full pages of analysis will spit out: 1 page telling you what consonant sou

Subjects:

Grades:

3rd

Types:

CCSS:

RF.3.3

[Grade 1] CKLA Skills Assessment Tracker (Unit 2)

Created by

Grammar, Phonics, Reading

This Excel tracker for CKLA Skills Grade 1 Unit 2 gathers and synthesizes all the data from the three end-of-unit assessments. Three parts that help you make sense of the scores:Tracker will color-code the scores into remediation, near mastery, and mastery.Dashboard will show you pie-chart percentages of the whole class on all three tests.Student Report is a one-page snapshot of one student's scores at a time. Included in the zip file are a blank tracker and then a sample with made-up scores all

Subjects:

Grades:

1st

Types:

CCSS:

, RF.1.3b

, RF.1.4a

, L.1.1b

[Grade 2 BUNDLE] CKLA Skills Assessment Trackers for Unit 1

Created by

Two very useful spreadsheets to make your life easier!:(1) Unit 1 Assessment Tracker for CKLA Skills, Grade 2(2) Unit 1 Word Reading in Isolation Tracker for CKLA Skills, Grade 2The Assessment Tracker synthesizes the results of each student's 1-4 independent reading comprehension tests plus his or her word reading score to give you an automatic group placement of 1A, 1B, 1C (above level), 2A, 2B, 2C (on level), or 3A, 3B, 3C (below level).The Word Reading in Isolation Tracker helps you track stu

Subjects:

Grades:

2nd

Types:

CCSS:

RL.2.1

, RF.2.3

[Grade 1] CKLA Skills UNIT 4 ASSESSMENT BUNDLE!

Created by

Grammar, Phonics, Reading

*TWO* Excel trackers for Grade 1 CKLA Skills assessments in Unit 4: ~ Mid-Year/End-of-Unit-4 Assessments~ Word Reading in Isolation AssessmentIf you've ever used one of my trackers before, know that I just keep getting better and better! ;) I've learned so many cool tricks to move from a basic color-coded spreadsheet that counts totals to an interactive graph-creating, report-generating machine! Up next: Unit 5, and then I'll go back and improve all the past ones!Note: As mentioned in the WRIA

Subjects:

Grades:

1st

Types:

CCSS:

RI.1.1

, L.1.1c

, L.1.1e

[Grade 1] CKLA Skills Assessment Tracker (Unit 3)

Created by

This Excel tracker for CKLA Skills Grade 1 Unit 3 gathers and synthesizes all the data from the two end-of-unit assessments (plus a spelling test).Three parts that help you make sense of the scores:Tracker will color-code the scores into remediation, near mastery, and mastery.Dashboard will show you pie-chart percentages of the whole class on all three tests.Student Report is a one-page snapshot of one student's scores at a time.Plus, I've created general Remediation Plans for some ideas on wher

Subjects:

Grades:

1st

Types:

CCSS:

, RF.1.3b

, RF.1.4a

, L.1.2d

[Grade 3] CKLA Skills Beginning-of-Year Assessment Tracker (Unit 1)

Created by

This is an Excel spreadsheet designed to help you collect students' scores from Grade 3, Unit 1 Skills assessments in one place - but then also to analyze the scores and give you an automatic group placement. Word Reading in Isolation tracker for Unit 1 here! (It automatically analyzes each of the sounds missed.)

Subjects:

Grades:

3rd

Types:

CCSS:

RL.3.1

, RF.3.3

[Grade 3] CKLA Word Reading in Isolation Tracker (Unit 6)

Created by

This is a tracker for the Unit 6 Word Reading in Isolation Assessment for Grade 3 CKLA. This assessment is part of the Middle-of-Year battery of assessments in the Viking Age unit and starts with the words twitch, cherry, squid.Looking for Grade 3 Unit 6 tracker for *all* assessments? Go here.Looking for Grade 3 Unit 1 [cloud, hook, joint] Word Reading? Go here.Looking for Grade 3 Unit 11 [steady, asphalt, oxygen] Word Reading? Go here.*** I have included here two versions of the tracker: one fo

Subjects:

Phonics, Reading

Grades:

3rd

Types:

CCSS:

RF.3.3

, RF.3.3b

, RF.3.3c

, RF.3.3d

[Grades 3, 4, 5] CKLA Word Reading in Isolation Assessment Tracker

Created by

This is an automatic tracker for the 'steady, asphalt, oxygen' Word Reading in Isolation assessment that occurs in beginning- and end-of-year grades 4 and 5 Core Knowledge Language Arts materials and end-of-year grade 3. (For the beginning-of-the-year grade 3 Word Reading test, go here. For the full G4 U1 tracker, go here. For the full G5 U1 tracker, go here. And for the full G3 U1 tracker, go here!)This works with either CKLA edition 1 or 2 - the tests remained the same.Do you find that the har

Subjects:

Grades:

3rd - 5th

Types:

Phonics, Reading, Reading Strategies

CCSS:

RF.3.3

, RF.4.3

, RF.4.3a

, RF.5.3

, RF.5.3a

UFLI Progress Monitoring Assessment All Lessons 1-128 Excel

Created by

Pippas Parents

Use this tool to track your students and their progress in UFLI. This will show each student's overall average across lessons, grade level average, and their total percent correct on each lesson.Directions:Add students to summary tab (their names will then populate on all lesson tabs)Enter scores on lessons tabsUse the individual tab for showcasing one student at a time. Enter the student's first and last name where it says "example student" and their scores will show as well as a grade level av

Subjects:

Grades:

K - 3rd

Types:

[Grade 4] CKLA Beginning-of-Year Assessment Tracker (Unit 1)

Created by

*Major update, September 2021: 30 students, greater functionality, AND an individual student report page!*This is an Excel workbook that will help you track and analyze the results of CKLA Grade 4, Unit 1 assessments. The beginning-of-year tests include 3 reading comprehension selections, one grammar and one morphology assessment, an extensive 65-word Word Reading in Isolation test (see my separate tracker for this in detail!), plus a fluency passage. Whew!In this zip file are two PDFs (the asse

Subjects:

Grades:

4th

Types:

CCSS:

RL.4.1

, RI.4.1

, RF.4.3

, L.4.3

, L.4.4

...

[Grade 2] CKLA Skills Assessment Tracker (Unit 3)

Created by

This is an Excel or Google Sheets workbook for tracking the assessment results from Grade 2 CKLA Skills, Unit 3.*MAJOR UPDATE ALERT!!!* I'm slowly but surely updating old and new trackers to have all the same features. Added in version 2.0 of this tracker:Excel AND Google Sheets versions!Rather than a single file download, you'll get a PDF with a link to my Google Drive folder, where you can download the Excel file or make a copy of the Google Sheets doc. I'm hoping this eliminates any problems

Subjects:

Grades:

2nd

Types:

CCSS:

RL.2.1

, RF.2.3

, L.2.3

[Kindergarten] CKLA Skills Assessment Tracker (Unit 1)

Created by

English Language Arts, Handwriting, Phonics

This is an Excel workbook for tracking the assessment results from Kindergarten CKLA Skills, Unit 1. There are five assessments in Unit 1, and this tracker helps you collect the student scores for all five AND will help with analysis - color-coding if above or below a certain score, adding up correct responses, and pulling all results together into a summary sheet. I spend many, many hours researching and assembling and fine-tuning these trackers, so I would very much appreciate a quick review l

Subjects:

Grades:

K

Types:

CCSS:

RF.K.1

, RF.K.2

Also included in: [Kindergarten Bundle] CKLA Skills Assessment Trackers for All 10 Units!

[Grade 3] CKLA Mid-Year Assessment Tracker (Unit 6)

Created by

Here is an Excel spreadsheet for collecting and analyzing the results of the Mid-Year Assessment for Grade 3 CKLA - Unit 6. This unit has four tests - Silent Reading, Grammar, Morphology, and Word Reading in Isolation - that will give you a snapshot of student skills at the half-year. This tracker does color-coding, rearranging based on skills, and graphs, all automatic. A fun feature is the Student Report, which gives you a one-page printable view of how each student performed on all the tests.

Subjects:

Grades:

3rd

Types:

Mairghread's Marvellous Mix

CCSS:

RL.3.1

, RL.3.2

, RI.3.1

, RI.3.2

, RF.3.3

...

Customizable Labels for Wilson Fundations Level 2

Created by

The Wilson Fundations Level 2 kit is an incredible resource with an OVERWHELMING number of small items in every kit! The kits are expensive and inevitably a word card will be borrowed by a teacher, fall behind a bookshelf, or just need to be put away in the right spot for yourself or colleagues next year! Maybe you even have a shared kit among multiple teachers in your building and you need to keep the inventory and items well labelled so nothing goes to waste! With this file, you can customi

Subjects:

Teacher Manuals, Professional Documents

Grades:

2nd

Types:

[Grade 1] CKLA Skills Assessment Tracker (Unit 4 + Mid-Year)

Created by

Grammar, Phonics, Reading

This Excel spreadsheet helps you enter, score, and analyze results from the Grade 1, Unit 4 assessments for CKLA Skills (both the regular end-of-unit tests and the mid-year benchmarks). This tracker works for both first edition and second edition of Skills. The Unit 4 assessments are Dictation and Grammar. Students spell words you dictate, demonstrating their ability to match sounds and spellings for r-controlled vowels, and they identify nouns, verbs, and contractions in a written test. I've se

Subjects:

Grades:

1st

Types:

CCSS:

RI.1.1

, L.1.1b

, L.1.1c

, L.1.1e

Also included in: [Grade 1] CKLA Skills *UNIT 4 ASSESSMENT BUNDLE*!

[Grade 1] CKLA Skills End-of-Year Assessment Tracker (Unit 7)

Created by

The CKLA Skills program designed these Unit 7 end-of-year assessments in a flowchart fashion – that is, fewer and fewer students take each test. Ostensibly, this is to minimize unnecessary testing and target those who really need further testing. My teachers and I have found, however, that there are many factors that make up “good” or “on-grade-level” reading, and that one or even two tests are not sufficient to make these end-of-year judgments.Therefore, we make the time to administer all three

Subjects:

Grades:

1st

Types:

CCSS:

, RL.1.10

, RF.1.2b

, RF.1.2d

...

[Grade 5] CKLA Beginning-of-Year Assessment Tracker (Unit 1)

Created by

This is an Excel workbook that will help you track and analyze the results of CKLA Grade 5, Unit 1 assessments. The beginning-of-year tests include 3 reading comprehension selections, one grammar and one morphology assessment, an extensive 65-word Word Reading in Isolation test (see my separate tracker for this in detail!), plus a fluency passage. Whew! After you get through the 3+ days of assessment at the start of the year, use this document to help you keep track of all 5 test results, get so

Subjects:

Grades:

5th

Types:

CCSS:

RL.5.1

, RL.5.2

, RL.5.10

, RI.5.1

, RI.5.2

...

[Grade 2] CKLA Skills Assessment Tracker (Unit 2)

Created by

This is an Excel workbook for tracking the assessment results from Grade 2 CKLA Skills, Unit 2. There are three end-of-unit assessments in Unit 2, and this tracker helps you collect the student scores for all three AND will help with analysis - color-coding if above or below a certain score, adding up correct responses, converting scores to labels of poor, good, or excellent (which match Unit 3, for easy comparison), and pulling all results together into a summary sheet. And there are graphs! I

Subjects:

Grades:

2nd

Types:

CCSS:

RL.2.1

, RF.2.3a

, RF.2.3d

, RF.2.3e

, RF.2.4a

...

[Kindergarten] CKLA Skills Assessment Tracker (Unit 8)

Created by

English Language Arts, Phonics, Reading

***UPDATE! Now in Google Sheets format too!*** The link to the Sheets version is included in the Excel workbook, on the first tab, titled GOOGLE SHEETS LINK. This version also made some upgrades from the original Excel setup. Enjoy!This Excel document helps you collect and analyze the results of CKLA Skills assessments for Kindergarten, Unit 8. This is a huge assessment unit - there are up to six tests! As I mention in the notes, this unit is a sort of "soft closing" to the year - if students do

Subjects:

Grades:

K

Types:

Mairghread's Marvellous Mix

CCSS:

RF.K.3

, RF.K.3a

, RF.K.3b

, RF.K.3c

, RF.K.4

Also included in: [Kindergarten Bundle] CKLA Skills Assessment Trackers for All 10 Units!

Customizable Labels for Wilson Fundations Level 1 Kit

Created by

The Wilson Fundations Level 1 kit is an incredible resource with an OVERWHELMING number of small items in every kit! The kits are expensive and inevitably a word card will be borrowed by a teacher, fall behind a bookshelf, or just need to be put away in the right spot for yourself or colleagues next year!Maybe you even have a shared kit among multiple teachers in your building and you need to keep the inventory and items well labelled so nothing goes to waste!With this file, you can customize yo

Subjects:

EFL - ESL - ELD, English Language Arts, Phonics

Grades:

1st

Types:

Teacher Manuals, Professional Documents

[Grade 1] CKLA Skills Word Reading in Isolation Assessment Tracker (Unit 4)

Created by

This is an Excel tracker to help calculate and analyze results of the Grade 1 Unit 4 Word Reading in Isolation assessment only for CKLA Skills. Note that there are four assessments at the end of the Unit 4 and my full tracker for ALL of them is here. As part of the Mid-Year check for mastery, students sit with a teacher one-on-one to read a list of 60 words. These words are either one-syllable or two-syllable and contain almost every sound-spelling learned to date. (This is therefore also a usef

Subjects:

Phonics

Grades:

1st

Types:

Phonics, Reading, Reading Strategies

CCSS:

RF.1.3

Also included in: [Grade 1] CKLA Skills *UNIT 4 ASSESSMENT BUNDLE*!

UFLI Progress Monitoring Tracker Lessons 1-34

Created by

Pippas Parents

Use this tool to track your students and their progress in UFLI. This will show each student's overall average across lessons, grade level average, and their total percent correct on each lesson.Directions:Add students to summary tab (their names will then populate on all lesson tabs)Enter scores on lessons tabsUse the individual tab for showcasing one student at a time. Enter the student's first and last name where it says "example student" and their scores will show as well as a grade level av

Subjects:

Grades:

K - 3rd

Types: