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 KS5 Qualification Trends Report (a separate trends report for headline measures is also available). You can compare grades and grade range percentage trends, average points, and Value Added, for Level 3 qualifications 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 KS5 Qualification Trends Report:
- Select REPORTS.
- Select KS5.
- Select VIEW THE QUALIFICATION TRENDS REPORT:
- Select a Subject, 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 Qualification Trends Report opens, comprising charts and a table. Specific data presented includes Percentage and Cumulative Percentage at Grade, Value Add 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, A*-A and A*-B, across each dataset that has been included. |
| Value Added |
The Value-Added score for the qualification across each dataset that has been included. This is calculated by taking the total of the weighted VA point scores for the qualification, divided by the total weighted qualification size. See Sisra Analytics: KS5 - How is L3 Value Added (VA) 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 are displayed in the format of A Level A*-E, U, and X grades. These are mapped using equivalent A Level points and average grade boundaries. For example, to fall within the A* column, the grade would need to be worth 55 points or more. See Sisra Analytics: KS5 - How are Average Grade Boundaries used in reports? for further information.
Related information
- Sisra Analytics: KS5 - How do I fix a missing Trends Report or a specific year’s data not being included? (Admin)
- Sisra Analytics: KS5 - How do I fix incomplete analysis for a qualification in my Trends Report? (Admin).
- Sisra Analytics: KS5 - Why is the Value Added 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: KS5 - How is L3 Value Added (VA) calculated?
- Sisra Analytics: KS5 - How are Average Grade Boundaries used in reports?
Updated