Assessment spreadsheet for KS1 and 2 ( can be adapted for KS3)

I've taken Mark Dorling's progression pathway document and split it up into a series of individual statements then put the lot on a spreadsheet.

All you need do is post your pupils onto the first tab, it should copy them to the other six tabs (one for each area) then you stick a 1 in each cell as the pupils demonstate that skill. The spreadsheet will show which colour they have achieved in each area all on the first page and will average it out to give an overall computing level. I'm not sure if the average is useful, I've included it because we want to keep a record of overall progression.

Note that I have weighted the colours such that each one is more important than the last by a factor of about 1.5. My thinking is that a child in year 5 who is working on orange shouldn't be too affected if they haven't proved to have done everything in pink. Likewise, if they manage an skill in blue it should count overall as more important than the skills at orange level. It's trivially easy for you to change the formula to remove the weighting from cells in rows c to h in the overal scores page.

I have not weighted the different areas of the curriculum. I'm thinking that I might weight hardware as maybe 0.7 and IT skills as 1.5 (with everything else rated as 1) to reflect the relative number of "I can" type statements in these areas. This only affects the average computing score anyway. Again it's easy enough to add the weighting in to the formula in rows B.

Anyway I hope, I haven't made any errors and that other people find this useful too