{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["GUIDE TO KSB MAPPING","ST0746","ST0878","ST0930","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"GUIDE TO KSB MAPPING","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,2,3],[9,0,9,3],[10,0,10,3],[5,0,5,3],[3,0,3,3],[4,0,4,3],[6,0,6,3],[7,0,7,3],[8,0,8,3]]}
["GUIDE TO KSB MAPPING  "]
["Applicants must show how their qualification will enable a person to demonstrate that they have attained as many of the knowledge, skills and behaviours set out in the standard as may be reasonably expected by undertaking a course of education. "]
[]
["1. You can map your qualification to one or more occupational standards. "]
["2. Select the occupational standard(s) you wish to map to your qualification from the tabs in this spreadsheet. You may delete sheets/tabs that are not relevant to your qualification. "]
["3. Please fill in the following details in cells B1-7 on your selected tab: Awarding Body/Applicant, Qualification name, Programme title if applicable."]
["4. Please respond to each KSB statement."]
["5. Populate columns C-G as shown in the example at the top of each standard tab. "]
["6. Please be as specific as possible about which content in the qualification aligns to each KSB statement. "]
["7. Submit the completed spreadsheet along with 'Qualification structure' spreadsheet and any documents you have cited in the 'EVIDENCE UPLOAD' part of the application form. Where we have capacity we are happy to feedback on early drafts of your KSB mapping."]
["8. Please contact HTQ.approvals@education.gov.uk if you need further help or guidance on mapping."]

{"sheet":"ST0746","index":1,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Fire safety inspector (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The principles of the Fire Safety Order and fire safety legislation including, building regulations legislation and relevant codes of practice including national guidance and best practice",null,null,null,null,null,null,{"$f":"IF(C22:C39 = \"FULLY MET\",1,IF(C22:C39 = \"PARTIALLY MET\",0.5,IF(C22:C39 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","How the Fire Safety Order interacts with other legislation, guidance and best practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The role of the Primary Authority",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Levels of compliance and how the Enforcement Management Model and better regulation interacts with levels of compliance. ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","How to carry out fire safety audits on complex premises",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Different types of premises or environments, the associated risks and management levels",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Fire safety principles for high risk and complex premises or venues, in accordance with recognised guidance, legislation and regulations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Fire Risk Assessment processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Safeguarding issues and concerns and the actions to take",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The different groups and individuals they may interact with as part of their role ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How to initiate and undertake enforcement activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","How to work with other agencies to enforce fire safety legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The different types of formal response and the timescales",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The importance for operational staff to have valid, reliable and up to date information on premises, where the information is stored and how it can be accessed and used",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Their role in supporting formal investigations and the actions they can take in line with organisational policy",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The legislation, policies and procedures of the organisation and how these affect the role, including data protection, confidentiality, health and safety and lone working plus other relevant organisational policies and procedures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The causes and consequences of fires and unwanted fire signals",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The purpose and role of collaborative partners, sharing of information and the advantages of collaborative working",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Carry out an inspection/audit of complex premises and venues and assess the risks and evaluate the level of fire safety management",null,null,null,null,null,null,{"$f":"IF(C41:C51 = \"FULLY MET\",1,IF(C41:C51 = \"PARTIALLY MET\",0.5,IF(C41:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J41=1,1,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=1,\"NONE\",IF(L41=0.5,\"PARTIAL\",IF(L41=0,\"FULL\")))","v":"FULL"}]
["S2","Identify and constructively challenge non-compliance with the fire safety order and other relevant legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Produce fire safety reports, formal and informal correspondence, statutory notices and plans according to organisational policies and procedures",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J43=1,1,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},{"$f":"IF(L43=1,\"NONE\",IF(L43=0.5,\"PARTIAL\",IF(L43=0,\"FULL\")))","v":"FULL"}]
["S4","Identify safeguarding issues, such as hoarding, child sexual exploitation, slavery, vulnerability etc. and take appropriate action in accordance with organisational policies",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"}]
["S5","Evaluate risk levels for yourself, others and the environment and take appropriate action to ensure health and safety is maintained",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Apply British Standards, guidance and best practice to ensure compliance with fire safety legislation in the build environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Work with other agencies, such as local and national regulators ",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J47=1,0.5,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},{"$f":"IF(L47=0.5,\"NONE\",IF(L47=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S8","Demonstrate clear communication skills verbally and in writing, with the ability to interact with a wide range of audiences, being persuasive and confident.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["S9","Evaluate fire safety design submissions and fire protection systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Assess fire safety concerns, deliver fire safety advice as required and make decisions to instigate improvements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Respond to enquiries and requests from other organisations, in accordance with the Primary Authority.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Embraces and values equality, diversity and inclusion, treating everyone with dignity and respect",null,null,null,null,null,null,{"$f":"IF(C53:C60=\"FULLY MET\",1,IF(C53:C60=\"PARTIALLY MET\",0.5,IF(C53:C60=\"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J53=1,1,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=1,\"NONE\",IF(L53=0.5,\"PARTIAL\",IF(L53=0,\"FULL\")))","v":"FULL"}]
["B2","Demonstrates leadership through commitment and ability to develop self and others to improve organisational effectiveness and support a learning culture.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Acts with confidence and integrity, applying sound judgement with accuracy and rigour to create safe, effective and practical outcomes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Work within own level of authority, responsibility and competence and recognise when to seek support and/or assistance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Committed to supporting a strong safety culture and collaborating with others where necessary",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Contributes to achievements of self, others and organisation, by the establishment, maintenance and management of standards of performance",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J58=1,1,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=1,\"NONE\",IF(L58=0.5,\"PARTIAL\",IF(L58=0,\"FULL\")))","v":"FULL"}]
["B7","Takes personal responsibility to identify and challenge unsafe or inappropriate behaviours and processes.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J59=1,1,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=1,\"NONE\",IF(L59=0.5,\"PARTIAL\",IF(L59=0,\"FULL\")))","v":"FULL"}]
["B8","Demonstrates their contribution to - respecting life, the law, the environment and putting communities first",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J60)","v":0},"Net Score",{"$f":"SUM(L22:L60)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J63/L67","v":0},"total CoE KSB coverage",{"$f":"L63/L70","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",37]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L67-L68-(L69*0.5)","v":36.5}]

