Adding Custom Columns

Adding Custom Columns

As standard, Connect allows the import of Gender, Ethnicity, Disadvantage, SEND and EAL. If you have data types other than the standard fields, you can import these as Custom Columns, which you can then use to filter and analyse your data. 

Custom Columns allow you to import your own filter categories and define the values you wish to use. Other users can then use these in the filter drop-downs in the Connect analysis zones to drill down into your data. Some common categories used are 'Attendance', 'Feeder School', 'New to Sixth' and ‘Age Range.’ You can add Custom Columns when importing your student data for the first time, or at any point throughout the year and you can edit the data at any time.

Import Custom Columns for New Year Group

The screenshots below take you through the import for adding attendance as a Custom Column, but the process is the same for any custom data you wish to upload. If you are uploading a new year group into Connect, include your Custom Column(s) in the Excel file you are going to upload. Here is an example: 

From the Connect homepage, navigate to the Cohorts screen, found in the Data Management tab. In the Cohorts screen select + Year Group under the relevant academic year. The wizard will open and walk you through uploading your file. Once you get to step 5, Column Mapping, your custom column will appear in yellow as 'Unmapped'. Click the red Map button:



Then in the drop-down menu, select (Create New Custom Column):



Then click Save:



Then the box will turn green when it has been mapped and you can finish your import:



Please note you will need to republish any existing Gradepoints to update them with your Custom Columns. 

Adding Attendance to an Existing Year Group

If you have already set up your year group in Connect, but wish to add a Custom Column, please follow the steps in the video below: 



Please note that you will need to republish any existing Gradepoints to update them with your Custom Columns. 
    • Related Articles

    • Summit Custom Columns

      In Alps Connect and Summit, we have pre-defined fields for the following contextual Student Data: Gender, Disadvantage, Ethnicity, EAL, SEND. If there are other fields that you would like to use to filter your analysis, you can set these up as Custom ...
    • Importing Student Data

      To set up a new year group in Connect, you can export your MIS data to excel and upload it into the Connect Data Management area. Please note the process for importing Student Data is the same for KS4 and KS5, the only difference being the Prior ...
    • Roll Over Student Data

      Before a new academic year begins, you can save time by rolling-over your existing student data from the current year into the next academic year. In Connect, the new academic year is typically launched at the start of July for you to populate with ...
    • Summit Custom Comparisons

      In Summit, you can use existing contextual Student Data fields to build a custom group of students, for example female high prior attainers. Our standard contextual fields include the following: Gender, Disadvantage, Ethnicity, SEND, EAL and Prior ...
    • Editing Student Data

      If you need to edit your existing Student Data, you can do so by either editing individual students or uploading data in bulk. For example, you may wish to edit individual data if a student has left your college/school, or you could do a bulk upload ...