{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Main Sheet","Census data fields","Data Usage","Code Tables","Student numbers","National rate","Retention","PCW","Disadvantage","Large programme uplift","Area cost","T Levels","L3 maths and English","High value courses premium","Condition of funding","CoF FlowChart","CoF FlowChart.old","CoF Interactive FlowChart","SN_examples","NR_examples","RET_examples","CORE_examples","PCW_examples","DIS_examples","T_Level_examples","HVCP_examples","L3 maths and English examples","CoF examples","LPU_examples"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main Sheet","index":0,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[[13,1,13,17],[14,1,14,17],[15,1,15,17],[31,2,31,18],[34,2,34,4],[35,2,35,4],[43,2,43,4],[46,2,46,4],[36,2,36,4],[34,6,34,18],[44,6,44,18],[45,6,45,18],[36,6,36,18],[46,6,46,18],[43,6,43,18],[35,6,35,18]]}
[]
[null,"ESFA school census post-16 funding tool 2022 to 2023"]
[null,"Version 1.0 - June 2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Click here to see a high level data map showing you the key datasets used in 16 to 19 allocations and where they are used in the formula"]
[null,"If you are unsure about the meaning of field codes in the interactive examples please refer to the code table sheet for detailed descriptions."]
[null,"To ensure the examples work correctly please enable macros when opening this tool."]
[]
[null,"Core programme funding"]
[]
[]
[null,null,"Student numbers","x","National funding rate per student","x","Retention factor","x","Programme cost weighting","+","L3 maths and English  payment","+","Disadvantage","+","Large programme uplift",null,"x","Area cost"]
[]
[]
[]
[null,null,"Condition of funding (CoF)","______","Interactive Flowchart (CoF)","______","Static Flowchart (CoF)"]
[]
[null,"Additional formula funding elements",null,null,null,null,null,null,null,"Additional guidance on student programmes"]
[]
[]
[null,null,"High value courses premium (HVCP)",null,null,null,null,null,null,null,"T Levels"]
[]
[null,null,"Useful links"]
[]
[null,null,"Guidance"]
[null,null,"ESFA funding guidance",null,null,null,"www.gov.uk/16-to-19-education-funding-guidance"]
[null,null,"School census guidance",null,null,null,"www.gov.uk/school-census"]
[null,null,"Condition of funding detailed guidance",null,null,null,"www.gov.uk/16-to-19-funding-maths-and-english-condition-of-funding"]
[null,null,"Large programme uplift",null,null,null,"www.gov.uk/guidance/16-to-19-funding-large-programme-uplift"]
[null,null,"High value courses premium (HVCP) guidance",null,null,null,"www.gov.uk/guidance/16-to-19-funding-high-value-courses-premium"]
[null,null,"L3 maths and English payment",null,null,null,"www.gov.uk/guidance/16-to-19-funding-level-3-programme-maths-and-english-payment"]
[null,null,"How T Levels are funded",null,null,null,"www.gov.uk/guidance/how-t-levels-are-funded"]
[]
[null,null,"Reference data and systems"]
[null,null,"Find a learning aim (FALA)",null,null,null,"findalearningaimbeta.fasst.org.uk/"]
[null,null,"QAN web services",null,null,null,"collectdata.education.gov.uk/qwsweb/(S(glt55r551hufouidbqf0xgno))/Main.aspx"]
[null,null,"Qualifications approved for funding",null,null,null,"www.qualifications.education.gov.uk/"]
[null,null,"Postcode uplift factors",null,null,null,"https://www.gov.uk/government/publications/uplift-factors-and-postcode-files"]

