This guide explains how you can upload your actual SATs results into Smartgrade using the CTF containing your results that you receive from the DfE. You are able to upload your total KS2 raw scores for Reading, GPS, and Maths.
Before you begin your CTF upload, you must assign the relevant markbooks from the Marketplace:
In the Marketplace enter SATs 2023 Year 6 in the search box to find the assessments (note: the KS2 SATs tests are in the Summer 1 window):
For each subject you will need to click on ACTIVATE (agreeing to the pop-up message) and then ASSIGN to assign the classes to the assessment. For more information on assigning assessments, please see this guide. Make sure you assign Reading, GPS and Maths and then leave the markbooks empty and unsubmitted.
Then, once you have downloaded your CTF from the Primary Assessment Gateway, go to Configuration (accessed via the three yellow lines in the top-right corner of Smartgrade).
On the left-hand menu, select Bulk Import:
Use the drop-down selectors to configure the details of the assessments you'd like to upload data for. For the KS2 2023 SATs select:
ASSESSMENT FAMILY: 2023 SATs NATIONAL CURRICULUM TESTS
SUBJECT: We recommend selecting All subjects, although the option is available to just select one or two
ASSESSMENT WINDOW: Summer 1
RESULT TYPE / YEAR and ACADEMIC YEAR cannot be changed
SCHOOL: If you are a MAT admin, ensure you select the relevant school
Then select BROWSE FILES to choose your CTF file, and click UPLOAD DATA to begin the upload process.
IMPORTANT:
- If you try to upload data to an unsubmitted markbook containing data then a warning modal appears saying "There is already data in this markbook. If you proceed with the upload then all pre-existing data will be erased and replaced with the new data. Are you sure you wish to proceed?" You can choose to Cancel or DELETE AND UPLOAD CTF.
- If the file is in the expected format (CTF) but contains students that are not in a markbook then you will see a message saying: 'STUDENTS MISSING FROM MARKBOOK. There are students in your file that are not in a markbook on Smartgrade. The missing students are:...' You can choose to Cancel or CONTINUE.
- If the file is in the expected format but is missing students that are in a markbook then you will see a message saying: 'STUDENTS MISSING FROM FILE. There are students in your markbooks that are not in this file. The missing students are:...' You can choose to Cancel or CONTINUE, these students are marked as Absent.
- If you upload data to a markbook and there is missing data for some of the students, the students with missing data are marked as Absent in the relevant markbook.
- If you upload data for a student who appears in 2+ markbooks within the same window/subject combination then the data is uploaded to all markbooks but none of the affected markbooks are submitted. An error message says: 'STUDENTS IN MULTIPLE MARKBOOKS. There are students that appear in multiple markbooks. If you continue, results will be uploaded to all instances of the student and the affected markbooks will be unsubmitted. The duplicated students are:...'.
Once the CTF has imported the data is added to the markbooks and the markbooks are submitted. You will be taken to the analysis module with all classes selected and with data aggregated by class.
If you are unable to successfully upload your file after troubleshooting the above issues, please contact Smartgrade at help@smartgrade.co.uk.