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 use the data.
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.
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.
Yellow boxes indicate data that needs to be mapped or skipped.
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
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 ...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 ...Importing Teaching Data
Once the Student Data and Prior Attainment Data has been imported, you can then move onto importing your Teaching Data. This includes the subjects your students are studying, the teaching sets and teachers. You can only import one teaching set and ...Can't find a Subject
When you import subject information into Alps, either as Teaching Data or Grades Data, you will be asked to map your subjects to our Alps subject names. In the subject mapping step of any import, when you press the edit pencil to change your subject ...