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?

Possibly related posts:

• If not now, when? Why we need #openbadges and #dmlbadges for lifelong learning RIGHT NOW.
• What did we learn during a ‘semester of learning’ on #openbadges over at P2PU.org?
• My Belbin results – Part 2
• My Belbin results – Part 1
• #openbadges – Learner Stories
• JOIN US! A semester of learning about Open Badges and assessment.
• Semester of Learning: Open Badges and assessment
• A brand-new campaign for Purpos/ed: #purposedassess
• What would a post-test era look like for our schools?
• How do you define attendance? [JISC Inform article]