Sonar Tracker: How do I import Statutory End of KS2 Test scores / Teacher Assessments?

Sonar Tracker

Overview

This article explains how to download your Key Stage 2 tests, import the results into Sonar Tracker and then view them in reports. 

This article is only relevant if you use stand-alone Sonar Tracker and have not yet migrated to the integrated version. If you don't know which version of Sonar Tracker you are using, see Sonar Tracker: Which version of Sonar Tracker am I using?

If you are using the integrated version of Sonar Tracker, see MIS: How do I import a CTF? for information about importing data. 

To check your 2025/6 KS2 data is in Sonar Tracker see How do I see statutory data for Year 7 pupils?

Prerequisites

  • You must be an Account Admin or Account Owner by default.

Downloading results as a CTF from the National Curriculum Assessment Portal

Go to the DfE National Curriculum Assessment Portal and download your results as a CTF file.

Importing your CTF into Sonar Tracker

Follow these instructions to import your KS2 test results:

  1. Select School.
  2. Select the Send a file to Sonar widget to open your device's file management software and select the results CTF to upload (or drag the results CTF file you want to upload onto the widget):
  3. The system will detect the file contents and display the details. Check KS2:
  4. Select Upload and process file. Files are processed every 15 minutes so it shouldn't be too long before you see the raw scores in Assess > Statutory Assessments > KS2.

To ensure the reports  show your data, we must program the scaled score conversion tables into Sonar Tracker. We aim to do and test this as soon as possible on KS2 results day, after which any imported scores will be used to populate the reports.

Outcomes

Select Assessments / Statutory Assessments / End of Key Stage Two and select year group or class to see the results of your import:

  • Raw Scores will populate immediately.
  • Test Outcomes will populate immediately once the conversion tables have been programmed into the software;

On Key Stage 2 results day, we must program the conversion tables into Sonar Tracker for Test Outcomes to be calculated for this screen and reports. We aim to do this within the first couple of hours of the day.

If you think your data has not been imported, go to Sonar Tracker: Why can't I see my data after uploading a CTF in Sonar?

Reporting KS2 Outcomes

  1. Select the End of Key Stage 2 Outcomes report to show the percentage of pupils at and above in each subject as well as the school's combined percentage.
  2. Select the Statutory Dashboard in the Analysis tab (This report is updated overnight so will reflect any changes made the following day) 

  3. Select the Assessment Conversion Matrix Report to compare the KS2 data with the KS1 Outcomes for the pupils. When using this report for select KS2 Tests as the From option.

Related information

Training

New to Sonar Tracker?

Follow the link below to find out more about our getting started training (previously called "Administering Sonar Tracker") and to book your place:

Getting Started with Sonar Tracker

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request