Purpose
1 The Success Rates Tri-files are datasets produced from ILR and ISR collections for use with the FE Success Rates Methodology 2004/05. They bring the data from F05 collections to a compatible format for a particular FE Success Rate methodology which in itself will vary from year to year.
Relevant Collections
2 The tri-files needed for the 04/05 FE Success Rates will use data from the following collections
ILR (FE) 2004/05
ILR (FE) 2003/04
ILR (FE) 2002/03
ISR25
ISR22
3 The following variables are used as source data for the production of the tri-files for FE Success Rates methodology
Field Name | Dataset |
A01, A03, A05, A09, A10, A11a, A11b, A14, A17, A21, A27, A28, A31, A32, A34, A35, A36, A46a, A46b | ILR Learning Aim Dataset |
L01, L03, L11, L13, L14, L15, L16, L17, L12, L29, L32, L34a, L34b, L34c, L35 | ILR Learner Dataset |
Derived Variables and Datasets
4 The definition produces the following derived variable(s)
Field Name | Label | Dataset |
A_ACT_A | Actual current year guided learning hours using 1 November census date | Success Rates Tri-files for 2004/05, 2003/04, 2002/03, 2001/02 & 2000/01 |
A-EXP_A | Expected current year guided learning hours using 1 November census date | Success Rates Tri-files for 2004/05, 2003/04, 2002/03, 2001/02 & 2000/01 |
fundstat | Funding status | Success Rates Tri-files for 2004/05, 2003/04, 2002/03, 2001/02 & 2000/01 |
newref | Revised learner reference | Success Rates Tri-files for 2004/05, 2003/04, 2002/03, 2001/02 & 2000/01 |
Detailed definition
5 The details below cover the processing of data for the 04/05 collection. Older collections may require additional processing to bring the format into line with the latest collection; the detail of this extra processing is not defined here.
Matching and combining source data files
6 The Source Data listed above has the indicated fields extracted. At this point there may be separate files for each provider.
7 The Aims fields A01 and A03 are renamed as L01 and L03
8 The files are then matched to a single file by matching the Aim files with the Learner files using the L01 and L03 fields
Resolve anomalies with the data
9 The A36 field (Learning outcome grade) is mostly a 2 digit code and only the first 2 digits are used by the FE Success Rates methodology. In the case of BTEC National Diplomas where this is recoded as a 3 digit code to represent 3 different grades, this is recoded to reflect where they all are merit and above.
10 The values for fields A10, A28, A34 and A31 will cause problems for the FE Success rates methodology if they have no entry. In these particular cases they are set to zero.
Calculate derived variables
11 Fields A17, A27, A28, A31, A32 and A34 are used to calculate the derived variables A_ACT_A (Actual current year GLH using 1 Nov) and A_EXP_A (Expected current year GLH using 1 Nov) according to the Current Year Guided Learning Hours (CYGLH) Data Definition.
12 The field A10 (LSC funding stream) is used to determine which records to drop and to set a value in the derived variable 'fundstat' according to the following table
A10 value | description | record status | fundstat value |
10 | adult & community learning | keep | 0 |
20 | further education | keep | 1 |
30 | reserved for school sixth form | drop | NA |
40 | work based learning | drop | NA |
41 | WBL technical certificate funded as part of a framework | drop | NA |
42 | WBL key skills funded as part of a framework | drop | NA |
70 | LSC ESF co-financed | keep | 1 |
80 | other LSC funding stream (further details may be requested) | keep | 1 |
99 | no LSC funding for this learning aim | keep | 0 |
13 The Learner Reference Number (L03) is only unique to a learner at a particular provider since they are allocated by the providers. A new learner reference 'newref' is produced by combining the Provider Number (L01) with the learner reference number. This means that no learner will have the same 'newref' as any other learner with any other provider. It does not however mean that if a learner has aims with more than one provider then they have the same 'newref' in each case.
14 The format of 'newref' is an alphanumeric field of 19 characters with the 6 digits of the provider number first, followed by a single space followed by up to 12 characters of learner reference number (L03) that has had the leading zeros and trailing spaces removed.
Sample Code
15 The following sample code is available
