Class spreadsheet for teachers
Welcome back!
Feel free to suggest topics for me to write about using the Suggestions? tab to the right or use Formspring to ask me random stuff. Check Doug's FAQ first!
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
Possibly related posts:
Categories: Education
Tags: assessment, attendance, gradebook, IWork, Microsoft Excel, Microsoft Office, Numbers, Spreadsheet











![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=4c9e7aaa-e388-4c36-8873-d6301f9633b5)

I've just come across some great markbooks for KS3 Maths in the UK, they are the 'Building a Picture' sheets on http://glosmaths.org/resources.php
Going to trial using these with our Y9s to really focus on which parts of the curriculum they need to work on in order to move through the levels.
[Translate this post]
Hi Doug, is there any way this could be used by those of us who don't have numbers or a mac? Cheers.
Mark
[Translate this post]
Glad to see that you have learned the power of Numbers! Really does make it all simple. Now, if I could get it to create an excel VBA thing that I have, I would be VERY happy!
[Translate this post]
Unbelievably good timing, Doug! As school starts next week, I was looking at revamping my marking system. This is well thought out! Thanks!
[Translate this post]
No problem – I like to share what I do for exactly this reason!
[Translate this post]
I've just come across some great markbooks for KS3 Maths in the UK, they are the 'Building a Picture' sheets on http://glosmaths.org/resources.php
Going to trial using these with our Y9s to really focus on which parts of the curriculum they need to work on in order to move through the levels.
[Translate this post]
I've just come across some great markbooks for KS3 Maths in the UK, they are the 'Building a Picture' sheets on http://glosmaths.org/resources.php
Going to trial using these with our Y9s to really focus on which parts of the curriculum they need to work on in order to move through the levels.
[Translate this post]
Hi Doug, is there any way this could be used by those of us who don't have numbers or a mac? Cheers.
Mark
[Translate this post]
Hi Doug, is there any way this could be used by those of us who don't have numbers or a mac? Cheers.
Mark
[Translate this post]
Glad to see that you have learned the power of Numbers! Really does make it all simple. Now, if I could get it to create an excel VBA thing that I have, I would be VERY happy!
[Translate this post]
Glad to see that you have learned the power of Numbers! Really does make it all simple. Now, if I could get it to create an excel VBA thing that I have, I would be VERY happy!
[Translate this post]
Unbelievably good timing, Doug! As school starts next week, I was looking at revamping my marking system. This is well thought out! Thanks!
[Translate this post]
Unbelievably good timing, Doug! As school starts next week, I was looking at revamping my marking system. This is well thought out! Thanks!
[Translate this post]
No problem – I like to share what I do for exactly this reason!
[Translate this post]
No problem – I like to share what I do for exactly this reason!
[Translate this post]
Unbelievably good timing, Doug! As school starts next week, I was looking at revamping my marking system. This is well thought out! Thanks!
[Translate this post]
No problem – I like to share what I do for exactly this reason!
[Translate this post]
[...] – and can’t search and organize it. If you’re a teacher, make your markbook and attendance registers digital. Plan things using Google Calendar. These things might take some time to set up, but will pay [...]
[Translate this post]
[...] Class spreadsheet for teachers at dougbelshaw.com [...]
[Translate this post]