Overview

This article explains how to import a CTF from the Primary Assessment Gateway into Sonar Tracker. This lets you import your KS2 data into Sonar Tracker, as you are unable to transfer raw scores directly from Target Tracker into Sonar Tracker.

Instructions

Follow these steps to import your missing Statutory data after migrating from Target Tracker:

• Follow these instructions to open the Primary Assessment Gateway and download your KS2 test results:
  1. Go to the Primary Assessment Gateway in your browser.
  2. Enter your Username and Password then select Sign in.
  3. After successfully signing in, go to Available Activity.
  4. Select View and download KS2 test results.
  5. Select Download results.
  6. When the page opens, select Common transfer file (CTF) and download the file (full results with TA scores).
• In 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. The files will be processed and uploaded within 15 minutes. 

Outcomes

After 15 minutes, the files will be processed and the raw scores will be visible in the Key Stage 2 Statutory Assessments section of Sonar Tracker.

To view them:

1. Select Assessments.
2. Select Key Stage 2 under Statutory Assessments.
3. When prompted, select Year Group or Class.
4. Select Load Assessment to open the Key Stage 2 page.
5. Select one of the three options:
   
   • Test Raw Scores - these will populate immediately.
   • Test Outcomes - these will populate immediately once the conversion tables have been programmed into the software. On Key Stage 2 Results Day, Juniper Education programs the conversion tables into Sonar Tracker for Test Outcomes to be calculated for this screen and reports. We do this within the first couple of hours of the day.
   • Teacher Assessments.

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?

MTC data for current Year 5 pupils

1. If MTC data is missing, importing the CTF from the MTC Check Service will resolve this.
2. After you have the file, upload your CTF using Send a file to Sonar widget (as explained above).

Any other historical data

1. Create a CTF in your MIS. When doing this, choose General and include either the whole school or filter to a particular Year Group.
2. Upload your CTF using the Send a file to Sonar widget (as explained above).

Reporting Statutory outcomes

1. Select the End of Reception , End of Key Stage 1 , End of Key Stage 2 Outcomes Reports 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. 

Related information

• Sonar Tracker: Why can't I see my data after uploading a CTF in Sonar?
• Sonar Tracker: How do I import Statutory Data from a CTF?

Updated 10 September 2025 12:52