{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Intro","SchoolInfo","Activities","Pupils","Declaration","Lists","Engine"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":4,"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":"Intro","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,1,8,16],[13,1,13,16],[4,1,4,16],[5,1,5,16],[6,1,6,16],[7,2,7,16],[9,1,9,16],[10,1,10,16],[11,1,11,16],[12,1,12,16]]}
[]
[]
[null,"Alternative Provision Post-16 Transition Fund - Claim Form"]
[]
[null,"Background to the Fund\nThe Department for Education will provide AP settings with up to £750 for each year 11 pupil sole registered on their school or college roll and up to £750 for each year 11 pupil dual-registered (either main or subsidiary). The purpose of this funding is to support these young people to transition into sustained post-16 destinations and to avoid becoming not in education, employment or training (NEET). This funding is in response to the persistent disruption to education due to COVID-19 and the cancellation of this year’s exams. It is intended to provide additional bespoke transition support for year 11 pupils that can be used from now, over the summer and up until the end of February 2022 depending on individuals’ needs."]
[null,"Conditions of Funding\nFunding can only be spent by schools and colleges to support their existing year 11 cohort transition and remain successfully engaged in quality post-16 destinations.\nWhilst we give school leaders discretion to decide on the most effective and best value locally available solutions, wherever possible interventions should draw on evidence-based practice, and we provide several such suggestions in our guidance.  We recommend anyone planning interventions markedly different from those in our guidance contact our inbox to discuss eligibility. In most cases payment will issued via your commissioner (e.g. your local authority)."]
[null,"Where they need to, AP providers will be eligible to claim up to the per-pupil limits set out above. Schools and colleges will need to provide assurance that costs are legitimate additional costs incurred within the parameters of this funding by taking necessary measures and should consider the following before submitting claims:"]
[null,null,"▪ providers should keep records of all expenditure relating to the AP Transition Fund, as is usual with all spend, these records will be necessary for local audit arrangements;\n▪ the headteacher or school business manager who submits the claim should give due consideration to their financial duties when doing so, including signing their name against any claim; and\n▪ we would expect providers to be able to identify this income, and the related expenditure, when reporting their accounts.\n▪ providers should demonstrate how they adjusted interventions to have increased impact - if they made use of this funding last academic year."]
[null,"Finally, AP settings will be required to track and report on the NEET status of pupils participating in activities delivered under this fund, in Summer 2022. A second claim form will be provided in due course to submit this information to the Department. In the meantime, headteachers or school business managers should make provisions to track this data.\n\n"]
[null,"This funding, subject to the above conditions, is being provided under section 14 –16 of the Education Act 2002. As usual, we reserve the right to audit the expenditure and will not provide funding for claims which have not been made in accordance with the guidance, in order to protect public spending."]
[null,"Please refer to the Department's Guidance and Q&A Document for further information."]
[null,"Claim Form\nThis form is to be used by AP settings submitting claims for the AP Post-16 Transition Fund. The data collected in this form will be matched with census data in order to track claims with census data, and to monitor the delivery of this fund. Please read instructions carefully before completing this form and each section. You must complete and return each part:"]
[null,"School Info - Details of the AP setting making the claim including contact details, URN and amount being claimed,\n\nActivities - Information about the activities delivered using AP Post-16 transition funding including description of the activity, location, frequency and cost of activities. AP settings that used this funding last academic year should provide details on how they are monitoring the effectiveness of previous interventions and new activities in order to select activities that have maximum impact.\n\nPupils - Pupil Reference Number or Unique Pupil Number and registration status of the pupils participating in the activities delivered using the fund and the extent to which pupils attended or engaged with each activity, and\n\nDeclaration - AP settings are required to make a declaration that their claims are a true and accurate reflection of their expenditure and claim amount. Your claim will not be considered if this declaration is not signed. Additionally, AP Setting are asked to provide contact details if they are willing to be contacted by the DfE to discuss the fund and any learning stemming from it. "]
[null,"For the purposes of this fund we are meeting are Article 6 (1)(e) of the General Data Protection Regulation (GDPR). You can find out more about how DfE treats personal information at the following link: https://www.gov.uk/government/organisations/department-for-education/about/personal-information-charter"]

{"sheet":"SchoolInfo","index":1,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,1,53,8],[20,7,20,8],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[39,1,42,3],[20,1,20,5],[45,7,45,8],[52,1,52,8],[37,7,37,8],[31,1,33,3],[35,1,37,3],[32,4,32,7],[36,4,36,7],[40,4,40,7],[6,4,6,7],[1,1,1,7],[3,1,3,2],[3,4,3,7],[5,1,5,2],[5,4,5,7],[7,4,7,7],[8,4,8,7],[9,4,9,7],[10,4,10,7],[12,1,12,2],[12,4,12,7],[51,1,51,8],[14,1,14,2],[14,4,14,7],[16,1,16,2],[16,4,16,7],[18,1,18,7],[23,4,23,7],[22,4,22,7],[23,1,26,3],[44,4,44,7],[27,4,27,7],[26,4,26,7],[25,4,25,7],[24,4,24,7],[29,1,29,3],[29,4,29,7]]}
[]
[null,"School Information "]
[]
[null,"School Name"]
[]
[null,"School Address"]
[]
[]
[]
[]
[]
[]
[null,"URN"]
[]
[null,"Headteacher"]
[]
[null,"Email"]
[]
[null,"Claim for activities"]
[]
[null,"Are you claiming jointly with another setting?"]
[]
[]
[null,"If yes, please input the name(s) and URN of the partner school(s)"]
[]
[]
[]
[]
[]
[null,"Local authority contact*"]
[]
[null,"Number of main-registered pupils who participated from your setting"]
[]
[]
[]
[null,"Number of dual-registered** pupils who participated from your setting"]
[]
[]
[]
[null,"Number of pupils eligible \nfor the fund in your setting if different from number of participating pupils"]
[]
[]
[]
[]
[null,"Total Funding Claim***",null,null,"£"]
[]
[]
[]
[]
[]
[]
[null,"* Some payments will be made via your local authority. Please provide a local authority contact number/email address, if known."]
[null,"** Dual registration means any pupil who is not sole registered at the school, e.g. dual main or dual subsidiary, codes F and O for PRUs, AP academies and AP free schools. Full time vs part time for independent AP settings."]
[null,"*** If you are claiming for activities delivered jointly with partner schools, please only claim for the costs to your setting"]

