{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["GUIDE TO KSB MAPPING","OCC0827","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"OCC0827","index":1,"n_rows":123,"n_cols":32,"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\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Nursing associate (NMC 2018) (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Resubmission 1:\nWhere in the qualification is the relevant content?\n\n","Resubmission 1:\nEvidence\n ","Resubmission 1:\nSupporting Comments/Rationale","Resubmission 1:\nAssessment method","Resubmission 1:\nIM Comment","Resubmission 1:\nIM Moderation","Resubmission 1:\nG7 QA","Resubmission 2:\nWhere in the qualification is the relevant content?\n\n","Resubmission 2:\nEvidence\n ","Resubmission 2:\nSupporting Comments/Rationale","Resubmission 2:\nAssessment method","Resubmission 2\nIM Comment","Resubmission 2:\nIM Moderation","Resubmission 2:\nG7 QA","Conclusion\n"]
[null,"Knowledge"]
["K1","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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M22=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K2","Understand the 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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M23=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["K3","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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K8","Understand how discriminatory behaviour is exhibited",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K9","Understand 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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K11","Understand the factors that may lead to inequalities in health outcomes",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K14","Understand the importance of health screening",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K15","Understand 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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K18","Understand and apply the principles and processes for making reasonable adjustments",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K19","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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K29","Understand the different ways by which medicines can be prescribed",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["K36","Understand the roles of the different providers of health and care",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[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,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S9","Develop, manage and maintain appropriate relationships with people, their families, carers and colleagues",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S10","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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S12","Challenge or report discriminatory behaviour",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S15","Identify people who are eligible for health screening",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S16","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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M87=\"NONE\",\"MET\",\"NOT MET\")","v":"NOT MET"}]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S25","Meet people’s needs for safety, dignity, privacy, comfort and sleep",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S26","Meet people’s needs related to nutrition, hydration and bladder and bowel health",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S27","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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S28","Support people with commonly encountered symptoms including anxiety, confusion, discomfort and pain",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S32","Work collaboratively and in partnership with professionals from different agencies in interdisciplinary teams",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S33","Maintain safe work and care environments",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S35","Accurately undertake risk assessments, using contemporary assessment tools",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S36","Respond to and escalate potential hazards that may affect the safety of people",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S40","Support and motivate other members of the care team and interact confidently with them",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["S43","Contribute to team reflection activities to promote improvements in practice and services",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[null,"Behaviours"]
["B1","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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["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,"NONE",{"$f":"IF(J112=1,1,IF(J112=0.5,0.5,IF(J112=0,0)))","v":0},{"$f":"IF(L112=1,\"NONE\",IF(L112=0.5,\"PARTIAL\",IF(L112=0,\"FULL\")))","v":"FULL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
["B3","Be adaptable, reliable and consistent, show discretion, resilience and self-awareness",null,null,null,null,null,null,0,null,"NONE",0,"FULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT MET"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22: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",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":"L120-L121-(L122*0.5)","v":90}]

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