I'm so excited to share this lifelong tool with you! Whether you're moving toward standards based grading or just want to better understand what your students have learned, this will save you so much time! This is a spreadsheet that will allow you to enter your roster(s), how many items are on your assessment, enter the point value of each item, and categorize each item. After you grade the assessment, enter your student data. The spreadsheet will give you a wealth of information including:
A table of grades: how each student did on the assessment overall AND how each student did on each category (e.g. concept, standard, proficiency level, etc.).
A sortable table: sort your students by their assessment data. This is great for creating targeted reteaching groups!
A sheet for entering retake grades: Suppose a student only needs to retake one category on a particular assessment. Easily update just that category and the sheet will give you their updated assessment grade.
Best of all: Purchase this once and use it on all future assessments. This is an especially great tool for PLC's!