[Grade 1] CKLA Skills Assessment Tracker (Unit 5)
- Google Sheets™
- Excel Spreadsheets
Description
This *Google Sheets* spreadsheet helps you enter, score, and analyze results from the Grade 1, Unit 5 assessments for CKLA Skills. This tracker works for both first edition and second edition of Skills. (If you're needing an Excel version, please drop me a line and I'll prioritize it!)
The Unit 5 assessments are Word Recognition (spelling alternatives 'tch', 'wr', 've', 'ge', and 'g') and Grammar (nouns, verbs, sentence expansion with adjectives and locations, noun endings, and verb endings). For each of these assessments, you'll get:
- A tracker, on which you place an X for any missed item, and
- Reorganized results, which automatically compiles lists of students who missed any items, for easy identification.
All you need to do is enter student names and student answers. Then, you'll also have:
- A whole-class summary page, which displays everyone's scores along with color-coded mastery levels, and
- A dashboard, which condenses the results even further, to the most essential: average scores, average percent correct, total number of students in mastery, near mastery, and remediation levels, and two cute little pie graphs.
Wait, that's not all! Act now and you'll also receive a useful
- Individual student report, a printable one-pager that describes the tests and shows the student's scores on each one. These one-pagers are super helpful for communicating with parents or other staff or for placing in a portfolio.
**See these five features in action in the product preview above. After you enter names and scores, everything else is automatic - calculations, lists, color-coding, drop-down menus, graphs, you name it!**
But I didn't stop there! For the first time, I've included some specific guidance for the Word Recognition (phonics skills) results in a tab titled Reteaching Plans. There are some great resources in the Assessment & Remediation Guide, and I've organized them into a couple different progressions of reteaching or remediation lesson outlines. Leave me a note below if you enjoyed this new feature!
Finally, you'll also have access to a sample tracker, a copy of this tracker with made-up student names and scores, for viewing a completed document and/or for playing around with without fear of messing up your own tracker (just make a copy in order to edit). You'll find the link to this sample at the top of the first tab, About this Tracker.
Please enjoy and please do drop me a line via the Q&A tab, via a review, or via email if you have questions, requests, or feedback. I love it all! And, FYI, I am working on upgrading all the past trackers and maybe even making them interconnected in Sheets, with an ongoing summary of each student's results across the units. Stay tuned!