This is a project that Terry Brock (Maungatapere School, Whangarei) started and has been working on for several years. I have made my own version using Excel 2007 and continue to work with Terry to improve and add to this..
It basically replaces the blue assessment book (NZ) that most teachers use.
This is kind of a SMS but not online. It allows you to personalise your assesments. using this there is no waiting for yoru SMS company to make up a tempale you can do it all your self.
This MS Excel sheet is aimed at a teachers day to day assessment and management. It uses hyperlinks between sheets to make excel act a bit like a website.
It includes automatic colour coding of data so that the teacher is easily able to see patterns in the results.
This example is just some basic pages to start with but the concept can be taken much further. There is a "How To?' page in the excel file but if you want to do anything else or find out how I did it just Google it and you will find a way to do it.
Excel 2007 Version Excel 2003 Version (some features do not work)
Screen Shots.
Click on a thumbnail to view a larger image.
Hit Counter 197