{"sheet":"ST0878","index":2,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Youth justice practitioner (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Legislation and corresponding guidance relevant to all aspects of work in youth justice, including sentencing, risk of harm, safeguarding, children’s rights and equality and diversity.",null,null,null,null,null,null,{"$f":"IF(C22:C35 = \"FULLY MET\",1,IF(C22:C35 = \"PARTIALLY MET\",0.5,IF(C22:C35 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Child and adolescent development and the full range of complex needs that can be detrimental to children’s physical, emotional and mental health and wellbeing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The range of factors (e.g. substance misuse and adverse childhood experiences) that may lead to offending and anti-social behaviour and the methods for promoting desistance from these.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The principles of professional judgement, including defensible decision making, how to guard against conscious or unconscious bias and how to maintain professional boundaries.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The key components of relationship-based practice and the evidence-base for them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The range and purpose of assessment and planning tools relevant to working with children in the youth justice system.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The range and type of services available for children in the youth justice age group, including adult service providers and how these work in relation to young people who are in transition to them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Protocol and process arrangements in working with multi-agencies, including the sharing and safeguarding of information in line with data protection law.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The emotional and practical needs of specialist groups of young people, e.g. Looked After Children, girls, LGBTQ+, BAME",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The practical, emotional and psychological impact of key types of life changes and transitions between services affecting children up to the age of 18.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Barriers to children’s effective engagement with youth justice interventions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The contextual aspects of risk (risk of what, to whom and circumstances in which risk is likely to be higher or lower).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Their own safeguarding responsibilities and those of others within and outside of their organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The principles of effective programme design and implementation for reducing offending and reoffending",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Communicate effectively face to face and in writing (including digitally) with children who encounter the youth justice system",null,null,null,null,null,null,{"$f":"IF(C37:C52 = \"FULLY MET\",1,IF(C37:C52 = \"PARTIALLY MET\",0.5,IF(C37:C52 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J37=1,0.5,IF(J37=0.5,0.5,IF(J37=0,0)))","v":0},{"$f":"IF(L37=0.5,\"NONE\",IF(L37=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Identify the factors that may lead to offending and anti-social behaviour and the methods for promoting desistance, and use these to plan individually tailored interventions.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J38=1,1,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=1,\"NONE\",IF(L38=0.5,\"PARTIAL\",IF(L38=0,\"FULL\")))","v":"FULL"}]
["S3","Promote the physical, emotional and mental health and wellbeing of children in the youth justice system by recognising and building on strengths, identifying need and taking action to protect children where necessary.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J39=1,1,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=1,\"NONE\",IF(L39=0.5,\"PARTIAL\",IF(L39=0,\"FULL\")))","v":"FULL"}]
["S4","Use a range of engagement skills to promote trust, including clarification of role, purpose of intervention and boundaries of authority.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Develop relationships that are collaborative, motivating and child-centred using a range of strategies to engage young people and families (e.g. motivational interviewing, solution focussed methods, participatory practice, pro-social modelling and problem solving).",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J41=1,0.5,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=0.5,\"NONE\",IF(L41=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S6","Make effective use of assessment and planning tools designed for use in youth justice settings to inform decision making.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J42=1,1,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=1,\"NONE\",IF(L42=0.5,\"PARTIAL\",IF(L42=0,\"FULL\")))","v":"FULL"}]
["S7","Develop, implement and monitor plans which reflect risks and needs, and build on positive human and social capital to promote desistance.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J43=1,0.5,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},{"$f":"IF(L43=0.5,\"NONE\",IF(L43=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S8","Select interventions and approaches to working with young people based on the best available evidence about their effectiveness in promoting desistance from offending.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"}]
["S9","Broker access to sources of human and social capital appropriate to the needs of children in the youth justice system.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Be an effective social advocate for children and their families",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Share and safeguard information about children and their families in line with data protection law",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","identify, assess and meet the needs of children and young people where there are safeguarding concerns",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J48=1,0.5,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=0.5,\"NONE\",IF(L48=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S13","Reflect on practice within evidence-based frameworks in order to continuously improve outcomes for children in the youth justice system.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J49=1,1,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=1,\"NONE\",IF(L49=0.5,\"PARTIAL\",IF(L49=0,\"FULL\")))","v":"FULL"}]
["S14","Identify any barriers to children’s effective engagement with youth justice interventions and take steps to remove or mitigate these.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Actively protect the rights of children, challenge disproportionality and promote equality of opportunity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Keep accurate and timely records of all interactions relevant to the assessment, planning, implementation and review cycle.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Show consistency and fairness and be evidence-informed in making decisions.",null,null,null,null,null,null,{"$f":"IF(C54:C58 = \"FULLY MET\",1,IF(C54:C58 = \"PARTIALLY MET\",0.5,IF(C54:C58 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=1,\"NONE\",IF(L54=0.5,\"PARTIAL\",IF(L54=0,\"FULL\")))","v":"FULL"}]
["B2","Model and reward pro-social behaviours, including respect for diversity and being inclusive, and discourage inappropriate language and behaviours",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Be optimistic and hopeful; non-blaming; open and honest; empathetic; and patient and calm in all interactions, including situations that are stressful",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Operate in accordance with the legal, ethical and contractual requirements of youth justice work and maintain professional boundaries.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Commit to team working and engage proactively with partner organisations and agencies to maximise the engagement of children in mainstream services and other positive activities.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J58=1,0.5,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=0.5,\"NONE\",IF(L58=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J58)","v":0},"Net Score",{"$f":"SUM(L22:L58)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J61/L65","v":0},"total CoE KSB coverage",{"$f":"L61/L68","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",35]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",5]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L65-L66-(L67*0.5)","v":32.5}]

