Adding custom columns

Adding custom columns

Adding custom columns to your Student Information allows your colleagues to filter by categories that you define. As standard, Alps allows the import of Disadvantage, Ethnicity and Gender columns, with categories that we define and that are validated.

Custom columns allow you to import your own filter categories, and define the values you wish to use. Your colleagues can use these to filter in Connect Interactive and produce analysis based upon the different categories you define. Some common categories used are 'Feeder School', 'SEND' and ‘Age Range’ – this final one is particularly helpful for FE Colleges. For more information about how you can use filters and custom groups to create your analysis, please see our article on multilevel filters and comparisons.

You can add custom columns when importing your student data for the first time, or at any point throughout the year. Remember that you will need to republish any existing Gradepoints to add custom columns to existing data. Any further imports will have the custom column as a column mapping option, and you will be able to populate the custom columns for a new student when using the Quick Add Student function.

 

Adding custom columns when setting up your Year Group

If you are setting up your Gradepoint, include your custom column(s) in your student import file that you will import using the + Add Year Group wizard.

CC.png

When mapping your columns in Step 4 of the wizard, you can select New Custom Column. This gives you the opportunity to name your column.

Custom_Column_mapping_2.gif

 

Adding custom columns to an existing Year Group

If you have already set up your Year Group and wish to add a custom column, you will need to first prepare your data in Excel, including the Student ID used in your Year Group, and the custom column(s) you wish to import.

Go to the Students page in Connect Data, and click on the Year Group you wish to add the custom column to. Click on Import Additional Data and choose Update and merge.

import_add_data.PNG

update_and_merge_1.PNG

Choosing this option will add the column to your data without deleting any of the existing data. Choose the + Student Data option, and proceed through the wizard, importing your prepared Excel file.

The only data you need for the import are the student IDs and custom columns

CC.PNG

When you map your columns, you will need to map Student ID, and to create your custom column, click on Map and choose the option (create new custom column). You will then have the option to rename your column.

custom_columns.gif

Once you have completed the import, you will be able to see your custom columns in the Edit Student window, accessible by clicking on the pencil icon next to each student in the Students screen.

edit_student_model.PNG

Once you have added your custom columns, remember to go to the Gradepoints page and republish any Gradepoints affected by the addition.


    • Related Articles

    • Managing Custom Columns

      In Connect Data, we have now added a section underneath the Connect Data Settings that will allow you to edit and delete custom columns that you have imported via the student data import wizard.  For guidance on importing custom columns, please click ...
    • Getting the most from the High Middle and low prior attainment filter

      This video takes you through how to apply the High, Mid and Low comparison filter across the subject overview page in Connect  ​​​ The high, middle and low prior attainment comparison is available across all key stages and qualification types. The ...
    • Exporting data from SIMS

      This article give step by step instructions for SIMS schools using our report definitions to extract their Student Information, Teaching Sets and Exam Results. Importing the report definitions Running the reports Adding extra data – Student ...
    • Editing student data

      This article will show you how to make edits to the student data you have imported. You can make edits individually, using the Edit Student screen, or in bulk, using either merge or overwrite. Editing individual students Bulk updates – merge and ...
    • Mapping Columns

      Import files do not need to have headings with specific names, and the columns of data do not need to be in a specific order. During the import however, you will need to map the columns in your spreadsheet to Alps columns so that the application can ...