You need cookies enabled

Cookies

You need cookies enabled

Opening an individualised file

Method 1

The following instructions apply for Microsoft Excel 2007, 2010, & 2013.

1. Open a new Microsoft Excel window and close the blank workbook which appears.

Opening an individualised file 1

2.

Opening an individualised file 2

3. The file will open in Excel as a 'comma separated variable' (csv) file, you must now split the variables into separate columns in Excel.

Opening an individualised file 3

4.

Opening an individualised file 4

5.

Opening an individualised file 5

6.

Opening an individualised file 6

 

Method 2

Please note, if you have successfully opened the individualised file using Method 1, then you can ignore this section.


1.

Opening an individualised file 7

2.

Opening an individualised file 8

3.

Opening an individualised file 9

4.

Opening an individualised file 10

5. The file will opin in Excel as a 'comma seperated variable' (csv) file, you must now sort the variables to the columns in Excel.

Opening an individualised file 11

‌6.

Opening an individualised file 11

7.

Opening an individualised file 7

8.

Opening an individualised file 14

 

‌Formatting

Changing cell format

When you open an individualised file, some fields may not show the correct format (for example, the number 968001002 may look like '9.64E+08'). To obtain the string of numbers as originally returned follow these steps:

1. Highlight the column containing the field you wish to format.

2. Right click on the highlighted cells and select ‘Format Cells…’.

3. Select the Category to be ‘Number’, and the number of Decimal Places ‘0’.

4. Press ‘OK’.                  

Using an individualised file (an example)

Once you have opened your individualised file, for example, if you would like to filter to the records that generate the figures in column 1(a) of Table 2 for Other UG students you would apply the below filters:

  • HEAPESPOP= 1 (Records in the HEAPES population)
  • HEAPREG= 1 (Students who registered prior to the 2nd November, i.e. column 1)
  • HEAPGRADE= 'EXEMPT' (Students in the exempt population)
  • HEAPLEV= 'OTHER_UG' (Students on an other undergraduate course)

More examples can be found in the AP technical documents.

Page last updated 13 August 2015

Related content