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 the Academic Year and Year Group of your import, the articles below give details of how to produce the files you will need to import into this wizard.
Key Stage 5
All KS5 imports will need an Average GCSE Score, regardless of country.
Please note that the term APS (or average point score) often includes all level 2 qualifications whereas the Alps Average GCSE score does not include other level 2 equivalents. Please see our Average GCSE Calculation rules for further details.
Key Stage 4
For KS4 imports, you will need a DfE Key to Success export if you are from England, or the Year 8 Welsh National Test data if you from a Welsh school. The appropriate prior achievement will be automatically available.
Why we need prior attainment scores
Alps works on a value-add system, we measure how your students are progressing from their baseline score, or prior attainment. If you would like to know more about the prior attainment scores and the Alps methodology, please see our article Introduction to Alps for Data Managers.
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, ...
Average GCSE Score Calculation - for Data Managers
For all KS5 imports, you will need the Average GCSE Scores as a baseline for your students. The manual GCSE Score calculator allows you to enter the received GCSE grades one by one, and will calculate the Average GCSE Score for you. Key Stage 5 ...
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 ...
Downloading Key to Success data from the DfE for KS4 Imports - England
Visit the below website and enter your DfE username and password. https://sa.education.gov.uk/idp/Authn/UserPassword Select the Key to Success application from the options shown. Choose Searchable Pupil Data from the options on the left. Paste the ...
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 ...