I just wanted to show what my SBG Google-spreadsheets grade-book looks like 3/4 the way through a semester. Thanks to Julie’s (@jreulbach) trick, the spreadsheet colors itself in when I enter a grade. A big thank-you to Jim Pai (@paimath) for making brainstorming sessions and helping me to get this worked out over the summer.
Before today, if I had a quiz which covered several standards that were spread in very different parts of my spreadsheet, then I’d spend most my time, while plugging in grades, just scrolling left and right along the spreadsheet. Today I had the bright idea to shrink all the columns between the two points so that I can type in everyone’s grades without any scrolling (see below). Yay Google & spreadsheets.
For this last image, I’ve re-sized all the columns to show as many grades as possible in a single view for a single class. Wow, that’s a lot more grades than I wrote down last year, but I think that’s a good thing.
Thanks to Jasmine for reminding me to show you all this: Students have their own spreadsheet they can check which automatically pulls from my spreadsheet. Here’s what their spreadsheet looks like.