Class spreadsheet for teachers at dougbelshaw.com

Welcome! If you're new here, you may want to sign up for email updates or subscribe to the RSS feed for all my posts. Alternatively, browse or subscribe by category (look to your right). Thanks for visiting!

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:

Title

The name of the class/set you teach.

Attendance

This is like a standard gradebook - use /, O or L to indicate Present, Absent or Late.

Homework

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.

Assessment

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!)

dougbelshaw.com