Accessing the Capped 9 Spreadsheet - January 2026

Accessing the Capped 9 Spreadsheet - January 2026

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

Shape 

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.

A screenshot of a computer AI-generated content may be incorrect.


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

A screenshot of a computer AI-generated content may be incorrect.


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. 


A screenshot of a computer AI-generated content may be incorrect.

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. 

A screenshot of a computer AI-generated content may be incorrect.


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. 

A screenshot of a computer menu AI-generated content may be incorrect.


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. 
Important: Only the subjects listed in the Subject Mappings sheet linked below can be mapped within the Capped 9 spreadsheet. If your school teaches a subject that does not appear in this list, it cannot be mapped and will not be recognised by the Capped 9 formula. This may result in discrepancies in individual student scores and in the headline measures shown on the Dashboard sheet.

Before importing your data, we recommend checking the subjects in your Gradepoint against the list below. If a subject you teach is missing, please contact support@alps.education so we can advise.