This Excel tracker for CKLA Skills 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 where to go next based on the results!
Included in the zip file are a and then a filled in so you can play around with sorting, filtering, and all the functions without using your real data. I've also included a walking you through the tracker in more depth.
My hopes are that you can get some useful insights from these raw numbers and that this saves you some time to spend on your real life!