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:

Class spreadsheet for teachers

(ZIP, 104kb – please note that this will not work in Microsoft Excel!)

Reblog this post [with Zemanta]