Mapping Columns

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.

column_headers.png

During the import however, you will need to map the columns in your spreadsheet to Alps columns so that the application can use the data.

map_columns.PNG

Each box represents a column of data in your spreadsheet, so to map your columns, click the Map button on each, and select the appropriate Alps column from the dropdown.

Column_Mapping_Gif.gif

Some columns will need to be skipped, and some may be recognised automatically. In the example below I have mapped the columns in green, and I can map or skip my column in blue that I am editing.

mapped.PNG

Yellow boxes indicate data that needs to be mapped or skipped.

skipped.PNG

Once you have imported your data, you can click Save for Later at any time and return to your import later.

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

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

    • Subject mapping

      Within any import containing subjects, you will have to map your subject names to Alps subjects. Subject mapping is required within any grades import, teaching data or personalised targets import. Once you have mapped your subjects however, your ...

    • The Series Column

      KS4 Performance measures are a recent addition to the analysis available in Alps Connect with KS5 Performance measures also scheduled for release in due course. Within the import wizard of gradepoints there is now the option to import a new field - ...

    • Setting up your Year Group - KS4 and KS5 Schools in England

      Step 1: Rolling Over Existing Student Data If you have existing student data from the previous year, you can roll this over into your current year. You cannot roll-over Y13 or Y11 data, but please feel free to roll-over Y12 into Y13 and Y10 into Y11. ...