Uploading Standalone Grades e.g. Exams, Targets, Mocks etc. (Admin)

This article covers uploading grades data into the appropriate data sets within Analytics, including Exams and other grades such as Targets, Mocks, etc.

The screenshots below use KS3/4 as an example, however the steps are the same for KS5.

Uploading a standalone grades file

To upload your file, click DATA > select key stage and cohort > GRADES > Uploads.

To upload official banked exam grades, click ‘Exams’ on the left.

To upload grades into a standalone data set, select one of your additional data sets, such as Targets, Mocks, Data Set 3, Data Set 4, or Data Set 5. Each of these data sets can contain one full set of grades at a time. 

Then, select an EAP term, which should reflect when the data relates to or when it was collected. This controls the expected grades used for ‘on track’ analysis in the reports (if expected grades have been entered into your EAPs for that cohort). In KS3/4, this will also determine which grade method each qualification will use and whether KS3 or KS4 classes will be pulled through to the reports for those students. The Exams data set will automatically be set to the ‘KS4 or KS5 Exams’ term.

Next, from the options available in the Grade Type drop down, select what type of grade data you will be uploading into the data set, e.g. End of Key Stage Targets, Attainment, Predicted etc. This is important if your school is part of a trust which uses the Juniper Insights MAT Dashboard. Note: The Exams data set is automatically set to Exams.

Then, click ‘Upload Grade File’.

Next, choose the file you wish to upload and enter/select an appropriate date, such as when the grades were achieved or collected.

Enter a clear file title. This will only be visible in DATA for Sisra admins to distinguish between files, and so will not appear in the reports. Once entered, click ‘Upload’.

Next, we recommend checking that no potential issues have been raised in the file health check, as well as double checking the number of students and qualifications listed in the upload summary are as you expect for this file. 

If no issues have been found, click ‘Continue with the upload’.

Confirm Upload Qualification Names

When uploading subsequent grade files containing qualifications that have not been uploaded previously for that cohort, the Confirm Upload Qualification Names page will prompt you to merge these with existing qualifications or create these as new qualifications.

If the qualification you’re uploading grades for has not been uploaded before for that cohort and is therefore new, select “New” in the SISRA Qualification dropdown.

However, if this qualification exists for the cohort, but has been named slightly differently on your Matching page compared to your file, you can merge these together by selecting the appropriate qualification from the SISRA Qualification dropdown.

Once you have completed the selections for all qualifications shown, click ‘Complete the upload’. Any new qualifications will need to be set up on the Matching page.

You will then be taken to the Uploads page for that data set, where you can manage your file. Here you can export your grades list to Excel, edit the title or date of your file, see a preview of the files contents, or permanently delete the file.

If you’re working with grades that include L2 qualifications in KS5, these can also be uploaded alongside the student’s assessment/exam grades.

Thanks for reading!