Table of contents
Opening an individualised file
The following instructions apply for Microsoft Excel 2007, 2010, & 2013.
1. Open a new Microsoft Excel window and close the blank workbook which appears.
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.
Please note, if you have successfully opened the individualised file using Method 1, then you can ignore this section.
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.
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.