Sonar Tracker: Primary Assessment Conversion Matrix Report

Overview

This article provides an overview of the Primary Assessment Conversion Matrix report's purpose, guidance on how to access it, the various types of information it contains, and the different controls that help you customise what you see in the report.

Purpose

Do not use this report in its current format for Summative to Summative conversions as the colours and headline results are misleading. The numeric values in the cells will help to identify pupils but you should not take any notice of the colour coordination. To better compare Summative to Summative performance between Assessment Periods, use the Primary Summative Progress Analysis report.

The Primary Assessment Conversion Matrix report lets you make rapid comparisons between assessments of one type from one period with another in order to see conversions and to identify any pupils of concern that are not making the progress that you would expect. This works particularly well, for example, if you wish to compare teacher assessments at the end of the previous key stage with summative assessment for the current assessment period. Using the information you can put in place supporting interventions to help ensure identified pupils are given help to achieve their potential. Alternatively, you want to compare teacher assessments and test results, or assessments between the end of two key stages. This may show better than expected progress or show where progress is not at the expected rate. The report could be used in a body of evidence highlighting performance that is better / not as good as expected.

By default the report compares the current Assessment Period with the last Assessment Period in the previous Academic Year. Select a cell in the matrix that has pupil numbers and percentages to view the names pupils.

Opening the page

After selecting the Primary Assessment Conversion Matrix report from the Reports page menu, you will be prompted to select which pupils you wish to include. Select one or more Year Groups and / or Classes then select Load Report:

Report View

Elements

Field Name	Description
X Pupils	Number of pupils who are included in the report.
Headline / KPI - Less than expected progress	The percentage of those pupils within the selected group, with assessment results, that are making less than expected progress between the two selected periods for the selected subject and data sets (highlighted as red in the matrix). In the example above, a group of 30 pupils has been selected. All 30 of them have assessment data. Of those, 2 have made less than the expected level of progress. To calculate the percentage making Less than expected progress: Expected progress (%) = (Number of pupils making less than expected progress ÷ Number of pupils with assessment data) x 100 Therefore: Expected progress (%) = (2 ÷ 30) x 100 = 0.066 x 100 = 6.7%.
Headline / KPI - Expected progress (target group)	The percentage of those pupils within the selected group, with assessment results, that are just making the expected progress between the two selected periods for the selected subject and data sets, but may benefit from extra support (highlighted as yellow in the matrix). To calculate the percentage making expected progress (target group): Expected progress (target group) (%) = (Number of pupils making expected progress (target group) ÷ Number of pupils with assessment data) x 100
Headline / KPI - Expected progress	The percentage of those pupils within the selected group, with assessment results, that are making the expected progress between the two selected periods for the selected subject and data sets (highlighted as green in the matrix). In the example above, a group of 30 pupils has been selected. 30 of them have assessment data. Of those, 24 have made less than the expected level of progress. To calculate the percentage making Less than expected progress: Expected progress (%) = (Number of pupils making expected progress ÷ Number of pupils with assessment data) x 100 Therefore: Expected progress (%) = (24 ÷ 30) x 100 = 0.8 x 100 = 80.0%.
Headline / KPI - Better than expected progress	The percentage of those pupils within the selected group, with assessment results, that are making better than the expected progress between the two selected periods for the selected subject and data sets (highlighted as purple in the matrix). In the example above, a group of 30 pupils has been selected. 30 of them have assessment data. Of those, 4 have made less than the expected level of progress. To calculate the percentage making Less than expected progress: Better than expected progress (%) = (Number of pupils making better than expected progress ÷ Number of pupils with assessment data) x 100 Therefore: Better than expected progress (%) = (4 ÷ 30) x 100 = 0.133 x 100 = 13.3%.
Matrix - From Headings (Columns)	The heading for the columns is the name of the selected From Data Set containing the "from" assessment outcomes. The sub-headings, displayed on the individual columns comprise the different assessment grades / scores associated with the From Data Set and a column called No Assessment. The No Assessment column details those pupils who have no assessment data for the From Data Set for the selected Assessment Period.
Matrix - To Headings (Rows)	The heading for the rows is the name of the selected To Data Set containing the "to" assessment outcomes. The sub-headings, displayed on the individual rows comprise the different assessment grades / scores associated with the To Data Set and a row called No Assessment. The No Assessment row details those pupils who have no assessment data for the To Data Set for the selected Assessment Period.
Matrix - Cells (Elements)	Each cell (element) within the matrix lists the number and percentage of pupils achieving that assessment outcome. The total percentage value is based on the total number of pupils in the group (including those without assessment data). For the other cells the percentage value is based on the total number of pupils achieving the "from" assessment outcome. In the example below, this is the Just At outcome: A - The total number of pupils achieving Just At for 2022 - 2023 Summer 2 Summative is 6 pupils out of the set of 30 pupils. This total represents (6 ÷ 30) x 100 = 0.2 x 100 = 20.0% of pupils from the total group of pupils. Remember, the total set of pupils includes those pupils with no assessment data. In this example all pupils have assessment data. B - Of the 6 pupils who were Just At for 2022 - 2023 Summer 2 Summative, 1 was Below for 2023 - 2024 Spring 1 Summative. This represents (1 ÷ 6) x 100 = 0.166 x 100 = 16.7% of the Just At in 2022 - 2023 Summer 2 pupils. C - Of the 6 pupils who were Just At for 2022 - 2023 Summer 2 Summative, 5 were Securely At for 2023 - 2024 Spring 1 Summative. This represents (5 ÷ 6) x 100 = 0.833 x 100 = 83.3% of the Just At in 2022 - 2023 Summer 2 pupils.

