Accessing the Capped 9 Spreadsheet

Overview 

The Capped 9 spreadsheet allows schools to calculate and analyse Capped 9 outcomes using their own Gradepoint data exported from Connect. Once data has been imported, the spreadsheet automatically calculates individual student scores and headline measures across key demographics. 

Video Guide

 

Accessing the Capped 9 Spreadsheet 

To access the Capped 9 spreadsheet, first select the Main Gradepoint you wish to analyse using the Capped 9 methodology. For guidance on selecting Gradepoints, please see this article: Gradepoint Selector 

Next, in the Connect homepage navigate to the Student Analysis tile and click View Analysis.

In Student Analysis, click the Capped 9 button to download a blank copy of the Capped 9 spreadsheet. 

Then download your Student Analysis by clicking the Download Excel button to download a spreadsheet containing all student records from your main Gradepoint. 

Save the file with a name of your choosing. 

Importing Data into the Capped 9 Spreadsheet 

Follow the steps below to import your student data into the Capped 9 spreadsheet.

Open the Student Analysis Excel file you downloaded from Connect and navigate to the SPO – Grid Format sheet. 

Select and copy the entire contents of the SPO – Grid Format sheet, including the column headers. An easy way to do this it to click in the sheet, press Ctrl-A and then Ctrl-C to copy the entire contents of the sheet. 

Open the blank Capped 9 spreadsheet, then:

1. Navigate to the Raw Gradepoint sheet. 
   
2. Click on cell A1 (Student ID).
   
3. Right-click and select Paste Values to paste the copied data. 
   

Allow ~30 seconds for the data to import and formulas to update. The exact time will depend on the number of student records included. 

Viewing Capped 9 Results 

Once the import is complete, you can review the Capped 9 analysis using the following sheets: 

Results Sheet 

Displays each individual student’s: 

1. Literacy slot 
2. Numeracy slot 
3. Science slot 
4. Other six slots 
5. Total Capped 9 score 

Dashboard Sheet 

Shows average Capped 9 scores across different demographics, such as: 

1. All students 
2. Females/Males 
3. eFSM students 
4. Other defined groups

Notes and Troubleshooting 

1. Always use Paste Values when importing data to avoid formatting or formula issues. 
2. Do not edit formulas on calculated sheets, as this may affect results. 
3. If figures do not appear immediately, allow additional time for Excel to finish recalculating. 
4. This spreadsheet has been developed for current Year 11 students (25-26), Year 10 subjects have not been included in the spreadsheet. 

If you encounter any issues, incorrectly mapped subjects or have questions about the Capped 9 spreadsheet, please contact support@alps.education. 

• Related Articles

• Alps Guide Wales 25/26

  This guide is for Welsh schools/colleges. The purpose of this guide is to support colleagues in understanding the Alps methodology and the numbers sitting behind the data in Connect and Summit. Please click the link below to download:

• Average GCSE Scores

  Prior Attainment is crucial to your Alps analysis as it provides the baseline score from which we can measure your student progress. Without this baseline, we won’t be able to provide value-added analysis. This article will show you how to calculate ...

• Adding Welsh National Test Scores

  At Key Stage 4 in Wales, we use an average of the Year 8 Welsh National Test scores as Prior Attainment, or baseline, for your students. To add WNT scores, navigate to the Cohorts page found in the Data Management tab in the left menu. Click on the ...

• Using the Manual GCSE Score Calculator

  This article will show you how you can add and amend Average GCSE Scores for individual students. From the homepage, navigate to the Students page found in the Data Management tab in the left menu. In the Students screen you can view and edit your ...

• Student Value-Added (VAS)

  The Student VAS or Value Added Score is a quantitative measurement of how much progress an individual student has made over all subjects in relation to the aspiration at the 75th percentile. Currently, we calculate the Student VAS for A level and Key ...