Overview

This article explains how to review and update your KS4 student list and filters stored in Sisra Analytics to make sure they reflect the student information in the Spring Census. This will help to ensure your student information is accurate for headline figures reported on Results Day, as it will align with the data that the DfE uses for exam result reporting.

Prerequisites

You must be an administrator.

Instructions

Follow these instructions to check and update (as needed) your student list and filter values:

• 1. Select DATA.
  2. Select KS3/4.
  3. Select Current Yr 11.
  4. Select Students.
  5. Select Cohort to open the Student List:
     
  6. Review the data:
     1. Check the total number of students On Roll.
     2. Check the Active Students section, where students with the following Status are listed:
        • On Roll. These students are included in the school performance measures (where eligible).
        • Guest. These students are excluded from the school performance measures, but included in the student performance measures for internal analysis.
     3. Check the Inactive Students section, where students with the following Status are listed:
        • Left School. These students are excluded from all reports for the cohort. 
  7. If you need to update your student data, proceed to Step 2.

  You can manually create a new student from here by selecting Add New Student. If you manually add a student, remember, you must also manually add their classes. 

If you need to update your student data, choose an option from:

• To manually change the status of one or more students, from DATA > Select Key Stage 3/4 and Cohort > Students > Cohort:

  1. Check Actions next to one or more student names.
  2. Select Change Status. 
  3. When prompted, change the Student(s) Status:
     
     
     1. Select status.
     2. Select Change Status.

  To manually change a student's filter value(s), from DATA > Select Key Stage 3/4 and Cohort > Students > Cohort:

  1. Select their name.
  2. Select Filters to expand the section:
     
  3. Select Edit Filters.
  4. Change the filters as required:
     
  5. Select Save. 

  Quickly switch to another pupil by selecting their name in Showing detail for:.

  See Sisra Analytics: KS3/4 - Editing Student Details (Admin) for more information.  

• If you have lots of changes to make, extract the student data from your MIS during Spring Census,  make any changes and save the file in Microsoft Excel, then import. This will automatically update the cohort and filters automatically.

  Follow these instructions to import the file:

  1. Select DATA.
  2. Select KS3/4.
  3. Select Cohort.
  4. Select Students.
  5. Select Import.
  6. From Import File - Student Data:
     
     
     1. Select the key stage that the class data relates to (4).
     2. Select Choose File, and then select the file to upload from your device. 
     3. Select Import.
  7. When prompted, complete any Column Mapping as needed.
  8. Select Continue with the import.
  9. From the Import File - Student Data:
     
     
     1. Toggle Update Classes to No.
     2. Toggle Update Filters to Yes.
     3. Check Update Statuses - Yes.
     4. Select Complete the import.

  See Sisra Analytics: KS3/4 - Importing Student Data (Admin) for more information.

After updating your student data:

• 1. Go to DATA > Select Key Stage 3/4 and Cohort > Students > Cohort.
  2. Check all of your students have been awarded the appropriate status in the Students List:
     • If they have, move to Step 4.
     • If they have not, return to Step 2 to make any necessary changes before proceeding.
• 1. Go to DATA > Select KS 3/4 and Cohort > Students > Publish Students.
  2. Select Publish to publish the student data and reflect your changes in the reports.

If you have students who joined after the Spring Census (who are set automatically to Left School during the import), who won’t affect your school performance, but you would like to analyse internally, set them to Guest status.

Outcome

Your KS4 student list and filters reflect that of the Spring Census. This will help to ensure the accuracy of your student information for reporting in headline figures on Results Day.

Related information

• Sisra Analytics: KS3/4 - Editing Student Details (Admin).
• Sisra Analytics: KS3/4 - Importing Student Data (Admin). 
• Sisra Analytics: KS3/4 - Editing Student Details (Admin).

Training

Updated 12 June 2025 14:48