SATS analysis with Google Docs

I was conducting a question level analysis of our national curriculum tests, looking for topics where there were difficulties (and comparing how pupils with ASD performed in how science works questions).

Having devised a template on Excel I proceeded to enter data for my pupils.  Having completed the task it dawned on me that there would have been an easier way.

Once I had created the spreadsheet I could have used Google Forms and had the pupils enter their own data into the spreadsheet.  This would save considerable time with a large mainstream class, it is also a good way to collate other examination marks or even comments written on work.

Maybe next time I’ll remember to use Google Docs.