{"sheet":"Census data fields","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[14,4,14,5],[11,4,11,5],[8,4,8,5],[3,4,3,5],[3,1,3,2],[7,1,7,2],[13,1,13,2]]}
[]
[null,"School census data fields used for funding"]
[]
[null,"School characteristics module",null,null,"Pupil status module"]
[null,"N00216","LA number",null,"N00017","Pupil enrolment status"]
[null,"N00279","Departmental establishment number",null,"N00182","Pupil’s actual national curriculum year group"]
[null,null,null,null,"N00183","Pupil’s actual national curriculum year group on leaving"]
[null,"Pupil identifiers module"]
[null,"N00001","Unique pupil number (UPN)",null,"SEN module"]
[null,"N00011","Unique learner number (ULN)",null,"N00209","Pupil SEN provision"]
[null,"N00002","Pupil’s former UPN"]
[null,"N00006","Pupil date of birth",null,"Home information module"]
[null,null,null,null,"N00037","Postcode"]
[null,"Pupil characteristics module"]
[null,"N00155","Top up funding indicator",null,"Post-16 learning aims module"]
[null,"N00163","Planned learning hours",null,"N00194","Qualification number"]
[null,"N00164","Planned employability, enrichment and pastoral hours",null,"N00058","Learning aim start date"]
[null,"N00654","Planned learning hours previous year",null,"N00059","Learning aim planned end date"]
[null,"N00655","Planned employability, enrichment and pastoral hours previous year",null,"N00060","Learning aim actual end date"]
[null,"N00680","T Level planned learning hours",null,"N00141","Learning aim status"]
[null,"N00681","T Level planned employability, enrichment and pastoral hours",null,"N00674","Programme type"]
[null,"N00169","Maths GCSE highest prior attainment",null,"N00154","Core aim"]
[null,"N00170","Maths GCSE prior attainment year 11",null,"N00167","Learning aim withdrawal reason"]
[null,"N00171","English GCSE highest prior attainment",null,"N00184","Traineeship"]
[null,"N00172","English GCSE prior attainment year 11",null,"N00675","Work placement start date"]
[null,"N00175","Maths GCSE funding exemption",null,"N00676","Work placement end date"]
[null,"N00176","English GCSE funding exemption",null,"N00763","Learner Funding and Monitoring (FAM) type"]
[null,"N00656","Maths GCSE highest prior attainment previous year",null,"N00764","Learner Funding and Monitoring (FAM) code"]
[null,"N00657","English GCSE highest prior attainment previous year"]

{"sheet":"Data Usage","index":2,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[3,4,3,22],[41,4,41,17],[19,4,19,17],[20,4,20,17],[21,4,21,17],[22,4,22,17],[23,4,23,17],[24,4,24,17],[37,4,40,14],[44,4,44,17],[27,6,27,14],[28,4,28,14],[29,4,31,14],[33,4,33,17],[34,4,34,17],[43,4,43,17],[42,4,42,17],[63,4,63,17],[64,4,64,19],[25,4,25,17],[26,4,26,17],[54,4,54,17],[56,4,56,17],[57,6,57,14],[58,4,58,14],[59,4,61,14],[45,4,45,17],[46,6,46,14],[47,4,47,14],[48,4,51,14],[53,4,53,17],[35,6,35,14],[36,4,36,14]]}
[null,null,null,null,"Back to main sheet"]
[null,null,null,null,"Move on to the detailed data sections"]
[null,null,null,null,"Data usage map"]
[null,null,null,null,"Please use the buttons below to see where and how each dataset is used in the 16 to 19 funding formula. \nMore details can be found in detailed data sections which you can select individually from the main sheet or jump to using the link above."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Student numbers","x","National funding rate per student","x","Retention factor","x","Programme cost weighting","+","Level 3 maths and English payment","+","Disadvantage","+","Large programme uplift",null,"x","Area cost"]
[]
[null,null,null,null,null,null,null,null,"Additional formula funding elements"]
[]
[null,null,null,null,"Condition of funding",null,null,null,"High value courses premium (HVCP)"]
[]
[]
[null,null,null,null,"Census (previous year) data is used to:"]
[null,null,null,null,"Determine full time/part time funding bands and the national funding rate per student"]
[null,null,null,null,"Determine the retention factor using learning aim completion status"]
[null,null,null,null,"Determine the programme cost weighting factor using the core aim sector subject area"]
[null,null,null,null,"Determine the disadvantage block 1 factor using student home postcode"]
[null,null,null,null,"Determine student compliance with the condition of funding on the provision of GCSE maths and English"]
[null,null,null,null,"Determine maths and English study in level 3 programmes"]
[null,null,null,null,"Determine high value courses premium"]
[]
[null,null,null,null,"Dataset Principles"]
[null,null,null,null,"The autumn census is a single data return combining the end of one academic year and the start of the next. The ESFA must split this combined data into two separate years (previous and current). This split data is then used to drive all calculations for the relevant academic year."]
[]
[]
[]
[null,null,null,null,"Census (current year) data is used to:"]
[null,null,null,null,"Determine the lagged student number"]
[]
[null,null,null,null,"Dataset Principles"]
[null,null,null,null,"The autumn census is a single data return combining the end of one academic year and the start of the next. The ESFA must split this combined data into two separate years (previous and current). This split data is then used to drive all calculations for the relevant academic year."]
[]
[]
[]
[null,null,null,null,"LARS data is used to:"]
[null,null,null,null,"Determine the programme cost weighting factor matching the sector subject area to the core aim QN"]
[null,null,null,null,"Determine the occupational specialism (using the ZTLOS code) for T Levels, which sets the national funding rate and the programme cost weighting"]
[null,null,null,null,"Identify learning aim types that meet the large programme uplift criteria"]
[null,null,null,null,"Identify learning aims that are valid maths and English qualifications counting toward the condition of funding"]
[]
[null,null,null,null,"Dataset Principles"]
[null,null,null,null,"LARS data is publicly available from the Find a Learning Aims webpage (linked from the main sheet) – it is the key source of qualification validity data used by the ESFA. LARS contains all key qualification information also collected in QWS as well as highlighting maths and English qualifications that are valid for the condition of funding (which QWS does not record)."]
[]
[]
[]
[]
[null,null,null,null,"Postcode data is used to:"]
[null,null,null,null,"Determine the disadvantage block 1 factor matching the disadvantage uplift to the student home postcode"]
[null,null,null,null,"Determine eligibility for discretionary bursary funding, according to sudents' home postcode and the level of deprivation in the Index of Multiple Deprivation (IMD)"]
[null,null,null,null,"Determine the area uplift matched to the institution's postcode"]
[]
[null,null,null,null,"Dataset Principles"]
[null,null,null,null,"The postcode data used by the ESFA is sourced from ONS and enriched with disadvantage and area cost factors. The postcode data we use from 2016/17 allocations onward uses the Indices of Multiple Deprivation (IMD) and the 2011 census super output area definitions to calculate disadvantage uplifts."]
[]
[]
[]
[null,null,null,null,"YPMAD data is used to:"]
[null,null,null,null,"Determine large programme funding using the last full year’s attainment data (from the Young Peoples Matched Administrative Dataset, YPMAD)"]

{"sheet":"Code Tables","index":3,"n_rows":110,"n_cols":8,"rows_kept":110,"cut":false,"hidden":false,"merged":[[28,1,28,2],[35,1,35,2],[82,4,82,5],[90,4,90,5],[84,4,84,5],[85,4,85,5],[86,4,86,5],[88,4,88,5],[33,5,33,7],[36,5,36,7],[41,5,41,7],[44,5,44,7],[49,5,49,7],[54,5,54,7],[60,5,60,7],[64,5,64,7],[67,5,67,7],[70,5,70,7],[11,5,11,7],[17,5,17,7],[20,5,20,7],[25,5,25,7],[29,5,29,7]]}
[]
[null,"Back to main sheet"]
[]
[null,"Back to main sheet"]
[null,"Code tables"]
[null,"The tables below set out the allowable codes for each field and the value of each code."]
[null,"Please use these tables as a reference point for understanding the data set out in each interactive example."]
[]
[]
[null,"Pupil enrolment status",null,null,"Sector subject area (SSA) tier 2"]
[null,"Code","Description",null,"Code","Description","PCW banding","PCW factor"]
[null,"C","Current (single registration at this school)",null,1,"Health, public services and care"]
[null,"G","Guest (pupil not registered at this school but attending some lessons or sessions)",null,1.1000000000000001,"Medicine and dentistry","Low",1.1000000000000001]
[null,"M","Current main (dual registration)",null,1.2,"Nursing and subjects and vocations allied to medicine","Low",1.1000000000000001]
[null,"S","Current subsidiary (dual registration)",null,1.3,"Health and social care","Base",1]
[null,"F","FE college*",null,1.4,"Public services","Base",1]
[null,"O","Other provider*",null,1.5,"Child development and wellbeing","Base",1]
[null,"*PRUs only",null,null,2,"Science and mathematics"]
[null,null,null,null,2.1,"Science","Base/low [1]","1/1.1"]
[null,null,null,null,2.2000000000000002,"Mathematics and statistics","Base",1]
[null,"Aim status",null,null,3,"Agriculture, horticulture, and animal care"]
[null,"Code","Description",null,3.1,"Agriculture","High/specialist [2]","1.3/1.75"]
[null,1,"The learner is continuing or intending to continue the learning activities leading to the learning aim",null,3.2,"Horticulture and forestry","High/specialist [2]","1.3/1.75"]
[null,2,"The learner has completed the learning activities leading to the learning aim",null,3.3,"Animal care and veterinary science","High/specialist [2]","1.3/1.75"]
[null,3,"The learner has withdrawn from the learning activities leading to the learning aim",null,3.4,"Environmental conservation","High/specialist [2]","1.3/1.75"]
[null,4,"The learner has transferred to a new learning aim. That is, the learner has withdrawn from this learning aim and as a direct result has at the same time started studying for another learning aim within the same provider",null,4,"Engineering and manufacturing technologies"]
[null,null,null,null,4.0999999999999996,"Engineering","Very high",1.4]
[null,null,null,null,4.2,"Manufacturing technologies","Very high",1.4]
[null,"Maths GCSE prior attainment year 11",null,null,4.3,"Transportation operations and maintenance","Very high",1.4]
[null,"Code","Description",null,5,"Construction, planning and the built environment"]
[null,1,"Learner has GCSE maths (at grade A*-C / 9 - 4) – achieved by end of year 11",null,5.0999999999999996,"Architecture","Medium",1.2]
[null,2,"Learner has GCSE maths (at grade A*-C / 9 - 4) – achieved since the end of year 11",null,5.2,"Building and construction","Very high",1.4]
[null,3,"Learner does not have GCSE maths (at grade A*-C / 9 - 4)",null,5.3,"Urban, rural and regional planning","Medium",1.2]
[null,null,null,null,6,"Information and communication technology"]
[null,null,null,null,6.1,"ICT practitioners","Medium",1.2]
[null,"English GCSE prior attainment year 11",null,null,6.2,"ICT for users","Base",1]
[null,"Code","Description",null,7,"Retail and commercial enterprise"]
[null,1,"Learner has GCSE English (at grade A*-C / 9 - 4) – achieved by end of year 11",null,7.1,"Retailing and wholesaling","Medium",1.2]
[null,2,"Learner has GCSE English (at grade A*-C / 9 - 4) – achieved since the end of year 11",null,7.2,"Warehousing and distribution","Base",1]
[null,3,"Learner does not have GCSE English (at grade A*-C / 9 - 4)",null,7.3,"Service enterprises","Medium",1.2]
[null,null,null,null,7.4,"Hospitality and catering","High",1.3]
[null,null,null,null,8,"Leisure, travel and tourism"]
[null,"Maths GCSE funding exemption",null,null,8.1,"Sport, leisure and recreation","Base",1]
[null,"Code","Description",null,8.1999999999999993,"Travel and tourism","Base",1]
[null,"L","A learning disability prevents the pupil from studying for the qualification(s)",null,9,"Arts, media and publishing"]
[null,"O","A recognised overseas equivalent qualification is held by the pupil",null,9.1,"Performing arts","Medium",1.2]
[null,"U","Learner has met the GCSE condition of funding as they hold an approved equivalent UK qualification",null,9.1999999999999993,"Crafts, creative arts and design","Medium",1.2]
[null,"N","No exemption",null,9.3000000000000007,"Media and communication","Base",1]
[null,"F","Learner holds a pass grade for functional skills level 2",null,9.4,"Publishing and information services","Base",1]
[null,null,null,null,10,"History, philosophy and theology"]
[null,null,null,null,10.1,"History","Base",1]
[null,"English GCSE funding exemption",null,null,10.199999999999999,"Archaeology and archaeological sciences","Base",1]
[null,"Code","Description",null,10.3,"Philosophy","Base",1]
[null,"L","A learning disability prevents the pupil from studying for the qualification(s)",null,10.4,"Theology and religious studies","Base",1]
[null,"O","A recognised overseas equivalent qualification is held by the pupil",null,11,"Social Sciences"]
[null,"U","Learner has met the GCSE condition of funding as they hold an approved equivalent UK qualification",null,11.1,"Geography","Base",1]
[null,"N","No exemption",null,11.2,"Sociology and social policy","Base",1]
[null,"F","Learner holds a pass grade for functional skills level 2",null,11.3,"Politics","Base",1]
[null,null,null,null,11.4,"Economics","Base",1]
[null,null,null,null,11.5,"Anthropology","Base",1]
[null,"Maths GCSE highest prior attainment",null,null,12,"Languages, literature and culture"]
[null,"Code","Description",null,12.1,"Languages, literature and culture of the British Isles","Base",1]
[null,"A*","Grade A star",null,12.2,"Other languages, literature and culture","Base",1]
[null,"A","Grade A",null,12.3,"Linguistics","Base",1]
[null,"B","Grade B",null,13,"Education and training"]
[null,"C","Grade C",null,13.1,"Teaching and lecturing","Medium",1.2]
[null,"D","Grade D",null,13.2,"Direct learning support","Medium",1.2]
[null,"E","Grade E",null,14,"Preparation for life and work"]
[null,"F","Grade F",null,14.1,"Foundations for learning and life","Base",1]
[null,"G","Grade G",null,14.2,"Preparation for work","Base",1]
[null,"U","Grade U",null,15,"Business, administration and law"]
[null,9,"Grade 9",null,15.1,"Accounting and finance","Base",1]
[null,8,"Grade 8",null,15.2,"Administration","Base",1]
[null,7,"Grade 7",null,15.3,"Business management","Base",1]
[null,6,"Grade 6",null,15.4,"Marketing and sales","Base",1]
[null,5,"Grade 5",null,15.5,"Law and legal services","Base",1]
[null,4,"Grade 4"]
[null,3,"Grade 3",null,"[1] Academic programmes that include 2 or more science A levels receive the low (1.1) weighting."]
[null,2,"Grade 2",null,"[2] The high weighting (30%) will include non-specialist agriculture and animal care. "]
[null,1,"Grade 1",null,"The specialist weighting (75%) will apply where there is a requirement to maintain specialist facilities such as a farm or equine stables."]
[null,"NR","Not required"]
[null,null,null,null,"Large Programme Uplift"]
[null,null,null,null,"Study Programme Criteria",null,"Uplift on "]
[null,"English GCSE highest prior attainment",null,null,null,null,"National Rate"]
[null,"Code","Description",null,"4 full linear A Levels achieved at grade B or above",null,0.1]
[null,"A*","Grade A star",null,"5 full linear A Levels achieved at grade B or above",null,0.2]
[null,"A","Grade A",null,"Full level 3 International Baccalaureate Diploma achieved at 28 points ",null,0.2]
[null,"B","Grade B",null,"or above"]
[null,"C","Grade C",null,"Large TechBacc programme equivalent to 4 A levels where all ",null,0.1]
[null,"D","Grade D",null,"qualifications are passed"]
[null,"E","Grade E",null,"Large TechBacc programme equivalent to full level 3 International ",null,0.2]
[null,"F","Grade F",null,"Baccalaureate where all qualifications are passed"]
[null,"G","Grade G"]
[null,"U","Grade U"]
[null,9,"Grade 9",null,"Programme type"]
[null,8,"Grade 8",null,"Code","Description"]
[null,7,"Grade 7",null,"01","Study programme"]
[null,6,"Grade 6",null,30,"T Level transition programme"]
[null,5,"Grade 5",null,31,"T Level"]
[null,4,"Grade 4"]
[null,3,"Grade 3"]
[null,2,"Grade 2",null,"Learner Funding and Monitoring (FAM) Type"]
[null,1,"Grade 1",null,"Code","Description"]
[null,"NR","Not required",null,"NLM","National Learner Monitoring: To identify any additional monitoring characteristics for the pupil"]
[]
[]
[null,null,null,null,"Learner Funding and Monitoring (FAM) Code"]
[null,null,null,null,"Code","Description"]
[null,null,null,null,21,"Learner in receipt of 16 to 19 tuition fund"]
[null,null,null,null,22,"Learner repeating up to one full final year of 16 to 19 funded provision"]

{"sheet":"Student numbers","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,1,20,1],[18,3,18,4],[19,3,19,4],[20,3,20,4],[6,1,6,4],[12,2,14,2],[12,3,14,3],[9,4,14,4],[17,3,17,4]]}
[]
[null,"Return to main page"]
[null,"Move on to national funding rate per student"]
[]
[null,"Student Numbers"]
[]
[]
[null,"Data used"]
[null,"Census data","How","Why","Other considerations"]
[null,"Pupil's actual national curriculum year group","Students in national curriculum years 12, 13 and 14 are selected, students in national curriculum years below 12 are excluded from all calculations.","ESFA 16 to 19 funding supports post-16 pupils who have progressed beyond the compulsory national curriculum. Students recorded in national curriculum year 11 and below should be those still following the national curriculum and funded through the pre-16 funding regime.\n\nThere can be exceptional circumstances where students under the age of 16 are studying the majority of their programme at level 3. In such cases the national curriculum year should be 12.","All of these data principles are similarly applied to the records used to determine funding factors."]
[null,"Pupil enrolment status","Only students with main or current main registration are selected.","Guest pupils do not generate funding for the institution they are a guest in. Only the institution holding main registration for the student receives funding for the student. Therefore guest pupils are excluded. This means all learning aims for a student should be recorded by the institution holding main registration."]
[null,"Pupil on roll/off roll status","Only students who are on roll are counted for the current funding year.","Students who are off roll in the current year but who were on roll in the previous year may be included in the calculation of the relevant funding factors if they meet the other criteria (national curriculum year group and enrolment status)."]
[null,"Learning aim start date","The earliest start date, latest planned end date and latest actual end date across all learning aims in a student's study programme are used to determine whether or not the student qualifies for funding. Students who do not qualify for funding are excluded from all calculations.","To qualify for funding a student must remain on their study programme for a minimum period based on the planned length of the programme or the number of planned hours in the academic year. "]
[null,"Learning aim planned end date"]
[null,"Learning aim actual end date"]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation"]
[null,"Student incorrectly recorded as a guest.","The student will be excluded from all calculations.","Guest pupils do not generate funding for the institution they are a guest in. Only the institution holding main registration for the student receives funding for the student. Therefore guest pupils are excluded."]
[null,"Learning aim dates incorrectly recorded","The student may not qualify for funding, in which case the student will be excluded from all calculations.","Each student must qualify for funding by passing a funding qualifying period. The start date, planned end date and actual end date are used to calculate not only the qualifying period but also whether or not the student has passed the period and qualified for funding. Therefore incorrectly recorded dates can impact whether or not a student qualifies."]
[null,null,"The student may not be included in the census data for a year they were in learning which will affect either student numbers or funding factors and funding band proportions.","The start date, planned end date and actual end date are used to determine which years a student was or is in learning. These dates are the key data used to split the combined autumn census return into two files covering the end of one academic year and the start of the next. If the dates incorrectly show learning undertaken in one year only, this will exclude the student from either funding factors (if dates are only in the latter year) or student numbers (if dates are only in the former year)."]

{"sheet":"National rate","index":5,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[19,2,20,2],[10,2,11,2],[10,3,11,3],[10,4,11,4],[12,2,13,2],[12,3,13,3],[12,4,13,4]]}
[]
[null,"Return to main page"]
[null,"Move on to retention"]
[]
[null,"National funding rate per student\n(full-time/part-time bands)"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Other considerations"]
[null,"Planned hours and national funding rates","The sum of planned learning hours and planned employability, enrichment and pastoral hours gives a total planned hours figure for the academic year for each student. This total planned hours figure determines the funding band, and therefore, national funding rate the student attracts.",null,"The national funding rates have increased, following the announcement of the three-year spending review in autumn 2021. The increased funding rates are associated with higher hours thresholds for the funding bands.\n\nThe planned hours set out in the table of national funding rates (in the Funding rates and formula guidance on GOV.UK) are what ESFA expects providers to plan for students’ study programmes delivered in 2022 to 2023. However, the funding allocations for 2022 to 2023 used data from 2020 to 2021, when the expected delivery hours were lower. therefore the allocations for that year used the previous, lower, funding band thresholds. For the purposes of funding allocations, students’ funding bands are determined by the year in which they were studying."]
[null,"Planned learning hours (qualification hours)","The sum of planned learning hours and planned employability, enrichment and pastoral hours gives a total planned hours figure for the academic year for each student. This total planned hours figure determines the funding band, and therefore, national funding rate the student attracts.","The funding methodology enables the funding of appropriate non-qualification based activity alongside qualification activity and each are recorded in separate fields although taken as a whole when calculating funding.","Planned hours for study programmes are annual, reflecting the total planned hours for the student in an academic year.\n\nThere are two sets of planned hours fields: one for the current year and one for the previous year. For the 2022 autumn census, the fields suffixed with 'previous year' are the hours for post-16 pupils who were on roll and in year 12 or above in 2021 to 2022, and the other planned hours fields are for students who are on roll and in year 12 or above in the current year, 2022 to 2023.\n\nPlanned hours should not reflect weekly hours. \n\nPlanned hours data must not be changed to reflect actual hours.\n\nT Level hours cover the whole of the programme, which we expect to typically be 2 years. T Level hours for qualification and non-qualification activity are recorded in separate fields to study programme hours."]
[null,"Planned enrichment, employability and pastoral hours (non-qualification hours)"]
[null,"Top-up indicator","The top-up indicator is used to identify those students deemed 'high needs', that is, those students who are in receipt of element 3 top-up funding from a local authority or, in the case of a PRU, a local authority or another school.\n\nThe date of birth is used to calculate the student's age on 31st August of the relevant academic year.\n\nBoth sets of data are then used to ensure students receive the correct national funding rate based on their planned hours and age.\n\n","Funding for students aged 18 or over who are not designated 'high needs' is paid at a maximum national funding rate of £3,757 (for those students whose planned hours are 485 or above)."]
[null,"Date of birth"]
[null,"Unique pupil number (UPN) and former UPN","For some elements of the funding formula, we use the previous year's data. In the majority of cases, we do this using the unique learner number (ULN), and in its absence, the unique pupil number (UPN).","Using previous year's data allows us to look at a whole year's data, rather than a partial dataset taken midway through the year.\n\nWhen students change their UPN between census returns, institutions must return the former UPN as well as the current UPN so that we can accurately track them over the two years.\n\nThe elements of the funding formula that use data with a two-year lag are: funding rate band (planned hours), programme cost weighting, disadvantage blocks 1 and 2. "]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation","Other considerations"]
[null,"No planned hours are recorded for the student","This will impact on the funding band proportions used in an institutions allocation and result in no funding for the student.","If no planned hours are recorded the student's funding band will be set to part time band 1 (0 to 299 hours) with an FTE value of 0. As the FTE value is a multiplier for all other funding elements the student will generate no funding through the formula."]
[null,"Only planned learning hours recorded","This is likely to result in the student attracting a lower national funding rate than they should, impacting funding band proportions, potentially, resulting in a reduced funding allocation.","Qualification hours alone are unlikely to put a student in the full time funding band. Non-qualification hours should be recorded where this activity is planned for the student and in many cases will complete a student's study programme often putting them into the full time band or a higher part time band. ","Institutions should ensure all eligible activities are reflected in the planned hours returned for each student. Non-qualification hours can include a variety of study programme related activities such as:\n\n1) informal certificates such as Duke of Edinburgh Award\n\n2) work related activity such as preparing CVs and practising interview skills\n\n3) activities that offer enrichment to the student such as employer or university visits\n\nPlease refer to the ESFA Funding regulations guidance on planned hours for further information on how planned hours can be constructed and the types of activity that can be included."]
[null,"Weekly planned hours recorded",null,"Planned hours should reflect all of the hours planned to be delivered to a student in the academic year in question. If the average hours per week are recorded this will be the value taken as the annual hours and will put the student in the part time band 1 (0 to 299 hours)."]
[null,"T Level hours are recorded in the study programme hours fields",null,"If hours are recorded in the study programme hours fields, rather than the T Level hours fields, the T Level hours default to 0. This means that the funding band will be band 1, the lowest band."]
[null,"Top-up indicator not completed for students in receipt of element 3 top-up funding","This will reduce the number of high needs students identified for place funding and will result in a maximum funding rate of £3,757 for affected students aged 18 or over.","From 2015 to 2016, ESFA-funded high needs students will be identified solely by the completion of the top-up indicator. Therefore high needs students not identified as such will not be accounted for in the high needs place funding process.\n\nFurthermore the only 18+ students eligible for receiving funding at the full time national funding rate are those with high needs. If they are not identified as high needs funding will be capped at the top part time funding rate of £3,757."]
[null,"No former UPN recorded","The funding calculation may not match in the previous year's data.","If we cannot match the student's former UPN to a UPN recorded in the previous year's data, then we will not be able to use the right data from the previous year.\n\nThe elements of the funding formula that would use the previous year's data will not operate correctly, and the result of the funding calculation is likely to be distorted, resulting in incorrect funding. For example, if we cannot match in planned hours from the previous year, the student will have 0 planned hours, and the funding calculation will not output funding for them.","29/04/2019 - Suggest this whole row is now deleted.\nThe matching issue is now internal for SQL code only."]

{"sheet":"Retention","index":6,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Return to main page"]
[null,"Move on to programme cost weighting"]
[]
[null,"Retention"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why"]
[null,"Qualification number (QN)","The QN is used to ascertain information about the qualification from the Learning Aims Reference Service (LARS). For retention calculations, the aim type field (see below) from LARS is used to determine the type of qualification to ascertain whether it is vocational or academic.","For academic programmes retention is calculated from all academic aims within the programme and for vocational programmes it is based on the core aim recorded for the student. Therefore the ESFA needs to know which aims are academic and which are vocational."]
[null,"Core aim","A core aim is recorded for vocational programmes, and is used to determine the retention status of the student.","For vocational programmes the core aim reflects the principal or core activity for the student. As such this activity determines the status of the programme as it relates to key funding elements including retention."]
[null,"Learning aim status","Learning aims recorded as continuing (1) or completed (2) are classed as retained, whereas those set to withdrawn (3) or transferred (4) are not.\n\n","Retention is a measure of students completing the core elements of their programme. If they have withdrawn or transferred from these elements they are not complete."]
[]
[null,"Reference Data","How","Why"]
[null,"Aim type","The aim type field is held in LARS and is matched into census data using the QN. This field indicates the type of the qualification (for example A level, GCSE, diploma) which, in turn, is used to determine whether or not it is academic or vocational.","The retention calculation identifies aims as academic or vocational so only appropriate aims are selected according to the students main programme type - as described above."]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation"]
[null,"Incorrect or invalid QN is recorded","May result in a student being incorrectly recorded as not retained.","If an invalid QN is returned, we cannot match in reference data from LARS. Therefore the aim type will be unavailable and the learning aim will default to vocational. If the student's programme is academic, vocational aims will be ignored in the retention calculation.\n\nAn incorrect QN may result in incorrect LARS data being matched to the learning aim, again resulting in incorrectly excluded aims in the retention calculation."]
[null,"Core aim is returned for an academic student or not returned for a vocational student.","May result in a student being incorrectly recorded as not retained.","The core aim is used to determine whether or not a student's programme is academic or vocational (those with a core aim are vocational and those without are academic).\n\nIf a student is deemed academic because a core aim has not been recorded the retention calculation will exclude all vocational aims. If that student has no academic aims the retention status will be set to not retained by default. \n\nThe same is true of an academic student who is deemed vocational because a core aim has incorrectly been recorded."]
[null,"Learning aim status is incorrect or missing","May result in a student being incorrectly recorded as not retained.","Aims with incorrect statuses could reflect a transferred or withdrawn (not retained) aim where it is actually continuing or completed (retained).\n\nThose aims with no learning aim status will default to not retained."]

{"sheet":"PCW","index":7,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,4,12,4]]}
[]
[null,"Return to main page"]
[null,"Move on to disadvantage"]
[]
[null,"Programme cost weighting"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Other considerations"]
[null,"Qualification number (QN)","The QN is used to reference the sector subject area for the qualification from the Learning Aims Reference Service (LARS). This is used to determine the appropriate programme cost weighting for the core aim in each vocational study programme.","For vocational study programmes the programme cost weighting attracted is determined by the sector subject area of the core aim. The weighting is applied to the student's whole study programme.","Only vocational study programmes and T Levels can carry a weighting above 1. All academic programmes attract the base weight of 1, apart from programmes that include at least 2 science A levels.\n\nNot all vocational programmes carry a weighting above 1; many sector subject areas are base weighted.\n\nA list of weightings against sector subject areas can be found in the ESFA 'Funding rates and formula' guidance (please see the useful links section on the main page of this tool) and in the code table section of this tool."]
[null,"Qualification number (QN) - T Level occupational specialism aim","We use the T Level occupational specialism aims (starting ZTLOS) to determine programme weighting.\n\nPrior to 2021 to 2022, T Levels occupational specialisms were determined by the T Level technical qualification's discount code.","Within each T Level, occupational specialism can attract a different weighting."]
[null,"Core aim indicator","The core aim is used to determine whether or not a student's programme is academic or vocational. If it is vocational the core aim will be used to reference the appropriate programme cost weighting.","For vocational programmes the core aim should reflect the principal or core activity for the student. As such this activity determines the status of the programme as it relates to key funding elements including programme cost weighting."]
[null,"T Level transition programme class code","The core aim for a T Level transition programme must be the class code for the subject (the codes all start ZTPR).","The programme cost weighting is determined by the class code."]
[]
[null,"Reference data","How","Why"]
[null,"Sector subject area tier 2 (SSA T2)","We assign a programme cost weighting to each sector subject area (SSA) at tier 2 level. ","For vocational programmes, we use the core aim's SSA to weight the student's whole programme. We weight academic programmes with two or more A levels in the science SSA at 1.1. Other academic programmes to not receive a programme cost weighting uplift."]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation"]
[null,"No core aim recorded","If no core aim is recorded for a vocational programme the base weighting of 1 will applied to the student's whole programme.","Vocational study programmes are identified by the presence of a core aim. If no core aim is present the programme will be assumed to be academic and, therefore, not attract a weighting even if the aims in the programme fall under sector subject areas that do attract a weighting."]
[null,"Invalid qualification number (QN)","No programme cost weighting will be attracted.","An invalid QN will mean the aim cannot be matched to LARS to determine the sector subject area, therefore, no weighting will be attracted."]
[null,"Missing or invalid occupational specialism (ZTLOS) qualification number (QN)","The programme cost weighting will be wrong.","The occupational specialism code determines the programme weighting."]
[null,"T Level transition programme class code not recorded, or is not recorded as the core aim","The base weighting of 1 will applied to the student's whole programme.","The transition programme class code determines the programme cost weighting. Without the code, or if it is not recorded as the core aim, the default weighting of 1 will apply."]

{"sheet":"Disadvantage","index":8,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,2,11,2],[10,3,11,3],[10,4,11,4]]}
[]
[null,"Return to main page"]
[null,"Move on to large programme uplift"]
[]
[null,"Disadvantage"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Other considerations"]
[null,"Postcode","Each student's home postcode is used to reference an uplift value for that area in a postcode uplift file (see useful links on the main page).","Block 1 disadvantage funding is attracted by students living in the 27% most deprived super output areas (SOAs) of the country. This information (sourced from the Indices of Multiple Deprivation, or IMD) is stored in reference data matching postcodes to SOAs and disadvantage uplifts to each SOA."]
[null,"Maths GCSE prior attainment year 11","Students recorded in these fields as not having achieved a GCSE grade 9 to 4, A* to C by the end of national curriculum year 11 in either or both of these subjects will attract disadvantage block 2 funding.","Block 2 disadvantage funding accounts for the additional costs incurred for teaching students who have low prior attainment, as indicated by not achieving English and/or maths GCSEs at grade 4, C or above by the end of year 11 (typically age 16).","This data is not to be confused with the highest prior attainment grade that is recorded in the census to drive the condition of funding on maths and English."]
[null,"English GCSE prior attainment year 11"]
[]
[null,"Reference data","How","Why","Other considerations"]
[null,"Postcode factors","In this data set disadvantage uplifts are recorded against all UK residential postcodes. The student's home postcode is matched into this reference data to ascertain whether or not the student lives in an area that attracts a disadvantage uplift.","Block 1 disadvantage funding is attracted by students living in the 27% most deprived SOAs of the country. This information (sourced from the Indices of Multiple Deprivation, or IMD) is stored in reference data matching postcodes to SOAs and disadvantage uplifts to each SOA."]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation","Other considerations"]
[null,"Missing or incorrect postcode data","An incorrect disadvantage uplift will be attracted by the student - this is likely to lead to no uplift being applied for a student who should attract one.","If a postcode is missing or not valid a match will not be found in the postcode uplift reference data. Therefore, the disadvantage uplift value will default to 1 (no uplift)."]
[null,"Missing or incorrect prior attainment data","An incorrect block 2 instances per student figure will be applied to affected students resulting in an incorrect calculation of block 2 disadvantage funding.","Block 2 disadvantage funding is calculated as the number of instances per student (2 for students without maths and English at the end of year 11, 1 for students without maths or English at the end of year 11 and 0 for those with both at the end of year 11). If the maths and English prior attainment by end of year 11 fields are incorrectly completed the instances per student and overall block 2 funding will be incorrect."]

{"sheet":"Large programme uplift","index":9,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,2,18,2],[8,1,8,4],[15,1,15,3]]}
[]
[null,"Return to main page"]
[null,"Move on to area cost"]
[]
[null,"Large programme uplift"]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Things to consider"]
[null,"Census data is not used to calculate the large programme uplift"]
[]
[null,"Reference data","How","Why","Things to consider"]
[null,"Large programme calculations are taken from the Young person's matched administrative dataset (YPMAD). This data is based on exam results from awarding organisations.","From YPMAD data we calculate how many students studying with your institution in the relevant year hold the requisite exam grades for valid programmes. This number is then transferred directly to your allocation statement where the 10% and 20% large programme rates are applied to calculate a final large programme uplift value.","The large programme uplift is driven by minimum attainment levels achieved for qualifications making up a substantial programme. Attainment data is no longer collected in the school census, so we extract this information for your pupils from YPMAD data which is driven by the National Pupil Database (NPD).\n\nMore information on the large programme uplift can be found in the large programme uplift guidance link on the main sheet.","Large programme data operates on a 3 year lag, that is we use attainment from 3 years prior to the allocation year. \n\nFor example, for 2022 to 2023 allocations we use 2019 to 2020 YPMAD data."]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation"]
[null,"Census data is not used to calculate the large programme uplift"]
[null,"A2 or full linear A Levels incorrectly recorded. For example below grade B","Student will fail to meet the criteria for A2 or full linear A Levels; Full level 3 International Baccalaureate Diploma; Large TechBacc programme. ","Student required to have achieved 4/5 A2 or full linear A Levels to qualify for large programme uplift."]
[null,"Full level 3 International Baccalaureate Diploma incorrectly recorded. For example being below the 28 points threshold, consisting of only IB certificates and no IB Diploma.",null,"Student required to have achieved 28 points or above for the full level 3 International Baccalaureate Diploma, to qualify for large programme uplift. "]
[null,"Large TechBacc programme incorrectly recorded. For example a failure to correctly record all qualifications as passed.",null,"Student required to have achieved Large TechBacc programme either at equivalence to 4 A levels where all qualifications are passed or to have achieved equivalence to full level 3 International Baccalaureate where all qualifications are passed"]

