{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["GUIDE TO KSB MAPPING","ST0041","ST0043","ST0046","ST0048","ST0049","ST0484","ST0613","ST0629","ST0877","ST0936","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":"ST0041","index":1,"n_rows":76,"n_cols":18,"rows_kept":76,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Building services engineering senior technician (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","Engineering principles, underpinned by relevant scientific, theoretical and technical knowledge and understanding to solve well-defined building services engineering problems",null,null,null,null,null,null,{"$f":"IF(C22:C41 = \"FULLY MET\",1,IF(C22:C41 = \"PARTIALLY MET\",0.5,IF(C22:C41 = \"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","Building services engineering techniques, procedures and methods used for building services engineering systems, to either measure and test, design, install, commission, maintain or operate",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},"FULL"]
["K3","Advanced mathematical, statistical and analytical problem-solving tools",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Properties of, and selection criteria for materials, components or parts used in building services solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Techniques and methods to collect data and technical information for analysis and evaluation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Design principles and control processes used in the building services engineering consultancy, construction or manufacturing process, and the common constraints faced",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Technical drawings, designs, and models, using analytical and computer-based software packages",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Uses and limitations of computational and digital models, including Building Information Modelling (BIM)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Industry policies, standards, regulations and legislation, and codes of practice, including Building Safety legislation or BSI Flex 8670",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Statutory health, safety and welfare policies, procedures, and regulations including Construction (Design and Management) (CDM)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Risk assessment and mitigation processes, and their importance in the building services environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Principles of sustainable development and their impact on the lifecycle of building services engineering solutions, including United Nations Sustainable Development Goals (UNSDG), net-zero carbon emissions, environmental policies and legislations, and the climate change act",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Project management techniques, including quality and information management and assurance systems and continuous improvement processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Methods for planning and resourcing building services engineering tasks, and the impact on cost, quality, safety, security, and environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Methods of communication and when to use them, using appropriate engineering terminology and conventions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Roles and responsibilities within the organisation, team dynamics and their own boundaries of authority",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Relationships between key organisations in the building services engineering sector (for example organisations, customers, partners and suppliers)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Equality, diversity and inclusion, its importance and impact on building services engineering solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Ethical principles as applied to building services engineering including the need for security of data and information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Methods to maintain professional competence and technical knowledge including initial professional development (IPD) and continuing professional development (CPD)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply engineering principles, using relevant scientific, theoretical and technical know-how to solve well-defined building services engineering problems",null,null,null,null,null,null,{"$f":"IF(C43:C59 = \"FULLY MET\",1,IF(C43:C59 = \"PARTIALLY MET\",0.5,IF(C43:C59 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J43=1,1,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},"FULL"]
["S2","Apply building services engineering techniques, procedures and methods, and review the results, when measuring and testing, designing, installing, commissioning, maintaining or operating building services engineering systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Employ a range of advanced mathematical, statistical and data interpretation tools, using analytical and computational methods to interpret and solve well-defined building services engineering problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Interpret and compare performance information to choose compliant materials, components or parts",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Select and use technical literature and other sources of information and data to address well-defined building services engineering problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Produce and interpret building services engineering technical drawings, designs, and models, using analytical and computer-based software packages, recognising the limitations of the software used",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Produce building services engineering technical solutions in accordance with relevant industry standards, procedures, codes of practice, regulations, and legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Comply with, and encourage others to demonstrate, statutory health, safety and welfare policies, procedures and regulation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Complete risk assessments to identify, evaluate and mitigate risks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Apply principles of sustainable development, and assess the impact of these in their work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Employ project management techniques, measuring and recording progress against building services engineering project plans",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Assess and report on quality using appropriate management and assurance systems and continuous improvement processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Identify and use resources, equipment and technology to meet project requirements, including specifications, budget and timescales",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Monitor and manage individual performance, and supervise others, recognising the need to comply with appropriate codes of practice and equality, diversity & inclusion (EDI) requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Communicate using appropriate methods for the audience, using appropriate engineering terminology and conventions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Apply ethical principles to building services engineering projects, including the secure use of data and information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Plan, undertake and review their own professional competence, updating and reviewing their CPD to improve performance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Works to health, safety and welfare requirements, industry standards, statutory regulation and legislation, policies, and codes of practice, and ensuring others do likewise",null,null,null,null,null,null,{"$f":"IF(C61:C66 = \"FULLY MET\",1,IF(C61:C66 = \"PARTIALLY MET\",0.5,IF(C61:C66 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J61=1,1,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},"FULL"]
["B2","Makes independent decisions when delivering building services engineering projects, whilst knowing their own limitations and when to ask for help or to escalate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Works individually and as part of a team, being aware of their actions and the impact they may have on others, and demonstrating awareness of diversity and inclusion issues so as to meet the requirement of fairness at work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Solves problems with attention to detail, accuracy, and diligence, and seeks to continually improve",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Maintains professional and ethical working relationships with internal, external, and other stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Takes responsibility for their own professional development, seeking opportunities to enhance their knowledge, skills, and experience, and support others when requested",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J66)","v":0},"Net Score",{"$f":"SUM(L22:L66)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J69/L73","v":0},"total CoE KSB coverage",{"$f":"L69/L76","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",43]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L73-L74-(L75*0.5)","v":43}]

{"sheet":"ST0043","index":2,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Construction Design and Build Technician (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","Client Requirements - Know how to analyse client requirements and ensure comprehensive survey information",null,null,null,null,null,null,{"$f":"IF(C22:C29 = \"FULLY MET\",1,IF(C22:C29 = \"PARTIALLY MET\",0.5,IF(C22:C29 = \"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","Health and Safety - Understand risk assessment of design solutions and the importance of behaviours in safety-critical environments",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},"FULL"]
["K3","Sustainability - Understand the sustainability issues in projects across economic, social and environmental aspects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Construction Technology - Understand different construction methods and materials and building regulations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Develop Designs - Understand how to develop detailed designs in line with client requirements and construction process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Design Documentation - Understand how to co-ordinate design information in both electronic and paper form",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Monitor Compliance - Understand construction contracts and client quality standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Monitor Costs - Understand the importance of cost control on a construction project",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Client Requirements - Assist in the assessment and presentation of client requirements",null,null,null,null,null,null,{"$f":"IF(C31:C38 = \"FULLY MET\",1,IF(C31:C38 = \"PARTIALLY MET\",0.5,IF(C31:C38 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J31=1,1,IF(J31=0.5,0.5,IF(J31=0,0)))","v":0},"FULL"]
["S2","Health and Safety - Identify risk in designs and suggest actions to reduce risks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Sustainability - Assess, identify and record the environmental impact of projects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Construction Technology - Assist in the implementation of the most appropriate solutions for construction projects whilst maintaining adherence to building regulations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Develop Designs - Prepare and present design proposals and solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Design Documentation - Control document production and design information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Monitor Compliance - Inspect and report on quality standards and assist in commissioning of finished construction projects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Monitor Costs - Understand financial and legal constraints and measure and record progress against budget",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Professional Judgement - Be able to work within own level of competence and know when to seek advice from others",null,null,null,null,null,null,{"$f":"IF(C40:C46 = \"FULLY MET\",1,IF(C40:C46 = \"PARTIALLY MET\",0.5,IF(C40:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J40=1,1,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},"FULL"]
["B2","Commitment to Code of Ethics - Understand and apply the Code of Conduct and conduct regulations, ethics and professional standards relevant to industry’s recognised professional bodies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Continuing Professional Development - Identify own development needs and take action to meet those needs. Use own knowledge and expertise to help others when requested.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J42=1,0.5,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=0.5,\"NONE\",IF(L42=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B4","Commitment to Equality and Diversity - Understand the importance of equality and diversity and demonstrate these attributes so as to meet the requirements of fairness at work.",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},"FULL"]
["B5","Communicate Effectively - Be able to contribute effectively to meetings and present information in a variety of ways including oral and written.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Work in Teams - Be able to work with others in a collaborative and non-confrontational way.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Demonstrate Innovation - Be able to identify areas for improvement and suggest innovative solutions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J46)","v":0},"Net Score",{"$f":"SUM(L22:L46)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J49/L53","v":0},"total CoE KSB coverage",{"$f":"L49/L56","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",23]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L53-L54-(L55*0.5)","v":22.5}]

{"sheet":"ST0046","index":3,"n_rows":76,"n_cols":18,"rows_kept":76,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Civil engineering senior technician (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","Engineering principles, underpinned by relevant scientific, theoretical and technical knowledge and understanding to solve well-defined civil engineering problems",null,null,null,null,null,null,{"$f":"IF(C22:C41 = \"FULLY MET\",1,IF(C22:C41 = \"PARTIALLY MET\",0.5,IF(C22:C41 = \"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","Civil engineering techniques, procedures and methods used for civil engineering systems, to either measure and test, design, install, commission, maintain or operate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Advanced mathematical, statistical and analytical problem-solving tools",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Properties of, and selection criteria for materials, components or parts used in civil engineering solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Techniques and methods to collect data and technical information, to analyse and evaluate civil engineering problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Design principles and control processes used in the civil engineering consultancy, construction or manufacturing process, and the common constraints faced",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Technical drawings, designs, and models, using analytical and computer-based software packages",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Uses and limitations of computational and digital models, including Building Information Modelling (BIM)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Industry policies, standards, regulations and legislation, and codes of practice, including Building Safety legislation, Construction (Design and Management) (CDM) or Design Manual for Roads and Bridges (DMRB)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Statutory health, safety and welfare policies, procedures, and regulations including the Construction (Design and Management) regulation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Risk assessment and mitigation processes, and their importance in the civil engineering environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Principles of sustainable development and their impact on the lifecycle of civil engineering solutions, including United Nations Sustainable Development Goals (UNSDG), net-zero carbon emissions, environmental policies and legislations, and the climate change act",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Project management techniques, including quality and information management and assurance systems and continuous improvement processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Methods for planning and resourcing civil engineering tasks, and the impact on cost, quality, safety, security, and environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Methods of communication and when to use them, using appropriate engineering terminology and conventions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Roles and responsibilities within the organisation, team dynamics and their own boundaries of authority",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Relationships between key organisations in the civil engineering sector (for example organisations, customers, partners and suppliers)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Equality, diversity and inclusion, its importance and impact on civil engineering solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Ethical principles as applied to civil engineering including the need for the confidentiality and security of data and information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Methods to maintain professional competence and technical knowledge including initial professional development (IPD) and continuing professional development (CPD)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply engineering principles, using relevant scientific, theoretical and technical know-how to solve well-defined civil engineering problems",null,null,null,null,null,null,{"$f":"IF(C43:C59 = \"FULLY MET\",1,IF(C43:C59 = \"PARTIALLY MET\",0.5,IF(C43:C59 = \"NOT MET\",0,)))","v":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"}]
["S2","Apply civil engineering techniques, procedures and methods, and review the results, when measuring and testing, designing, installing, commissioning, maintaining or operating civil engineering systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Employ a range of advanced mathematical, statistical and data interpretation tools, using analytical and computational methods to interpret and solve civil engineering problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Interpret and compare performance information to choose compliant materials, components or parts",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Select and use technical literature and other sources of information and data to address well-defined civil engineering problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Produce and interpret civil engineering technical drawings, designs, and models, using analytical and computer-based software packages, recognising the limitations of the software used",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Produce civil engineering technical solutions in accordance with relevant industry standards, procedures, codes of practice, regulations, and legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Comply with, and encourage others to demonstrate, statutory health, safety and welfare policies, procedures and regulation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Complete risk assessments to identify, evaluate and mitigate risks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Apply principles of sustainable development, and assess the impact of these in their work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Employ project management techniques, measuring and recording progress against civil engineering project plans",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Assess and report on quality using appropriate management and assurance systems and continuous improvement processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Identify and use resources, equipment and technology to meet project requirements, including specifications, budget and timescales",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Monitor and manage individual performance, and supervise others, recognising the need to comply with appropriate codes of practice and equality, diversity & inclusion (EDI) requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Communicate using appropriate methods for the audience, using appropriate engineering terminology and conventions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Apply ethical principles to civil engineering projects, including the secure use of data and information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Plan, undertake and review their own professional competence, updating and reviewing their CPD to improve performance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Works to health, safety and welfare requirements, industry standards, statutory regulation and legislation, policies, and codes of practice, and ensuring others do likewise",null,null,null,null,null,null,{"$f":"IF(C61:C66 = \"FULLY MET\",1,IF(C61:C66 = \"PARTIALLY MET\",0.5,IF(C61:C66 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J61=1,1,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=1,\"NONE\",IF(L61=0.5,\"PARTIAL\",IF(L61=0,\"FULL\")))","v":"FULL"}]
["B2","Makes independent decisions when delivering civil engineering projects, whilst knowing their own limitations and when to ask for help or to escalate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Works individually and as part of a team, being aware of their actions and the impact they may have on others, and demonstrating awareness of diversity and inclusion issues so as to meet the requirement of fairness at work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Solves problems with attention to detail, accuracy, and diligence, and seeks to continually improve",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Maintains professional and ethical working relationships with internal, external, and other stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Takes responsibility for their own professional development, seeking opportunities to enhance their knowledge, skills, and experience, and support others when requested",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J66)","v":0},"Net Score",{"$f":"SUM(L22:L66)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J69/L73","v":0},"total CoE KSB coverage",{"$f":"L69/L76","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",43]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L73-L74-(L75*0.5)","v":43}]

{"sheet":"ST0048","index":4,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Construction Site Supervisor (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","Health and Safety - Understand risk assessment of activities and the importance of behaviours in safety-critical environments",null,null,null,null,null,null,{"$f":"IF(C22:C28 = \"FULLY MET\",1,IF(C22:C28 = \"PARTIALLY MET\",0.5,IF(C22:C28 = \"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","Sustainability - Understand the sustainability issues in projects across economic, social and environmental aspects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Construction Technology - Understand different construction methods and materials",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Construction Management - Understand management principles and the project management lifecycle",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Planning and Organising Work - Understand the importance of project planning and resourcing and be able to analyse different techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Monitor Quality - Able to define the quality required on a finished construction project",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Monitor Costs - Understand the importance of cost control on a construction project",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Health and Safety - Identify risk of activities and encourage all employees to demonstrate safety-conscious behaviours",null,null,null,null,null,null,{"$f":"IF(C30:C36 = \"FULLY MET\",1,IF(C30:C36 = \"PARTIALLY MET\",0.5,IF(C30:C36 = \"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"}]
["S2","Sustainability - Assess, identify and record the environmental impact of projects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Construction Technology - Assist in the implementation of the most appropriate solutions for construction projects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Project Management - Use effective management principles and be able to supervise construction workers",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J33=1,0.5,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},{"$f":"IF(L33=0.5,\"NONE\",IF(L33=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Planning and Organising Work - Understand overall plan for project and measure and record progress against plan",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"}]
["S6","Monitor Quality - Assess and report on quality standards and assist in commissioning of finished construction projects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Monitor Costs - Understand financial and legal constraints and measure and record progress against budget ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Professional Judgement - Be able to work within own level of competence and know when to seek advice from others",null,null,null,null,null,null,{"$f":"IF(C38:C44 = \"FULLY MET\",1,IF(C38:C44 = \"PARTIALLY MET\",0.5,IF(C38:C44 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J38=1,1,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=1,\"NONE\",IF(L38=0.5,\"PARTIAL\",IF(L38=0,\"FULL\")))","v":"FULL"}]
["B2","Commitment to Code of Ethics - Work within Rules and Regulations of Professional Competence and Conduct for the industry’s recognised professional bodies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Continuing Professional Development - Identify own development needs and take action to meet those needs. Use own knowledge and expertise to help others when requested.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Commitment to Equality and Diversity - Understand the importance of equality and diversity and demonstrate these attributes so as to meet the requirements of fairness at work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Communicate Effectively - Be able to contribute effectively to meetings and present information in a variety of ways including oral and written.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Work in Teams - Be able to work with others in a collaborative and non-confrontational way.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Demonstrate Innovation - Be able to identify areas for improvement and suggest innovative solutions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J44)","v":0},"Net Score",{"$f":"SUM(L22:L44)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J47/L51","v":0},"total CoE KSB coverage",{"$f":"L47/L54","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",21]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L51-L52-(L53*0.5)","v":20.5}]

{"sheet":"ST0049","index":5,"n_rows":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Construction Quantity Surveying Technician (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","Health and Safety - Understand the principles and responsibilities imposed by law and other regulations in a construction environment",null,null,null,null,null,null,{"$f":"IF(C22:C28 = \"FULLY MET\",1,IF(C22:C28 = \"PARTIALLY MET\",0.5,IF(C22:C28 = \"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","Sustainability - Understand the sustainability issues in projects across economic, social and environmental aspects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Construction Technology - Understand different construction techniques and materials and the principles of design",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Contracts - Understand different forms of contracts used in construction and why they are applied in different situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Procurement - Understand the different types of procurement process and negotiation requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Cost control - Understand the importance of controlling costs during a construction project and the effect of changes to the project",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Financial reporting - Understand the various forms of reporting on project progress",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Health and Safety - Apply health and safety issues to all activities",null,null,null,null,null,null,{"$f":"IF(C30:C37 = \"FULLY MET\",1,IF(C30:C37 = \"PARTIALLY MET\",0.5,IF(C30:C37 = \"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"}]
["S2","Sustainability - Demonstrate application of the principles of sustainability",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Construction Technology - Assist in the implementation of the most appropriate solutions for construction projects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Contracts - Be able to apply different types of contracts to different situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Procurement - Assist in the selection of and negotiation with specialist contractors for a construction project",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J34=1,0.5,IF(J34=0.5,0.5,IF(J34=0,0)))","v":0},{"$f":"IF(L34=0.5,\"NONE\",IF(L34=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S6","Cost control - Assist in the measurement and costing of construction works during a project.",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"}]
["S7","Financial reporting - Assist in the preparation of financial reports, cash flow and cost forecasts for a construction project",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Administration - Assist in the collection, collation and storage of relevant data and its analysis",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Commitment to Code of Ethics - Understand and apply the Code of Conduct and conduct regulations, ethics and professional standards relevant to industry’s recognised professional bodies.",null,null,null,null,null,null,{"$f":"IF(C39:C45 = \"FULLY MET\",1,IF(C39:C45 = \"PARTIALLY MET\",0.5,IF(C39:C45 = \"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"}]
["B2","Continuing Professional Development - Identify own development needs and take action to meet those needs. Use own knowledge and expertise to help others when requested.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Commitment to Equality and Diversity - Understand the importance of equality and diversity and demonstrate these attributes so as to meet the requirements of fairness at work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Communicate Effectively - Be able to contribute effectively to meetings and present information in a variety of ways including oral and written.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Conflict avoidance - Be able to assist in planning to avoid conflict and resolving issues that do arise",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Work in Teams - Be able to work with others in a collaborative and non-confrontational way.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Demonstrate Innovation - Be able to identify areas for improvement and suggest innovative solutions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J45)","v":0},"Net Score",{"$f":"SUM(L22:L45)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J48/L52","v":0},"total CoE KSB coverage",{"$f":"L48/L55","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",22]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L52-L53-(L54*0.5)","v":21.5}]

{"sheet":"ST0484","index":6,"n_rows":95,"n_cols":18,"rows_kept":95,"cut":false,"hidden":false,"merged":[[9,0,9,6],[21,0,21,6],[83,0,83,6],[71,0,71,6],[73,0,73,6],[79,0,79,6],[27,0,27,6],[81,0,81,6],[41,0,41,6],[37,0,37,6],[31,0,31,6],[35,0,35,6],[46,0,46,6],[54,0,54,6],[56,0,56,6],[58,0,58,6],[50,0,50,6],[75,0,75,6],[77,0,77,6],[60,0,60,6],[62,0,62,6],[64,0,64,6],[66,0,66,6],[68,0,68,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Facilities 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"]
["Property Asset management"]
["K1","Implications of property ownership",null,null,null,null,null,null,{"$f":"IF(C23:C27 = \"FULLY MET\",1,IF(C23:C27 = \"PARTIALLY MET\",0.5,IF(C23:C27 = \"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","Establishment & management of registers for property & fixed assets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Principles of building design; the features of building, fabric, structures and components and their implications for maintenance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Relocation requirements & factors involved",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Layout, flow management & space planning techniques; accessibility & inclusion",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Service Delivery"]
["K6","Principles of contract management",null,null,null,null,null,null,{"$f":"IF(C29:C31 = \"FULLY MET\",1,IF(C29:C31 = \"PARTIALLY MET\",0.5,IF(C29:C31 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J29=1,1,IF(J29=0.5,0.5,IF(J29=0,0)))","v":0},"FULL"]
["K7","Problem solving techniques, prevention measures, corrective actions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Management of sub-contractors (management systems for contractors & specialists, e.g. security & access, performance management, H&S briefings)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Compliance"]
["K9","Regulatory frameworks, health and safety, client requirements, statutory legislation and FM industry best practice; sustainability and corporate responsibility",null,null,null,null,null,null,{"$f":"IF(C33:C35 = \"FULLY MET\",1,IF(C33:C35 = \"PARTIALLY MET\",0.5,IF(C33:C35 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J33=1,1,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},"FULL"]
["K10","The impact of FM on the environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Principles of risk management; business continuity planning",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Management systems"]
["K12","FM data capture, analysis & management techniques; types, capabilities and limitations of FM IT systems e.g. of building management services; requirements of ISO 41001 (international FM standard)",null,null,null,null,null,null,{"$f":"IF(C37 = \"FULLY MET\",1,IF(C37 = \"PARTIALLY MET\",0.5,IF(C37 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J37=1,1,IF(J37=0.5,0.5,IF(J37=0,0)))","v":0},"FULL"]
["Policy implementation and change management"]
["K13","FM organizational and service requirements, targets & objectives",null,null,null,null,null,null,{"$f":"IF(C39:C41 = \"FULLY MET\",1,IF(C39:C41 = \"PARTIALLY MET\",0.5,IF(C39:C41 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J39=1,1,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},"FULL"]
["K14","Change management techniques (e.g. agile v waterfall; developing work processes, procedures, systems, structures & roles)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Principles of project management (tools & methods for planning, monitoring & managing an FM project; process-based methodologies; project stages)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Quality and stakeholder management"]
["K16","Quality management in FM",null,null,null,null,null,null,{"$f":"IF(C43:C46 = \"FULLY MET\",1,IF(C43:C46 = \"PARTIALLY MET\",0.5,IF(C43:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J43=1,1,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},"FULL"]
["K17","Client objectives, requirements & value; Service Level Agreements (SLAs)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Survey & benchmarking techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Uses of customer feedback; principles of continuous improvement; influencing techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["People management"]
["K20","Ways of recording and tracking human resources capabilities",null,null,null,null,null,null,{"$f":"IF(C48:C50 = \"FULLY MET\",1,IF(C48:C50 = \"PARTIALLY MET\",0.5,IF(C48:C50 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},"FULL"]
["K21","The impact of change on people HR-related legislation affecting FM",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Capability building, HR tools and techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Financial and procurement management"]
["K23","Financial/budget/resource management & reporting systems and processes & techniques",null,null,null,null,null,null,{"$f":"IF(C52:C53 = \"FULLY MET\",1,IF(C52:C53 = \"PARTIALLY MET\",0.5,IF(C52:C53 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J52=1,1,IF(J52=0.5,0.5,IF(J52=0,0)))","v":0},"FULL"]
["K24","Accountability within delegated financial authorities Organizational procurement policies and processes & client objectives and requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["Property Asset management"]
["S1","Manage property and fixed assets and implement building maintenance plans (monitor and control premises; optimize the use of space; evaluate the effectiveness of the implementation of a property management plan)",null,null,null,null,null,null,{"$f":"IF(C56 = \"FULLY MET\",1,IF(C56 = \"PARTIALLY MET\",0.5,IF(C56 = \"NOT MET\",0,)))","v":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"}]
["Service Delivery"]
["S2","Ensure the delivery of FM service provision to required standards and identify opportunities for improvement (identify requirements; identify opportunities for improvements; identify and rectify FM service delivery problems)",null,null,null,null,null,null,{"$f":"IF(C58 = \"FULLY MET\",1,IF(C58 = \"PARTIALLY MET\",0.5,IF(C58 = \"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"}]
["Compliance"]
["S3","Meet FM compliance, risk and business continuity requirements (analyse the extent to which compliance, Corporate Social Responsibility (CSR) & sustainability requirements are met; carry out risk assessments; develop a Business Continuity Plan (BCP))",null,null,null,null,null,null,{"$f":"IF(C60 = \"FULLY MET\",1,IF(C60 = \"PARTIALLY MET\",0.5,IF(C60 = \"NOT MET\",0,)))","v":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"}]
["Management systems"]
["S4","Use FM management systems to monitor, report and act on the performance and efficiency of properties, assets and services against FM Key Performance Indicators (KPIs) (collate data; analyse statistics; maintain data security)",null,null,null,null,null,null,{"$f":"IF(C62 = \"FULLY MET\",1,IF(C62 = \"PARTIALLY MET\",0.5,IF(C62 = \"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"}]
["Policy implementation and change management"]
["S5","Develop and implement delivery plans for the management of FM properties, assets and services and manage change (carry out activities ethically and sustainably; identify operational impact of change; develop plans to mitigate negative impacts; manage expectations)",null,null,null,null,null,null,{"$f":"IF(C64 = \"FULLY MET\",1,IF(C64 = \"PARTIALLY MET\",0.5,IF(C64 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["Quality and stakeholder management"]
["S6","Establish and manage day-to-day relationships with clients and other stakeholders to agreed quality standards (develop and implement FM quality management operational plans; use appropriate stakeholder management methods; recommend improvements to the quality of FM service provision)",null,null,null,null,null,null,{"$f":"IF(C66 = \"FULLY MET\",1,IF(C66 = \"PARTIALLY MET\",0.5,IF(C66 = \"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"}]
["People management"]
["S7","Motivate, manage and develop FM teams to deliver operational objectives (deploy assets; assess and plan for individuals’ development needs; comply with Human Resources (HR) requirements)",null,null,null,null,null,null,{"$f":"IF(C68 = \"FULLY MET\",1,IF(C68 = \"PARTIALLY MET\",0.5,IF(C68 = \"NOT MET\",0,)))","v":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"}]
["Financial and procurement management"]
["S8","Manage FM finances and procure FM goods and services, ensuring they are delivered within agreed budgets and make recommendations for innovation (analyse financial information; develop operational plan and budget; manage budget variances; analyse the effectiveness of procurement practices)",null,null,null,null,null,null,{"$f":"IF(C70 = \"FULLY MET\",1,IF(C70 = \"PARTIALLY MET\",0.5,IF(C70 = \"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"}]
[null,"Behaviours"]
["Customer Focus"]
["B1","Exceed customer expectations and add value",null,null,null,null,null,null,{"$f":"IF(C73 = \"FULLY MET\",1,IF(C73 = \"PARTIALLY MET\",0.5,IF(C73 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J73=1,0.5,IF(J73=0.5,0.5,IF(J73=0,0)))","v":0},{"$f":"IF(L73=0.5,\"NONE\",IF(L73=0,\"PARTIAL\"))","v":"PARTIAL"}]
["Collaboration"]
["B2","Work in partnership with others for the common good",null,null,null,null,null,null,{"$f":"IF(C75 = \"FULLY MET\",1,IF(C75 = \"PARTIALLY MET\",0.5,IF(C75 = \"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"}]
["Influencing"]
["B3","Anticipating and responding to others’ needs and influencing them to enhance performance",null,null,null,null,null,null,{"$f":"IF(C77 = \"FULLY MET\",1,IF(C77 = \"PARTIALLY MET\",0.5,IF(C77 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J77=1,1,IF(J77=0.5,0.5,IF(J77=0,0)))","v":0},{"$f":"IF(L77=1,\"NONE\",IF(L77=0.5,\"PARTIAL\",IF(L77=0,\"FULL\")))","v":"FULL"}]
["Innovation & quality"]
["B4","Aim for a higher level of excellence",null,null,null,null,null,null,{"$f":"IF(C79 = \"FULLY MET\",1,IF(C79 = \"PARTIALLY MET\",0.5,IF(C79 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J79=1,1,IF(J79=0.5,0.5,IF(J79=0,0)))","v":0},{"$f":"IF(L79=1,\"NONE\",IF(L79=0.5,\"PARTIAL\",IF(L79=0,\"FULL\")))","v":"FULL"}]
["Ethics & integrity"]
["B5","Work for the greater good and not sacrifice high standards for immediate gain or personal benefit",null,null,null,null,null,null,{"$f":"IF(C81 = \"FULLY MET\",1,IF(C81 = \"PARTIALLY MET\",0.5,IF(C81 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J81=1,1,IF(J81=0.5,0.5,IF(J81=0,0)))","v":0},{"$f":"IF(L81=1,\"NONE\",IF(L81=0.5,\"PARTIAL\",IF(L81=0,\"FULL\")))","v":"FULL"}]
["Leading people"]
["B6","Foster the growth of themselves and others, inspiring them to exceed their personal and professional goal",null,null,null,null,null,null,{"$f":"IF(C83 = \"FULLY MET\",1,IF(C83 = \"PARTIALLY MET\",0.5,IF(C83 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J83=1,1,IF(J83=0.5,0.5,IF(J83=0,0)))","v":0},{"$f":"IF(L83=1,\"NONE\",IF(L83=0.5,\"PARTIAL\",IF(L83=0,\"FULL\")))","v":"FULL"}]
["Systematic approach"]
["B7","Approach work in an orderly way",null,null,null,null,null,null,{"$f":"IF(C85 = \"FULLY MET\",1,IF(C85 = \"PARTIALLY MET\",0.5,IF(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"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J85)","v":0},"Net Score",{"$f":"SUM(L23:L85)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J88/L92","v":0},"total CoE KSB coverage",{"$f":"L88/L95","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",39]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L92-L93-(L94*0.5)","v":37.5}]

{"sheet":"ST0613","index":7,"n_rows":59,"n_cols":18,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Acoustics technician (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The principles and responsibilities, imposed law and other regulations in acoustics engineering environments.",null,null,null,null,null,null,{"$f":"IF(C22:C31 = \"FULLY MET\",1,IF(C22:C31 = \"PARTIALLY MET\",0.5,IF(C22:C31 = \"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","Scientific principles that underpin acoustics including the transmission of sound through different materials and behaviour and control of sound.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Level 4 mathematics for undertaking hand and spreadsheet based acoustic calculations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The range of equipment used to measure sound and vibration including calibration and maintenance techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Sound and vibration measuring and recording techniques in laboratory, internal and external environments.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Sustainable practices in the design and manufacture of acoustic products.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Technical drawing using Computer Aided Design software packages.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Acoustic modelling software and methods and their use in the sector.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Technical report writing techniques for both internal and external audiences.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The standards and guidance applicable to acoustics practitioners (e.g. Approved Document E of the Building Regulations, Control of Pollution Act 1974, Building Bulletin 93: Acoustics Design of Schools).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Identify risk of activities and apply safe working practices both in laboratory and site environments.",null,null,null,null,null,null,{"$f":"IF(C33:C43 = \"FULLY MET\",1,IF(C33:C43 = \"PARTIALLY MET\",0.5,IF(C33:C43 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J33=1,0.5,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},{"$f":"IF(L33=0.5,\"NONE\",IF(L33=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Plan, measure, analyse and report acoustic data.",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"}]
["S3","Operate acoustic modelling software appropriate to their organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Operate Computer Aided Design software packages.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Calibrate, operate and maintain acoustic equipment to maintain the appropriate British Standards (e.g. BS EN 61672-2: 2014 Electroacoustics, Sound Level Meters).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Undertake acoustics calculations manually and using spreadsheets.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Apply standards and guidance in the context of acoustics including those related to the built environment, construction, and laboratory/on-site testing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Listen critically and interpret sound correctly.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Communicate effectively, contributing to meetings and presenting information in a variety of ways including oral and written.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Produce succinct and understandable reports for the end user.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Think critically, analyse and clearly present the outputs of acoustic information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Accuracy and diligence in practical work in both laboratory and site contexts.",null,null,null,null,null,null,{"$f":"IF(C45:C49 = \"FULLY MET\",1,IF(C45:C49 = \"PARTIALLY MET\",0.5,IF(C45:C49 = \"NOT MET\",0,)))","v":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"}]
["B2","Team working with others in a collaborative and non-confrontational way.",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"}]
["B3","Attention to detail in results outputs against standards, guidance and client briefs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Time management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Commitment to Equality and Diversity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J49)","v":0},"Net Score",{"$f":"SUM(L22:L49)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J52/L56","v":0},"total CoE KSB coverage",{"$f":"L52/L59","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",26]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L56-L57-(L58*0.5)","v":25}]

{"sheet":"ST0629","index":8,"n_rows":83,"n_cols":18,"rows_kept":83,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"BEMS (Building Energy Management Systems) Controls Engineer (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","Understanding building control technologies and theory including: The primary role and function of the control system The merits of automated control over manual control methods The development of interface protocols so data can be shared and exchanged between the BEMS and 3rd party systems e.g. access systems and lighting systems",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","Understand the fundamentals of controlling HVAC (heating, ventilation and air conditioning) and building technology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Understand hydrodynamics and hydronic systems in buildings e.g. the transfer of heat energy and cooling energy through a building using water",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Understand thermodynamic relationships in air conditioning systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Understand cooling systems, heat generation and renewable technology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Understand the principles and practices of measurement technology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Understand Control Panel wiring, construction and relay logic",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Understand the control principles associated with the design, function, facilities management and use of the building",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Understand communications technology protocols and media",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Understand the practices and procedures for the installation of BEMS wiring systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Understand the principles and practices for the commissioning of BEMS and associated equipment in buildings",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Understand the principles for diagnosing and correcting faults in BEMS network systems and BEMS equipment in buildings",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Understand the energy efficiency and comfort control requirement within buildings",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Understand the testing, inspection and certification of BEMS related controls equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Understand the operation and application of BEMS field devices e.g. sensors",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Understand relevant health & safety legislation and safe working practices applying to themselves and others. Give particular reference to understanding the requirements for protection of and safe working with electrical installations and BEMS impact on ‘wellbeing’",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Understand the general characteristics of electrical installations and how to assess them",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Understand the requirements of inspection and testing of BEMS element of electrical installations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Understand the principles of control logic including the fundamentals of proportional and integral control",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Applying the control principles associated with the design, function and use of buildings e.g. to create points lists, description of operation, cable schedules",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","Incorporating hydrodynamics/ hydronic systems into designs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Applying the principles and practices of measurement technology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Incorporating cooling systems, heat generation and renewable technology into designs as applicable",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Incorporating Control Panel wiring, construction and relay logic into the design process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Applying communications technology protocols and media e.g. MODBUS and BACNET",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Applying relevant safety legislation, codes of practice and safe working practices to themselves and others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Identifying requirements for protection of electrical installations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Incorporating the needs of a variety of building stakeholders (e.g. owners/ operators) within the design of the BEMS system",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Applying the practices and procedures for the installation of BEMS wiring systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Interpreting the requirements for the BEMS element of electrical installations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Applying the principles and practices for the commissioning of BEMS systems and equipment in a variety of building types and environments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Applying the principles, for diagnosing and correcting faults in BEMS network systems and BEMS equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Applying the principles for completing conditional site surveys, along with associated recommendations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Applying knowledge of energy efficiency to optimise comfort in buildings whilst minimising energy usage",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Identifying the requirements of inspection and testing of BEMS element of electrical installations within relevant legislative requirements, specifications, codes of practice and industry recognised practices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Carrying out the testing, inspection and certification of BEMS related controls and equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Applying the principles and practices for the design and commissioning of standard network architectures e.g. Ethernet TCP/IP, MSTP and RS48",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Carrying out updates to BEMS system hardware to ensure compatibility with latest products",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Be aware of the needs and concerns of others, especially in relation to diversity and equality",null,null,null,null,null,null,{"$f":"IF(C62:C73 = \"FULLY MET\",1,IF(C62:C73 = \"PARTIALLY MET\",0.5,IF(C62:C73 = \"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"}]
["B2","Create maintain, and enhance productive working relationships",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Commit to compliance with health and safety",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Strive to communicate effectively with work colleagues and clients using oral, written and electronic methods to communicate technical and other information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Take responsibility for working independently and completing work to the appropriate specifications and codes of practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Solving problems within their own scope of responsibility, by applying technical and behavioural skills and knowledge to define the problem, identify, evaluate and select alternatives and implement solutions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Accepting responsibility for their own work and actions and that of others in their team",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Accepting, prioritizing, delegating and undertaking technical and other tasks effectively",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Committed to working effectively with colleagues, the public, clients and other stakeholders",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=0.5,\"NONE\",IF(L70=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B10","Take responsibility for personal development, demonstrating commitment to learning and self-improvement",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"}]
["B11","Exercise responsibilities in an ethical manner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B12","Undertake work in a way that contributes to sustainable development",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J73)","v":0},"Net Score",{"$f":"SUM(L22:L73)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J76/L80","v":0},"total CoE KSB coverage",{"$f":"L76/L83","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",50]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L80-L81-(L82*0.5)","v":49.5}]

{"sheet":"ST0877","index":9,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Land referencer (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","Health, safety and well-being legislation. Company policy, practice and reporting methods.",null,null,null,null,null,null,{"$f":"IF(C22:C37 = \"FULLY MET\",1,IF(C22:C37 = \"PARTIALLY MET\",0.5,IF(C22:C37 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The elements of a typical land referencing project including structure, lifecycle, hierarchy, contact and non-contact referencing. The range of typical projects where land referencing is applied and the risks posed to a typical land referencing project (e.g. ransom strips, un-notified interested parties).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The various stakeholders in a land referencing project. The importance of consultation and the purpose of public engagement. Landowner liaison processes, consideration of attitudes and behaviours. Managing conflict when engaging with project stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","UK consent methods and instruments.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Diligent enquiry: the definition of, processes required to satisfy and the consequences of non-compliance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The range of information sources, including paper and digital map data, and how this is procured to support land referencing exercises. Quality control standards and methodology. The unknown owner process.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Digital tools used to inspect and report information. The forms of acquiring and recording information from project stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Types of public rights of way, identifying public and private rights of way, their boundaries and methods of identifying beneficiaries of private rights of way.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Processes involved with identifying and requesting information from major landowners and statutory undertakers. The registration of ownership in land and consequences of unregistered land. Interests and land/property and the hierarchy of interests. Balancing and validating conflicting data sources.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Agreeing access to land for surveys. Options and processes for gaining access to land through agreement, negotiation of licences or statutory notification.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Agricultural practices, uses and interests in land, land classification, rural conditions, impacts of surveys and projects on agricultural land.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Contact referencing and the methods that a land referencer would use to make contact with stakeholders before, during and post-site work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The process behind the production of land plans, order plans and bill plans including processes and options for setting up templates and working with the GIS team to produce plans. Requirements for land consultation checking of plans and ensuring consistency with other deliverables.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Documents forming an application or bill such as book of reference, land plans and ownership schedules. Standards for writing plot descriptions for a book of reference.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The definition, significance, identification and recording of special category land and crown land.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The process of site notice planning, production, erection, maintenance and proof of service.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Identify relevant legislation and the appropriate data extraction required to satisfy the requirements of the chosen consent method. Ensure compliance with relevant health, safety and well-being legislation, company policy and practice. Process personal information in a secure manner.",null,null,null,null,null,null,{"$f":"IF(C39:C48 = \"FULLY MET\",1,IF(C39:C48 = \"PARTIALLY MET\",0.5,IF(C39:C48 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J39=1,1,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=1,\"NONE\",IF(L39=0.5,\"PARTIAL\",IF(L39=0,\"FULL\")))","v":"FULL"}]
["S2","Interpret information from multiple sources, including paper and digital, relaying in a coherent and clear format. Identify proprietors, types of tenure and rights over land, current beneficiaries and successors and unknown interests in land.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Record information accurately and comprehensively, providing a full auditable trail of evidence. Use a Geographic Information System (GIS) for data processing and analysis, areas measurement and plan production.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Maintain accurate records in accordance with company procedures.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J42=1,0.5,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=0.5,\"NONE\",IF(L42=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Build professional landowner and stakeholder relationships to enable effective enquiry, influence and negotiation. Prepare for, conduct and follow up stakeholder meetings and record minutes.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J43=1,0.5,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},"PARTIAL"]
["S6","Plan site visits to enable the required data collection.",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"}]
["S7","Analyse land features and how they impact or inform legal interest in the land.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Serve notices, evidencing that they have been successfully served in accordance with relevant legislation.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J46=1,0.5,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=0.5,\"NONE\",IF(L46=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Monitor site notices and provide a prompt response to returned notices or queries from affected parties.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J47=1,0.5,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},"PARTIAL"]
["S10","Communication with a range of stakeholders via numerous methods including phone, email and in person.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J48=1,0.5,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},"PARTIAL"]
[null,"Behaviours"]
["B1","Adopt a professional approach to work, respect confidentiality and work collaboratively across multiple disciplines.",null,null,null,null,null,null,{"$f":"IF(C50:C53 = \"FULLY MET\",1,IF(C50:C53 = \"PARTIALLY MET\",0.5,IF(C50:C53 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"}]
["B2","Demonstrate an attention to detail when solving problems, taking into consideration people, places and environments and the relationship between them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Work independently, self-manage and prioritise work and own professional development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Demonstrate a commitment to equality, diversity and inclusion.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J53)","v":0},"Net Score",{"$f":"SUM(L22:L53)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J56/L60","v":0},"total CoE KSB coverage",{"$f":"L56/L63","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",30]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",5]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L60-L61-(L62*0.5)","v":27.5}]

{"sheet":"ST0936","index":10,"n_rows":61,"n_cols":18,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Town planning assistant (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","Legislation and Policy: The features of current town planning regulations, policy and guidance. Appreciation of the implications of case law for planning applications and statutory plan making",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","Planning Process: Forms of development management and development plans that happen in planning and their supporting administrative processes. How to respond to requests for technical information about proposals and planning issues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Data collection: Where to find current and historical data on single sites and wider areas for development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Environmental procedures and sustainability: The features of environmental and ecological designations and processes relevant to the planning system. Where to find information identifying potential flood risk for developments and matters such as energy and climate change.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Conservation and design: The features of the natural and historic environment that can be affected by developments and how they can and should be protected by the planning system. The features of technical constraints related to design.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Conditions, appeals and enforcement: The features of monitoring compliance of authorised and unauthorised developments and support the processing of planning appeals.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Stakeholder engagement: The wider decision making and political context in which planners work. Including the types and sizes of organisations working in planning, statutory authorities and other consultees, including the local community",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Mapping and graphics: Map preparation and analysis including taking measurements from maps. Methods and techniques for creating and explaining graphical representations including specialist graphic tools and mapping technologies as appropriate, and taking site photographs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Health and Safety: Responsibilities under health and safety legislation on safe working practices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Size and scale: How to assess the size and scale of developments and structures in relation to planning policy and impact on adjacent developments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Report writing: How to select and present information about policy constraints, site research and baseline analysis",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Project Management: The requirements for projects, including timescales, deadlines, cost implications, and identifying milestones/targets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Data analysis: Research, collate and compare data relating to development proposals, applications and other planning considerations",null,null,null,null,null,null,{"$f":"IF(C35:C45 = \"FULLY MET\",1,IF(C35:C45 = \"PARTIALLY MET\",0.5,IF(C35:C45 = \"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","Policy analysis: Apply legislation, local and national policy and regulations to projects and casework",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Site analysis: Take and edit site photographs correctly, and take site visit notes accurately",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Report writing: Write reports and summaries and prepare initial documentation for planning proposals and policy representations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Communication: Communicate effectively with members of the public, clients and other stakeholders. Respond to queries in writing and verbally. Use community engagement techniques to encourage participation in the planning system.",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","Casework: Process own casework of projects including checking planning documentation for completeness and taking action in response to missing documentation",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"}]
["S7","Data monitoring: Consult, create and where necessary maintain records on relevant planning registers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Mapping: Create accurate drawings, maps and digital illustrations. Interpret drawings and maps, and use appropriate mapping tools",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Presentation – internal: Discuss and present planning information, documentation and findings to colleagues",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Presentation – external: Prepare and deliver presentations to external audiences e.g. members of the public or other community or professional stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Administration: Provide administrative support to line managers and peers. Keep an accurate record of meetings. Use appropriate case management systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1"," Take care for their own health and safety",null,null,null,null,null,null,{"$f":"IF(C47:C51 = \"FULLY MET\",1,IF(C47:C51 = \"PARTIALLY MET\",0.5,IF(C47:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J47=1,1,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},{"$f":"IF(L47=1,\"NONE\",IF(L47=0.5,\"PARTIAL\",IF(L47=0,\"FULL\")))","v":"FULL"}]
["B2","Reliability, integrity and respect for confidentiality on work related and personal matters, including appropriate use of social media and information systems. Follows their employers Code of Conduct.",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"}]
["B3","Commitment to their own Continuing Professional Development",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Work effectively both on their own and as part of a team",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Demonstrate time management skills, prioritise workload, work under pressure and be able to meet critical deadlines",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J51)","v":0},"Net Score",{"$f":"SUM(L22:L51)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J54/L58","v":0},"total CoE KSB coverage",{"$f":"L54/L61","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",28]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L58-L59-(L60*0.5)","v":27.5}]

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