Even though our school system has a completely elctronic gradebook and attandance book online I still love to have a physical gradebook. You just never know what is going to happen or when the site will be down. I also like keeping a physical book because I can look at the “big picture” on one page rather than logging in and out of several different pages to see what is going on with a child. It’s nice to be able to recognize when a student’s grade is low because of outstanding absences, tardies, or just sheer laziness. I also like being able to grab the gradebook and go to a data meeting or a parent conference because most of the time there is not a computer accessible during those situations.
I decided to spend a little time with Excel and make my own. I liked a gradebook that I used when I first started teaching. It had 3 rows dedicated to each student. I used the top one to mark absences, the middle to code the absence (P for Parent Note, D for Doctor’s note, F for Fieldtrip, S for Suspension, R for Retract, O for Other), the bottom row was used for the score that the child received on an assignment that day. So, I patterend my gradebook to that theme. It is scaled to use over one entire quarter. It can be printed on standard 8.5 x 11″ paper or cardstock.
Here is the FREE PDF version of the gradebook: Gradebook 2012
I plan to print mine on a cardstock, punch holes in it, and place it in my 3-ringed binder that I have dedicated for each class.