I’ve wished I knew how to use a spreadsheet for a couple years, but this summer I finally worked at it, in part because I was inspired by Alice Keeler, who is a spreadsheet wizard. If you’re looking for edtech know-how and inspiration, check out her blog, Teacher Tech, you won’t be disappointed.
The result of my early learning is a still developing but functioning grade book for Provincial standards. You can view it here, and if you would like to use it or keep a copy, click the “File” menu and select, “Make a Copy”. See the “Directions” tab at the bottom for a quick tour.
The basic layout looks like this:
Standards are listed on the left (y-axis) and Assignments are listed on top (x-axis). Of course not all assignments will assess all standards, but rather a handful of different standards. In other words, there will be many blanks on this spreadsheet. Right now I’m using a 1-5 numerical scale because it is formula friendly and I haven’t yet figured out how to use a symbol/letter scale that can also return some of the formula results. I have a lot of learning to do.
The interesting data are hidden in columns A-D and look like this:
As you can see by the headings in row 2, this sheet calculates a few valuable ways to look at each standard. Knowing how many times a standard was assessed (if at all) is important to guide your coverage, future instruction, and final assessment of a student’s abilities/knowledge.
I’m not sure if knowing a percentage is helpful or harmful–there is a lot of philosophy connected to assessment that I won’t unpack here. I included it for information and, honestly, because old habits die hard. I’ll be reflecting on it throughout the semester.
I’d be happy if you made suggestions for improvements or customizations, and I’d be thrilled if you took it for a test ride in a class. You don’t have to know how to make the improvements happen, simply share ideas/functions that you would find useful, and I’ll see what I can do (more learning for me!).