{"sheet":"Area cost","index":10,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[9,1,9,4]]}
[]
[null,"Return to main page"]
[null,"Move on to T Levels"]
[]
[null,"Area cost"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Other considerations"]
[null,"No census data is used to calculate area cost"]
[]
[null,"Reference data","How","Why","Other considerations"]
[null,"Postcode factors","The institution's main address is used to determine whether or not learning is delivered primarily in an area that attracts an area cost weighting.","Research has shown that there is a clearly marked difference in the relative costs of delivery between London and the south east, and the rest of England. ","Area cost weightings are shown in detail in the ESFA 'Funding rates and formula' funding guidance book which can be found on the links part of the main sheet."]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation","Other considerations"]
[null,"Not applicable","Not applicable","Not applicable","Not applicable"]

{"sheet":"T Levels","index":11,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[10,2,11,2],[10,3,11,3],[22,2,23,2],[10,4,13,4]]}
[]
[null,"Return to main page"]
[null,"Move on to level 3 maths and English"]
[]
[null,"T Levels"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Other considerations"]
[null,"Qualification number (QN) - occupational specialism (ZTLOS)","We use the occupational specialism code to determine the programme's funding band.\n\nWhen T Level programmes are fully implemented into the lagged funding system, the programme cost weighting for a T level programme will also be determined by the occupational specialism. The 16 to 19 funding reports in COLLECT show the programme cost weighting that will be generated by the occupational specialism even though that value will not be used in funding allocations until T Levels are fully lagged.\n\n","Within a T Level, occupational specialisms can be in different funding bands and can attract different programme weightings.","Occupational specialism is identified by a separate qualification number (QN). The QNs for occupational specialisms begin with ZTLOS."]
[null,"Qualification number (QN)","We use QNs and core aims to identify and correctly fund T Level programmes.","The TQ must be the core aim in order for a programme to be identified as a T Level.","More information on T Levels is on GOV.UK."]
[null,"Core aim"]
[null,"T Level qualification and non-qualification hours","In some cases, we use the values recorded in the T Level hours fields to determine the funding band.","Students cannot be funded above the set funding band for a particular T Level, but if the hours are below the band minimum students will be funded in the band appropriate to the hours."]
[null,"Programme type","Programme type identifies which type of programme each learning aim belongs to.","When students do more than one kind of programme in a year, the programme type allows us to correctly identify which aims belong to which programme and fund the student correctly."]
[]
[null,"Reference data","How","Why","Other considerations"]
[null,"LARS learning aim type","LARS holds learning aim types, including a type to identify T Levels technical qualifications (TQs).","The TQ must be the core aim in order for a programme to be identified as a T Level."]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation"]
[null,"The technical qualification (TQ) is not the core aim","The programme is not identified as a T Level. The funding band and programme weighting are very likely to be incorrect.","Only T Levels can be funded in band 6 and above. If another qualification has been identified as a core aim, the programme will be treated as a study programme and will be in band 5 or lower. We will also use the core aim determine the programme cost weighting."]
[null,"Missing or invalid occupational specialism (ZTLOS) qualification number (QN)","The programme has an incorrect funding band and/or incorrect programme weighting.","The occupational specialism determines what the funding band and programme weighting should be; if there is no occupational specialism aim for the student, the band and weighting are likely to be lower than the correct ones for the occupational specialism."]
[null,"T Level programme hours are below the band minimum","The T Level student is funded at a lower level than they should be.","Each T Level has a set funding band, with minimum hours. Students cannot be funded at a higher band, but if the T Level hours are below the band minimum the student is funded at that lower level.\n\nThe T Level hours must be the hours for the whole programme, across all years that it will run for. If the hours only reflect the annual hours, the student will be funded at a lower level."]
[null,"T Level hours are recorded in the study programme hours fields",null,"If hours are recorded in the study programme hours fields, rather than the T Level hours fields, the T Level hours default to 0. This means that the funding band will be band 1, the lowest band. As this band works out the funding based on the recorded hours as a proportion of a full time programme, the funding will be nil (0 hours in the proportional gives £0 funding)."]
[null,"The wrong programme type is assigned to the programme aim","The most recent programme is not identified as a T Level. The funding band will be wrong.","The programme type for the most recent programme aim determines the programme type for funding purposes. If the type is set as a study programme rather than a T Level, the funding cannot be in one of the higher T Level funding bands."]

{"sheet":"L3 maths and English","index":12,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[11,2,12,2],[11,3,12,3],[15,2,17,2],[15,3,17,3]]}
[]
[null,"Return to main page"]
[null,"Move on to high value courses premium (HVCP)"]
[]
[null,"Level 3 maths and English payment"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Other considerations"]
[null,"English/maths GCSE highest prior attainment","The prior attainment grade for English/maths determines whether a student is eligible for the L3 maths and English payment.","A student who doesn't have maths and/or English GCSE grade 9 to 4 or equivalent at the start of their level 3 programme is likely to need additional support to achieve and therefore to incur additional cost.","More information on the payment is on GOV.UK."]
[null,"Qualification numbers (QNs)","We use QNs to determine if a student is on a substantial vocational programme","To count as a substantial programme, a student must be on a programme meeting one of the following criterion:\n- have an academic programme that includes at least two A levels,\n- have a level 3 vocational qualification of 360 guided learning hours (GLH) as their latest core aim."]
[null,"Learning start date","We use the earliest and latest start dates from a student's learning aims to determine the length of the programme.","1 year and 2 programmes are paid at different rates. We count a programme of 18 months or longer as a 2 year programme; all other programmes are counted as 1 year programmes."]
[null,"Learning end date"]
[]
[null,"Reference data","How","Why","Other considerations"]
[null,"LARS qualification number (QN)","We compare student data with the census with LARS reference data to determine if a student is on a qualifying programme.","Students on programmes that do not qualify are not eligible for the payment, even if they do not have maths and/or English GCSE at the required level."]
[null,"LARS GLH"]
[null,"LARS level "]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation","Other considerations"]
[null,"Incorrect qualification numbers (QNs) recorded","The student may not be eligible for the payment.","If a student does not have the correct QNs recorded for their programme (for example, AS instead of A levels, or a vocational qualification that does not have 360 guided learning hours (GLH) or more, then their programme meet the eligibility critiria set out above."]
[null,"The core aim is not a substantial vocational qualification","The student will not be eligible for the payment.","Students on a vocational programme must have their core qualification as one that meets the programme eligibility criteria. Even if they have a level 3 vocational qualification of 360GLH or more in their programme, they are not eligible for the payment if they have another qualification as the core aim."]
[null,"Programme start and end dates incorrect, making the programme too short","The student will not be eligible for the payment, or will be paid at a lower rate.","A 2 year study programme is one that spans 18 months or more; therefore a programme could run over two academic/funding years but still be counted as a 1 year programme. All study programmes under 18 months are treated as one year programmes for the purposes of the payment."]
[null,"Prior attainment wrongly recorded","The student will not be eligible for the payment.","Students are eligible for the payment when they don't have maths and/or English GCSE grade 9 to 4 or equivalent at the start of their level 3 programme"]

{"sheet":"High value courses premium","index":13,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[20,1,22,1],[20,2,23,2],[9,3,10,3],[9,4,10,4],[13,2,15,2],[13,3,15,3],[13,4,15,4]]}
[]
[null,"Return to main page"]
[null,"Move on to condition of funding"]
[]
[null,"High value courses premium (HVCP)"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Other considerations"]
[null,"QN","Only A levels in certain subjects, or vocational level 3 qualifications larger than 360 guided learning hours (GLH) in certain sector subject areas (SSAs) qualify for the HVCP.","HVCP is intended to help to develop a more productive economy, by supporting providers to increase the number of students studying substantial level 3 study programmes in selected subjects. The subjects have been selected using data on earnings outcomes and on their relevance to the UK Industrial Strategy.","A list of qualifications is available on GOV.UK."]
[null,"Core aim","The eligible qualification has to be the core aim in order for the student to earn the premium."]
[]
[null,"Reference data","How","Why","Other considerations"]
[null,"LARS learning aim type","The LARS reference data is used to create the list of qualifications that qualify for the HVCP."]
[null,"LARS guided learning hours"]
[null,"LARS sector subject area (SSA)"]
[null,"List of qualifications that qualify for the HVCP","The core aim has to be on the list for a student to earn the premium."]
[]
[null,"Common errors"]
[null,"Recording error","Result","Explanation","Other considerations"]
[null,"Incorrect QN","The student does not qualify for HVCP","If a student's programme does not include a qualification that is on the list of those that qualify for HVCP, they will not qualify for the additional funding"]
[null,null,null,"We will not count an incorrect QN that is not an A level in one of the specified subjects."]
[null,null,null,"An incorrect QN that is not a a substantial qualification (360GLH or more) will not qualify for HVCP."]
[null,"Incorrect core aim",null,"If a student does not have a core aim that correctly identifies their programme, they are will not qualify for HVCP, as the qualifications in their programme will not meet the criteria."]

{"sheet":"Condition of funding","index":14,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,3,35,3],[3,1,4,1],[15,2,17,2],[25,2,26,2],[25,3,26,3],[30,2,36,2],[15,3,17,3],[15,4,17,4],[10,2,11,2],[8,3,14,3],[8,2,9,2],[10,4,11,4],[8,4,9,4],[12,2,13,2],[12,4,13,4]]}
[]
[null,"Return to main page"]
[]
[null,"Condition of funding on the provision of mathematics and English"]
[]
[]
[null,"Calculated using"]
[null,"Census data","How","Why","Other considerations"]
[null,"Planned learning hours (qualification hours)","A student's planned hours are used in two elements of the condition of funding logic:\n\n1) The condition of funding does not apply to students on a study programme of 150 planned hours or less.\n\n2) All students on a study programme of 485 planned hours or above who hold a GCSE grade 3, D in maths and/or English are required to undertake an approved GCSE qualification (or approved level 3 qualification) in order to meet the condition of funding. Stepping stone qualifications will not meet the condition of funding for these students.","All students starting a new study programme of 150 hours or more, aged 16 to 18, or aged 19 to 25 if they have an Education and Health Care Plan (EHCP), who do not hold a GCSE grade 9 to 4, A* to C qualification in maths and/or in English, are required to be studying these subjects as part of their study programme in each academic year.\n\nFor students not studying an approved qualification,  funding will be removed from future allocations at the national funding rate per student, for the relevant year. The approved qualifications are\n\n• GCSEs or a level 1/level 2 certificates (approved IGCSE) that count towards the English Baccalaureate (EBacc) measure, or\n\n• approved stepping stone qualifications. \n","Students holding GCSE maths/English at grade 2/E and below, or who hold grade 3/D and are undertaking a study programme of less than 485 hours can undertake approved stepping stone qualifications in order to meet the condition of funding."]
[null,"Planned enrichment, employability and pastoral hours (non-qualification hours)"]
[null,"Maths GCSE funding exemption","There are two exemptions to the condition of funding:\n\n• students with learning difficulties and/or disabilities, who are assessed as not able to study either GCSE or stepping stone qualifications;\n\n• students with overseas qualifications that are established as equivalent to GCSE grade 4, C\n\nThese fields are used to determine whether or not a student is exempt from the condition of funding for maths and/or English.\n\nUK equivalent qualifications are also recorded in these fields (these are qualifications that are not GCSEs but count as equivalencies for the purposes of the condition of funding, for example maths and English A levels).\n\n",null,"Students with a grade 2 or below in maths or English can study towards a pass in functional skills level 2 (legacy or reformed) or they can still study towards a GCSE grade 9 to 4, A* to C.\n\nStudents with a pass grade in maths or English functional skills level 2 (legacy or reformed) should be recorded as follows: \n\nFor English, record code F in the English GCSE funding exemption field\nOR\nFor maths, record code F in the Maths GCSE funding exemption field"]
[null,"English GCSE funding exemption"]
[null,"Maths GCSE highest prior attainment","These two fields are used to determine, for maths and for English, whether or not a student holds a GCSE qualification and, if so, at what grade.\n\nThis information then determines whether or not a student must undertake an approved maths and/or English qualification to meet the condition of funding.",null,"Usually the fields for highest prior attainment are completed with the grade that the student holds at the start of the year. However, if a student is resitting a GCSE, and therefore does not have a learning aim record for the qualification that would result in them meeting the condition, then the prior attainment field must be updated in-year with the result of the resit. If the student does not achieve the required grade in the resit to meet the condition, they must enrol on a maths/English qualification as necessary."]
[null,"English GCSE highest prior attainment"]
[null,"Qualification number (QN)","The QN is used to match post-16 learning aims recorded against the student into LARS to determine whether or not they are undertaking approved maths and/or English qualifications."]
[null,"Learning aim start date","The start date, planned end date and actual end date of valid maths and English learning aims in a student's study programme are used to determine whether or not the aims qualify and count towards meeting the condition of funding. Learning aims that are on the approved list of maths and English qualifications but do not meet the qualifying period do not count towards the condition of funding.\n\nThe learning aim start date should also fall between the qualification's start date and the last date for new starts of the qualification in question (the effective from and last date for new starts can be found on the list of approved qualifications in LARS).","A qualifying period is applied to valid maths and English aims to ensure that the student is fully engaged on this element of the programme to give them the best chance of attaining a grade 4, C or above at GCSE level.\n\nThe check on the learning aim start date ensures that the student started the learning aim when it was still a live qualification according to the valid date range set by the awarding organisation."]
[null,"Learning aim planned end date"]
[null,"Learning aim actual end date"]
[null,"Traineeship Indicator","Traineeships can be full or part time programmes. Students are required to meet the condition as full time or part time, according to the hours recorded for their programme.","We have changed the permitted duration of traineeships: previously they were a maximum of 6 months, but now they can be 12 months. Therefore the requirement to meet the condition of funding applies to traineeships as it does to all other full and part time study programmes."]
[null,"T Levels","The condition of funding will apply to all T Level students starting their T Level programme on or after 1st August 2022 in the same way as it does to other study programmes.",null,"Prior to 2022 to 2023, T Level students who did not hold GCSE maths and English pass grades could not achieve their T Levels - the maths and English GCSEs comprised an 'exit requirement'. There was no funding penalty for students who were on a T Level programme who did not have maths and English. This has now changed. From 2022 to 2023, students who do not have GCSE maths and/or English must study towards the relevant qualifications, following the condition of funding requirements. T Level students who do not meet the condition may have fudning removed."]
[null,"Unique pupil number (UPN) and former UPN","For some elements of the funding formula, we use the previous year's data. In the majority of cases, we do this using the unique learner number (ULN), and in its absence, the unique pupil number (UPN).","Using previous year's data allows us to look at a whole year's data, rather than a partial dataset taken midway through the year.\n\nWhen students change their UPN between census returns, institutions must return the former UPN as well as the current UPN so that we can accurately track them over the two years.\n\nThe elements of the funding formula that use data with a two-year lag are: funding rate band (planned hours), programme cost weighting, disadvantage blocks 1 and 2. "]
[]
[null,"Reference data","How","Why","Other considerations"]
[null,"LARS CoF type","This information highlights those qualifications that count as a GCSE (or approved level 3 qualification) for the purposes of the 3, D grade requirement.","All students on a study programme of 485 planned hours or above who hold a GCSE grade 3, D in maths and/or English are required to undertake an approved GCSE qualification (or approved level 3 qualification) in order to meet the condition of funding, stepping stone qualifications will not meet the condition of funding for these students."]
[null,"LARS funding validity category","This information determines whether or not a qualification is approved to be undertaken to meet the condition of funding. Only qualifications with EFACONFUNDENGLISH (for English) and EFACONFUNDMATHS (for maths) funding validity categories count as valid qualifications.","Only qualifications approved by the Department for Education as being valid English or maths GCSE, level 3 or stepping stone qualifications will count towards meeting the condition of funding."]
[null,"LARS funding validity effective from date","The student's start date on each maths/English learning aim must fall between these dates in order to count towards meeting the condition of funding.","The effective from date and the last date for new starts determine the effective date range within which a student is eligible to enrol on a qualification. These are set by the awarding organisation responsible for the qualification."]
[null,"LARS funding validity last date for new starts"]
[]
[null,"Potential errors"]
[null,"Recording error","Result","Explanation","Other considerations"]
[null,"Incorrect QN","The student is unlikely to meet the condition of funding.","An incorrect QN will result in the learning aim either not being identifiable or being identified incorrectly. As the learning aim needs to be correctly identified to ascertain whether or not it counts toward the condition of funding an incorrect QN is very likely to have an adverse effect on the student's status."]
[null,"Incorrect/missing prior attainment grades",null,"Prior attainment grades indicate whether or not a student is required to undertake approved maths and/or English qualifications in order to meet the condition of funding. If this data is missing we will assume the student does not hold the relevant qualification and, therefore, must be studying an approved qualification. If the student is not enrolled on a suitable qualification, they will not meet the condition of funding.\n\nA similar scenario is likely where incorrect prior attainment is recorded."]
[null,"Incorrect/missing exemption codes",null,"If a student is exempt from either maths or English they are not required to undertake an approved qualification in that subject in order to meet the condition of funding. If the exemption has not been recorded or has been recorded incorrectly and the student is not undertaking approved qualifications they are unlikely to meet the condition of funding."]
[null,"Incorrect start/planned end/actual end dates",null,"In order to count towards the condition of funding an approved maths or English aim must be enrolled on for a minimum qualifying period (6 weeks for those aims with a planned length of 6 weeks or more, 2 weeks for those aims with a planned length of between 2 and 6 weeks - aims with a planned length less than 2 weeks do not qualify). The start, planned end and actual end dates are used to calculate this qualifying period and if recorded incorrectly are likely to result in aims not qualifying."]
[null,"Recording maths/English aims that are not approved to count towards the condition of funding",null,"In order to count towards the condition of funding a maths/English aim must be approved and the aim start date must fall within the valid range for that qualification.\n\nThis is explained in detail in the Condition of funding valid qualifications link on the main sheet."]
[null,"Approved qualification recorded but start date outside the valid range"]
[null,"Student has a grade 3, D in maths and/or English but is not undertaking a GCSE or equivalent",null,"Any full time student with grade 3, D in maths or English must undertake a GCSE in that subject in order to meet the condition of funding."]
[null,"No former UPN recorded","The funding calculation may not match in the previous year's data.","If we cannot match the student's former UPN to a UPN recorded in the previous year's data, then we will not be able to use the right data from the previous year.\n\nThe elements of the funding formula that would use the previous year's data will not operate correctly, and the result of the funding calculation is likely to be distorted, resulting in incorrect funding. For example, if we cannot match in planned hours from the previous year, the student will have 0 planned hours, and the funding calculation will not output funding for them.","29/04/2019 - Suggest this whole row is now deleted.\nThe matching issue is now internal for SQL code only."]

