CAS Community   >   Resources   >  

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

A spreadsheet that allows you to keep track of which level yyour pupils are at in all aspects of the computing curriculum

Theresa Knott

Created by Theresa Knott
last edited Sep 24 2014 by Theresa Knott

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.

Downloaded 4526 times.


This resource has attached files: to access these files, please tick the box below to assent to the license terms
License: The resources on CAS website are under Creative Commons Attribution-Share Alike 3.0 licence unless otherwise specified by the resource creators.

You must confirm that you have read and agree the licence's ToS before you can download the attachments of this resource.

I have read the licence agreement of this resource and agree to abide by its terms and conditions.

Feedback and Comments

Available when logged in (join via the front page, for free):
  • View 36 comments on this resource.
  • View resource history, links to related resources.
  • Leave feedback for the author(s), or help by editing the resource.

© 2021 BCS, The Chartered Institute for IT Registered charity: No. 292786
Using the websiteDisclaimer of liabilityCookies policyPrivacy notice