The Series Column

The Series Column

The series column is an additional column you can add into your in-year monitoring data and end of year exam results.

The series information is the season when the student is going to be sitting their final examinations e.g Summer 2025. 

This is what the data needs to look like in your Excel file before you import it:


If you do not include the series data, then the import wizard will tell you that you have missing values.

To fix these errors, you need to click on the 'Select Value' option on the drop-down menu and then choose the appropriate season from the available options. 
If you take a look at the bottom right-hand corner of the screenshot below, you will notice that you won't be able to move on with the import until you have fixed these errors. 


Once you have chosen the appropriate season, it should look like the screenshot below, and you'll be able to move on with the import:



    • Related Articles

    • Grade Errors

      This article will show you some common grade errors that you may come up against when importing grades data into Alps. Invalid Subject Mapping This error can occur when you have chosen the incorrect subject in the subject mapping step that doesn't ...
    • 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 ...
    • 'Record was not matched' - how to fix mismatching student ID numbers

      This is a common reason why you might be unable to publish data and import to Connect Interactive / report. Connect Data uses Student ID numbers to link your Cohort and Grades, so if the IDs do not match, the software will be unable to create your ...
    • Subject Value Added Overview

      This is often the best place to start each August / September on your improvement journey. The table provides an overview of how the progress of students in each subject compares to progress made in that subject nationally. On this page you can ...
    • Students not included in Key Indicator Calculations

      Value added progress cannot be calculated for students without a prior achievement score. The Alps report will show you the individual students did not have a prior achievement score in the data file you submitted to Alps. Please check that these are ...