{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Instructions","School or Setting audit","Progress tracker","Action plan","Audit Tracker","Workings"],"not_rendered":{"charts":20,"images":0,"macros":1,"external_links":2,"defined_names":143,"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":"Introduction","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Audit and Action Planning Tool "]
[]
["Name: "]
["Job title: "]
["Email:"]
["School or Setting name: "]
[]
["Introduction"]
["This audit and action planning tool is for schools and settings doing whole school work including targeted work with individual children and young people and supports schools and settings to develop effective strategies to prevent and respond to key issues.   \n\nOnce you have completed your baseline audit you will be able to clearly see where your school or setting is effective and what you might need to work on. You can then develop an action plan to support you to take the work forward. We recommend repeating this termly.  \n\nIf you have any questions about this tool, please contact inclusionandsend@norfolk.gov.uk.   "]

{"sheet":"Instructions","index":1,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Instructions:"]
["STEP 1 - First audit"]
["Select the ‘School or Setting audit' sheet. You will see a number of indicators. In column B, select if you have ‘Fully met, ‘Partially met' or ‘Not yet met' the indicator. Once you have completed this, use column C to select whether to add each indicator to your action plan as a goal for your school or setting to work towards. If you select 'Yes' from the drop-down list in this column, the entry will automatically be added to the 'Action Plan' sheet."]
["STEP 2 - Action plan"]
["Select the ‘Action Plan’ sheet. You will see that the indicators you have chosen to work on have appeared automatically in the pink boxes. You will also notice that some suggested actions have been added underneath the indicator which will help you reach your goal. You can also add other actions and outline who is going to implement the action, and what the timeframe is for making the change. Share this with colleagues across the school and implement your action plan, indicating whether you have completed the actions in column D. "]
["STEP 3 – Second audit"]
["Once your action plan is complete (i.e. you have selected an answer in column D for each action), go back to the ‘School or Setting audit’ sheet and assess the indicators again using column D, ‘Second audit’ and select if you have ‘Fully met, ‘Partially met' or ‘Not yet met' each indicator. \nHow often you repeat the action plan is dependent on your current needs, we would recommend completing it on a termly basis to support school improvement."]
["STEP 4 – Progress tracker"]
["Select the ‘Progress Tracker’ sheet to see a visual representation of your audit and a summary of the progress made on your action plan. You will see how your final audit compares against your first audit. You can also access this at any time during the process to check on progress. "]
["STEP 5 – Futher support"]
["If you would like further support then you can share your audit tool with us. Please contact us on inclusionandsend@norfolk.gov.uk."]

{"sheet":"School or Setting audit","index":2,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[23,0,23,3],[26,0,26,3],[29,0,29,3],[0,0,0,3],[1,0,1,3],[20,0,20,3],[14,0,14,3],[17,0,17,3],[3,0,3,3],[6,0,6,3],[10,0,10,3]]}
["School audit"]
[" - First, identify a group of key staff who will lead on this work\n   TIP: Completing this audit together will make your assessment more accurate\n - There are 16 indicators in 4 areas to assess your approach to addressing homophobic, biphobic & transphobic bullying\n - Hover over each indicator to display guidance\n - Add indicators to the Action plan by choosing 'Yes' in column B"]
["School or Setting name:","First Audit","Add to Action plan","Second Audit"]
["1) Ethos and Environment\n"]
["1.1. In our school/setting we have a clear vision and approach which values all CYP, promotes feelings of safety, a sense of belonging and supports the positive mental health and emotional wellbeing of CYP.","Choose…","No","Choose…",{"$f":"C5&COUNTIF($C$5:C5,C5)","v":"No1"}]
["1.2 In our school / setting, there is a coordinated whole school approach to vaping.","Choose…","No","Choose…",{"$f":"C6&COUNTIF($C$5:C6,C6)","v":"No2"}]
["2) Leadership and Governance\n"]
["2.1 Our leaders and governors are up to date with guidance and legislation around vaping.","Choose…","No","Choose…",{"$f":"C8&COUNTIF($C$5:C8,C8)","v":"No3"}]
["2.2 Our leaders and governors understand the current vaping issues which are impacting their schools / setting.","Choose…","No","Choose…",{"$f":"C9&COUNTIF($C$5:C9,C9)","v":"No4"}]
["2.3 Our leaders and governors oversee policy development and curriculum.","Choose…","No","Choose…",{"$f":"C10&COUNTIF($C$5:C10,C10)","v":"No5"}]
["3) Policy Development"]
["3.1 Our school / setting has developed a separate vaping policy or guidance is incorporated into an existing drugs/alcohol policy (or the wider behaviour policy for primary schools).","Choose…","No","Choose…",{"$f":"C12&COUNTIF($C$5:C12,C12)","v":"No6"}]
["3.2 Our policies including behaviour and safeguarding are clear, up to date and aligned to national guidance and legislation. ","Choose…","No","Choose…",{"$f":"C13&COUNTIF($C$5:C13,C13)","v":"No7"}]
["3.3 Our policies are accessible to all and communicated appropriately with CYP, staff and families.","Choose…","No","Choose…",{"$f":"C14&COUNTIF($C$5:C14,C14)","v":"No8"}]
["4) Children and Young People's Voice"]
["4.1 Our school / setting has effective processes and systems in place which collect CYP voice, with adaptations made to ensure all CYP can participate and feel heard.","Choose…","No","Choose…",{"$f":"C16&COUNTIF($C$5:C16,C16)","v":"No9"}]
["4.2 We use information collected through CYP voice to identify areas for development and evidence strengths.","Choose…","No","Choose…",{"$f":"C17&COUNTIF($C$5:C17,C17)","v":"No10"}]
["5) Support and Signposting for Children and Young People"]
["5.1 Our CYP are provided with information from trusted sources of support.","Choose…","No","Choose…",{"$f":"C19&COUNTIF($C$5:C19,C19)","v":"No11"}]
["5.2 Our staff know how to respond to concerns around individual CYP and vaping.","Choose…","No","Choose…",{"$f":"C20&COUNTIF($C$5:C20,C20)","v":"No12"}]
["6) Partnerships with Families"]
["6.1 All our families are well informed about how our school / setting manages vaping.","Choose…","No","Choose…",{"$f":"C22&COUNTIF($C$5:C22,C22)","v":"No13"}]
["6.2 Our families are provided with guidance and information from trusted sources. ","Choose…","No","Choose…",{"$f":"C23&COUNTIF($C$5:C23,C23)","v":"No14"}]
["7) Curriculum, Teaching and Learning"]
["7.1 We provide CYP with opportunities to develop resilience and confidence through age and stage appropriate high quality RSHE, PSHE, SMSC and the wider curriculum as well as ensuring a focus on mental health and wellbeing. ","Choose…","No","Choose…",{"$f":"C25&COUNTIF($C$5:C25,C25)","v":"No15"}]
["7.2 Our teaching is supported by the use of quality resources which enhance learning.","Choose…","No","Choose…",{"$f":"C26&COUNTIF($C$5:C26,C26)","v":"No16"}]
["8) Staff CPD"]
["8.1 All our staff access relevant CPD opportunities around vaping.","Choose…","No","Choose…",{"$f":"C28&COUNTIF($C$5:C28,C28)","v":"No17"}]
["8.2 All our staff are up to date with other relevant training such as mental health, RSHE, behaviour and safeguarding.","Choose…","No","Choose…",{"$f":"C29&COUNTIF($C$5:C29,C29)","v":"No18"}]
["9) Assessment, recording and reporting"]
["9.1 We have a clear picture of how our school / setting is impacted by vaping.","Choose…","No","Choose…",{"$f":"C31&COUNTIF($C$5:C31,C31)","v":"No19"}]
["9.2 We use the data we have around vaping to inform and refine provision and support. ","Choose…","No","Choose…",{"$f":"C32&COUNTIF($C$5:C32,C32)","v":"No20"}]
["9.3 Our school / setting reports any illegal sales of vapes to the local authority. ","Choose…","No","Choose…",{"$f":"C33&COUNTIF($C$5:C33,C33)","v":"No21"}]
["9.4 We report any adverse reactions associated with vaping of both nicotine and non-nicotine containing e-cigarettes to the MHRA via theyellow card scheme.","Choose…","No","Choose…",{"$f":"C34&COUNTIF($C$5:C34,C34)","v":"No22"}]

{"sheet":"Progress tracker","index":3,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,1,17],[0,0,0,17]]}
["Progress tracker"]
[" - This page is a visual representation of your School or Setting audit\n - The charts show what proportion of your answers were 'Fully', 'Partially' or 'Not yet' met, overall and across the nine areas of the audit\n - Complete the audit routinely to show progress over time\n   TIP: Share your tracker with staff and governors to encourage buy-in across the school or setting community "]

