{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["GUIDE TO KSB MAPPING","ST0509","ST0516","ST0746","ST0747","ST0764","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":"ST0509","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[9,0,9,6],[0,3,2,4]]}
[null,"START HERE",null,"PLEASE CONTACT US AT HTQ.APPROVALS@EDUCATION.GOV.UK IF YOU WISH TO MAP YOUR QUALIFICATION AGAINST ST0509 POLICE COMMUNITY SUPPORT OFFICER (LEVEL 4) OCCUPATIONAL STANDARD"]
[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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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,"Police community support officer (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Knowledge"]
["K1","The ethics and values of the police service, including: duty of care, service delivery, employment practice, efficiency, effectiveness and value for money, the Code of Ethics, professional standards, and equality, diversity and human rights"]
["K2","The composition and diversity of individuals, groups and neighbourhoods in their community and ways in which they may help to develop partnership working to address local community and policing issues, problems or concerns"]
["K3","Appropriate methods and media for communicating with individuals, local and multi-agency partners across the community e.g. social media, face to face, neighbourhood meetings, email etc."]
["K4","The principles of applying a preventative, evidence-based community policing approach to mitigate or solve community issues, problems or concerns"]
["K5","The legal and organisational requirements related to managing conflict and acting in a way which is likely to defuse potential conflict situations, including applying tactical (non-physical) options in line with their powers, training and issued equipment"]
["K6","The legal and organisational requirements (local policy) related to responding to incidents and performance of their PCSO duties relating to these responses, including enforcement activities such as e.g. issuing fixed penalty notices (FPNs) for anti-social behaviour, dog fouling and littering and any bylaws relating to their operational context e.g. railway related offences (British Transport Police)"]
["K7","The factors that affect vulnerable people (e.g. those at risk from radicalisation or those experiencing mental ill health; the elderly; children and those who may be being coerced, victims and witnesses) and how this may impact on their need for support, including where they may be able to access that support e.g. local Prevent body"]
["K8","The legal and organisational requirements relating to handling community and police information and intelligence"]
[null,"Skills"]
["S1","Foster, promote and maintain channels of communication and develop close working relationships with key groups, multi-agency partners and individuals across the community"]
["S2","Communicate effectively, in accordance with the varied needs of differing situations, individuals, groups and communities, including those who may be victims, witnesses and vulnerable people, supporting diversity and inclusivity through their communications"]
["S3","Provide initial support to vulnerable people and assess their needs for further support, including providing advice on accessing that support"]
["S4","Gather, handle and submit information and intelligence from a variety of sources to support law enforcement and to maximise policing effectiveness."]
["S5","Work under the direction of their line managers and community-based Police Constables, contribute to developing, planning and implementing preventative and problem-solving policing approaches to local concerns and issues, including providing assistance to review, analyse and share the results of evidence-based initiatives"]
["S6","Work alongside partner organisations or as part of a multi-disciplinary team to improve, mitigate and solve community problems, issues or concerns"]
["S7","Provide an initial response to incidents (where necessary) in-line with legal and organisational requirements and the limits of their responsibilities, including appropriate planning (e.g. strategies for managing traffic flow), for responses based on analysis of all relevant information at hand"]
["S8","Provide support for victims and witnesses at policing incidents, including advice to identify and access sources of additional support (or accessing sources on behalf of individuals) and post-incident help, and where appropriate, delivering any necessary follow-up assistance."]
["S9","Apply appropriate conflict management tactics e.g. appropriate communication (not ‘hands on’ physical techniques) where absolutely necessary and in-line with the powers bestowed on them, issued equipment (where applicable), the training they have received and organisational policy and procedure."]
[null,"Behaviours"]
["B1","Taking accountability - Being accountable and taking ownership for own role and responsibilities, whilst being effective and willing to take appropriate, justifiable risks."]
["B2","Professional integrity - Maintain the highest standards of professionalism and trustworthiness, making sure that values, moral codes and ethical standards are always upheld, including challenging others where their standards fall below those expected."]
["B3","Emotionally astute - Understand and effectively manage own emotions in stressful situations, understanding motivations and underlying reasons for own behaviour and that of others. Value diversity and difference in approaches to work, thinking and background, and treat people with sensitivity, compassion and warmth."]
["B4","Curious and innovative - Have an inquisitive and outward-looking nature, searching for new information to understand alternative sources of best practice and implement creative working methods. Committed to reflecting on how own role is undertaken, learning from success and mistakes, to continuously review and adapt approach."]
["B5","Collaborative - Work effectively with colleagues and external partners, sharing skills, knowledge and insights as appropriate to lead to the best possible results."]
["B6","Supportive & inspirational leading - Uphold the police service’s values in day-to-day activities, providing inspiration and clarity to colleagues and stakeholders. Consider how the wider organisation and others are impacted, and help others to deliver their objectives effectively."]

{"sheet":"ST0516","index":2,"n_rows":61,"n_cols":18,"rows_kept":61,"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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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,"Intelligence analyst (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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 organisationally appropriate intelligence collection and storage methods, together with their limitations. This includes applying that knowledge to sensitive and classified materials and other openly accessible information.",null,null,null,null,null,null,{"$f":"IF(C22:C33 = \"FULLY MET\",1,IF(C22:C33 = \"PARTIALLY MET\",0.5,IF(C22:C33 = \"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 implications for loss of sensitive material, remaining alert to the methods required to protect against physical and cyber security risks and what procedures to follow in the event of loss of such material?",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The processes involved in the collation and evaluation of organisationally relevant sources of information for use within intelligence products which will include learning to use specialist software systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Organisationally relevant Intelligence Sources that are commonly used, such as Open Source, Imagery, Communications and Human.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The Intelligence Cycle, including all processes involved in direction, collection, processing and dissemination of intelligence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The main factors influencing their respective organisational/client environments, such as specific threats and key intelligence priorities, for example, tax evasion, passport fraud, people smuggling, organised criminality.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The benefit of generating or using intelligence combined from a number of sources as opposed to a single source, considering how validity and credibility can be affected depending on the type used.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How to use analytical development techniques to identify and produce key findings and judgements in assessments. Techniques could include, but are not limited to, pattern and trend analysis, geospatial analysis, network analysis, or others as appropriate to the organisation and its risks.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Understand how to carry out data analysis from a numerical or factual perspective and interpret it, taking account of quantity and quality of data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","How to identify intelligence gaps and opportunities for further analysis such as developing and maintaining an expert level knowledge or expertise to allow considered assessment through interpretation and evaluation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How to identify a range of relevant and credible information sources and recognise the need to collect new data when necessary from internal and external sources.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","How bias can affect judgement, and the dangers it presents if measures are not in place to mitigate this.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Engage with clients appropriately to ensure effective understanding of intelligence tasks and actively monitor ongoing intelligence requirements, engaging with all levels in an organisation, the customer and other interested parties in order to respond to demands.",null,null,null,null,null,null,{"$f":"IF(C35:C43 = \"FULLY MET\",1,IF(C35:C43 = \"PARTIALLY MET\",0.5,IF(C35:C43 = \"NOT MET\",0,)))","v":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"}]
["S2","Recommend what information should be collected based upon identified intelligence gaps, and/or issue requests for information to external organisations to collect or process information.",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"}]
["S3","Identify, review, and interpret significant information, applying organisationally appropriate analytical techniques such as the use of diagnostics (links, patterns, and trends), scenario generation and validating assessments to identify key findings and opportunities for further analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Think critically, through objective analysis and evaluation of an issue, to form a judgement which is unbiased, undistorted and can withstand challenge.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Produce written reports to a high standard as well as confident verbal briefings and presentation of findings, using an appropriate range of methods dependent on factors like audience, available time and the organisation’s culture.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Obtain client views on outcomes so as to feed back into the Intelligence Cycle and enrich the process of collection, processing, dissemination.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Use existing and emerging IT (including digital) applications in the analysis, development and dissemination of intelligence products in line with organisational requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Operate in accordance with applicable security and legislative responsibilities such as applying appropriate audit trails, handling instructions, and protective markings, including the Official Secrets’ Act.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J42=1,0.5,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=0.5,\"NONE\",IF(L42=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Organise appropriate disposal when working with sensitive materials.",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"}]
[null,"Behaviours"]
["B1","Confident in their ability and have courage of their convictions.",null,null,null,null,null,null,{"$f":"IF(C45:C51 = \"FULLY MET\",1,IF(C45:C51 = \"PARTIALLY MET\",0.5,IF(C45:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"FULL"}]
["B2","Logical with a good attention to detail.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Discreet and trustworthy when working with highly confidential materials.",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"}]
["B4","Open minded, innovative and a problem solver.",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"}]
["B5","Agile, able to adjust rapidly and decisively, especially when operating in complex situations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Persistent and resilient; not all intelligence activity will immediately be successful.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Flexible and understand that there is more than one way of working.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J51)","v":0},"Net Score",{"$f":"SUM(L22:L51)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J54/L58","v":0},"total CoE KSB coverage",{"$f":"L54/L61","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",28]
[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",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L58-L59-(L60*0.5)","v":26.5}]

{"sheet":"ST0746","index":3,"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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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,"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"}]
["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,"PARTIAL",{"$f":"IF(J44=1,0.5,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=0.5,\"NONE\",IF(L44=0,\"PARTIAL\"))","v":"PARTIAL"}]
["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",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"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,"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"}]
["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",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L67-L68-(L69*0.5)","v":35}]

{"sheet":"ST0747","index":4,"n_rows":95,"n_cols":18,"rows_kept":95,"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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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,"Counter fraud investigator (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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","Understand the legislation and associated codes of practice relevant to investigations as well as an understanding of departmental policy. Covering appropriate laws including Police and Criminal Evidence Act 1984 (PACE), Criminal Procedure and Investigations Act 1996 (CPIA), Human Rights Act (HRA), and Proceeds of Crime Act 2002 (POCA), Data Protection legislation, Public Interest Disclosure Act 1998 (PIDA), Whistleblowing (WB) policies and equivalent Civil legislation such as the Finance Act (FA) where appropriate.",null,null,null,null,null,null,{"$f":"IF(C22:C49 = \"FULLY MET\",1,IF(C22:C49 = \"PARTIALLY MET\",0.5,IF(C22:C49 = \"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","Understand the points to prove in pursuing an investigation such as guilty mind, guilty act, and prima facie evidence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Develop professional knowledge of relevant legislation and regulatory requirements for the different types of investigation. Keep this knowledge up to date by identifying sources of information and identifying policy and law change.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Understand how to open and maintain a case file and how to plan an investigation to the required standard for criminal, civil, regulatory or disciplinary investigations. Understand the Fraud Investigation Model (Criminal) / or organisational equivalent when responding to allegations of fraud.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Understand the different types of evidence (direct, circumstantial, hearsay etc.)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Understand the types of forensic opportunity available and when they can be used to gather evidence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Understand the principles of RIPA codes of practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Understand why the recording of notes of interviews, conversations, evidential observations and decisions made during the course of an investigation is necessary and has knowledge of best practice use. Understand how to produce witness statements / affidavits to the standard required for all types of investigations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Understand why recording investigation activities / enquiries during the course of an investigation are necessary and has knowledge of best practice use. Understand the rules and relevant policies relating to the continuity of evidence such that the source of evidence can be fully supported. Understand the National Intelligence Model, National Intelligence methodology (criminal investigation) and the demarcation of intelligence and evidence and demonstrate awareness of source and evidence handling.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Understand the relevant legislation and procedures (including Legal Professional Privilege) in the participation of a search of a person, premises, vehicles or workplaces.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Understand how to assess the strength of evidence and the requirement to lawfully gather evidence to required standards in a criminal, civil, regulatory or disciplinary investigations, subject to role.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Understand how to produce witness statements to the standards required by the CPIA 1996 (criminal investigations). Understand how to produce witness statements / affidavits to the standard required for non-criminal investigations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Understand how data may be analysed and collated to support investigative decisions and outcomes in criminal, civil, regulatory or disciplinary investigations as appropriate. Understand when the government protective marking scheme and source management processes should apply when disseminating material.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Understand the briefing and de-briefing format.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Understand the PEACE model and the use of conversation management and open recall techniques, how to produce an overarching investigative interviewing strategy, an interview plan and how to evaluate an investigatory interview to identify further investigative actions, to the required standard, civil, disciplinary, regulatory or criminal. Where appropriate.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Understand the requirements for conducting an Interview Under Caution (IUC) fully compliant with the requirements of PACE and Criminal Justice Act 2003 (CJA) (criminal investigations). Understand the requirements for conducting an interview which is fully compliant with relevant legislation or departmental policy (non-criminal investigations).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Understand the varying demands of the witness and how to respond to them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Understand how to produce investigator notes, narrative statements, 3rd party witness testimonies and transcripts, and the requirements for retention.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Understand how to produce concise, timely, clear, balanced & accurate reports, briefings, letters, e-mails & other items of correspondence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Understand how to prepare files, applications and orders for court to the required standard for the activity undertaken.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Understand the procedures and requirement to give evidence as a witness at hearings. (Criminal / Civil / Regulatory / Disciplinary investigations). Understand the process for referring a case to other law enforcement agencies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Understand compliance with the provisions for disclosure in court, tribunal or disciplinary proceedings as appropriate.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Understand how to obtain, record & present evidence in court during proceedings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Understand how to provide insight from investigations to identify and facilitate improvements to policy and processes to assist prevention, deterrence and increased future detection.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Understand how to prepare an evidence file with material to support court, tribunal or disciplinary proceedings in accordance with the requirements of the relevant legislation, codes of practice or departmental policy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Understand how to prepare files and investigate to the relevant standard in parallel, including the differences and associated risks in parallel investigations and the relevant parallel civil enforcement and / or recovery / compensation actions and how to progress them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Understand who the partners are in the counter fraud community and law enforcement sector and the need to build and maintain new and existing partner / stakeholder relationships with those involved in investigations to achieve progress on objectives, key initiatives and shared interests.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Understand the different types of fraud committed and how these frauds could be perpetrated, the processes required to determine the losses and costs figures in sanction and redress outcomes and how to report the outcome with recommendations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply legislation and associated codes of practice and can determine points to prove in pursuing an investigation. Apply departmental policy.",null,null,null,null,null,null,{"$f":"IF(C51:C78 = \"FULLY MET\",1,IF(C51:C78 = \"PARTIALLY MET\",0.5,IF(C51:C78 = \"NOT MET\",0,)))","v":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"}]
["S2"," Investigate the points to prove in pursuing an investigation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Identify sources of information e.g. regarding the process of policy and law change.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Maintain case files and produce investigation plans to the required standards for criminal, civil, regulatory or disciplinary investigations. Apply the Fraud Investigation Model (Criminal) / or organisational equivalent when responding to allegations of fraud.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Differentiate between types of evidence (direct, circumstantial, hearsay etc.) and relate their significance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Utilise forensic opportunities and how to apply them in investigations (where relevant to the type of investigations undertaken).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Apply consideration of the principles of RIPA codes of practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Implement best practice for note taking during the course of an investigation (where relevant to the type of investigations undertaken). Implement best practice for witness statements during the course of an investigation (Relevant to the type of investigations undertaken).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Produce records of the investigation activities / enquires during the course of an investigation. Apply the rules and relevant policies relating to the continuity of evidence so the source of evidence can be fully supported. Apply the classification and handling of information in line with the National Intelligence Model and national intelligence methodology (criminal investigation) and appropriate handling principles to source and intelligence material, demonstrating knowledge of potential risks of mishandling.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Participate in searches (including consideration of Legal Professional Privilege) of a person, premises, vehicles or workplaces, adhering to policy and legislation of organisation.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J60=1,0.5,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=0.5,\"NONE\",IF(L60=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S11","Assess the strength of evidence and apply the relevant legislation and codes of practice to gather evidence to required standards, subject to role",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J61=1,1,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=1,\"NONE\",IF(L61=0.5,\"PARTIAL\",IF(L61=0,\"FULL\")))","v":"FULL"}]
["S12","Produce witness statements to the required standard for the investigations e.g. Criminal Investigation Standard.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Use analysis techniques on a range of data and make sound and fair investigation decisions in investigation as appropriate. Apply the organisation’s protective marking scheme and source management before disseminating material.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Apply the briefing and de-briefing method, disseminating information gathered to the appropriate individuals, groups, or departments as required, for all investigations.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J64=1,0.5,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=0.5,\"NONE\",IF(L64=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Utilise the PEACE model for interviewing, applying conversation management and open recall techniques, complete an overarching investigative interviewing strategy, produce interview plans, summarise and evaluate interviews to the required standard.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=1,\"NONE\",IF(L65=0.5,\"PARTIAL\",IF(L65=0,\"FULL\")))","v":"FULL"}]
["S16","Undertake an interview appropriate to the investigation being undertaken, introducing testimony and exhibits during interviews as appropriate.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Recognise and respond to the varying demands of the witness.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Produce and retain accurate investigator notes, narrative statements, 3rd party witness testimonies and transcripts.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Produce concise, timely, clear, balanced & accurate reports, briefings, letters, e-mails & other items of correspondence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Prepare files, applications and orders for court to the required standard for the activity undertaken.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Present evidence as a witness at appropriate hearings. Refer appropriate cases to other law enforcement agencies.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J71=1,0.5,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=0.5,\"NONE\",IF(L71=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S22","Comply with the provisions of disclosure in legal proceedings.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J72=1,1,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=1,\"NONE\",IF(L72=0.5,\"PARTIAL\",IF(L72=0,\"FULL\")))","v":"FULL"}]
["S23","Obtain, record & present evidence in court during proceedings.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J73=1,0.5,IF(J73=0.5,0.5,IF(J73=0,0)))","v":0},{"$f":"IF(L73=0.5,\"NONE\",IF(L73=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S24"," Produce full and accurate post investigation assessments.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J74=1,1,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=1,\"NONE\",IF(L74=0.5,\"PARTIAL\",IF(L74=0,\"FULL\")))","v":"FULL"}]
["S25"," Produce an evidence file with material to support court, tribunal or disciplinary proceedings in accordance with the requirements of the relevant legislation, codes of practice or departmental policy.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J75=1,1,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},{"$f":"IF(L75=1,\"NONE\",IF(L75=0.5,\"PARTIAL\",IF(L75=0,\"FULL\")))","v":"FULL"}]
["S26","Utilise the correct powers appropriate to the type of investigation.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},{"$f":"IF(L76=0.5,\"NONE\",IF(L76=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S27","Build and maintain new and existing partner / stakeholder relationships to achieve progress on objectives, key initiatives and shared interests and developing beneficial working relationships.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J77=1,0.5,IF(J77=0.5,0.5,IF(J77=0,0)))","v":0},{"$f":"IF(L77=0.5,\"NONE\",IF(L77=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S28","Categorising fraud and provide insight into how the fraud was perpetrated, calculate the losses and costs borne in cases of fraud for use in sanctions and redress outcomes.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J78=1,0.5,IF(J78=0.5,0.5,IF(J78=0,0)))","v":0},{"$f":"IF(L78=1,\"NONE\",IF(L78=0.5,\"PARTIAL\",IF(L78=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Committed, conscientious and organised even when completing multiple tasks.",null,null,null,null,null,null,{"$f":"IF(C80:C85 = \"FULLY MET\",1,IF(C80:C85 = \"PARTIALLY MET\",0.5,IF(C80:C85 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J80=1,1,IF(J80=0.5,0.5,IF(J80=0,0)))","v":0},{"$f":"IF(L80=1,\"NONE\",IF(L80=0.5,\"PARTIAL\",IF(L80=0,\"FULL\")))","v":"FULL"}]
["B2","Take accountability for decisions made and for maintaining own knowledge and skills.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Work with integrity, impartiality and excellence in line with requirements of the business and their profession.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Inquisitive, open-minded and objective, will seek out evolving and innovative ways to add value",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5"," Show courage, resilience and flexibility when interacting with others to ensure the best outcome.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Work collaboratively with stakeholders to achieve common goals and have an awareness of different styles of working to ensure mutual respect.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J85)","v":0},"Net Score",{"$f":"SUM(L22:L85)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J88/L92","v":0},"total CoE KSB coverage",{"$f":"L88/L95","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",62]
[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",6]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L92-L93-(L94*0.5)","v":59}]

{"sheet":"ST0764","index":5,"n_rows":180,"n_cols":7,"rows_kept":180,"cut":false,"hidden":false,"merged":[[9,0,9,6],[0,3,2,4]]}
[null,"START HERE",null,"PLEASE CONTACT US AT HTQ.APPROVALS@EDUCATION.GOV.UK IF YOU WISH TO MAP YOUR QUALIFICATION AGAINST ST0764 NON HOME OFFICE POLICE OFFICER (LEVEL 4) OCCUPATIONAL STANDARD "]
[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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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,"Non home office police officer (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Knowledge"]
["K1","The codes of ethics and values and standards, including duty of care to both colleagues and others, and this may include but is not restricted to equality, diversity and human rights"]
["K2","The threat posed by the prevailing security situation and any policy/measures to mitigate the risk"]
["K3","The policy and statutory powers to effectively manage incidents. This may include but is not restricted to; responding to incidents, preserving scenes and evidence when necessary; arrest, detain and report individuals safely and lawfully; risk manage health and safety for self and for others"]
["K4","Authorised equipment and physical resources is to be used in the execution of their duty"]
["K5","The management of health and safety for self and for others"]
["K6","Available technology for use in a policing and investigate environment"]
["K7","The policy and legislative obligations concerned in the recovery, handling and management of information and intelligence"]
["K8","Gathering, submitting and sharing information and intelligence to further policing-related outcomes"]
["K9","The policy and statutory powers used to methodically search individuals or vehicles"]
["K10","The preservation of evidence including; persons, areas, property or premises"]
["K11","The principles of conflict resolution using communication skills and the application to physical protection and restraint"]
["K12","The policy for the management of suspects, victims and witnesses paying attention to vulnerable individuals or groups"]
["K13","The policy, procedures and legislative obligation in the production of written submissions to support the justice system"]
["K14","The inter-dependent areas of policing. This will include but is not restricted to; other policing or law enforcements agencies; organisations within the justice system; governmental and non-governmental departments and agencies"]
["K15","The diversity of individuals, groups and neighbourhoods in their community and ways in which they may help to develop partnership working to address local community and policing issues, problems or concerns"]
["K16","The requirements and processes for the assured recovery or preservation of evidence to maintain its integrity for future exploitation"]
["K17","The organisational support and obligations to the justice system"]
["K18","The policy, legislative requirements and statutory powers to be applied to the investigation of criminal and non-criminal matters"]
["K19","The electronic equipment, applications and systems used within their organisation. How they are effectively used in the detection or deterrence of crime"]
["K20","What is an authorised firearms officer (AFO)"]
["K21","What is fitness for armed duty and personal responsibility in relation to it"]
["K22","What needs to be recorded and where, in relation to the issue and carriage of firearms and related equipment"]
["K23","The legislation and national guidelines relating to carrying a police firearm"]
["K24","The different methods of carriage of a police firearms in accordance with procedures"]
["K25","The authorities for deployment of AFOs"]
["K26","The criteria for deployment of AFOs"]
["K27","When an AFO may self-deploy"]
["K28","The key benefits and considerations of post deployment procedures following the deployment of AFOs"]
["K29","The role of the post incident manager (PIM)"]
["K30","The criteria for post incident investigation and the difference between a mandatory and voluntary referral"]
["K31","The roles/responsibilities specific to the post incident process"]
["K32","Who may become key police witnesses"]
["K33","The legislation and national guidelines relating to shooting a police firearm"]
["K34","The factors to be considered prior to shooting a police firearm"]
["K35","How to respond appropriately to vulnerable persons in a firearm situation"]
["K36","The appropriate points of aim when shooting a police firearm"]
["K37","The police firearms shooting positions"]
["K38","What is meant by \"containment\" in a firearms situation"]
["K39","How to carry out a dynamic risk assessment"]
["K40","Considerations in relation to sieges"]
["K41","The different roles within the context of the wider police operation to support the achievement of operational strategies and priorities for action in relation to containment in a firearm situation"]
["K42","The different methods of containment in a firearms situation"]
["K43","The range of tactical actions to deal with subjects on foot in a firearms situation"]
["K44","The range of tactical actions to deal with subjects in a vehicle in a firearms situation"]
["K45","The additional considerations when responding to vehicle as weapon attacks"]
["K46","The range of tactical actions to deal with subjects in a building or other structure in a firearms situation"]
["K47","Emergency search"]
["K48","The circumstances under which an emergency search can be conducted"]
["K49","The resource considerations for emergency search"]
["K50","Search terminology"]
["K51","The considerations/tactics for open area searches"]
["K52","The specialist support and equipment that should be considered when searching for subjects in the open"]
["K53","The specialist support and equipment that should be considered when performing open country searches"]
["K54","The considerations for cover and movement"]
["K55","The procedures for cover and movement"]
["K56","The different less lethal weapons"]
["K57","The intended use of less lethal weapons"]
["K58","The legislation/guidelines in relation to the carriage of less lethal weapons"]
["K59","The legislation/guidelines in relation to the use of less than lethal weapons in a policing operation"]
["K60","The post deployment procedures after use of a less lethal weapon in a policing operation"]
["K61","The proportionate and lawful use of force in line with legal accountabilities"]
["K62","First aid"]
["K63","Tactics in a firearms situation"]
["K64","The room entry principles when conducting emergency search"]
["K65","The National Decision Making (NDM) or equivalent process"]
[null,"Skills"]
["S1","Demonstrate effective communication in accordance with the varied needs of differing situations, individuals, groups and communities. Use own communication skills to manage planned and uncertain situations, and to persuade/lead others as needed"]
["S2","Gather, handle and accurately assess information and intelligence from appropriate sources to support law enforcement and to maximise policing effectiveness"]
["S3","Analyse all available information to make threat assessments and manage conflict situations in policing through leadership, and deal with a wide range of behaviours and incidents, taking personal accountability for the use of proportionate and justifiable responses and actions"]
["S4","Analyse all available information to be able to assess the risks and threats posed by the situation to allow for the best possible outcome. In doing so use the national decision making model or equivalent to influence the thought process behind decisions and activity"]
["S5","Demonstrate proficient use of authorised equipment, this may include but is not restricted to communications and personnel protection assets"]
["S6","Demonstrate the correct use of health and safety procedures and demonstrate an understanding of individual responsibility"]
["S7","Demonstrate appropriate use of statutory powers and policy to manage suspects, victims and witnesses across various challenging situations, conducting all actions in a balanced, proportionate and justifiable manner. This may include but is not restricted to arrest and search"]
["S8","Identify the appropriate situation to use authorised equipment, including communications and personnel protection assets and able to effect user maintenance or apply the procedures for the management of damaged or inoperable equipment"]
["S9","Take measures to ensure that security, integrity and confidentiality of information is maintained, using appropriate policy and legislation concerned with the management of information"]
["S10","Generate written submissions and reports. This will include the management and storage of such items and their disclosure when appropriate"]
["S11","Provide an initial and ongoing response to incidents, which can be complex, confrontational and life- threatening, to bring about the best possible outcomes"]
["S12","Provide an initial response to crime scenes, where encountered, that require the management and preservation of evidence and or exhibits"]
["S13","Identify those individuals who are considered vulnerable and manage them in accordance with policy and legislation"]
["S14","Provide support for victims and witnesses, inclusive of those who are deemed to be vulnerable, at policing incidents. This includes giving advice to identify and access sources of additional support (or accessing sources on behalf of individuals) and post-incident help, and where appropriate, delivering any necessary follow-up assistance"]
["S15","Apply and promote the codes of ethics and values and standards in the delivery of all aspect of their duties"]
["S16","Demonstrate working alongside partner organisations or as part of a multi-disciplinary team to improve, mitigate and solve community problems, issues or concerns. This my include, but is not restricted the provision of Crime Reduction advice"]
["S17","Engage in community activity. This for example could include schools or community groups and maybe collaborative activity with other stakeholders such as law enforcement agencies"]
["S18","Use the appropriate policy, legislative requirements and statutory powers when conducting investigation in to criminal and non-criminal matters"]
["S19","Provide support to vulnerable people and assess their needs for further support, including providing advice on accessing that support"]
["S20","Preserve and manage crime scenes whilst also developing forensic strategies to exploit evidential opportunities from available material"]
["S21","Recover, manage and, where appropriate, dispose of evidence in accordance with policy and in line with statutory obligations"]
["S22","Demonstrate the use electronic equipment, applications and systems used in a policing and investigational context"]
["S23","Be able to issue firearms in accordance with national procedures"]
["S24","Recognise when an AFO is deployed"]
["S25","Demonstrate loading, make ready and unloading a police firearm in accordance with procedures"]
["S26","Be able to identify the characteristics and capabilities of firearms, ammunition, ballistics, protection"]
["S27","Demonstrate the different carriages of a police firearm"]
["S28","Deploy operationally as an AFO in accordance with set procedures and authorities"]
["S29","Carry out post deployment procedures"]
["S30","Identify the key benefits and considerations of post deployment procedures following the deployment of AFOs"]
["S31","Be able to recognise the criteria for post incident investigation and the difference between a mandatory and voluntary referral"]
["S32","Describe the roles/responsibilities specific to the post incident process"]
["S33","Summarise the immediate post incident command considerations. (LO 7)."]
["S34","Recognise who are key police witnesses"]
["S35","Review own performance objectively and take steps to maintain and enhance competence and professional standards appropriate to the role"]
["S36","Demonstrate competence in a range of tactical options commensurate with the AFO role"]
["S37","Be able to apply procedures and legislation in relation to shooting a police firearm and in line with policy and guidance"]
["S38","Demonstrate competence with a range of weapons and tactical equipment appropriate to the role"]
["S39","Demonstrate appropriate handling of a police firearm"]
["S40","Demonstrate accuracy in shooting a police firearm"]
["S41","Demonstrate the appropriate action to deal with a weapon malfunction"]
["S42","Shoot the weapon accurately from the standing, kneeling and prone position if appropriate to the weapon"]
["S43","Shoot accurately having moved dynamically between different shooting positions"]
["S44","Shoot accurately at close range"]
["S45","Shoot accurately using cover"]
["S46","Shoot the firearm to the required national minimum standard of accuracy"]
["S47","Shoot accurately whilst on approach and withdrawal"]
["S48","Demonstrate the correct reload drill"]
["S49","Demonstrate competence in a range of tactical options commensurate with their AFO role"]
["S50","Be able to work effectively in a team to achieve shared objectives, demonstrating awareness of individual differences and providing support as required"]
["S51","Respond to conflict situations using a range of tactical options, assessing the threat to determine a proportionate response in line with legislation, policy and guidance"]
["S52","Assess the immediacy and proximity of threat in order to make operational decisions for the protection of life"]
["S53","Apply nationally recognised techniques associated with containment in a firearms situation"]
["S54","Demonstrate a physical overt or discreet containment"]
["S55","Be able to carry out a dynamic risk assessment in a firearms situation"]
["S56","Apply the National Decision Model to manage the response to a situation in a reasonable and proportionate way"]
["S57","Demonstrate good and effective communication skills with the ability to listen to others"]
["S58","Be able to act with discretion and emotional intelligence to manage conflict and defuse difficult situations"]
["S59","Perform Overt Interception in a police firearms situation"]
["S60","Perform a Challenge from Cover in a police firearms situation"]
["S61","Demonstrate safely approaching a stationary vehicle making best use of cover"]
["S62","Demonstrate safely approaching a stationary vehicle making best use of cover"]
["S63","Use appropriate portable ballistic protection"]
["S64","Be able to plan a simple approach to a building"]
["S65","Plan and participate in a limited entry, as part of a team"]
["S66","Consider contingencies when conducting a limited entry"]
["S67","Perform the role of shield officer, cover officer and support officer when conducting a limited entry as part of a team"]
["S68","Demonstrate the correct non-verbal tactical communication (NVTC) as required"]
["S69","Perform the roles of number one, two, support and front cover during an emergency search"]
["S70","Demonstrate the different form up configurations correctly when conducting an emergency search"]
["S71","Perform emergency search with varying officer numbers"]
["S72","Demonstrate correct initial setup on a closed inward/outward opening and open door"]
["S73","Demonstrate correct positioning within the team prior to entry"]
["S74","Understand own role within the context of the wider police operation to support the achievement of operational strategies and priorities for action"]
["S75","Competent in a range of tactical options commensurate with own AFO role"]
["S76","Perform searches in the open as part of a pair"]
["S77","Perform searches in the open as part of a larger team"]
["S78","Perform open country searches in context with role"]
["S79","Perform cover and movement as a pair"]
["S80","Perform cover and movement as part of a team"]
["S81","Gather and handle information and intelligence from a variety of sources, to assess threat in line with legislation, policies and guidance to take the appropriate action"]
["S82","Demonstrate competence in the use of Taser"]
["S83","Demonstrate competence in the use of the Launcher"]
["S84","Provide medical aid commensurate with training as required to preserve life"]
["S85","Demonstrate competence in the provision of ballistic first aid"]
[null,"Behaviours"]
["B1","Professional integrity. Maintain the highest standards of professionalism and trustworthiness, making sure that values, moral codes and ethical standards are always upheld, including challenging others where appropriate"]
["B2","Take ownership. Being accountable and taking ownership for own role and responsibilities, whilst being effective and willing to take appropriate, justifiable risks. Notwithstanding this, have the situational awareness to understand own limitations in ability or authority and seek guidance and support when unsure"]
["B3","Emotionally aware. The ability to understand and manage emotion in stressful situations and environments. Understand that the views and beliefs of others, based on culture, background and experiences may not always align with our own, thereby treating people with sensitivity, compassion and warmth"]
["B4"," Innovative and open minded. Constantly look for ways to improve the individual and the organisation. Be outward looking, inquisitive and creative when considering the development and implementation of working practices. Reflect on individual and team performance, acknowledging success and mistakes, and ask how could I do better"]
["B5","Collaborative. Build effective relationships with colleagues and other partners thereby allowing for the sharing of information, skills and knowledge. This mutually beneficial approach will remove boundaries and contribute to the best possible outcomes and results"]
["B6","Support and Inspire. Know how our individual behaviours impact on the organisation and others. By being a supportive role model create the right climate that will inspire others to maintain performance and professional standards thereby contributing to a positive environment"]
["B7","Critically Analyse. Based on knowledge, experiences and information to hand analyse issues or problems to identify solutions or resolution. But acknowledge that on occasion they may need to seek support and guidance or information from other sources to influence decisions of courses of action"]

{"sheet":"ST0878","index":6,"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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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,"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"}]
["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",{"$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"}]
["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,"PARTIAL",{"$f":"IF(J46=1,0.5,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=0.5,\"NONE\",IF(L46=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S11","Share and safeguard information about children and their families in line with data protection law",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},"PARTIAL"]
["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},"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",8]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L65-L66-(L67*0.5)","v":31}]

{"sheet":"ST0930","index":7,"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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote 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 – Where 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 - Provide 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,"PARTIAL",{"$f":"IF(J40=1,0.5,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=0.5,\"NONE\",IF(L40=0,\"PARTIAL\"))","v":"PARTIAL"}]
["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",5]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L59-L60-(L61*0.5)","v":26.5}]

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