Adding Welsh National Test Scores for KS4 imports - Wales

Adding Welsh National Test Scores for KS4 imports - Wales

At Key Stage 4 in Wales, we use an average of the Year 8 Welsh National Test scores as a prior attainment, or baseline, score for your students.

Launch the + Prior Attainment wizard from the Year Group summary bar.


The wizard will guide you through the import steps and provide an Excel template for you to download. Click here to download the Excel template.

You can also download the template from the first step of the prior attainment wizard:


Populate the template with the UPN and Year 8 WNT Standardised Scores for your students.


Please save the template locally and populate. If you have * or ** in your data then please change these to 69 and 141 respectively.

Once this is done, import your WNT file using the wizard and click Next.


The scores will be calculated for you, and will be matched to your students present in the selected Year Group using the UPN.


    • Related Articles

    • Different Types of Prior Attainment Scores

      Your Prior Attainment scores can be imported within the + Year Group step, or you can use the + Prior Attainment wizards to import your data and make use of our prior attainment calculators. The Prior Attainment import wizard will change based upon ...
    • Adding Average GCSE Scores for KS5 imports - All Countries

      The Prior Attainment wizard will change depending upon your country and the Key Stage. KS4 imports in Wales; you will be given instructions on importing your Year 8 Welsh National Test Scores KS4 in England; you will need to Key to Success file from ...
    • CAT4 as KS4 Prior Attainment - Step by Step Guide for Data Managers

      Alps is a value-add system, and the prior attainment – or baseline – is crucial to assessing the progress your students are making. ​ For schools who do not have Key Stage 2 scores to use as their prior attainment for Key Stage 4 analysis, we provide ...
    • Getting the most from the High Middle and low prior attainment filter

      This video takes you through how to apply the High, Mid and Low comparison filter across the subject overview page in Connect  ​​​ The high, middle and low prior attainment comparison is available across all key stages and qualification types. The ...
    • Adding Key to Success data for KS4 imports - England

      If you do not already have your KS2 scores calculated and saved locally, you can download a Key to Success file from the DfE, using the student UPNs. Connect Data will read this file, and calculate either the KS2 Fine Scores or the KS2 Scaled Scores, ...