You need cookies enabled

HEFCE closed at the end of March 2018. The information on this website is historical and is no longer maintained.

Many of HEFCE's functions will be continued by the Office for Students, the new regulator of higher education in England, and Research England, the new council within UK Research and Innovation.

The HEFCE domain - www.hefce.ac.uk - will continue to function until September 2018. At this point we will close the site entirely and all its information will only be available from the National Web Archive.

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