HESES10 re-creation funding worksheets

This page details how to re-create the funding worksheet data that are provided as part of our re-creation of Higher Education Statistics Survey (HESES) (the HESES10 re-creation) which we carry out for monitoring purposes. This information is aimed at those universities responsible for making student data returns.

The 'HESES10 re-creation funding worksheets' are tables provided in the HESES11 re-creation workbook.

It includes descriptions of how to re-create data using the individualised file for the funding worksheets listed in the table of contents below.

Further detail on the different types of FTE that contribute to the recalculation of 2011-12 WP and improving retention can be found in 'FTEs used for the re-calculated 2011-12 WP and improving retention allocations' (WPTESSFTE worksheet).

The figures shown in each of the reports are sourced from the HESES10 re-creation and the final 2010-11 individual grant tables. We may also use the final 2011-12 individual grant tables for WP and TESS re-calculations.


Table of contents

Report on adjustments to grant for 2010-11 using the HESES10 re-creation (HBK worksheet)

Funding conditional upon delivery of growth: Actual FTEs (HEFCE-fundable)

The students used to derive 'Actual FTEs (HEFCE-fundable)' can be identified by selecting:

  • HESEXCL = 0
  • HESCOMP = 4
  • HESTYPE = HOMEF, HOMEIF

'Actual FTEs (HEFCE-fundable)' can be found by summing HESESFTE and dividing by 100 for these students.

Medical and dental holdback: FTE from HESES10 re-creation

The students used to derive 'FTE from HESES10 re-creation' can be identified by selecting:

  • HESMED = 1
  • HESTYPE = HOMEF, HOMEIF
  • HESEXCL = 0
  • HESCOMP = 4

'FTE from HESES10 re-creation' can be found by summing HESESFTE and dividing by 100 for these students.

Student number control for 2010-11: Recruited numbers from Table 6 of HESES10 re-creation

The students used to derive 'Recruited numbers from Table 6 of HESES10 re-creation' can be identified by selecting SNCPOP = 1.

Recalculation of standard resource for 2010-11 using the HESES10 re-creation (STD worksheet)

2010-11 FTEs from HESES10 re-creation

'2010-11 FTEs from HESES10 re-creation' are identified by summing the FTE of students in each combination of length (LENGTH), level (HESLEVEL), mode (HESMODE) and price group. Examples of the assignment to different price groups are described below.

Price groupABCD
Example description HEFCE-funded, long, full-time undergraduates excluding foundation degrees assigned to price group A HEFCE-funded, long, full-time foundation degree students assigned to price group B HEFCE-funded, standard-length, full-time, sandwich year-out undergraduates excluding foundation degrees assigned to price group C HEFCE-funded, long, part-time taught postgraduates assigned to price group D
HESTYPE value HOMEF HOMEF HOMEF HOMEF
LENGTH value L L S L
HESMODE value FTS FTS FTS, SWOUT PT
HESLEVEL value UGX FD UGX PGT
HESCOMP value 4 4 4 4
HESEXCL value 0 0 0 0
How to identify the number of '2010-11 FTEs from HESES10 re-creation' (Sum of the values of FTEA) / 100 ((Sum of the values of FTEB) + (Sum of (FTEMEDIA x MEDIAB)) / 100 ((Sum of the values of FTEC) + (Sum of FTEMEDIA x MEDIAC)) / 100 ((Sum of the values of FTED) + (Sum of FTEMEDIA x MEDIAD)) / 100

Recalculation of assumed fee income for 2010-11 using the HESES10 re-creation (F10 worksheet)

2010-11 Estimated FTE students

To identify '2010-11 Estimated FTE students' from the individualised file, sum across HESFHC for the required level (HESLEVEL) and mode (HESMODE). For example, to replicate the '2010-11 Estimated FTE students' in the full-time postgraduate category, select: HESMODE = FTS HESLEVEL = PGT and sum HESFHC.

The 'UG' level consists of foundation degrees (HESLEVEL = FD) and undergraduate excluding foundation degrees (HESLEVEL = UGX).

Total fee income

To calculate 'Total fee income' for each combination of mode and level, sum across HESAFEE for the required level (HESLEVEL) and mode (HESMODE). For example, to replicate the 'Total fee income' in the part-time postgraduate category, select:

  • HESMODE = PT
  • HESLEVEL = PGT
  • sum HESAFEE.

The 'UG' level consists of foundation degrees (HESLEVEL = FD) and undergraduate excluding foundation degrees (HESLEVEL = UGX).

2010-11 FTEs from HESES10 re-creation

The students used to derive '2010-11 FTEs from HESES10 re-creation' can be identified for each combination of mode (HESMODE) and level (HESLEVEL) by selecting:

  • HESEXCL = 0
  • HESCOMP = 4
  • HESTYPE = HOMEF.

'2010-11 FTEs from HESES10 re-creation' can be found by summing HESESFTE and dividing by 100 for these students. This total will match the '2010-11 FTEs from HESES10 re-creation' total on the standard resource table (STD worksheet).

Re-calculated 2011-12 WP allocations based on FTEs from the HESES10 re-creation (WP worksheet) and Re-calculated 2011-12 improving retention allocation based on FTEs from the HESES10 re-creation (TESS worksheet)

The following elements are partially informed by the HESES re-creation. The WPTESSFTE worksheet provides the contribution of the HESES re-creation to these figures.

The WPTESSFTE worksheet contains the detailed breakdown of the '2011-12 Base FTEs' and the '2010-11 non-mainstream FTEs' as used in the Re-calculated 2011-12 WP allocations based on FTEs from the HESES10 re-creation (WP worksheet) and Re-calculated 2011-12 improving retention allocation based on FTEs from the HESES10 re-creation (TESS worksheet).

FT + SWOUT UG (inc. FD) base FTEs for 2011-12 (using HESES10 re-creation FTEs) plus 2010-11 non-mainstream FTEs (WP and TESS worksheets)

The 'HESES10 re-creation FTEs' element of this figure for full-time and sandwich year-out undergraduates is calculated by selecting:

  • HESTYPE = HOMEF
  • HESMODE = FTS, SWOUT
  • HESCOMP = 4
  • HESEXCL = 0
  • HESLEVEL = UGX, FD.

Sum HESESFTE and divide by 100 for these students.

PT UG (inc. FD) base FTEs for 2011-12 (using HESES10 re-creation FTEs) plus 2010-11 non mainstream FTEs (WP and TESS worksheets)

The 'HESES10 re-creation FTEs' element of this figure for part-time undergraduates is calculated by selecting:

  • HESTYPE = HOMEF
  • HESMODE = PT
  • HESCOMP = 4
  • HESEXCL = 0
  • HESLEVEL = UGX, FD.

Sum HESESFTE and divide by 100 for these students.

Base FTEs for 2011-12 (using HESES10 re-creation FTEs) plus 2010-11 non-mainstream FTEs (WP worksheet)

The 'HESES10 re-creation FTEs' element of this figure is calculated by selecting:

  • HESTYPE = HOMEF
  • HESCOMP = 4
  • HESEXCL = 0.

Sum HESESFTE and divide by 100 for these students. This total will match the '2010-11 FTEs from HESES10 re-creation' total on the standard resource table (the STD worksheet).

Page last updated 20 July 2012

Share this: