{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["GUIDE TO KSB MAPPING","ST0041","ST0046","ST0484","ST0613","ST0629","ST0877","ST0936","ST1105","ST1299","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\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Building services engineering senior technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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":"ST0046","index":2,"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\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Civil engineering senior technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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":"ST0484","index":3,"n_rows":95,"n_cols":18,"rows_kept":95,"cut":false,"hidden":false,"merged":[[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],[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]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Facilities manager (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["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":4,"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\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Acoustics technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The 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":5,"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\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"BEMS (building energy management systems) controls engineer (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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,"PARTIAL",{"$f":"IF(J50=1,0.5,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=0.5,\"NONE\",IF(L50=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S10","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,"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"}]
["B10","Take responsibility for personal development, demonstrating commitment to learning and self-improvement",null,null,null,null,null,null,0,null,"NONE",0,"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":6,"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\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Land referencer (level 4) "]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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,"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"}]
["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,"NONE",0,"FULL"]
["S10","Communication with a range of stakeholders via numerous methods including phone, email and in person.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[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",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L60-L61-(L62*0.5)","v":29}]

{"sheet":"ST0936","index":7,"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\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Town planning assistant (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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,"PARTIAL",{"$f":"IF(J49=1,0.5,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=0.5,\"NONE\",IF(L49=0,\"PARTIAL\"))","v":"PARTIAL"}]
["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",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L58-L59-(L60*0.5)","v":27}]

{"sheet":"ST1105","index":8,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Heritage construction specialist (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Principles, philosophy and ethics of conservation for historic buildings, structures and settings.",null,null,null,null,null,null,{"$f":"IF(C22:C46 = \"FULLY MET\",1,IF(C22:C46 = \"PARTIALLY MET\",0.5,IF(C22:C46 = \"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","Statutory, quality and policy standards and legislation applicable to heritage construction work.",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},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","Historic, archaeological, architectural and environmental context relevant to British historic building stock (built pre-1919).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Principles of assessing the significance and condition of heritage property or asset, for example whole buildings, parts of buildings, ancillary structures, monuments, architectural features including garden structures, walls and paving.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Traditional and historic construction materials, techniques and practices used to build heritage property or assets.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6"," Construction materials, techniques and practices used to repair, maintain, adapt, retrofit and conserve heritage property or assets.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The performance of historic and traditional buildings, where this differs to modern buildings, and the impact this has on the selection of construction methods.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Principles of risk assessment and impact mitigation of modern techniques, materials, practices and interventions on heritage projects.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Principles of sustainability in the historic environment, including as climate change relates to it, and how this impacts repair, maintenance, retrofit, energy efficiency and conservation, of historic and traditional structures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Health and safety: law and obligations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Standard forms of construction contract and subcontract and contractual mechanisms as applied at various stages of the contract. The roles, responsibilities and duties of the contract administrator and the duties of the parties to the contract.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J32=1,1,IF(J32=0.5,0.5,IF(J32=0,0)))","v":0},{"$f":"IF(L32=1,\"NONE\",IF(L32=0.5,\"PARTIAL\",IF(L32=0,\"FULL\")))","v":"FULL"}]
["K12","Documentation required during heritage construction projects for example statements of significance, condition surveys and other heritage statements and specifications.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Quantification and costing of construction work.",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"}]
["K14","The structure of teams who work on historic and traditional buildings, including specialists and designers, and how the heritage construction specialist interacts with these roles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The contribution that historic and traditional buildings and heritage construction can make to local, regional, national and community and cultural identities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Common issues, symptoms and warning signs of stress, anxiety and depression, including where to go for help and the resources available.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Principles of designing heritage construction work programmes including risk assessment and time management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Principles of solving heritage construction problems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Principles of researching and developing new techniques and disseminating findings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Report writing techniques. IT applications for technical reporting.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Verbal communication techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The Equality Act - requirements on organisations. Social inclusion practices. Reasonable adjustments to support accessibility. The impact of unconscious bias.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Principles of leading people and managing the quality of their work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Digital technology in the industry: management information systems and equipment digital interfaces.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Information technology. General data protection regulation (GDPR). Cyber security.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply relevant statutory, quality and policy standards and legislation to the planning and execution of heritage construction work.",null,null,null,null,null,null,{"$f":"IF(C48:C64 = \"FULLY MET\",1,IF(C48:C64 = \"PARTIALLY MET\",0.5,IF(C48:C64 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["S2","Evaluate, select and recommend construction materials, techniques and practices used in heritage construction work.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J49=1,1,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=1,\"NONE\",IF(L49=0.5,\"PARTIAL\",IF(L49=0,\"FULL\")))","v":"FULL"}]
["S3","Assess the condition and significance of heritage property or asset and record findings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Apply sustainability principles, including energy efficiency and building performance, to the planning and execution of heritage construction work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Assess the risks of modern techniques, materials, practices and interventions on heritage projects, and mitigate the impact on current and future heritage construction works.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Complete and maintain heritage project documentation and records.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Communicate technical information to stakeholders using appropriate formats, for example photographs, drawings, sketches and digital formats.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Design heritage construction work programmes, including costs, risk assessment and time management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Select and use procurement and contract forms.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Identify and instruct specialist skills outside of own competence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Communicate verbally with stakeholders, specialists and clients.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Raise awareness, appreciation and understanding of historic and traditional structures, promoting best-practice, including through public engagement activities.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J59=1,0.5,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=0.5,\"NONE\",IF(L59=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S13","Lead people and manage the quality of their work for example staff, volunteers and external specialist contractors.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J60=1,0.5,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},"PARTIAL"]
["S14","Lead the development of new techniques through research and or dissemination of research.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J61=1,1,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=1,\"NONE\",IF(L61=0.5,\"PARTIAL\",IF(L61=0,\"FULL\")))","v":"FULL"}]
["S15","Solve problems based on an assessment of available evidence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Apply and promote policies and practices to support equity, diversity and inclusion.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Use information technology and digital systems. Comply with cyber security.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Act ethically in the completion of work.",null,null,null,null,null,null,{"$f":"IF(C66:C70 = \"FULLY MET\",1,IF(C66:C70 = \"PARTIALLY MET\",0.5,IF(C66:C70 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"}]
["B2","Committed to maintaining and enhancing competence of self and others, including to future generations, through Continued Professional Development (CPD).",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J67=1,0.5,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=0.5,\"NONE\",IF(L67=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Collaborate with others, for example within teams, across disciplines and external stakeholders.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J68=1,1,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=1,\"NONE\",IF(L68=0.5,\"PARTIAL\",IF(L68=0,\"FULL\")))","v":"FULL"}]
["B4","Puts safety first for themselves and others ensuring compliance with health, safety, welfare, environmental and quality requirements and policies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Encourage a diverse and inclusive culture.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J70)","v":0},"Net Score",{"$f":"SUM(L22:L70)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J73/L77","v":0},"total CoE KSB coverage",{"$f":"L73/L80","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",47]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L77-L78-(L79*0.5)","v":45.5}]

{"sheet":"ST1299","index":9,"n_rows":111,"n_cols":18,"rows_kept":111,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Cellular network field engineer (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Awareness of Health and safety legislations, regulations and safe working practices, network operator and tower estate owners design and construction rules and guidelines, relevance to the occupation and the operative's responsibilities. Including Health and Safety at Work Act, Control of Substances Hazardous to Health (COSHH). Manual handling. Working at height regulations. Working in confined spaces. Situational awareness. Isolation and emergency stop procedures. Emergency evacuation procedures. Safety equipment: guards, signage, fire extinguishers",null,null,null,null,null,null,{"$f":"IF(C22:C65 = \"FULLY MET\",1,IF(C22:C65 = \"PARTIALLY MET\",0.5,IF(C22:C65 = \"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","Tower climbing techniques",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},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","Safety control equipment and how to use personal protective equipment (PPE)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","International commission non-Ionising radiation protection (ICNIRP): frequency ranges",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Principles of Transverse Electromagnetic Wave (TEM) propagation: Hyugen’s theorem",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Principles of electromagnetic field",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Fibre transmission and modes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Lifting and lowering techniques, slings, knots and attachments, for rooftop, greenfield and street works",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Site standards, survey requirements and site set up for any specific activity: Site inductions, toolbox talks, dynamic risk assessments (DRA), scope of work, Risk Assessments & Method Statements (RAMS), identification of hazards, lines of reporting and required control measures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Site inspection requirements: validity, duration, standard industry practice, Working at Height (WAH), Electrical, Civil and Environment – awareness of how to access, Barber portal, relevant sources and Person in charge of Works (PICW)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Statutory requirements for maintaining electrical equipment: distribution boards, power support units, battery supplies, mains supplies, Remote radio boxes (RRB's) Break out boxes (BOB)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Statutory requirements for maintaining environmental equipment: detecting or removal of asbestos, site pollution, bird nesting, Weil disease.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Statutory requirements for maintaining civil equipment: avoiding danger from undergrounds services, permission to dig, cat scanning, excavations, tower roots, cabinet plinths group repairs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Statutory requirements for maintaining working at height equipment: Site specific structures, antenna systems, feeders, Remote Radio Unit (RRU), Remote Radio Head (RRH), Mast head amplifiers (MHA's), Directional Radio Link (DRL) and associated fixings, frequency bands",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Communication techniques and methods when communicating with people in different roles",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J36=1,1,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=1,\"NONE\",IF(L36=0.5,\"PARTIAL\",IF(L36=0,\"FULL\")))","v":"FULL"}]
["K16","Methods of interpreting and extracting relevant information from drawings, specifications and work instructions using paper based and digital methods",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Roles and Responsibilities of site personnel ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Personal responsibilities and obligations in protecting safety of self, colleagues and the public whilst undertaking work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Process and procedures for the planning, of electrical systems Including Alternating Current (AC) and Direct Current (DC), Low Voltage (LV), Protective Extra Low Voltage (PELV)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Process and procedures for the set up and installation of electrical systems Including Alternating Current (AC) and Direct Current (DC), Low Voltage (LV), Protective Extra Low Voltage (PELV)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Process and procedures for the inspection and testing of electrical systems Including Alternating Current (AC) and Direct Current (DC), Low Voltage (LV), Protective Extra Low Voltage (PELV)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Full and partial isolation processes of electrical circuits including Electrotechnical systems and electrical systems and equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Tools, equipment, components used in role",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Power supplies: Uninterruptible power supply (UPS), Generators, Standby and Primary Sources",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Principles of sustainability: Energy efficiency and reuse of materials, recycling, principles of control and management of emissions and waste, efficient use of resources",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Principles of sustainable development and their impact on the occupation: net-zero carbon emissions, low carbon processes, environmental policies and legislations, and the climate change act",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Equity, Diversity and Inclusivity and its principles in the workplace including routes for reporting unethical behaviour",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Industry recognised standards as defined within current British standards including wiring regulations and Electrical Installation Certificate (EIC)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Maintenance techniques for cell site apparatus",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Fault finding and repair techniques for cell site apparatus",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Decommission techniques for cell site apparatus",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Principles of electrical design: design load, sizing and safe route of cabling, overcurrent, undercurrent, circuit protection, earthing and lightning protection, equipotential bonding",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Tower rescue and casualty management techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Leadership and management techniques: planning, work scheduling, delegation techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","Wellbeing: mental and physical health considerations and how to access support",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Cellular Network and transmission design and topology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Radio access, network structure and interactions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","Commission and integration testing processes on Base Station Sub-System (BSS)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","Construction phase plan (CPP)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","Information required for handover pack",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","Client specifications for frequency limits pass and fail parameters",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","Process and procedures for the planning and testing, of Radio frequency (RF) complying with regulations International Commission on Non-Ironizing Radiation Protection (ICNIRP)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K43","Radio Frequency (RF) testing equipment: Open, short and load",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K44","Telecom connectors:7/16 N_type 43..10",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Compile and verify a construction phase plan (CPP)",null,null,null,null,null,null,{"$f":"IF(C67:C94 = \"FULLY MET\",1,IF(C67:C94 = \"PARTIALLY MET\",0.5,IF(C67:C94 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J67=1,1,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=1,\"NONE\",IF(L67=0.5,\"PARTIAL\",IF(L67=0,\"FULL\")))","v":"FULL"}]
["S2","Conduct, produce and write a risk assessment and method statement at site level",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J68=1,0.5,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=0.5,\"NONE\",IF(L68=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S3","Recognise, record and monitor risks, escalating to relevant personnel",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"}]
["S4","Comply with health and safety regulations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Identify and use personal protective equipment (PPE) ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Comply with electrical regulations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Delegate and assign tasks according to scope of works and specific skillset and Health and safety",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Conduct site surveys to meet client’s installation criteria",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J74=1,0.5,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=0.5,\"NONE\",IF(L74=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Review and compile information to produce handover pack",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J75=1,1,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},{"$f":"IF(L75=1,\"NONE\",IF(L75=0.5,\"PARTIAL\",IF(L75=0,\"FULL\")))","v":"FULL"}]
["S10","Select, implement and evaluate control measures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Install electrical systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Inspect and test electrical systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Isolate electrical circuits",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Maintain cell site apparatus",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15"," Find faults and repair cell site apparatus",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Decommission cell site apparatus",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Commission and conduct integration testing on Base Station Sub-System (BSS)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Select and use work restraint, work positioning, and fall arrest equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Climb site towers",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J85=1,0.5,IF(J85=0.5,0.5,IF(J85=0,0)))","v":0},{"$f":"IF(L85=0.5,\"NONE\",IF(L85=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S20","Use lifting and lowering techniques using slings, knots and attachments",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J86=1,1,IF(J86=0.5,0.5,IF(J86=0,0)))","v":0},{"$f":"IF(L86=1,\"NONE\",IF(L86=0.5,\"PARTIAL\",IF(L86=0,\"FULL\")))","v":"FULL"}]
["S21","Select and use tools and equipment when working at ground level and at height",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Conduct tower rescue and casualty management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Apply sustainable principles and low carbon processes to implement site environmental solutions and disposal of waste",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Apply equity, diversity and inclusion principles",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Communicate with internal and external stakeholders using sector specific terminology through written or verbal means",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Interpret design drawings",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Use Radio Frequency (RF) monitor",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Conduct site inspections",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J94=1,0.5,IF(J94=0.5,0.5,IF(J94=0,0)))","v":0},{"$f":"IF(L94=0.5,\"NONE\",IF(L94=0,\"PARTIAL\"))","v":"PARTIAL"}]
[null,"Behaviours"]
["B1","Take Responsibility for own actions and for the actions of those under their supervision or direction with respect to safety",null,null,null,null,null,null,{"$f":"IF(C96:C101 = \"FULLY MET\",1,IF(C96:C101 = \"PARTIALLY MET\",0.5,IF(C96:C101 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J96=1,0.5,IF(J96=0.5,0.5,IF(J96=0,0)))","v":0},{"$f":"IF(L96=0.5,\"NONE\",IF(L96=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Demonstrate commitment to workplace health, safety",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J97=1,1,IF(J97=0.5,0.5,IF(J97=0,0)))","v":0},{"$f":"IF(L97=1,\"NONE\",IF(L97=0.5,\"PARTIAL\",IF(L97=0,\"FULL\")))","v":"FULL"}]
["B3","Take responsibility for and promote sustainable working practices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Committed to continued professional development (CPD) to maintain and enhance competence in own area of practice",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J99=1,0.5,IF(J99=0.5,0.5,IF(J99=0,0)))","v":0},{"$f":"IF(L99=0.5,\"NONE\",IF(L99=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Encourage a diverse and inclusive culture",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Recognise limitations, seek input from others and escalate issues when required",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J101)","v":0},"Net Score",{"$f":"SUM(L22:L101)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J104/L108","v":0},"total CoE KSB coverage",{"$f":"L104/L111","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",78]
[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",6]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L108-L109-(L110*0.5)","v":75}]

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