Managing Custom Columns

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. 

custom_columns_.png

For guidance on importing custom columns, please click here.

The current name, values and academic year of the custom columns will be displayed in this section:

manage_custom_columns.PNG

To edit a custom column, click the edit button:

edit_button.PNG

To delete a custom column, click the trash bin icon:

trash_bin.PNG

You can edit the name of a custom column:

custom_column_name_change.png

You can add new values to your custom column. Simply type your new value into the text box and select 'Add':

adding_new_value_to_cust_column.png

You can also delete values from a custom column. Simply click the trash bin icon on the far right hand side of the edit custom column window:

delete_custom_column_values.png

Once you have finished editing your custom column, be sure to save your changes by clicking 'Save Custom Column':

save_cust_columns_3.png

Once you have saved your changes, the changes will then appear on the custom column summary bar:

new_values_.png

Finally, click 'Save Custom Columns' in the bottom right hand corner of your screen to save all of the changes you have made.

save_cust_columns_2.png

You can export these custom columns alongside your student data, from the students section in Connect Data. Simply click 'Export' above the year group summary bar:

export.png

Make sure you have your student data ticked, and then click 'Export to Excel':

export_to_excel.PNG

As you can highlighted below, my custom column has exported alongside my student data:

exported.png

 

 

 

 

 

 

    • Related Articles

    • 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, SEND, EAL and Gender columns, with categories that we define and that ...

    • 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 ...

    • Manage Settings section - Creating Custom comparison groups

      You can now use multiple comparison categories to create groups in your subject, teaching set and student analysis, including any custom groups you have added. You will be able to create several of these comparison groups to view on one screen. You ...

    • 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 ...

    • Changing subject mappings

      Using the Overwrite & replace option, it is possible to update a subject mapping. Using Overwrite & replace will also remove the incorrect subject. Alternatively, you can change subjects one-by-one for individual students. Editing subjects for ...