How to import KS2 SAT scaled scores from NCA Tools

The KS2 SAT scaled scores for 2017-18 will be available for schools to download from NCA tools from 7.30am on 10th July.

Once these scores are available, they can be imported into Insight.

Download scores from NCA Tools

  1. Head to the NCA Tools Website at https://ncatools.education.gov.uk/ and log in.
  2. Download your results as a Common Transfer File (CTF):
    1. Choose Pupil Results
    2. Choose Download Key Stage 2 Results
    3. Select Combined file containing all subjects
    4. Select CTF as the File Format
    5. Click Download

Import scores into Insight

      Navigate to the Admin page and choose Manage Pupils:

      Admin-Manage Pupils

      Click the Update Pupils button:

      update-pupils

      Click the CTF File button:

      click-ctf-file

      Click the Choose file button. Navigate to the CTF you exported to your computer (you're looking for a filename that ends with .xml) and click Open:

      ctf-click-choose-file

      Once you've chosen your file you'll be able to see which pupils will be updated. Just click Apply the Selected Changes to finish.

      Analysing your SAT Scaled Scores

      Insight records SAT scaled scores under the Assessment Name: SAT Scaled Score.

      You can view your scaled scores via any of Insight's reports, but a good place to start is with the Cohorts > Overviews - Attainment report. If you set it up using the controls shown below, you'll see a visual summary of what percentage of the cohort met the expected standard:

      Please note that Insight is using last year's "high score" threshold of 110. In the unlikely event of the government changing this once the national data is released, Insight will be updated accordingly.


      Writing Data

      There are no scaled scores for Writing, just teacher assessments, such as EXS. However, Insight can generate nominal scores from those teacher assessments for you. This makes it easier to see all subjects on the same report.

      To see Writing, first click Advanced Options, then in the Subjects list tick Reading, Writing and Maths.


      How did we do?