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.
Fiendishlyclever 