Key Stage 2 Data

ProgressTeaching can calculate Progress 8 for attainment, predicted, and target data for any students with Key Stage 2.

The KS2 averages for students are calculated using a Reading and Maths scaled score. The following aspects and result sets are typically used for this calculation.

How to upload KS2 data

1. Start with a blank Excel spreadsheet.

2. Insert student UPNs from cell A4 going downwards.

3. Enter 'KS2 Reading Scaled Score' in cell B1.

4. Enter 'KS2 Maths Scaled Score' in cell C1.

5. Enter 'KS2 Validated' in cells B2 and C2.

6. Change cell B3 and C3 to a Text type field.

7. Enter the start of the academic year date in cell B3 and C3 in the format YYYY-MM-DD.

8. Input the Reading and Maths scaled score data for the students and save the file.

9. In ProgressTeaching, access the Admin area.

10. Select Progress > Student Result from the menu.

11. Select Import V2.

12. Upload your file and select Import (the page should refresh and display a message saying that it was successfully uploaded).

13. Next, select Progress > Student KS2 Values from the menu.

14. Select Recalculate KS2 values so that the system processes the new KS2 data.

How to export KS2 data for a year group

1. Access the Admin area, and select Progress > Student Result from the menu.

2. Select Export from the page.
   

3. At the top of the page, select the year group that you want to upload KS2 data for.
   

4. Select the plus icon twice to add two lines to your export sheet, and enter the following aspects and result sets into those lines.

5. You should end up with the below template.
   

6. Select Export.

How to find students that are missing KS2 data

1. Access the Admin area, and select Progress > Student KS2 Values from the menu.

2. This data is contained within the Students without calculated KS2 Fine Value table.
   

3. You can filter for different year group, as well as students that are currently off roll.

Estimated KS2 data

Students with estimated KS2 scores will not be used when calculating a school’s P8 or any other VA measure as, without official KS2 values, they will not be included in official P8 calculations.

The purpose of supporting estimated KS2 is to allow for the internal tracking of student progress.

The subject and class pages allow you to display Progress 8 calculated both with and without the estimated KS2. To do this, you can use the following two options on the page:

• VA with estimated
• VA
  

Students with estimated KS2 scores will be indicated by an exclamation mark.

Adding estimated KS2 data individually

1. Access the Admin area, and select Progress > Student KS2 Values from the menu.

2. Search for the student within the Students without calculated KS2 Fine Value table.

3. Select the pencil icon to edit and assign an estimated value to them.

4. Once created, you will need to press Recalculate KS2 Values in the top right for the changes to flow through the system.

Overriding KS2 Fine Values

1. Access the Admin area, and select Progress > Student KS2 Values from the menu.

2. Search for the student and select the override button on the right.

3. Input a new score and hit Save.

4. Once you have completed the changes you wish to make for all pupils, please select Recalculate KS2 Values in the top right.

ProgressTeaching will use the new KS2 value for all official P8 and VA calculations for the student. Once saved, you will notice a revert button next to the student. This allows you to revert to the previous values.