RSE & PSHE: Assessment spreadsheet (26/27 preview)

Please note: This document is a preview of the 2026/2027 scheme. As it is a working document, updates are likely to be made.

RSE & PSHE assessment: The essential progress tracker

This clear, downloadable spreadsheet allows teachers to record RSE & PSHE assessments for each lesson plan in Kapow Primary’s RSE & PSHE scheme of work, covering Year 1 to Year 6.

With details of every lesson’s learning objectives and level descriptors, the document provides the ideal place to record pupils’ formative assessment.

How do I use this RSE & PSHE assessment spreadsheet?

For each lesson, review the ‘Assessing Pupils Progress’ statements in the spreadsheet, then indicate in the relevant cells whether each pupil is working towards (WT), secure understanding (SU) or greater depth (GD).

The spreadsheet will then calculate the percentage of lessons in which the pupil has achieved each grading and allow you to analyse whole-class trends.

Who is this RSE & PSHE assessment spreadsheet useful for?

For teachers:

Use the spreadsheet to quickly track which pupils may need extra challenges and which might require additional support.
Determine each pupil’s attainment using the statements in the ‘Assessing pupils’ progress’ column for each lesson.
If required, adapt future lessons to address gaps in knowledge or correct misconceptions.

For subject leaders:

These assessment sheets can quickly form the basis of your analysis of RSE & PSHE learning within your school.
Quickly identify gaps in knowledge or ongoing trends and use this insight to determine what staff CPD may be needed, where extra resources might be required, or simply to recognise where your school excels.
This information can also inform your action plan for RSE & PSHE.
Should Ofsted visit and want to discuss RSE & PSHE at your school or conduct a RSE & PSHE deep dive, this document will ensure you have the facts you need at your fingertips.