{"sheet":"ST0930","index":3,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Anti-social behaviour and community safety officer (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Legal and organisational definitions of anti-social behaviour (ASB). The different types and categories of ASB. Organisational key performance indicators (KPI) when responding to the different categories of ASB.",null,null,null,null,null,null,{"$f":"IF(C22:C32 = \"FULLY MET\",1,IF(C22:C32 = \"PARTIALLY MET\",0.5,IF(C22:C32 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The definitions of vulnerability, safeguarding principles, the risk assessment matrix, vulnerabilities across a range of clients/group settings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Organisational policies and procedures in relation to ASB, community safety, vulnerability and safeguarding including hate crime, domestic abuse and tenancy management. The organisational process for dealing with reports of ASB/community safety. The organisational investigative process for reports of ASB and community safety issues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Legislation in relation to ASB and community safety matters including domestic abuse, hate crime, safeguarding, landlord and tenant law. The range of legal tools and powers available to resolve ASB.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Preparing a case for court. Court standard witness statements and burden of proof. Different types of evidence and how they can be used. Roles of court staff and legal staff including solicitors and barristers. Court processes and Civil Procedure Rules.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The range of informal tools that can be used to tackle ASB and community safety issues. How and in what circumstances informal tools can be used.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Multi-agency working and the roles of partner agencies. Referral routes to specific agencies. Available multi-agency meetings and forums.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","ASB case management principles. Investigative methods, interview methodology and techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The range of communication methods to engage with internal and external partners and stakeholders including statutory and voluntary sector.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Customer service standards and organisational KPIs in relation to responding to customers. Complaints and enquiry processes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Methods of recording information. IT systems, information and data-sharing processes. Law, guidance and principles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Respond effectively and appropriately to reports. Analyse reports of ASB/community safety, identifying priorities and what the next appropriate steps are. Analyse and risk-assess all reports of ASB and community safety issues.",null,null,null,null,null,null,{"$f":"IF(C34:C47 = \"FULLY MET\",1,IF(C34:C47 = \"PARTIALLY MET\",0.5,IF(C34:C47 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J34=1,1,IF(J34=0.5,0.5,IF(J34=0,0)))","v":0},{"$f":"IF(L34=1,\"NONE\",IF(L34=0.5,\"PARTIAL\",IF(L34=0,\"FULL\")))","v":"FULL"}]
["S2","Provide a professional and timely response to customer enquiries. Manage expectations and keep the customer informed of progress. Identify potential safeguarding needs of young and vulnerable people.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J35=1,0.5,IF(J35=0.5,0.5,IF(J35=0,0)))","v":0},{"$f":"IF(L35=0.5,\"NONE\",IF(L35=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S3","Communicate with customers and stakeholders using a range of methods including face-to-face, telephone, email, letters, reports responding to the needs of a diverse group.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J36=1,1,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=1,\"NONE\",IF(L36=0.5,\"PARTIAL\",IF(L36=0,\"FULL\")))","v":"FULL"}]
["S4","Make justifiable and appropriate decisions on the information available.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Plan and prioritise work effectively using a range of organisational tools to ensure tasks are completed and deadlines are met.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Work effectively and collaboratively with a range of stakeholders and customers to achieve specific targets and outcomes. Comply with court directions and ensure that deadlines are met.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J39=1,0.5,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=0.5,\"NONE\",IF(L39=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S7","Investigate reports of ASB/community safety thoroughly and systematically to understand and analyse underlying issues. Obtaining appropriate evidence.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J40=1,1,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=1,\"NONE\",IF(L40=0.5,\"PARTIAL\",IF(L40=0,\"FULL\")))","v":"FULL"}]
["S8","Plan investigations into cases thoroughly and methodically.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J41=1,1,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=1,\"NONE\",IF(L41=0.5,\"PARTIAL\",IF(L41=0,\"FULL\")))","v":"FULL"}]
["S9","Interview all parties involved in a case using effective investigative and interview techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Understand and gather relevant information and using the full range of tools, powers and support available to resolve ASB/community safety issues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Maintain accurate and appropriately-detailed records and information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Effectively challenge, influence and negotiate with customers, partners and stakeholders to achieve outcomes and resolutions.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J45=1,0.5,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=0.5,\"NONE\",IF(L45=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S13","Prepare a case file for referral to solicitors or for legal proceedings.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J46=1,1,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=1,\"NONE\",IF(L46=0.5,\"PARTIAL\",IF(L46=0,\"FULL\")))","v":"FULL"}]
["S14","Effectively present a case and evidence for a review panel or in legal proceedings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Demonstrate a commitment to delivering a high-quality, timely and responsive service. Take ownership of dealing with all matters appropriately demonstrating a commitment to equality, diversity, inclusion and discretion.",null,null,null,null,null,null,{"$f":"IF(C49:C52 = \"FULLY MET\",1,IF(C49:C52 = \"PARTIALLY MET\",0.5,IF(C49:C52 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J49=1,1,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=1,\"NONE\",IF(L49=0.5,\"PARTIAL\",IF(L49=0,\"FULL\")))","v":"FULL"}]
["B2","Work effectively with colleagues and external stakeholders seeking to deliver joint solutions, sharing appropriate information and negotiating new ways of providing services together.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J50=1,0.5,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=0.5,\"NONE\",IF(L50=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Deliver timely performance and taking responsibility and accountability for quality outcomes. Use insight, judgement, evidence and knowledge to arrive at accurate, expert and professional decisions and advice.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
["B4","Communicate with others clearly and concisely making efforts to understand needs, perspectives and concerns.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J52)","v":0},"Net Score",{"$f":"SUM(L22:L52)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J55/L59","v":0},"total CoE KSB coverage",{"$f":"L55/L62","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",29]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L59-L60-(L61*0.5)","v":27}]

{"sheet":"Source filters ","index":4,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["FULLY MET"]
["PARTIALLY MET"]
["NOT MET "]