{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["GUIDE TO KSB MAPPING","ST0551","ST1379","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":"ST0551","index":1,"n_rows":89,"n_cols":18,"rows_kept":89,"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,"Early years lead practitioner (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Ethical and rights-based approaches to support the child, listening to the child’s authentic voice within their social and cultural context enabling advocacy for the child and their individual journey, developing high quality childcare environments that are continuously evaluated.",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","How individual children learn and develop from conception to 8 years in relation to typical and atypical neurological, cognitive, social, emotional, behavioural, communication and physical development within the social, cultural context and the impact of this on their future.",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","Factors that have an impact upon health, well-being and early learning that can affect children from conception to 8 years.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Current and contemporary schools of thought to enable respectful and nurturing personal care.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Local and national child protection and safeguarding policies and procedures in practice, identifying when a child is at risk, and how to challenge in order to protect them. This includes understanding the role of the designated lead for safeguarding and assimilating findings of serious case reviews.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Theories of self-regulation, resilience and well-being and the impact of adverse early childhood experiences.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Current and emerging theories of attachment and how these relate to promoting relationships effectively such as the key person approach.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The importance of the social cultural context on the learning and development of the child and the influence parents, families and carers have within the home learning environment and the complexities of the family situation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The importance of play and the theoretical perspectives of play and its impact on a child’s learning and development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","How to stimulate children’s creativity and curiosity and why and how this enables enquiry based active learning.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","A wide range of underpinning theories from physiological, neurological, developmental and education and how these can be incorporated to develop own pedagogy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Current and contemporary approaches in the development of emergent literacy and numeracy skills such as synthetic phonics.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How planning cycles inform and improve practice and the principles of individual needs-based assessment for effective early intervention for all children responsive to typical and atypical needs and development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Potential effects of transitions and schools of thought on how to successfully support children and their families.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The importance of enabling environments and the impact of opportunities, resources and relationships on learning and development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How to promote inclusion, equality and diversity in the sector and why it is essential.",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},"FULL"]
["K17","Current and contemporary theoretical perspectives and approaches to leadership and how to support others through leaderful practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Principles of reflection in influencing early years practice with a commitment to life-long learning including continual professional development and action research.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","How to maintain accurate and coherent records and reports for the purpose of sharing information and communicate effectively in both oral and written English.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The current and relevant policy, statutory guidance and legal requirements as appropriate to the sector within; local, national, historical and global contexts.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Strategies to effect collaborative approaches to working with parents, professional bodies and multi agencies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Analyse and articulate how all children’s individual learning can be affected by their current developmental capabilities, characteristics and individual circumstances taking into account all factors contributing to typical and atypical development.",null,null,null,null,null,null,{"$f":"IF(C44:C69 = \"FULLY MET\",1,IF(C44:C69 = \"PARTIALLY MET\",0.5,IF(C44:C69 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},"FULL"]
["S2","Promote equality of opportunity and anti-discriminatory practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Observe, assess, plan, facilitate and participate in play opportunities which include current curriculum requirements.",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"}]
["S4","Ensure plans fully reflect the individual development needs and circumstances of children and actively participate in the provision of consistent care, responding quickly to the needs of the individual child.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J47=1,0.5,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},"PARTIAL"]
["S5","Provide a dynamic, evolving and enabling environment that reflects the current interests, motivations, and play of individual and groups of children.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S6","Encourage all children’s participation, ensuring a sensitive, respectful and effective balance within the adult and child dynamic to facilitate play opportunities.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S7","Engage in effective strategies to develop and extend children's learning and thinking, including sustained shared thinking.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S8","Support and promote children’s speech, language and communication development and determining and adapting appropriate responses and interventions.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S9","Support children to engage in a range of learning contexts such as individual, small groups and larger groups as appropriate for their play and support confidence within social experiences.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S10","Ensure staff are deployed effectively to suit and enhance the learning environment, prioritising the safety and wellbeing of all children.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S11","Advocate for the child, cultivating professional partnerships with parents/carers and other professionals, presenting their understanding of the child’s journey within multidisciplinary teams to holistically support the child’s individual needs.",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S12","Demonstrate the importance of the home learning environment, developing an effective and collaborative partnership to enhance opportunities for the child.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J55=1,1,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=1,\"NONE\",IF(L55=0.5,\"PARTIAL\",IF(L55=0,\"FULL\")))","v":"FULL"}]
["S13","Make use of formative and summative assessment, tracking children’s progress to plan for future learning possibilities including early interventions based on individual developmental needs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Take responsibility for supporting the key person in articulating children's progress and planning future learning possibilities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Use current and contemporary knowledge, research, theories and approaches to develop, enhance and articulate their own pedagogical approach and practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Use reflection to develop themselves both professionally and personally to enhance their practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Plan, carry out and guide appropriate physical care routines for individual children.",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"}]
["S18","Promote, model and support children and families to develop a healthy approach to making choices relating to personal care including eating, sleeping and physical activity.",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},"PARTIAL"]
["S19","Develop, model and implement strategies to support the emotional, psychological, physical and cultural needs of all children within the setting.",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"]
["S20","Identify and act upon own responsibilities in relation to health and safety, prevention and control of infection, carrying out risk assessments and risk management processes in line with policies and procedures.",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"}]
["S21","Ensure the security and confidentiality of data, records and information in line with current legislation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Be a leaderful practitioner to support, mentor, coach, train and guide colleagues in a range of settings, providing inspiration and motivation to engage others to develop their practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Be confident to identify, action and competently challenge issues and undertake difficult conversations where appropriate.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Advocate for children through their child centred approach, listening to the voice of the child; ensuring children’s rights, views and wishes are heard, respected and acted upon at all times. Offer appropriate support and influence decisions in the best interests of the child.",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"}]
["S25","Competently action and carry out safeguarding procedures, using their professional curiosity, knowledge, insight and understanding.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J68=1,1,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=1,\"NONE\",IF(L68=0.5,\"PARTIAL\",IF(L68=0,\"FULL\")))","v":"FULL"}]
["S26","Explore and understand, challenge and question; knowing when to act to safeguard and protect children.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Ethical, fair, consistent and impartial, valuing equality and diversity at all times within professional boundaries.",null,null,null,null,null,null,{"$f":"IF(C71:C79 = \"FULLY MET\",1,IF(C71:C79 = \"PARTIALLY MET\",0.5,IF(C71:C79 = \"NOT MET\",0,)))","v":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"}]
["B2","Leaderful and motivating through consistent modelling of innovative and aspirational practice to other colleagues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Person centred, friendly and approachable, demonstrating caring, empathetic and respectful qualities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Authentic and fun, demonstrating playful practice through animated and expressive play and quality interactions with children.",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"}]
["B5","Positive and proactive member of the team, being assertive and exercising diplomacy.",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"}]
["B6","Reflective practitioner.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Creative and imaginative, demonstrating curiosity and inquisitiveness in order to be resourceful in all areas, including play and problem solving.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Flexible and adaptable; responding to children’s spontaneous activities.",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"}]
["B9","Receptive and open to challenge and constructive criticism.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J79=1,1,IF(J79=0.5,0.5,IF(J79=0,0)))","v":0},{"$f":"IF(L79=1,\"NONE\",IF(L79=0.5,\"PARTIAL\",IF(L79=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J79)","v":0},"Net Score",{"$f":"SUM(L22:L79)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J82/L86","v":0},"total CoE KSB coverage",{"$f":"L82/L89","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":"L86-L87-(L88*0.5)","v":48.5}]

{"sheet":"ST1379","index":2,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Learning and skills mentor (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The roles and responsibilities of a mentor, understanding the organisational and professional boundaries, legal and ethical requirements, including safeguarding",null,null,null,null,null,null,{"$f":"IF(C22:C37 = \"FULLY MET\",1,IF(C22:C37 = \"PARTIALLY MET\",0.5,IF(C22:C37 = \"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 establish and manage a mentoring contract",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","How to plan for mentoring sessions and review and revise action plans",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Mentoring theory and models, including maintaining good practice and protocols within the mentoring relationship",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Organisational and legal requirements for recording, storing and sharing personal information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Strategies to assess starting points of the mentee, including potential barriers to development",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Methods of communication to maintain the mentoring relationship and review progress towards agreed outcomes",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J28=1,1,IF(J28=0.5,0.5,IF(J28=0,0)))","v":0},"FULL"]
["K8","Questioning and listening techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Methods for providing feedback to inform progression",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The impact of their own values, beliefs and behaviours on mentoring practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How to provide accurate and relevant vocational/pastoral advice and guidance to meet mentee needs, including points of referral to other professional services",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Theories and models of evaluation and reflection",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Approaches to sustainable mentoring practice",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J34=1,1,IF(J34=0.5,0.5,IF(J34=0,0)))","v":0},"FULL"]
["K14","Opportunities for continuing professional development",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The role of supervision in supporting the mentor",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Evidence-based practice informed by own research",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Conduct sustainable mentoring practice within organisational and professional boundaries, and legal and ethical requirements, including safeguarding",null,null,null,null,null,null,{"$f":"IF(C39:C52 = \"FULLY MET\",1,IF(C39:C52 = \"PARTIALLY MET\",0.5,IF(C39:C52 = \"NOT MET\",0,)))","v":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"}]
["S2","Establish and maintain mentoring contracts with mentees and where relevant, other stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Conduct mentoring sessions according to agreed plans",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Implement established mentoring tools and techniques to help the mentee work towards agreed outcomes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Maintain records of mentoring practice, complying with quality, confidentiality and data protection requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Establish and use assessed starting points to establish agreed outcomes of the mentoring process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Assess and review progress and achievement of agreed outcomes and revise action plans as appropriate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Maintain mentoring relationship through a non-judgemental and objective approach",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Use questioning techniques to encourage reflection and progression",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Provide feedback to the mentee to inform progression",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Inform, advise and guide the mentee to support development toward agreed outcomes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Apply theories and models of evaluation and reflection to support mentee development",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Monitor and reflect on own mentoring practice, including feedback from supervision, to develop self",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Apply evidence based mentoring practice informed by own research",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Demonstrate and promote sustainable practices with mentee",null,null,null,null,null,null,{"$f":"IF(C54:C58 = \"FULLY MET\",1,IF(C54:C58 = \"PARTIALLY MET\",0.5,IF(C54:C58 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=1,\"NONE\",IF(L54=0.5,\"PARTIAL\",IF(L54=0,\"FULL\")))","v":"FULL"}]
["B2","Work to ethical and legal standards within professional boundaries",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Be resilient and adaptable when dealing with challenge and change, maintaining focus and self-control",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Demonstrate and encourage mutual respect, displaying a deep understanding of equality and diversity, with and between learners, colleagues and appropriate agencies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Committed to improving their own professional practice in relation to mentoring",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J58)","v":0},"Net Score",{"$f":"SUM(L22:L58)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J61/L65","v":0},"total CoE KSB coverage",{"$f":"L61/L68","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",35]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L65-L66-(L67*0.5)","v":35}]

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