Pathways - Youth-Transitions/resources GitHub Wiki
In Post-16 pathways to employment for lower attaining pupils we studied the pathways through post-16 study taken by young people who had low levels of achievement by the end of Key Stage 4 (roughly, age 16).
This included, inter alia, defining "learning pathways" for young people enrolled in further education establishments (for example, colleges). These are broad "programmes of study" derived from the learning aims (qualifications) they were observed to be studying.
The fft.pathways.sql script derived a number of variables, including type_id, which is the learning pathway that we used. The values it produces are (in decreasing priority):
| 1 | Level 4 or above |
| 11 | Advanced (Level 3) apprenticeship |
| 12 | 2 or more A-levels or AS-levels |
| 13 | Advanced 14-19 Diploma |
| 14 | Large Level 3 BTEC/OCR National or T-levels |
| 15 | Level 3 NVQ (National Vocational Qualification) |
| 16 | Mixed Level 3 (studying an A- or AS-level alongside another Level 3 qualification type, with total size at least Level 3 minimum ("full width"), but without sufficient in any one type) |
| 17 | Other "full" Level 3 (any other Level 3 qualifications, equivalent to 2 or more A-levels) |
| 20 | Mixed Level 2/3 (includes some Level 3, "full" width if Level 2 are also included) |
| 21 | Partial Level 2/3 (studying qualifications at both Level 2 and 3, but taken together are not "full" width) |
| 22 | Partial Level 3 (studying at Level 3, but less than 2 A-level equivalent) |
| 31 | Level 2 Apprenticeship |
| 32 | Traineeship |
| 33 | Standard (Level 2) 14-19 Diploma |
| 34 | Level 2 NVQ |
| 35 | Other "full" Level 2 (i.e. qualifications equivalent to 5 or more GCSE grades A*-C or 9-4) |
| 41 | Partial Level 2 |
| 42 | Below Level 2 |
The code calculates pathways on three enumeration dates each year. These dates are set in a table variable @dates. We have chosen the third Thursday on each of each of October, January and May (i.e. once per term in each academic year).
By default, the script is set with @reentrant_mode enabled. This means that if the script is interrupted before it finishes (e.g. if SRS goes down), it will pick up where it left off when restarted. Setting @reentrant_mode to 0 would clear out any records from a previous run and start again.
The other columns calculated in fft.pathways are:
- upin_anon, the pseudonymised establishment, based on UPIN
- ukprn_anon, the pseudonymised establishment, based on UKPRN
- ssa_tier2, a classification (SSA Tier 2) for the subject of the dominant qualification in the programme of study
- is_composite, whether the pathway is made of multiple qualifications, for example multiple A-level qualifications
- is_framework, whether the dominant qualification is a framework apprenticeship
- is_standard, whether the dominant qualification is a standard apprenticeship
- has_sfl_english, whether the student is studying Skills for Life (SFL) English alongside or as part of the main pathway
- has_sfl_maths, whether the student is studying Skills for Life (SFL) mathematics alongside or as part of the main pathway
- level, the level of the pathway
- is_completed, whether the student completed any of the qualifications in this pathway
- is_achieved, whether the student achieved (passed) any of the qualifications in this pathway
- length_of_study, the length (in days) of the dominant qualification within the pathway