Tuesday 23 November 2010

Homework Grades using Google Docs

I currently grade my students homework using the following scale:


































GradeDescriptionTypical
1ExcellentCompleted with all working and marked
2GoodCompleted with working, but not marked
3SatisfactoryCompleted, without working
4Cause for ConcernApproximately 50% complete
5Intervention RequiredNot attempted


 

I have tried a number of different methods to record these grades on a daily basis:

  • On paper, with a class roll

  • On my laptop, walking around the room

  • On my iPhone, using a database app – HanDBase, StoreIt, Tap Forms


I have had great difficulty with these for a variety of reasons. This year, I started to call students out to my desk at the front of the room, so I could record it on my laptop. This worked quite well, but I am keen to be moving around the room. Google Docs has just released a new mobile version for creating and editing documents and I think that the spreadsheets fit the bill!



It's easiest to set up the file on the desktop version. I haven't set it up the way that I normally do, so that it's quick to record grades. Google Spreadsheets are set up for iPhone (and other mobiles) so that it is very easy to add a row. So, I have a column for each student (in my old excel markbook, I had a row for each student). It's easy to have a worksheet for HW grades and another one for marks. The other great benefit is that it's all backed up instantly and automatically all the time!

No comments:

Post a Comment