{"sheet":"CoF FlowChart","index":15,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":false,"merged":[[83,6,83,16],[85,6,85,16],[1,2,1,13],[3,2,3,13],[5,2,5,13],[79,2,79,16],[82,6,82,16],[82,2,82,5],[83,2,83,5],[85,2,85,5]]}
[null,"Return to main page",null,null,null,null,null,null,null,null,null,null,null,"Go to condition of funding"]
[null,null,"This interactive tool presents the maths and English condition of funding in a step-by-step user friendly way.\n\nThe maths and English condition of funding applies to students who are funded under the 16-19 funding methodology only."]
[]
[null,null,"The interactive tool and flowchart is not intended to be exhaustive; schools and colleges are recommended to use the tool in conjunction with our detailed guidance on maths and English condition of funding below:"]
[]
[null,null,"Unless exempt, a student to whom the condition of funding applies must hold or undertake valid qualifications in both maths and English to be compliant with the condition of funding."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Useful links"]
[]
[null,null,"Guidance"]
[null,null,"Detailed information for institutions on maths and English condition of funding.",null,null,null,"www.gov.uk/16-to-19-funding-maths-and-english-condition-of-funding"]
[null,null,"How to access and use the Learning Reference Services (LARS) to find the list of qualifications that meet the funding condition on the provision of English and maths.",null,null,null,"www.gov.uk/government/publications/condition-of-funding-on-maths-and-english-qualifications-list"]
[null,null,"Reference data and systems"]
[null,null,"Find a learning aim",null,null,null,"https://findalearningaimbeta.fasst.org.uk/"]

{"sheet":"CoF FlowChart.old","index":16,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[[3,1,4,4],[3,6,4,9]]}
[]
[null,"Return to main page"]
[]
[null,"Condition of funding on the provision of mathematics and English",null,null,null,null,"Condition of funding flowchart"]

{"sheet":"CoF Interactive FlowChart","index":17,"n_rows":104,"n_cols":18,"rows_kept":104,"cut":false,"hidden":false,"merged":[[71,3,72,17],[76,7,78,15],[85,7,87,15],[0,3,0,17],[45,7,47,15],[2,2,2,18],[13,7,15,15],[21,7,23,15],[29,7,31,15],[37,7,39,15],[43,3,43,18],[97,2,97,16],[100,6,100,16],[100,2,100,5],[101,2,101,5],[103,2,103,4],[103,6,103,18],[101,6,101,16]]}
[null,null,null,"This interactive tool presents the maths and English condition of funding in a step-by-step user friendly way.\n\nThe maths and English condition of funding applies to students who are funded under the 16 to 19 funding methodology only.\n\nThe interactive tool and flowchart is not intended to be exhaustive; schools and colleges are recommended to use the tool in conjunction with our detailed guidance on maths and English condition of funding below:\n\nUnless exempt, a student to whom the condition of funding applies must hold or undertake valid qualifications in both maths and English to be compliant with the condition of funding."]
[null,null,"Return to main page",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Go to condition of funding"]
[null,null,"Condition of funding interactive flow chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Is the student under the age of 16 as at 31 August 2020 or on a programme of less than 150 hours?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Useful links"]
[]
[null,null,"Guidance"]
[null,null,"Detailed information for institutions on maths and English condition of funding.",null,null,null,"www.gov.uk/16-to-19-funding-maths-and-english-condition-of-funding"]
[null,null,"How to access and use the Learning Reference Services (LARS) to find the list of qualifications that meet the funding condition on the provision of English and maths. ",null,null,null,"www.gov.uk/government/publications/condition-of-funding-on-maths-and-english-qualifications-list"]
[null,null,"Reference data and systems"]
[null,null,"Find a learning aim (FALA)",null,null,null,"findalearningaimbeta.fasst.org.uk/"]

{"sheet":"SN_examples","index":18,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,14,6,14],[8,6,12,10],[0,10,0,13],[1,10,1,12],[1,1,1,9]]}
[null,null,null,null,null,null,null,null,null,null,"Return to student numbers"]
[null,"Student numbers\n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record.)",null,null,null,null,null,null,null,null,"Return to main sheet"]
[]
[null,"Student reference","Student name","Age","NCYear","Enrolment status","QN","Qualification title","SSA tier 2","Start date","Planned end date","Actual end date","Aim status","Core aim","Qualifies for funding"]
[null,100002,"Audrey Forsyth",17,12,"C","50067515","BTEC Subsidiary Diploma in Sport (QCF)","08.1","2014-09-02","30/07/2015","30/07/2015",2,1,"Y",null,null,{"$f":"K5-J5","v":331}]
[null,100002,"Audrey Forsyth",17,12,"C","5002193X","GCE A Level in Geology","02.1","2014-09-02","30/07/2015","30/07/2015",2,0,null,null,null,{"$f":"IF(L5=\"\",999,(L5-J5))","v":331}]
[null,100002,"Audrey Forsyth",17,12,"C","50025004","GCE A Level in Psychology A","02.1","2014-09-02","30/07/2015","30/07/2015",2,0]
[]
[null,null,null,null,null,null,{"$f":"IF(E5<12,\"Only students in national curriculum years 12, 13 or 14 are selected for funding purposes so this student is excluded from all calculation elements.\",IF(F5=\"S\",\"Only students with main or current main registration are selected for funding purposes so this student is excluded from all calculation elements.\",IF(R5<14,\"The planned length of the students programme (based on the ealiest start date and latest planned end date in the funding year) is less than two weeks. Therefore the student does not qualify for funding and is excluded from all calculation elements.\",IF(R6<42,\"The 6 week qualifying period for this programme has not been met, therefore the student does not qualify for funding and is excluded from all calculation elements.\",\"The student counts for funding purposes.\"))))","v":"The student counts for funding purposes."}]

{"sheet":"NR_examples","index":19,"n_rows":33,"n_cols":40,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,4],[0,1,0,15],[2,17,4,18],[6,17,8,18],[10,17,12,18],[14,17,16,18],[31,1,31,4]]}
[null,"National funding rate per student (full-time/part-time bands)\n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record)"]
[null,"Student reference","Student name","Funded student","Age at 31 Aug","Earliest Start date","Latest Planned End Date","Latest Actual End Date","Top-up Indicator","Planned Learning hours","Planned Employability, Enrichment and Pastoral Hours","Total planned hours","18 Plus High Needs?",null,"Funding band","National funding rate",null,null,null,null,null,null,null,null,"Student Reference","Student Name","Funded Student","Age at 31 Aug","Earliest Start date","Latest Planned End Date","Latest Actual End Date","Top-up Indicator","Planned Learning hours","Planned Employability, Enrichment and Pastoral Hours","Total Planned Hours","18 Plus High Needs?",null,"Funding Band","National Funding Rate"]
[null,100001,"Stephen Bailey",1,16,"2014-09-01","2015-07-20",null,null,490,180,{"$f":"SUM(J3:K3)","v":670},{"$f":"IF(AND(E3>=18,I3=1),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(L3>=485,E3>=18,M3=\"N\"),5,IF(L3>=580,6,IF(L3>=485,4,IF(L3>=385,3,IF(L3>=300,2,1)))))","v":6},{"$f":"INDEX($U$3:$U$8,MATCH(N3,$T$3:$T$8,0),1)","v":"580+"},{"$f":"IF(O3=\"0-299\",(L3/640)*4542,INDEX($V$3:$V$8,MATCH(N3,$T$3:$T$8,0),1))","v":4542},null,{"$f":"IF(AND(J3=0,K3=0),\"Recording no planned hours will remove all funding from the student\",\"\")","v":""},null,6,"580+",4542,null,null,100001,"Stephen Bailey",1,16,"2014-09-01","2015-07-20",null,null,490,180,{"$f":"SUM(AG3:AH3)","v":670},{"$f":"IF(AND(AB3>=18,AF3=1),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(AI3>=485,AB3>=18,AJ3=\"N\"),5,IF(AI3>=580,6,IF(AI3>=485,4,IF(AI3>=385,3,IF(AI3>=300,2,1)))))","v":6},{"$f":"INDEX($U$3:$U$8,MATCH(AK3,$T$3:$T$8,0),1)","v":"580+"},{"$f":"IF(AL3=\"0-299\",(AI3/640)*4542,INDEX($V$3:$V$8,MATCH(AK3,$T$3:$T$8,0),1))","v":4542},{"$f":"AM3-P3","v":0}]
[null,100004,"Isaac Stewart",1,18,"2014-09-01","2015-07-20",null,null,520,120,{"$f":"SUM(J4:K4)","v":640},{"$f":"IF(AND(E4>=18,I4=1),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(L4>=485,E4>=18,M4=\"N\"),5,IF(L4>=580,6,IF(L4>=485,4,IF(L4>=385,3,IF(L4>=300,2,1)))))","v":5},"485+",{"$f":"IF(O4=\"0-299\",(L4/640)*4542,INDEX($V$3:$V$8,MATCH(N4,$T$3:$T$8,0),1))","v":3757},null,null,null,5,"485+",3757,null,null,100004,"Isaac Stewart",1,18,"2014-09-01","2015-07-20",null,null,520,120,{"$f":"SUM(AG4:AH4)","v":640},{"$f":"IF(AND(AB4>=18,AF4=1),\"Y\",\"N\")","v":"N"},5,"485+",{"$f":"IF(AL4=\"0-299\",(AI4/640)*4542,INDEX($V$3:$V$8,MATCH(AK4,$T$3:$T$8,0),1))","v":3757},{"$f":"AM4-P4","v":0}]
[null,100005,"Max Campbell",1,16,"2014-09-02","2015-07-20",null,1,510,150,660,"N",6,"580+",4542,null,null,null,4,"485-579",3757,null,null,100005,"Max Campbell",1,16,"2014-09-02","2015-07-20",null,1,510,150,660,"N",6,"580+",4542,0]
[null,100008,"Alexandra McLean",1,17,"2014-09-01","2015-07-20",null,null,440,150,590,"N",6,"580+",4542,null,null,null,3,"385-484",3056,null,null,100008,"Alexandra McLean",1,17,"2014-09-01","2015-07-20",null,null,440,150,590,"N",6,"580+",4542,0]
[null,100010,"Isaac Nash",1,17,"2014-09-01","2015-07-20",null,null,360,120,480,"N",3,"385-484",3056,null,{"$f":"IF(AND(J3>50,K3=0),\"Recording no non-qualification hours will reduce funding for the student\",\"\")","v":""},null,2,"300-384",2416,null,null,100010,"Isaac Nash",1,17,"2014-09-01","2015-07-20",null,null,360,120,480,"N",{"$f":"IF(AND(AI7>=485,AB7>=18,AJ7=\"N\"),5,IF(AI7>=580,6,IF(AI7>=485,4,IF(AI7>=385,3,IF(AI7>=300,2,1)))))","v":3},"385-484",3056,0]
[null,100011,"Gabrielle Vaughan",1,17,"2014-09-01","2015-07-20",null,null,490,180,670,"N",6,"580+",4542,null,null,null,1,"0-299",4542,null,null,100011,"Gabrielle Vaughan",1,17,"2014-09-01","2015-07-20",null,null,490,180,670,"N",{"$f":"IF(AND(AI8>=485,AB8>=18,AJ8=\"N\"),5,IF(AI8>=580,6,IF(AI8>=485,4,IF(AI8>=385,3,IF(AI8>=300,2,1)))))","v":6},"580+",4542,0]
[null,100012,"Liam Morgan",1,18,"2014-09-01","2015-07-20",null,1,630,50,680,"Y",6,"580+",4542,null,null,null,null,null,null,null,null,100012,"Liam Morgan",1,18,"2014-09-01","2015-07-20",null,1,630,50,680,"Y",6,"580+",4542,0]
[null,100014,"Lillian Scott",1,18,"2013-09-04","2015-07-20",null,1,240,30,270,"Y",1,"0-299",1916.15625,null,null,null,null,null,null,null,null,100014,"Lillian Scott",1,18,"2013-09-04","2015-07-20",null,1,240,30,{"$f":"SUM(AG10:AH10)","v":270},"Y",1,"0-299",1916.15625,0]
[null,100016,"Dylan Mills",1,18,"2014-09-01","2015-07-20",null,null,390,50,440,"N",3,"385-484",3056,null,{"$f":"IF(AND(J3 >1,J3< 50),\"Recording weekly hours will reduce funding for the student\",\"\")","v":""},null,null,null,null,null,null,100016,"Dylan Mills",1,18,"2014-09-01","2015-07-20",null,null,390,50,440,"N",3,"385-484",3056,0]
[null,100019,"Rachel Morgan",1,16,"2014-09-01","2015-07-20",null,null,330,40,370,"N",2,"300-384",2416,null,null,null,null,null,null,null,null,100019,"Rachel Morgan",1,16,"2014-09-01","2015-07-20",null,null,330,40,370,"N",2,"300-384",2416,0]
[null,100022,"Wanda Watson",1,17,"2014-09-01","2015-07-20",null,null,560,100,660,"N",6,"580+",4542,null,null,null,null,null,null,null,null,100022,"Wanda Watson",1,17,"2014-09-01","2015-07-20",null,null,560,100,660,"N",6,"580+",4542,0]
[null,100023,"Joanne Greene",1,18,"2013-09-03","2015-07-20",null,1,480,80,560,"Y",4,"485-579",3757,null,null,null,null,null,null,null,null,100023,"Joanne Greene",1,18,"2013-09-03","2015-07-20",null,1,480,80,560,"Y",4,"485-579",3757,0]
[null,100025,"Ava Peters",1,17,"2014-09-01","2015-07-20",null,null,490,100,590,"N",6,"580+",4542,null,{"$f":"IF(I14=0,\"A missing top-up indicator can affect the funding band of the student and reduce funding\",\"\")","v":""},null,null,null,null,null,null,100025,"Ava Peters",1,17,"2014-09-01","2015-07-20",null,null,490,100,590,"N",6,"580+",4542,0]
[null,100026,"Felicity Langdon",1,16,"2014-09-01","2015-07-20",null,1,460,110,570,"N",4,"485-579",3757,null,null,null,null,null,null,null,null,100026,"Felicity Langdon",1,16,"2014-09-01","2015-07-20",null,1,460,110,570,"N",4,"485-579",3757,0]
[null,100028,"Ruth Rampling",1,18,"2014-09-01","2015-07-20",null,null,390,80,470,"N",3,"385-484",3056,null,null,null,null,null,null,null,null,100028,"Ruth Rampling",1,18,"2014-09-01","2015-07-20",null,null,390,80,470,"N",3,"385-484",3056,0]
[null,100030,"Dorothy Hardacre",1,17,"2014-09-01","2015-07-20",null,null,440,70,510,"N",4,"485-579",3757,null,null,null,null,null,null,null,null,100030,"Dorothy Hardacre",1,17,"2014-09-01","2015-07-20",null,null,440,70,510,"N",4,"485-579",3757,0]
[]
[null,null,null,null,null,null,null,null,null,null,"Total national rate funding",null,null,null,null,{"$f":"SUM(P3:P19)","v":60322.15625}]
[null,"540+",{"$f":"COUNTIF(O3:O18,B21)","v":0},{"$f":"C21/SUM($C$21:$C$26)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"ROUND($D$30*D21,0)","v":{"$error":"#DIV/0!"}}]
[null,"450+",{"$f":"COUNTIF(O3:O18,B22)","v":0},{"$f":"C22/SUM($C$21:$C$26)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"ROUND($D$30*D22,0)","v":{"$error":"#DIV/0!"}}]
[null,"450-539",{"$f":"COUNTIF(O3:O18,B23)","v":0},{"$error":"#DIV/0!"},null,null,null,null,{"$error":"#DIV/0!"}]
[null,"360-449",{"$f":"COUNTIF(O3:O18,B24)","v":0},{"$error":"#DIV/0!"},null,null,null,null,{"$error":"#DIV/0!"}]
[null,"280-359",{"$f":"COUNTIF(O3:O18,B25)","v":0},{"$error":"#DIV/0!"},null,null,null,null,{"$error":"#DIV/0!"}]
[null,"0-279",{"$f":"COUNTIF(O3:O18,B26)","v":0},{"$error":"#DIV/0!"},null,null,null,null,{"$error":"#DIV/0!"}]
[]
[null,null,{"$f":"SUM(C21:C27)","v":0},{"$f":"SUM(D21:D27)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(I21:I27)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Lagged Student Number",null,25]
[]
[null,"Return to national funding rate per student"]
[null,"Return to main sheet"]

{"sheet":"RET_examples","index":20,"n_rows":29,"n_cols":26,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,13,27,15],[28,13,28,15],[0,1,0,6],[8,5,12,7],[16,14,18,14],[16,15,18,15],[20,5,24,7],[3,14,6,14],[3,15,6,15]]}
[null,"Student retention\n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record)"]
[null,"Example 1 - invalid qualification numbers (QNs)"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA tier 2","Start Date","Planned End Date","Actual End Date","Learning aim status","Core aim","Qualification category","Programme category","Retention status",null,null,"Only retained aims","Core aim status","Core Aim status desc",null,"LearnAimRef","LearnAimRefTitle","LearnAimRefTypeDesc","Qualification category"]
[null,100011,"Gabrielle Vaughan",16,50022635,{"$f":"IF(ISERROR(MATCH(E4,W:W,0))=TRUE,\"No match\",INDEX(X:Y,MATCH(E4,W:W,0),1))","v":"GCE AS Level in Sociology"},{"$f":"IF(ISERROR(MATCH(E4,W:W,0))=TRUE,\"No match\",INDEX(X:Y,MATCH(E4,W:W,0),2))","v":"GCE AS level"},"02.1","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G4=\"No match\",\"Unknown\",INDEX($Z$4:$Z$7,MATCH($E4,$W$4:$W$7,0)))","v":"Academic"},{"$f":"IF(SUM(M4:M7)>0,\"Vocational\",\"Academic\")","v":"Academic"},{"$f":"IF(O4=\"Academic\",IF(OR(S4=1,S4=2,S5=1,S5=1,S6=1,S6=2,S7=1,S7=2),\"Retained\",\"Not retained\"),IF(OR(U4=\"Retained\",U5=\"Retained\",U6=\"Retained\",U7=\"Retained\"),\"Retained\",\"Not retained\"))","v":"Retained"},null,null,{"$f":"IF(N4=$O$4,L4,\"\")","v":2},{"$f":"IF(M4=1,L4,\"\")","v":""},{"$f":"IF(OR(T4=1,T4=2),\"Retained\",\"Not Retained\")","v":"Not Retained"},null,50022635,"GCE AS Level in Sociology","GCE AS level","Academic"]
[null,100011,"Gabrielle Vaughan",16,50022696,{"$f":"IF(ISERROR(MATCH(E5,W:W,0))=TRUE,\"No match\",INDEX(X:Y,MATCH(E5,W:W,0),1))","v":"GCE AS Level in Biology"},{"$f":"IF(ISERROR(MATCH(E5,W:W,0))=TRUE,\"No match\",INDEX(X:Y,MATCH(E5,W:W,0),2))","v":"GCE AS level"},"12.1","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G5=\"No match\",\"Unknown\",INDEX($Z$4:$Z$7,MATCH($E5,$W$4:$W$7,0)))","v":"Academic"},null,null,null,null,{"$f":"IF(N5=$O$4,L5,\"\")","v":2},{"$f":"IF(M5=1,L5,\"\")","v":""},{"$f":"IF(OR(T5=1,T5=2),\"Retained\",\"Not Retained\")","v":"Not Retained"},null,50022696,"GCE AS Level in Biology","GCE AS level","Academic"]
[null,100011,"Gabrielle Vaughan",16,"5002498X",{"$f":"IF(ISERROR(MATCH(E6,W:W,0))=TRUE,\"No match\",INDEX(X:Y,MATCH(E6,W:W,0),1))","v":"GCE AS Level in English Language B"},{"$f":"IF(ISERROR(MATCH(E6,W:W,0))=TRUE,\"No match\",INDEX(X:Y,MATCH(E6,W:W,0),2))","v":"GCE AS level"},"11.1","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G6=\"No match\",\"Unknown\",INDEX($Z$4:$Z$7,MATCH($E6,$W$4:$W$7,0)))","v":"Academic"},null,null,null,null,2,{"$f":"IF(M6=1,L6,\"\")","v":""},"Not Retained",null,"5002498X","GCE AS Level in English Language B","GCE AS level","Academic"]
[null,100011,"Gabrielle Vaughan",16,50025946,{"$f":"IF(ISERROR(MATCH(E7,W:W,0))=TRUE,\"No match\",INDEX(X:Y,MATCH(E7,W:W,0),1))","v":"GCE AS Level in Geography"},{"$f":"IF(ISERROR(MATCH(E7,W:W,0))=TRUE,\"No match\",INDEX(X:Y,MATCH(E7,W:W,0),2))","v":"GCE AS level"},"11.2","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G7=\"No match\",\"Unknown\",INDEX($Z$4:$Z$7,MATCH($E7,$W$4:$W$7,0)))","v":"Academic"},null,null,null,null,2,{"$f":"IF(M7=1,L7,\"\")","v":""},"Not Retained",null,50025946,"GCE AS Level in Geography","GCE AS level","Academic"]
[]
[null,null,null,null,null,{"$f":"IF(P4=\"Not Retained\",\"The aim type cannot be determined for invalid QANs meaning the aims default to vocational. The programme is academic but no academic aims are found, hence the student is not retained\",\"The student is retained\")","v":"The student is retained"}]
[]
[]
[]
[]
[]
[null,"Example 2 - incorrect aim status"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA tier 2","Start Date","Planned End Date","Actual End Date","Learning aim status","Core aim","Qualification category","Programme category","Retention status"]
[null,100009,"Matt McGrath",18,"5002498X","GCE A Level in Geography","GCE A Level","11.1","2013-09-02","2014-07-21","2014-07-21",2,0,"Academic","Vocational",{"$f":"IF(L18=3,\"Not retained\",\"Retained\")","v":"Retained"}]
[null,100009,"Matt McGrath",18,50025946,"BTEC Subsidiary Diploma in Applied Science (QCF)","Diploma","02.1","2013-09-02","2014-07-21","2014-07-21",2,1,"Vocational"]
[null,100009,"Matt McGrath",18,50067254,"GCE A Level in Psychology A","GCE A Level","02.1","2013-09-02","2014-07-21","2014-07-21",2,0,"Academic"]
[]
[null,null,null,null,null,{"$f":"IF(P17=\"Not Retained\",\"The core aim in this vocational programme is erroniously recorded as withdrawn meaning the aim (and the student) is not retained\",\"The student is retained\")","v":"The student is retained"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to retention"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to main page"]

{"sheet":"CORE_examples","index":21,"n_rows":29,"n_cols":25,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,13,27,15],[28,13,28,15],[16,14,19,14],[16,15,19,15],[0,1,0,6],[3,14,6,14],[3,15,6,15],[8,5,12,7],[21,5,27,7]]}
[null,"Core aims\n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record)"]
[null,"Example 1 - incorrect core aim"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA tier 2","Start Date","Planned End Date","Actual End Date","Learning aim status","Core aim","Qualification category","Programme category","Retention status",null,null,"Only retained aims","Core aim status","Core Aim status desc"]
[null,100018,"Christian Graham",17,50067254,{"$f":"IF(ISERROR(MATCH(E4,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E4,W:W,0),1))","v":"BTEC Subsidiary Diploma in Applied Science (QCF)"},{"$f":"IF(ISERROR(MATCH(E4,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E4,W:W,0),2))","v":"Diploma"},"02.1","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G4=\"GCE AS level\",\"Academic\",IF(G4=\"GCSE\",\"Academic\",\"Vocational\"))","v":"Vocational"},{"$f":"IF(SUM(M4:M7)>0,\"Vocational\",\"Academic\")","v":"Vocational"},{"$f":"IF(O4=\"Academic\",IF(OR(S4=1,S4=2,S5=1,S5=1,S6=1,S6=2,S7=1,S7=2),\"Retained\",\"Not Retained\"),IF(OR(U4=\"Retained\",U5=\"Retained\",U6=\"Retained\",U7=\"Retained\"),\"Retained\",\"Not Retained\"))","v":"Retained"},null,null,{"$f":"IF(N4=$O$4,L4,\"\")","v":2},{"$f":"IF(M4=1,L4,\"\")","v":""},{"$f":"IF(OR(T4=1,T4=2),\"Retained\",\"Not Retained\")","v":"Not Retained"},null,"LearnAimRef","LearnAimRefTitle","LearnAimRefTypeDesc"]
[null,100018,"Christian Graham",17,50091475,{"$f":"IF(ISERROR(MATCH(E5,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E5,W:W,0),1))","v":"Subsidiary Diploma in IT (QCF)"},{"$f":"IF(ISERROR(MATCH(E5,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E5,W:W,0),2))","v":"Diploma"},"06.1","2013-09-02","2014-07-21","2014-07-21",2,1,{"$f":"IF(G5=\"GCE AS level\",\"Academic\",IF(G5=\"GCSE\",\"Academic\",\"Vocational\"))","v":"Vocational"},null,null,null,null,{"$f":"IF(N5=$O$4,L5,\"\")","v":2},{"$f":"IF(M5=1,L5,\"\")","v":2},{"$f":"IF(OR(T5=1,T5=2),\"Retained\",\"Not Retained\")","v":"Retained"},null,50022635,"GCE AS Level in Sociology","GCE AS level"]
[null,100018,"Christian Graham",17,60131597,{"$f":"IF(ISERROR(MATCH(E6,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E6,W:W,0),1))","v":"GCSE in English"},{"$f":"IF(ISERROR(MATCH(E6,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E6,W:W,0),2))","v":"GCSE"},"12.1","2013-09-02","2014-07-21","2014-01-13",3,0,"Academic",null,null,null,null,{"$f":"IF(N6=$O$4,L6,\"\")","v":""},{"$f":"IF(M6=1,L6,\"\")","v":""},"Not Retained",null,50022696,"GCE AS Level in Biology","GCE AS level"]
[null,100018,"Christian Graham",17,50067503,{"$f":"IF(ISERROR(MATCH(E7,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E7,W:W,0),1))","v":"BTEC Subsidiary Diploma in Business (QCF)"},{"$f":"IF(ISERROR(MATCH(E7,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E7,W:W,0),2))","v":"Diploma"},"15.3","2013-09-02","2014-07-21","2014-07-21",2,0,"Vocational",null,null,null,null,{"$f":"IF(N7=$O$4,L7,\"\")","v":2},{"$f":"IF(M7=1,L7,\"\")","v":""},"Not Retained",null,"5002498X","GCE AS Level in English Language B","GCE AS level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50025946,"GCE AS Level in Geography","GCE AS level"]
[null,null,null,null,null,{"$f":"IF(M5=0,\"The student is following a vocational programme but does not have a core aim identified, therefore is treated as academic. With only 1 academic aim - which is set to withdrawn - the student is not retained.\",\"The student is retained\")","v":"The student is retained"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50067254,"BTEC Subsidiary Diploma in Applied Science (QCF)","Diploma"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,50067503,"BTEC Subsidiary Diploma in Business (QCF)","Diploma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50091475,"Subsidiary Diploma in IT (QCF)","Diploma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60131597,"GCSE in English","GCSE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50069329","Certificate in Photography","Certificate"]
[]
[null,"Example 2 - core aim recorded for an academic programme"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA tier 2","Start Date","Planned End Date","Actual End Date","Learning aim status","Core aim","Qualification category","Programme category","Retention status",null,null,"Only retained aims","Core aim status","Core Aim status desc"]
[null,100851,"Ife Adeola",16,50022696,{"$f":"IF(ISERROR(MATCH(E17,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E17,W:W,0),1))","v":"GCE AS Level in Biology"},{"$f":"IF(ISERROR(MATCH(E17,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E17,W:W,0),2))","v":"GCE AS level"},"09.3",null,null,null,3,0,"Vocational",{"$f":"IF(SUM(M17:M20)>0,\"Vocational\",\"Academic\")","v":"Academic"},{"$f":"IF(O17=\"Academic\",IF(OR(S17=1,S17=2,S18=1,S18=1,S19=1,S19=2,S20=1,S20=2),\"Retained\",\"Not Retained\"),IF(OR(U17=\"Retained\",U18=\"Retained\",U19=\"Retained\",U20=\"Retained\"),\"Retained\",\"Not Retained\"))","v":"Retained"},null,null,{"$f":"IF(N17=$O$17,L17,\"\")","v":""},{"$f":"IF(M17=1,L17,\"\")","v":""},{"$f":"IF(OR(T17=1,T17=2),\"Retained\",\"Not Retained\")","v":"Not Retained"}]
[null,100851,"Ife Adeola",16,"5002498X",{"$f":"IF(ISERROR(MATCH(E18,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E18,W:W,0),1))","v":"GCE AS Level in English Language B"},{"$f":"IF(ISERROR(MATCH(E18,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E18,W:W,0),2))","v":"GCE AS level"},12.1,null,null,null,2,0,"Academic",null,null,null,null,{"$f":"IF(N18=$O$17,L18,\"\")","v":2},{"$f":"IF(M18=1,L18,\"\")","v":""},{"$f":"IF(OR(T18=1,T18=2),\"Retained\",\"Not Retained\")","v":"Not Retained"}]
[null,100851,"Ife Adeola",16,50025946,{"$f":"IF(ISERROR(MATCH(E19,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E19,W:W,0),1))","v":"GCE AS Level in Geography"},{"$f":"IF(ISERROR(MATCH(E19,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E19,W:W,0),2))","v":"GCE AS level"},"02.1","2013-09-02","2014-07-21","2014-01-13",2,0,"Academic",null,null,null,null,{"$f":"IF(N19=$O$17,L19,\"\")","v":2},{"$f":"IF(M19=1,L19,\"\")","v":""},"Not Retained"]
[null,100851,"Ife Adeola",16,"50069329",{"$f":"IF(ISERROR(MATCH(E20,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E20,W:W,0),1))","v":"Certificate in Photography"},{"$f":"IF(ISERROR(MATCH(E20,W:W,0))=TRUE,\"No Match\",INDEX(X:Y,MATCH(E20,W:W,0),2))","v":"Certificate"},"09.2",null,null,null,2,0,"Academic",null,null,null,null,{"$f":"IF(N20=$O$17,L20,\"\")","v":2},{"$f":"IF(M20=1,L20,\"\")","v":""},"Not Retained"]
[]
[null,null,null,null,null,{"$f":"IF(M17=1,S22,\"The student is retained\")","v":"The student is retained"},null,null,null,null,null,null,null,null,null,null,null,null,"An academic aim has been recorded as the core aim. As core aims should only be recorded for vocational programmes or mixed programmes with a vocational core, this denotes the programme is vocational and not academic. Because the student has withdrawn from that aim (status 3), they are not retained on it. Therefore the student is not retained for the whole of their programme, as students on vocational programmes have to be retained on their core aim to count as retained for the programme."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to retention"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to main page"]

{"sheet":"PCW_examples","index":22,"n_rows":36,"n_cols":25,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,14,6,14],[4,15,6,15],[17,14,19,14],[17,15,19,15],[8,5,12,8],[35,5,39,8],[30,7,33,7],[30,8,33,8],[1,1,1,10],[21,5,25,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Return to main sheet"]
[null,"Programme cost weighting\n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record)",null,null,null,null,null,null,null,null,null,null,"Return to programme cost weighting"]
[]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA tier 2","Start Date","Planned End Date","Actual End Date","Learning aim status","Core aim","Qualification category","Programme category","Programme weighting"]
[null,100033,"Alison Morgan",18,"50091475","Subsidiary Diploma in IT (QCF)","Diploma","06.1","2013-09-02","2014-07-21","2014-07-21",2,1,{"$f":"IF(M5=1,\"Vocational\",\"Academic\")","v":"Vocational"},{"$f":"IF(M5=1,\"Vocational\",\"Academic\")","v":"Vocational"},{"$f":"IF(O5=\"Vocational\",INDEX($T$18:$T$22,MATCH(H5,R18:R22,0),1),1)","v":1.2}]
[null,100033,"Alison Morgan",18,"50024978","GCE A Level in English Language B","GCE A Level","12.1","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G6=\"Diploma\", \"Vocational\",\"Academic\")","v":"Academic"}]
[null,100033,"Alison Morgan",18,"50025892","GCE A Level in Media Studies","GCE A Level","09.3","2013-09-02","2014-07-21","2014-07-21",2,0,"Academic"]
[]
[null,null,null,null,null,{"$f":"IF(M5=0,\"A core aim has not been returned for any aims in this vocational study programme. This means the programme is treated as academic and the student will, therefore, attract the base weighting of 1.\",\"The student receives the 1.2 vocational weighting\")","v":"The student receives the 1.2 vocational weighting"}]
[]
[]
[]
[]
[]
[]
[]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA tier 2","Start Date","Planned End Date","Actual End Date","Learning aim status","Core aim","Qualification category","Programme category","Programme weighting"]
[null,100023,"Joanne Greene",17,10040973,{"$f":"IF(LEN($E18)<8,\"No match\",W18)","v":"BTEC Diploma in Graphics"},{"$f":"IF(LEN($E18)<8,\"No match\",X18)","v":"Diploma"},"09.2","2013-09-03","2015-07-21",null,1,1,"Vocational",{"$f":"IF(N18=\"Academic\",\"Academic\",\"Vocational\")","v":"Vocational"},{"$f":"IF(O18=\"Vocational\",INDEX($S$18:$T$22,MATCH(H18,$R$18:$R$22,0),2),1)","v":1.2},null,"06.1","Medium",1.2,null,10040973,"BTEC Diploma in Graphics","Diploma","09.2"]
[null,100023,"Joanne Greene",17,"50022210",{"$f":"IF(LEN($E19)<8,\"No match\",W19)","v":"GCE AS Level in Dance"},"GCE AS Level","09.1","2013-09-03","2014-07-21","2014-07-21",2,0,"Academic",null,null,null,"12.1","Base",1,null,"50022210","GCE AS Level in Dance","GCE AS Level","09.1"]
[null,100023,"Joanne Greene",17,"50025995","GCE AS Level in Media Studies","GCE AS Level","09.3","2013-09-03","2014-07-21","2014-07-21",2,0,"Academic",null,null,null,"09.3","Base",1,null,"50025995","GCE AS Level in Media Studies","GCE AS Level","09.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09.2","Medium",1.2]
[null,null,null,null,null,{"$f":"IF(O18=\"Academic\",\"The sector subject area cannot be determined for invalid QANs, meaning a weighting of 1 is assigned. The student will, therefore, attract the base weighting of 1.\",\"The student receives the 1.2 vocational weighting\")","v":"The student receives the 1.2 vocational weighting"},null,null,null,null,null,null,null,null,null,null,null,"09.1","Medium",1.2]
[]
[]
[]
[]
[]
[]
[]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","Core aim","Programme type","Programme weighting"]
[null,100024,"Noor Holloway",16,"ZPROG001","Programme aim",0,"T Level",{"$f":"IF(E32=\"ZTLOS002\",1.3,1)","v":1.3}]
[null,100024,"Noor Holloway",16,"ZTLOS002",{"$f":"IF(E32=\"ZTLOS002\",\"T Level Occupational Specialism - Civil engineering\",\"No occupational specialism recorded\")","v":"T Level Occupational Specialism - Civil engineering"},{"$f":"IF(E32=\"ZTLOS002\",\"0\",\"-\")","v":"0"}]
[null,100024,"Noor Holloway",16,"None","T Level Technical Qualification in Design, Surveying and Planning for Construction",1]
[null,100024,"Noor Holloway",16,"6031364X","GCE A Level in Further Mathematics B (MEI)",0]
[]
[null,null,null,null,null,{"$f":"IF(I31=1.3,\"The student has a valid ZTLOS code recorded to indicate the occupational specialism for their T Level and therefore receives the correct weighting.\",\"The student has no ZTLOS code recorded for their occupational specialism, and therefore receives no programme weighting uplift.\")","v":"The student has a valid ZTLOS code recorded to indicate the occupational specialism for their T Level and therefore receives the correct weighting."}]

{"sheet":"DIS_examples","index":23,"n_rows":37,"n_cols":26,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,5,36,7],[3,1,3,11],[24,1,24,3],[25,1,25,3],[24,6,28,15],[29,6,33,15],[35,5,35,7]]}
[]
[]
[]
[null,"Disadvantage\n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record)"]
[]
[null,"Student reference","Student name","Funded student","Age at 31 Aug","Postcode","Earliest start date","Latest planned end date","Latest actual end date","Disadvantage block 1 uplift","Maths GCSE prior attainment year 11","English GCSE prior attainment year 11","Total block 2 instances","Planned learning hours","Planned employability, enrichment and pastoral hours","Total planned hours",null,null,null,"Postcode","Maths prior attainment by end of Year 11","English prior attainment by end of Year 11"]
[null,100001,"Stephen Bailey",1,16,"B19 2SW","2014-09-01","2015-07-20",null,{"$f":"IF(ISERROR(MATCH(F7,$Y$8:$Y$13,0))=TRUE,1,INDEX($Z$8:$Z$13,MATCH(F7,$Y$8:$Y$13,0),1))","v":1.0900000000000001},2,2,{"$f":"IF(OR(K7=2,K7=3),1,0)+IF(OR(L7=2,L7=3),1,0)","v":2},450,180,630,null,null,null,"B19 2SW",2,2]
[null,100004,"Isaac Stewart",1,18,"B8 3QU","2014-09-01","2015-07-20",null,{"$f":"IF(ISERROR(MATCH(F8,$Y$8:$Y$13,0))=TRUE,1,INDEX($Z$8:$Z$13,MATCH(F8,$Y$8:$Y$13,0),1))","v":1.07},1,1,{"$f":"IF(OR(K8=2,K8=3),1,0)+IF(OR(L8=2,L8=3),1,0)","v":0},480,120,600,null,null,null,"B8 3QU",1,1,null,"lee bank","B15 2AX",1.02]
[null,100005,"Max Campbell",1,16,"B23 6RE","2014-09-02","2015-07-20",null,1.03,1,1,0,470,150,620,null,null,null,"B23 6RE",1,1,null,"sbrook","B11 1LU",1.02]
[null,100008,"Alexandra McLean",1,17,"B8 3QU","2014-09-01","2015-07-20",null,1.07,3,1,1,400,150,550,null,null,null,"B8 3QU",3,1,null,"erdington","B23 6RE",1.03]
[null,100010,"Isaac Nash",1,17,"B31 1PG","2014-09-01","2015-07-20",null,1.1100000000000001,3,2,2,320,120,440,null,null,null,"B31 1PG",3,2,null,"northfield","B31 1PG",1.1100000000000001]
[null,100011,"Gabrielle Vaughan",1,17,"B23 6RE","2014-09-01","2015-07-20",null,1.03,1,1,0,450,180,630,null,null,null,"B23 6RE",1,1,null,"saltley","B8 3QU",1.07]
[null,100012,"Liam Morgan",1,18,"B8 3QU","2014-09-01","2015-07-20",null,1.07,2,2,2,590,50,640,null,null,null,"B8 3QU",2,2,null,"newtown","B19 2SW",1.0900000000000001]
[null,100014,"Lillian Scott",1,18,"B15 2AX","2013-09-04","2015-07-20",null,1.02,1,1,0,200,30,230,null,null,null,"B15 2AX",1,1]
[null,100016,"Dylan Mills",1,18,"B19 2SW","2014-09-01","2015-07-20",null,1.0900000000000001,2,1,1,350,50,400,null,null,null,"B19 2SW",2,1]
[null,100019,"Rachel Morgan",1,16,"B19 2SW","2014-09-01","2015-07-20",null,1.0900000000000001,1,1,0,290,40,330,null,null,null,"B19 2SW",1,1]
[null,100022,"Wanda Watson",1,17,"B31 1PG","2014-09-01","2015-07-20",null,1.1100000000000001,2,2,2,520,100,620,null,null,null,"B31 1PG",2,2]
[null,100023,"Joanne Greene",1,18,"B15 2AX","2013-09-03","2015-07-20",null,1.02,2,1,1,440,80,520,null,null,null,"B15 2AX",2,1]
[null,100025,"Ava Peters",1,17,"B19 2SW","2014-09-01","2015-07-20",null,1.0900000000000001,2,2,2,450,100,550,null,null,null,"B19 2SW",2,2]
[null,100026,"Felicity Langdon",1,16,"B23 6RE","2014-09-01","2015-07-20",null,1.03,1,1,0,420,110,530,null,null,null,"B23 6RE",1,1]
[null,100028,"Ruth Rampling",1,18,"B31 1PG","2014-09-01","2015-07-20",null,1.1100000000000001,2,2,2,350,80,430,null,null,null,"B31 1PG",2,2]
[null,100030,"Dorothy Hardacre",1,17,"B23 6RE","2014-09-01","2015-07-20",null,1.03,1,1,0,400,70,470,null,null,null,"B23 6RE",1,1]
[]
[]
[null,"Disadvantage block 1 factor",null,null,{"$f":"AVERAGE(J7:J22)","v":1.0662500000000001},null,{"$f":"IF(E25<1.065,\"Incorrect or missing postcodes mean disadvantage uplift data cannot be matched to the student bringing the institutions overall disadvantage block 1 factor down and reducing disadvantage funding allocated.\",\"Postcode data is accurate and disadvantage block 1 factor and funding is correct\")","v":"Postcode data is accurate and disadvantage block 1 factor and funding is correct"}]
[null,"Disadvantage block 2 instances per student",null,null,{"$f":"SUM(M7:M22)/SUM(D7:D22)","v":0.9375}]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(E26<0.935,\"Incorrect or missing prior attainment data means disadvantage block 2 instances per student are incorrect reducing the institution's overall disadvantage block 2 funding allocated.\",\"Prior attainment data is accurate and disadvantage block 2 funding is correct\")","v":"Prior attainment data is accurate and disadvantage block 2 funding is correct"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Return to main sheet"]
[null,null,null,null,null,"Return to disadvantage"]

{"sheet":"T_Level_examples","index":24,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[39,13,42,13],[16,8,19,8],[39,12,42,12],[27,12,30,12],[27,13,30,13],[27,11,30,11],[39,8,42,8],[39,9,42,9],[39,10,42,10],[39,11,42,11],[44,5,46,6],[16,7,19,7],[16,6,19,6],[27,9,30,9],[27,8,30,8],[16,9,19,9],[0,7,0,8],[21,5,23,6],[32,5,34,6],[1,7,1,10],[1,1,1,6],[27,10,30,10],[27,7,30,7],[10,5,12,6],[4,8,8,8],[4,9,8,9],[55,5,57,6],[50,13,53,13],[50,8,53,8],[50,9,53,9],[50,10,53,10],[50,11,53,11],[50,12,53,12]]}
[null,null,null,null,null,null,null,"Return to T Levels"]
[null,"T Levels\n(please click on red buttons to see the effects of data errors and the green button to reset the data back to a clean record)",null,null,null,null,null,"Return to main sheet"]
[null,"Example 1 - Technical qualification (TQ) is not the core aim"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","Core aim","Programme type - aim level","Programme weighting","Programme type - overall programme"]
[null,100489,"Avery Falana",17,"ZPROG001","Generic code to identify ILR programme aims",0,"31 - T Level",1.2,"T Level"]
[null,100489,"Avery Falana",17,60358294,"T Level Technical Qualification in Education and Childcare",1,"31 - T Level"]
[null,100489,"Avery Falana",17,"ZTLOS007","T Level Occupational Specialism - Assisting teaching",0,"31 - T Level"]
[null,100489,"Avery Falana",17,"ZWRKX003","T Level Industry Placement",0,"31 - T Level"]
[null,100489,"Avery Falana",17,60147003,"GCSE (9-1) in Mathematics",0,"31 - T Level"]
[]
[null,null,null,null,null,{"$f":"IF(G6<1,\"The student does not have the T Level technical qualification as their core aim, and therefore does not count as a T Level student.\",\"The student has the T Level as their technical qualification and therefore is counted as a T Level student.\")","v":"The student has the T Level as their technical qualification and therefore is counted as a T Level student."}]
[]
[]
[]
[null,"Example 2 - T Level programme hours below the band minimum"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","T Level qualification hours","T Level non qualification hours","Total T Level hours","Funding band"]
[null,100489,"Avery Falana",17,"ZPROG001","Generic code to identify ILR programme aims",900,550,{"$f":"G17+H17","v":1450},"Band 7 (T Level)"]
[null,100489,"Avery Falana",17,60358294,"T Level Technical Qualification in Education and Childcare"]
[null,100489,"Avery Falana",17,"ZTLOS007","T Level Occupational Specialism - Assisting teaching"]
[null,100489,"Avery Falana",17,"ZWRKX003","T Level Industry Placement"]
[]
[null,null,null,null,null,{"$f":"IF(I17>1449,\"The student's total hours is greater than the band minimum and thefore their funding band is correct.\",\"The student's total hours is less than the band minimum and therefore they are funded in a lower, non-T Level funding band.\")","v":"The student's total hours is greater than the band minimum and thefore their funding band is correct."}]
[]
[]
[]
[null,"Example 3 - Hours recorded in the wrong fields"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","Core aim","Qualification hours","EEP hours","Total hours (study programmes)","T Level qualification hours","T Level non qualification hours","Total T Level hours","Funding band"]
[null,100489,"Avery Falana",17,"ZPROG001","Generic code to identify ILR programme aims",0,0,0,{"$f":"H28+I28","v":0},900,550,{"$f":"K28+L28","v":1450},"Band 7 (T Level)"]
[null,100489,"Avery Falana",17,60358294,"T Level Technical Qualification in Education and Childcare",1]
[null,100489,"Avery Falana",17,"ZTLOS007","T Level Occupational Specialism - Assisting teaching",0]
[null,100489,"Avery Falana",17,"ZWRKX003","T Level Industry Placement",0]
[]
[null,null,null,null,null,{"$f":"IF(M28=1450,\"The student's hours are correctly recorded in the T Level fields, therefore the funding band is correct.\",\"The student's hours are wrongly recorded in the study programme hours fields, and therefore the funding band is too low.\")","v":"The student's hours are correctly recorded in the T Level fields, therefore the funding band is correct."}]
[]
[]
[]
[]
[null,"Example 4 - Wrong programme type"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","Core aim","Programme type - aim level","Programme weighting","Programme type - overall programme","T Level qualification hours","T Level non qualification hours","Total T Level hours","Funding band"]
[null,100489,"Avery Falana",17,"ZPROG001","Generic code to identify ILR programme aims",0,"31 - T Level",1.2,"T Level",900,550,{"$f":"K40+L40","v":1450},"Band 7 (T Level)"]
[null,100489,"Avery Falana",17,60358294,"T Level Technical Qualification in Education and Childcare",1,"31 - T Level"]
[null,100489,"Avery Falana",17,"ZTLOS007","T Level Occupational Specialism - Assisting teaching",0,"31 - T Level"]
[null,100489,"Avery Falana",17,"ZWRKX003","T Level Industry Placement",0,"31 - T Level"]
[]
[null,null,null,null,null,{"$f":"IF(H40=\"31 - T Level\",\"The student's programme aim (ZPROG001) is correctly recorded as the T Level type (code 31).\",\"The student's programme aim (ZPROG001) is wrongly recorded as a study programme (code 1), resulting in incorrect funding band and weighting.\")","v":"The student's programme aim (ZPROG001) is correctly recorded as the T Level type (code 31)."}]
[]
[]
[]
[null,"Example 5 - Wrong occupational specialism QN recorded"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","Core aim","Programme type - aim level","Programme weighting","Programme type - overall programme","T Level qualification hours","T Level non qualification hours","Total T Level hours","Funding band"]
[null,100489,"Avery Falana",17,"ZPROG001","Generic code to identify ILR programme aims",0,"31 - T Level",1.4,"T Level",1450,70,{"$f":"K51+L51","v":1520},"Band 7 (T Level)"]
[null,100489,"Avery Falana",17,60369115,"T Level Technical Qualification in Building Services Engineering for Construction",1,"31 - T Level"]
[null,100489,"Avery Falana",17,"ZTLOS026","T Level Occupational Specialism - Air conditioning engineering and refrigeration engineering",0,"31 - T Level"]
[null,100489,"Avery Falana",17,"ZWRKX003","Programme start date",0,"31 - T Level"]
[]
[null,null,null,null,null,{"$f":"IF(E53=\"ZTLOS032\",\"The student's programme aim is correctly recorded, giving the correct programme weighting and funding band.\",\"The student's programme aim is wrongly recorded, resulting in incorrect lower weighting and funding band.\")","v":"The student's programme aim is wrongly recorded, resulting in incorrect lower weighting and funding band."}]

{"sheet":"HVCP_examples","index":25,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5],[6,1,9,4],[13,1,15,1],[13,2,15,2],[17,1,20,4]]}
[null,null,null,null,null,null,null,null,"Return to HVCP"]
[null,"High value courses premium (HVCP)\n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record)",null,null,null,null,null,null,"Return to main page"]
[null,"Example 1 - Incorrect QN (not an HVCP qual, voc prog)"]
[null,"Student reference","Student name","Qualification number (QN)","Qualification title","Level","Guided learning hours (GLH)"]
[null,100721,"Mo Hassan",60002669,"Diploma in Vehicle Parts Competence",3,640]
[]
[null,{"$f":"IF(E5=\"Diploma in Vehicle Parts Competence\",\"The qualification is on the HVCP list and the student is eligible for the premium.\",\"The qualification is not eligible for the premium: it is level 2 and has too few GLH.\")","v":"The qualification is on the HVCP list and the student is eligible for the premium."}]
[]
[]
[]
[]
[null,"Example 2 - Incorrect QN (not a substantial A level programme)"]
[null,"Student reference","Student name","Qualification number (QN)","Qualification title","Level","Guided learning hours (GLH)"]
[null,100721,"Mo Hassan",60149735,"GCE A Level in History",3,360]
[null,null,null,60160445,"GCE A Level in Psychology",3,360]
[null,null,null,50073333,"BTEC Certificate in Art and Design (QCF)",3,64]
[]
[null,{"$f":"IF(E14=\"GCE A Level in History\",\"The student's programme includes two A levels and therefore is a qualifying A level programme.\",\"The student's programme does not include two A levels and therefore does not count as a qualifying A level programme.\")","v":"The student's programme includes two A levels and therefore is a qualifying A level programme."}]

{"sheet":"L3 maths and English examples","index":26,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[[28,13,29,13],[28,14,29,14],[28,15,29,15],[31,4,35,12],[1,1,1,10],[20,4,24,12],[28,1,29,1],[28,2,29,2],[28,8,29,8],[28,9,29,9],[28,10,29,10],[28,11,29,11],[28,12,29,12],[17,11,18,11],[17,12,18,12],[17,13,18,13],[17,14,18,14],[17,15,18,15],[17,1,18,1],[17,2,18,2],[17,8,18,8],[17,9,18,9],[17,10,18,10],[5,13,7,13],[5,14,7,14],[5,15,7,15],[5,1,7,1],[5,2,7,2],[9,4,13,12],[5,8,7,8],[5,9,7,9],[5,10,7,10],[5,11,7,11],[5,12,7,12],[39,15,41,15],[39,1,41,1],[39,2,41,2],[39,8,41,8],[39,9,41,9],[39,10,41,10],[43,4,47,12],[39,11,41,11],[39,12,41,12],[39,13,41,13],[39,14,41,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Return to L3 maths and English payment"]
[null,"Level 3 maths and English payment\n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record)",null,null,null,null,null,null,null,null,null,null,"Return to main page"]
[]
[null,"Example 1 - student is not on a substantial L3 A level programme"]
[null,"Student reference","Student name","Qualification number (QN)","Qualification title","Core aim","Level","Guided learning hours (GLH)","Prog start","Prog end","Prog length","Grade 9-4 maths at the start of their L3 programme?","Payment","Grade 9-4 English at the start of their L3 programme?","Payment","Total payment"]
[null,5037842,"Xia Li",60149735,"GCE A Level in History",1,3,360,"2020-09-07",{"$f":"I6+600","v":"2022-04-30"},"2 year","No",750,"Yes",0,{"$f":"M6+O6","v":750}]
[null,null,null,60160445,"GCE A Level in Psychology",0,3,360]
[null,null,null,60147003,"GCSE (9-1) in Mathematics",0,"1/2",130]
[]
[null,null,null,null,{"$f":"IF(E6=\"GCE A Level in History\",\"The student's programme includes two A levels and therefore is a substantial L3 programme.\",\"The student's programme does not include two A levels and therefore does not count as a substantial L3 programme.\")","v":"The student's programme includes two A levels and therefore is a substantial L3 programme."}]
[]
[]
[]
[]
[]
[null,"Example 2 - student is not on a substantial L3 vocational programme"]
[null,"Student reference","Student name","Qualification number (QN)","Qualification title","Core aim","Level","Guided learning hours (GLH)","Prog start","Prog end","Prog length","Grade 9-4 maths at the start of their L3 programme?","Payment","Grade 9-4 English at the start of their L3 programme?","Payment","Total payment"]
[null,5037842,"Xia Li","6032675X","BTEC National Diploma in Horticulture",1,3,720,"2020-09-07","2021-07-16","1 year","No",375,"Yes",0,{"$f":"M18+O18","v":375}]
[null,null,null,"6035267X","Functional Skills Qualification in Mathematics",0,2,55]
[]
[null,null,null,null,{"$f":"IF(E18=\"BTEC National Diploma in Horticulture\",\"The student's programme includes a vocational qualification of more than 360 hours and therefore is a substantial L3 programme.\",\"The student's programme does not include a vocational qualification of more than 360 hours and therefore does not count as a substantial L3 programme.\")","v":"The student's programme includes a vocational qualification of more than 360 hours and therefore is a substantial L3 programme."}]
[]
[]
[]
[]
[]
[null,"Example 3 - dates recorded wrongly"]
[null,"Student reference","Student name","Qualification number (QN)","Qualification title","Core aim","Level","Guided learning hours (GLH)","Programme start date","Programme end date","Prog length","Grade 9-4 maths at the start of their L3 programme?","Payment","Grade 9-4 English at the start of their L3 programme?","Payment","Total payment"]
[null,5037842,"Xia Li","6032675X","BTEC National Diploma in Horticulture",1,3,720,"2020-09-07","24/06/2022","2 year","No",750,"Yes",0,{"$f":"M29+O29","v":750}]
[null,null,null,"6035267X","Functional Skills Qualification in Mathematics",0,2,55]
[]
[null,null,null,null,{"$f":"IF(K29=\"2 year\",\"The student is on a 2 year programme, as it lasts more than 18 months.\",\"The student is on a 1 year programme, as the dates indicate it is shorter than 18 months.\")","v":"The student is on a 2 year programme, as it lasts more than 18 months."}]
[]
[]
[]
[]
[]
[null,"Example 4 - prior attainment recorded wrongly"]
[null,"Student reference","Student name","Qualification number (QN)","Qualification title","Core aim","Level","Guided learning hours (GLH)","Programme start date","Programme end date","Prog length","Grade 9-4 maths at the start of their L3 programme?","Payment","Grade 9-4 English at the start of their L3 programme?","Payment","Total payment"]
[null,5037842,"Xia Li","6032675X","BTEC National Diploma in Horticulture",1,3,720,"2020-09-07","2022-06-24","2 year","No (grade 3 or below)",750,"No (grade 3 or below)",750,{"$f":"M40+O40","v":1500}]
[null,null,null,"6035267X","Functional Skills Qualification in Mathematics",0,2,55]
[null,null,null,60346541,"Functional Skills English",0,2,55]
[]
[null,null,null,null,{"$f":"IF(L40=\"No (grade 3 or below)\",\"The student has prior attainment recorded that qualifies them for 2 instances of the L3 maths and English payment.\",\"The student does not have prior attainment recorded that qualifies them for 2 instances of the L3 maths and English payment.\")","v":"The student has prior attainment recorded that qualifies them for 2 instances of the L3 maths and English payment."}]

{"sheet":"CoF examples","index":27,"n_rows":154,"n_cols":25,"rows_kept":154,"cut":false,"hidden":false,"merged":[[129,6,134,15],[108,6,111,17],[113,6,116,17],[84,6,89,17],[101,4,101,6],[102,4,102,6],[102,10,103,10],[102,11,103,11],[102,12,103,12],[102,13,103,13],[102,15,106,15],[102,16,106,16],[102,17,106,17],[103,4,103,6],[104,4,104,6],[105,4,105,6],[106,4,106,6],[60,5,65,14],[77,4,77,6],[78,4,78,6],[78,15,82,15],[78,16,82,16],[78,17,82,17],[79,4,79,6],[80,4,80,6],[81,4,81,6],[82,4,82,6],[78,10,79,10],[78,11,79,11],[78,12,79,12],[78,13,79,13],[55,4,55,6],[56,4,56,6],[56,12,58,12],[56,13,58,13],[56,14,58,14],[57,4,57,6],[58,4,58,6],[38,5,43,14],[17,5,22,14],[32,4,32,6],[33,4,33,6],[33,12,35,12],[33,13,35,13],[33,14,35,14],[34,4,34,6],[35,4,35,6],[9,21,9,23],[10,21,10,23],[11,21,11,23],[12,21,12,23],[13,21,13,23],[151,21,151,23],[152,21,152,23],[153,6,159,14],[147,12,151,12],[147,13,151,13],[147,14,151,14],[148,4,148,6],[149,4,149,6],[150,4,150,6],[151,4,151,6],[147,4,147,6],[2,11,2,13],[3,11,3,13],[2,1,2,8],[149,21,149,23],[150,21,150,23],[146,4,146,6],[14,21,14,23],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[10,12,14,12],[10,13,14,13],[10,14,14,14],[82,21,82,23],[77,21,77,23],[78,21,78,23],[79,21,79,23],[80,21,80,23],[81,21,81,23]]}
[]
[]
[null,"Condition of funding on the provision of mathematics and English \n(please click on red buttons to see the effects of data errors and the green buttons to reset the data back to a clean record)",null,null,null,null,null,null,null,null,null,"Return to condition of funding"]
[null,null,null,null,null,null,null,null,null,null,null,"Return to main sheet"]
[null,"Example 1 - Invalid qualification number (QN)"]
[null,"Student reference","Student name","Age","Planned learning hours (qualification hours)","Planned enrichment, employability and pastoral hours (non-qualification hours)","Total planned hours","Maths GCSE funding exemption","English GCSE funding exemption","Maths GCSE highest prior attainment","English GCSE highest prior attainment"]
[null,100018,"Christian Graham",17,450,120,{"$f":"SUM(E7:F7)","v":570},"N","N","E","E"]
[]
[]
[null,"Student reference","Student name","Qualification number","Qualification title",null,null,"Start date","Planned end date","Actual end date","LARS CoF type","Learning aim status","Condition of funding - maths status","Condition of funding - English status","Condition of funding overall status",null,null,null,null,null,"Qualification Reference","Qualification Title",null,null,"LARS EFA CoF Type"]
[null,100018,"Christian Graham",50067254,{"$f":"IF(ISERROR(MATCH(D11,U11:U15,0))=TRUE,\"No match\",INDEX(V11:X15,MATCH(D11,U11:U15,0),1))","v":"BTEC Subsidiary Diploma in Applied Science (QCF)"},null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2,{"$f":"IF(K14=\"GCSE\",\"Doesn't have maths, studying maths\",\"Doesn't have maths, not studying maths\")","v":"Doesn't have maths, studying maths"},{"$f":"IF(K13=\"GCSE\",\"Doesn't have English, studying English\",\"Doesn't have English, not studying English\")","v":"Doesn't have English, studying English"},{"$f":"IF(OR(M11=\"Doesn't have maths, not studying maths\",N11=\"Doesn't have English, not studying English\"),\"Doesn't meet the condition of funding\",\"Meets the condition of funding\")","v":"Meets the condition of funding"},null,null,null,null,null,50067254,"BTEC Subsidiary Diploma in Applied Science (QCF)",null,null,"N/A"]
[null,100018,"Christian Graham",50091475,{"$f":"IF(ISERROR(MATCH(D12,U12:U16,0))=TRUE,\"No match\",INDEX(V12:X16,MATCH(D12,U12:U16,0),1))","v":"Subsidiary Diploma in IT (QCF)"},null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2,null,null,null,null,null,null,null,null,50091475,"Subsidiary Diploma in IT (QCF)",null,null,"N/A"]
[null,100018,"Christian Graham",60131597,{"$f":"IF(ISERROR(MATCH(D13,U13:U17,0))=TRUE,\"No match\",INDEX(V13:X17,MATCH(D13,U13:U17,0),1))","v":"GCSE in English"},null,null,"2013-09-02","2014-07-21","2014-07-21",{"$f":"IF(ISERROR(MATCH(D13,U13:U17,0))=TRUE,\"No match\",\"GCSE\")","v":"GCSE"},2,null,null,null,null,null,null,null,null,60131597,"GCSE in English",null,null,"GCSE"]
[null,100018,"Christian Graham",50078562,{"$f":"IF(ISERROR(MATCH(D14,U14:U18,0))=TRUE,\"No match\",INDEX(V14:X18,MATCH(D14,U14:U18,0),1))","v":"GCSE in Mathematics"},null,null,"2013-09-02","2014-07-21","2014-07-21",{"$f":"IF(ISERROR(MATCH(D14,U14:U18,0))=TRUE,\"No match\",\"GCSE\")","v":"GCSE"},2,null,null,null,null,null,null,null,null,50078562,"GCSE in Mathematics",null,null,"GCSE"]
[null,100018,"Christian Graham",50067503,{"$f":"IF(ISERROR(MATCH(D15,U15:U19,0))=TRUE,\"No match\",INDEX(V15:X19,MATCH(D15,U15:U19,0),1))","v":"BTEC Subsidiary Diploma in Business (QCF)"},null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2,null,null,null,null,null,null,null,null,50067503,"BTEC Subsidiary Diploma in Business (QCF)",null,null,"N/A"]
[]
[]
[null,null,null,null,null,{"$f":"IF(O11=\"Doesn't meet the condition of funding\",\"The student holds grade E in both maths and English GCSE but invalid QNs mean that it is impossible to tell if the student is undertaking approved maths and English qualifications. Therefore the student does not meet the condition of funding.\",\"The student complies with the condition of funding.\")","v":"The student complies with the condition of funding."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Example 2 - Missing prior attainment grades"]
[null,"Student reference","Student name","Age","Planned learning hours (qualification hours)","Planned enrichment, employability and pastoral hours (non-qualification hours)","Total planned hours","Maths GCSE funding exemption","English GCSE funding exemption","Maths GCSE highest prior attainment","English GCSE highest prior attainment"]
[null,100018,"Christian Graham",17,450,120,{"$f":"SUM(E30:F30)","v":570},"N","N","B","A"]
[]
[]
[null,"Student reference","Student name","Qualification number","Qualification title",null,null,"Start date","Planned end date","Actual end date","LARS EFA CoF type","Learning aim status","Condition of funding - maths status","Condition of funding - English status","Condition of funding overall status"]
[null,100018,"Christian Graham",50067254,"BTEC Subsidiary Diploma in Applied Science (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2,{"$f":"IF(J30=\"B\",\"Has maths, not studying maths\",\"Doesn't have maths, not studying maths\")","v":"Has maths, not studying maths"},{"$f":"IF(K30=\"A\",\"Has English, not studying English\",\"Doesn't have English, not studying English\")","v":"Has English, not studying English"},{"$f":"IF(OR(M34=\"Doesn't have maths, not studying maths\",N34=\"Doesn't have English, not studying English\"),\"Doesn't meet the condition of funding\",\"Meets the condition of funding\")","v":"Meets the condition of funding"}]
[null,100018,"Christian Graham",50091475,"Subsidiary Diploma in IT (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2]
[null,100018,"Christian Graham",50067503,"BTEC Subsidiary Diploma in Business (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2]
[]
[]
[null,null,null,null,null,{"$f":"IF(O34=\"Doesn't meet the condition of funding\",\"The student holds GCSE maths and English at grade C or above however, the prior attainment does not reflect this. As the student is also not recorded as undertaking either subject, they do not meet the condition of funding.\",\"The student complies with the condition of funding.\")","v":"The student complies with the condition of funding."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Example 3 - Incorrect exemption data"]
[null,"Student reference","Student name","Age","Planned learning hours (qualification hours)","Planned enrichment, employability and pastoral hours (non-qualification hours)","Total planned hours","Maths GCSE funding exemption","English GCSE funding exemption","Maths GCSE highest prior attainment","English GCSE highest prior attainment"]
[null,100018,"Christian Graham",17,450,120,{"$f":"SUM(E53:F53)","v":570},"U","N","NR","A"]
[]
[]
[null,"Student reference","Student name","Qualification number","Qualification title",null,null,"Start date","Planned end date","Actual end date","LARS EFA CoF type","Learning aim status","Condition of funding - maths status","Condition of funding - English status","Condition of funding overall status"]
[null,100018,"Christian Graham",50067254,"BTEC Subsidiary Diploma in Applied Science (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2,{"$f":"IF(H53=\"U\",\"Has maths, Not studying maths\",\"Doesn't have maths, not studying maths\")","v":"Has maths, Not studying maths"},{"$f":"IF(K53=\"A\",\"Has English, not studying English\",\"Doesn't have English, not studying English\")","v":"Has English, not studying English"},{"$f":"IF(OR(M57=\"Doesn't have maths, not studying maths\",N57=\"Doesn't have English, not studying English\"),\"Doesn't meet the condition of funding\",\"Meets the condition of funding\")","v":"Meets the condition of funding"}]
[null,100018,"Christian Graham",50091475,"Subsidiary Diploma in IT (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2]
[null,100018,"Christian Graham",50067503,"BTEC Subsidiary Diploma in Business (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21","N/A",2]
[]
[null,null,null,null,null,{"$f":"IF(H53=\"N\",\"This student holds a UK  maths qualification equivalent to GCSE grade C or above but the exemption code does not reflect this, hence the student does not comply.\",\"The student complies with the condition of funding.\")","v":"The student complies with the condition of funding."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Example 4 - Incorrect learning aim dates"]
[null,"Student reference","Student name","Age","Planned learning hours (qualification hours)","Planned enrichment, employability and pastoral hours (non-qualification hours)","Total planned hours","Maths GCSE funding exemption","English GCSE funding exemption","Maths GCSE highest prior attainment","English GCSE highest prior attainment"]
[null,100018,"Christian Graham",17,450,120,{"$f":"SUM(E75:F75)","v":570},"N","N","E","E"]
[]
[]
[null,"Student reference","Student name","Qualification number","Qualification title",null,null,"Start date","Planned end date","Actual end date","Planned length (days)","CoF qualifying period","Actual length (days)","Aim qualifies for CoF","Learning aim status","Condition of funding - maths status","Condition of funding - English status","Condition of funding overall status",null,null,"Qualification Reference","Qualification Title",null,null,"LARS EFA CoF Type"]
[null,100018,"Christian Graham",50067254,{"$f":"IF(ISERROR(MATCH(D79,U79:U83,0))=TRUE,\"No Match\",INDEX(V79:X83,MATCH(D79,U79:U83,0),1))","v":"BTEC Subsidiary Diploma in Applied Science (QCF)"},null,null,"2013-09-02","2014-07-21","2014-07-21",null,null,null,null,2,{"$f":"IF(N82=\"Y\",\"Doesn't have maths, studying maths\",\"Doesn't have maths, not studying maths\")","v":"Doesn't have maths, studying maths"},{"$f":"IF(N81=\"Y\",\"Doesn't have English, studying English\",\"Doesn't have English, not studying English\")","v":"Doesn't have English, studying English"},{"$f":"IF(OR(P79=\"Doesn't have maths, not studying maths\",Q79=\"Doesn't have English, not studying English\"),\"Doesn't meet the condition of funding\",\"Meets the condition of funding\")","v":"Meets the condition of funding"},null,null,50067254,"BTEC Subsidiary Diploma in Applied Science (QCF)",null,null,"N/A"]
[null,100018,"Christian Graham",50091475,{"$f":"IF(ISERROR(MATCH(D80,U80:U84,0))=TRUE,\"No Match\",INDEX(V80:X84,MATCH(D80,U80:U84,0),1))","v":"Subsidiary Diploma in IT (QCF)"},null,null,"2013-09-02","2014-07-21","2014-07-21",null,null,null,null,2,null,null,null,null,null,50091475,"Subsidiary Diploma in IT (QCF)",null,null,"N/A"]
[null,100018,"Christian Graham",60131597,"GCSE in English",null,null,"2013-09-02","2014-07-21","2014-09-20",{"$f":"I81-H81","v":322},{"$f":"IF(K81<14,0,IF(K81>=168,42,14))","v":42},{"$f":"J81-H81","v":383},{"$f":"IF(L81=0,\"N\",IF(M81>=L81,\"Y\",\"N\"))","v":"Y"},2,null,null,null,null,null,60131597,"GCSE in English",null,null,"GCSE"]
[null,100018,"Christian Graham",50078562,"GCSE in Mathematics",null,null,"2013-09-02","2014-07-21","2014-07-21",322,{"$f":"IF(K82<14,0,IF(K82>=168,42,14))","v":42},{"$f":"J82-H82","v":322},{"$f":"IF(L82=0,\"N\",IF(M82>=L82,\"Y\",\"N\"))","v":"Y"},2,null,null,null,null,null,50078562,"GCSE in Mathematics",null,null,"GCSE"]
[null,100018,"Christian Graham",50067503,"BTEC Subsidiary Diploma in Business (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21",null,null,null,null,2,null,null,null,null,null,50067503,"BTEC Subsidiary Diploma in Business (QCF)",null,null,"N/A"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(N81=\"N\",N82=\"N\"),\"The student has not studied their maths and English aims for the minimum qualifying period, hence they do not count towards the condition of funding and the student does not comply.\",\"The student complies with the condition of funding.\")","v":"The student complies with the condition of funding."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Example 5 - Non-approved maths and English aims and incorrect start dates"]
[null,"Student reference","Student name","Age","Planned learning hours (qualification hours)","Planned enrichment, employability and pastoral hours (non-qualification hours)","Total planned hours","Maths GCSE funding exemption","English GCSE funding exemption","Maths GCSE highest prior attainment","English GCSE highest prior attainment"]
[null,100018,"Christian Graham",17,450,120,{"$f":"SUM(E99:F99)","v":570},"N","N","E","E"]
[]
[]
[null,"Student reference","Student name","Qualification number","Qualification title",null,null,"Start date","Planned end date","Actual end date","Has CoF validity on LARS","CoF validity start date","CoF validity last date for new starts","Start date in valid range","Learning aim status","Condition of funding - maths status","Condition of funding - English status","Condition of funding overall status"]
[null,100018,"Christian Graham",50067254,"BTEC Subsidiary Diploma in Applied Science (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21",null,null,null,null,2,{"$f":"IF(N106=\"Y\",\"Doesn't have maths, Studying maths\",\"Doesn't have maths, not studying maths\")","v":"Doesn't have maths, Studying maths"},{"$f":"IF(N105=\"Y\",\"Doesn't have English, Studying English\",\"Doesn't have English, not studying English\")","v":"Doesn't have English, Studying English"},{"$f":"IF(OR(P103=\"Doesn't have maths, not studying maths\",Q103=\"Doesn't have English, not studying English\"),\"Doesn't meet the condition of funding\",\"Meets the condition of funding\")","v":"Meets the condition of funding"}]
[null,100018,"Christian Graham",50091475,"Subsidiary Diploma in IT (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21",null,null,null,null,2,null,null,null,null,null,"aim ref","title","valid","LDNS","Effective from"]
[null,100018,"Christian Graham",60013588,{"$f":"INDEX(V105:V106,MATCH(D105,$U$105:$U$106,0),1)","v":"Certificate in English Language"},null,null,"2013-09-02","2014-07-21","2014-09-20",{"$f":"INDEX(W105:W106,MATCH(D105,$U$105:$U$106,0),1)","v":"Y"},{"$f":"INDEX(X105:Y106,MATCH(D105,$U$105:$U$106,0),2)","v":"2011-09-01"},{"$f":"INDEX(X105:Y106,MATCH(D105,$U$105:$U$106,0),1)","v":"2016-08-31"},{"$f":"IF(AND(H105>=L105,H105<=M105),\"Y\",\"N\")","v":"Y"},2,null,null,null,null,null,60110326,"Certificate in English Skills (QCF)","N","No validity","No validity"]
[null,100018,"Christian Graham",60101738,"Functional Skills Qualification in Mathematics at Level 2",null,null,"2013-09-02","2014-07-21","2014-07-21","Y","2013-08-01","2018-05-31",{"$f":"IF(AND(H106>=L106,H106<=M106),\"Y\",\"N\")","v":"Y"},2,null,null,null,null,null,60013588,"Certificate in English Language","Y","2016-08-31","2011-09-01"]
[null,100018,"Christian Graham",50067503,"BTEC Subsidiary Diploma in Business (QCF)",null,null,"2013-09-02","2014-07-21","2014-07-21",null,null,null,null,2]
[]
[null,null,null,null,null,null,{"$f":"IF(K105=\"N\",\"The qualification recorded is not recognised as counting toward the condition of funding. As the student does not hold a suitable, approved English qualification they do not meet the condition of funding.\",\"The student is enrolled on a qualification that meets the condition of funding for English.\")","v":"The student is enrolled on a qualification that meets the condition of funding for English."}]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(N106=\"N\",\"The start date of this maths qualification is before the valid start date, therefore it does not count toward the condition of funding. As the student does not hold a suitable, approved maths qualification they do not meet the condition of funding.\",\"The student is enrolled on a qualification that meets the condition of funding for maths.\")","v":"The student is enrolled on a qualification that meets the condition of funding for maths."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Example 6 - GCSE grades 2/E or below and no pass in Functional Skills Level 2"]
[null,"Student reference","Student name","Age","Planned learning hours (qualification hours)","Planned enrichment, employability and pastoral hours (non-qualification hours)","Total planned hours","Maths GCSE funding exemption","English GCSE funding exemption","Maths GCSE highest prior attainment","English GCSE highest prior attainment","Maths Functional Skill Level 2","English Functional Skill Level 2","Condition of funding overall status"]
[null,100018,"Christian Graham",17,450,120,{"$f":"SUM(E128:F128)","v":570},"N","N",2,"E","P","P",{"$f":"IF(OR(L128=\" \",M128=\" \"),\"Doesn't meet the condition of funding\",\"Meets the condition of funding\")","v":"Meets the condition of funding"},null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P","P"]
[null,null,null,null,null,null,{"$f":"IF(L128=\" \",\"The student holds grade 2/E in both maths and English GCSE but does not hold Functional Skills Level 2 pass grades in maths and English qualifications. Therefore the student does not meet the condition of funding.\",\"The student complies with the condition of funding.\")","v":"The student complies with the condition of funding."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Example 6 - D grade student not undertaking GCSEs"]
[null,"Student reference","Student name","Age","Planned learning hours (qualification hours)","Planned enrichment, employability and pastoral hours (non-qualification hours)","Total planned hours","Maths GCSE funding exemption","English GCSE funding exemption","Maths GCSE highest prior attainment","English GCSE highest prior attainment"]
[null,100018,"Christian Graham",17,450,120,{"$f":"SUM(E144:F144)","v":570},"N","N","D","D"]
[]
[]
[null,"Student reference","Student name","Qualification number","Qualification title",null,null,"Start date","Planned end date","Actual end date","Learning aim status","LARS EFA CoF type","Condition of funding - maths status","Condition of funding - English status","Condition of funding overall status"]
[null,100018,"Christian Graham",50067254,"BTEC Subsidiary Diploma in Applied Science (QCF)",null,null,"2015-09-02","2016-07-21","2016-07-21",2,"N/A",{"$f":"IF(L151=\"GCSE\",\"Doesn't have maths, studying maths\",\"Doesn't have maths, not studying maths\")","v":"Doesn't have maths, studying maths"},{"$f":"IF(L150=\"GCSE\",\"Doesn't have English, studying English\",\"Doesn't have English, not studying English\")","v":"Doesn't have English, studying English"},{"$f":"IF(OR(M148=\"Doesn't have maths, not studying maths\",N148=\"Doesn't have English, not studying English\"),\"Doesn't meet the condition of funding\",\"Meets the condition of funding\")","v":"Meets the condition of funding"}]
[null,100018,"Christian Graham",50091475,"Subsidiary Diploma in IT (QCF)",null,null,"2015-09-02","2016-07-21","2016-07-21",2,"N/A"]
[null,100018,"Christian Graham",60131597,{"$f":"INDEX($V$150:$X$153,MATCH(D150,$U$150:$U$153,0),1)","v":"GCSE in English"},null,null,"2015-09-02","2016-07-21","2016-09-20",2,{"$f":"INDEX($Y$150:$Y$153,MATCH(D150,$U$150:$U$153,0),1)","v":"GCSE"},null,null,null,null,null,null,null,null,60013588,"Certificate in English Language",null,null,"Stepping stone"]
[null,100018,"Christian Graham",50078562,{"$f":"INDEX($V$150:$X$153,MATCH(D151,$U$150:$U$153,0),1)","v":"GCSE in Mathematics"},null,null,"2015-09-02","2016-07-21","2016-07-21",2,{"$f":"INDEX($Y$150:$Y$153,MATCH(D151,$U$150:$U$153,0),1)","v":"GCSE"},null,null,null,null,null,null,null,null,60101738,"Functional Skills Qualification in Mathematics at Level 2",null,null,"Stepping stone"]
[null,100018,"Christian Graham",50067503,"BTEC Subsidiary Diploma in Business (QCF)",null,null,"2015-09-02","2016-07-21","2016-07-21",2,"N/A",null,null,null,null,null,null,null,null,60131597,"GCSE in English",null,null,"GCSE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50078562,"GCSE in Mathematics",null,null,"GCSE"]
[null,null,null,null,null,null,{"$f":"IF(OR(L150=\"stepping stone\",L151=\"stepping stone\"),\"The student holds grade D for maths and English and is not undertaking GCSE or equivalent qualifications. Therefore, the student does not meet the condition of funding.\",\"The student complies with the condition of funding.\")","v":"The student complies with the condition of funding."}]

{"sheet":"LPU_examples","index":28,"n_rows":90,"n_cols":29,"rows_kept":90,"cut":false,"hidden":false,"merged":[[73,6,77,6],[81,13,84,13],[81,15,84,15],[86,6,90,6],[47,6,51,6],[55,13,58,13],[55,15,58,15],[60,6,64,6],[68,13,71,13],[68,15,71,15],[22,6,26,6],[30,13,33,13],[30,15,33,15],[35,6,39,6],[43,13,45,13],[43,14,45,14],[43,15,45,15],[17,13,20,13],[17,15,20,15],[1,1,1,6],[1,15,1,17],[4,13,7,13],[4,15,7,15],[9,6,13,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to large programme uplift"]
[null,"Large programme uplift (LPU)\n(please click on red buttons to see the effects of data errors and the green button to reset the data back to a clean record)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to main sheet"]
[null,"Example 1 - Invalid grade mix"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA Tier 2","Start Date","Planned End Date","Actual End Date","Learning Aim Status","Core Aim","Qualification Category","Grade","LPU status",null,null,null,"LearnAimRef","LearnAimRefTitle","LearnAimRefTypeDesc","SSA Tier 2","Valid/Invalid for LPU"]
[null,100018,"Christian Graham",17,50024759,"GCE A Level in Biology","GCE A level","02.1","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G5=\"GCE A-Level\",\"Academic\",IF(G5=\"GCSE\",\"Academic\",\"Vocational\"))","v":"Vocational"},"A",{"$f":"IF(AND(OR(O5=\"A\",O5=\"B\"),OR(O6=\"A\",O6=\"B\"),OR(O7=\"A\",O7=\"B\"),OR(O8=\"A\",O8=\"B\")),\"10% uplift\",\"No uplift\")","v":"10% uplift"},null,null,null,50024759,"GCE A Level in Biology","GCE A level","02.1","Valid Qual for LPU"]
[null,100018,"Christian Graham",17,50024267,"GCE A Level in Chemistry","GCE A level",12.2,"2013-09-02","2014-07-21","2014-07-21",2,0,null,"B",null,null,null,null,50024267,"GCE A Level in Chemistry","GCE A level","02.1","Valid Qual for LPU"]
[null,100018,"Christian Graham",17,"5002596X","GCE A Level in Classics","GCE A level","02.1","2013-09-02","2014-07-21","2014-01-13",2,0,null,"A",null,null,null,null,"5002596X","GCE A Level in Classics","GCE A level",12.2,"Valid Qual for LPU"]
[null,100018,"Christian Graham",17,60147477,"GCE A Level in Physics","GCE A level",null,"2013-09-02","2014-07-21","2014-07-21",2,0,null,"A",null,null,null,null,60147477,"GCE A Level in Physics","GCE A level","02.1","Valid Qual for LPU"]
[]
[null,null,null,null,null,null,{"$f":"IF(P5=\"No Uplift\",\"The student does not have 4 A levels at grades A*, A or B. Therefore the student is not eligible for the large programme uplift.\",\"The student has 4 A levels at grades A*, A or B and is therefore valid for the large programme uplift.\")","v":"The student has 4 A levels at grades A*, A or B and is therefore valid for the large programme uplift."},null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A level Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5002596X","GCE A Level in Classics","GCE A level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,"02.1"]
[null,"Example 2 - Invalid qualification mix",null,null,null,null,null,"02.1"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA Tier 2","Start Date","Planned End Date","Actual End Date","Learning Aim Status","Core Aim","Qualification Category","Grade","LPU status"]
[null,100018,"Christian Graham",17,50024759,"GCE A Level in Biology","GCE A level",15.3,"2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G18=\"GCE A-Level\",\"Academic\",IF(G18=\"GCSE\",\"Academic\",\"Vocational\"))","v":"Vocational"},"A",{"$f":"IF(G20=\"Diploma\",\"No uplift\",\"10% uplift\")","v":"10% uplift"}]
[null,100018,"Christian Graham",17,50024267,"GCE A Level in Chemistry","GCE A level",null,"2013-09-02","2014-07-21","2014-07-21",2,0,null,"A"]
[null,100018,"Christian Graham",17,"5002596X","GCE A Level in Classics","GCE A level","Diploma","2013-09-02","2014-07-21","2014-01-13",2,0,null,"A",null,null,null,null,50067503,"BTEC Subsidiary Diploma in Business (QCF)","Diploma",15.3,"Invalid Qual for LPU"]
[null,100018,"Christian Graham",17,60147477,"GCE A Level in Physics","GCE A level","02.1","2013-09-02","2014-07-21","2014-07-21",2,0,null,"A",null,null,null,null,"P"]
[]
[null,null,null,null,null,null,{"$f":"IF(P18=\"No Uplift\",\"The student has an invalid mix of vocational and academic qualifications and so is not eligible for the large programme uplift.\",\"The student has 4 A level qualifications and is therefore valid for the large programme uplift.\")","v":"The student has 4 A level qualifications and is therefore valid for the large programme uplift."}]
[]
[]
[]
[]
[]
[null,"Example 3 - Ineligible A level qualification",null,null,null,null,null,"02.1"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA Tier 2","Start Date","Planned End Date","Actual End Date","Learning Aim Status","Core Aim","Qualification Category","Grade","LPU status"]
[null,100018,"Christian Graham",17,50024759,"GCE A Level in Biology","GCE A level","02.1","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G31=\"GCE A-Level\",\"Academic\",IF(G31=\"GCSE\",\"Academic\",\"Vocational\"))","v":"Vocational"},"A",{"$f":"IF(F31=\"GCE A Level in General Studies\",\"No uplift\",\"10% uplift\")","v":"10% uplift"},null,null,null,50021941,"GCE A Level in General Studies","GCE A-Level",14.1,"Invalid Qual for LPU"]
[null,100018,"Christian Graham",17,50024267,"GCE A Level in Chemistry","GCE A level",null,"2013-09-02","2014-07-21","2014-07-21",2,0,null,"B"]
[null,100018,"Christian Graham",17,"5002596X","GCE A Level in Classics","GCE A level",12.2,"2013-09-02","2014-07-21","2014-01-13",2,0,null,"B"]
[null,100018,"Christian Graham",17,50024759,"GCE A Level in Biology","GCE A level","02.1","2013-09-02","2014-07-21","2014-07-21",2,0,null,"A"]
[]
[null,null,null,null,null,null,{"$f":"IF(P31=\"No Uplift\",\"The student only has 3 valid A level qualifications as general studies does not count. Therefore the student is not eligible for the large programme uplift.\",\"The student has 4 valid A level qualifications and is therefore valid for the large programme uplift.\")","v":"The student has 4 valid A level qualifications and is therefore valid for the large programme uplift."}]
[]
[]
[]
[]
[]
[null,"Example 4 - Missing Tech Bacc project qualification"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA Tier 2","Start Date","Planned End Date","Actual End Date","Learning Aim Status","Core Aim","Qualification Category","Grade","LPU status",null,null,null,"LearnAimRef","LearnAimRefTitle","LearnAimRefTypeDesc","SSA Tier 2","Valid/Invalid for LPU"]
[null,100018,"Christian Graham",17,50081652,"Extended Diploma in Engineering (QCF)","TechBacc",null,"2013-09-02","2014-07-21","2014-07-21",2,1,{"$f":"IF(G44=\"GCE A-Level\",\"Academic\",IF(G44=\"GCSE\",\"Academic\",\"Vocational\"))","v":"Vocational"},{"$f":"IF(F46=\"Extended Project\",\"20% uplift\",\"No uplift\")","v":"20% uplift"},{"$f":"IF(F46=\"Extended Project\",\"20% uplift\",\"No uplift\")","v":"20% uplift"},null,null,null,50081652,"Extended Diploma in Engineering (QCF)","TechBacc","04.1","Valid Qual for LPU"]
[null,100018,"Christian Graham",17,10034080,"GCE A Level in Mathematics","GCE A-Level",null,"2013-09-02","2014-07-21","2014-07-21",2,0,null,null,null,null,null,null,10034080,"GCE A Level in Mathematics","GCE A-Level","02.2","Valid Qual for LPU"]
[null,100018,"Christian Graham",17,"5002372X","Extended Project","TechBacc"," ","2013-09-02","2014-07-21","2014-01-13",2,0,null,null,null,null,null,null,"5002372X","Extended Project","TechBacc",14.1,"Valid Qual for LPU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","Extended Project omitted"," "," "," "]
[null,null,null,null,null,null,{"$f":"IF(O44=\"No Uplift\",\"The student does not have the extended project. Therefore the student is not eligible for the large programme uplift.\",\"The student has all the elements of the TechBacc and is therefore valid for the large programme uplift.\")","v":"The student has all the elements of the TechBacc and is therefore valid for the large programme uplift."}]
[]
[]
[]
[]
[]
[null,"Example 5 - Missing International Baccalaureate Diploma"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA Tier 2","Start Date","Planned End Date","Actual End Date","Learning Aim Status","Core Aim","Qualification Category","Grade","LPU status",null,null,null,"LearnAimRef","LearnAimRefTitle","LearnAimRefTypeDesc","SSA Tier 2","Valid/Invalid for LPU"]
[null,100018,"Christian Graham",17,50034157,"International Baccalaureate Diploma","International Baccalaureate",14.1,"Valid Qual for LPU",null,null,null,null,"Academic",28,{"$f":"IF(F56=\"International Baccalaureate Diploma\",\"20% uplift\",\"No uplift\")","v":"20% uplift"},null,null,null,50034157,"International Baccalaureate Diploma","International Baccalaureate",14.1,"Valid Qual for LPU"]
[null,100018,"Christian Graham",17,60131779,"IBO Level 3 Certificate in HL Chemistry","International Baccalaureate",14.1,"2013-09-02","2014-07-21","2014-07-21",2,0,null,null,null,null,null,null,60131779,"IBO Level 3 Certificate in HL Chemistry","International Baccalaureate",14.1,"Valid Qual for LPU","2013-09-02","2014-07-21","2014-07-21",2,0]
[null,100018,"Christian Graham",17,60131743,"IBO Level 3 Certificate in HL Biology","International Baccalaureate",14.1,"2013-09-02","2014-07-21","2014-01-13",2,0,null,null,null,null,null,null,60131743,"IBO Level 3 Certificate in HL Biology","International Baccalaureate",14.1,"Valid Qual for LPU"]
[null,100018,"Christian Graham",17,60131809,"IBO Level 3 Certificate in HL Physics","International Baccalaureate",14.1,"2013-09-02","2014-07-21","2014-07-21",2,0,null,null,null,null,null,null,60131809,"IBO Level 3 Certificate in HL Physics","International Baccalaureate",14.1,"Valid Qual for LPU"]
[]
[null,null,null,null,null,null,{"$f":"IF(P56=\"No Uplift\",\"The student does not have the International Baccalaureate Diploma. Therefore the student is not eligible for the large programme uplift.\",\"The student has all the elements of the International Baccalaureate Diploma and is therefore valid for the large programme uplift.\")","v":"The student has all the elements of the International Baccalaureate Diploma and is therefore valid for the large programme uplift."},null,null,null,null,null,null,null,null,null,null,null,null," ","IB Diploma omitted"," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50034157,"IB Diploma less than 28 points"," "," "," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,26]
[]
[null,"Example 6 - International Baccalaureate Diploma less than 28 points"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA Tier 2","Start Date","Planned End Date","Actual End Date","Learning Aim Status","Core Aim","Qualification Category","Grade","LPU status"]
[null,100018,"Christian Graham",17,50034157,"International Baccalaureate Diploma","International Baccalaureate",14.1,"2013-09-02","2014-07-21","2014-07-21",2,0,"Academic",28,{"$f":"IF(O69=28,\"20% uplift\",\"No uplift\")","v":"20% uplift"}]
[null,100018,"Christian Graham",17,60131779,"IBO Level 3 Certificate in HL Chemistry","International Baccalaureate",14.1,"2013-09-02","2014-07-21","2014-07-21",2,0]
[null,100018,"Christian Graham",17,60131743,"IBO Level 3 Certificate in HL Biology","International Baccalaureate",14.1,"2013-09-02","2014-07-21","2014-01-13",2,0]
[null,100018,"Christian Graham",17,60131809,"IBO Level 3 Certificate in HL Physics","International Baccalaureate",14.1,"2013-09-02","2014-07-21","2014-07-21",2,0]
[]
[null,null,null,null,null,null,{"$f":"IF(P69=\"No Uplift\",\"The student has less than the required 28 points for the International Baccalaureate Diploma to count. Therefore the student is not eligible for the large programme uplift.\",\"The student has the required 28 points for the International Baccalaureate Diploma and is therefore valid for the large programme uplift.\")","v":"The student has the required 28 points for the International Baccalaureate Diploma and is therefore valid for the large programme uplift."}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"See the effect of invalid QAN on LPU"]
[null,"Example 7 - Invalid Advanced Mathematics grade"]
[null,"Student reference","Student name","Age","Qualification number","Qualification title","LARS aim type","SSA Tier 2","Start Date","Planned End Date","Actual End Date","Learning Aim Status","Core Aim","Qualification Category","Grade","LPU status"]
[null,100018,"Christian Graham",17,50024759,"GCE A Level in Biology","GCE A level","02.1","2013-09-02","2014-07-21","2014-07-21",2,0,{"$f":"IF(G82=\"GCE A-Level\",\"Academic\",IF(G82=\"GCSE\",\"Academic\",\"Vocational\"))","v":"Vocational"},"B",{"$f":"IF(AND(OR(O82=\"A\",O82=\"B\"),OR(O83=\"A\",O83=\"B\"),OR(O84=\"C\",O84=\"B\"),OR(O85=\"A\",O85=\"B\")),\"10% uplift\",\"No uplift\")","v":"10% uplift"}]
[null,100018,"Christian Graham",17,50024267,"GCE A Level in Chemistry","GCE A level",12.2,"2013-09-02","2014-07-21","2014-07-21",2,0,null,"B",null,null,null,null,"R6020556","Advanced Mathematics","GCE A level"]
[null,100018,"Christian Graham",17,"R6020556","Advanced Mathematics","GCE A level","02.1","2013-09-02","2014-07-21","2014-01-13",2,0,null,"C",null,null,null,null,"C",null,"D"]
[null,100018,"Christian Graham",17,60147477,"GCE A Level in Physics","GCE A level",null,"2013-09-02","2014-07-21","2014-07-21",2,0,null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LearnAimRef","LearnAimRefTitle","LearnAimRefTypeDesc","SSA Tier 2","Valid/Invalid for LPU"]
[null,null,null,null,null,null,{"$f":"IF(P82=\"No Uplift\",\"The student does not have Advanced Mathematics at grade C and 3 A levels at grade B. Therefore the student is not eligible for the large programme uplift.\",\"The student has Advanced Mathematics at grade C and 3 A levels at grade B and is therefore valid for the large programme uplift.\")","v":"The student has Advanced Mathematics at grade C and 3 A levels at grade B and is therefore valid for the large programme uplift."},null,null,null,null,null,null,null,null,null,null,null,null,50024759,"GCE A Level in Biology","GCE A level","02.1","Valid Qual for LPU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50024267,"GCE A Level in Chemistry","GCE A level","02.1","Valid Qual for LPU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R6020556","Advanced Mathematics","GCE A level",12.2,"Valid Qual for LPU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60147477,"GCE A Level in Physics","GCE A level","02.1","Valid Qual for LPU"]