Ilr funding and monitoring data 2014-15: funding summaries



Download 174.45 Kb.
Date28.05.2018
Size174.45 Kb.
#51631

ILR funding and monitoring data 2014-15: funding summaries

ILR data for the 2016-17 targeted allocations for access, disability and retention: technical document




Purpose


  1. This document details the algorithms applied to the 2014-15 ILR R14 data which may be used to calculate the 2016-17 targeted allocations for access, disability and retention.




  1. This document is aimed at readers with in-depth knowledge of the ILR data. Readers are advised to have a copy of the ‘Specification of the Individualised Learner Record for 2014 to 2015’ (available from https://www.gov.uk/government/publications/ilr-specification-validation-rules-and-appendices-2014-to-2015) to hand when using this document.



2014-15 ILR fields used in the targeted allocations for access, disability and retention algorithms


  1. Only certain fields, detailed in Table 1, are used to generate the derived fields for access, disability and retention.




  1. Throughout this document, fields taken or derived from the ILR return are shown in capitals using the names given in Tables 1 and 2 respectively.



Using the individualised file


  1. When working through this document it is necessary to use the individualised file SO14_FXXXXXXXX.ind, where XXXXXXXX is the UK Provider Reference Number (UKPRN) for your college. Details of how to access this file are given on the HEFCE web-site (www.hefce.ac.uk/data/famd/help/output/). The file will show the allocation of students to cells within the tables and, where relevant, details of why they were excluded from the access, disability and retention populations.



Table 1 ILR fields which may inform the targeted allocations for access, disability and retention





Description

Name

Data entity

Column in individualised file*

Date of birth

DATEOFBIRTH

Learner

I

Country of domicile

DOMICILE

Learner

J

Additional learning support

LEARNFAMCODE_DLA

Learner

L

Learner reference number

LEARNREFNUMBER

Learner

B

Home postcode

POSTCODEPRIOR

Learner

K

UK provider reference number

UKPRN

Learner

A

Unique learner number

ULN

Learner

AE

Learning aim data set sequence

AIMSEQNUMBER

Learning aim

C

Learning aim reference

LEARNAIMREF

Learning aim

M

Learning planned end date

LEARNPLANENDDATE

Learning aim

H

Learning start date

LEARNSTARTDATE

Learning aim

G

Major source of tuition fees for the learner

MSTUFEE

HE

N

Student instance identifier

NUMHUS

HE

D

Qualification on entry

QUALENT3

HE

AF

* The individualised file SO14_FXXXXXXXX.ind, downloadable from the HEFCE extranet. (See www.hefce.ac.uk/data/famd/help/output/)

Description of derived fields


  1. This section provides details of the derived fields in the individualised data file. These fields may be used in calculating the targeted allocations for access, disability and retention.



Table 2 Derived fields which may be used to inform the targeted allocations for access, disability and retention allocations





Field name

Description

Paragraph

Column in individualised file*

SO allocation(s) used in

DISALLOC

Inclusion in numerator of disability allocation proportion

11

P

Dis

DISPOP

Inclusion in denominator of disability allocation proportion

10

O

Dis

EQGRP

Entry qualification risk group

33-35

AJ

IR

EQPOP

Indicates students in the population for the full-time improving retention allocation

31

AI

IR

EXCLPC

Indicates whether postcode was mapped to census data

16

U

WA

HEFCOMP

HEIFES completion of year of programme of study indicator

42

AC

WA/IR

HEFESFTE

FTE for the year of programme of study

36

Y

Dis

HEFEXCL

Reason for exclusion from the HEIFES re-creation

53

F

Dis/WA/IR

HEFLEVEL

Level of study

21

Z

Dis/WA/IR

HEFMODE

Mode of study

20

AA

Dis/WA/IR

HEFQAIM

Recognised as HE qualification aim

19

AD

Dis/WA/IR

HEFTYPE

Fundability status

24

AB

Dis/WA/IR

HIGHQUAL

Indicates students who have previously obtained their qualification aim or a higher qualification aim

15

V

WA

PGDSA

Postgraduate DSA eligibility

9

R

Dis

SOENTQUAL

Grouping of the student’s highest qualification on entry

30

NOT SHOWN

IR

SOENTRANT

Students in their first year of programme of study

12

W

WA

SOENTRYAGE

Student’s age on commencement of programme of study

13-14

X

WA/IR

SOGRADECOMB

Categorises students with A‑levels on entry according to the highest grades for these qualification types.

26-29

NOT SHOWN

IR

SOLINK

A link has been made to another data source.

19-23

AG

IR

SOLINKAGE

Student’s age in years on 31 August 2014

24

AH

IR

SOTARIFF

Our formulation of students’ UCAS tariff points from NPD and ILR data.

25

NOT SHOWN

IR

STUBID

Unique year of programme of study identifier

17

E

Dis/WA/IR

UGDSA

Undergraduate DSA eligibility

8

Q

Dis

UGLEVEL

Indicates whether student is aiming for a first degree

32

AK

IR

WAPOP

Indicates inclusion in a widening access population

17

S

WA

WAQUIN

Participation or educational attainment quintile of student in widening access population

18

T

WA

* The individualised file SO14_FXXXXXXXX.ind, downloadable from the HEFCE extranet (see www.hefce.ac.uk/data/famd/help/output/).
The algorithms for deriving these fields are given in ‘HEIFES14 re-creation algorithms’ (see the ‘HEIFES14 re‑creation technical document’); the paragraph references refer to this document.
Dis = Student opportunity allocation for disabled students, WA = Widening access for students from disadvantaged backgrounds, IR = Improving retention.


  1. Institutions may wish to use the ‘Credibility’ sheet in the SO14_FXXXXXXXX.xlsx workbook which may highlight data quality issues relating to the ILR fields used in the student opportunity algorithms to inform amendments.



Improving provision for disabled students

UGDSA (Column Q)


  1. The UGDSA field indicates the Disabled Students’ Allowance (DSA) eligibility status for undergraduates, including students on Postgraduate Initial Teacher Training courses.




Value

Description

Definition

1

Undergraduate eligible for DSA


DOMICILE = XF, XG, XH, XI, XK and

(HEFLEVEL = UG or HEFQAIM = PGCE) and

MSTUFEE ≠ 31 and
(HEFMODE = FTS or
(HEFMODE = PT and ((LEARNSTARTDATE < 1 September 2012 and HEFESFTE ≥ 50) or (LEARNSTARTDATE ≥ 1 September 2012 and HEFESFTE ≥ 25))))


0

Otherwise

Otherwise



PGDSA (Column R)


  1. The PGDSA field indicates the DSA eligibility status for postgraduates, excluding students on Postgraduate Initial Teacher Training courses.




Value

Description

Definition

1

Postgraduate eligible for DSA


DOMICILE = XF, XG, XH, XI, XK and
HEFLEVEL = PGT, PGT_UGF and HEFQAIM ≠ PGCE and

MSTUFEE ≠ 11, 12, 13, 14, 15, 16, 17, 18, 19, 31 and



(HEFMODE = FTS or
(HEFMODE = PT and ((LEARNSTARTDATE < 1 September 2012 and HEFESFTE ≥ 50) or (LEARNSTARTDATE ≥ 1 September 2012 and HEFESFTE ≥ 25))))

0

Otherwise

Otherwise



DISPOP (Column O)


  1. The DISPOP field indicates whether the student is included in the denominator of the disability allocation proportion.




Value

Description

Definition

1

Included in the denominator of the disability allocation proportion

HEFCOMP = 4 and HEFEXCL = 0 and
HEFTYPE = HOMEF and
(UGDSA = 1 or PGDSA = 1)

0

Otherwise

Otherwise



DISALLOC (Column P)


  1. The DISALLOC field indicates whether the student is included in the numerator of the disability allocation proportion.




Value

Description

Definition

1

Included in the numerator of the disability allocation proportion

DISPOP = 1 and LEARNFAMCODE_DLA = 1

0

Otherwise

Otherwise



Widening access for student from disadvantaged backgrounds

SOENTRANT (Column W)


  1. The SOENTRANT field identifies students in their first year of programme of study.




Value

Description

Definition

1

Entrant

LEARNSTARTDATE ≥ 1 August 2014

0

Otherwise

Otherwise



SOENTRYAGE (Column X)


  1. The SOENTRYAGE field contains the student’s age at the commencement of the programme of study. This is the number of full years between DATEOFBIRTH and LEARNSTARTDATE.




  1. Where DATEOFBIRTH or LEARNSTARTDATE are missing, SOENTRYAGE will be set to zero.



HIGHQUAL (Column V)


  1. The HIGHQUAL field indicates whether or not the student has previously obtained their qualification aim or a higher qualification aim.




Value

Description

Definition

1

Student has not previously obtained their qualification aim or a higher qualification aim

((QUALENT3* = J and HEFQAIM = FIRST)

or

(QUALENT3* = C (except C90) and



HEFQAIM = FIRST, DIPHE, CERTED,

FOUDEG, FDBC, DET, DTLLS, HND) or

(QUALENT3 = C90 and HEFQAIM = FIRST,

DIPHE, CERTED, FOUDEG, FDBC, DET, DTLLS, HNC, HND) or

QUALENT3* = P, Q, R, X (except X04, X06))


0

Otherwise

Otherwise

*The first character of QUALENT3 is used.

EXCLPC (Column U)


  1. The EXCLPC field indicates whether the student’s home postcode (POSTCODEPRIOR) has been excluded from the mapping to 2001 census ward data. Postcodes are excluded if our analysis indicates they are unreliable for participation measurement (typically institutions such as boarding schools), they are marked as non-geographic postcodes in the ONS National Statistics Postcode Directory, or where no link to 2001 census ward data is possible.




Value

Description

Y

Excluded from mapping to 2001 census ward data

N

Included in mapping to 2001 census ward data


WAPOP (Column S)


  1. The WAPOP field indicates whether the student is included in either the young full-time, mature full-time or part-time widening access allocation population.




Value

Description

Definition

1

Included in young full-time widening access allocation population

EXCLPC = N and
DOMICILE = XF, XG, XH, XI, XK and

HEFTYPE = HOMEF and HEFCOMP = 4 and

HEFEXCL = 0 and SOENTRYAGE < 21 and

SOENTRANT = 1 and HEFLEVEL = UG and HEFMODE = FTS



2

Included in mature full-time widening access allocation population

EXCLPC = N and
DOMICILE = XF, XG, XH, XI, XK and

HEFTYPE = HOMEF and HEFCOMP = 4 and

HEFEXCL = 0 and SOENTRYAGE ≥ 21 and

SOENTRANT = 1 and HEFLEVEL = UG and

HEFMODE = FTS


3

Included in the part-time widening access allocation population

EXCLPC = N and
DOMICILE = XF, XG, XH, XI, XK and

HEFTYPE = HOMEF and HEFCOMP = 4 and



HEFEXCL = 0 and SOENTRANT = 1 and
HEFLEVEL = UG and HEFMODE = PT

0

Otherwise

Otherwise



WAQUIN (Column T)


  1. The WAQUIN field indicates:

    1. For students in the young, full-time widening access population (WAPOP = 1): the young higher education participation rate (POLAR3) quintile of the student’s 2001 census ward. Values are 1 to 5, with 1 being the quintile of lowest participation rate.




    1. For students in the mature, full-time widening access population (WAPOP = 2) or part‑time widening access population (WAPOP = 3): the educational attainment quintile of the student’s 2001 census ward (defined as the proportion of 16-74 year olds qualified to HE level). Values are 1 to 5, with 1 being the quintile of lowest educational attainment. Note that part-time and mature full-time students who already hold a higher education qualification at the same level as, or higher than, their current qualification aim, or have unknown entry qualifications (HIGHQUAL = 0), are given a quintile value of 5, irrespective of their postcode.


Improving retention

Linking to other data sources


  1. As the TOTALTS field in the ILR is no longer required for 2014-15 we have linked ILR data with other data sources (any provider’s ILR data and schools’ National Pupil Database (NPD) data) to derive students’ UCAS tariff points and Level 3 grade combinations for the purposes of assigning them to full-time improving retention risk groups for the 2016-17 SO allocations.

  2. We link to ILR and NPD data from 2002-03 to 2013-14 inclusive to find prior qualifications and grades achieved for students recorded in the 2014-15 ILR return. We link to ILR and NPD data by combinations of first name(s), surname, date of birth, gender and (where available) home postcode and prior educational establishment (that is, the equivalent data linking method that HESA adopt for UK Performance Indicators). Spelling errors and other typographical errors (e.g. in dates) are taken into account. The SOTARIFF, SOGRADECOMB and SOENTQUAL fields are currently not displayed in the individualised file (SO14_FXXXXXXXX.ind). We are considering the data protection implications and at a later date may conclude that we can add some (or all) of these fields to the individualised file.

  3. Links to other data sources were not included in the SO14_WF_FXXXXXXXX.xlsx web facility outputs, so we assumed a blank value for SOTARIFF for every record. Students will now be assigned to a risk group if we have been able to make a link between your 2014-15 ILR data and other data sources, which may have changed your calculated funding allocation.

  4. We have aligned the algorithms in paragraphs XX-XX as much as possible to the equivalent algorithms used to calculate 2016-17 SO allocations for higher education institutions (HEIs) from the Higher Education Statistics Agency (HESA) student record (available from: www.hefce.ac.uk/data/famd/latest/).These algorithms are closely aligned to those used in the UK Performance Indicators (UKPIs) in Higher Education for non-continuation, available from https://www.hesa.ac.uk/pis/defs#entryquals.

SOLINK (Column AG)

  1. The SOLINK field indicates whether a link to other data sources was made for the purpose of calculating tariff points.

Value

Description

Definition

1

A link has been made to establish tariff points

Link to other data sources has been made

0

Otherwise

Otherwise


SOLINKAGE (Column AH)


  1. The SOLINKAGE field indicates the student’s age in years on 31 August 2014. This is the number of full years between DATEOFBIRTH and 31 August 2014.



SOTARIFF (NOT SHOWN)


  1. The SOTARIFF field shows the number of UCAS tariff points that are generated by the student’s entry qualifications, as derived from linked data. It is calculated using the same method as the HESA derived field XTARIFF for 2014-15. The full specification for XTARIFF in 2014-15 can be found on HESA’s website at: www.hesa.ac.uk/C14051/Derived_field_specifications. SOTARIFF is capped at 9998.



SOGRADECOMB (NOT SHOWN)


  1. The SOGRADECOMB field categorises students, where the student has A-levels on entry, into groups according to the highest grades for these qualification types.



  1. Where qualifications for the student have identical subjects, we identify the qualification type which results in the highest value of tariff points and discard those duplicates with a lower value of tariff points.



  1. Hashes and lower case letters are stripped out from qualification grades as they do not affect the assignment of tariff points so can be disregarded for the purposes of this calculation.



  1. Where a 'double-award' is taken each of the two grades is treated separately. Likewise where an A‑level and an AS‑level are treated as a combined award each of the two grades is treated separately as an A‑level and AS‑level respectively.



Value

Description

Definition

ACC_BBC+

Student’s highest A-level grades are at least ACC or BBC

Student has at least 3 A-levels or vocational A-levels of which the highest grades are in the following combinations:

(A*, A*, A*); (A*, A*, A); (A*, A, A); (A, A, A); (A*, A*, B); (A*, A, B); (A, A, B); (A*, A*, C); (A*, A, C); (A, A, C); (A*, B, B); (A, B, B); (A*, B, C); (A, B, C); (B, B, B); (A*, C, C); (A, C, C); (B, B, C)



BCC_CCC

Student’s highest A-level grades are BCC or CCC

Student has at least 3 A-levels or vocational A-levels of which the highest grades are in the following combinations:

(B, C, C); (C, C, C)



OTHER

Otherwise

Otherwise


SOENTQUAL (NOT SHOWN)


  1. The SOENTQUAL field contains the group of the student’s highest qualification on entry.

Value

Description

Definition

HEPG

HE: Postgraduate

QUALENT3 = DUK, DZZ, D80, MUK, M41, M44, M71, M80, M90, MZZ, H71

HEFD

HE: First degree

QUALENT3 = M2X, HUK, HZZ, H11, JUK


HEOUG

HE: Other undergraduate

QUALENT3 = H80, J10, J20, J30, J48, J80, C20, C30, C44, C80, C90

FOU

Foundation course

QUALENT3 = J49

L3_COMB

Level 3 qualification with combinations of A-levels

SOGRADECOMB ≠ OTHER and not above

BACC

Baccalaureate

(QUALENT3 = P62, P63 or linked data indicates an International Baccalaureate (IB) that attracts tariff) and not above

BTEC

BTEC

Linked data indicates a Level 3 BTEC

and not above



ACCESS

Access course

(QUALENT3 = X00, X01 or linked data indicates an Access to HE Diploma) and not above

OTH3_TAR

Other Level 3 qualifications (generally expected to be included in the tariff)

(SOLINK = 1 or QUALENT3 = P47, P50, P54, P64, P65, P68, P69, P91, P93, P94) and not above

OTH3_POSSTAR

Other Level 3 qualifications (may or may not be included in the tariff)

QUALENT3 = P41, P42, P46, P80 and not above

OTH3_NOTAR

Other Level 3 qualifications (not generally expected to be included in the tariff)

QUALENT3 = P51, P53, P70, P92 and not above


NONE

No formal qualifications

QUALENT3 = X02, X03, X05 and not above

OTHER

Other qualifications

QUALENT3* = Q, R and not above

UNKNOWN

Unknown entry qualifications

Otherwise

* The first character of QUALENT3 is used

EQPOP (Column AL)


  1. The EQPOP field indicates whether the student is included in the full-time improving retention allocation population.

Value

Description

Definition

1

Included in full-time improving retention allocation population

HEFCOMP = 4 and

HEFEXCL = 0 and


DOMICILE = XF, XK and

HEFTYPE = HOMEF and


HEFLEVEL = UG and

HEFMODE = FTS, SWOUT

and not excluded due to the reasons below


0

Not included in the full-time improving retention population: 30 years old on or before 31 August 2014 and have Level 3 qualifications that we would expect to generate tariff points

SOLINKAGE ≥ 30 and

SOENTQUAL = OTH3_TAR, OTH3_POSSTAR



0

Not included in the full-time improving retention population: Less than 30 years old on 31 August 2014 and have Level 3 qualifications but we have not been able to make a link

SOLINKAGE < 30 and

SOENTQUAL = OTH3_TAR, OTH3_POSSTAR and SOLINK = 0



0

Not included in full-time improving retention allocation population: otherwise

Otherwise


UGLEVEL (Column AK)


  1. The UGLEVEL field splits undergraduate students into those aiming for a first degree and other undergraduates.



Value

Description

Definition

OUG

Other undergraduate

HEFLEVEL = UG and

HEFQAIM = DIPHE, CERTED, FOUDEG, FDBC, DET, DTLLS, HNC, HND, UGOTHER



FIRST

Undergraduate aiming for a first degree

HEFLEVEL = UG and HEFQAIM ≠ OTHER and not above

OTHER

Not an undergraduate

Otherwise


EQGRP (Column AM)


  1. The EQGRP field holds the entry-qualification risk group the student was assigned to.



  1. For those aiming for a first degree (UGLEVEL = FIRST), the assignment to risk groups is as follows:



Value

Description

Definition

Y_F_L

Young, first degree,

low risk


UGLEVEL = FIRST and SOENTRYAGE < 21 and

(SOENTQUAL = L3_COMB, HEPG, HEOUG, HEFD, BACC

(SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and SOTARIFF ≥ 291))


Y_ F_M

Young, first degree, medium risk

UGLEVEL = FIRST and SOENTRYAGE < 21 and

((SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and (101 ≤ SOTARIFF ≤ 290 or SOTARIFF = 0))

or SOENTQUAL = FOU)

and not above



Y_ F_H

Young, first degree, high risk

UGLEVEL = FIRST and SOENTRYAGE < 21 and

((SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and 1 ≤ SOTARIFF ≤ 100) or

SOENTQUAL = ACCESS, BTEC, OTHER, NONE)

and not above



Y_F_U

Young, first degree, unknown

UGLEVEL = FIRST and SOENTRYAGE < 21 and not above

M_ F_L

Mature, first degree,

low risk


UGLEVEL = FIRST and SOENTRYAGE ≥ 21 and

((SOENTQUAL = L3_COMB and SOGRADECOMB = ACC_BBC+) or

(SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and SOTARIFF ≥ 261) or

SOENTQUAL = HEPG, HEOUG, HEFD)



M_ F_M

Mature, first degree, medium risk

UGLEVEL = FIRST and SOENTRYAGE ≥ 21 and

((SOENTQUAL = L3_COMB and SOGRADECOMB = BCC_CCC) or

(SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and SOTARIFF ≤ 260) or

SOENTQUAL = BACC, ACCESS, FOU)

and not above


M_ F_H

Mature, first degree, high risk

UGLEVEL = FIRST and SOENTRYAGE ≥ 21 and

SOENTQUAL = BTEC, OTHER, NONE

and not above


M_ F_U

Mature, first degree, unknown

UGLEVEL = FIRST and SOENTRYAGE ≥ 21 and not above



  1. For other undergraduates (UGLEVEL = OUG), the assignment to risk groups is instead as follows:



Value

Description

Definition

Y_O_L

Young, other undergraduate,

low risk


UGLEVEL = OUG and SOENTRYAGE < 21 and

(SOENTQUAL = L3_COMB, HEPG, HEOUG, HEFD or

(SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and SOTARIFF ≥ 291))


Y_ O_M

Young, other undergraduate, medium risk

UGLEVEL = OUG and SOENTRYAGE < 21 and

((SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and 161 ≤ SOTARIFF ≤ 290) or

SOENTQUAL = BACC, FOU, ACCESS)

and not above



Y_ O_H

Young, other undergraduate, high risk

UGLEVEL = OUG and SOENTRYAGE < 21 and

((SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and SOTARIFF ≤ 160) or

SOENTQUAL = BTEC, OTHER, NONE)

and not above



Y_O_U

Young, other undergraduate, unknown

UGLEVEL = OUG and SOENTRYAGE < 21 and not above

M_ O_L

Mature, other undergraduate,

low risk


UGLEVEL = OUG and SOENTRYAGE ≥ 21 and

(SOENTQUAL = L3_COMB, HEPG, HEOUG, HEFD, ACCESS or

((SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and SOTARIFF ≥ 161) )


M_ O_M

Mature, other undergraduate, medium risk

UGLEVEL = OUG and SOENTRYAGE ≥ 21 and

((SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and 1 ≤ SOTARIFF ≤ 160) or

SOENTQUAL = FOU)

and not above



M_ O_H

Mature, other undergraduate, high risk

UGLEVEL = OUG and SOENTRYAGE ≥ 21 and

(SOENTQUAL = BACC, BTEC, OTHER, NONE or

(SOENTQUAL = OTH3_TAR, OTH3_NOTAR, OTH3_POSSTAR and SOTARIFF = 0))

and not above



M_ O_U

Mature, other undergraduate, unknown

UGLEVEL = OUG and SOENTRYAGE ≥ 21 and not above



Re-building the 2016-17 SO allocation using the individualised file


The downloadable document ‘Detailed 2016-17 SO allocation method’ (available from www.hefce.ac.uk/data/famd/indicative/so/) describes how to re-build the 2016-17 SO allocations shown in the SO14_FXXXXXXXX.xlsx workbook.

Download 174.45 Kb.

Share with your friends:




The database is protected by copyright ©ininet.org 2024
send message

    Main page