Overview
This article explains how to compare the performance of your current cohort at a qualification level with that of previous years using the interactive KS3/4 Qualification Trends Report (a separate trends report for headline measures is also available). You can compare grades and grade range percentage trends, Subject Progress Index (SPI) and average points for the last 5 years (either including or excluding COVID-19 years).
Prerequisites
- The Qualification Trends Report must be set up in Sisra Analytics. If the report is not available, contact your school's Administrator.
- Relevant data for the last five years must have been uploaded to enable analysis.
Instructions - video
Instructions
To access the KS3/4 Qualification Trends Report:
- Select REPORTS.
- Select KS3/4.
- Select VIEW THE QUALIFICATION TRENDS REPORT:
- Select a Qualification, when the Qualification Trends Report opens:
- Optionally, to remove data from the COVID-19 years (2019-2020 and 2020-2021), if it is visible, slide the Covid Years toggle to the left:
Outcome
The KS3/4 Qualification Trends Report opens, comprising charts and a table. Specific data presented includes Percentage and Cumulative Percentage at Grade, Subject Progress Index (SPI) and Average point per entry for the selected subject:
Both tables and charts can be exported from the report. The tables can be used in Microsoft Excel, and the charts are downloaded as image files, which can be used in documents or presentations.
- Select Export Table Data to export a file for use in Microsoft Excel:
- Select the hamburger next to a chart, then select Download image to save the chart as an image file:
Although you cannot filter this report, if you'd like to filter the data, export the table at the bottom of the report and manipulate further within Microsoft Excel.
Elements
| Field name | Description |
| Percentage at Grade* | The percentage of students with each grade in that qualification, across each dataset that has been included. |
| Cumulative Percentage at Grade* | The percentage of students with grades within each grade range, for example, 9-8 and 9-7, across each dataset that has been included. |
| Subject Progress Index |
The Subject Progress Index (SPI) score for the qualification, across each dataset that has been included. The SPI for a qualification is the average of students’ SPI scores within that qualification (grade points minus collaborative average from the Sisra Data Collaboration). SPI will only be included for cohorts where the Data Collaboration event has been opted into, set up and published with for that dataset. See Sisra Analytics: KS3/4 - How is SPI (Subject Progress Index) calculated? for further information. |
| Average Points per Entry | The average points for that qualification across each dataset included. This is calculated by taking the total points for the qualification divided by the total entries. |
* The grades displayed will be in the format of 9 to 1, U and X grades. This is mapped using equivalent Attainment 8 points. For example, a D* in a Non-GCSE worth 8.5 points would be counted as an equivalent to an 8.
Related information
- Sisra Analytics: KS3/4 - How do I fix a missing Trends Report or a specific year’s data not being included? (Admin).
- Sisra Analytics: KS3/4 - How do I fix incomplete analysis for a qualification in my Trends Report? (Admin).
- Sisra Analytics: KS3/4 - Why is the Subject Progress Index chart not populated as expected in the Trends Report? (Admin).
- Sisra Analytics: Do Locked or Embargoed Reports appear within the Trends Report? (Admin).
- Sisra Analytics: KS3/4 - How is SPI (Subject Progress Index) calculated?
Updated