Controls

Control	Description
	Select to refresh the contents of the report. This is particularly useful if you think that the data may have changed whilst you were using the report, for example, if someone else added new assessment data during the time you were viewing it.
Filters (1 Active Filter or x Active Filters)	The filters control indicates how many filters are currently applied to the data set. Select to contextually filter the pupils.
From Data Set	The From Data Set is used in conjunction with the To Data Set and their associated Academic Years and Assessment Points. Together they let you compare statutory end of Key Stage data with ongoing Summative Assessments. Select the From Data Set from: Summative (default value). ELGs 2020 End of Key Stage 1 TA (Key Stage 1 Teacher Assessment). End of Key Stage 1 Test. End of Key Stage 2 TA (Key Stage 2 Teacher Assessment). End of Key Stage 2 Test.
From Academic Year and Assessment Point	Select the Academic Year and Assessment Point for the From Data Set. By default this is set at the last Assessment Point in the previous Academic Year.
To Data Set	The To Data Set is used in conjunction with the From Data Set and their associated Academic Years and Assessment Points. Together they let you compare statutory end of Key Stage data with ongoing Summative Assessments. Select the To Data Set from: Summative (default value). Targets. End of Key Stage 1 TA (Key Stage 1 Teacher Assessment). End of Key Stage 1 Test. End of Key Stage 2 TA (Key Stage 2 Teacher Assessment). End of Key Stage 2 Test.
To Academic Year and Assessment Point	Select the Academic Year and Assessment Point for the To Data Set. By default this is set at the current Assessment Point in the current Academic Year.
Subject	Check the Subjects that you want to use when running the Primary Assessment Conversion Matrix report. The Subjects to choose from are: Reading (default). Art and Design. Writing. Mathematics. Computing. Design and Technology. Science. Geography. Spoken Language. History. Religious Education. Languages. Music. Physical Education. PSHE.
Matrix - Cells (Elements)	When only a total number and percentage are displayed in a cell, select the cell to view the names of those pupils who make up the number. When names are displayed, select the cell to hide them.
Display Options	Check / uncheck the following to control how the report is presented: Names Check to view the names of the individual pupils whose results make up the totals shown in each of the cells in the report: By default, Names is not checked. Cumulative By default the result shown in each cell relates to that grade/score only. Check Cumulative to see the results of the grades/scores from Significantly Below onwards added to the current value. For example, if you want to view which pupils are Securely At or higher, this will comprise the total pupils in Significantly Below, Below, Securely At, Above and Significantly Above). This is illustrated in the example below: Significantly Below cumulatively includes all those pupils who are Below, Just At, Securely At, Above and Significantly Above. Below cumulatively includes all those pupils who are Just At, Securely At, Above and Significantly Above. Just At cumulatively includes all those pupils who are Securely At, Above and SignificantlyAbove. Securely At cumulatively includes all those pupils who are Above and Significantly Above. Above cumulatively includes all those pupils who are Above and Significantly Above. Significantly Above cumulatively includes only those pupils who are Significantly Above. KPIs Check to show the Headline Key Performance Indicators (KPIs) associated with the report. By default, this is checked.
PDF	Select to create a PDF version of the report. When created, the report is automatically downloaded to your device. To view the report in PDF format, locate and open the PDF file using either the built-in download functionality in your web browser or the file management tools on your device.