Gradebook document with conditional formatting
When I was teaching Math and Science in a 5th grade bilingual classroom at Rivera Elementary, I wanted to create a document where I could see at glance the progress of my students in both content areas. I wanted it to be a live document where data would be added as soon as assessments where administered and graded. I also wanted it to look sort of like a heat map, where I could immediately identify trends by just looking at the colors (basically a grade book on steroids). The data I was going to collect was:
After a couple of attempts, I came up with a Google sheets document that I'd like to share with you. I have to say that one of the most useful features I enjoyed from it, were the colors. They made it so easy for me to see the progress (or lack of) of all my students just by looking at their colors horizontally, therefore quickly identifying my tier 1, tier 2, and tier 3 students. Then, I would easily know who were going to be in my next small group, success time group, and after school tutoring group.
This document that I'm sharing now was the latest one I used, and I'm sure there is room for tweaking/improvement. Please feel free to make a copy for yourself and adapt it to your own particular needs. The coloring part is done with google sheet's conditional formatting where you basically establish numerical ranges for the different colors you want to be displayed. If you have never tried this, and need help please let me know directly or leave a comment below and I will be more than happy to assist you.
Here is the document (I left it with all of last year's data so that you can see what it would look like at the end of the year and how the colors help you identifying things fast).
Jesús López De Nava
- 4th grade STAAR score
- BOY benchmark
- Imagine Math screeners
- Report card assessments
- Math zone asessments
- Math SIM
- Math STAAR
- and...
After a couple of attempts, I came up with a Google sheets document that I'd like to share with you. I have to say that one of the most useful features I enjoyed from it, were the colors. They made it so easy for me to see the progress (or lack of) of all my students just by looking at their colors horizontally, therefore quickly identifying my tier 1, tier 2, and tier 3 students. Then, I would easily know who were going to be in my next small group, success time group, and after school tutoring group.
This document that I'm sharing now was the latest one I used, and I'm sure there is room for tweaking/improvement. Please feel free to make a copy for yourself and adapt it to your own particular needs. The coloring part is done with google sheet's conditional formatting where you basically establish numerical ranges for the different colors you want to be displayed. If you have never tried this, and need help please let me know directly or leave a comment below and I will be more than happy to assist you.
Here is the document (I left it with all of last year's data so that you can see what it would look like at the end of the year and how the colors help you identifying things fast).
Jesús López De Nava
BE/ESL Instructional Coach/Facilitator
Denton ISD
Comments
Post a Comment