This article covers uploading assessment grades data into KS3/4 or KS5. This is different to uploading the standalone types of grades such as Exams, Targets, and Mocks etc., as the Assessments area allows for a type of data that you would like to track over time, for example current working at grades or predictions.

These are managed using assessment collections, which reflect each data point throughout the year (e.g. Y11 Autumn, Y11 Spring, etc.). Each time you collect assessment grades in school, you will need to create a new assessment collection. Each assessment collection will then become a separate report in the REPORTS area for that cohort, allowing you to analyse the figures on those specific grades.

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

Creating an Assessment Collection

To create an assessment collection to store your latest assessment grades for the cohort, click DATA > select key stage and cohort > GRADES > Uploads > Assessments. Click 'Create Assessment Collection'.

You can then work through the following:

• Collection Name - Enter a clear name which will form the name in the reports once published. We recommend including the year the grades were collected and your assessment cycle labels used in school (e.g. Y11 Autumn, Y13 Autumn, etc.).
  
  
• Grade Type - From the options available, select what type of grade data you will be uploading into this assessment collection. For example, if you upload Predictions, you can select this. If you upload Current Working grades you can select Attainment.
  
  
• Date - Enter/select a date related to when the data was collected. This is used to ensure collections are order chronologically based on when they were collected.
  
  
• Term - Select which year/term the data was collected within or relates to. For example, if you're uploading Y11 Autumn grades, this may be Year 11 Term 1.
  
  The term controls the expected grades used for ‘on track’ analysis in the reports (if 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.
  

You can then enter an optional description and click Create.

This will take you back to the 'Uploads for Assessments page', displaying your new assessment collection.

Any grade files uploaded into that collection will be collated and form that assessment in the reports.

Uploading Assessment Grades

Within your new collection, click 'Upload Grade File'.

You will then be asked to select the relevant upload type, based on what format your Excel file is currently in. The two upload types are Broadsheet and Grade List, and both of these formats are individually explained further on.

• Uploading from Broadsheet

If your file is a Broadsheet, you will need to first select the row which contains the titles of each subject. In the majority of cases this will be row '1', but you should check this in your file to make sure.

Next, choose your file, then enter the relevant Assessment Date based on when the grades were collected.

Then, enter a clear file title to identify the contents of the upload (this will only be visible in DATA to allow you to distinguish between your files), and click Upload.

You will then be taken to the Column Mapping - Grade Data screen:

On this page, you should ensure the Student ID and Student Name columns are correctly mapped, then select the first and last qualification columns, based on your file.

Once all columns are mapped correctly, click Continue with the Upload.

• Uploading from Grade List

If your file has each score in a single column, you would use the Grade List option.

Next, choose your file, then enter the relevant Assessment Date based on when the grades were collected.

Then, enter a clear file title to identify the contents of the upload (this will only be visible in DATA to allow you to distinguish between your files), and click Upload.

You will then be taken to the Column Mapping - Grade Data screen:

On this page, you should ensure the Student ID and Student Name columns are correctly mapped, then select the columns containing the Qualification Name, and the Grade/Level.

Once all columns are mapped correctly, click Continue with the Upload.

Completing the Upload

During the upload process, Analytics will perform a file health check, which will inform you of issues found in the file. We recommend checking this, as well as checking the number of students and qualifications listed in the upload summary are as you expect for this file.

However, if you are happy with the file (or want to address issues in Analytics where possible) and you have checked the upload summary, click ‘Continue with the upload’

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.

Including Banked Exams in Assessments

If students have sat banked exams before the year they would be reported on, you can upload these grades into assessment collections to view an overall picture of how your final figures may look.

For example, if you’re working with Current Y11, you could upload a file of official, banked exam grades (e.g. grades achieved in Y10) into your Y11 collections alongside the student’s Y11 assessment grades. Similarly, if you’re working with Current Y13, you can upload a file of banked exams students have achieved when they were in Y12 (such as AS qualifications, L2 resits etc.), alongside your Y13 assessments grades.

In the example below, this would ensure that both the Y10 banked exams and Y11 Autumn grades files contribute towards the ‘Y11 Autumn’ assessment report.

You must also ensure to upload any official, banked exam grades into the Exams data set.

Thanks for reading!

Updated 20 January 2025 16:19