Pupil names along the top, topics down the side and a set of cells in-between with Red Amber Green conditional formatting.
Once it’s finally unblocked at school (don’t get me started!!) I hope that the class and I can keep track of what they have revised and how happy they are with it in the run up to the GCSE exams in May. To make life easier, I’ve shared it with everyone so that they can all edit it without having to login. Fingers crossed nobody deletes things they shouldn’t!
Here’s a copy so you can see what I’m on about: http://spreadsheets.google.com/ccc?key=pC4ABCj9PtMrQ-bT2dSxMTA