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 version includes standards for ELA, writing, speaking and listening, math, science, and social science for grades K-2. Updates will include standards for world languages.
**Although the file is downloadable as Excel (.xlsx), it is best if used directly in Google Sheets.