As a teacher, I could NEVER find a simple, user-friendly version of a spreadsheet that allowed me to track students based on the various Common Core or NGSS standards. What I have created for teachers and admin alike is a simple Google Sheet where individual standards can be assessed and tracked. Duplicate the document for each student in your class.
I have also pre-coded numerous interactive functions, which include:
>Averages of individual standards across four quarters.
>Average performance on all standards per quarter.
>Cell color functions based on a simple 1-3 scale, with one being novice (red), two being intermediate (yellow), and three being mastery (green).
>Percentage of standards on red, yellow, or green.
This sample is for Kindergarten ELA only. Additional versions will include grade levels from K-12, all major CCSS subject domains and sub-domains, Next Generation Science Standards, C3 Social Studies Framework, and World Languages (Levels I-IV).
Additional functionalities will include summary data across all subjects and grade levels so the tracker can follow the student throughout multiple grade levels.
**Although the file is downloadable as Excel, best if used directly in Google Sheets.