Statutory data for ELGs, Phonics Screening, KS1 and KS2 Teacher assessments and Tests may all be imported from a single CTF (Common Transfer File) quickly and easily using the following steps.
Ensure you have Admin rights in order to proceed. Non Admin users will not be able to import data.
You can either;
1. Import one whole school CTF from your MIS - this will allow you to import all statutory data (EYFS. Phonics*, MTC and KS2) in your MIS for all pupils in one go
Create a 'Full' or 'General' CTF (including Tasks and Tests if it's an option) from your MIS, ensuring your own school is set as the destination school (data with any other destination school will be ignored by the import)
This can be for the whole school, a year group or individual pupil.
or
2. Import separate CTFs from your MIS pertaining to particular Statutory Assessments - this will allow you to import one type of assessment at a time
or
3. Import a file you have downloaded from the Primary Assessment Gateway (Yr6) or MTC service* ( Yr4)
*only available from 24th June 2024 and subject to confirmation from schools
Navigate to the School section via the left hand menu
Add the file to the 'Send a file to Sonar' section by dropping it in the window or clicking within the window to browse for a file.
The system will detect the content of the file and display a window with the details.
Place a tick in any of the boxes for the data you want to import then choose Upload and Process File.
*NB: Due to the way results were recorded when Phonics screening was administered in the Autumn Term of 2021, we advise uploading the file twice; the first time leaving Phonics unticked. If having uploaded the file again with Phonics ticked no Phonics data is imported you should then create a new CTF, just with Phonics data included, for Years 2,3,5 and 6 - depending on your MIS these may need to be separate files - and upload them, ticking only Phonics this time.
Files are processed every ten minutes so this is the maximum time you will have to wait for the data to be available.
If you think your data has not been imported please refer to the tips in here;
Troubleshooting - I've uploaded a CTF to Sonar but cannot see the data.