{"sheet":"Activities","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,3,10],[1,1,1,10]]}
[]
[null,"Activities"]
[]
[null,"This section of the claim form collects information on the activities delivered using the AP Post-16 Transition Fund. Please read the below instructions carefully before completing the form.\n\nPlease use the 'Add New Activity' button below to add information on an activity:\nActivity Reference - please give your activity a unique reference number (e.g. Activity 1, Activity 2, Transition Coach 1, etc.)\nActivity Type - please select that activity type which best suits your activity. If no activity type is applicable please select other and specify in the further comments section.\nDescription - please provide a short description of the activity (e.g. how it was delivered, what it included, etc.)\nDelivered by - please use the drop down list to select who the activity was delivered by\nLocation - please use the drop down list to select where the activity was delivered. If your activity was delivered in multiple places, please specify in the further comments section.\nFrequency - please select the frequency with which the activity was delivered. If this is not applicable please select not applicable.\nDelivery period - please provide the overall dates within which your setting delivered your activities.\nNumber of sessions - please tell us the number of sessions each pupil was expected to attend e.g. each pupil was expected to attend 8 transition mentor sessions. If this is not applicable please select not applicable.\nCost - please tell us the overall cost of the activity at a setting level.\nFurther comments - please use this space to provide further details on options selected earlier in the form or any further comments.\n\nOnce entered, activities will appear in the table at the bottom of this page. You can enter a maximum of 10 activities.\n\nIf you need to edit information about an activity please use the 'Edit Activity' button below (the edit button will only work when there are new entries added)\n\nOnce you have entered all of the activity information please press continue.\n"]
[]
[]
[]
[]
[null,"Ref","Activity Type","Description","Delivered by","Location","Frequency","Delivery Period","No. Sessions","Total Cost","Further Comments"]
[null,"Example Activity","Transition mentors","Our new transition mentors met with pupils to give careers advice, discuss strategies to implement in their new destinations or employment, fiil in application forms and signpost to wider support services. Transition mentors worked with specific groups in order to build relationships with children and provide personalised advice.","Internal staff hired specifically for this fund","Other - please specify in comments","Fortnightly","24/05/2021 - 18/02/2022",8,14300,"Transition mentoring took place in the local Job Centre Plus during the summer holidays when the AP was closed."]

{"sheet":"Pupils","index":3,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,3,13]]}
[]
[null,"Pupils"]
[]
[null,"This section of the claim form collects information on the pupils who have participated in activities delivered using the AP Post-16 Transition Fund. Please read the below instructions carefully before completing the form.\n\nPlease use the 'Add New Pupil' button below to add information on an pupil:\nPupil Reference Number (PRN) - please specificy the PRN for the participating pupil\nRegistration Status - please select from the drop down list the registration status of the pupil\nNEET Risk Assessment - Please provide an assessment of the risk of the pupil becoming NEET before they engaged with the activities delivered by the Post-16 transition fund relative to your overall cohort\nActivity - For each activity please specify to what extent the pupil attended or engaged with the activity from the drop down list\n\nOnce entered, pupil information will appear in the table at the bottom of this page. You can enter a maximum of 260 pupils.\n\nIf you need to edit information about a pupil please use the 'Edit Pupil' button below (the edit button will only work when there are new entries added)\n\nOnce you have entered all of the activity information please press continue."]
[]
[]
[]
[]
[null,"Pupil Reference Number (PRN) or Unique Pupil Number (UPN)","Registration Status","NEET Risk Assessment",{"$f":"Activities!B11","v":0},{"$f":"Activities!B12","v":0},{"$f":"Activities!B13","v":0},{"$f":"Activities!B14","v":0},{"$f":"Activities!B15","v":0},{"$f":"Activities!B16","v":0},{"$f":"Activities!B17","v":0},{"$f":"Activities!B18","v":0},{"$f":"Activities!B19","v":0},{"$f":"Activities!B20","v":0}]
[null,"Example Pupil","Sole/Main","Medium","Partially","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]

{"sheet":"Declaration","index":4,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[[54,1,54,8],[55,1,55,8],[49,1,51,8],[1,1,1,8],[25,3,25,7],[23,3,23,7],[21,3,21,7],[36,1,40,8],[43,1,45,8],[17,1,19,8],[28,1,31,8],[7,1,9,5],[11,1,12,5]]}
[]
[null,"Declarations"]
[]
[null,"Please use this checklist to ensure you have completed the following:"]
[]
[null,"School Information"]
[]
[null,"Activities - provided detailed information and the associated costs for each of the activities delivered using the Post-16 Transition Fund"]
[]
[]
[]
[null,"Pupil Information - provided PRN, registration status and activity information for each pupil"]
[]
[]
[]
[null,"Declarations"]
[]
[null,"If you are willing to be contacted by DfE to discuss your work on the Fund and inform any learning stemming from it, please leave a name and contact details in the boxes below."]
[]
[]
[]
[null,"Name"]
[]
[null,"Telephone"]
[]
[null,"Email"]
[]
[]
[null,"I confirm I understand that I will be recontacted in Summer 2022 to provide the NEET status of pupils who have participated in activities delivered using this funding as a condition of receiving this funding and will make provisions to track this data."]
[]
[]
[]
[]
[]
[]
[]
[null,"For FE colleges and independent schools only\nI confirm that this funding was used solely for year 11 pupils placed in our settings due to exclusion, health needs, new arrival in the local authority, or an off-site direction to improve their behaviour, and we have provided evidence from commissioners confirming this.  "]
[]
[]
[]
[]
[]
[]
[null,"Signed by a senior officer authorised to sign this on behalf of the organisation named above confirming that the claim is in accordance with the terms and conditions described "]
[]
[]
[]
[null,"Signature"]
[]
[]
[]
[]
[]
[]
[null,"Please return the completed form to "]
[null,"APTransitionFund.COVID-19@education.gov.uk"]

{"sheet":"Lists","index":5,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Activities Lists"]
[null,null,null,null,null,null,null,null,null,"WILL BE HIDDEN FROM APS"]
["Type","Delivered By","Location","Frequency"]
["-","-","-","-"]
["Transition mentors","Existing internal staff","Internally","At least daily"]
["Engagement Activities","Internal staff hired specifically for this fund","Externally - FE college","Every other day"]
["Extend Y11","External staff","Externally - with employers","Weekly"]
["Third Sector Activities","Other - please specify in comments","Other - please specify in comments","Fortnightly"]
["Other - please specify in comments",null,null,"Monthly"]
[null,null,null,"Other - please specify in comments"]
[null,null,null,"Not applicable"]
[]
[]
[]
[]
[]
[]
["Pupils Lists"]
[]
["Registration Status","Attendance","NEET Risk"]
["-","-","-"]
["Sole/Main","Fully","High"]
["Dual Main","Partially","Medium"]
["Dual Sub","Not at all","Low"]
[null,"N/A"]

{"sheet":"Engine","index":6,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
["Activities",null,null,null,null,null,null,null,null,"WILL BE HIDDEN FROM APS"]
[null,{"$f":"COUNTA(Activities!B1:B21)","v":4},"Total entries in the database - no more than 10"]
[null,"Edit","Mode"]
[null,1,"Row store"]
[]
[]
["Pupils"]
[null,{"$f":"COUNTA(Pupils!B1:B260)","v":4},"Total entries in the database"]
[null,"New","Mode"]
[null,1,"Row store"]