1. Home
  2. Assessment
  3. Primary Assessment
  4. Config>Assessment
  5. How to administer the Key Stage 2 Teacher Assessments
  1. Home
  2. Assessment
  3. Primary Assessment
  4. Modules>Assessment
  5. Assessment Sheets List
  6. How to administer the Key Stage 2 Teacher Assessments

How to administer the Key Stage 2 Teacher Assessments

This article is aimed at those responsible for administering the KS2 Teacher Assessments

Read Guidance

In addition you can record the results for the Year 4 Multiplications Check in the KS2 Stage Assessment Sheets. For DfE guidance on the MTC see here.

Please see here for DfE guidance on administering the KS2 Teacher Assessments and here for information on the column headings in the Stage Assessment Sheets.

See also Primary Data Collections for Bromcom EYFS and Phonics guidance and to register for live webinars.

Important Dates

The deadline line for submission of the data is Friday 28th June 2024.

This guide shows you how to:

  • Setup Access to the Assessment Sheets List
  • Configure the Stage Assessment Sheets
  • Access the Stage Assessment Sheets
  • Input Individual Student Data into the Stage Assessment Sheets
  • Print or Export the Stage Assessment Sheets.
  • Create a KS2 CTF to then upload to Collect

Setup access to the Assessment Sheets List

To set Permissions for access to the Assessment Sheets List where the Stage Assessment Sheets are located, from the left hand menu go to Config then Set Up and Roles and Permissions.

See also How to Edit a Role and its Permissions.

From the dropdown list select the required Role and Edit. From the Module dropdown choose Assessment.

Scroll down to Routines and ensure Assessment Sheets List is ticked as Access.


Configure the Stage Assessment Sheets

To set Permissions for access to Configurations from the left menu go to Config>Set Up>Roles and Permissions. Choose the required role and click Edit, then from the Module dropdown choose Assessment then ensure Configurations is ticked for Access and Save

Configuration Permissions

From the Menu on the left go to Config and then Assessment and Configurations, or use the Global Search Tool.

Note: if you are recording the Year 4 Multiplication Check you will need to add Year 4 in the Stage Assessment Sheet Configuration.

Tick Enable Sheet Users and you will see the config box:


Select the relevant parameters:

  • Enable Sheet Users – selecting this option will only allow the selected Roles and selected Staff in the Selection List to access and input data in the Stage Assessment Sheets.
  • Select individual users – use the blue magnifying glass to open the Staff selector page and select the members of staff who are not defined in the Roles who also need access to the Stage Assessment Sheets. Alternatively type the Staff name into the box, if selecting a single member of Staff. The selected Staff will appear in the Selection List.
  • Generate Templates for National Curriculum Year Groups – select the relevant Year Group or Year Groups you need to generate Stage Assessment Sheets for.

When you’re done, click Save.

Access the Stage Assessment Sheets as a Teacher or Administrator

From the Menu on the left go to Modules >Assessment > Assessment Sheets List


Or from the Overview Tab click More on the Assessment Sheets Widget to access the Assessment Sheets List.

Assessment Sheets Widget
  • User Access – if the user has more than one Role allocated to them select the required Role.
  • Marksheet type – filter to show Stage Assessment.
  • High Level Filter – this is used to filter by the current register or todays register. Leave this box empty as we are setting the date back to the previous academic year.
  • Select the Year Group Stage Assessment Marksheet you require and Double Click to open the sheet. You can click the Filter in the Marksheet Name column header and filter by for example KS2-2024 if needed

Input Individual Student Data into the Stage Assessment Sheets

For DfE guidance on completing the KS2 Teacher Assessments see here and for guidance on column headings see here.

Below is a screenshot with 2024 column heading information for the KS2 Teacher Assessments.

For the Year 4 Multiplication Check the results column for this is the last column in the KS2 Stage Assessment Sheet.

KS2 Assessment Sheet


Click in an Individual Cell to input data for an Individual Student.


Right click on the column heading to Flood Fill the same data for all students, see the Column Details or Filter the column.

Column Details

The inputted data will save automatically as the data is inputted.

Select Export to Export the Stage Assessment Sheet in csv Format which will be saved locally.

Create a KS2 CTF

From the Menu on the left go to Students to open the Students List Page. There are three selection options, individually, by group, or select all:

  • Select individual Students: Select the Students that you are producing a KS2 CTF for by clicking on each individual Student record; or
Student List Page
  • Select by Groups: to filter the list by a specific Year Group click on the 3 vertical blue bars to Add/Remove Additional Columns. Tick Year Group and Save to add it as a column to the Student List Page. Now you can filter by this Group.
Add a Year Group Column
Choose Year Group
  • Select all: To select all the Students from the Selections dropdown Select All.
Select Students

Once you have selected the required Students from the Actions dropdown scroll down and select CTF Export. Change the Export Type to KS2 Return.

Choose Export Type

Export to complete the process.

Updated on May 10, 2024

Was this article helpful?

Related Articles

Noticed a missing guide?
Fill the form below and we will get this created.
Suggest Help Article