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

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 tests to all students. We use the combination of results to gather a more accurate profile of each reader. I highly recommend taking this approach, and, if you do, here are spreadsheets that will calculate almost everything automatically! (You can still use the tracker if you don't do all three tests for all students. Just use tab #1.)

All you need to do is enter student names and their scores, and most of the rest will fill in: an overall label of “intensive remediation,” “below grade level,” “on grade level,” or “above grade level”; a dashboard with circle graphs showing proficiency; a grouping chart with students listed by label; and a summary sheet on which you can select a student and have his or her information populate.

I very much want to help you navigate these documents. My ultimate goal is to make your life easier! It's difficult to anticipate the various ways you might need to use this, so please, please reach out to me with any questions. As I've said, I made most calculations automatic, but absolutely let me know if something doesn't work, and feel free to ask me how to eliminate or add rows, for example, or any other ways to customize this to your needs. See the “sample” document first to see a completed version, and then have at the blank one!