Key Objectives Assessment Grids

Just as term ended, Tim Clarke (@tim_jumpclarke) sent me an excel spreadsheet he had created to record assessment against the key objectives for Maths and Writing and Reading.

mathskosheetAfter a few emails and a bit of tweaking, we’re releasing what will hopefully be a useful tool for schools choosing to use the Key Objectives approach. For each subject there is a spreadsheet covering all year groups (although it would, of course, be possible to combine sheets from different files to put, say all the Y5 pages into one document).

For each subject and year group, there is a list of objectives and a grid into which the numbers 1, 2 or 3 can be entered (representing, say ‘Working Towards’, ‘Achieved’ and ‘Exceeded’, or whatever such terminology as you choose to use). The cells change colour, and importantly the summary at the foot of the column does too, to represent the number of points scored. The percentage values for these can be set for your school. (The default is that 50% of points awarded turns orange; 75% turns green)

The files can be downloaded from here:

NC 2014 Mathematics key objectives markbook

NC 2014 Writing key objectives markbook

NC 2014 Reading Key objectives markbook

(The booklets of key objectives are available on this page)

For those schools considering a mastery approach to mathematics, I have also created an adapted version into which the value 2 is deemed to be “mastered”. The totals at the bottom of each column in this case calculate the number of objectives which have been deemed to be mastered, changing the colour according to the percentage of objectives mastered (rather than just by an average of point scores). This version can also be downloaded:

NC 2014 Maths Mastery objectives markbook

Tagged: , , , ,

9 thoughts on “Key Objectives Assessment Grids

  1. cazzypot2013 27 July 2014 at 12:05 am Reply

    Reblogged this on The Echo Chamber.

  2. 90maz 27 July 2014 at 11:26 am Reply

    Reblogged this on speciallyteaching.

  3. Matt Hickey (@mjh131076) 27 July 2014 at 4:39 pm Reply

    A great resource that will be invaluable during the transition to life without levels. I have created something similar (a resource which I am happy to share if requested) but doesn’t opt for the best fit approach.

    In the screenshot provided, Puff Daddy would be deemed to be meeting age related expectations as he has achieved over 50% of the points available. The screenshot also shows there are 3 key objectives that he has not met. This is where I had an issue with what I had first created and asked myself a question, “Can a child be at age related expectation if there are key objectives they haven’t met?”

    A good level of development in EYFS requires all key objectives to be met in the 12 ‘main’ areas. A child can miss out on GLD but still end up with a higher total score. This is the approach I went for. The formula I designed required at least a 2 in key areas for age related expectation to be met.

    I also added in a termly overview page to show progression over the year for the child and the cohort / class.

    I would be really interested in people’s views and I want to stress that this is not a criticism of the resource. I am happy to share or help develop things if people are interested in collaboration.


    • Michael Tidd 27 July 2014 at 6:58 pm Reply

      Hello Matt,
      I’ve also been interested in the approach that requires students to ‘master’ knowledge, hence the separate maths document. I’d be very interested to see what you’ve come up with.

    • Matt Hudson 28 July 2014 at 9:20 am Reply

      Hi Matt,
      I’d also be interested in seeing what you have done.

  4. Becky Roberts 28 July 2014 at 9:45 am Reply

    Hi Matt
    I agree with your comments about GLD and would be interested in working together on it. Are you willing to share

  5. nialiax 29 July 2014 at 9:26 pm Reply

    Reblogged this on educatingthoughts and commented:
    Excellent resources as always @ramblingsofateacher

  6. […] Michael Tidd and Tim Clarke, heads of Primary Schools in Nottingham and Hampshire, have been developing spreadsheets to record assessment against the key objectives for Maths and Writing and Reading. […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: