{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["GUIDE TO KSB MAPPING","ST0108","ST0215","ST0287","ST0393","ST0542","ST0543","ST0597","ST0701","ST0770","ST0786","ST0827","ST0829","ST0873","ST0945","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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 (or F-J for ST0770) 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":"ST0108","index":1,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[9,0,9,6],[29,0,29,6],[33,0,33,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,"Dental Technician (integrated) (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Oral Anatomy - Normal dental/oral anatomy and physiology.",null,null,null,null,null,null,{"$f":"IF(C22:C27 = \"FULLY MET\",1,IF(C22:C27 = \"PARTIALLY MET\",0.5,IF(C22:C27 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Dental devices and combating oral problems - How design of custom-made devices can contribute to restoration of functionality as well as prevention of oral disease/further decline.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Manufacturing Procedures - The procedures used in design and manufacture of custom made devices - dentures, crowns, bridges, orthodontic (including Computer Aided Design (CAD)/ Computer Aided Manufacturing (CAM) & IT Solutions).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Material Selection - The principles regarding the selection and use of materials for use in custom made dental devices.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The Dental Team and Professionalism - The role of Dental Technician and other dental team members in management and leadership, professionalism and communication.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Medical Devices Directive & GDC Guidelines - Compliance with the Medical Devices Directive Council 93/42/EEC (MDD), GDC standards for Dental Team, Scope of practice  http://www.gdc-uk.org/Newsandpublications/Publications/Publications/StudentFtPApril10web_260310[1 ].pdf",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Appropriate Device Selection - Advise the prescribing dentist on appropriate dental devices based on dentist input, while recognising oral limitations and their effect on devices. Evaluate, for individual patients, the need for more complex treatment and seek advice from the dentist or more experienced Dental Technicians as appropriate.",null,null,null,null,null,null,{"$f":"IF(C29 = \"FULLY MET\",1,IF(C29 = \"PARTIALLY MET\",0.5,IF(C29 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J29=1,0.5,IF(J29=0.5,0.5,IF(J29=0,0)))","v":0},{"$f":"IF(L29=0.5,\"NONE\",IF(L29=0,\"PARTIAL\"))","v":"PARTIAL"}]
["Device Manufacture - Design, manufacture, assess, repair, modify and provide biomechanically sound custom-made dental devices in the following three areas:"]
["S2","1. Prosthetic Device Manufacture (Dentures) - Design and manufacture complete and partial removable prosthesis, including the provision of custom made impression trays",null,null,null,null,null,null,{"$f":"IF(C31:C33 = \"FULLY MET\",1,IF(C31:C33 = \"PARTIALLY MET\",0.5,IF(C31:C33 = \"NOT MET\",0,)))","v":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"}]
["S3","2. Conservation Device Manufacture (Crown/Bridge) - Produce models and dies for conservation work. Design and manufacture single metallic and tooth coloured restorations. Create substructures for bridgework and apply tooth coloured materials for permanent restorations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","3. Orthodontic Device Manufacture (Braces) - Produce models for Orthodontic case study purposes and appliance construction. Design and manufacture removable, functional and fixed orthodontic appliances",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["--------"]
["S5","Digital Manufacturing Procedures - Aware of the basic procedures used in design and manufacture of custom made devices (including CAD/CAM & IT Solutions).",null,null,null,null,null,null,{"$f":"IF(C35:C39 = \"FULLY MET\",1,IF(C35:C39 = \"PARTIALLY MET\",0.5,IF(C35:C39 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J35=1,1,IF(J35=0.5,0.5,IF(J35=0,0)))","v":0},{"$f":"IF(L35=1,\"NONE\",IF(L35=0.5,\"PARTIAL\",IF(L35=0,\"FULL\")))","v":"FULL"}]
["S6","Device Assessment - Assess impressions, models and finished devices as well as the fitness for purpose of devices and propose alternatives where necessary, in line with patient prescription, and formally record these decisions as for MDD requirements. Can review and Quality Assure the devices",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J36=1,0.5,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=0.5,\"NONE\",IF(L36=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S7","Implants and attachments - Aware of basic procedures for the use of implants, milling and precision attachments as used with various forms of custom made dental restorations",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"}]
["S8","Communication - Communicate effectively with and about patients, their representatives and the rest of the dental team. Handle complaints effectively and within GDC guidelines.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J38=1,0.5,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=0.5,\"NONE\",IF(L38=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Decontamination & Infection Control - Manage safety, infection control and decontamination risks around the dental laboratory in keeping with current regulations",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,"Behaviours"]
["B1","Continuing Personal Development - Proactive in their own development, willing to commit to lifelong learning by use of a Personal Development Plan (PDP), personal reflection and continuous improvement.",null,null,null,null,null,null,{"$f":"IF(C41:C44 = \"FULLY MET\",1,IF(C41:C44 = \"PARTIALLY MET\",0.5,IF(C41:C44 = \"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"}]
["B2","Ethical/Legal Awareness - Recognise and act within GDC standards, ethical guidance, information governance and relevant laws.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Collaboration - Willing to give and receive feedback effectively and tactfully within the wider dental team; takes responsibility for establishing personal networks with dental professionals, specialists and other relevant individuals and organisations.",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"}]
["B4","Responsibility & Integrity - Ready to take responsibility for integrity of completed work.",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,"Gross score",{"$f":"SUM(J22:J44)","v":0},"Net Score",{"$f":"SUM(L22:L44)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J47/L51","v":0},"total CoE KSB coverage",{"$f":"L47/L54","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",19]
[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":"L51-L52-(L53*0.5)","v":17}]

{"sheet":"ST0215","index":2,"n_rows":105,"n_cols":18,"rows_kept":105,"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,"Assistant Practitioner (Health) (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The legislation, policies, standards, local ways of working and codes of conduct that apply to own role",null,null,null,null,null,null,{"$f":"IF(C22:C57 = \"FULLY MET\",1,IF(C22:C57 = \"PARTIALLY MET\",0.5,IF(C22:C57 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The scope of own practice, limitations of own competence and who to ask for support",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The principles of equality, diversity and inclusion and providing person-centred care and support, including consent, active participation and choice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The principles of a ‘duty of care’, ‘safeguarding’ and ‘protection’ as they apply to adults and children, the signs of harm and abuse and how to reduce the risk of harm and abuse",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The normal ranges expected when taking physiological, technical and psychological measurements and the significance of a variation from the normal range",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The types of assessment relevant to the individual’s physical and mental health and wellbeing and the factors that may influence and impact assessment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The signs that an individual is in pain, distress or discomfort",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The signs of change in an individual’s health and wellbeing, including the indications of when to intervene within the scope of practice and when to escalate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The principles of maintaining nutrition and fluid balance and the signs and symptoms of inadequate nutrition and fluid intake",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Clinical, diagnostic and therapeutic interventions within the scope of own role and the underpinning principles to select equipment and tools in the context of the intervention",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The signs that an individual’s health and well-being is changing as a result of a clinical, diagnostic or therapeutic intervention",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Ways to record and store information securely, including the safe use of technology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The principles of confidentiality, duty of confidence and disclosure",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The frameworks and principles of team working including delegation, accountability and supervision in the workplace",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The structural and strategic environment in which health and social care services operate and how these impact on own role",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Methods of communication to use in the workplace, including how to overcome barriers and challenges",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The benefits of digital solutions for improving communication systems and practices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The meaning of ‘capacity’, the differences between mental illness, dementia and learning disability, and the impact of these conditions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","How to identify and evaluate own learning and development needs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How to use feedback to create a personal development plan",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Models of reflective practices used in health and care and how reflection can be used to improve own practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The principles and styles of leadership in relation to own role and place of work and the relationship between leadership and management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The tools and techniques used to identify learning needs and learning styles",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","The relationship between teaching, coaching and mentoring, and how to evaluate if individuals’ learning needs have been met",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","National and local strategies, priorities, and initiatives for promoting and improving public health",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","The wider determinants of health such as the contribution of social influences, health literacy, individual circumstances, behaviours and lifestyle choices on health and wellbeing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","The principles of risk management and the hazards and risks associated with the scope of own practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","The principles of a duty of candour, and techniques for managing challenging situations, unsafe work practices, addressing comments, compliments, conflict and complaints",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","The principles of infection prevention and control, when and how to select the right personal protective equipment for self and others and how to handle hazardous materials and substances",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","How to move and assist individuals safely and how to move and handle equipment and other objects safely",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Methods and indicators used to measure quality, their application in health and care and how they inform a quality improvement plan",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","The rationale and ethical considerations for undertaking research activity and how to review literature and interrogate the existing evidence base",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Methods for collecting research data and how to interpret and apply findings to own and others’ practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","The structure and function of human body systems and how they relate to and impact on each other",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","The relationship between health and well-being and the principles and philosophy of the biomedical, sociological and psychological models in providing holistic health and care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","The stages and processes of human development and how health and wellbeing needs vary throughout the lifespan",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Work in line with legislation, policies, standards and codes of conduct that apply to own role",null,null,null,null,null,null,{"$f":"IF(C59:C91 = \"FULLY MET\",1,IF(C59:C91 = \"PARTIALLY MET\",0.5,IF(C59:C91 = \"NOT MET\",0,)))","v":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"}]
["S2","Work within the scope of practice, the limits of own knowledge and skills, escalating and reporting to others when needed",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Work in partnership with others to champion safe, equitable, non-discriminatory person-centred care and support for individuals",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J61=1,0.5,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=0.5,\"NONE\",IF(L61=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S4","Promote and maintain the principles of a duty of care, safeguarding and protection, always acting in the best interest of individuals and working across organisations and with other agencies to ensure they do not come to harm",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J62=1,0.5,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},"PARTIAL"]
["S5","Undertake and monitor physiological, technical and psychological measurements using the appropriate equipment and tools within scope of own practice",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"}]
["S6","Select and use the correct equipment and tools to undertake timely assessment of an individual's physical and mental healthcare status within own scope of practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Recognise and respond to an individual in pain, distress or discomfort",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J65=1,0.5,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=0.5,\"NONE\",IF(L65=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S8","Interpret results of assessment in the context of the individual’s health and wellbeing, making appropriate changes or recommendations to the care plan within scope of own practice or escalating in line with local protocol",null,null,null,null,null,null,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"}]
["S9","Support individuals with nutrition and fluids in line with their care needs, taking action as required",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J67=1,0.5,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=0.5,\"NONE\",IF(L67=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S10","Undertake evidence-based clinical, diagnostic or therapeutic interventions delegated by a registered healthcare professional in line with scope of practice, and standard operating procedures",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J68=1,0,IF(J68=0.5,0,IF(J68=0,0)))","v":0},{"$f":"IF(L68=0,\"NONE\")","v":"NONE"}]
["S11","Monitor and review the impact of clinical, diagnostic or therapeutic interventions on an individual’s health and well-being",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J69=1,0,IF(J69=0.5,0,IF(J69=0,0)))","v":0},{"$f":"IF(L69=0,\"NONE\")","v":"NONE"}]
["S12","Record and store information related to individuals securely and in line with local and national policies, including the safe use of technology",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=0.5,\"NONE\",IF(L70=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S13","Report and share information related to individuals securely and in line with local and national policies, maintaining confidentiality",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},"PARTIAL"]
["S14","Delegate work to colleagues in the multi-disciplinary team and engage in supervision",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J72=1,0.5,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},"PARTIAL"]
["S15","Liaise with the multidisciplinary team to prioritise and manage own workload",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},"PARTIAL"]
["S16","Communicate with individuals, their families, carers and health and care professionals using techniques designed to maximise understanding",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J74=1,0.5,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},"PARTIAL"]
["S17","Promote the use of digital solutions to improve communication systems and practices",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"}]
["S18","Recognise and respond to limitations in an individual’s mental capacity",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J76=1,0,IF(J76=0.5,0,IF(J76=0,0)))","v":0},{"$f":"IF(L76=0,\"NONE\")","v":"NONE"}]
["S19","Participate in training and development activities and evaluate the impact of learning on own practice",null,null,null,null,null,null,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"}]
["S20","Seek out and respond to feedback and engage in appraisals",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J78=1,0.5,IF(J78=0.5,0.5,IF(J78=0,0)))","v":0},{"$f":"IF(L78=0.5,\"NONE\",IF(L78=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S21","Reflect on own practice to improve practice",null,null,null,null,null,null,0,null,"NONE"]
["S22","Provide leadership and act as a role model for others within the scope of own role",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J80=1,0.5,IF(J80=0.5,0.5,IF(J80=0,0)))","v":0},{"$f":"IF(L80=0.5,\"NONE\",IF(L80=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S23","Identify learning and development needs of 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"}]
["S24","Teach, coach and mentor others and confirm that learning needs have been met",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Actively seek out and act on opportunities to support individuals to maximise their health and well-being within the scope of the role",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Promote preventative health behaviours and support individuals to make informed choices to improve their health and wellbeing within the scope of the role",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Conduct and record risk assessments relevant to the activity and scope of own practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Uphold the principles of duty of candour, identifying and managing challenging situations, unsafe work practices and addressing comments, compliments, conflict and complaints",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J86=1,0.5,IF(J86=0.5,0.5,IF(J86=0,0)))","v":0},{"$f":"IF(L86=0.5,\"NONE\",IF(L86=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S29","Maintain a safe and healthy working environment for self and others, using techniques for infection prevention and control, including the use of Personal Protective Equipment (PPE) and supporting others to comply with policy and procedures",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J87=1,1,IF(J87=0.5,0.5,IF(J87=0,0)))","v":0},{"$f":"IF(L87=1,\"NONE\",IF(L87=0.5,\"PARTIAL\",IF(L87=0,\"FULL\")))","v":"FULL"}]
["S30","Move and assist individuals, equipment and other items safely",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Participate in and support others in audit and quality improvement activities in the workplace",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J89=1,0.5,IF(J89=0.5,0.5,IF(J89=0,0)))","v":0},{"$f":"IF(L89=0.5,\"NONE\",IF(L89=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S32","Conduct research activity within the scope of own role and act on the findings",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J90=1,1,IF(J90=0.5,0.5,IF(J90=0,0)))","v":0},{"$f":"IF(L90=1,\"NONE\",IF(L90=0.5,\"PARTIAL\",IF(L90=0,\"FULL\")))","v":"FULL"}]
["S33","Identify opportunities to improve quality in the workplace and contribute to local, regional and national quality improvement initiatives",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J91=1,0.5,IF(J91=0.5,0.5,IF(J91=0,0)))","v":0},{"$f":"IF(L91=0.5,\"NONE\",IF(L91=0,\"PARTIAL\"))","v":"PARTIAL"}]
[null,"Behaviours"]
["B1","Treat people with dignity",null,null,null,null,null,null,{"$f":"IF(C93:C95 = \"FULLY MET\",1,IF(C93:C95 = \"PARTIALLY MET\",0.5,IF(C93:C95 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J93=1,1,IF(J93=0.5,0.5,IF(J93=0,0)))","v":0},{"$f":"IF(L93=1,\"NONE\",IF(L93=0.5,\"PARTIAL\",IF(L93=0,\"FULL\")))","v":"FULL"}]
["B2","Show respect and empathy for those you work with",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J94=1,0.5,IF(J94=0.5,0.5,IF(J94=0,0)))","v":0},{"$f":"IF(L94=0.5,\"NONE\",IF(L94=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Be adaptable, reliable and consistent",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J95=1,1,IF(J95=0.5,0.5,IF(J95=0,0)))","v":0},{"$f":"IF(L95=1,\"NONE\",IF(L95=0.5,\"PARTIAL\",IF(L95=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J95)","v":0},"Net Score",{"$f":"SUM(L22:L95)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J98/L102","v":0},"total CoE KSB coverage",{"$f":"L98/L105","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",72]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",15]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L102-L103-(L104*0.5)","v":61.5}]

{"sheet":"ST0287","index":3,"n_rows":76,"n_cols":18,"rows_kept":76,"cut":false,"hidden":false,"merged":[[38,0,38,6],[43,0,43,6],[48,0,48,6],[9,0,9,6],[21,0,21,6],[30,0,30,6],[34,0,34,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,"Associate Ambulance Practitioner (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["Core Knowledge"]
["K1","How the AAP role engages in supporting the organisation in delivering high quality care and meeting its targets.",null,null,null,null,null,null,{"$f":"IF(C23:C30 = \"FULLY MET\",1,IF(C23:C30 = \"PARTIALLY MET\",0.5,IF(C23:C30 = \"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"}]
["K2","How to develop and use a personal & professional development plan including the importance of reflective practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","How to communicate effectively, including writing clear, concise information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The importance of health, safety and dynamic risk assessments. How to report incidents, near misses and follow the correct processes to promote health and safety at work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The organisation’s safeguarding procedures and to protect individuals and groups including referral through the appropriate routes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","How to promote person centred approaches and know how to work and adhere to relevant codes of practice and ethics.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","How to practice and follow information governance by understanding data protection, Caldicott regulations and other legislation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How to follow policies and procedures in relation to infection prevention & control. The importance of treating patients and their carers with privacy & dignity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Moving & Handling, Light Rescue, Extrication & Environmental Safety"]
["K9","How to undertake dynamic risk assessments prior to moving & positioning individuals in accordance with their care plan, as well as using equipment and other items safely.",null,null,null,null,null,null,{"$f":"IF(C32:C34 = \"FULLY MET\",1,IF(C32:C34 = \"PARTIALLY MET\",0.5,IF(C32:C34 = \"NOT MET\",0,)))","v":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"}]
["K10","The Health & Safety at Work Act and related regulations. They will know how to manage their own safety and that of others in a range of environments.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How to perform a range of light rescue and extrication techniques responsibly and in a safe and effective manner. Understand the meaning of Common Law and know what criteria must be met to undertake gaining an entry with good intent.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Assessment & Physiological Measurements, Administration of Medications, Treatment & Intervention, Safe discharging & referrals"]
["K12","How to follow a stepwise and holistic approach to patient assessment by understanding and applying codes of practice and ethics, etc. Understand how to carry out and interpret a range of physiological measurements. Know how to make appropriate changes or recommendations to the treatment plan as directed.",null,null,null,null,null,null,{"$f":"IF(C36:C38 = \"FULLY MET\",1,IF(C36:C38 = \"PARTIALLY MET\",0.5,IF(C36:C38 = \"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"}]
["K13","How to operate under given exemptions, clinical guidelines and will understand their own restrictions of the administration of medications in accordance with the AAP’s scope of practice. They will know how to prepare medications and undertake the relevant safety checks prior to administration.  They will know and understand how to use UK Ambulance Service Clinical Practice Guidelines and other documents to support the AAP role.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How to manage the acute care of service users and others across the age ranges, to include: airway management, intermediate life support, wounds & bleeding, burns & scalds, medical conditions, bones-joints-ligaments-tendons injuries, use of medical gases, babies & children, pregnancy & child birth, hostile & major incidents, substances hazardous to health, care for the elderly, pain management by understanding all SOPs, policies, procedures and guidelines. The necessity of safety netting prior to discharging following organisation’s referral pathways including completion of relevant documentation. Know how to create clear & concise records to support all referrals to all agencies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Mental Health, Mental Capacity, Dementia & Learning Disability, End of Life & Bereavement"]
["K15","The importance of promoting mental health and wellbeing; understand the current Mental Health Act and the roles of other partner agencies.",null,null,null,null,null,null,{"$f":"IF(C40:C43 = \"FULLY MET\",1,IF(C40:C43 = \"PARTIALLY MET\",0.5,IF(C40:C43 = \"NOT MET\",0,)))","v":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"}]
["K16","How to undertake the diagnostic and functional assessment of mental capacity and respond appropriately, acting in the best interest of the service user at all times.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Understand and be able to support those with dementia and learning disabilities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","How to support individuals across the age ranges with an end of life care plan in a compassionate and supportive manner. They will be able to identify and respond to their own and others feelings when dealing with bereavement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Intermediate Life Support & assisting the registered practitioner"]
["K19","How to effectively perform intermediate life support for individuals across the age ranges using appropriate equipment and techniques safely.",null,null,null,null,null,null,{"$f":"IF(C45:C48 = \"FULLY MET\",1,IF(C45:C48 = \"PARTIALLY MET\",0.5,IF(C45:C48 = \"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"}]
["K20","Know what equipment a registered practitioner will need to effectively apply the skill of Intubation, Cannulation, and Fluid Therapy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","How to assist when required within own scope of practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Know what drug therapy is needed by the registered practitioner when dealing with service users in cardiac arrest.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Driving & electronic communication"]
["K23","How to operate a range of electronic devices to communicate effectively with all colleagues internally and externally.",null,null,null,null,null,null,{"$f":"IF(C50:C51 = \"FULLY MET\",1,IF(C50:C51 = \"PARTIALLY MET\",0.5,IF(C50:C51 = \"NOT MET\",0,)))","v":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"}]
["K24","How to prepare a range of vehicles prior to use, operate and drive safely at all times adhering to legislation, Highway Code and policies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Core skills - Engage in organisational effectiveness, and personal & professional development by using & promoting: Effective communication; conflict resolution training; equality & inclusion; implementation of health & safety; safeguarding and protecting individuals and groups; person centred approaches; good practice in information governance; infection prevention & control measures; duty of care and patient’s privacy & dignity.",null,null,null,null,null,null,{"$f":"IF(C53:C59 = \"FULLY MET\",1,IF(C53:C59 = \"PARTIALLY MET\",0.5,IF(C53:C59 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J53=1,0.5,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=0.5,\"NONE\",IF(L53=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Moving & Handling - Undertake risk assessment prior to moving & positioning individuals, using equipment and other items safely.",null,null,null,null,null,null,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"}]
["S3","Assessment & Measurements - Follow a stepwise and holistic approach to patient assessment, undertaking a range of physiological measurements using appropriate equipment in a safe and effective manner.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Assessment and Measurements - Make appropriate changes or recommendations to the treatment plan within their scope of practice, reporting changes where applicable and necessary.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Treatment and Intervention - Manage service users and others across the age ranges - from babies & children to  care for the elderly - within the emergency & urgent care setting, to include: airway, respiratory & circulatory management; wounds & bleeding; burns & scalds; medical conditions; bones-joints-ligaments-tendons injuries; use of medical gases; pregnancy & child birth; hostile & major incidents; substances hazardous to health and pain management.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J57=1,0.5,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=0.5,\"NONE\",IF(L57=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S6","Intermediate Life Support and Assisting the practitioner - Perform intermediate life support for individuals across the age ranges using appropriate equipment and techniques safely and effectively. Assist the practitioner in the skills of Cannulation, Fluids Treatment and Intubation, including the preparation of live saving drugs, using the skills necessary to deliver effective medicines management criteria.",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J58=1,0,IF(J58=0.5,0,IF(J58=0,0)))","v":0},{"$f":"IF(L58=0,\"NONE\")","v":"NONE"}]
["S7","Light rescue and Extrication - Perform a range of light rescue and extrication techniques in a safe and effective manner, using a range of equipment.",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,"Behaviours"]
["B1","Patient centred - Be professional and passionate about the emergency and urgent care services; have a commitment to quality and care for service users and their relatives, a positive attitude in helping to improve patient care/experience, learning from successes and mistakes in line with the NHS Constitution.",null,null,null,null,null,null,{"$f":"IF(C61:C66 = \"FULLY MET\",1,IF(C61:C66 = \"PARTIALLY MET\",0.5,IF(C61:C66 = \"NOT MET\",0,)))","v":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"}]
["B2","Dygnity and respect for all - Show understanding and be respectful of all service users, carers and all those who the AAP come into contact with. The AAP will promote equality of opportunity and celebrate diversity, demonstrating high standards of behaviour and conduct with honesty and openness at all times.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J62=1,0.5,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=0.5,\"NONE\",IF(L62=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Teamwork - Work closely and collaboratively with others of all levels in an open/honest and supportive way, acting in the best interest of the service users and others. Promoting teamwork and taking a genuine interest in those whom we work with, offering support and guidance when it is needed. Inspire each other to work together to create better services.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J63=1,0.5,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},"PARTIAL"]
["B4","Care and compassion - Deliver a first class service which is responsive to individual needs, recognising and celebrating good performance, striving to maintain a positive, safe, caring and compassionate working environment for all. Ensure that compassion is central to the care provided with humanity and kindness.",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},"PARTIAL"]
["B5","Effective communication - Be open and honest with individuals choosing the most appropriate way of communicating, using everyday language, avoiding jargon. Respect confidentiality and personal information about service users and others.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J65=1,0.5,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},"PARTIAL"]
["B6","Competence - Be personally responsible for own learning and development. Engage with advancing technologies, maximising learning opportunities. Encourage and support others in their personal development to increase and maintain high levels of competency.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J66=1,0.5,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},"PARTIAL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J66)","v":0},"Net Score",{"$f":"SUM(L23:L66)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J69/L73","v":0},"total CoE KSB coverage",{"$f":"L69/L76","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",1]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",7]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L73-L74-(L75*0.5)","v":32.5}]

{"sheet":"ST0393","index":4,"n_rows":100,"n_cols":18,"rows_kept":100,"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,"Dairy technologist (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The dairy industry structure. Financial considerations. Ethical business practices.",null,null,null,null,null,null,{"$f":"IF(C22:C55 = \"FULLY MET\",1,IF(C22:C55 = \"PARTIALLY MET\",0.5,IF(C22:C55 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Different teams and functions involved in dairy production. Dairy technologist role. Limits of scope of practice: when to seek input from others and when to escalate.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},"FULL"]
["K3","Good Manufacturing Practice (GMP). Production and operational planning concepts.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Health and safety. Health and Safety at Work Act – responsibilities. Health and safety culture. Control of Substances Hazardous to Health (CoSHH). The Reporting of Injuries, Diseases and Dangerous Occurrences Regulations (RIDDOR). Manual handling. Personal Protective Equipment (PPE). Types of hazards. Risk assessments, mitigation methods, and method statements (safe systems of work).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Principles of food and dairy safety. Allergenic control. Good Hygienic Practice (GHP). Microbiology and food borne illnesses. Biological, physical, allergenic (cross-contamination), and chemical contamination of dairy and related products. Food storage, temperature control and preservation of dairy products. Hygienic design, construction and maintenance of food premises and equipment, and their cleaning and disinfection. Pest control. Personal hygiene and training requirements. Food safety culture. Traceability.",null,null,null,null,null,null,0,null,"NONE",0,{"$f":"IF(L26=1,\"NONE\",IF(L26=0.5,\"PARTIAL\",IF(L26=0,\"FULL\")))","v":"FULL"}]
["K6","Food safety legislation principles: Food Safety Act, Regulation (EC) 852/2004, The General Food Law Regulation (EC) 178/2002, The Food Safety and Hygiene (England) Regulations, The Food Hygiene (Scotland) Regulations, The Food Hygiene (Wales) Regulations, The Food Information to Consumers Regulations (EC)1169/2011, Food Information Regulations, Regulation (EC) No 2073/2005 on Microbiological criteria for foodstuffs, The Weights and Measures (Packaged Goods) Regulations. Sources of information for legislation changes.",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},"FULL"]
["K7","Food safety management control of dairy and related food systems: Hazard Analysis and Critical Control Points (HACCP), Threat Analysis of Critical Control Points (TACCP), and Vulnerability Assessment of Critical Control Points (VACCP).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Principles of dairy chemistry. Chemical properties. Compositional milk and dairy product analysis. Quality testing of milk and dairy products.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Principles of dairy microbiology. Types of micro-organisms and their structure. Cultivation conditions and procedures. Aseptic conditions and Good Laboratory Practice (GLP): organisation and discipline within the laboratory. Hygiene monitoring and auditing. Laboratory analysis techniques. Indicator organisms. Interpretation of microbiological data as an indicator of risk.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Milk and dairy derivatives as raw materials. Primary production. Dairy farming practice. Composition of milk and dairy produce. Additives. Dairy products as an ingredient in other foods and associated allergenic issues. Dairy alternatives (non-milk based ingredients).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Function of quality assurance within the dairy industry. Quality assurance schemes and factors affecting the Quality Management Plan (QMP).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Cleaning, disinfection, and sterilisation. Different techniques: chemical, heat, steam technology and ultraviolet - when they should be used. Components of Clean In Place (CIP). New developments in cleaning technology. Environmental impact of cleaning. Cleaning validation, verification, and optimisation techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Basic physical and hygienic design principles of dairy process engineering: mass and energy balances, modes of thermal transfer, principles of fluid flow, and rheology (deformation and flow of materials - solids and liquids).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Principles of food industry unit operations. Preservation operations. Dairy industry unit operations. Factory service operations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Product development processes: recipe development, specifications, market gap identification, acceptance testing and process design, packaging requirements, and nutrition and organoleptic characteristics.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Milk processing: end-to-end. New concepts in milk processing. By-products.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Cheese and fermented product technology. Cheese and cheese related products. Yogurt and related products. Soured creams and crème fraiche.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Butter and milk fat technology. Butter manufacture. Yellow fat and dairy spread manufacture. Ice cream manufacture. Dairy dessert manufacture.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The chemistry of whey protein. Whey processing techniques and technology.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Leadership and management techniques: influencing, negotiation, and conflict management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Change management principles and techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Project management roles and techniques: planning, prioritising, organising, stakeholder management, and risk management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Problem solving and fault finding: 5 whys, root cause analysis, Failure Mode Effects Analysis (FMEA).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Continuous improvement principles and techniques: Plan-do-check-act (PDCA), Lean, 6 Sigma, and Statistical Process Control (SPC). Lean manufacturing tools. Process mapping.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Data analysis techniques. Data analysis and reporting systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Dairy supply chain: mapping and risk management. World dairy economic drivers. Milk and dairy product supply and demand factors. Food security.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Environmental Protection Act and environmental management systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Measuring environment impact and environmental audit requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Dairy automation and process control. Control systems. Instrumentation. Control theory principles. Machine communications and networking. Integrated control and automation systems. Digital manufacturing. Dairy industry automated processes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Information technology: Management Information Systems (MIS), spreadsheets, presentation, word processing, email, virtual communication and learning platforms. General Data Protection Regulation (GDPR). Cyber security.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Communication techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Report writing techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Workplace training and development techniques: coaching and transfer of knowledge.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Equality, diversity, and inclusion. Unconscious bias.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply food safety management systems.",null,null,null,null,null,null,{"$f":"IF(C57:C79 = \"FULLY MET\",1,IF(C57:C79 = \"PARTIALLY MET\",0.5,IF(C57:C79 = \"NOT MET\",0,)))","v":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"}]
["S2","Apply food and dairy hygiene practice principles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Comply with food safety regulations and procedures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Comply with health and safety regulations, guidelines, and procedures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Comply with environmental regulations, guidelines, and procedures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Apply sustainable working practices. For example, efficient use of resources, waste minimisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Apply quality control processes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Apply extended knowledge of underlying dairy concepts.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Identify, review and evaluate, and select scientific techniques, procedures, and methods in the context of new and different areas of work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Apply scientific techniques, procedures, and methods to undertake tasks.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Apply engineering concepts and principles to analyse dairy performance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Collect data. Analyse, interpret, and evaluate data, scientific and technology information, concepts, and ideas including use of statistical methods.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Apply changes to dairy processing unit operations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Apply problem solving techniques, identifying issues. Propose solutions to problems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Use continuous improvement techniques and make recommendations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Apply project management techniques: planning and prioritising tasks, organising resources, managing stakeholders and risk management.",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},"FULL"]
["S17","Conduct environmental impact assessments.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Develop technical written content. For example, operating procedures, working instructions, and reports.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Communicate with others for example, colleagues, customers, and stakeholders. Use industry terminology where appropriate.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Create and deliver presentations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Negotiate with and influence colleagues or stakeholders; manage conflict.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J77=1,1,IF(J77=0.5,0.5,IF(J77=0,0)))","v":0},"FULL"]
["S22","Use information and digital technology.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Identify training needs. Coach individuals.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Take personal responsibility for and promote food safety and health and safety.",null,null,null,null,null,null,{"$f":"IF(C81:C89 = \"FULLY MET\",1,IF(C81:C89 = \"PARTIALLY MET\",0.5,IF(C81:C89 = \"NOT MET\",0,)))","v":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"}]
["B2","Take personal responsibility for and promote sustainable working practices.",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"}]
["B3","Act in a professional manner.",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},"FULL"]
["B4","Take responsibility for the quality of work and enable others to work to high standards. For example, decisive, self-reliant, and motivated.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Respond and adapt to work demands and situations.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J85=1,0.5,IF(J85=0.5,0.5,IF(J85=0,0)))","v":0},{"$f":"IF(L85=0.5,\"NONE\",IF(L85=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B6","Recognise limitations, seek input from others and escalate issues when required.",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"}]
["B7","Collaborate with others for example, within teams, across disciplines, and external stakeholders, promoting inclusion.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Ambassador for the dairy industry.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Committed to maintaining and enhancing competence of self and others through Continued Professional Development (CPD).",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J89=1,0.5,IF(J89=0.5,0.5,IF(J89=0,0)))","v":0},{"$f":"IF(L89=0.5,\"NONE\",IF(L89=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J89)","v":0},"Net Score",{"$f":"SUM(L22:L89)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J93/L97","v":0},"total CoE KSB coverage",{"$f":"L93/L100","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",66]
[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",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L97-L98-(L99*0.5)","v":65}]

{"sheet":"ST0542","index":5,"n_rows":103,"n_cols":18,"rows_kept":103,"cut":false,"hidden":false,"merged":[[45,0,45,6],[51,0,51,6],[9,0,9,6],[21,0,21,6],[24,0,24,6],[35,0,35,6],[56,0,56,6],[61,0,61,6],[73,0,73,6],[82,0,82,6],[86,0,86,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,"Oral Health Practitioner (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["Care of the individual"]
["K1","How to apply the legislation, policies and local ways of working related to your role What person centred care, valid consent, duty of care, safeguarding, diversity, equality and inclusion mean and why they are important",null,null,null,null,null,null,{"$f":"IF(C23:C24 = \"FULLY MET\",1,IF(C23:C24 = \"PARTIALLY MET\",0.5,IF(C23:C24 = \"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"}]
["K2","Relevant dental oral and craniofacial anatomy and physiology and their application to patient management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Clinical Practice"]
["K3","The range of normal human structures and functions, with particular reference to dental caries, oral medicine, periodontal disease and dental treatment and how this relates to working in the mouth",null,null,null,null,null,null,{"$f":"IF(C26:C35 = \"FULLY MET\",1,IF(C26:C35 = \"PARTIALLY MET\",0.5,IF(C26:C35 = \"NOT MET\",0,)))","v":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"}]
["K4","A range of preventative oral and general health procedures used in your role. How to select techniques according to the individual’s need.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","How to adapt your techniques and solve problems to suit individuals with special requirements, within your area of competence",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","How to maintain a clinical environment. How to control and prevent infection. The x-rays, photos and records you are required to take and keep",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","A range of general health screening activities related to your role and the population you work with eg recognising an abnormality and referring appropriately",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Normal parameters associated with blood pressure and blood sugar levels. How to carry out physiological measurements and what steps to take if results are outside the norm",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","How, why and when to take and process finger-prick blood samples.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Which other services are available in your area, what they provide and how people can access them",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Legislation on prescription-only medicines",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The types of medical emergency that may arise and ways to address them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Community based oral health"]
["K13","General health systems and be able to review their relationship to oral health using high quality evidence such as research documents",null,null,null,null,null,null,{"$f":"IF(C37:C45 = \"FULLY MET\",1,IF(C37:C45 = \"PARTIALLY MET\",0.5,IF(C37:C45 = \"NOT MET\",0,)))","v":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"}]
["K14","How to outline the basic principles of population health, including demographic, social, UK and international oral health trends; a range of common risk factors",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Determinants of health inequalities and how they are measured",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Guidelines for best practice including national and local health initiatives",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The needs of different patient groups you work with across the age range including those who are nervous, have learning disabilities, have mental health conditions or phobias, require palliative care or have cognitive impairment such as dementia",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","How diet, nutrition and hydration link with systemic and oral health including obesity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Ways to encourage self-care and motivation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Behaviour change and the theories that underpin models of learning in individuals and groups to change behaviour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Theories and concepts of motivational interviewing; different ways to support behaviour change according to whether you are working with an individual (e.g. in dental surgery) or with carers (in schools, homes or care homes) or on a group basis",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Communication"]
["K22","A range of methods of communicating with individuals across the age range.",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"}]
["K23","How to check you have been understood.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Barriers to communication and a range of ways to overcome them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","When to refer or escalate if something is outside of your scope of practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","GDC Guidelines for handling complaints",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Professional Development"]
["K27","The principles relating to evidence-based approaches to learning, clinical and professional practice and decision making; including using a range of sources of evidence.",null,null,null,null,null,null,{"$f":"IF(C53:C55 = \"FULLY MET\",1,IF(C53:C55 = \"PARTIALLY MET\",0.5,IF(C53:C55 = \"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"}]
["K28","The consequences of your actions, attitude and behaviour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","How to assess and reflect upon your own capabilities and limitations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["Care of the individual"]
["S1","Put patient’s interests first, maintaining a caring approach towards them",null,null,null,null,null,null,{"$f":"IF(C58:C61 = \"FULLY MET\",1,IF(C58:C61 = \"PARTIALLY MET\",0.5,IF(C58:C61 = \"NOT MET\",0,)))","v":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"}]
["S2","Treat people with dignity, respecting their choices, gaining valid consent for all treatments and respecting confidentiality",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Work autonomously in people’s mouths to take dental bacterial plaque indices and food debris scores",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"}]
["S4","Use a range of personal oral care tools",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"}]
["Clinical Practice"]
["S5","Autonomously plan practice sessions in the community",null,null,null,null,null,null,{"$f":"IF(C63:C73 = \"FULLY MET\",1,IF(C63:C73 = \"PARTIALLY MET\",0.5,IF(C63:C73 = \"NOT MET\",0,)))","v":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"}]
["S6","Prepare the clinical equipment and records for each session",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Prepare and maintain a clinical environment, adhering to infection control and prevention ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Prepare, mix and handle bio-materials",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Take dental bacterial plaque indices and food debris scores in the mouth of individuals",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J67=1,0.5,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=0.5,\"NONE\",IF(L67=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S10","Select preventative strategies that are appropriate to the individual and adapt appropriately for individuals with special requirements",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J68=1,0.5,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},"PARTIAL"]
["S11","Undertake general health screening including checking for diabetes, taking blood pressure readings and taking finger-prick blood for blood tests",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J69=1,0.5,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},"PARTIAL"]
["S12","Refer individuals to other services if necessary",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},"PARTIAL"]
["S13","Apply topical fluoride under prescription in the mouth",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},"PARTIAL"]
["S14","Carry out intra and extra oral photography",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"}]
["S15","Recognise and manage medical emergencies",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"}]
["Community based oral health"]
["S16","Plan clinical preventative session",null,null,null,null,null,null,{"$f":"IF(C75:C82 = \"FULLY MET\",1,IF(C75:C82 = \"PARTIALLY MET\",0.5,IF(C75:C82 = \"NOT MET\",0,)))","v":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"}]
["S17","Deliver brief clinical preventative advice interventions to targeted groups",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Encourage self-care and motivation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Provide oral and general systemic advice e.g. tobacco cessation or diet advice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Prepare, deliver and evaluate oral health messages to groups or individuals",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Support individuals and groups to change their behaviour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Provide motivational interviews",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Determine and implement strategies for improving oral health in the community.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Communication"]
["S24","Communicate effectively with and about patients, their representatives and the dental team, and with carers, other healthcare workers or schoolteachers",null,null,null,null,null,null,{"$f":"IF(C84:C86 = \"FULLY MET\",1,IF(C84:C86 = \"PARTIALLY MET\",0.5,IF(C84:C86 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J84=1,0.5,IF(J84=0.5,0.5,IF(J84=0,0)))","v":0},{"$f":"IF(L84=0.5,\"NONE\",IF(L84=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S25","Escalate any issues when they are outside your scope of practice.",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"}]
["S26","Handle complaints effectively and within GDC guidelines.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Professional Development"]
["S27","Manage your own time, resources and personal behaviour.",null,null,null,null,null,null,{"$f":"IF(C88:C89 = \"FULLY MET\",1,IF(C88:C89 = \"PARTIALLY MET\",0.5,IF(C88:C89 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J88=1,1,IF(J88=0.5,0.5,IF(J88=0,0)))","v":0},{"$f":"IF(L88=1,\"NONE\",IF(L88=0.5,\"PARTIAL\",IF(L88=0,\"FULL\")))","v":"FULL"}]
["S28","Be proactive in your own development, willing to commit to lifelong learning by use of a Personal Development Plan (PDP), personal reflection and continuous improvement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","You will treat people with dignity and respect.",null,null,null,null,null,null,{"$f":"IF(C91:C93 = \"FULLY MET\",1,IF(C91:C93 = \"PARTIALLY MET\",0.5,IF(C91:C93 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J91=1,1,IF(J91=0.5,0.5,IF(J91=0,0)))","v":0},{"$f":"IF(L91=1,\"NONE\",IF(L91=0.5,\"PARTIAL\",IF(L91=0,\"FULL\")))","v":"FULL"}]
["B2","You will work as part of a team, having the courage to challenge areas of concern and working to evidence based best practice.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J92=1,0.5,IF(J92=0.5,0.5,IF(J92=0,0)))","v":0},{"$f":"IF(L92=0.5,\"NONE\",IF(L92=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","You will be reliable and consistent, taking responsibility for the integrity of your own actions and completed work.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J93=1,1,IF(J93=0.5,0.5,IF(J93=0,0)))","v":0},{"$f":"IF(L93=1,\"NONE\",IF(L93=0.5,\"PARTIAL\",IF(L93=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J93)","v":0},"Net Score",{"$f":"SUM(L23:L93)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J96/L100","v":0},"total CoE KSB coverage",{"$f":"L96/L103","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",60]
[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",9]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L100-L101-(L102*0.5)","v":55.5}]

{"sheet":"ST0543","index":6,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":false,"merged":[[46,0,46,6],[9,0,9,6],[21,0,21,6],[36,0,36,6],[81,0,81,6],[53,0,53,6],[56,0,56,6],[67,0,67,6],[76,0,76,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,"Clinical Dental Technician (integrated) (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["Care of the individual"]
["K1","Legislation, policies and local ways of working related to your role",null,null,null,null,null,null,{"$f":"IF(C23:C36 = \"FULLY MET\",1,IF(C23:C36 = \"PARTIALLY MET\",0.5,IF(C23:C36 = \"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"}]
["K2","What valid consent, duty of care, safeguarding, diversity, equality and inclusion mean and why they are important",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The needs of different patient groups including children, adults, older people and those with special needs. ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Basic principles of population health, including demographic, social, UK and international oral health trends, determinants and inequalities of health and how they are measured.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Why it is important to record and store information securely and confidentially",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","How to recognise abnormalities of the oral cavity, holistically and, when appropriate, raise concerns.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The range of normal human structures and functions with particular reference to oral disease and treatment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The potential routes of transmission of infectious agents, mechanisms for prevention of infection, the scientific principles of decontamination and disinfection and relevance to health and safety.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Your role in the replacement of lost teeth.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The principles and practice of patient assessment in regard to dental devices and appliances",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Principles of an evidence-based approach to learning, clinical professional practice and decision-making.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The need for more complex treatment and when to seek appropriate advice from the dentist.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Patient and public safety including relevant regulations for dental radiography",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The types of medical emergency that may arise and ways to address them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Dental Prostheses"]
["K15","Identify appropriate dental devices based on own diagnoses and/or dentist input, while recognising oral limitations and their effect on devices; how to work with the patient to ensure any teeth selected are a suitable colour and design.",null,null,null,null,null,null,{"$f":"IF(C38:C46 = \"FULLY MET\",1,IF(C38:C46 = \"PARTIALLY MET\",0.5,IF(C38:C46 = \"NOT MET\",0,)))","v":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"}]
["K16","Processes for taking impressions including bite registration devices and how to use this information when making up the next stage of denture construction.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How to fit or provide a range of devices and appliances for the oral cavity according to prescription including complete or partial dentures, sports guards and other prescribed dental devices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","How the procedures you use in design and manufacture of custom-made devices; dentures, crowns, bridges, orthodontic (including CAD/ CAM & IT Solutions and the complexity of the denture attachment) influence the clinical relationship the device has with the patient’s mouth and existing teeth. Know and understand the how the use of CAD/CAM, IT solutions and emerging 3D Technology may be of use in appliance planning.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The limitations of your own role in relation to prescribing, fitting and providing dental devices including complete or partial dentures, sports mouth guards and other appliances, including when you can only carry out activities based on a prescription from a dentist.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How design of devices contributes to restoration of functionality and oral health, including the possible biomechanical effects in the mouth caused by selecting and using different materials for custom made dental devices.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Ways to evaluate patients changing requirements and when to seek advice or refer patients to the prescribing dentist",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Quality assurance processes; how to repair or modify a range of dental devices in line with the appropriate Medical Device Directive",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Delivery of oral health care and preventive information to encourage self-care and motivation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Communication"]
["K24","A range of methods of communicating with individuals across the age range including how to check you have been understood, barriers to communication and ways to overcome them.",null,null,null,null,null,null,{"$f":"IF(C48:C53 = \"FULLY MET\",1,IF(C48:C53 = \"PARTIALLY MET\",0.5,IF(C48:C53 = \"NOT MET\",0,)))","v":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"}]
["K25","Your role in communication with patients and wider team, including the importance of confidentiality",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","GDC Guidelines for Handling complaints",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Your role as part of the dental and wider multi-disciplinary team",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Your role in management, education and leadership",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","When to refer or escalate if something is outside of your scope of practice or experience",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Professional Development"]
["K30","Industry standards, guidelines and GDC compliance requirements relating to your role, why it is important to commit to lifelong learning;  how to use a Personal Development Plan and personal reflection as a means of continuous improvement",null,null,null,null,null,null,{"$f":"IF(C55:C55 = \"FULLY MET\",1,IF(C55:C55 = \"PARTIALLY MET\",0.5,IF(C55:C55 = \"NOT MET\",0,)))","v":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,"Skills"]
["Care of the individual"]
["S1","Treat people with dignity, respecting their choices, gaining valid consent for all treatments and respecting confidentiality. ",null,null,null,null,null,null,{"$f":"IF(C58:C67 = \"FULLY MET\",1,IF(C58:C67 = \"PARTIALLY MET\",0.5,IF(C58:C67 = \"NOT MET\",0,)))","v":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"}]
["S2","Put the patients’ interests first when taking clinical decisions, maintaining a caring approach towards them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Take detailed dental, social and medical history and keep full, accurate and contemporaneous patient records.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Carry out clinical examinations within your scope of practice, recognising abnormal oral mucosa(2) and related underlying structures and refer patients, where necessary.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J61=1,0.5,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=0.5,\"NONE\",IF(L61=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Manage safety, infection control and decontamination risks around the clinical environment and the dental laboratory in keeping with current regulations.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S6","Perform effective patient assessment, diagnosis and treatment planning.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S7","Demonstrate effective clinical decision making.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S8","Give appropriate patient advice including patient referrals.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S9","Provide clinical dental care as outlined in a treatment plan or prescription and plan the delivery in the most appropriate way.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S10","Recognise and manage medical emergencies.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["Dental Prostheses"]
["S11","Perform technical and clinical dental procedures for providing removable dental appliances, including assessing the patient’s mouth and tissues, and discussing with them the range of dentures or other removable dental devices that would best meet their needs",null,null,null,null,null,null,{"$f":"IF(C69:C76 = \"FULLY MET\",1,IF(C69:C76 = \"PARTIALLY MET\",0.5,IF(C69:C76 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J69=1,0.5,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=0.5,\"NONE\",IF(L69=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S12","Take the appropriate impressions, ensuring they are fit for purpose",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"}]
["S13","Design, manufacture and fit biomechanically sound complete or partial dentures, devices and appliances for the oral cavity according to prescription",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"}]
["S14","Prescribe, provide or fit complete or partial dentures, sports mouth guards or other dental devices including using the agreed procedures in design and manufacture of custom made devices",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J72=1,0.5,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},"PARTIAL"]
["S15","Advise the prescribing dentist on appropriate dental devices based on dentist input, while recognising oral limitations and their effect on devices. ",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},"PARTIAL"]
["S16","Evaluate the need for more complex treatment and seek advice from the prescribing dentist.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J74=1,0.5,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},"PARTIAL"]
["S17","Review and quality assure the devices from the clinical standpoint, including repairing or modifying custom made clinical dental devices to meet the needs of the patient. ",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J75=1,0.5,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},"PARTIAL"]
["S18","At the final fitting stage ensure that they are fit for purpose and the patient is aware of how to look after not only their dentures or other oral devices but their mouth in general.  ",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},{"$f":"IF(L76=1,\"NONE\",IF(L76=0.5,\"PARTIAL\",IF(L76=0,\"FULL\")))","v":"FULL"}]
["Communication"]
["S19","As the clinician responsible for the patient communicate effectively with and about patients, their representatives and the dental team. ",null,null,null,null,null,null,{"$f":"IF(C78:C81 = \"FULLY MET\",1,IF(C78:C81 = \"PARTIALLY MET\",0.5,IF(C78:C81 = \"NOT MET\",0,)))","v":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"}]
["S20","Handle complaints effectively and within GDC guidelines.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Work as part of team, maintaining networks with colleagues and other professionals. ",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J80=1,0.5,IF(J80=0.5,0.5,IF(J80=0,0)))","v":0},{"$f":"IF(L80=0.5,\"NONE\",IF(L80=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S22","Be willing to give and receive effective and constructive feedback across the dental team.",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"}]
["Professional Development"]
["S23","Manage your own time, resources and personal behaviour including being proactive in your own development",null,null,null,null,null,null,{"$f":"IF(C83:C83 = \"FULLY MET\",1,IF(C83:C83 = \"PARTIALLY MET\",0.5,IF(C83:C83 = \"NOT MET\",0,)))","v":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,"Behaviours"]
["B1","You will treat people with dignity and respect.",null,null,null,null,null,null,{"$f":"IF(C85:C87 = \"FULLY MET\",1,IF(C85:C87 = \"PARTIALLY MET\",0.5,IF(C85:C87 = \"NOT MET\",0,)))","v":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"}]
["B2","You will work as part of a team, having the courage to challenge areas of concern and working to evidence based best practice.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J86=1,0.5,IF(J86=0.5,0.5,IF(J86=0,0)))","v":0},{"$f":"IF(L86=0.5,\"NONE\",IF(L86=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3"," You will be reliable and consistent, taking responsibility for the integrity of your own actions and completed work.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J87=1,1,IF(J87=0.5,0.5,IF(J87=0,0)))","v":0},{"$f":"IF(L87=1,\"NONE\",IF(L87=0.5,\"PARTIAL\",IF(L87=0,\"FULL\")))","v":"FULL"}]
[]
[]
[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":"J90/L94","v":0},"total CoE KSB coverage",{"$f":"L90/L97","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",56]
[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",15]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L94-L95-(L96*0.5)","v":48.5}]

{"sheet":"ST0597","index":7,"n_rows":73,"n_cols":18,"rows_kept":73,"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,"Technician scientist (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Principles of laboratory techniques and scientific experimentation.",null,null,null,null,null,null,{"$f":"IF(C22:C40 = \"FULLY MET\",1,IF(C22:C40 = \"PARTIALLY MET\",0.5,IF(C22:C40 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","How to apply the principles of laboratory techniques and scientific experimentation to contribute to the development of technical projects and the implementation of new processes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Laboratory equipment relevant to the role and the associated maintenance and calibration requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The key principles of scientific investigation relevant to the role (e.g. route cause analysis or out of specification results).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Named and recognised scientific theory appropriate to the workplace and role (e.g. Chemistry, Physics or Life Sciences).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The requirements and significance of reporting results, considering the importance of accuracy, precision, and recognising trends.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Mathematical concepts and techniques relevant to the work role (e.g. basic statistical analysis, relating to sampling and data to evaluate results).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The basic principles and procedures of project management and how to contribute to project plans with other team members (e.g. project timeline & milestones).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Business requirements pertaining to record-keeping, traceability & confidentiality, and quality control systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The internal and external regulatory environment pertinent to the work role and how to comply with regulations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The importance of operating ethically and sustainably, complying with codes of conduct, and the impact of this on business operations, the wider sector, society, and the environment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","How the role impacts on the business and the environment in which it operates (e.g idea creation, innovation, and enterprise).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The importance of consulting reliable sources of information to keep up to date with scientific, role, or sector knowledge and ways to communicate this to team members.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Health and safety and environmental regulations, procedures, documentation, and risk management systems applicable to the role.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Importance of developing soft skills (people and interpersonal) relevant to the role.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Different approaches and methods, for use in the identification, design, development, and implementation of solutions to technical problems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Techniques used to identify and manage stakeholder expectations including compliance with codes of conduct.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The importance and impact of good record keeping.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","How digital technology enables the functionality of the working environment to be adaptable to change.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Identify potential scientific techniques to meet defined objectives.",null,null,null,null,null,null,{"$f":"IF(C42:C56 = \"FULLY MET\",1,IF(C42:C56 = \"PARTIALLY MET\",0.5,IF(C42:C56 = \"NOT MET\",0,)))","v":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"}]
["S2","Review and select appropriate scientific techniques to undertake required tasks (consider risk management, safe working practices, equipment availability, quality standards, the environment, and sustainability).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Source and calibrate specified instrumentation and laboratory equipment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Plan and perform laboratory-based investigations and scientific experimentation using scientific techniques, procedures, and methods relevant to the role.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Systematically obtain information when conducting scientific experiments.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Record and store data in accordance with regulatory requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Contribute to the development or improvement of processes and methodologies and support their implementation into the business as part of a wider team.",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"}]
["S8","Use data analysis tools and software packages to process or produce reliable, accurate data or information.",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"}]
["S9","Interpret scientific data to inform actions or recommendations and escalate where required.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Present the results of scientific work to scientific and non-scientific audiences in written and oral form.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Plan and prioritise own tasks and complete work to schedule whilst maintaining compliance with internal and external requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Contribute to recommendations, improvements, or scientific solutions to meet the requirements of internal or external customers.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Identify, develop or contribute to solutions to technical problems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Collaborate with stakeholders and identify results requiring further investigation or escalation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Keeps up to date with advances in scientific and sector working practices and technologies. Shares best practice across the team.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Acts in a professional and ethical manner (demonstrates reliability, integrity, and respect for confidentiality).",null,null,null,null,null,null,{"$f":"IF(C58:C63 = \"FULLY MET\",1,IF(C58:C63 = \"PARTIALLY MET\",0.5,IF(C58:C63 = \"NOT MET\",0,)))","v":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"}]
["B2","Acts in a way that builds and maintains positive relationships with stakeholders (takes account of the impact of own work on others, internally and externally).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Committed to continuous professional development (handles and responds positively to change, adjusting to different conditions, technologies, situations, and environments).",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"}]
["B4","Committed to adopting safe working practices.",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"}]
["B5","Committed to the adoption of environmentally sustainable working practices.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Resilient under pressure.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J63)","v":0},"Net Score",{"$f":"SUM(L22:L63)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J66/L70","v":0},"total CoE KSB coverage",{"$f":"L66/L73","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",40]
[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",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L70-L71-(L72*0.5)","v":39}]

{"sheet":"ST0701","index":8,"n_rows":116,"n_cols":18,"rows_kept":116,"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,"Orthodontic therapist (integrated) (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The General Dental Council scope of practice, your role as an orthodontic therapist and that of others in the dental team, local clinical guidelines and policies",null,null,null,null,null,null,{"$f":"IF(C22:C68 = \"FULLY MET\",1,IF(C22:C68 = \"PARTIALLY MET\",0.5,IF(C22:C68 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The principles of an evidence-based approach to learning, clinical and professional practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Ways to maintain your professional knowledge and competence",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The principles of clinical decision making and your role in the decision-making process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","What is meant by patient-centred care, the importance of safeguarding and your duty of care, the signs of abuse or neglect including local and national systems and ways to raise concerns where appropriate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The scientific principles of medical ionizing radiation and statutory regulations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Current health and safety policy legislation related to your role as an orthodontic therapist",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The range of contemporary orthodontic treatment options, their impact, outcomes, limitations and risks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The need for an accurate and current patient history, the importance of each component of the patient assessment process and the needs of different patient groups including children, adults, older people or those with special care requirements throughout the patient care process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The importance of an orthodontist’s s prescription",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The cause of malocclusion and its possible impact of a poor bite or malpositioned teeth on medical, psychological and sociological aspects of health.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The potential routes of transmission of infectious agents in dental practice, mechanisms for the prevention of infection, the scientific principles of decontamination and disinfection and their relevance to health and safety",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","A range of communication methods, including verbal and non-verbal, listening skills and be aware of the barriers to communication",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The importance of maintaining confidentiality and protecting all data relating to patients and their treatment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The need to explain and check patients’ and guardians’ understanding of treatments, options, costs and informed consent",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How to manage anxiety or challenging behaviour including relevant behavioural change techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How to manage lines of communication within your team or with wider healthcare professions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The principles of information governance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The use of a range of communication methods and technologies and their appropriate application in support of clinical practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The importance of and the need to maintain accurate and current records in accordance with legal and statutory requirements and best practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","The need to treat all patients equally, with respect and dignity, appreciating the importance of patient and guardian choice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Dental, craniofacial anatomy and physiology relevant to orthodontic therapy, the range of normal human structures and functions and the principles that derive from the biomedical, behavioural and materials sciences as they apply to the practice of orthodontic therapy",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","A range of orthodontic equipment, instruments, materials and appliances such as braces, retainers, headgear, face bows, pliers, archwires, brackets, bands, cements and adhesives including their uses and limitations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","The scientific principles underpinning the use of biomaterials and their limitations with emphasis on those used in dentistry",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Different types of adhesives and cement, when to use them and how to apply or remove them from teeth",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Types of instruments for cleaning and preparing tooth surfaces",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","A range of orthodontic appliances such as fixed and removable braces and retainers, their use and ways to fit them",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Problems associated with orthodontic appliances, how to recognise them and the appropriate action to take",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","How archwires that fit into appliances affect the patient’s mouth, teeth and overall wellbeing and when to change or repair them",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","When and why appliances should be removed in accordance with the prescription",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","The cause of oral disease in relation to dental decay and gum disease and basic facial structure formation with a focus on abnormalities and acute conditions that may arise",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","The significance of changes in patients reported oral health",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","A range of common oral health problems and the need for appropriate follow-up care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","The principles of preventive care and the importance of providing patients with comprehensive and accurate preventive education and instruction",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","The role of health promotion, how health promotion strategies are implemented including demographic and social trends and the principles of planning oral health care for communities to meet needs and demands",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Ways to encourage self-care and motivation, the health risks of poor diet, substance misuse and substances such as tobacco and alcohol on oral and general health",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","The need to monitor and review treatment outcomes including when to seek advice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","The referral process, the management and organisation of local referral networks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","The importance of an appropriate and timely referral",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","The types of medical emergencies that may occur and ways to deal with them",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","The risks around the clinical environment and manage these in a safe and efficient manner complying with current best practice guidelines",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","Your own role in relation to the rest of the dental team and to any trainees or students you may supervise including when to escalate and report",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K43","The importance of appraisal, training and ongoing review including ways to give and receive feedback",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K44","The importance of maintaining your own network of dental professionals, specialists and other stakeholders involved in the care and support of patients",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K45","The wider dental and healthcare system you work in",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K46","A range of reflective models and how to use them in your own practice and in maintaining your own professional development portfolio",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K47","The importance of quality and ways to encourage continual improvement",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Adhere to legal and ethical responsibilities in line with General Dental Council requirements, taking responsibility for the integrity of own actions and completed work recognising the limits of your competence and experience",null,null,null,null,null,null,{"$f":"IF(C70:C103 = \"FULLY MET\",1,IF(C70:C103 = \"PARTIALLY MET\",0.5,IF(C70:C103 = \"NOT MET\",0,)))","v":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"}]
["S2","Identify normal and abnormal facial growth, physical, mental and dental development",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Take a patient medical and social history, checking the patient’s level of experience and expectations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Carry out screening for the orthodontic need for treatment either under the direction of an orthodontist or direct to patients",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"}]
["S5","Recognise the early stages of chronic problems with the soft tissues of the mouth",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"}]
["S6","Recognise urgent care problems related to orthodontic treatment and take appropriate action in line with their scope of practice",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J75=1,0.5,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},{"$f":"IF(L75=0.5,\"NONE\",IF(L75=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S7","Implement and perform effective decontamination and infection control procedures",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},{"$f":"IF(L76=1,\"NONE\",IF(L76=0.5,\"PARTIAL\",IF(L76=0,\"FULL\")))","v":"FULL"}]
["S8","Communicate appropriately, effectively and sensitively",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Maintain patient confidentiality at all times",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Assess and manage patient anxiety, discomfort or challenging behaviour through effective communication, reassurance and relevant behavioural techniques",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J79=1,0.5,IF(J79=0.5,0.5,IF(J79=0,0)))","v":0},{"$f":"IF(L79=0.5,\"NONE\",IF(L79=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S11","Create, update and store contemporaneous patient records",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"}]
["S12","Make effective decisions regarding the care of patients in line with the orthodontist’s treatment plan and in partnership with the patient and their parent/guardian",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J81=1,0.5,IF(J81=0.5,0.5,IF(J81=0,0)))","v":0},{"$f":"IF(L81=0.5,\"NONE\",IF(L81=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S13","Put patients’ interests first and act to protect them",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"}]
["S14","Respect patients’ dignity and choices obtaining and documenting valid consent for all treatments and personal care delivery",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J83=1,0.5,IF(J83=0.5,0.5,IF(J83=0,0)))","v":0},{"$f":"IF(L83=0.5,\"NONE\",IF(L83=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Take impressions or scans of patient’s teeth as prescribed by the referring practitioner",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"}]
["S16","Use impressions or scans of the teeth to produce study models",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Select and use the correct orthodontic equipment, instruments and materials to ensure appropriate and safe orthodontic care of the patient",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Clean and prepare tooth surfaces ready for orthodontic treatment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Undertake a basic orthodontic assessment of a patient’s mouth",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Fit the brackets and wires which make up braces in accordance with the prescription",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J89=1,0.5,IF(J89=0.5,0.5,IF(J89=0,0)))","v":0},{"$f":"IF(L89=0.5,\"NONE\",IF(L89=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S21","Fit, adjust, remove or repair a range of orthodontic appliances that the patient may wear as prescribed by the orthodontist. In the absence of a prescription, be able to make safe removable and fixed appliance components",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J90=1,0.5,IF(J90=0.5,0.5,IF(J90=0,0)))","v":0},"PARTIAL"]
["S22","Make the appliance safe and ensure continuing care is provided as soon as possible",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J91=1,0.5,IF(J91=0.5,0.5,IF(J91=0,0)))","v":0},"PARTIAL"]
["S23","Insert, ligate, remove, trim or repair archwires from appliances under prescription",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J92=1,0.5,IF(J92=0.5,0.5,IF(J92=0,0)))","v":0},"PARTIAL"]
["S24","Remove the brackets and wires which make up appliances and the cement from the tooth surface that has held the bracket to the tooth safely and as prescribed, without causing damage to the tooth surface",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J93=1,0.5,IF(J93=0.5,0.5,IF(J93=0,0)))","v":0},"PARTIAL"]
["S25","Contribute to relevant tests and diagnostic procedures",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J94=1,1,IF(J94=0.5,0.5,IF(J94=0,0)))","v":0},{"$f":"IF(L94=1,\"NONE\",IF(L94=0.5,\"PARTIAL\",IF(L94=0,\"FULL\")))","v":"FULL"}]
["S26","Apply evidence-based oral health advice including toothbrushing, interdental cleaning, care of braces and removable orthodontic appliances, diet and hydration advice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Encourage and support self-care and motivation providing appropriate advice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Recognise and manage patients with acute oral conditions and know the referral process",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J97=1,0.5,IF(J97=0.5,0.5,IF(J97=0,0)))","v":0},{"$f":"IF(L97=0.5,\"NONE\",IF(L97=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S29","Identify where patients’ needs may differ from the treatment plan or prescription and direct patients for advice where appropriate",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J98=1,1,IF(J98=0.5,0.5,IF(J98=0,0)))","v":0},{"$f":"IF(L98=1,\"NONE\",IF(L98=0.5,\"PARTIAL\",IF(L98=0,\"FULL\")))","v":"FULL"}]
["S30","Work with colleagues in a way that is in the patients’ best interests",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Recognise and manage medical emergencies",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J100=1,0.5,IF(J100=0.5,0.5,IF(J100=0,0)))","v":0},{"$f":"IF(L100=0.5,\"NONE\",IF(L100=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S32","Take part in appraisal and ongoing review",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J101=1,1,IF(J101=0.5,0.5,IF(J101=0,0)))","v":0},{"$f":"IF(L101=1,\"NONE\",IF(L101=0.5,\"PARTIAL\",IF(L101=0,\"FULL\")))","v":"FULL"}]
["S33","Co-operate with members of the wider dental or healthcare team, taking responsibility for establishing personal networks",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J102=1,0.5,IF(J102=0.5,0.5,IF(J102=0,0)))","v":0},{"$f":"IF(L102=0.5,\"NONE\",IF(L102=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S34","Reflect on own practice, recognising how reflection can be used to continually improve the quality of patient care and professional development",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J103=1,1,IF(J103=0.5,0.5,IF(J103=0,0)))","v":0},{"$f":"IF(L103=1,\"NONE\",IF(L103=0.5,\"PARTIAL\",IF(L103=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Act in a manner consistent with the GDC standards for the dental team which include communication, professionalism, teamwork and clinical skills",null,null,null,null,null,null,{"$f":"IF(C105:C106 = \"FULLY MET\",1,IF(C105:C106 = \"PARTIALLY MET\",0.5,IF(C105:C106 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J105=1,1,IF(J105=0.5,0.5,IF(J105=0,0)))","v":0},{"$f":"IF(L105=1,\"NONE\",IF(L105=0.5,\"PARTIAL\",IF(L105=0,\"FULL\")))","v":"FULL"}]
["B2","Act in a non-discriminatory manner respecting diversity and upholding the rights, dignity and autonomy of others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J106)","v":0},"Net Score",{"$f":"SUM(L22:L106)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J109/L113","v":0},"total CoE KSB coverage",{"$f":"L109/L116","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",83]
[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",13]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L113-L114-(L115*0.5)","v":76.5}]

{"sheet":"ST0770","index":9,"n_rows":167,"n_cols":21,"rows_kept":167,"cut":false,"hidden":false,"merged":[[133,11,133,15],[145,11,145,15],[157,11,157,15],[9,0,9,9],[10,2,10,4],[18,1,18,4],[21,2,21,4],[121,11,121,15]]}
[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 (this list contain the core KSBs for the Sports Coach occupation, plus the specific KSBs for High Performance Coach, Community Coach and School Coach options).","Included in:",null,null,"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 I) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column H does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Knowledge","Sports Coach (level 4) - High Performance Coach","Sports Coach (level 4) - Community Coach ","Sports Coach (level 4) - School Coach"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","YES","YES","YES","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","YES","YES","YES","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,"Sports coach (level 4)"]
[null,"Three options are available (columns C-E). Please check if the KSB needs to be mapped against the option of your choice. If you map against two or three options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
[]
["KSB","KSB Statement (this list contain the core KSBs for the Sports Coach occupation, plus the specific KSBs for High Performance Coach, Community Coach and School Coach options).","Included in:",null,null,"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 I) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column H does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","Sports Coach (level 4) - High Performance Coach","Sports Coach (level 4) - Community Coach ","Sports Coach (level 4) - School Coach"]
["K1","Coaching philosophies and professional practice that consider key stakeholder needs, sporting contexts and codes","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F24:F66 = \"FULLY MET\",1,IF(F24:F66 = \"PARTIALLY MET\",0.5,IF(F24:F66 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(M24=1,1,IF(M24=0.5,0.5,IF(M24=0,0)))","v":0},{"$f":"IF(O24=1,\"NONE\",IF(O24=0.5,\"PARTIAL\",IF(O24=0,\"FULL\")))","v":"FULL"}]
["K2","Professional development planning methods and self-awareness skills training techniques","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Transformational coaching methods and strategic planning techniques","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Organisational vision, strategies, policies and processes required to ensure legal, ethical, effective and efficient coaching systems. Including current health and safety, safeguarding, data protection and equality laws","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Approaches to organisational workforce structures that underpin best practice and showcase the value of scope within the coaching team","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Coaching team development and deployment techniques aligned to all relevant and current legislation, policy, process, operating standards and scopes of practice","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Coaching service delivery approaches including industry support networks and collaborative, cohesive and competent coaching teams","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Curriculum design methods and coaching pedagogies relevant to the participants unique development needs, the demands of the sport or physical activity and the occupational environment","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Progressive programme design and delivery techniques that prioritises accessibility, duty of care and accelerate whole child/person development and sport specific skill acquisition","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Progressive programme design and delivery techniques that ensure safe practice and support at events and competition and embed learning transfer across situations","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Inclusive coaching techniques that embed human rights, equality laws and conventions to ensure ethical coaching practice","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Chief Medical Officer guidelines, Public Health England agendas, organisational, sport specific and holistic approaches to wellbeing considering stressors relevant to the participants context","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Learning theories and skill acquisition techniques relevant to participant’s unique development needs, the demands of the sport and occupational environment","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Positive learning environment attributes and behaviour management strategies relevant to the participant’s unique development needs, demands of the sport and the occupational environment","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Developments in learning resources including technological advancements and wider industry support mechanisms that maximise engagement, development and performance gains","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Methods to measure the impact of the coaching strategies though analysis of key indicators from participant, coach, coaching team and organisational perception and performance data","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","UK sport and sport specific strategies, global data, trends and contemporary issues in high performance sport, including social, economic, educational and technological influences","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","UK sport guidelines, high-performance sport stakeholders, organisational context, culture, codes, direction and politics that influence coaching processes","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Profiling and enquiry methods designed to measure bio-psycho-social attributes and inform whole person optimisation planning","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Profiling and enquiry methods designed to measure sport specific technical and tactical attributes and inform sustainable development and high-performance goals    ","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Session planning techniques that consider high performance athlete's/player's unique needs, goals and curriculum plans","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Session preparation techniques including resource organisation, event risk assessment and safe operating procedures in line with high performance sport policy","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Session delivery and adaptation techniques that motivate high performance players/athletes through tailored coaching and communication methods for maximum impact","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Session evaluation methods that measure sustainable development and performance gains to shape future plans as part of the continuous enquiry cycle","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Methods to measure the impact of the coaching practice on the national and international positioning of the sport by comparing athlete/player results against national and international benchmarks","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Sport England Professional Workforce Strategies, social change agendas, national trends on national physical activity participation, local data and contemporary influences","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Community initiative or club context, culture, stakeholders, Sport England Coaching Plan, sport specific codes, geographic infrastructure and networks that influence coaching pedagogy and process effectiveness","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Profiling and enquiry methods designed to measure whole child/person development dimensions considering cognitive, social, emotional and physiological capabilities","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Profiling and enquiry methods designed to measure participant motives, behavioural norms, psychomotor skills, technical and tactical awareness in specific sport and physical activity contexts to enable process goals to be agreed  ","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Session planning techniques that consider each participant unique motives, access and development needs, goals and seasonal plans","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Session preparation techniques including resource organisation, event risk assessment and safe operating procedures in line with community organisation health and safety policy","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Session delivery and adaptation techniques including tailored coaching and targeted communication methods for maximum impact on long-term engagement and enrichment","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Session evaluation methods that measure engagement, enrichment and whole child/person development dimensions to shape future plans as part of the continuous enquiry cycle","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Methods to measure the impact of coaching practice on social change associated with access, participation, performance, equality and wellbeing by comparing results against local and national benchmarks","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","National trends in education, the Department for Education strategies, Statutory Guidelines, DfE National Curriculum the Ofsted Education Inspection Framework and the educational paradigm shift","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","School stakeholders, context, category, strategies, culture and codes that influence coaching pedagogy and process effectiveness","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Profiling and enquiry methods designed to measure whole child development dimensions considering cognitive, social, emotional and physiological stages of development","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","Profiling and enquiry methods designed to measure psychomotor, technical and tactical skills in physical activity contexts drawn from the Department for Education National Curriculum and enable physical education targets to be agreed","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","Session planning techniques that consider each child's unique profile, development needs, educational targets, and curriculum plans","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","Session preparation techniques including resource organisation, event risk assessment and safe operating procedures in line with school health and safety policy","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","Session delivery and adaptation techniques that inspire children though tailored coaching and communication methods for maximum impact","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","Session evaluation methods that prioritise children’s mastery of physical education standards, psychomotor skills and whole child development and shape future plans as part of the continuous enquiry cycle","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K43","Methods to measure and evaluate the impact of coaching practice on school standards by comparing children's results against local and national benchmarks","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Influence key stakeholders in the sporting context through own coaching philosophy and professional practice ","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F68:F110 = \"FULLY MET\",1,IF(F68:F110 = \"PARTIALLY MET\",0.5,IF(F68:F110 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(M68=1,0.5,IF(M68=0.5,0.5,IF(M68=0,0)))","v":0},{"$f":"IF(O68=0.5,\"NONE\",IF(O68=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Enhance coaching competencies and inter-intra-personal skills through continued professional development and self-awareness skills training","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M69=1,1,IF(M69=0.5,0.5,IF(M69=0,0)))","v":0},{"$f":"IF(O69=1,\"NONE\",IF(O69=0.5,\"PARTIAL\",IF(O69=0,\"FULL\")))","v":"FULL"}]
["S3","Develop transformational coaching strategies and tactics that consider sector, sport, organisation and participants unique needs","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Comply with legal, ethical, effective and efficient coaching systems that align to the organisational vision, strategies, policies and processes","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M71=1,0.5,IF(M71=0.5,0.5,IF(M71=0,0)))","v":0},{"$f":"IF(O71=0.5,\"NONE\",IF(O71=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Promote the value of the coaching team considering workforce structures and scopes including support staff, coaches, coaching assistants, and volunteers ","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M72=1,0.5,IF(M72=0.5,0.5,IF(M72=0,0)))","v":0},"PARTIAL"]
["S6","Facilitate the development of the coaching team through due diligence, inductions, development and performance monitoring","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M73=1,0.5,IF(M73=0.5,0.5,IF(M73=0,0)))","v":0},"PARTIAL"]
["S7","Deliver effective coaching services through industry support networks and a collaborative, cohesive and competent coaching team","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M74=1,0.5,IF(M74=0.5,0.5,IF(M74=0,0)))","v":0},"PARTIAL"]
["S8","Design high quality curriculum that considers participants’ unique profiles, promotes ownership and informs micro, meso and macro plans as relevant to the sporting context","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M75=1,1,IF(M75=0.5,0.5,IF(M75=0,0)))","v":0},{"$f":"IF(O75=1,\"NONE\",IF(O75=0.5,\"PARTIAL\",IF(O75=0,\"FULL\")))","v":"FULL"}]
["S9","Designs and delivers progressive programmes and selects coaching pedagogies that maximise engagement, whole child/person development and accelerates sustainable skill acquisition","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Delivers safe and effective coaching support to participants in practice, at events or competitions and influences learning and skill transfer across situations","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Embrace each participants uniqueness, their rights and advocates fairness, equality and diversity within the coaching environment","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Promote holistic wellbeing to control/contain stressors experienced by participants in their own context and environment","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Facilitate participant development by applying learning theory and skill acquisition techniques relevant to participants needs, sport specific demands and context","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Facilitate participant development and skill acquisition through positive learning environments and behaviour management strategies","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Facilitate participant development and skill acquisition through technological advancements and wider industry support mechanisms","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Measure the impact of the coaching strategies though analysis of participant, coach, coaching team and organisational perception and performance data","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Proactively responds to global trends, strategies, and contemporary issues in high performance sport to ensure best practice in coaching","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Embrace the high-performance context, culture, organisational direction, and codes to deliver effective coaching processes","YES","NO","NO",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M85=1,0.5,IF(M85=0.5,0.5,IF(M85=0,0)))","v":0},{"$f":"IF(O85=0.5,\"NONE\",IF(O85=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S19","Profile athletes or players to measure bio-psycho-social attributes and inform whole person optimisation ","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M86=1,1,IF(M86=0.5,0.5,IF(M86=0,0)))","v":0},{"$f":"IF(O86=1,\"NONE\",IF(O86=0.5,\"PARTIAL\",IF(O86=0,\"FULL\")))","v":"FULL"}]
["S20","Profile athlete/players to measure sport specific technical and tactical attributes and inform sustainable development and high-performance goals","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Plan sessions that consider high performance athlete's/player's unique needs, goals, curriculum, progressive programmes, practice, and competition schedules","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Prepare for sessions by organising resources, conducting event risk assessment and ensures safe operating procedures in line with high performance sport policy","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Deliver safe, inclusive sessions and makes adaptations in the moment to accelerate development and maximise performance gains through relevant coaching and communication methods","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Evaluate sessions to monitor sustainability of athlete/player development and performance gains to shape future plans as part of the continuous enquiry cycle","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Measure the impact of the coaching practice on the national and international positioning of the sport by comparing athlete or player results against national and international benchmarks","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Proactively responds to sector strategies, social change agendas, national and local trends in physical activity participation and contemporary influences","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Embrace the community category, context, culture, codes, stakeholders and public sector duty to deliver effective coaching pedagogies and processes","NO","YES","NO",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M94=1,0.5,IF(M94=0.5,0.5,IF(M94=0,0)))","v":0},{"$f":"IF(O94=0.5,\"NONE\",IF(O94=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S28","Profile participants to measure whole child/person development dimensions considering cognitive, social, emotional and physiological capabilities","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M95=1,1,IF(M95=0.5,0.5,IF(M95=0,0)))","v":0},{"$f":"IF(O95=1,\"NONE\",IF(O95=0.5,\"PARTIAL\",IF(O95=0,\"FULL\")))","v":"FULL"}]
["S29","Profile participants motives, behavioural norms, psychomotor skills, technical and tactical awareness in community sport and physical activity contexts to enable goals to be agreed","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S30","Plan targeted and accessible sessions that consider each participant's unique motives, development needs, goals and seasonal plans","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Prepare for sessions by organising resources, conducting event risk assessment and ensures safe operating procedures in line with community organisation health and safety policy","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S32","Deliver safe and inclusive and effective sessions and makes adaptations in the moment to engage and enrich participants though tailored coaching and targeted communication methods for maximum impact","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S33","Evaluate sessions to monitor engagement, enrichment and whole child/person development dimensions to shape future plans as part of the continuous enquiry cycle","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S34","Measure the impact of coaching practice on social change associated with access, participation, performance, equality and wellbeing by comparing results against local and national benchmarks","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S35","Proactively responds to national trends in education standards, paradigm shifts, strategies and contemporary influences in school and physical education","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S36","Embrace the school category, context, culture, codes, stakeholders, and statutory guidelines to deliver effective coaching pedagogies and processes","NO","NO","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M103=1,0.5,IF(M103=0.5,0.5,IF(M103=0,0)))","v":0},{"$f":"IF(O103=0.5,\"NONE\",IF(O103=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S37","Profile whole child development dimensions considering cognitive, social, emotional and physiological stages of development","NO","NO","YES",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S38","Profile children's psychomotor, technical and tactical skills in physical activity contexts drawn from the DfE National Curriculum to enable physical education targets to be agreed","NO","NO","YES",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S39","Plan safe, inclusive and effective sessions that consider each child's unique development needs, educational targets and curriculum plans","NO","NO","YES",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S40","Prepare for sessions by organising resources, conducting event risk assessment and ensures safe operating procedures in line with school health and safety policy","NO","NO","YES",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S41","Delivers safe, inclusive and effective sessions and makes necessary adaptations to develop children’s psychomotor skill mastery though tailored coaching and communication methods for maximum impact","NO","NO","YES",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S42","Evaluate sessions to monitor children's mastery of physical education standards, psychomotor skills and whole child development to shape plans as part of the continuous enquiry cycle","NO","NO","YES",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S43","Measure and evaluates the impact of coaching practice on school standards by comparing children's results against local and national benchmarks","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M110=1,1,IF(M110=0.5,0.5,IF(M110=0,0)))","v":0},{"$f":"IF(O110=1,\"NONE\",IF(O110=0.5,\"PARTIAL\",IF(O110=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Advocate: acts as an ambassador for the organisation and sector both internally and externally","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F112:F119 = \"FULLY MET\",1,IF(F112:F119 = \"PARTIALLY MET\",0.5,IF(F112:F119 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(M112=1,0.5,IF(M112=0.5,0.5,IF(M112=0,0)))","v":0},{"$f":"IF(O112=0.5,\"NONE\",IF(O112=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Inspirational: leads by example, acts with integrity, builds trust and demonstrates respect for others","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M113=1,1,IF(M113=0.5,0.5,IF(M113=0,0)))","v":0},{"$f":"IF(O113=1,\"NONE\",IF(O113=0.5,\"PARTIAL\",IF(O113=0,\"FULL\")))","v":"FULL"}]
["B3","Ethical: accepts responsibility and is committed to equality, diversity, human rights and safe practice","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Collaborative: demonstrates awareness of own and others’ working styles and collaborates to achieve positive outcomes","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Motivational: considers participants unique needs and tailors’ solutions to meet their unique needs","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Resilient: adapts when dealing with challenges by maintaining focus, self-control and is flexible to changing work environment and people demands","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M117=1,0.5,IF(M117=0.5,0.5,IF(M117=0,0)))","v":0},{"$f":"IF(O117=0.5,\"NONE\",IF(O117=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B7","Results orientated: influences change by soliciting and acting on feedback to deliver results","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M118=1,1,IF(M118=0.5,0.5,IF(M118=0,0)))","v":0},{"$f":"IF(O118=1,\"NONE\",IF(O118=0.5,\"PARTIAL\",IF(O118=0,\"FULL\")))","v":"FULL"}]
["B8","Innovative: challenges the status quo to foster new ways of thinking and working and to resolve problems. Seeks out opportunities for continuous improvement in participants, the coaching system, services, the organisation and the sector","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M119=1,0.5,IF(M119=0.5,0.5,IF(M119=0,0)))","v":0},{"$f":"IF(O119=0.5,\"NONE\",IF(O119=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Sports Coach (level 4) - High Performance Coach    "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M24:M48, M68:M92, M112:M119)","v":0},"Net Score",{"$f":"SUM(O24:O48, O68:O92, O112:O119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M124/O128","v":0},"total CoE KSB coverage",{"$f":"O124/O131","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O128-O129-(O130*0.5)","v":53.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Sports Coach (level 4) - Community Coach"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M24:M39, M49:M57, M68:M83, M93:M101, M112:M119)","v":0},"Net Score",{"$f":"SUM(O24:O39, O49:O57, O68:O83, O93:O101, O112:O119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M136/O140","v":0},"total CoE KSB coverage",{"$f":"O136/O143","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O140-O141-(O142*0.5)","v":53.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Sports Coach (level 4) - School Coach"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M24:M39, M58:M66, M68:M83, M102:M110, M112:M119)","v":0},"Net Score",{"$f":"SUM(O24:O39, O58:O66, O68:O83, O102:O110, O112:O119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M148/O152","v":0},"total CoE KSB coverage",{"$f":"O148/O155","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O152-O153-(O154*0.5)","v":50.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KBSs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M24:M119)","v":0},"Net Score",{"$f":"SUM(O24:O119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M160/O164","v":0},"total CoE KSB coverage",{"$f":"O160/O167","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O164-O165-(O166*0.5)","v":85.5}]

{"sheet":"ST0786","index":10,"n_rows":103,"n_cols":18,"rows_kept":103,"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,"Associate Continuing Healthcare Practitioner (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Understands the structures and functions of the human body",null,null,null,null,null,null,{"$f":"IF(C22:C54 = \"FULLY MET\",1,IF(C22:C54 = \"PARTIALLY MET\",0.5,IF(C22:C54 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Understand how to support people going through the Continuing Healthcare process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Understand commonly encountered mental, physical, behavioural and cognitive health conditions, medication usage and treatments and and how ill health impacts on the individual and their family",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The principles of infection control",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Understand the principles of Funded-nursing care and Joint packages of care and how the Associate Continuing Healthcare Practitioner can support the planning and assessment of these",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Knows how and when to plan and facilitate referal, discharge or transition of care between professionals, settings or services and what makes up an appropriate care package",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Understands the principles of a primary health need and the difference between health and social care needs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Understand the importance and how to use a range of communication methods and media available to assist with communication",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The range of health and social care contract types used, including Personal Health Budgets and services commissioned to treat and support individuals with ill health, disabilities and social care needs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Knows the principles of healthcare business and financial planning, commissioning and procurement and how this impacts on continuing healthcare services and the numeracy to undertake basic budgetary analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Understand the impact of co-morbidities and the demands of meeting people’s complex health and social care needs when commissioning services",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","How to undertake risk assessment, using a range of commonly used tools, and know when to seek advice to avoid compromising quality and safety of others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Understands the factors which affect vulnerable people and how this can impact on the health and social care needs and the role of safeguarding policy in oversight of their care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Understand the differences between risk aversion and risk management and how to avoid compromising quality of care commissioned but work towards the choices of the individual where safe to do so",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Understand the role and function of the Care Quality Commission for care home, supportive living and home care providers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Understand the importance of Contractual Management in maintaining the quality, sustainability and effectiveness of services and what contractual levers can be used if concerns are identified",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Knows how discriminatory behaviour is exhibited and the impact this can have on individuals and the commissioning function",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Techniques to manage differences of opinion, conflict and difficult conversations between professionals",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Understand the principles of accountability and how this applies to the role of Associate Continuing Healthcare Practitioner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Understands the principles of courage, transparency and the professional duty of candour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Knows how care navigation/social prescribing can be used to address the individual’s needs and support them to move from dependence to more independence",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Understand roles, responsibilities and models of care of all members of the health and social care multidisciplinary team in providing and commissioning care and how the MDT contribute to a lawful assessment for eligibility of Continuing Healthcare",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Understand the principles of effective leadership and supervisory opportunities and roles for a associate continuing healthcare practitioner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Understand the demands of multidisciplinary practice and strategies to develop resilience in self and know how to seek support to help deal with uncertain situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Understand relevant legal, regulatory and governance requirements, policies, and frameworks, including any mandatory reporting duties, to all areas of practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Knows the financial implications that eligibility has and how this can influence demand on the service, behaviours and decisions made",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Knows how to critically appraise and reflect upon knowledge, research and practice and understand how this can be used in practice improve the quality of care and service delivered and commissioned",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","The importance of accurate and timely data collection processes and how this has an impact on local and national assurance mechanisms",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Know how to review individual’s health and social care needs related to breathing, nutrition, bladder and bowel health, skin integrity, mobility, communication, psychological and emotional, cognition, behaviour, symptom control and consciousness",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Understand the challenges of providing safe care for people with complex co-morbidities and complex care needs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Understands methods for dealing with potential conflict situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Recognises the impact of claims companies and solicitors on the appeals process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Understands the roles, responsibilities and functions of the Health and Social care professionals that form a MDT",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","To make appropriate referrals of an individual into the continuing healthcare service via a standard or fast-track referral pathway, using the mandated screening tools as per national policy, rejecting and redirecting any inappropriate referrals",null,null,null,null,null,null,{"$f":"IF(C56:C83 = \"FULLY MET\",1,IF(C56:C83 = \"PARTIALLY MET\",0.5,IF(C56:C83 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J56=1,0.5,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=0.5,\"NONE\",IF(L56=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","To formulate, monitor and reassess person-centred, evidence based health and social care plan, delegated by registered practitioner, ensuring commissioned services maintain optimal independence and health and social care outcomes where possible and continues to meet the needs of the individual",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J57=1,0.5,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=0.5,\"NONE\",IF(L57=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S3","Take appropriate action where change in health or social care need requires screening, referral or further MDT assessment to establish ongoing Continuing Healthcare eligibility",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"}]
["S4","Co-ordinate routine planning and management of referral, discharge or transition of care between professionals, settings or services",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J59=1,0.5,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=0.5,\"NONE\",IF(L59=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Protect health through applying the principles of infection prevention and control",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"}]
["S6","Communicate and provide information in an accessible way that is sensitive and appropriate, using a range of skills and strategies with colleagues and people at all stages of life and with a range of mental, physical, cognitive and behavioural challenges recognising common barriers to communication",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J61=1,0.5,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=0.5,\"NONE\",IF(L61=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S7","Utilise report writing skills to formulate clear and evidence based multidisciplinary team recommendations",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"}]
["S8","Develop, manage and maintain appropriate relationships and rapport with people, their families, carers, colleagues and providers",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J63=1,0.5,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},{"$f":"IF(L63=0.5,\"NONE\",IF(L63=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Facilitate discussions with individuals and their families to set an indicative Personal Health Budget",null,null,null,null,null,null,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"}]
["S10","Identify responsible commissioner for individuals referred into the continuing healthcare service",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Commission a package of care for an individual eligible for continuing healthcare",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J66=1,0.5,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=0.5,\"NONE\",IF(L66=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S12","Manage and prioritise competing demands, prioritising workload based on level of risk",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"}]
["S13","Process referrals in a timely manner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","In a range of settings, recognise where people could be at risk, including from neglect, and take appropriate action to report potential risk for assessment",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J69=1,0.5,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=0.5,\"NONE\",IF(L69=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Commission safe, effective and person-centred health and social care packages for people who have co-morbidities and complex care needs",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},"PARTIAL"]
["S16","Participate in data collection to support service delivery evaluation, audit or assurance activity to identify appropriate quality improvement activities or any gaps within the provider market",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},"PARTIAL"]
["S17","Works within limits of own competence, experience and training, delegating tasks and escalating issues and duties appropriately",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J72=1,0.5,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},"PARTIAL"]
["S18","Act as an advocate for the individual",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"}]
["S19","Use facilitation and co-ordination skills to make best use of the contributions of others across the multidisciplinary team for the purposes of a lawful assessment or review",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"}]
["S20","Apply the principles of effective leadership",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Act as a role model to colleagues, supervising and providing feedback about behaviour and actions of others, motivating them to reflect on and develop their practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Ensure the wellbeing and resilience needs of the team are met and recognise signs of vulnerability in themselves or their colleagues",null,null,null,null,null,null,0,null,"NONE ",0,"FULL"]
["S23","Act in accordance with legislation, national guidance and local policy at all times",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J78=1,0.5,IF(J78=0.5,0.5,IF(J78=0,0)))","v":0},{"$f":"IF(L78=0.5,\"NONE\",IF(L78=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S24","Can proactively engage with the individual or representative to support an amicable and lawful resolution of conflict or disagreement",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"}]
["S25","Identify and collate documents and evidence demonstrating current health and social care need from all professionals involved in the care of the individual, for lawful assessment or review of health and social care need to be undertaken",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J80=1,0.5,IF(J80=0.5,0.5,IF(J80=0,0)))","v":0},{"$f":"IF(L80=0.5,\"NONE\",IF(L80=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S26","Use a range of digital technologies to access, input, share and apply information and data within teams and between agencies",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"}]
["S27","Complete, store and retain accurate and contemporaneous records and data",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","The ability to read, interpret and understand clinical records and notes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Act in a non-discriminatory fashion, treating people with dignity and respecting individual's diversity, beliefs, culture, needs, values, privacy and preferences",null,null,null,null,null,null,{"$f":"IF(C85:C93 = \"FULLY ET\",1,IF(C85:C93 = \"PARTIALLY MET\",0.5,IF(C85:C93 = \"NOT MET\",0,)))","v":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"}]
["B2","Be caring, sensitive and compassionate, nurturing the potential in others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Have the courage to speak up and challenge areas of concern or any discriminatory behaviour, providing honest, accurate and constructive feedback",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J87=1,0.5,IF(J87=0.5,0.5,IF(J87=0,0)))","v":0},{"$f":"IF(L87=0.5,\"NONE\",IF(L87=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B4","Be competent, reliable and committed, using reflection to constantly improve and work to evidence based best practice always working within limits of own competence, experience and training",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J88=1,1,IF(J88=0.5,0.5,IF(J88=0,0)))","v":0},{"$f":"IF(L88=1,\"NONE\",IF(L88=0.5,\"PARTIAL\",IF(L88=0,\"FULL\")))","v":"FULL"}]
["B5","Be adaptable, reliable and consistent, show discretion, resilience and self-awareness and demonstrate leadership",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Communicate in ways that are sensitive and appropriate, considering emotional, psychological, cognitive, language, social and other circumstances",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Constantly works to build the development of a positive associate CHC practitioner-patient relationship as a core element of the role",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J91=1,0.5,IF(J91=0.5,0.5,IF(J91=0,0)))","v":0},{"$f":"IF(L91=0.5,\"NONE\",IF(L91=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B8","Act as an ambassador and promote trust, upholding the reputation and promoting public confidence in the continuing healthcare service",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J92=1,0.5,IF(J92=0.5,0.5,IF(J92=0,0)))","v":0},{"$f":"IF(L92=0.5,\"NONE\",IF(L92=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B9","Demonstrates accountability in practice, engaging proactively in continuing development and training",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J93=1,0.5,IF(J93=0.5,0.5,IF(J93=0,0)))","v":0},{"$f":"IF(L93=0.5,\"NONE\",IF(L93=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J93)","v":0},"Net Score",{"$f":"SUM(L22:L93)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J96/L100","v":0},"total CoE KSB coverage",{"$f":"L96/L103","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",70]
[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",17]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L100-L101-(L102*0.5)","v":61.5}]

{"sheet":"ST0827","index":11,"n_rows":123,"n_cols":18,"rows_kept":123,"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,"Nursing Associate (NMC 2018) (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Understand the Code: Professional standards of practice and behaviour for nurses, midwives and nursing associates (NMC, 2018), and how to fulfill all registration requirements",null,null,null,null,null,null,{"$f":"IF(C22:C64 = \"FULLY MET\",1,IF(C22:C64 = \"PARTIALLY MET\",0.5,IF(C22:C64 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Understand the demands of professional practice and demonstrate how to recognise signs of vulnerability in themselves or their colleagues and the action required to minimise risks to health",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Understand the professional responsibility to adopt a healthy lifestyle to maintain the level of personal fitness and well-being required to meet people’s needs for mental and physical care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Understand the principles of research and how research findings are used to inform evidence-based practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Understand the meaning of resilience and emotional intelligence, and their influence on an individual’s ability to provide care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Understand and apply relevant legal, regulatory and governance requirements, policies, and ethical frameworks, including any mandatory reporting duties, to all areas of practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Understand the importance of courage and transparency and apply the Duty of Candour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Understand how discriminatory behaviour is exhibited",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Understand the aims and principles of health promotion, protection and improvement and the prevention of ill health when engaging with people",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Understand the principles of epidemiology, demography, and genomics and how these may influence health and well-being outcomes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Understand the factors that may lead to inequalities in health outcomes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Understand the importance of early years and childhood experiences and the possible impact on life choices, mental, physical and behavioural health and well-being",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Understand the contribution of social influences, health literacy, individual circumstances, behaviours and lifestyle choices to mental, physical and behavioural health outcomes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Understand the importance of health screening",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Understand human development from conception to death, to enable delivery of person-centred safe and effective care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Understand body systems and homeostasis, human anatomy and physiology, biology, genomics, pharmacology, social and behavioural sciences as applied to delivery of care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Understand commonly encountered mental, physical, behavioural and cognitive health conditions as applied to delivery of care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Understand and apply the principles and processes for making reasonable adjustments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Know how and when to escalate to the appropriate professional for expert help and advice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Know how people’s needs for safety, dignity, privacy, comfort and sleep can be met",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Understand co-morbidities and the demands of meeting people’s holistic needs when prioritising care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Know how to meet people’s needs related to nutrition, hydration and bladder and bowel health",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Know how to meet people’s needs related to mobility, hygiene, oral care, wound care and skin integrity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Know how to support people with commonly encountered symptoms including anxiety, confusion, discomfort and pain",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Know how to deliver sensitive and compassionate end of life care to support people to plan for their end of life",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Understand where and how to seek guidance and support from others to ensure that the best interests of those receiving care are upheld",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Understand the principles of safe and effective administration and optimisation of medicines in accordance with local and national policies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Understand the effects of medicines, allergies, drug sensitivity, side effects, contraindications and adverse reactions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Understand the different ways by which medicines can be prescribed",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Understand the principles of health and safety legislation and regulations and maintain safe work and care environments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Understand how inadequate staffing levels impact on the ability to provide safe care and escalate concerns appropriately",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Understand what constitutes a near miss, a serious adverse event, a critical incident and a major incident",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Understand when to seek appropriate advice to manage a risk and avoid compromising quality of care and health outcomes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Know and understand strategies to develop resilience in self and know how to seek support to help deal with uncertain situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","Understand own role and the roles of all other staff at different levels of experience and seniority in the event of a major incident",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Understand the roles of the different providers of health and care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Understand the challenges of providing safe nursing care for people with complex co-morbidities and complex care needs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","Understand the complexities of providing mental, cognitive, behavioural and physical care needs across a wide range of integrated care settings",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","Understand the principles and processes involved in supporting people and families with a range of care needs to maintain optimal independence and avoid unnecessary interventions and disruptions to their lives",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","Understand own role and contribution when involved in the care of a person who is undergoing discharge or a transition of care between professionals, settings or services",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","Know the roles, responsibilities and scope of practice of different members of the nursing and interdisciplinary team, and own role within it",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","Understand and apply the principles of human factors and environmental factors when working in teams",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K43","Understand the influence of policy and political drivers that impact health and care provision",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Act in accordance with the Code: Professional standards of practice and behaviour for nurses, midwives and nursing associates (NMC, 2018), and fulfil all registration requirements",null,null,null,null,null,null,{"$f":"IF(C66:C109 = \"FULLY MET\",1,IF(C66:C109 = \"PARTIALLY MET\",0.5,IF(C66:C109 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J66=1,0.5,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=0.5,\"NONE\",IF(L66=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Keep complete, clear, accurate and timely records",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"}]
["S3","Recognise and report any factors that may adversely impact safe and effective care provision",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Take responsibility for continuous self-reflection, seeking and responding to support and feedback to develop professional knowledge and skills",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Safely demonstrate evidence-based practice in all skills and procedures required for entry to the register: Standards of proficiency for nursing associates Annex A & B (NMC 2018)",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J70=1,0,IF(J70=0.5,0,IF(J70=0,0)))","v":0},{"$f":"IF(L70=0,\"NONE\")","v":"NONE"}]
["S6","Act as an ambassador for their profession and promote public confidence in health and care services",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J71=1,1,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=1,\"NONE\",IF(L71=0.5,\"PARTIAL\",IF(L71=0,\"FULL\")))","v":"FULL"}]
["S7","Communicate effectively using a range of skills and strategies with colleagues and people at all stages of life and with a range of mental, physical, cognitive and behavioural health challenges",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J72=1,0.5,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=0.5,\"NONE\",IF(L72=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S8","Recognise signs of vulnerability in self or colleagues and the action required to minimise risks to health",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"}]
["S9","Develop, manage and maintain appropriate relationships with people, their families, carers and colleagues",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J74=1,0.5,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=0.5,\"NONE\",IF(L74=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S10","Provide, promote, and where appropriate advocate for, non-discriminatory, person-centred and sensitive care at all times, reflecting on people’s values and beliefs, diverse backgrounds, cultural characteristics, language requirements, needs and preferences, taking account of any need for adjustments",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J75=1,0.5,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},"PARTIAL"]
["S11","Report any situations, behaviours or errors that could result in poor care outcomes",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},{"$f":"IF(L76=1,\"NONE\",IF(L76=0.5,\"PARTIAL\",IF(L76=0,\"FULL\")))","v":"FULL"}]
["S12","Challenge or report discriminatory behaviour",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"}]
["S13","Apply the aims and principles of health promotion, protection and improvement and the prevention of ill health when engaging with people",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"}]
["S14","Promote preventive health behaviours and provide information to support people to make informed choices to improve their mental, physical, behavioural health and wellbeing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Identify people who are eligible for health screening",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Promote health and prevent ill health by understanding the evidence base for immunisation, vaccination and herd immunity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Protect health through understanding and applying the principles of infection prevention and control, including communicable disease surveillance and antimicrobial stewardship and resistance",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J82=1,0.5,IF(J82=0.5,0.5,IF(J82=0,0)))","v":0},{"$f":"IF(L82=0.5,\"NONE\",IF(L82=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S18","Apply knowledge, communication and relationship management skills required to provide people, families and carers with accurate information that meets their needs before, during and after a range of interventions",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"}]
["S19","Recognise when capacity has changed recognise and how a person’s capacity affects their ability to make decisions about their own care and to give or withhold consent",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J84=1,0.5,IF(J84=0.5,0.5,IF(J84=0,0)))","v":0},{"$f":"IF(L84=0.5,\"NONE\",IF(L84=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S20","Recognise people at risk of abuse, self-harm and/or suicidal ideation and the situations that may put them and others at risk",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S21","Monitor the effectiveness of care in partnership with people, families and carers, documenting progress and reporting outcomes",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S22","Take personal responsibility to ensure that relevant information is shared according to local policy and appropriate immediate action is taken to provide adequate safeguarding and that concerns are escalated",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S23","Work in partnership with people, to encourage shared decision making, in order to support individuals, their families and carers to manage their own care when appropriate",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S24","Perform a range of nursing procedures and manage devices, to meet people’s need for safe, effective and person-centred care",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S25","Meet people’s needs for safety, dignity, privacy, comfort and sleep",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S26","Meet people’s needs related to nutrition, hydration and bladder and bowel health",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S27","Meet people’s needs related to mobility, hygiene, oral care, wound care and skin integrity",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S28","Support people with commonly encountered symptoms including anxiety, confusion, discomfort and pain",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S29","Give information and support to people who are dying, their families and the bereaved and provide care to the deceased",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S30","Recognise when a person’s condition has improved or deteriorated by undertaking health monitoring, interpreting, promptly responding, sharing findings and escalating as needed",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S31","Act in line with any end of life decisions and orders, organ and tissue donation protocols, infection protocols, advanced planning decisions, living wills and lasting powers of attorney for health",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S32","Work collaboratively and in partnership with professionals from different agencies in interdisciplinary teams",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S33","Maintain safe work and care environments",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S34","Act in line with local and national organisational frameworks, legislation and regulations to report risks, and implement actions as instructed, following up and escalating as required",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S35","Accurately undertake risk assessments, using contemporary assessment tools",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J100=1,1,IF(J100=0.5,0.5,IF(J100=0,0)))","v":0},{"$f":"IF(L100=1,\"NONE\",IF(L100=0.5,\"PARTIAL\",IF(L100=0,\"FULL\")))","v":"FULL"}]
["S36","Respond to and escalate potential hazards that may affect the safety of people",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J101=1,0.5,IF(J101=0.5,0.5,IF(J101=0,0)))","v":0},{"$f":"IF(L101=0.5,\"NONE\",IF(L101=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S37","Participate in data collection to support audit activity, and contribute to the implementation of quality improvement strategies",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J102=1,0.5,IF(J102=0.5,0.5,IF(J102=0,0)))","v":0},"PARTIAL"]
["S38","Prioritise and manage own workload, and recognise where elements of care can safely be delegated to other colleagues, carers and family members",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J103=1,1,IF(J103=0.5,0.5,IF(J103=0,0)))","v":0},{"$f":"IF(L103=1,\"NONE\",IF(L103=0.5,\"PARTIAL\",IF(L103=0,\"FULL\")))","v":"FULL"}]
["S39","Recognise when people need help to facilitate equitable access to care, support and escalate concerns appropriately",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J104=1,0.5,IF(J104=0.5,0.5,IF(J104=0,0)))","v":0},{"$f":"IF(L104=0.5,\"NONE\",IF(L104=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S40","Support and motivate other members of the care team and interact confidently with them",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J105=1,0.5,IF(J105=0.5,0.5,IF(J105=0,0)))","v":0},"PARTIAL"]
["S41","Monitor and review the quality of care delivered, providing challenge and constructive feedback when an aspect of care has been delegated to others",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J106=1,0.5,IF(J106=0.5,0.5,IF(J106=0,0)))","v":0},"PARTIAL"]
["S42","Support, supervise and act as a role model to nursing associate students, health care support workers and those new to care roles, review the quality of the care they provide, promoting reflection and providing constructive feedback",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J107=1,0.5,IF(J107=0.5,0.5,IF(J107=0,0)))","v":0},"PARTIAL"]
["S43","Contribute to team reflection activities to promote improvements in practice and services",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J108=1,0.5,IF(J108=0.5,0.5,IF(J108=0,0)))","v":0},"PARTIAL"]
["S44","Access, input, and apply information and data using a range of methods including digital technologies, and share appropriately within interdisciplinary teams",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J109=1,1,IF(J109=0.5,0.5,IF(J109=0,0)))","v":0},{"$f":"IF(L109=1,\"NONE\",IF(L109=0.5,\"PARTIAL\",IF(L109=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Treat people with dignity, respecting individual's diversity, beliefs, culture, needs, values, privacy and preferences",null,null,null,null,null,null,{"$f":"IF(C111:C113 = \"FULLY MET\",1,IF(C111:C113 = \"PARTIALLY MET\",0.5,IF(C111:C113 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J111=1,1,IF(J111=0.5,0.5,IF(J111=0,0)))","v":0},{"$f":"IF(L111=1,\"NONE\",IF(L111=0.5,\"PARTIAL\",IF(L111=0,\"FULL\")))","v":"FULL"}]
["B2","Show respect and empathy for those you work with, have the courage to challenge areas of concern and work to evidence based best practice",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J112=1,0.5,IF(J112=0.5,0.5,IF(J112=0,0)))","v":0},{"$f":"IF(L112=0.5,\"NONE\",IF(L112=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Be adaptable, reliable and consistent, show discretion, resilience and self-awareness",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J113=1,1,IF(J113=0.5,0.5,IF(J113=0,0)))","v":0},{"$f":"IF(L113=1,\"NONE\",IF(L113=0.5,\"PARTIAL\",IF(L113=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J113)","v":0},"Net Score",{"$f":"SUM(L22:L113)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J116/L120","v":0},"total CoE KSB coverage",{"$f":"L116/L123","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",90]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",30]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L120-L121-(L122*0.5)","v":74}]

{"sheet":"ST0829","index":12,"n_rows":86,"n_cols":18,"rows_kept":86,"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,"Health Play Specialist (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The Code of professional conduct and standards of practice and behaviour for registered health play specialist (HPSET, 2019), and how to fulfil all registration requirements",null,null,null,null,null,null,{"$f":"IF(C22:C40 = \"FULLY MET\",1,IF(C22:C40 = \"PARTIALLY MET\",0.5,IF(C22:C40 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The professional responsibility to adopt a healthy lifestyle to maintain the level of personal fitness and well-being required to meet people’s needs for mental and physical care through play",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The relevant legal, regulatory and governance requirements, policies, and ethical frameworks, including any mandatory reporting duties, to all areas of practice Take personal responsibility to ensure that relevant information is shared according to local policy and appropriate immediate action is taken to provide adequate safeguarding and that concerns are escalated e.g people at risk of abuse, self-harm and/or suicidal ideation and the situations that may put them and others at risk",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The meaning of resilience and emotional intelligence, and their influence on an individual’s ability to provide play",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The established principles for working with sick children, young people and their families",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The Child development theory and research related to specialised play and recreation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The best practice in health play, based on current theoretical, legal and local policies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How discriminatory behaviour is exhibited",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The principles and processes for making reasonable adjustments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The principles of research and how research findings are used to inform evidence-based practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The principles of health and safety legislation and regulations and maintain safe work and care environments by undertaking risk assessments as per organisational policy",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The importance of early years and childhood experiences and the possible impact on life choices, mental, physical and behavioural health and well-being",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The contribution of social influences, health literacy, individual circumstances, behaviours and lifestyle choices to mental, physical and behavioural health outcomes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How and when to escalate to the appropriate professional for expert help and advice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Where and how to seek guidance and support from others to ensure that the best interests of those receiving play are upheld, know and understand strategies to develop resilience in self and know how to seek support to help deal with uncertain situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Own role and the roles of all other staff at different levels of experience and seniority",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The roles of the different providers of health and care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The principles of human factors and environmental factors when working in teams",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The influence of policy and political drivers that impact health and care provision",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Act in accordance with the Code: Professional standards of practice and behaviour for registered health play specialist (HPSET, 2019), and fulfil all registration requirements",null,null,null,null,null,null,{"$f":"IF(C42:C72 = \"FULLY MET\",1,IF(C42:C72 = \"PARTIALLY MET\",0.5,IF(C42:C72 = \"NOT MET\",0,)))","v":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"}]
["S2","Keep complete, clear, accurate and timely records",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"}]
["S3","Recognise and report any factors that may adversely impact safe and effective play provision",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Take responsibility for continuous self-reflection, seeking and responding to support and feedback to develop professional knowledge and skills",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Safely demonstrate evidence-based practice in all skills and procedures required for entry to the register: (HPSET, 2019)",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J46=1,0.5,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=0.5,\"NONE\",IF(L46=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S6","Act as an ambassador for their profession and promote public confidence in health play services",null,null,null,null,null,null,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"}]
["S7","Knows a range of communication skills and strategies and how and when to apply the method most suitable to the situation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Recognise signs of vulnerability in self or colleagues and the action required to minimise risks to health",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J49=1,0.5,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=0.5,\"NONE\",IF(L49=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Develop, manage and maintain appropriate relationships with people, their families, carers and colleagues",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"}]
["S10","Provide, promote, and where appropriate advocate for, non-discriminatory, person-centred and sensitive play at all times, reflecting on people’s values and beliefs, diverse backgrounds, cultural characteristics, language requirements, needs and preferences, taking account of any need for adjustments",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J51=1,0.5,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=0.5,\"NONE\",IF(L51=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S11","Report any situations, behaviours or errors that could result in poor outcomes",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J52=1,1,IF(J52=0.5,0.5,IF(J52=0,0)))","v":0},{"$f":"IF(L52=1,\"NONE\",IF(L52=0.5,\"PARTIAL\",IF(L52=0,\"FULL\")))","v":"FULL"}]
["S12","Challenge or report discriminatory behaviour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Promote behaviours and provide information to support children, young people and their families to make informed choices to improve their mental, physical, behavioural health and wellbeing through play strategies",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J54=1,0.5,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=0.5,\"NONE\",IF(L54=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S14","Apply knowledge, communication and relationship management skills required to provide children, young people, families and carers with accurate information that meets their needs before, during and after a range of play interventions",null,null,null,null,null,null,0,null,"PARTIAL",0,{"$f":"IF(L55=0.5,\"NONE\",IF(L55=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Recognise when capacity has changed and how a person’s capacity affects their ability to make decisions about their own care and to give or withhold consent",null,null,null,null,null,null,0,null,"PARTIAL",0,{"$f":"IF(L56=0.5,\"NONE\",IF(L56=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S16","Recognise people at risk of abuse, self-harm and/or suicidal ideation and the situations that may put them and others at risk",null,null,null,null,null,null,0,null,"PARTIAL",0,{"$f":"IF(L57=0.5,\"NONE\",IF(L57=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S17","Monitor the effectiveness of play in partnership with children young people, families and carers, documenting progress and reporting outcomes",null,null,null,null,null,null,0,null,"PARTIAL",0,{"$f":"IF(L58=0.5,\"NONE\",IF(L58=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S18","Take personal responsibility to ensure that relevant information is shared according to local policy and appropriate immediate action is taken to provide adequate safeguarding and that concerns are escalated",null,null,null,null,null,null,0,null,"PARTIAL",0,{"$f":"IF(L59=0.5,\"NONE\",IF(L59=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S19","Work in partnership with other professionals, to encourage shared decision making, in order to support individuals",null,null,null,null,null,null,0,null,"PARTIAL",0,{"$f":"IF(L60=0.5,\"NONE\",IF(L60=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S20","Meet children and young people’s needs for safety, dignity, privacy, comfort and play",null,null,null,null,null,null,0,null,"PARTIAL",0,{"$f":"IF(L61=0.5,\"NONE\",IF(L61=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S21","Support people with commonly encountered symptoms including anxiety, confusion, discomfort and pain",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J62=1,0,IF(J62=0.5,0,IF(J62=0,0)))","v":0},{"$f":"IF(L62=0,\"NONE\")","v":"NONE"}]
["S22","Work collaboratively and in partnership with professionals from different agencies in interdisciplinary teams",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J63=1,0.5,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},{"$f":"IF(L63=0.5,\"NONE\",IF(L63=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S23","Maintain safe work and play environments",null,null,null,null,null,null,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"}]
["S24","Act in line with local and national organisational frameworks, legislation and regulations to report risks, and implement actions as instructed, following up and escalating as required",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J65=1,0.5,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=0.5,\"NONE\",IF(L65=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S25","Accurately undertake risk assessments, using contemporary assessment tools as per organisation policy and procedures",null,null,null,null,null,null,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"}]
["S26","Respond to and escalate potential hazards that may affect the safety of Child, young people and adults",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J67=1,0.5,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=0.5,\"NONE\",IF(L67=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S27","Participate in data collection to support audit activity, and contribute to the implementation of quality improvement strategies",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J68=1,0.5,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=0.5,\"NONE\",IF(L68=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S28","Prioritise and manage own workload, and recognise where elements of care can safely be delegated to other colleagues, carers and family members",null,null,null,null,null,null,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"}]
["S29","Support, supervise and act as a role model to health play specialist students and members of other professional teams and those new to care roles, review the quality of the play they provide, promoting reflection and providing constructive feedback",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=0.5,\"NONE\",IF(L70=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S30","Contribute to team reflection activities to promote improvements in practice and services",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J71=1,1,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=1,\"NONE\",IF(L71=0.5,\"PARTIAL\",IF(L71=0,\"FULL\")))","v":"FULL"}]
["S31","Access, input, and apply information and data using a range of methods including digital technologies, and share appropriately within interdisciplinary team",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Treat people with dignity, respecting individual's diversity, beliefs, culture, needs, values, privacy and preferences",null,null,null,null,null,null,{"$f":"IF(C74:C76 = \"FULLY MET\",1,IF(C74:C76 = \"PARTIALLY MET\",0.5,IF(C74:C76 = \"NOT MET\",0,)))","v":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"}]
["B2","Show respect and empathy for those you work with, have the courage to challenge areas of concern and work to evidence based best practice",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J75=1,0.5,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},{"$f":"IF(L75=0.5,\"NONE\",IF(L75=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Be adaptable, reliable and consistent, show discretion, resilience and self-awareness",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},{"$f":"IF(L76=1,\"NONE\",IF(L76=0.5,\"PARTIAL\",IF(L76=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J76)","v":0},"Net Score",{"$f":"SUM(L22:L76)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J79/L83","v":0},"total CoE KSB coverage",{"$f":"L79/L86","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",53]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",19]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L83-L84-(L85*0.5)","v":42.5}]

{"sheet":"ST0873","index":13,"n_rows":80,"n_cols":18,"rows_kept":80,"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,"Hygiene Specialist (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Relevant national and international industry legislation and codes of practice, including Health and Safety at Work Act, Control of Substances Hazardous to Health (COSHH), employment, product, chemical and environmental legislation",null,null,null,null,null,null,{"$f":"IF(C22:C42 = \"FULLY MET\",1,IF(C22:C42 = \"PARTIALLY MET\",0.5,IF(C22:C42 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Hygiene methodology considering materials of construction (premises and equipment), types of contamination, environment and water chemistry",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Chemical hygiene practices: the science of chemicals and the impact of the selection of chemicals",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Alternative hygiene practices e.g. the use of ozone, steam, carbon dioxide",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Hygienic design principles of premises and equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Hazard control associated with the hygiene process, e.g. allergens, microbiological, chemical, physical and speciation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Design of effective hygiene management systems, including method statements, risk assessments, safe systems of work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How to plan and organise resources, e.g. people, timescales, equipment, materials, costs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Pest control – knowledge of types of pests, controls, prevention and pest control documentation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Contract management – management of costs, overview of contracts, specifications, service level agreements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","People management – selecting, leading, managing, coaching, developing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Types and application of environmental sampling e.g. adenosine triphosphate (ATP), swabs, air sampling",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Validation, verification and monitoring techniques of hygiene processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How to deal appropriately with incidents and accidents including disaster recovery and critical incidents.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Effluent treatment, drainage and discharge – volume, concentration, chemical composition",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The principles of project management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The principles and tools of continuous improvement, including LEAN, 8 Wastes, Kaizen, 5S, Six Sigma, route cause analysis",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The principles of auditing practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Management information systems, the systems utilised by the organisation – how to analyse data and identify trends",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How to sustainably manage and reduce waste",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Budget management tools and techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Comply with relevant industry legislation, permits, codes of practice and safe working practices",null,null,null,null,null,null,{"$f":"IF(C44:C61 = \"FULLY MET\",1,IF(C44:C61 = \"PARTIALLY MET\",0.5,IF(C44:C61 = \"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"}]
["S2","Select and apply the most appropriate and effective hygiene methodology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Contribute to the design of new, and the modification of, existing premises and equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Contribute to the identification and implementation of controls to minimise the risk of hazards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Create and maintain a hygiene management system including hygiene related documentation, method statements, risk assessments, safe systems of work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Plan, organise, prioritise time and resources effectively to maintain organisational hygiene standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Manage an integrated pest management system",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Review and manage contracts, costs, specifications, service level agreements and appropriate supplier controls; assess supplier, contractor and vendor performance",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J51=1,0.5,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=0.5,\"NONE\",IF(L51=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Lead, manage and develop individuals and cross-functional teams",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J52=1,0.5,IF(J52=0.5,0.5,IF(J52=0,0)))","v":0},{"$f":"IF(L52=0.5,\"NONE\",IF(L52=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S10","Select and carry out the most appropriate sampling methodology",null,null,null,null,null,null,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"}]
["S11","Implement validation, verification and monitoring activities to evaluate the effectiveness of organisational hygiene standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Deal appropriately with incidents and accidents and suggest recommendations to prevent reoccurence",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J55=1,0.5,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=0.5,\"NONE\",IF(L55=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S13","Use project management tools to deliver projects to time, cost, specification and quality",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"}]
["S14","Contribute and lead hygiene continuous improvement activities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Establish and implement the audit schedule in relation to hygiene activities to ensure compliance with legal, industry and customer standards; conduct internal and external audits across functions",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"}]
["S16","Analyse and evaluate information and data to make informed decisions and present solutions; create and formulate spreadsheets and graphs, electronic filing systems, presentations, reports; utilising electronic communications",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"}]
["S17","Manage the waste streams and identify methods of waste reduction",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Agree and manage hygiene budgets; monitor forecasts versus actual costs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Positive attitude: accepts responsibility, is proactive and plans work, tenacious in approach, committed to equality and diversity, and demonstrates a safety mind-set",null,null,null,null,null,null,{"$f":"IF(C63:C70 = \"FULLY MET\",1,IF(C63:C70 = \"PARTIALLY MET\",0.5,IF(C63:C70 = \"NOT MET\",0,)))","v":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"}]
["B2","Drive for results: Proactively seeks and acts on feedback. Continuous drive for change and encourages others to deliver results across functional areas capturing and standardising best practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Team-working: Awareness of own and others’ working styles and collaborates with others to achieve results.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Inspirational: Leads by example, acts with integrity, builds trust and demonstrates respect for others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Communicates effectively: Adapts style to suit audience and situation, influences and persuades key stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Managing Change: Resilient and adaptable when dealing with challenge and change, maintaining focus and self-control, flexible to changing work environment and demands",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J68=1,0.5,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=0.5,\"NONE\",IF(L68=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B7","Innovation: Challenges the status quo to foster new ways of thinking and working and resolve problems; seeks out opportunities to drive forward change and improvements for the business",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J69=1,0.5,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=0.5,\"NONE\",IF(L69=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B8","Company/industry perspective: knowledge of company and industry, acts as an ambassador both internally and externally",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=0.5,\"NONE\",IF(L70=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J70)","v":0},"Net Score",{"$f":"SUM(L22:L70)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J73/L77","v":0},"total CoE KSB coverage",{"$f":"L73/L80","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",47]
[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",7]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L77-L78-(L79*0.5)","v":43.5}]

{"sheet":"ST0945","index":14,"n_rows":88,"n_cols":18,"rows_kept":88,"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,"Outdoor learning specialist (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Methods to identify and analyse the wants, needs and expectations of participants, customers, and stakeholders.",null,null,null,null,null,null,{"$f":"IF(C22:C48 = \"FULLY MET\",1,IF(C22:C48 = \"PARTIALLY MET\",0.5,IF(C22:C48 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","How to use Theory of Change to design outdoor learning programmes or services that contribute to desired long-term impact, including organising and aligning intended outcomes with meaningful/realistic learning opportunities utilising outdoor activities and experiences.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Legislation, codes of practice, ethics and accepted good practice related to the safe delivery of learning experiences in the outdoor and indoor environments in which they work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Recognised approaches to outdoor learning appropriate to their workplace including their history, pedagogy/andragogy and application when designing, planning and delivering outdoor learning programmes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The background and application of relevant theories of human and social development; models of psychology; and neuroscience appropriate to their work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The physical and emotional capacity, motivation drivers, developmental needs and rights of the population group they work with.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The evidence base for the effectiveness of the outdoor learning provided in their workplace and the relevant evaluation and research data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The ethics, theories, legal position and methods of making and recording risk–benefit assessments for outdoor learning experiences.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Workplace policies and procedures relevant to leading an outdoor learning programme including the planning process, safety systems, budgetary control, and reporting",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Approaches for motivating, supervising, coaching and mentoring staff allocated for a programme.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Theories and models for leading groups in the outdoors.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Relevant research and theory on decision making and judgement in the outdoor setting informed by approaches to reflection in-action, reflection on-action-in-context, and reflection on-action.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How to recognise and respond to a dynamic change in environmental, individual, or group conditions using an appropriate problem solving, recovery, rescue or emergency response",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The benefits of instruction, teaching, coaching and mentoring approaches and their application in facilitating outdoor learning.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Methods to differentiate learning in order to respond to different learning preferences, group dynamics and interpersonal communication, emotional and cultural intelligences.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Principles of assessment as learning, rules of assessment evidence and assessment methods suitable for the range of activities and intended outcomes of the outdoor programmes delivered.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Feedback methods that support participants to achieve intended outcomes and development goals",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Methods to identify and overcome barriers to equality, diversity and inclusion within programmes, the organisation and the wider sector .",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Digital technologies to support instruction, teaching, coaching and learning in the outdoors and how they benefit self and participants.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The geography and ecology of landscapes in which they practice, including but not limited to local, regional and global perspectives on habitat, biodiversity, the effects of climate change, social history, and local effects such as weather and tides.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Methods to gather and analyse feedback and evidence data on outputs, outcomes and impacts of an outdoor learning programme.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Methods to build and maintain effective relationships with a wide range of participants, volunteers, stakeholders and colleagues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","How to positively promote the work of the organisation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Principles of good customer service, including the types, needs and expectations of internal and external customers and ways to manage conflict.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","How to lead meetings, structure and deliver effective instructions, presentations, written reports.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Ethics and the value of reflective practice for professional development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Contemporary issues and the global challenges faced by Outdoor Learning, including the role and vision of organisations such as the Institute for Outdoor Learning",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Use questions, observations, discussions, surveys and active listening to identify the programme needs and expectations of customers, participants and stakeholders.",null,null,null,null,null,null,{"$f":"IF(C50:C72 = \"FULLY MET\",1,IF(C50:C72 = \"PARTIALLY MET\",0.5,IF(C50:C72 = \"NOT MET\",0,)))","v":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"}]
["S2","Plan a purposeful sequence of outdoor learning activities and experiences matched to an agreed Theory of Change.",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},"FULL"]
["S3","Comply with relevant legislation and codes of practice related to the safe delivery of learning experiences in the outdoor and indoor environments in which they work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Make programme design and delivery decisions based on the pedagogy/andragogy of the chosen approaches to outdoor learning used by their organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Produce risk-benefit assessments for outdoor learning programmes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Supervise, motivate and work alongside the delivery team allocated to an outdoor learning programme, taking into account available resources, participant needs, individual and organisational approach, programme budget, intended outcomes and desired long-term impact.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Lead differentiated outdoor learning activities and experiences to meet the needs and capabilities of individual participants within the group using appropriate resources and techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Instruct others in how to participate in activities correctly and safely and vary the content, tempo and direction of the activities to enable all participants to contribute to and benefit from the experience.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Make decisions informed by data such as by observations, experience, reflection in-action (in the moment), reflection on-action-in-context (during the experience), reflection on-action (post experience) and professional judgement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Deal with a dynamic change in group, equipment, or environmental conditions using an appropriate problem solving, recovery, rescue or emergency response.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Create the conditions for participant engagement and achievement whilst supporting equality and diversity and inclusion.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Use a relevant approach such as instruction, teaching, coaching and mentoring approaches to assist participants to meet the intended outcomes of a session and programme.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Use relevant approaches to outdoor learning; theories of human and social development; psychological models; and neuroscience to support participants to achieve the intended outcomes of a programme.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Use the rules of assessment evidence to determine participant progress towards intended outcomes and provide appropriate feedback in terms of its timing, frequency, content and delivery that promotes further learning.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Use digital technologies to support the delivery of outdoor learning sessions and enable participants to engage with technology to achieve the intended outcomes of a programme.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Plan and lead programmes and activities that are sustainable, minimise impact and connect participants with their environment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Care for, conserve and enhance the environment in which they work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Use research data and evaluation of own experience to: plan and lead evidence informed outdoor learning experiences; and communicate the value of an outdoor learning programme",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Use data gathered on outputs, outcomes and impacts of outdoor learning programmes to quality assure programme and organisational improvements in the short, medium and longer term.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Engage and communicate confidently, clearly and considerately with individuals, small groups and larger groups.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Lead meetings, deliver presentations and write short reports .",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Use reflective practice in their work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Recognise own values, beliefs, strengths, areas of development and set future goals in line with own and the organisations objectives.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Acts in a way that builds and maintains positive relationships with colleagues, participants and stakeholders.",null,null,null,null,null,null,{"$f":"IF(C74:C78 = \"FULLY MET\",1,IF(C74:C78 = \"PARTIALLY MET\",0.5,IF(C74:C78 = \"NOT MET\",0,)))","v":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"}]
["B2","Champions the wellbeing and health and safety of participants and stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Encourages participants to achieve their potential in the activity, experience or programme",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Acts in a professional and ethical manner and portrays a positive approach to work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Champions, actively respects and protects the outdoor environment in which they work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J78)","v":0},"Net Score",{"$f":"SUM(L22:L78)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J81/L85","v":0},"total CoE KSB coverage",{"$f":"L81/L88","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",55]
[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":"L85-L86-(L87*0.5)","v":55}]

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