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


  • y6_teacher_assessment_level_calculator.xls

About this resource


Created: Jun 22, 2009

Updated: Sep 9, 2015

Report a problem

3 Reviews

  • 5

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

  • 5
    user avatarTootler7 years agoreport

    Like it. Very useful - ta very much

  • 3
    user avatarKatehellen8 years agoreport

    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.