{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["GUIDE TO KSB MAPPING","OCC0487","OCC0516","OCC0746","OCC0747","OCC0878","OCC0930","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":"OCC0487","index":1,"n_rows":96,"n_cols":32,"rows_kept":96,"cut":false,"hidden":false,"merged":[[62,0,62,6],[64,0,64,6],[67,0,67,6],[70,0,70,6],[9,0,9,6],[21,0,21,6],[34,0,34,6],[42,0,42,6],[45,0,45,6],[52,0,52,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Specialist rescue operative (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Resubmission 1:\nWhere in the qualification is the relevant content?\n\n","Resubmission 1:\nEvidence\n ","Resubmission 1:\nSupporting Comments/Rationale","Resubmission 1:\nAssessment method","Resubmission 1:\nIM Comment","Resubmission 1:\nIM Moderation","Resubmission 1:\nG7 QA","Resubmission 2:\nWhere in the qualification is the relevant content?\n\n","Resubmission 2:\nEvidence\n ","Resubmission 2:\nSupporting Comments/Rationale","Resubmission 2:\nAssessment method","Resubmission 2\nIM Comment","Resubmission 2:\nIM Moderation","Resubmission 2:\nG7 QA","Conclusion\n"]
[null,"Knowledge"]
["Rescue operations"]
["K1","The importance and reasons for legal and regulatory compliance",null,null,null,null,null,null,{"$f":"IF(C23:C34 = \"FULLY MET\",1,IF(C23:C34 = \"PARTIALLY MET\",0.5,IF(C23:C34 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M23=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K2","An understanding of the importance of following policies, procedures and work instructions. These will include but will not be limited to: health and safely policy including signed statement. The hazard identification and risk assessment process aligned to the ability to implement controls to reduce the risk to an acceptable level",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J24=1,1,IF(J24=0.5,0.5,IF(J24=0,0)))","v":0},{"$f":"IF(L24=1,\"NONE\",IF(L24=0.5,\"PARTIAL\",IF(L24=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M24=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K3","The procedures and processes for responding to and conducting emergency rescue operations.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J25=1,1,IF(J25=0.5,0.5,IF(J25=0,0)))","v":0},{"$f":"IF(L25=1,\"NONE\",IF(L25=0.5,\"PARTIAL\",IF(L25=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M25=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K4","The operational and technical aspects of working at height, confined space entry and specialist rescue operations in underground mines, heights and confined spaces (see sub sector section above).This will require the specialist rescue operative to ensure those entering it are competent. Working at height hazards and a detailed understanding of operations being undertaken at height including and understanding of maintaining safe systems coupled to a backup (fall arrest) requirement.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J26=1,1,IF(J26=0.5,0.5,IF(J26=0,0)))","v":0},{"$f":"IF(L26=1,\"NONE\",IF(L26=0.5,\"PARTIAL\",IF(L26=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M26=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K5","Working at height recovery and retrieval systems.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J27=1,1,IF(J27=0.5,0.5,IF(J27=0,0)))","v":0},{"$f":"IF(L27=1,\"NONE\",IF(L27=0.5,\"PARTIAL\",IF(L27=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M27=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K6","Requirements of suitable and effective anchor point to provide a safe point to commence work or rescue from height.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J28=1,1,IF(J28=0.5,0.5,IF(J28=0,0)))","v":0},{"$f":"IF(L28=1,\"NONE\",IF(L28=0.5,\"PARTIAL\",IF(L28=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M28=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K7","The operations being undertaken within the confined space. This will provide information to the rescue teams as to the likely equipment required to facilitate a successful rescue. This service is required by those entering confined spaces, or other similar space in which there is a reasonably foreseeable specified risk. ",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J29=1,1,IF(J29=0.5,0.5,IF(J29=0,0)))","v":0},{"$f":"IF(L29=1,\"NONE\",IF(L29=0.5,\"PARTIAL\",IF(L29=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M29=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K8","The hazards and risks associated with working at height, confined space and underground environments and how to control them to an acceptable level.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J30=1,1,IF(J30=0.5,0.5,IF(J30=0,0)))","v":0},{"$f":"IF(L30=1,\"NONE\",IF(L30=0.5,\"PARTIAL\",IF(L30=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M30=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K9","The operation of equipment that will be utilised in providing an effective rescue. This will include access and egress equipment, environmental monitors, respiratory protective devices, compressed air escape breathing apparatus, chemical oxygen breathing apparatus, compressed air breathing apparatus, long duration oxygen regenerative (4 hr) breathing apparatus, extraction equipment, advanced first aid, resuscitation equipment, pain relief equipment.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J31=1,1,IF(J31=0.5,0.5,IF(J31=0,0)))","v":0},{"$f":"IF(L31=1,\"NONE\",IF(L31=0.5,\"PARTIAL\",IF(L31=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M31=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K10","The legal and regulatory maintenance and servicing requirements of rescue equipment.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J32=1,1,IF(J32=0.5,0.5,IF(J32=0,0)))","v":0},{"$f":"IF(L32=1,\"NONE\",IF(L32=0.5,\"PARTIAL\",IF(L32=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M32=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K11","How to train others in health and safety requirements to operate in a confined space and in an underground mine.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J33=1,1,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},{"$f":"IF(L33=1,\"NONE\",IF(L33=0.5,\"PARTIAL\",IF(L33=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M33=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K12","An acknowledgement that different people learn in different ways and have the ability to change teaching methods to adapt to this.",null,null,null,null,null,null,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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M34=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["Health and safety"]
["K13","The importance of reporting and evaluation of all potential work hazards and site-specific hazards, including near misses and dangerous occurrences",null,null,null,null,null,null,{"$f":"IF(C36:C42 = \"FULLY MET\",1,IF(C36:C42 = \"PARTIALLY MET\",0.5,IF(C36:C42 = \"NOT MET\",0,)))","v":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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M36=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K14","When it may be necessary not to rescue an injured person",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J37=1,1,IF(J37=0.5,0.5,IF(J37=0,0)))","v":0},{"$f":"IF(L37=1,\"NONE\",IF(L37=0.5,\"PARTIAL\",IF(L37=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M37=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K15","How to fight fires and when not to fight fires",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M38=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K16","How fire spreads and how to fight fires in the underground and confined space environments",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J39=1,1,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=1,\"NONE\",IF(L39=0.5,\"PARTIAL\",IF(L39=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M39=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K17","How to save and preserve an endangered life.",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M40=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K18","How to identify the risks of activities using approved assessment processes, such as research into the history of the confined space or underground mine, hazard identification, risk assessment, control measures to ensure that the level of risk is at an acceptable level. Examples would be knowing how to maintain an atmosphere at an acceptable (safe) level; monitoring a trend of gases within a confined space or underground mine and understanding results; monitoring atmospheric pressure and understanding impact on a confined space and underground mine",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M41=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K19","Risk assessments, legislation, regulations (such as working at height, mines act, confined space, PUWER, first aid, LOLER), safe systems of work, and limits of responsibility.",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M42=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["Effective communications"]
["K20","The reporting lines in both day-to-day and emergency situations.",null,null,null,null,null,null,{"$f":"IF(C44:C45 = \"FULLY MET\",1,IF(C44:C45 = \"PARTIALLY MET\",0.5,IF(C44:C45 = \"NOT MET\",0,)))","v":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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M44=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K21","How to communicate effectively and how to develop and maintain effective working relationships.",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M45=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["Learning and development"]
["K22","Inclusive teaching and learning approaches and how to use them.",null,null,null,null,null,null,{"$f":"IF(C47:C51 = \"FULLY MET\",1,IF(C47:C51 = \"PARTIALLY MET\",0.5,IF(C47:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J47=1,1,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},{"$f":"IF(L47=1,\"NONE\",IF(L47=0.5,\"PARTIAL\",IF(L47=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M47=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K23","Ways to create an inclusive teaching and learning environment",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M48=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K24","Training aids including visual, Aural, Reading, Writing and kinaesthetic",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M49=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K25","Individual learning styles and how to assess them",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M50=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K26","Plan, prepare, deliver and assess training",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M51=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
[null,"Skills"]
["Rescue operations"]
["S1","Operate as part of an effective and efficient rescue team to the required company standards, safe systems of work and current regulations such as Confined Spaces and Mines Regulations.",null,null,null,null,null,null,{"$f":"IF(C54:C62 = \"FULLY MET\",1,IF(C54:C62 = \"PARTIALLY MET\",0.5,IF(C54:C62 = \"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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M54=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S2","Train and assess competence of others in the environments they themselves are deemed competent in. (a mine, a confined space and at height) ",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J55=1,1,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=1,\"NONE\",IF(L55=0.5,\"PARTIAL\",IF(L55=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M55=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S3","Conduct rescue operations in multiple environments and hazardous situations, such as at height, oxygen deficient, toxic and hot atmospheres, and carry out rescues involving casualty entrapment.  Examples would be confined spaces, heights or underground mines with complex entry and exits with various options for ventilating the confined space or underground mine. These complex confined spaces and underground mines would or may have multiple operations being undertaken simultaneously.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J56=1,1,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=1,\"NONE\",IF(L56=0.5,\"PARTIAL\",IF(L56=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M56=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S4","Fight different types of fires in both above ground and underground environments that may contain various gasses and other underground hazards.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J57=1,1,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=1,\"NONE\",IF(L57=0.5,\"PARTIAL\",IF(L57=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M57=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S5","Preserve an endangered life, conduct a rescue if possible.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J58=1,1,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=1,\"NONE\",IF(L58=0.5,\"PARTIAL\",IF(L58=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M58=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S6","Remain calm and objective under pressure.",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M59=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S7","Transport trapped people through an irrespirable atmosphere.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J60=1,1,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=1,\"NONE\",IF(L60=0.5,\"PARTIAL\",IF(L60=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M60=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S8","Transport casualties to a place of safety and further assistance.",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M61=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S9","Fault find, test, maintain and service/re-service all rescue equipment",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J62=1,1,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=1,\"NONE\",IF(L62=0.5,\"PARTIAL\",IF(L62=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M62=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["Sustainability"]
["S10","Minimise the effect of emissions from fire, fumes or other gases in the confined space or underground environment.",null,null,null,null,null,null,{"$f":"IF(C64 = \"FULLY MET\",1,IF(C64 = \"PARTIALLY MET\",0.5,IF(C64 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M64=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["Maintenance techniques"]
["S11","Conduct routine and reactive maintenance of all equipment and breathing apparatus in accordance with company policy, procedures and manufacturers’ specifications.",null,null,null,null,null,null,{"$f":"IF(C66:C67 = \"FULLY MET\",1,IF(C66:C67 = \"PARTIALLY MET\",0.5,IF(C66:C67 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M66=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S12","Use materials, fluids, gases and lubricants required for everyday operations and maintenance in accordance with company policy, procedures, Control of Substances Hazardous to Health data (COSHH) and manufacturers’ specifications",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J67=1,1,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=1,\"NONE\",IF(L67=0.5,\"PARTIAL\",IF(L67=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M67=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["Planning and organising"]
["S13","Plan and arrange equipment and resources and complete required rescue standby tasks in line with company key performance indicators and measures and record progress against them.",null,null,null,null,null,null,{"$f":"IF(C69:C70 = \"FULLY MET\",1,IF(C69:C70 = \"PARTIALLY MET\",0.5,IF(C69:C70 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M69=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S14","Plan the work required, follow the plan and look for and implement improvements in this plan as well as future work plans",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J70=1,1,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=1,\"NONE\",IF(L70=0.5,\"PARTIAL\",IF(L70=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M70=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["Learning and development"]
["S15","Plan inclusive teaching and learning incorporating people learning styles",null,null,null,null,null,null,{"$f":"IF(C72:C75 = \"FULLY MET\",1,IF(C72:C75 = \"PARTIALLY MET\",0.5,IF(C72:C75 = \"NOT MET\",0,)))","v":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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M72=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S16","Deliver inclusive teaching and learning,",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J73=1,1,IF(J73=0.5,0.5,IF(J73=0,0)))","v":0},{"$f":"IF(L73=1,\"NONE\",IF(L73=0.5,\"PARTIAL\",IF(L73=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M73=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S17","Evaluate the delivery of inclusive teaching and learning, modifying delivery where required",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M74=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["S18","Assess learners using a range of methods, against competency requirements and skills matrices",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M75=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
[null,"Behaviours"]
["B1","Assess own level of competence and know when to seek advice from colleagues.",null,null,null,null,null,null,{"$f":"IF(C77:C86=\"FULLY MET\",1,IF(C77:C86=\"PARTIALLY MET\",0.5,IF(C77:C86=\"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J77=1,1,IF(J77=0.5,0.5,IF(J77=0,0)))","v":0},{"$f":"IF(L77=1,\"NONE\",IF(L77=0.5,\"PARTIAL\",IF(L77=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M77=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B2","Actively delegate actions effectively in emergency or hazardous situations",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J78=1,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M78=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B3","Recognise, accept and continue duties when it may have been necessary not to rescue a severely injured person.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J79=1,1,IF(J79=0.5,0.5,IF(J79=0,0)))","v":0},{"$f":"IF(L79=1,\"NONE\",IF(L79=0.5,\"PARTIAL\",IF(L79=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M79=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B4","Critically identify own development needs and take action to meet those needs.",null,null,null,null,null,null,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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M80=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B5","Use own knowledge and expertise to help others.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J81=1,1,IF(J81=0.5,0.5,IF(J81=0,0)))","v":0},{"$f":"IF(L81=1,\"NONE\",IF(L81=0.5,\"PARTIAL\",IF(L81=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M81=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B6","Actively maintain levels of knowledge and skills through continuing professional development, maintain CPD records.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J82=1,1,IF(J82=0.5,0.5,IF(J82=0,0)))","v":0},{"$f":"IF(L82=1,\"NONE\",IF(L82=0.5,\"PARTIAL\",IF(L82=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M82=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B7","Pro-actively communicate with operational team effectively ensuring information is passed clearly and promptly using a range of methods",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J83=1,1,IF(J83=0.5,0.5,IF(J83=0,0)))","v":0},{"$f":"IF(L83=1,\"NONE\",IF(L83=0.5,\"PARTIAL\",IF(L83=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M83=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B8","Accept responsibility for own behaviours, actions and standards of work",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J84=1,1,IF(J84=0.5,0.5,IF(J84=0,0)))","v":0},{"$f":"IF(L84=1,\"NONE\",IF(L84=0.5,\"PARTIAL\",IF(L84=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M84=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B9","Take ownership of issues in an emergency situation and deal with appropriately",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J85=1,1,IF(J85=0.5,0.5,IF(J85=0,0)))","v":0},{"$f":"IF(L85=1,\"NONE\",IF(L85=0.5,\"PARTIAL\",IF(L85=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M85=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["B10","Actively promote a positive health, safety and environmental culture through situational awareness and by personal example, taking appropriate actions if others are acting in an unsafe manner.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J86=1,1,IF(J86=0.5,0.5,IF(J86=0,0)))","v":0},{"$f":"IF(L86=1,\"NONE\",IF(L86=0.5,\"PARTIAL\",IF(L86=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M86=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J87)","v":0},"Net Score",{"$f":"SUM(L23:L87)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J89/L93","v":0},"total CoE KSB coverage",{"$f":"L89/L96","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",54]
[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",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L93-L94-(L95*0.5)","v":54}]

{"sheet":"OCC0516","index":2,"n_rows":61,"n_cols":32,"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","Resubmission 1:\nWhere in the qualification is the relevant content?\n\n","Resubmission 1:\nEvidence\n ","Resubmission 1:\nSupporting Comments/Rationale","Resubmission 1:\nAssessment method","Resubmission 1:\nIM Comment","Resubmission 1:\nIM Moderation","Resubmission 1:\nG7 QA","Resubmission 2:\nWhere in the qualification is the relevant content?\n\n","Resubmission 2:\nEvidence\n ","Resubmission 2:\nSupporting Comments/Rationale","Resubmission 2:\nAssessment method","Resubmission 2\nIM Comment","Resubmission 2:\nIM Moderation","Resubmission 2:\nG7 QA","Conclusion\n"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M22=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M23=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["B2","Logical with a good attention to detail.",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["B5","Agile, able to adjust rapidly and decisively, especially when operating in complex situations.",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["B6","Persistent and resilient; not all intelligence activity will immediately be successful.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["B7","Flexible and understand that there is more than one way of working.",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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[]
[]
[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":"OCC0746","index":3,"n_rows":70,"n_cols":32,"rows_kept":70,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Fire safety inspector (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Resubmission 1:\nWhere in the qualification is the relevant content?\n\n","Resubmission 1:\nEvidence\n ","Resubmission 1:\nSupporting Comments/Rationale","Resubmission 1:\nAssessment method","Resubmission 1:\nIM Comment","Resubmission 1:\nIM Moderation","Resubmission 1:\nG7 QA","Resubmission 2:\nWhere in the qualification is the relevant content?\n\n","Resubmission 2:\nEvidence\n ","Resubmission 2:\nSupporting Comments/Rationale","Resubmission 2:\nAssessment method","Resubmission 2\nIM Comment","Resubmission 2:\nIM Moderation","Resubmission 2:\nG7 QA","Conclusion\n"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M22=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M23=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K3","The role of the Primary Authority",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K5","How to carry out fire safety audits on complex premises",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K6","Different types of premises or environments, the associated risks and management levels",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K8","Fire Risk Assessment processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K9","Safeguarding issues and concerns and the actions to take",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K11","How to initiate and undertake enforcement activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K12","How to work with other agencies to enforce fire safety legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K13","The different types of formal response and the timescales",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K17","The causes and consequences of fires and unwanted fire signals",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S3","Produce fire safety reports, formal and informal correspondence, statutory notices and plans according to organisational policies and procedures",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J43=1,1,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},{"$f":"IF(L43=1,\"NONE\",IF(L43=0.5,\"PARTIAL\",IF(L43=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S4","Identify safeguarding issues, such as hoarding, child sexual exploitation, slavery, vulnerability etc. and take appropriate action in accordance with organisational policies",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S5","Evaluate risk levels for yourself, others and the environment and take appropriate action to ensure health and safety is maintained",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S9","Evaluate fire safety design submissions and fire protection systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["B6","Contributes to achievements of self, others and organisation, by the establishment, maintenance and management of standards of performance",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J58=1,1,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=1,\"NONE\",IF(L58=0.5,\"PARTIAL\",IF(L58=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J60)","v":0},"Net Score",{"$f":"SUM(L22:L60)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J63/L67","v":0},"total CoE KSB coverage",{"$f":"L63/L70","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",37]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L67-L68-(L69*0.5)","v":36.5}]

{"sheet":"OCC0747","index":4,"n_rows":95,"n_cols":32,"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","Resubmission 1:\nWhere in the qualification is the relevant content?\n\n","Resubmission 1:\nEvidence\n ","Resubmission 1:\nSupporting Comments/Rationale","Resubmission 1:\nAssessment method","Resubmission 1:\nIM Comment","Resubmission 1:\nIM Moderation","Resubmission 1:\nG7 QA","Resubmission 2:\nWhere in the qualification is the relevant content?\n\n","Resubmission 2:\nEvidence\n ","Resubmission 2:\nSupporting Comments/Rationale","Resubmission 2:\nAssessment method","Resubmission 2\nIM Comment","Resubmission 2:\nIM Moderation","Resubmission 2:\nG7 QA","Conclusion\n"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M22=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M23=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K5","Understand the different types of evidence (direct, circumstantial, hearsay etc.)",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K7","Understand the principles of RIPA codes of practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K14","Understand the briefing and de-briefing format.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K23","Understand how to obtain, record & present evidence in court during proceedings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S2"," Investigate the points to prove in pursuing an investigation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S7","Apply consideration of the principles of RIPA codes of practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",{"$f":"IF(J62=1,1,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=1,\"NONE\",IF(L62=0.5,\"PARTIAL\",IF(L62=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",{"$f":"IF(J63=1,1,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},{"$f":"IF(L63=1,\"NONE\",IF(L63=0.5,\"PARTIAL\",IF(L63=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S17","Recognise and respond to the varying demands of the witness.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["B2","Take accountability for decisions made and for maintaining own knowledge and skills.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[]
[]
[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":"OCC0878","index":5,"n_rows":68,"n_cols":32,"rows_kept":68,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Youth justice practitioner (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Resubmission 1:\nWhere in the qualification is the relevant content?\n\n","Resubmission 1:\nEvidence\n ","Resubmission 1:\nSupporting Comments/Rationale","Resubmission 1:\nAssessment method","Resubmission 1:\nIM Comment","Resubmission 1:\nIM Moderation","Resubmission 1:\nG7 QA","Resubmission 2:\nWhere in the qualification is the relevant content?\n\n","Resubmission 2:\nEvidence\n ","Resubmission 2:\nSupporting Comments/Rationale","Resubmission 2:\nAssessment method","Resubmission 2\nIM Comment","Resubmission 2:\nIM Moderation","Resubmission 2:\nG7 QA","Conclusion\n"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M22=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M23=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K11","Barriers to children’s effective engagement with youth justice interventions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S3","Promote the physical, emotional and mental health and wellbeing of children in the youth justice system by recognising and building on strengths, identifying need and taking action to protect children where necessary.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J39=1,1,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=1,\"NONE\",IF(L39=0.5,\"PARTIAL\",IF(L39=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S4","Use a range of engagement skills to promote trust, including clarification of role, purpose of intervention and boundaries of authority.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S10","Be an effective social advocate for children and their families",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S11","Share and safeguard information about children and their families in line with data protection law",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S12","identify, assess and meet the needs of children and young people where there are safeguarding concerns",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J48=1,0.5,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=0.5,\"NONE\",IF(L48=0,\"PARTIAL\"))","v":"PARTIAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J58)","v":0},"Net Score",{"$f":"SUM(L22:L58)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J61/L65","v":0},"total CoE KSB coverage",{"$f":"L61/L68","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",35]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",5]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L65-L66-(L67*0.5)","v":32.5}]

{"sheet":"OCC0930","index":6,"n_rows":62,"n_cols":32,"rows_kept":62,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Anti-social behaviour and community safety officer (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Resubmission 1:\nWhere in the qualification is the relevant content?\n\n","Resubmission 1:\nEvidence\n ","Resubmission 1:\nSupporting Comments/Rationale","Resubmission 1:\nAssessment method","Resubmission 1:\nIM Comment","Resubmission 1:\nIM Moderation","Resubmission 1:\nG7 QA","Resubmission 2:\nWhere in the qualification is the relevant content?\n\n","Resubmission 2:\nEvidence\n ","Resubmission 2:\nSupporting Comments/Rationale","Resubmission 2:\nAssessment method","Resubmission 2\nIM Comment","Resubmission 2:\nIM Moderation","Resubmission 2:\nG7 QA","Conclusion\n"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M22=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M23=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K8","ASB case management principles. Investigative methods, interview methodology and techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S4","Make justifiable and appropriate decisions on the information available.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S7","Investigate reports of ASB/community safety thoroughly and systematically to understand and analyse underlying issues. Obtaining appropriate evidence.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J40=1,1,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=1,\"NONE\",IF(L40=0.5,\"PARTIAL\",IF(L40=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S11","Maintain accurate and appropriately-detailed records and information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J52)","v":0},"Net Score",{"$f":"SUM(L22:L52)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J55/L59","v":0},"total CoE KSB coverage",{"$f":"L55/L62","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",29]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L59-L60-(L61*0.5)","v":27}]

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