dougbelshaw.com/blog

Welcome! If you're new here, please have a look around and consider subscribing via RSS or email for free updates (look to your left). You can contact me here! and/or buy into my new (e-)book - #uppingyourgame: an educator's guide to productivity

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

Related articles by Zemanta

• EditGrid’s Handy Excel Plugin for Spreadsheet Heaven
• Google Docs Instant Form
• Apple iWork and Microsoft Office: Can they work together?