Do you find it challenging to stay on top of what your students know and how well they know it in a standards-based classroom? They learn and grow at varied rates! I created an Excel spreadsheet that color formatted the cell based on the rubric/scale I entered: 1 (red), 2 (yellow), 3 (green) and 4 (blue). This really helped stay on top of formative data, and use this data to inform instruction, intervention, and enrichment.
I improved the spreadsheet to include one place to enter your students' names; the names automatically carry over to the other sheets (labeled at the bottom). There is one sheet for each substrand, which really helps focus instructional decisions on the needs of the students. This is a great tool when setting up guided reading groups focused on specific standards-based skills.
This may not replace your gradebook, as it does not retain all marks entered, only the most recent. This is intended to hold students' current level of performance, based on whatever assessments you use, either formative or summative.
Please note: this is created in MS Excel.