It’s a well-documented fact that I don’t like working with paper. Consequently, I track student attendance, homework and grades via spreadsheets. This year, instead of using Microsoft Excel, I’m using Numbers which comes with iWork ’08 for Mac OSX. Numbers has a pre-configured (US-centric) spreadsheet for educators. I’ve played about with it a bit to make it more relevant… 🙂
I’ve set up the spreadsheet in the following way:
The name of the class/set you teach.
This is like a standard gradebook – use /, O or L to indicate Present, Absent or Late.
Colour-coordinated using conditional formatting. Entering Y, N or L (i.e. Yes, No or Late) makes cells change colour to green, red or yellow respectively.
This is entered as a percentage, with less than 60% highlighted in red. Graphs give at-a-glance indication of class performance.
You can download the spreadsheet here:
(ZIP, 104kb – please note that this will not work in Microsoft Excel!)