{"sheet":"Action plan","index":4,"n_rows":128,"n_cols":5,"rows_kept":128,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Action plan"]
[" - Indicators you selected in the School or Setting audit will appear here\n - Decide what actions need to take place to make progress in this area\n   TIP: Break things down into manageable tasks; there are two extra rows if you need them\n - Include a due date, who the task is delegated to and update when it is completed"]
["Indicator:","Due by:","Delegated to:","Completed?"]
["1.1 In our school/setting we have a clear vision and approach which values all CYP, promotes feelings of safety, a sense of belonging and supports the positive mental health and emotional wellbeing of CYP.",null,null,null,{"$f":"IF('School or Setting audit'!$C$5=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Review school vision and ensure key preventative concepts are considered such as belonging, positive mental health and emotional wellbeing.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$5=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Ensure all staff understand and are confident with the school vision and approaches.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$5=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Consider completing a whole-school audit aroundn mental health and wellbeing - Mentally Healthy Schools",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$5=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$5=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$5=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["1.2 In our school / setting, there is a coordinated whole school approach to vaping.",null,null,null,{"$f":"IF('School or Setting audit'!$C$6=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Consider NICE guidelines recommendations.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$6=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Review staff knowledge and skills considering the Staff CPD links in the WSA guide in the section titled ‘How can we support staff awareness, confidence and skills?’",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$6=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Review policy and procedures around individual vaping incidents –Vaping (padlet.com).",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$6=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Consider how your approach to vaping is communicated to staff, CYP and families.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$6=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Ensure your approach to vaping forms part of your induction for new staff.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$6=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$6=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$6=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["2.1 Our leaders and governors are up to date with guidance and legislation around vaping.",null,null,null,{"$f":"IF('School or Setting audit'!$C$8=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Share NICE guidelines and NHS advice. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$8=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$8=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$8=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["2.2 Our leaders and governors understand the current vaping issues which are impacting their schools / setting.",null,null,null,{"$f":"IF('School or Setting audit'!$C$9=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Add ‘Vaping’ item to governors agenda to review any issues regularly.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$9=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$9=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$9=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["2.3 Our leaders and governors oversee policy development and curriculum.",null,null,null,{"$f":"IF('School or Setting audit'!$C$10=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Involve in development and review of vaping policy (and other relevant policies).",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$10=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Review PSHE curriculum in light of vaping content.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$10=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$10=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$10=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["3.1 Our school / setting has developed a separate vaping policy or guidance is incorporated into an existing drugs/alcohol policy (or the wider behaviour policy for primary schools).",null,null,null,{"$f":"IF('School or Setting audit'!$C$12=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Develop vaping policy / Make addition of vaping content to existing Drugs and alcohol policy.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$12=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Use policy guidance from Action on Smoking and Health (ASH).",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$12=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Use guidance:",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$12=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["DfE Searching, Screening and Confiscation",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$12=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["DfE and ACPO drug advice for schools. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$12=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$12=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$12=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["3.2 Our policies including behaviour and safeguarding are clear, up to date and aligned to national guidance and legislation.",null,null,null,{"$f":"IF('School or Setting audit'!$C$13=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Ensure procedures outlined in relevant policies align with your responses to vaping. The following guidance may support:",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$13=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["DfE Searching, Screening and Confiscation",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$13=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["DfE and ACPO drug advice for schools. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$13=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["DfE Behaviour in Schools guidance. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$13=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$13=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$13=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["3.3 Our policies are accessible to all and communicated appropriately with CYP, staff and families.",null,null,null,{"$f":"IF('School or Setting audit'!$C$14=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Consider CYP and family needs and adapt policy as needed.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$14=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Take account of CYP's cultural, special educational or physical needs. (for example, by providing material in alternative formats such as visuals, large print, Braille, audio and video.)",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$14=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$14=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$14=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["4.1 Our school / setting has effective processes and systems in place which collect CYP voice, with adaptations made to ensure all CYP can participate and feel heard.",null,null,null,{"$f":"IF('School or Setting audit'!$C$16=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Build processes and systems into classroom practice as well as whole school activities on a regular basis.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$16=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Adapt activities based on need.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$16=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Use guidance on collecting CYP views in this padlet (within the ‘CYP voice’ section) and information about CYP voice and peer support programmes here.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$16=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$16=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["4.2 We use information collected through CYP voice to identify areas for development and evidence strengths.",null,null,null,{"$f":"IF('School or Setting audit'!$C$17=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Build in reviews of CYP voice into your whole school development plan on a regular basis.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$17=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$17=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$17=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$17=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["5.1 Our CYP are provided with information from trusted sources of support.",null,null,null,{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Use these posters from ASH.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Identify local support agencies / opportunities, and advertise these with contact numbers.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Consider other support also e.g. How to manage a mental health concern",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["ChatHealth Poster ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Kooth electronic resources (email for physical posters)",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Anna Freud posters and signposting",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Use signposting links shared within the WSA guide in the section titled ‘What support can we signpost CYP to?’",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Share these links in several ways e.g. newsletters, form time, 1-1 conversations, student portal, etc",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$19=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["5.2 Our staff know how to respond to concerns around individual CYP and vaping.",null,null,null,{"$f":"IF('School or Setting audit'!$C$20=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["See guidance here – Vaping (padlet.com).",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$20=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Consider the 3 I’s approach:",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$20=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Intention - What do we need to do about it? ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$20=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Intervention - What will it look like? ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$20=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Impact – How will we measure impact, on individual, group and whole school basis?",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$20=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$20=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$20=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["6.1 All our families are well informed about how our school / setting manages vaping.",null,null,null,{"$f":"IF('School or Setting audit'!$C$22=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Use the model letter in this padlet to communicate to parent / carers about a vaping incident. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$22=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Please use the model letter to communicate any changes to policy to families.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$22=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$22=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$22=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["6.2 Our families are provided with guidance and information from trusted sources.",null,null,null,{"$f":"IF('School or Setting audit'!$C$23=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Share 'Top Tips on talking to your child about tricky topics' within this padlet with your families e.g. on school website, any newsletters or individual communications to parents as relevant. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$23=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Share these resources with families - Vaping: The Facts | Smokefree Sheffield and Smoking, E-Cigs & Vaping (justonenorfolk.nhs.uk)",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$23=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$23=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$23=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["7.1 We provide CYP with opportunities to develop resilience and confidence through age and stage appropriate high quality RSHE, PSHE, SMSC and the wider curriculum as well as ensuring a focus on mental health and wellbeing. ",null,null,null,{"$f":"IF('School or Setting audit'!$C$25=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Review curriculum planning across year groups and ensure there is adequate focus on development of these skills.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$25=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Consider lesson observations to ensure skills are being developed through teaching and learning approaches.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$25=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$25=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$25=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["7.2 Our teaching is supported by the use of quality resources which enhance learning.",null,null,null,{"$f":"IF('School or Setting audit'!$C$26=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Use resources linked to within the WSA guide in the section titled ‘What quick curriculum activities can we include?’.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$26=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$26=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$26=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["8.1 All our staff access relevant CPD opportunities around vaping.",null,null,null,{"$f":"IF('School or Setting audit'!$C$28=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["All staff access CPD content via the links included in the WSA guide in the section titled ‘How can we support staff awareness, confidence and skills?’",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$28=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Ensure this is part of your induction process for new staff.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$28=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$28=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$28=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["8.2 All our staff are up to date with other relevant training such as mental health, RSHE, behaviour and safeguarding.",null,null,null,{"$f":"IF('School or Setting audit'!$C$29=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Review relevant training and ensure vaping is included as appropriate.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$29=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$29=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$29=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["9.1 We have a clear picture of how our school / setting is impacted by vaping.",null,null,null,{"$f":"IF('School or Setting audit'!$C$31=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Electronic systems e.g. CPOMs are used to record vaping incidents as soon as possible by the staff member involved.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$31=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["If specific concerns arise from an incident e.g. safeguarding, appropriate procedures are followed. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$31=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Recognise, report on, and bring in relevant external support if there are concerns re Child Criminal Exploitation (CCE) with possible dealing of vapes, and consider a link to CYP Drug & Alcohol services if there is wider substance or alcohol misuse.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$31=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,null,{"$f":"IF('School or Setting audit'!$C$31=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$31=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["9.2 We use the data we have around vaping to inform and refine provision and support. ",null,null,null,{"$f":"IF('School or Setting audit'!$C$32=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["On a termly basis, review incidents to note any patterns or trends.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$32=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Patterns and trends should inform curriculum and support. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$32=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Consider having ‘Substance misuse incidents’ as a standing item on your governor’s agenda.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$32=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,null,{"$f":"IF('School or Setting audit'!$C$32=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$32=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["9.3 Our school / setting reports any illegal sales of vapes to the local authority. ",null,null,null,{"$f":"IF('School or Setting audit'!$C$33=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Report this to Local Authority Trading Standards via the Citizens Advice Portal Reporting to Trading Standards - Citizens Advice. If you need further advice around this please contact the Citizens Advice helpline on 0808 223 1133or email them via this link Citizens Advice ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$33=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Write this into policy to ensure staff follow consistently.",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$33=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$33=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$33=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["9.4 We report any adverse reactions associated with vaping of both nicotine and non-nicotine containing e-cigarettes to the MHRA via theyellow card scheme.",null,null,null,{"$f":"IF('School or Setting audit'!$C$34=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
["Write this step into policy to ensure staff follow consistently. ",null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$34=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$34=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]
[null,null,null,"Choose…",{"$f":"IF('School or Setting audit'!$C$34=\"Yes\",\"Show\",\"Hide\")","v":"Hide"}]

{"sheet":"Audit Tracker","index":5,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,0,0,17],[1,0,1,17],[2,0,2,17],[28,0,28,17]]}
["Audit tracker"]
[" - This page is a visual representation of your School auditresponses, separated by first and second audits\n - The charts show what proportion of your answers were 'Fully', 'Partially' or 'Not yet' met, overall and across the four areas of the audit\n   TIP: If you want to focus on one term only. Use the +/- button to the bottom left of each chart to open and close them"]
["Progress tracker - First Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Progress tracker - Second Audit"]

{"sheet":"Workings","index":6,"n_rows":52,"n_cols":75,"rows_kept":52,"cut":false,"hidden":true,"merged":[[19,48,19,74],[19,9,19,20],[0,9,0,10],[0,11,0,12],[0,13,0,14],[19,21,19,47]]}
["Local Authority",null,"Rating",null,"Yes/No",null,"Other Rating",null,null,"Term 1",null,"Term 2",null,"Term 3",null,null,null,null,null,null,"Action Time Frames",null,"Indicators"]
[null,null,"Choose…",null,"Choose…",null,null,null,null,"Total","Total %","Total","Total %","Total","Total %",null,null,null,null,null,"Choose timeframe…"]
["Birmingham City Council",null,"Fully met",null,"Yes",null,"Yes, and have had an impact",null,null,{"$f":"$J$1","v":"Term 1"},{"$f":"$J$1","v":"Term 1"},{"$f":"$L$1","v":"Term 2"},{"$f":"$L$1","v":"Term 2"},{"$f":"$N$1","v":"Term 3"},{"$f":"$N$1","v":"Term 3"},"Rating Value",null,null,null,null,"Long Term",null,"1. The school anti-bullying policy specifically references homophobic, biphobic and transphobic bullying."]
["Bristol",null,"Partially met",null,"No",null,"Yes, but have had little impact",null,"Fully met",{"$f":"COUNTIFS('School or Setting audit'!$B$5:$B$23,$I4)","v":0},{"$f":"IFERROR($J4/$J$7,\"\")","v":""},{"$f":"COUNTIFS('School or Setting audit'!$D$5:$D$23,$I4)","v":0},{"$f":"IFERROR($L4/$L$7,\"\")","v":""},{"$f":"COUNTIFS('School or Setting audit'!#REF!,$I4)","v":{"$error":"#REF!"}},{"$f":"IFERROR($N4/$N$7,\"\")","v":""},2,null,null,null,null,"Medium Term",null,"2. The policy references the Equality Act 2010 and shows our commitment to preventing and responding effectively to the bullying of protected* and vulnerable groups."]
["Derby",null,"Not yet met",null,null,null,"None",null,"Partially met",{"$f":"COUNTIFS('School or Setting audit'!$B$5:$B$23,$I5)","v":0},{"$f":"IFERROR($J5/$J$7,\"\")","v":""},{"$f":"COUNTIFS('School or Setting audit'!$D$5:$D$23,$I5)","v":0},{"$f":"IFERROR($L5/$L$7,\"\")","v":""},{"$f":"COUNTIFS('School or Setting audit'!#REF!,$I5)","v":{"$error":"#REF!"}},{"$f":"IFERROR($N5/$N$7,\"\")","v":""},1,null,null,null,null,"Short Term",null,"3. The Head and Senior Management Team demonstrate a clear commitment to preventing and tackling homophobia, biphobia and transphobia."]
["Herefordshire",null,null,null,"Yes/No without Choose",null,null,null,"Not yet met",{"$f":"COUNTIFS('School or Setting audit'!$B$5:$B$23,$I6)","v":0},{"$f":"IFERROR($J6/$J$7,\"\")","v":""},{"$f":"COUNTIFS('School or Setting audit'!$D$5:$D$23,$I6)","v":0},{"$f":"IFERROR($L6/$L$7,\"\")","v":""},{"$f":"COUNTIFS('School or Setting audit'!#REF!,$I6)","v":{"$error":"#REF!"}},{"$f":"IFERROR($N6/$N$7,\"\")","v":""},0,null,null,null,null,null,null,"4. Bullying is recorded by type, including homophobic, biphobic, transphobic and sexist bullying, and this data is regularly analysed, reported to governors and used to inform whole school developments."]
["Leicestershire",null,null,null,null,null,null,null,"Total",{"$f":"SUM(J4:J6)","v":0},0,0,0,{"$error":"#REF!"},0,null,null,null,null,null,null,null,"5. External organisations are or have been used to support and complement work to prevent and respond to HBT bullying. "]
["Lincolnshire",null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6. The SRE curriculum and teaching is LGBT-inclusive and staff are confident to address same-sex relationships, gender stereotyping and gender identity."]
["Luton",null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7. Lesbian, Gay, Bisexual and Trans (LGBT) people are visible in the curriculum, including in core subjects."]
["Norfolk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8. Diverse families and LGBT role models are visible throughout the school including on displays, electronic screens and in the library."]
["Gloucestershire",null,null,null,"Yes without Choose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9. LGBT equality is celebrated and events are used to raise awareness of the impact of homophobia, biphobia and transphobia."]
["South Gloucestershire",null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10. School staff and pupils have a shared understanding of what bullying is."]
["Stoke-on-Trent",null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11. All school staff, including governors, receive appropriate training and support to address HBT bullying."]
["Worcestershire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12. Skilled staff support students who want to discuss their sexual orientation and/or gender identity."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13. Students are aware of how to report all incidents of homophobic, biphobic and transphobic bullying."]
[null,null,null,null,"Yes/No/Partially",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14. Students are consulted about how the school's anti-bullying policy is implemented, including HBT bullying."]
[null,null,null,null,"Choose…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15. Students are supported to coordinate activities which promote a more LGBT-inclusive school."]
[null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16. Parents and carers receive information about the requirements of the Equality Act 2010 and how the school tackles HBT bullying."]
[null,null,null,null,"No"]
[null,null,null,null,"Partially",null,null,null,null,"Audit 3",null,null,null,null,null,null,null,null,null,null,null,"Second Audit",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,"First Audit"]
[null,null,null,null,null,null,null,null,null,"School leadership and policies","School leadership and policies %","School leadership and policies (Rating Value)","Prevention","Prevention %","Prevention (Rating Value)","Staff training and responsiveness","Staff training and responsiveness %","Staff training and responsiveness (Rating Value)","Pupils and parents/carers","Pupils and parents/carers %","Pupils and parents/carers (Rating Value)","Ethos & Environment","Ethos & Environment%","Ethos & Environment(Rating Value)","Leadership and Governance","Leadership and Governance %","Leadership and Governance (Rating Value)","Policy Development","Policy Development%","Policy Development (Rating Value)","Children and Young People's Voice","Children and Young People's Voice %","Children and Young People's Voice (Rating Value)","Support and Signposting for Children and Young People","Support and Signposting for Children and Young People %","Support and Signposting for Children and Young People (Rating Value)","Partnerships with Families","Partnerships with Families %","Partnerships with Families (Rating Value)","Curriculum, Teaching and Learning","Curriculum, Teaching and Learning %","Curriculum, Teaching and Learning (Rating Value)","Staff CPD","Staff CPD %","Staff CPD (Rating Value)","Assessment, recording and reporting","Assessment, recording and reporting %","Assessment, recording and reporting (Rating Value)","Ethos & Environment","Ethos & Environment%","Ethos & Environment(Rating Value)","Leadership and Governance","Leadership and Governance %","Leadership and Governance (Rating Value)","Policy Development","Policy Development%","Policy Development (Rating Value)","Children and Young People's Voice","Children and Young People's Voice %","Children and Young People's Voice (Rating Value)","Support and Signposting for Children and Young People","Support and Signposting for Children and Young People %","Support and Signposting for Children and Young People (Rating Value)","Partnerships with Families","Partnerships with Families %","Partnerships with Families (Rating Value)","Curriculum, Teaching and Learning","Curriculum, Teaching and Learning %","Curriculum, Teaching and Learning (Rating Value)","Staff CPD","Staff CPD %","Staff CPD (Rating Value)","Assessment, recording and reporting","Assessment, recording and reporting %","Assessment, recording and reporting (Rating Value)"]
[null,null,null,null,null,null,null,null,null,{"$f":"$J$20","v":"Audit 3"},"Audit 3","Audit 3","Audit 3","Audit 3","Audit 3","Audit 3","Audit 3","Audit 3","Audit 3","Audit 3","Audit 3",{"$f":"$V$20","v":"Second Audit"},"Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit","Second Audit",{"$f":"$AW$20","v":"First Audit"},{"$f":"$AW$20","v":"First Audit"},"First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit","First Audit"]
[null,null,null,null,null,null,null,null,"Fully met",{"$f":"COUNTIFS('School or Setting audit'!#REF!,$I23)","v":{"$error":"#REF!"}},{"$f":"IFERROR($J23/$J$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$J23","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I23)","v":{"$error":"#REF!"}},{"$f":"IFERROR($M23/$M$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$M23","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I23)","v":{"$error":"#REF!"}},{"$f":"IFERROR($P23/$P$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$P23","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I23)","v":{"$error":"#REF!"}},{"$f":"IFERROR(S23/$S$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$S23","v":{"$error":"#REF!"}},{"$f":"COUNTIFS('School or Setting audit'!$D$5:$D$6,$I23)","v":0},{"$f":"IFERROR($V23/$V$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$V23","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$8:$D$10,$I23)","v":0},{"$f":"IFERROR($Y23/$Y$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$Y23","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$12:$D$14,$I23)","v":0},{"$f":"IFERROR($AB23/$AB$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AB23","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$16:$D$17,$I23)","v":0},{"$f":"IFERROR(AE23/$AE$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AE23","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$19:$D$20,$I23)","v":0},{"$f":"IFERROR(AH23/$AH$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AE23","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$22:$D$23,$I23)","v":0},{"$f":"IFERROR(AK23/$AK$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AE23","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$25:$D$26,$I23)","v":0},{"$f":"IFERROR(AN23/$AN$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AN23","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$28:$D$29,$I23)","v":0},{"$f":"IFERROR(AQ23/$AQ$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AQ23","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$31:$D$34,$I23)","v":0},{"$f":"IFERROR(AT23/$AQ$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AT23","v":0},{"$f":"COUNTIFS('School or Setting audit'!$B$5:$B$6,$I23)","v":0},{"$f":"IFERROR($AW23/$AW$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AW23","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$8:$B$10,$I23)","v":0},{"$f":"IFERROR($AZ23/$AZ$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$AZ23","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$12:$B$14,$I23)","v":0},{"$f":"IFERROR($BC23/$BC$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$BC23","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$16:$B$17,$I23)","v":0},{"$f":"IFERROR(BF23/$BF$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$BF23","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$19:$B$20,$I23)","v":0},{"$f":"IFERROR(BI23/$BF$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$BF23","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$22:$B$23,$I23)","v":0},{"$f":"IFERROR(BL23/$BF$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$BF23","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$25:$B$26,$I23)","v":0},{"$f":"IFERROR(BO23/$BO$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$BO23","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$28:$B$29,$I23)","v":0},{"$f":"IFERROR(BR23/$BR$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$BR23","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$31:$B$34,$I23)","v":0},{"$f":"IFERROR(BU23/$BU$26,0)","v":0},{"$f":"VLOOKUP($I23,$I$1:$N$6,4)*$BU23","v":0}]
[null,null,null,null,null,null,null,null,"Partially met",{"$f":"COUNTIFS('School or Setting audit'!#REF!,$I24)","v":{"$error":"#REF!"}},{"$f":"IFERROR($J24/$J$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$J24","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I24)","v":{"$error":"#REF!"}},{"$f":"IFERROR($M24/$M$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$M24","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I24)","v":{"$error":"#REF!"}},{"$f":"IFERROR($P24/$P$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$P24","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I24)","v":{"$error":"#REF!"}},{"$f":"IFERROR(S24/$S$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$S24","v":{"$error":"#REF!"}},{"$f":"COUNTIFS('School or Setting audit'!$D$5:$D$6,$I24)","v":0},{"$f":"IFERROR($V24/$V$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$V24","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$8:$D$10,$I24)","v":0},{"$f":"IFERROR($Y24/$Y$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$Y24","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$12:$D$14,$I24)","v":0},{"$f":"IFERROR($AB24/$AB$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AB24","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$16:$D$17,$I24)","v":0},{"$f":"IFERROR(AE24/$AE$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AE24","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$19:$D$20,$I24)","v":0},{"$f":"IFERROR(AH24/$AH$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AE24","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$22:$D$23,$I24)","v":0},{"$f":"IFERROR(AK24/$AK$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AE24","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$25:$D$26,$I24)","v":0},{"$f":"IFERROR(AN24/$AN$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AN24","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$28:$D$29,$I24)","v":0},{"$f":"IFERROR(AQ24/$AQ$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AQ24","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$31:$D$34,$I24)","v":0},{"$f":"IFERROR(AT24/$AQ$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AT24","v":0},{"$f":"COUNTIFS('School or Setting audit'!$B$5:$B$6,$I24)","v":0},{"$f":"IFERROR($AW24/$AW$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AW24","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$8:$B$10,$I24)","v":0},{"$f":"IFERROR($AZ24/$AZ$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$AZ24","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$12:$B$14,$I24)","v":0},{"$f":"IFERROR($BC24/$BC$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$BC24","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$16:$B$17,$I24)","v":0},{"$f":"IFERROR(BF24/$BF$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$BF24","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$19:$B$20,$I24)","v":0},{"$f":"IFERROR(BI24/$BF$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$BF24","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$22:$B$23,$I24)","v":0},{"$f":"IFERROR(BL24/$BF$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$BF24","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$25:$B$26,$I24)","v":0},{"$f":"IFERROR(BO24/$BO$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$BO24","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$28:$B$29,$I24)","v":0},{"$f":"IFERROR(BR24/$BR$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$BR24","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$31:$B$34,$I24)","v":0},{"$f":"IFERROR(BU24/$BU$26,0)","v":0},{"$f":"VLOOKUP($I24,$I$1:$N$6,4)*$BU24","v":0}]
[null,null,null,null,null,null,null,null,"Not yet met",{"$f":"COUNTIFS('School or Setting audit'!#REF!,$I25)","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$J25","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I25)","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$M25","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I25)","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$P25","v":{"$error":"#REF!"}},{"$f":"COUNTIF('School or Setting audit'!#REF!,$I25)","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$S25","v":{"$error":"#REF!"}},{"$f":"COUNTIFS('School or Setting audit'!$D$5:$D$6,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$V25","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$8:$D$10,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$Y25","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$12:$D$14,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AB25","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$16:$D$17,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AE25","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$19:$D$20,$I25)","v":0},{"$f":"IFERROR(AH25/$AH$26,0)","v":0},{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AE25","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$22:$D$23,$I25)","v":0},{"$f":"IFERROR(AK25/$AK$26,0)","v":0},{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AE25","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$25:$D$26,$I25)","v":0},{"$f":"IFERROR(AN25/$AN$26,0)","v":0},{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AN25","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$28:$D$29,$I25)","v":0},{"$f":"IFERROR(AQ25/$AQ$26,0)","v":0},{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AQ25","v":0},{"$f":"COUNTIF('School or Setting audit'!$D$31:$D$34,$I25)","v":0},{"$f":"IFERROR(AT25/$AQ$26,0)","v":0},{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AT25","v":0},{"$f":"COUNTIFS('School or Setting audit'!$B$5:$B$6,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AW25","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$8:$B$10,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$AZ25","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$12:$B$14,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$BC25","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$16:$B$17,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$BF25","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$19:$B$20,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$BF25","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$22:$B$23,$I25)","v":0},0,{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$BF25","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$25:$B$26,$I25)","v":0},{"$f":"IFERROR(BO25/$BO$26,0)","v":0},{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$BO25","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$28:$B$29,$I25)","v":0},{"$f":"IFERROR(BR25/$BR$26,0)","v":0},{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$BR25","v":0},{"$f":"COUNTIF('School or Setting audit'!$B$31:$B$34,$I25)","v":0},{"$f":"IFERROR(BU25/$BU$26,0)","v":0},{"$f":"VLOOKUP($I25,$I$1:$N$6,4)*$BU25","v":0}]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J23:J25)","v":{"$error":"#REF!"}},{"$f":"SUM(K23:K25)","v":0},{"$error":"#REF!"},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"SUM(V23:V25)","v":0},{"$f":"SUM(W23:W25)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH23:AH25)","v":0},0,0,0,0,{"$f":"SUM(AM23:AM25)","v":0},0,0,{"$f":"SUM(AP23:AP25)","v":0},0,0,0,0,0,0,{"$f":"SUM(AW23:AW25)","v":0},{"$f":"SUM(AX23:AX25)","v":0},{"$f":"SUM(AY23:AY25)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(BI23:BI25)","v":0},0,0,0,0,0,{"$f":"SUM(BO23:BO25)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicators","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. The school anti-bullying policy specifically references homophobic, biphobic and transphobic bullying.","Fully met: Policy specifically references homophobic, biphobic and transphobic bullying and how the school monitors and plans to address it.\nPartially met: Policy references homophobic, biphobic or transphobic bullying (but not all three).\nNot yet met: Policy doesn't reference homophobic, biphobic or transphobic bullying."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. The policy references the Equality Act 2010 and shows our commitment to preventing and responding effectively to the bullying of protected* and vulnerable groups.","Fully met: Policy references the Equality Act and protected characteristics, and includes a statement of commitment to preventing and responding effectively.\nPartially met: Policy references the Equality Act but does not include an explicit statement of commitment and/or protected characteristics.\nNot yet met: Policy does not reference the Equality Act.\n*Protected characteristics: age, disability, gender reassignment, pregnancy and maternity, race, religion or belief, sex, sexual orientation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. The Head and Senior Management Team demonstrate a clear commitment to preventing and tackling homophobia, biphobia and transphobia.","Fully met: The Head/SMT has provided a clear commitment to prevent and tackle HBT bullying via whole-school approach to reach students, parents and school staff by, for example, sending a letter home to parents/carers, within staff induction/inset days, statement on website and/or within anti-bullying policy.\nPartially met: Members of SMT have gone to some lengths to provide a clear commitment to prevent and tackle HBT bullying but not via a whole school approach that reaches the whole-school community. \nNot yet met: The Head and/or SMT has not provided any formal commitment to prevent and tackle HBT bullying."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Bullying is recorded by type, including homophobic, biphobic, transphobic and sexist bullying, and this data is regularly analysed, reported to governors and used to inform whole school developments.","Fully met: Bullying is recorded by type, that includes HBT and sexist bullying, and data is regularly analysed, reported and used.\nPartially met: Bullying is recorded by type that does not include HBT and sexist bullying OR data is rarely analysed, reported and used.\nNot yet met: Bullying is not recorded by type and data is rarely analysed, reported and used."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. External organisations are or have been used to support and complement work to prevent and respond to HBT bullying. ","Fully met: the school has had input from external organisations in the last three years and this has had a significant, positive impact on how the school approaches HBT bullying.\nPartially met: input from external organisations has been superficial (e.g. using resources) or took place more than 3 years ago and has had a minimal impact on how the school approaches HBT bullying.\nNot yet met: No input from external organisations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6. The SRE curriculum and teaching is LGBT-inclusive and staff are confident to address same-sex relationships, gender stereotyping and gender identity.","Fully met: The SRE curriculum explicitly addresses LGBT people and staff who deliver SRE have received training/support in LGBT inclusive delivery. \nPartially met:  The SRE curriculum covers some LGBT issues but teaching does not always use inclusive language and staff who deliver SRE have not received training/support.\nNot yet met: The SRE curriculum does not address LGBT people and teaching does not use inclusive language, such as partner instead of boyfriend/girlfriend."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7. Lesbian, Gay, Bisexual and Trans (LGBT) people are visible in the curriculum, including in core subjects.","Fully met: LGBT people are visible in multiple subjects across the curriculum.\nPartially met: LGBT people are visible in a few subjects across the curriculum.\nNot yet met: LGBT people are visible in no subjects across the curriculum."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8. Diverse families and LGBT role models are visible throughout the school including on displays, electronic screens and in the library.","Fully met: Diverse families and a variety of LGBT role models are visible in multiple places in the school.\nPartially met: Diverse families and LGBT role models are visible in only one place within school.\nNot yet met: Diverse families and LGBT role models are not visible in the school."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9. LGBT equality is celebrated and events are used to raise awareness of the impact of homophobia, biphobia and transphobia.","Fully met: LGBT equality has been celebrated regularly and has included events such as LGBT History Month to raise awareness.\nPartially met: LGBT equality has been celebrated on a one-off or infrequent basis.\nNot yet met: LGBT equality has not been celebrated either in events or other ways."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10. School staff and pupils have a shared understanding of what bullying is.","Fully met: The school has a shared definition of what bullying is, that is understood, stated in policies and discussed  amongst all staff and pupils.\nPartially met: The school has a shared definition of bullying that is infrequently referred to or not in policies, or only discussed  amongst some staff and pupils.\nNot yet met: The school has no shared definition of bullying. \nABA defines bullying as the repetitive, intentional hurting of one person or group by another person or group where the relationship involves an imbalance of power. Bullying can be physical, verbal or psychological and can happen face to face or online."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11. All school staff, including governors, receive appropriate training and support to address HBT bullying.","Fully met: Training is provided regularly for all staff/governors, and additional support is clearly signposted.\nPartially met: Training has been provided for some staff/governors.\nNot yet met: No staff/governors have received training in the last three years."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12. Skilled staff support students who want to discuss their sexual orientation and/or gender identity.","Fully met: Pupils are made aware that they can discuss their sexual orientation and/or gender identity with any member of staff.\nPartially met: Pupils are made aware that they can discuss their sexual orientation and/or gender identity with some members of staff. \nNot yet met: Pupils are not made aware that they can discuss their sexual orientation and/or gender identity with staff."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13. Students are aware of how to report all incidents of homophobic, biphobic and transphobic bullying.","Fully met: Processes for reporting incidents of HBT bullying are communicated to students through a variety of channels.\nPartially met: Processes for reporting incidents of HBT bullying are not clearly communicated to students or use only a single channel.\nNot yet met: Processes for reporting incidents of HBT bullying are not in place."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14. Students are consulted about how the school's anti-bullying policy is implemented, including HBT bullying.","Fully met: Systems are in place to consult all students about the school's anti-bullying policy on a regular basis.\nPartially met: Students or some students have been consulted about the school's anti-bullying policy, but on a one-off or irregular basis.\nNot yet met: Students have not been consulted about the school's anti-bullying policy. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15. Students are supported to coordinate activities which promote a more LGBT-inclusive school.","Fully met: Students are encouraged to coordinate activities that promote LGBT inclusion with the support of staff.\nPartially met: Students have independently coordinated activities that promote LGBT inclusion.\nNot yet met: There have been no student-coordinated activities that promote LGBT inclusion."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16. Parents and carers receive information about the requirements of the Equality Act 2010 and how the school tackles HBT bullying.","Fully met: Parents and carers receive regular information through a variety of channels.\nPartially met: Information is available for parents and carers but not actively promoted to them.\nNot yet met: Information is not available for parents and carers."]