The KS3/4 Qualification Trends report provides interactive year-on-year comparison of your historical Exam performance (up to the last 5 years, either including or excluding COVID years), at a click of a button! This includes grade and grade range percentage trends, Subject Progress Index (SPI) and average points, helping to inform your analysis!
Qualification Trends
To access the Qualification Trends Report, click REPORTS > KS3/4 and then ‘View Trend Reports’.
| If the trends report is not available, we recommend contacting your Sisra Admin directly. Admins – If this report is not shown or analysis is incomplete for a qualification, please see KS3/4 Reports Troubleshooting - Qualifications Trends (Admins) |
Once in the report, you must select a qualification to view the charts available. You can then view and even hover over key elements of the chart for extra information. You can also include / exclude the year groups affected by COVID from the analysis using the 'Covid Years' toggle (a video tutorial demonstrating this further is available at the bottom of this article). This can be disabled by default by your Sisra Administrator in CONFIG. > Settings > KS3/4 Report Settings.
Towards the bottom of the report, you can also found a table of the results, which can be exported to Excel by clicking 'Export Table Data'.
In brief, the following charts / analysis is provided:
-
Percentage at Grade* – The percentage of students with each grade in that qualification, across each dataset included.
- Cumulative Percentage at Grade* – The percentage of students with grades within each grade range (e.g. 9-8, 9-7 etc.), across each dataset included.
*Note: 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’.
- Subject Progress Index – The SPI score for the qualification, across each dataset included. SPI for a qualification is the average of students’ SPI scores within that qualification (grade points minus collaborative average from the Sisra Data Collaboration). For more information on how SPI is calculated, click here.
Please note: SPI will only be included for cohorts where the Data Collaboration event has been opted into, set up and published with for that dataset.
- Average Points – 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.
| Currently, the Trends report is available for qualification analysis (not headline measures) and there is presently no facility to apply filtering. However, if further filtering is required, you can click ‘Export Table Data’, to export the table at the bottom of the report as an Excel file, and manipulate further. |
Thanks for reading!