Educational leadership & learning

Updated “Assessment Journey” Excel spreadsheets

I have updated the Information page on the Excel spreadsheets that I created to share with colleagues in the summer term 2015. Many thanks again to Andy Higgs (@andrewbhiggs) who kindly shared a series of spreadsheets he and his staff had created to track all the NC objectives.

In our school we have been discussing whether by only tracking NAHT KPIs we are in danger of teaching what we need to assess, when we must ensure we help our pupils learn the full curriculum. However how manageable is it to assess all of the objectives? Staff are trying to assess 2 or 3 each week based on what they have taught and the pupils learnt. It also raised the question of whether we can confidently say a pupil has achieved end of year expectations if we only track the NAHT KPIs? How much detail do we need? We are having our first PAMs (Pupil Achievement Meetings) in a few weeks time, which should give us some early indications.

The new slightly updated versions which we are trialling this year (in Y1-Y3) are linked to this blog. The main elements are:

  • Updated information page which gives clearer definition of when to give a 1 (Working towards / Apprentice), a 2 (Mastery of End of Year Expectations) or a 3 (Deep learning Expert)
  • A suggested progression for All and Most Able pupils, and where they should be to on track for end of year expectations at different points in the year
  • How our class teachers will use the “Assessment Journeys”, numerical targets to aim for, but not be enslaved to and to give an overall ‘domain’ Teacher Assessment judgement in February and July
  • On each sheet (Reading, Writing and Maths) with have added pupil groups columns to allow us to quickly filter for specific groups
  • The NAHT KPIs (Key Performance Indicators) are identified in red font. As well as an overall total / percentage for all objectives, the sheets are also set up to calculate a percentage of the NAHT KPIs
  • Hampshire LA suggested Phases for Key Objectives to be taught / learnt. Phase 1 by November, Phase 2 by February and Phase 3 by May

Y1 NC Assessment Journey

Y2 NC Assessment Journey

Y3 NC Assessment Journey

Y4 NC Assessment Journey

Y5 NC Assessment Journey

Y6 NC Assessment Journey

Our aim is still that these “Assessment Journey” spreadsheets should be a valuable and useful tool for class teachers, a support to the professional discussions about pupils’ learning and provide sufficient detail at whole school level to evidence our judgements (alongside books and pupil comments). Crucially I think it’s not about which tracking system we use, but the way it is used to support (not lead) teaching, learning and assessment.


Cornerstone CE Primary, Hampshire


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Tag Cloud

%d bloggers like this: