Skip to main content

Y6 Teacher Assessment Level Calculator 2009

Overall rating 4 out of 54.3 (3 ratings)

Last updated 24 June 2011, created 22 June 2009, viewed 5,526

A spreadsheet using the weightings from QCA to help you calculate an overall NC level for the children using the strands in Mathematics, English and Science. Simply enter the pupils' names, your teacher assessment of them at each strand across each subject (NC level 2, 3, 4, 5 etc) and the spread More…sheet will calculate the overall level using the specified weightings. The 'divided' column shows the quotient of the calculation so you can double check that it is rounding correctly! Any feedback welcome.

Downloads and web links

  • Excel documentPupil assessment
    y6_teacher_assessment_level_calculator.xls (32kb, Excel document)
Need help viewing resource files?


Reviews (3)

Please provide a rating.

Add a review
Comment Report or delete comment Rating

Fantastic, so pleased it found it! Saved a lot of time..I will circulate to all my Y6 colleagues! Thanks

from ladykel2004, 24 June 2011
(report comment) 5 out of 5

Like it!. Very useful - ta very much

from tootler, 24 June 2010
(report comment) 5 out of 5

Teacher assessment. Thanks a lot! Made the job really quick and painless in a sea of endless jobs.....roll on the end of the year.

from Katehellen, 23 June 2009
(report comment) 3 out of 5
Report a problem with this resource