Compass - Exporting

Step 1

Log in to Compass as an administrator.

Step 2

Click on the pencil icon and then select 'semester reports'.

Step 3

Click on the semester you wish to export.

Step 4

Click on the ‘exports’ button and choose ‘All Results' (choose 'OK' when it suggests this could take a while — it never takes as long as they suggest unless your school is very large).

Step 5

The file will then export, and most likely will be saved to your downloads folder (depending on the settings of your computer).

Step 6

Open the Excel file

Step 7

Insert two blank columns to the left of the column labelled 'StudentFirst'. Then label these new columns 'Year' and 'Semester' as seen below. (Please make sure these words are capitalised.)

Step 8

Then input the year and semester into the first two rows.

Step 9

Next, highlight those four cells and move your mouse to the bottom right-hand corner of the highlighted cells, until you notice your mouse icon changes to a black cross. Once this happens, double click your mouse. The data should now fill down to the last student in the file.
If this does not work, you should alternatively be able to hold and drag your mouse down until you reach the last student, and this should copy the year/semester all the way down to the bottom row of student data.

Step 10

Save the file ready for uploading.

Step 11