{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["GUIDE TO KSB MAPPING","ST0385","ST0563","ST0575","ST0762","ST0809","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":"ST0385","index":1,"n_rows":110,"n_cols":18,"rows_kept":110,"cut":false,"hidden":false,"merged":[[44,0,44,6],[46,0,46,6],[49,0,49,6],[51,0,51,6],[55,0,55,6],[47,0,47,6],[56,0,56,6],[91,0,91,6],[94,0,94,6],[96,0,96,6],[98,0,98,6],[62,0,62,6],[65,0,65,6],[67,0,67,6],[68,0,68,6],[88,0,88,6],[72,0,72,6],[74,0,74,6],[78,0,78,6],[82,0,82,6],[83,0,83,6],[85,0,85,6],[40,0,40,6],[9,0,9,6],[9,8,9,15],[10,8,11,15],[21,0,21,6],[34,0,34,6],[22,0,22,6],[28,0,28,6],[31,0,31,6],[33,0,33,6],[38,0,38,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",null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["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,"Operations or Departmental Manager (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"]
["ORGANISATIONAL PERFORMANCE - DELIVERING RESULTS"]
["Operational Management"]
["K1","Understand operational management approaches and models, including creating plans to deliver objectives and setting KPIs.",null,null,null,null,null,null,{"$f":"IF(C24:C28 = \"FULLY MET\",1,IF(C24:C28 = \"PARTIALLY MET\",0.5,IF(C24:C28 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J24=1,1,IF(J24=0.5,0.5,IF(J24=0,0)))","v":0},{"$f":"IF(L24=1,\"NONE\",IF(L24=0.5,\"PARTIAL\",IF(L24=0,\"FULL\")))","v":"FULL"}]
["K2","Understand business development tools (eg SWOT), and approaches to continuous improvement.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J25=1,1,IF(J25=0.5,0.5,IF(J25=0,0)))","v":0},{"$f":"IF(L25=1,\"NONE\",IF(L25=0.5,\"PARTIAL\",IF(L25=0,\"FULL\")))","v":"FULL"}]
["K3","Understand operational business planning techniques, including how to manage resources, development of sales and marketing plans, setting targets and monitoring performance. Knowledge of management systems, processes and contingency planning.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J26=1,1,IF(J26=0.5,0.5,IF(J26=0,0)))","v":0},{"$f":"IF(L26=1,\"NONE\",IF(L26=0.5,\"PARTIAL\",IF(L26=0,\"FULL\")))","v":"FULL"}]
["K4","Understand how to initiate and manage change by identifying barriers and know how to overcome them.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J27=1,1,IF(J27=0.5,0.5,IF(J27=0,0)))","v":0},{"$f":"IF(L27=1,\"NONE\",IF(L27=0.5,\"PARTIAL\",IF(L27=0,\"FULL\")))","v":"FULL"}]
["K5","Understand data security and management, and the effective use of technology in an organisation.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J28=1,1,IF(J28=0.5,0.5,IF(J28=0,0)))","v":0},{"$f":"IF(L28=1,\"NONE\",IF(L28=0.5,\"PARTIAL\",IF(L28=0,\"FULL\")))","v":"FULL"}]
["Project Management"]
["K6","Know how to set up and manage a project using relevant tools and techniques, and understand process management.",null,null,null,null,null,null,{"$f":"IF(C30:C31 = \"FULLY MET\",1,IF(C30:C31 = \"PARTIALLY MET\",0.5,IF(C30:C31 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J30=1,1,IF(J30=0.5,0.5,IF(J30=0,0)))","v":0},{"$f":"IF(L30=1,\"NONE\",IF(L30=0.5,\"PARTIAL\",IF(L30=0,\"FULL\")))","v":"FULL"}]
["K7","Understand approaches to risk management.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J31=1,1,IF(J31=0.5,0.5,IF(J31=0,0)))","v":0},{"$f":"IF(L31=1,\"NONE\",IF(L31=0.5,\"PARTIAL\",IF(L31=0,\"FULL\")))","v":"FULL"}]
["Finance"]
["K8","Understand business finance: how to manage budgets, and financial forecasting.",null,null,null,null,null,null,{"$f":"IF(C33:C33 = \"FULLY MET\",1,IF(C33:C33 = \"PARTIALLY MET\",0.5,IF(C33:C33 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J33=1,1,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},{"$f":"IF(L33=1,\"NONE\",IF(L33=0.5,\"PARTIAL\",IF(L33=0,\"FULL\")))","v":"FULL"}]
["INTERPERSONAL EXCELLENCE - MANAGING PEOPLE AND DEVELOPING RELATIONSHIPS"]
["Leading People"]
["K9","Understand different leadership styles, how to lead multiple and remote teams and manage team leaders.",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"}]
["K10","Know how to motivate and improve performance, supporting people using coaching and mentoring approaches. ",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"}]
["K11","Understand organisational cultures and diversity and their impact on leading and managing change. Know how to delegate effectively.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J38=1,1,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=1,\"NONE\",IF(L38=0.5,\"PARTIAL\",IF(L38=0,\"FULL\")))","v":"FULL"}]
["Managing people"]
["K12","Know how to manage multiple teams, and develop high performing teams. Understand performance management techniques, talent management models and how to recruit and develop people.",null,null,null,null,null,null,{"$f":"IF(C40:C40 = \"FULLY MET\",1,IF(C40:C40 = \"PARTIALLY MET\",0.5,IF(C40:C40 = \"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"}]
["Building relationships"]
["K13","Understand approaches to partner, stakeholder and supplier relationship management including negotiation, influencing, and effective networking.",null,null,null,null,null,null,{"$f":"IF(C42:C44 = \"FULLY MET\",1,IF(C42:C44 = \"PARTIALLY MET\",0.5,IF(C42:C44 = \"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"}]
["K14","Knowledge of collaborative working techniques to enable delivery through others and how to share best practice.",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"}]
["K15","Know how to manage conflict at all levels.",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"}]
["Communication"]
["K16","Understand interpersonal skills and different forms of communication and techniques (verbal, written, non-verbal, digital) and how to apply them appropriately.",null,null,null,null,null,null,{"$f":"IF(C46:C46 = \"FULLY MET\",1,IF(C46:C46 = \"PARTIALLY MET\",0.5,IF(C46:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J46=1,1,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=1,\"NONE\",IF(L46=0.5,\"PARTIAL\",IF(L46=0,\"FULL\")))","v":"FULL"}]
["PERSONAL EFFECTIVENESS - MANAGING SELF"]
["Self awareness"]
["K17","Understand own impact and emotional intelligence. Understand different and learning and behaviour styles.",null,null,null,null,null,null,{"$f":"IF(C49:C49 = \"FULLY MET\",1,IF(C49:C49 = \"PARTIALLY MET\",0.5,IF(C49:C49 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J49=1,1,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=1,\"NONE\",IF(L49=0.5,\"PARTIAL\",IF(L49=0,\"FULL\")))","v":"FULL"}]
["Management of self"]
["K18","Understand time management techniques and tools, and how to prioritise activities and the use of different approaches to planning, including managing multiple tasks.",null,null,null,null,null,null,{"$f":"IF(C51:C51 = \"FULLY MET\",1,IF(C51:C51 = \"PARTIALLY MET\",0.5,IF(C51:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
["Decision making"]
["K19","Understand problem solving and decision making techniques, including data analysis.",null,null,null,null,null,null,{"$f":"IF(C53:C54 = \"FULLY MET\",1,IF(C53:C54 = \"PARTIALLY MET\",0.5,IF(C53:C54 = \"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"}]
["K20","Understand organisational values and ethics and their impact on decision making.",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"}]
[null,"Skills"]
["ORGANISATIONAL PERFORMANCE - DELIVERING RESULTS"]
["Operational Management"]
["S1","Able to input into strategic planning and create plans in line with organisational objectives.",null,null,null,null,null,null,{"$f":"IF(C58:C62 = \"FULLY MET\",1,IF(C58:C62 = \"PARTIALLY MET\",0.5,IF(C58:C62 = \"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","Support, manage and communicate change by identifying barriers and overcoming them.",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"}]
["S3","Demonstrate commercial awareness, and able to identify and shape new opportunities.",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"}]
["S4","Creation and delivery of operational plans, including setting KPIs, monitoring performance against plans.",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"}]
["S5","Producing reports, providing management information based on the collation, analysis and interpretation of data.",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"}]
["Project Management"]
["S6","Plan, organise and manage resources to deliver required outcomes.",null,null,null,null,null,null,{"$f":"IF(C64:C65 = \"FULLY MET\",1,IF(C64:C65 = \"PARTIALLY MET\",0.5,IF(C64:C65 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["S7","Monitor progress, and identify risk and their mitigation. Able to use relevant project management tools.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=1,\"NONE\",IF(L65=0.5,\"PARTIAL\",IF(L65=0,\"FULL\")))","v":"FULL"}]
["Finance"]
["S8","Able to monitor budgets and provide reports, and consider financial implications of decisions and adjust approach and recommendations accordingly.",null,null,null,null,null,null,{"$f":"IF(C67:C67 = \"FULLY MET\",1,IF(C67:C67 = \"PARTIALLY MET\",0.5,IF(C67:C67 = \"NOT MET\",0,)))","v":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"}]
["INTERPERSONAL EXCELLENCE - MANAGING PEOPLE AND DEVELOPING RELATIONSHIPS"]
["Leading People"]
["S9","Able to communicate organisational vision and goals and how these to apply to teams.",null,null,null,null,null,null,{"$f":"IF(C70:C72 = \"FULLY MET\",1,IF(C70:C72 = \"PARTIALLY MET\",0.5,IF(C70:C72 = \"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"}]
["S10","Support development through coaching and mentoring, and enable and support high performance working.",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"}]
["S11","Able to support the management of change within the organisation.",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"}]
["Managing people"]
["S12","Able to manage talent and performance. Develop, build and motivate teams by identifying their strengths and enabling development within the workplace. Able to delegate and enable delivery though others.",null,null,null,null,null,null,{"$f":"IF(C74:C74 = \"FULLY MET\",1,IF(C74:C74 = \"PARTIALLY MET\",0.5,IF(C74:C74 = \"NOT MET\",0,)))","v":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"}]
["Building relationships"]
["S13","Able to build trust, and use effective negotiation and influencing skills and manage conflict.",null,null,null,null,null,null,{"$f":"IF(C76:C78 = \"FULLY MET\",1,IF(C76:C78 = \"PARTIALLY MET\",0.5,IF(C76:C78 = \"NOT MET\",0,)))","v":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"}]
["S14","Able to identify and share good practice, and work collaboratively with others both inside and outside of the organisation.",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"}]
["S15","Use of specialist advice and support to deliver against plans.",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"}]
["Communication"]
["S16","Able to communicate effectively (verbal, non-verbal, written, digital) and be flexible in communication style.",null,null,null,null,null,null,{"$f":"IF(C80:C82 = \"FULLY MET\",1,IF(C80:C82 = \"PARTIALLY MET\",0.5,IF(C80:C82 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J80=1,1,IF(J80=0.5,0.5,IF(J80=0,0)))","v":0},{"$f":"IF(L80=1,\"NONE\",IF(L80=0.5,\"PARTIAL\",IF(L80=0,\"FULL\")))","v":"FULL"}]
["S17","Able to chair meetings and present using a range of media.",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"}]
["S18","Use of active listening, and able to challenge and give constructive feedback.",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"}]
["PERSONAL EFFECTIVENESS - MANAGING SELF"]
["Self awareness"]
["S19","Able to reflect on own performance, working style and its impact on others.",null,null,null,null,null,null,{"$f":"IF(C85:C85 = \"FULLY MET\",1,IF(C85:C85 = \"PARTIALLY MET\",0.5,IF(C85:C85 = \"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"}]
["Management of self"]
["S20","Able to create a personal development plan.",null,null,null,null,null,null,{"$f":"IF(C87:C88 = \"FULLY MET\",1,IF(C87:C88 = \"PARTIALLY MET\",0.5,IF(C87:C88 = \"NOT MET\",0,)))","v":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"}]
["S21","Use of time management and prioritisation techniques.",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"}]
["Decision making"]
["S22","Able to undertake critical analysis and evaluation to support decision making. Use of effective problem solving techniques.",null,null,null,null,null,null,{"$f":"IF(C90:C90 = \"FULLY MET\",1,IF(C90:C90 = \"PARTIALLY MET\",0.5,IF(C90:C90 = \"NOT MET\",0,)))","v":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"}]
[null,"Behaviours"]
["Takes responsibility"]
["B1","Drive to achieve in all aspects of work. Demonstrates resilience and accountability.",null,null,null,null,null,null,{"$f":"IF(C93:C94 = \"FULLY MET\",1,IF(C93:C94 = \"PARTIALLY MET\",0.5,IF(C93:C94 = \"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","Determination when managing difficult situations. Seeks new opportunities.",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"}]
["Inclusive"]
["B3","Open, approachable, authentic, and able to build trust with others. Seeks the views of others and values diversity.",null,null,null,null,null,null,{"$f":"IF(C96:C96 = \"FULLY MET\",1,IF(C96:C96 = \"PARTIALLY MET\",0.5,IF(C96:C96 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J96=1,1,IF(J96=0.5,0.5,IF(J96=0,0)))","v":0},{"$f":"IF(L96=1,\"NONE\",IF(L96=0.5,\"PARTIAL\",IF(L96=0,\"FULL\")))","v":"FULL"}]
["Agile"]
["B4","Flexible to the needs of the organisation. Is creative, innovative and enterprising when seeking solutions to business needs. Positive and adaptable, responding well to feedback and need for change. Open to new ways of working.",null,null,null,null,null,null,{"$f":"IF(C98:C98 = \"FULLY MET\",1,IF(C98:C98 = \"PARTIALLY MET\",0.5,IF(C98:C98 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J98=1,0.5,IF(J98=0.5,0.5,IF(J98=0,0)))","v":0},{"$f":"IF(L98=0.5,\"NONE\",IF(L98=0,\"PARTIAL\"))","v":"PARTIAL"}]
["Professionalism"]
["B5","Sets an example, and is fair, consistent and impartial. Open and honest. Operates within organisational values",null,null,null,null,null,null,{"$f":"IF(C100:C100 = \"FULLY MET\",1,IF(C100:C100 = \"PARTIALLY MET\",0.5,IF(C100:C100 = \"NOT MET\",0,)))","v":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"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J24:J100)","v":0},"Net Score",{"$f":"SUM(L24:L100)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J103/L107","v":0},"total CoE KSB coverage",{"$f":"L103/L110","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,"partialy mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L107-L108-(L109*0.5)","v":45}]

{"sheet":"ST0563","index":2,"n_rows":102,"n_cols":18,"rows_kept":102,"cut":false,"hidden":false,"merged":[[89,0,89,6],[85,0,85,6],[35,0,35,6],[64,0,64,6],[73,0,73,6],[78,0,78,6],[81,0,81,6],[68,0,68,6],[40,0,40,6],[47,0,47,6],[53,0,53,6],[60,0,60,6],[9,0,9,6],[9,8,9,15],[10,8,11,15],[21,0,21,6],[30,0,30,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",null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["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,"Learning and Development Consultant Business Partner (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"]
["Technical Expertise"]
["K1","Paradigms, theories and models that underpin effective adult learning, group behaviour and learning culture, for example behaviourism, cognitivism, constructivism, neuroscience.",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","Legislation and policies that influence learning design and delivery",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The merits of different learning delivery channels to select an appropriate face-to-face, blended or digital solution.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Current research and appropriate application of best practice and best fit solutions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The latest learning practice, trends and emerging thinking.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Positively incorporating diversity and inclusion into learning and development interventions and processes. Researching and applying current best practice in this area.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Change management methodologies and the principles of project management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Consultancy tools and techniques, for example the use of SWOT, 5 Whys, weighted matrix etc providing costed recommendations and projected impact, return on investment, return of expectation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Business Understanding"]
["K9","Their organisation’s vision, mission, values, strategy, plans and stakeholders; its external market and sector and the opportunities, challenges and issues it faces.",null,null,null,null,null,null,{"$f":"IF(C32:C35 = \"FULLY MET\",1,IF(C32:C35 = \"PARTIALLY MET\",0.5,IF(C32:C35 = \"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","How business, learning and human resources key performance indicators and metrics build a clear picture of how the business is performing.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J33=1,1,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},{"$f":"IF(L33=1,\"NONE\",IF(L33=0.5,\"PARTIAL\",IF(L33=0,\"FULL\")))","v":"FULL"}]
["K11","The process of stakeholder mapping to define interactions with staff that are part of the learning needs analysis, design, delivery, and evaluation.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J34=1,1,IF(J34=0.5,0.5,IF(J34=0,0)))","v":0},{"$f":"IF(L34=1,\"NONE\",IF(L34=0.5,\"PARTIAL\",IF(L34=0,\"FULL\")))","v":"FULL"}]
["K12","How to measure the impact, return on investment and expectation of learning on the business.",null,null,null,null,null,null,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"}]
["Learning and Development Function"]
["K13","The learning and development structure required to meet business needs and whether this should be in-house, outsourced and how to source specialist expertise when required.",null,null,null,null,null,null,{"$f":"IF(C37:C40 = \"FULLY MET\",1,IF(C37:C40 = \"PARTIALLY MET\",0.5,IF(C37:C40 = \"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","The various learning and development roles, responsibilities and skills required to design and deliver face-to-face, blended or digital solutions.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J38=1,1,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=1,\"NONE\",IF(L38=0.5,\"PARTIAL\",IF(L38=0,\"FULL\")))","v":"FULL"}]
["K15","The policies and processes required for effective organisation learning.",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"}]
["K16","How to prepare, monitor and manage a budget.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J40=1,1,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=1,\"NONE\",IF(L40=0.5,\"PARTIAL\",IF(L40=0,\"FULL\")))","v":"FULL"}]
["Management Information and Technology"]
["K17","The collection of data and information, both qualitative and quantitative, to analyse learning needs, implement effective delivery and measure outcomes and impact.",null,null,null,null,null,null,{"$f":"IF(C42:C46 = \"FULLY MET\",1,IF(C42:C46 = \"PARTIALLY MET\",0.5,IF(C42:C46 = \"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"}]
["K18","How to identify sources, trends and anomalies in data and information.",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"}]
["K19","How to shape internal information systems and how they play a role to support learning.",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"}]
["K20","How technology can support learning, including understanding of digital platforms  and delivery channels as relevant to the role.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"FULL"}]
["K21","Emerging technologies that can support effective learning.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J46=1,1,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=1,\"NONE\",IF(L46=0.5,\"PARTIAL\",IF(L46=0,\"FULL\")))","v":"FULL"}]
[null,"Skills"]
["Learning and development Consultancy"]
["S1","Work as a learning and development business partner or consultant across the whole organisation or key functions and relevant stakeholders as appropriate, to build insight into existing levels of capability against future requirements, identifying organisational skills gaps and risks.",null,null,null,null,null,null,{"$f":"IF(C49:C53 = \"FULLY MET\",1,IF(C49:C53 = \"PARTIALLY MET\",0.5,IF(C49:C53 = \"NOT MET\",0,)))","v":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"}]
["S2","Use a range of techniques to obtain an initial brief from internal stakeholders, and investigate and analyse data to validate the need for a learning intervention.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"}]
["S3","Present a range of relevant and innovative solutions, logically and with credibility, to gain buy-in from senior stakeholders.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
["S4","Develop an organisational development, learning and development and succession plan that addresses gaps and fulfils skills, resourcing, talent, and future leadership needs in the partner and business area, accounting for changing internal and external environment, business and learner needs.",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"}]
["S5","Initiate the design of interventions and monitor implementation.",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"}]
["Developing a Learning Culture"]
["S6","Foster and develop an embedded culture of learning and continuous improvement (e.g. through using communication campaigns).",null,null,null,null,null,null,{"$f":"IF(C55:C60 = \"FULLY MET\",1,IF(C55:C60 = \"PARTIALLY MET\",0.5,IF(C55:C60 = \"NOT MET\",0,)))","v":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"}]
["S7","Manage learning and knowledge transfer.",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"}]
["S8","Facilitate collective and social learning using innovative technological solutions.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J57=1,1,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=1,\"NONE\",IF(L57=0.5,\"PARTIAL\",IF(L57=0,\"FULL\")))","v":"FULL"}]
["S9","Influence management at all levels to collaborate and take responsibility for learning initiatives.",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"}]
["S10","Set up and manage action learning sets, coaching and mentoring programmes.",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"}]
["S11","Ensure quality of learning and training delivery through providing feedback to colleagues to ensure continuous improvement of self and others.",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"}]
["Budget and Resource Management"]
["S12","Construct and manage an learning and development budget, project, intervention, including managing resources to effectively deliver.",null,null,null,null,null,null,{"$f":"IF(C62:C64 = \"FULLY MET\",1,IF(C62:C64 = \"PARTIALLY MET\",0.5,IF(C62:C64 = \"NOT MET\",0,)))","v":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"}]
["S13","Identify and analyse potential cost savings to ensure maximum value.",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"}]
["S14","Effectively engage, negotiate and manage third party suppliers.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J64=1,0.5,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=0.5,\"NONE\",IF(L64=0,\"PARTIAL\"))","v":"PARTIAL"}]
["Relationship Management"]
["S15","Build effective working relationships with business managers (using the language of the business), peers and other learning and development functions, together with relevant external organisations to deliver business results from learning and development plans and solutions.",null,null,null,null,null,null,{"$f":"IF(C66:C68 = \"FULLY MET\",1,IF(C66:C68 = \"PARTIALLY MET\",0.5,IF(C66:C68 = \"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"}]
["S16","Communicate confidently with people at all levels, including senior management.",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"}]
["S17","Work with senior leaders to carry out succession planning, organisational development and talent pipeline plans.",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"}]
["Facilitation Skills"]
["S18","Build rapport and demonstrate the use of language patterns to facilitate and encourage discussions, debate, learning and decisions.",null,null,null,null,null,null,{"$f":"IF(C70:C72 = \"FULLY MET\",1,IF(C70:C72 = \"PARTIALLY MET\",0.5,IF(C70:C72 = \"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"}]
["S19","Employ a range of questioning and listening skills to generate brainstorming, discussion and debate, learning and decisions.",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"}]
["S20","Effectively manage challenging learner and group behaviours.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J72=1,1,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=1,\"NONE\",IF(L72=0.5,\"PARTIAL\",IF(L72=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["Constant and Curious Learner"]
["B1","Pro-actively seeking opportunities and feedback to develop their business acumen, improve their performance and overall capability.",null,null,null,null,null,null,{"$f":"IF(C75:C78 = \"FULLY MET\",1,IF(C75:C78 = \"PARTIALLY MET\",0.5,IF(C75:C78 = \"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"}]
["B2","Probing and inquiring to delve deeper into opportunities, options and solutions.",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"}]
["B3","A desire to understand and experiment with new ideas and techniques, identifying areas for self and wider development and improvements.",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"}]
["B4","That they act as a role model for learning within their organisation and across their networks.",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"}]
["Collaborative Partner"]
["B5","They are a trusted partner, acting with integrity, ensuring that clients, partners and learners alike feel heard and are confident in their ability to deliver.",null,null,null,null,null,null,{"$f":"IF(C80:C81 = \"FULLY MET\",1,IF(C80:C81 = \"PARTIALLY MET\",0.5,IF(C80:C81 = \"NOT MET\",0,)))","v":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"}]
["B6","They can enable different departments or stakeholders to effectively work together above their own agendas and priorities.",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"}]
["Commercial Thinker"]
["B7","They understand and apply the commercial context, realities and drivers behind learning needs and solutions.",null,null,null,null,null,null,{"$f":"IF(C83:C85 = \"FULLY MET\",1,IF(C83:C85 = \"PARTIALLY MET\",0.5,IF(C83:C85 = \"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"}]
["B8","They are focused on outcomes and impacts.",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"}]
["B9","They develop ideas, insights and solutions for defined business benefits.",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"}]
["Constructive Challenger"]
["B10","Personal resilience to manage competing priorities, ensuring that they deliver the outcomes of their work through co-design and a full understanding of the impact they have on others.",null,null,null,null,null,null,{"$f":"IF(C87:C89 = \"FULLY MET\",1,IF(C87:C89 = \"PARTIALLY MET\",0.5,IF(C87:C89 = \"NOT MET\",0,)))","v":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"}]
["B11","The courage to hold a mirror up to the organisation when diagnosing solutions.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J88=1,0.5,IF(J88=0.5,0.5,IF(J88=0,0)))","v":0},{"$f":"IF(L88=0.5,\"NONE\",IF(L88=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B12","Skilfully navigating through organisational and personal politics.",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"}]
["Passionate and Agile Deliverer\n"]
["B13","Responsiveness and flexibility to changing internal and external environments and business needs.",null,null,null,null,null,null,{"$f":"IF(C91:C92 = \"FULLY MET\",1,IF(C91:C92 = \"PARTIALLY MET\",0.5,IF(C91:C92 = \"NOT MET\",0,)))","v":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"}]
["B14","Being a role model for the learning and development profession, inspiring and galvanising others around learning solutions, ensuring that learning is embedded and delivers ambitious goals, outcomes and timelines.",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"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J92)","v":0},"Net Score",{"$f":"SUM(L23:L92)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J95/L99","v":0},"total CoE KSB coverage",{"$f":"L95/L102","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,"partialy mitigated",13]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L99-L100-(L101*0.5)","v":48.5}]

{"sheet":"ST0575","index":3,"n_rows":84,"n_cols":18,"rows_kept":84,"cut":false,"hidden":false,"merged":[[49,0,49,6],[42,0,42,6],[9,0,9,6],[9,8,9,15],[10,8,11,15],[21,0,21,6],[37,0,37,6],[45,0,45,6],[26,0,26,6],[30,0,30,6],[33,0,33,6],[52,0,52,6],[56,0,56,6],[59,0,59,6],[62,0,62,6],[64,0,64,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",null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["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,"School Business Professional (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"]
["Finance"]
["K1","Understands the range of educational funding streams available which are applicable to their educational setting.",null,null,null,null,null,null,{"$f":"IF(C23:C26 = \"FULLY MET\",1,IF(C23:C26 = \"PARTIALLY MET\",0.5,IF(C23:C26 = \"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","Has a working knowledge of accounting practices and understands how to apply business principles to the optimum use of funding to support learning outcomes.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J24=1,1,IF(J24=0.5,0.5,IF(J24=0,0)))","v":0},{"$f":"IF(L24=1,\"NONE\",IF(L24=0.5,\"PARTIAL\",IF(L24=0,\"FULL\")))","v":"FULL"}]
["K3","Understands school compliance issues.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J25=1,1,IF(J25=0.5,0.5,IF(J25=0,0)))","v":0},{"$f":"IF(L25=1,\"NONE\",IF(L25=0.5,\"PARTIAL\",IF(L25=0,\"FULL\")))","v":"FULL"}]
["K4","Recognises business efficiency and knows the range of data required to inform school business decisions.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J26=1,1,IF(J26=0.5,0.5,IF(J26=0,0)))","v":0},{"$f":"IF(L26=1,\"NONE\",IF(L26=0.5,\"PARTIAL\",IF(L26=0,\"FULL\")))","v":"FULL"}]
["Procurement"]
["K5","Knowledge of school procurement regulations and requirements and how to achieve value for money, including collaborative procurement.",null,null,null,null,null,null,{"$f":"IF(C28:C30 = \"FULLY MET\",1,IF(C28:C30 = \"PARTIALLY MET\",0.5,IF(C28:C30 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J28=1,1,IF(J28=0.5,0.5,IF(J28=0,0)))","v":0},{"$f":"IF(L28=1,\"NONE\",IF(L28=0.5,\"PARTIAL\",IF(L28=0,\"FULL\")))","v":"FULL"}]
["K6","Understands how to manage collaborative processes with other schools in order to share good practice and secure financial efficiencies.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J29=1,1,IF(J29=0.5,0.5,IF(J29=0,0)))","v":0},{"$f":"IF(L29=1,\"NONE\",IF(L29=0.5,\"PARTIAL\",IF(L29=0,\"FULL\")))","v":"FULL"}]
["K7","Has an awareness of the complexities of procurement law.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J30=1,1,IF(J30=0.5,0.5,IF(J30=0,0)))","v":0},{"$f":"IF(L30=1,\"NONE\",IF(L30=0.5,\"PARTIAL\",IF(L30=0,\"FULL\")))","v":"FULL"}]
["Human Resources"]
["K8","Understands the complexities of teaching and support staff contracts, terms & conditions of employment and payroll.",null,null,null,null,null,null,{"$f":"IF(C32:C33 = \"FULLY MET\",1,IF(C32:C33 = \"PARTIALLY MET\",0.5,IF(C32:C33 = \"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"}]
["K9","Understands educational HR policies, safer recruitment, and compliance with safeguarding priorities and equality legislation. Has an awareness of when to seek legal advice.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J33=1,1,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},{"$f":"IF(L33=1,\"NONE\",IF(L33=0.5,\"PARTIAL\",IF(L33=0,\"FULL\")))","v":"FULL"}]
["Managing Support Services"]
["K10","Knows the impact of educational policies at an operational level in order to support the school development plan.",null,null,null,null,null,null,{"$f":"IF(C35:C37 = \"FULLY MET\",1,IF(C35:C37 = \"PARTIALLY MET\",0.5,IF(C35:C37 = \"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"}]
["K11","Understands the influence of educational regulatory bodies (DfE, Ofsted, etc). Is aware of Ofsted requirements and the implications these have for the workforce and planning in a school.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J36=1,1,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=1,\"NONE\",IF(L36=0.5,\"PARTIAL\",IF(L36=0,\"FULL\")))","v":"FULL"}]
["K12","Knows how to manage the DfE pupil and workforce census and their impact on the school.",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"}]
["Governance and Risk"]
["K13","Has practical knowledge of the supporting documentation governors need.",null,null,null,null,null,null,{"$f":"IF(C39:C42 = \"FULLY MET\",1,IF(C39:C42 = \"PARTIALLY MET\",0.5,IF(C39:C42 = \"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"}]
["K14","Understands the process of risk management and procures and manages insurance cover for the school to mitigate risks as appropriate.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J40=1,1,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=1,\"NONE\",IF(L40=0.5,\"PARTIAL\",IF(L40=0,\"FULL\")))","v":"FULL"}]
["K15","Has relevant knowledge enabling compliance with charitable status and education law.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J41=1,1,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=1,\"NONE\",IF(L41=0.5,\"PARTIAL\",IF(L41=0,\"FULL\")))","v":"FULL"}]
["K16","Understands the impact of, and how to implement, safeguarding policy in a school environment.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J42=1,1,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=1,\"NONE\",IF(L42=0.5,\"PARTIAL\",IF(L42=0,\"FULL\")))","v":"FULL"}]
["Marketing"]
["K17","Understands how marketing can be used to underpin school funding.",null,null,null,null,null,null,{"$f":"IF(C44:C45 = \"FULLY MET\",1,IF(C44:C45 = \"PARTIALLY MET\",0.5,IF(C44:C45 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"}]
["K18","Knows the marketing priorities of their school and the impact marketing activities can have. Understands marketing activities to promote their school and takes into account e-safety when doing so.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J45=1,0.5,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=0.5,\"NONE\",IF(L45=0,\"PARTIAL\"))","v":"PARTIAL"}]
["Infrastructure\n"]
["K19","Awareness of the optimum deployment of resources targeted to raise pupil attainment.",null,null,null,null,null,null,{"$f":"IF(C47:C49 = \"FULLY MET\",1,IF(C47:C49 = \"PARTIALLY MET\",0.5,IF(C47:C49 = \"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"}]
["K20","Understands the significance of physical facilities and digital processes in an educational setting, e.g. facilities repair logs, student data analysis, data security and safe use of social media.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["K21","Has knowledge of relevant legislation that schools must comply with, such as Health & Safety, Freedom of Information, Employment and Data Protection policies.",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"}]
["Ethical Standards"]
["K22","Understands and demonstrates the highest standards of personal and professional conduct, and applies statutory regulations and provisions.",null,null,null,null,null,null,{"$f":"IF(C51:C51 = \"FULLY MET\",1,IF(C51:C51 = \"PARTIALLY MET\",0.5,IF(C51:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
[null,"Skills"]
["Financial and Operational Management"]
["S1","Manages strategies set by senior personnel and drafts budgets that reflect them. ",null,null,null,null,null,null,{"$f":"IF(C54:C56 = \"FULLY MET\",1,IF(C54:C56 = \"PARTIALLY MET\",0.5,IF(C54:C56 = \"NOT MET\",0,)))","v":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"}]
["S2","Manages the accurate recording and reporting of the school’s finances to inform the senior leadership team who set the priorities for school spending. Completes pre-audit checks.",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"}]
["S3","Produces reports that present information and data using a range of analytical processes.",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"}]
["Project Management"]
["S4","Plans, organises and manages processes to ensure value for money for the school whilst supporting education delivery, e.g. contract management, payroll, building maintenance and small development projects.",null,null,null,null,null,null,{"$f":"IF(C58:C59 = \"FULLY MET\",1,IF(C58:C59 = \"PARTIALLY MET\",0.5,IF(C58:C59 = \"NOT MET\",0,)))","v":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"}]
["S5","Uses multiple IT packages and specialised schools MIS (management information systems) platforms. Prepares and collates reporting data.",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"}]
["Change Management"]
["S6","Embraces change in a school and influence others in a positive manner.",null,null,null,null,null,null,{"$f":"IF(C61:C62 = \"FULLY MET\",1,IF(C61:C62 = \"PARTIALLY MET\",0.5,IF(C61:C62 = \"NOT MET\",0,)))","v":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","Works constructively within a team environment.",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"}]
["Communicati on and Relationship Building"]
["S8","Communicates appropriately and effectively with a range of stakeholders including students, parents, governors/trustees, staff, government and local government departments, e.g. DfE/ ESFA, to gain positive outcomes. Has the confidence to question or seek clarification of aspects of school practice when unsure or unclear.",null,null,null,null,null,null,{"$f":"IF(C64:C64 = \"FULLY MET\",1,IF(C64:C64 = \"PARTIALLY MET\",0.5,IF(C64:C64 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J64=1,0.5,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=0.5,\"NONE\",IF(L64=0,\"PARTIAL\"))","v":"PARTIAL"}]
["Strategic Management"]
["S9","Manages support services across an entire school whilst also providing guidance to colleagues on the most appropriate use of school funding. ",null,null,null,null,null,null,{"$f":"IF(C66:C67 = \"FULLY MET\",1,IF(C66:C67 = \"PARTIALLY MET\",0.5,IF(C66:C67 = \"NOT MET\",0,)))","v":0},null,"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"}]
["S10","Effectively line manages small teams to drive efficiencies.",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"}]
[null,"Behaviours"]
["B1","Change Catalyst - Keeps up to date with educational policies and embraces change. Self- motivated and supportive of others in working through change.",null,null,null,null,null,null,{"$f":"IF(C69:C74 = \"FULLY MET\",1,IF(C69:C74 = \"PARTIALLY MET\",0.5,IF(C69:C74 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"}]
["B2","Decision Maker - Demonstrates a confident approach to decision-making and prioritisation, thus gaining the confidence of others.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Skilled Negotiator - Open, approachable and is able to build trust with others. Consults and seeks the views of others and values diversity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Collaborative - Behaves in a collaborative way with other internal and external stakeholders. Promotes a team spirit and actively demonstrates professional competence in all settings and situations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Resilient - Has the ability to adapt to different, changing and challenging situations whilst promoting the highest professional standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Challenger - Is willing to ask difficult questions whilst demonstrating an ethical, fair and consistent approach. Offers a business perspective and supports discussion and debate with professional knowledge and evidence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J74)","v":0},"Net Score",{"$f":"SUM(L23:L74)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J77/L81","v":0},"total CoE KSB coverage",{"$f":"L77/L84","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",38]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",8]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L81-L82-(L83*0.5)","v":34}]

{"sheet":"ST0762","index":4,"n_rows":82,"n_cols":18,"rows_kept":82,"cut":false,"hidden":false,"merged":[[9,0,9,6],[9,8,9,15],[10,8,11,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",null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["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,"Information Manager (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","Regulations, data protection, protocols, standards, and guidelines relating to effective management and control of information and how they are applied in the organisation",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","Understanding of the concept of the Common Data Environment (CDE) as the primary source of information used by stakeholders to collect, manage and disseminate information, whether this is through one or multiple systems of record",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Information storage and exchange processes, systems and outputs within a team and across a project and asset. Principles of the mechanisms for formal and informal information distribution, whether this is complex models (such as 3D) or documentation/data (using mechanisms like COBie), use of workflow for digital delivery of information through business processes, and information types and how/where these are stored",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The details and implications of security accreditation, ISO27001, PAS 1192 Part 5 and industry specific requirements such as List N (Nuclear) and List X (Defence) and information classification such as sensitive and classified",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","How to design and implement project management and asset management systems incorporating specification of requirement, definition of process, configuration and approach",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Types and styles of communication and business reports, presentations and training events",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Basic engineering, construction, asset, procurement and operational systems and the role they play in the execution of projects and how information flows between these systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Understanding of information standards as they relate to implementation and compliance of requirements and how these might impact systems that manage the CDE",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Range of solutions and formats for the design, procurement, creation, building, operation, storage, validation, dissemination, inter-operability and merging of information and to provide secure access and integration",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Line management practice and principle and how they are applied in the organisation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Estimation and budget management techniques that ensure income and expenditure",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Processes to securely hand over information in a manner that supports the future management of the asset",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Scope of responsibilities for the management of information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Practice and principle of allocation of duties and work scheduling and how they operate in the organisation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Contractual and commercial implications relating to the management of information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Principles of risk management and processes for mitigating risk",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Concept of information planning, what is required and at what lifecycle stage",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Supply chain competency assessment to meet information delivery requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The importance of reflection and evaluation of own work and their impact on the organisation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Proficiently apply regulations including data protection, standards, guidelines and quality requirements as they pertain to information process and output",null,null,null,null,null,null,{"$f":"IF(C42:C60 = \"FULLY MET\",1,IF(C42:C60 = \"PARTIALLY MET\",0.5,IF(C42:C60 = \"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","Assist with the operation and maintenance of a Common Data Environment (CDE) and ensure the (CDE) maintains integrity and follows agreed protocols and that data remains secure",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","Establish processes and accurately analyse, audit, verify and validate data as being accurate, appropriate, attributable, authentic and relevant according to protocols",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"}]
["S4","Evaluate and make recommendations around information work processes, quality improvement and future resource planning for information management requirements",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"FULL"}]
["S5","Identify and manage risk, put in place mitigating actions to minimise risk data integrity and security",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J46=1,1,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=1,\"NONE\",IF(L46=0.5,\"PARTIAL\",IF(L46=0,\"FULL\")))","v":"FULL"}]
["S6","Draft work plans, strategies, delegate responsibilities and work instructions defining the scope of information management that comply with aims, objectives, planned milestones and organisation procedure",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J47=1,0.5,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},{"$f":"IF(L47=0.5,\"NONE\",IF(L47=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S7","Validate, manage, disseminate and store information throughout all stages of a project or asset",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["S8","Design and embed consistent data control processes and workflows accounting for status, maturity, version control, revision control, audit history and approval processes",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","Advise on the implications of security accreditation, ISO27001, PAS 1192 Part 5 and industry specific requirements such as List N (Nuclear) and List X (Defence) and information classification",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"}]
["S10","Establish and consistently implement project and asset systems including specification requirements, definition of processes, configuration and appropriate training plans",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","Prepare and deliver timely, accurate and clear written and verbal reports",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","Define and implement solutions to information sharing and storage problems",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"}]
["S13","Evaluate requirements and provide solutions for embedding contractual and regulatory requirements",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"}]
["S14","Define and manage processes for staged and progressive handover of information and structured formats in line with delivery schedules, duly verified to meet quality acceptability requirements",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"}]
["S15","Effectively use a range of solutions and formats for the creation, dissemination, storage, validation and merging of information, ensuring secure access and effective integration",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"}]
["S16","Prepare and deliver effective training on information management to internal and external stakeholders, monitor the effectiveness of this training and reflect on feedback to inform continuous quality improvement within the scope of responsibility",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"}]
["S17","Estimate resources, manpower and associated costs to ensure compliance with baseline and changes to scope for future development and innovation requirements",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"}]
["S18","Apply principles of effective line management in line with organisation practice",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"}]
["S19","Reflect and evaluate own work and its impact on the organisation to plan for improved performance",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J60=1,0.5,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=0.5,\"NONE\",IF(L60=0,\"PARTIAL\"))","v":"PARTIAL"}]
[null,"Behaviours"]
["B1","Act professionally, show commitment to the industry and employer and work collaboratively across multiple disciplines",null,null,null,null,null,null,{"$f":"IF(C62:C72 = \"FULLY MET\",1,IF(C62:C72 = \"PARTIALLY MET\",0.5,IF(C62:C72 = \"NOT MET\",0,)))","v":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"}]
["B2","Demonstrate analytical skills to effectively solve problems",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"}]
["B3","Establish and maintain effective relationships with clients, internal and external stakeholders and colleagues at all levels",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J64=1,0.5,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=0.5,\"NONE\",IF(L64=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B4","Demonstrate a commitment to equality, diversity and inclusion, and act ethically with integrity and respect",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=1,\"NONE\",IF(L65=0.5,\"PARTIAL\",IF(L65=0,\"FULL\")))","v":"FULL"}]
["B5","Committed to lead, manage and coach others effectively",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Maintain a focus on the end result and be flexible while adopting a lean and agile approach",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Foster a safe, secure and healthy working environment through personal responsibility and behaviour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Effective self-manage, prioritise and proactively approach work and continuous professional development",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"}]
["B9","Flexible to changing working environment and demands, resilient under pressure",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B10","Adopt a reflective approach to evaluating own work and its impact on the organisation to plan for improved performance",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"}]
["B11","Maintain an open mind, be inquisitive and apply learning to take advantage of innovation and new methods of working",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J72=1,1,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=1,\"NONE\",IF(L72=0.5,\"PARTIAL\",IF(L72=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J72)","v":0},"Net Score",{"$f":"SUM(L22:L72)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J75/L79","v":0},"total CoE KSB coverage",{"$f":"L75/L82","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",49]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",9]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L79-L80-(L81*0.5)","v":44.5}]

{"sheet":"ST0809","index":5,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":false,"merged":[[9,0,9,6],[9,8,9,15],[10,8,11,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",null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["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,"Coaching Professional (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","Theories of learning and reflective practice such as Kolb, Gibbs, Schon, etc., and basic schools of psychology and neuroscience, including linguistic interpretation and application",null,null,null,null,null,null,{"$f":"IF(C22:C33 = \"FULLY MET\",1,IF(C22:C33 = \"PARTIALLY MET\",0.5,IF(C22:C33 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The theories of emotional and social intelligence, such as Goleman and Salovey & Mayer, and application of the theories to understanding self",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Diversity and inclusion and bias theory, including personality type theories, such as preferences for introversion vs extroversion, integrity, ontology and human values and how they impact on behaviour and organisations. The theory of self actualisation, such as Maslow’s Hierarchy of needs, motivational theory, Herzberg",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The importance of coaching contracting and recontracting, and models enabling its effectiveness",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The theory of organisational culture (and values) and leadership styles, and the impact these can have on individuals and their behaviour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Coaching theory, including maintaining good practice coaching protocols and a code of conduct within the coaching process (including \"unconditional positive regard\", non-judgmentalism and non-directiveness)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Methods of communication including verbal / non-verbal / building rapport / matching and mirroring. Listening skills, including levels of listening. Theories of relationship management, including transactional analysis, power dynamics, and stakeholder management theories",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Theories of increasing self-awareness such as the Johari Window and the journey from unconscious incompetence to unconscious competence, and types of feedback",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Evaluation: theories of return on investment and delivery of value",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The differences and similarities between coaching, mentoring, training, counselling and consulting",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Relevant legislation (e.g. Data Protection Act, safeguarding) and coaching competencies and codes of ethics described by the main professional bodies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The existence of a range of coaching models and techniques, and related psychological approaches, such as Whitmore’s GROW model, Kline’s Thinking Environment, Gestalt, neurolinguistic programming (NLP), cognitive behavioural coaching, positive psychology, metaphor, solutions-focussed coaching and skills and performance coaching. Methods of goal setting, such as SMART goals, alignment of personal and organisational goals, and aspirational/dream goals",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Time management, including scheduling coaching sessions, and self-leadership to resolve conflicting priorities and ensure sufficient time for record keeping and other role activities",null,null,null,null,null,null,{"$f":"IF(C35:C49 = \"FULLY MET\",1,IF(C35:C49 = \"PARTIALLY MET\",0.5,IF(C35:C49 = \"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"}]
["S2","Working with those receiving coaching to set clear goals, including visualisation techniques, setting timescales, validating their achievability, recording outcome-focused, prioritised action plans and monitoring progress towards goals",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J36=1,1,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=1,\"NONE\",IF(L36=0.5,\"PARTIAL\",IF(L36=0,\"FULL\")))","v":"FULL"}]
["S3","Communication, including (but not limited to) descriptions of the coaching process and roles and responsibilities (including those related to boundaries and confidentiality), and the benefits of coaching in relation to the context of those receiving coaching",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"}]
["S4","Contracting with all relevant stakeholders, including logistics, preferences of the coach and those receiving coaching, considerations of the system within which the coaching relationship sits, goal setting, outcome realisation and contract conclusion. This includes holding oneself to high ethical standards, particularly in the areas of confidentiality (including when maintaining coaching records) and management of boundaries (including their own competence and values, relevant codes of ethics, and relevant legislation, policies and procedures)",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"}]
["S5","Stakeholder management, including a range of challenging and senior people, and focus on their agenda and outcomes throughout",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J39=1,0.5,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=0.5,\"NONE\",IF(L39=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S6","Rapport/trust building and maintenance, including recognition of the personal values, emotional state(s) and response of those receiving coaching, validating their understanding of themselves and their circumstances, dealing with difficult coaching relationships and ensuring non-dependence on the coach",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J40=1,0.5,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=0.5,\"NONE\",IF(L40=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S7","Deliver feedback in a style that is useful, acceptable, non-judgmental and meaningful to those receiving coaching",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J41=1,1,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=1,\"NONE\",IF(L41=0.5,\"PARTIAL\",IF(L41=0,\"FULL\")))","v":"FULL"}]
["S8","Identification of patterns of thinking and limiting/enabling beliefs and actions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Questioning techniques to raise the self-awareness of those receiving coaching, including asking open questions, broaching challenging subject areas (e.g. emotional state, characteristics of wider systems) and questioning untrue, limiting assumptions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Uses several established tools and techniques to develop their own coherent model of coaching to help those receiving coaching work towards outcomes. Uses models and approaches from the context of those receiving coaching",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Demonstrates emotional intelligence, including demonstrating empathy and genuine support for those receiving coaching (\"unconditional positive regard\"), and adapting language and behaviour in response to the whole person of those receiving coaching",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Applies coaching theories, models and tools, techniques and ideas beyond the core communication skills in order to bring about insight and learning",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Identifies energy shifts within a coaching context, enabling these to be aired and addressed and managed",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Manages and celebrates diversity in their coaching practice, including demonstrating how diversity and inclusion informs their professional practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Demonstrates awareness of own values, beliefs and behaviours; recognises how these affect their practice and uses this self-awareness to manage their effectiveness in meeting the objectives of those receiving coaching and, where relevant, the sponsor",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Committed to self-development, including self-reflection, gathering information on the effectiveness of their own practice, producing personal development plans and receiving coach supervision",null,null,null,null,null,null,{"$f":"IF(C51:C54 = \"FULLY MET\",1,IF(C51:C54 = \"PARTIALLY MET\",0.5,IF(C51:C54 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
["B2","Self-awareness, including of their own behaviours, values, beliefs and attitudes, and attending to their own wellbeing, resilience and maintaining mental capacity",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"}]
["B3","Act as an ambassador for a coaching mindset and positive approach to personal development",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"}]
["B4","Is spontaneous, open and flexible, demonstrating respect and engendering trust",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"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J54)","v":0},"Net Score",{"$f":"SUM(L22:L54)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J57/L61","v":0},"total CoE KSB coverage",{"$f":"L57/L64","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",31]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L61-L62-(L63*0.5)","v":29.5}]

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