{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Guide","Structure","ST0041","ST0043","ST0046","ST0048","ST0049","ST0484","ST0613","ST0629","ST0877","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","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
["Quick reference guide to KSB mapping",null,"Table to assist with B11-13"]
[null,null,"Reference","Name of occupational standard"]
["1. START HERE",null,"ST0043","Construction Design and Build Technician (Level 4)"]
["Awarding body:",null,"ST0048","Construction Site Supervisor (Level 4)"]
["Please type the name of your awarding body here",null,"ST0049","Construction Quantity Surveying Technician (Level 4)"]
["Qualification name:",null,"ST0484","Facilities Manager (Level 4)"]
["Please type your qualification title here",null,"ST0613","Acoustics Technician (Level 4)"]
["Programme title if applicable:",null,"ST0629","BEMS (Building energy management systems) controls engineer (Level 4)"]
["Please type the programme title here",null,"ST0877","Land Referencer (Level 4)"]
["Please select the occupational standard(s) you are mapping in this spreadsheet","Dropdown Options"]
["Standard 1 - select from the dropdown list to the right"]
["Standard 2 - select from the dropdown list to the right"]
["Standard 3 - select from the dropdown list to the right"]
["If your qualification maps to more than three occupational standards, please contact us at HTQ.approvals@education.gov.uk"]
[]
["2. GUIDE TO KSB MAPPING  "]
["Awarding bodies must demonstrate that a 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. "]
[]
["Before you begin, please list your qualification modules in the 'Structure' tab."]
["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 by clicking the blue STxxxx link in the reference column, to the right."]
["3. When the occupational standard opens, double check the name of the standard is correct. "]
["4. Please respond to each KSB statement."]
["5. Populate the Detailed page/pargraph reference, KSB coverage, Evidence, Assessment method and Supporting comments/rationale columns, as shown in the example below. "]
["6. Please be as specific as possible about which content in the qualification aligns to each KSB statement. "]
["7. You may delete sheets/tabs that are not relevant to  your qualification. "]
["8. Submit the completed spreadsheet along with 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."]
["9. Please contact HTQ.approvals@education.gov.uk if you need further help or guidance on mapping."]
[]
["3. EXAMPLE OF KSB MAPPING"]
["Please see the KSB mapping examples to the right. ","KSB Number","This is the list of KSB statements","Where in the qualification is the content? \nIndicate the reference document(s)/module(s)/unit(s) and page/paragraph number(s) you are citing as evidence of coverage","Select the coverage from the drop down list","Paste or type clear evidence supporting your KSB coverage. For example, learning outcomes or indicative module content","Provide information on how this KSB is assessed, i.e. the method of assessment used.  ","Provide comments and/or a rationale to support the evidence you have cited. If the KSB mentions key terms not explicitly referenced in your evidence, please explain how they are covered. If you have partially met or not met a KSB, provide a rationale to support your judgement"]
[null,"KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale"]
[null,"K1","Understand the background legislation and regulatory frameworks (such as IBL 188) relating to the occupation. ","Module 1.1 Legal and Ethical Considerations; p44-45, para 4-7.\nModule 4.2 Professional Issues and CPD; p9, para 3-4. \nQualification specification p4.","FULLY MET","MO1.1 LO3 Understand and critically reflect on legislation relating to and affecting the occupation.\nIndicative content\nLegal background; legislation; role of industry bodies; national/international considerations. \n\nMO4.2 LO2 Understand the importance of staying up to date with professional developments in the field, including legal frameworks, industry best practice, guidelines and relevant standards. ","Students are required to produce a written report using a brief provided. Within this report students are expected to cover relevant laws, legislation and industry body standards relevant to the brief. ","The detailed coverage of relevant law and legislation is taught in Year 1. It is covered again in Year 2, where learners reflect on it from a  professional perspective. The national regulatory framework and industry body standards (e.g. IBL 188) are covered in detail. "]
[null,"K2","The principles, features and differences of waterfall and agile methodologies for project delivery and software development.","Module 3. Software development; p.6, para 4-7.","FULLY MET","MO3 LO 1 Critically analyse and evaluate approaches to software development methodologies. Theory, method and application.\n\nIndicative content \nUse of different software methodologies; matching methodology to function. \nA range of software methodologies are covered and applied to software problems.","K2 is assessed via a project. Within this project students will be expected to demonstrate practical application and produce written project report(s) which evidence methodologies and methods. ","Waterfall and agile are not explicitly referred to in the LO or indicative content, although they are both fully covered in this module. We cover four approaches to software development, providing background, theory and practical applications. Learners will get 'hands on' experience of evaluating waterfall and agile, including their use in real-world problem solving and project delivery."]

{"sheet":"Structure","index":1,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,10]]}
["Return to Guide"]
["Please list all the modules in the qualification",null,null,null,null,null,null,null,null,null,null,"Response"]
["Does every possible combination of modules/units/pathways ensure that a learner achieves competence in the occupation(s) which the TQ is in respect of and for which the Institute has published an occupational standard "]
[]
["Note: If a module is not aligned/mapped to an occupational standard it is classed as additional content"]
[]
["Module Code","Module Name","Full-Time Year","Part-Time Year","Core/Option","Mapped to Standard(s)","Credits","Level","Delivery Method","Delivery Comments"]
["EXAMPLE001","Foundations of Technical Concepts","Year 1","Year 1","Core ","ST0041, ST0046",30,4,"Mixed","40% classroom, 60% placement."]

{"sheet":"ST0041","index":2,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[null,"Building Services Engineering Technician (Level 4)","DO NOT USE "]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","DO NOT USE "]
["K1 Health and Safety","Understand the principles and responsibilities imposed law and other regulations in a building services environment","DO NOT USE ",null,null,null,null,null,{"$f":"IF(D5:D10 = \"FULLY MET\",1,IF(D5:D10 = \"PARTIALLY MET\",0.5,IF(D5:D10 = \"NOT MET\",0,)))","v":0}]
["K2 Sustainability","Understand the sustainability issues in projects across economic, social and environmental aspects","DO NOT USE ",null,null,null,null,null,0]
["K3 Engineering Principles","Understand engineering techniques, procedures and methods and the principles of design","DO NOT USE ",null,null,null,null,null,0]
["K4 Project Management","Understand management principles and the project management lifecycle and the contractual conditions on a project","DO NOT USE ",null,null,null,null,null,0]
["K5 Planning and Organising Work","Understand the importance of project planning and resourcing and be able to analyse different techniques","DO NOT USE ",null,null,null,null,null,0]
["K6 Monitor Quality","Able to define the quality required and the commissioning process on a finished building services project","DO NOT USE ",null,null,null,null,null,0]
[null,"Skills","DO NOT USE "]
["S1 Health and Safety","Identify risk of activities and encourage all employees to demonstrate safety- conscious behaviours","DO NOT USE ",null,null,null,null,null,{"$f":"IF(D12:D17 = \"FULLY MET\",1,IF(D12:D17 = \"PARTIALLY MET\",0.5,IF(D12:D17 = \"NOT MET\",0,)))","v":0}]
["S2 Sustainability","Assess, identify and record the environmental impact of projects","DO NOT USE ",null,null,null,null,null,0]
["S3 Engineering Solutions","Assist in the implementation of the most appropriate solutions for building services projects","DO NOT USE ",null,null,null,null,null,0]
["S4 Project Management","Use effective management principles and be able to supervise building services workers, ensuring adherence to contractual conditions","DO NOT USE ",null,null,null,null,null,0]
["S5 Planning and Organising Work","Understand overall plan for project and measure and record progress against plan","DO NOT USE ",null,null,null,null,null,0]
["S6 Monitor Quality","Assess and report on quality standards and assist in commissioning of finished  building services projects","DO NOT USE ",null,null,null,null,null,0]
[null,"Behaviours ","DO NOT USE "]
["B1 Professional Judgement","Be able to work within own level of competence and know when to seek advice from others","DO NOT USE ",null,null,null,null,null,{"$f":"IF(D19:D25 = \"FULLY MET\",1,IF(D19:D25 = \"PARTIALLY MET\",0.5,IF(D19:D25 = \"NOT MET\",0,)))","v":0}]
["B2 Commitment to Code of Ethics","Work within Rules and Regulations of Professional Competence and Conduct for the Chartered Institution of Building Services Engineers","DO NOT USE ",null,null,null,null,null,0]
["B3 Continuing Professional Development","Identify own development needs and take action to meet those needs. Use own knowledge and expertise to help others when requested.","DO NOT USE ",null,null,null,null,null,0]
["B4 Commitment to Equality and Diversity","Understand the importance of equality and diversity and demonstrate these attributes so as to meet the requirements of fairness at work.","DO NOT USE ",null,null,null,null,null,0]
["B5 Communicate Effectively","Be able to contribute effectively to meetings and present information in a variety of ways including oral and written.","DO NOT USE ",null,null,null,null,null,0]
["B6 Work in Teams","Be able to work with others in a collaborative and non-confrontational way.","DO NOT USE ",null,null,null,null,null,0]
["B7 Demonstrate Innovation","Be able to identify areas for improvement and suggest innovative solutions.","DO NOT USE ",null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J25)","v":0},"Net Score",{"$f":"SUM(L5:L25)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J28/L32","v":{"$error":"#VALUE!"}},"total CoE KSB coverage",{"$f":"L28/L35","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs","?"]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated","?"]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated","?"]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L32-L33-(L34*0.5)","v":{"$error":"#VALUE!"}}]

{"sheet":"ST0043","index":3,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,"Construction Design and Build Technician (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1 Client Requirements","Know how to analyse client requirements and ensure comprehensive survey information",null,null,null,null,null,null,{"$f":"IF(D5:D12 = \"FULLY MET\",1,IF(D5:D12 = \"PARTIALLY MET\",0.5,IF(D5:D12 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2 Health and Safety","Understand risk assessment of design solutions and the importance of behaviours in safety-critical environments",null,null,null,null,null,null,0,null,"NONE"]
["K3 Sustainability","Understand the sustainability issues in projects across economic, social and environmental aspects",null,null,null,null,null,null,0,null,"NONE"]
["K4 Construction Technology","Understand different construction methods and materials and building regulations",null,null,null,null,null,null,0,null,"NONE"]
["K5 Develop Designs","Understand how to develop detailed designs in line with client requirements and construction process",null,null,null,null,null,null,0,null,"NONE"]
["K6 Design Documentation","Understand how to co-ordinate design information in both electronic and paper form",null,null,null,null,null,null,0,null,"NONE"]
["K7 Monitor Compliance","Understand construction contracts and client quality standards",null,null,null,null,null,null,0,null,"NONE"]
["K8 Monitor costs","Understand the importance of cost control on a construction project",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1 Client Requirements","Assist in the assessment and presentation of client requirements",null,null,null,null,null,null,{"$f":"IF(D14:D21 = \"FULLY MET\",1,IF(D14:D21 = \"PARTIALLY MET\",0.5,IF(D14:D21 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["S2 Health and Safety","Identify risk in designs and suggest actions to reduce risks",null,null,null,null,null,null,0,null,"NONE"]
["S3 Sustainability","Assess, identify and record the environmental impact of projects",null,null,null,null,null,null,0,null,"NONE"]
["S4 Construction Technology","Assist in the implementation of the most appropriate solutions for construction projects whilst maintaining adherence to building regulations",null,null,null,null,null,null,0,null,"NONE"]
["S5 Develop Designs","Prepare and present design proposals and solutions",null,null,null,null,null,null,0,null,"NONE"]
["S6 Design Documentation","Control document production and design information",null,null,null,null,null,null,0,null,"NONE"]
["S7 Monitor Compliance","Inspect and report on quality standards and assist in commissioning of finished construction projects",null,null,null,null,null,null,0,null,"PARTIAL"]
["S8 Monitor costs","Understand financial and legal constraints and measure and record progress against budget",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1 Professional Judgement","Be able to work within own level of competence and know when to seek advice from others",null,null,null,null,null,null,{"$f":"IF(D23:D29 = \"FULLY MET\",1,IF(D23:D29 = \"PARTIALLY MET\",0.5,IF(D23:D29 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2 Commitment to Code of Ethics","Understand and apply the Code of Conduct and conduct regulations, ethics and professional standards relevant to industry’s recognised professional bodies.",null,null,null,null,null,null,0,null,"NONE"]
["B3 Continuing Professional Development","Identify own development needs and take action to meet those needs. Use own knowledge and expertise to help others when requested.",null,null,null,null,null,null,0,null,"NONE"]
["B4 Commitment to Equality and Diversity","Understand the importance of equality and diversity and demonstrate these attributes so as to meet the requirements of fairness at work.",null,null,null,null,null,null,0,null,"PARTIAL"]
["B5 Communicate Effectively","Be able to contribute effectively to meetings and present information in a variety of ways including oral and written.",null,null,null,null,null,null,0,null,"NONE"]
["B6 Work in Teams","Be able to work with others in a collaborative and non-confrontational way.",null,null,null,null,null,null,0,null,"NONE"]
["B7 Demonstrate Innovation","Be able to identify areas for improvement and suggest innovative solutions.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J29)","v":0},"Net Score",{"$f":"SUM(L5:L29)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J32/L36","v":0},"total CoE KSB coverage",{"$f":"L32/L39","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",23]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L36-L37-(L38*0.5)","v":21.5}]

{"sheet":"ST0046","index":4,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[null,"Construction Site Engineering Technician (Level 4)","DO NOT USE "]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","DO NOT USE "]
["K1 - Health and Safety","Understand the principles and responsibilities imposed law and other regulations in a construction environment","DO NOT USE ",null,null,null,null,null,{"$f":"IF(D5:D10 = \"FULLY MET\",1,IF(D5:D10 = \"PARTIALLY MET\",0.5,IF(D5:D10 = \"NOT MET\",0,)))","v":0}]
["K2 - Sustainability","Understand the sustainability issues in projects across economic, social and environmental aspects","DO NOT USE ",null,null,null,null,null,0]
["K3 - Engineering Principles","Understand engineering techniques, procedures and methods and the principles of design","DO NOT USE ",null,null,null,null,null,0]
["K4 - Construction Management","Understand management principles and the project management lifecycle","DO NOT USE ",null,null,null,null,null,0]
["K5 - Planning and Organising Work","Understand the importance of project planning and resourcing and be able to analyse different techniques","DO NOT USE ",null,null,null,null,null,0]
["K6 - Monitor Quality","Able to define the quality required on a finished construction project","DO NOT USE ",null,null,null,null,null,0]
[null,"Skills","DO NOT USE "]
["S1 - Health and Safety","Identify risk of activities and encourage all employees to demonstrate safety conscious behaviours","DO NOT USE ",null,null,null,null,null,{"$f":"IF(D12:D17 = \"FULLY MET\",1,IF(D12:D17 = \"PARTIALLY MET\",0.5,IF(D12:D17 = \"NOT MET\",0,)))","v":0}]
["S2 - Sustainability","Assess, identify and record the environmental impact of projects","DO NOT USE ",null,null,null,null,null,0]
["S3 - Engineering Solutions","Assist in the implementation of the most appropriate solutions for construction projects ","DO NOT USE ",null,null,null,null,null,0]
["S4 - Construction Management","Use effective management principles and be able to supervise construction workers","DO NOT USE ",null,null,null,null,null,0]
["S5 - Planning and Organising Work","Understand overall plan for project and measure and record progress against plan","DO NOT USE ",null,null,null,null,null,0]
["S6 - Monitor Quality","Assess and report on quality standards of finished construction projects","DO NOT USE ",null,null,null,null,null,0]
[null,"Behaviours","DO NOT USE "]
["B1 - Professional Judgement","Be able to work within own level of competence and know when to seek advice from others","DO NOT USE ",null,null,null,null,null,{"$f":"IF(D19:D25 = \"FULLY MET\",1,IF(D19:D25 = \"PARTIALLY MET\",0.5,IF(D19:D25 = \"NOT MET\",0,)))","v":0}]
["B2 - Commitment to Code of Ethics","Work within Rules and Regulations of Professional Competence and Conduct for the Institution of Civil Engineers","DO NOT USE ",null,null,null,null,null,0]
["B3 - Continuing Professional Development","Identify own development needs and take action to meet those needs. Use own knowledge and expertise to help others when requested.","DO NOT USE ",null,null,null,null,null,0]
["B4 - Commitment to Equality and Diversity","Understand the importance of equality and diversity and demonstrate these attributes so as to meet the requirements of fairness at work.","DO NOT USE ",null,null,null,null,null,0]
["B5 - Communicate Effectively","Be able to contribute effectively to meetings and present information in a variety of ways including oral and written.","DO NOT USE ",null,null,null,null,null,0]
["B6 - Work in Teams","Be able to work with others in a collaborative and non-confrontational way.","DO NOT USE ",null,null,null,null,null,0]
["B7 - Demonstrate Innovation","Be able to identify areas for improvement and suggest innovative solutions.","DO NOT USE ",null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J25)","v":0},"Net Score",{"$f":"SUM(L5:L25)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J28/L32","v":{"$error":"#VALUE!"}},"total CoE KSB coverage",{"$f":"L28/L35","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs","?"]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated","?"]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated","?"]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L32-L33-(L34*0.5)","v":{"$error":"#VALUE!"}}]

{"sheet":"ST0048","index":5,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"Construction Site Supervisor (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1 Health and Safety","Understand risk assessment of activities and the importance of behaviours in safety-critical environments",null,null,null,null,null,null,{"$f":"IF(D5:D11 = \"FULLY MET\",1,IF(D5:D11 = \"PARTIALLY MET\",0.5,IF(D5:D11 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2 Sustainability","Understand the sustainability issues in projects across economic, social and environmental aspects",null,null,null,null,null,null,0,null,"NONE"]
["K3 Construction Technology","Understand different construction methods and materials",null,null,null,null,null,null,0,null,"NONE"]
["K4 Construction Management","Understand management principles and the project management lifecycle",null,null,null,null,null,null,0,null,"NONE"]
["K5 Planning and Organising Work","Understand the importance of project planning and resourcing and be able to analyse different techniques",null,null,null,null,null,null,0,null,"NONE"]
["K6 Monitor Quality","Able to define the quality required on a finished construction project",null,null,null,null,null,null,0,null,"NONE"]
["K7 Monitor costs","Understand the importance of cost control on a construction project",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1 Health and Safety","Identify risk of activities and encourage all employees to demonstrate safety - conscious behaviours",null,null,null,null,null,null,{"$f":"IF(D13:D19 = \"FULLY MET\",1,IF(D13:D19 = \"PARTIALLY MET\",0.5,IF(D13:D19 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["S2 Sustainability","Assess, identify and record the environmental impact of projects",null,null,null,null,null,null,0,null,"NONE"]
["S3 Construction   Technology","Assist in the implementation of the most appropriate solutions for construction projects",null,null,null,null,null,null,0,null,"NONE"]
["S4 Project Management","Use effective management principles and be able to supervise construction workers",null,null,null,null,null,null,0,null,"FULL"]
["S5 Planning and Organising Work","Understand overall plan for project and measure and record progress against plan",null,null,null,null,null,null,0,null,"NONE"]
["S6 Monitor Quality","Assess and report on quality standards and assist in commissioning of finished construction projects",null,null,null,null,null,null,0,null,"NONE"]
["S7 Monitor costs","Understand financial and legal constraints and measure and record progress against budget ",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1 Professional Judgement","Be able to work within own level of competence and know when to seek advice from others",null,null,null,null,null,null,{"$f":"IF(D21:D27 = \"FULLY MET\",1,IF(D21:D27 = \"PARTIALLY MET\",0.5,IF(D21:D27 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2 Commitment to Code of Ethics","Work within Rules and Regulations of Professional Competence and Conduct for the industry’s recognised professional bodies.",null,null,null,null,null,null,0,null,"NONE"]
["B3 Continuing Professional Development","Identify own development needs and take action to meet those needs. Use own knowledge and expertise to help others when requested.",null,null,null,null,null,null,0,null,"NONE"]
["B4 Commitment to Equality and Diversity","Understand the importance of equality and diversity and demonstrate these attributes so as to meet the requirements of fairness at work.",null,null,null,null,null,null,0,null,"NONE"]
["B5 Communicate Effectively","Be able to contribute effectively to meetings and present information in a variety of ways including oral and written.",null,null,null,null,null,null,0,null,"NONE"]
["B6 Work in Teams","Be able to work with others in a collaborative and non-confrontational way.",null,null,null,null,null,null,0,null,"NONE"]
["B7 Demonstrate Innovation","Be able to identify areas for improvement and suggest innovative solutions.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J27)","v":0},"Net Score",{"$f":"SUM(L5:L27)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J30/L34","v":0},"total CoE KSB coverage",{"$f":"L30/L37","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",21]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L34-L35-(L36*0.5)","v":19.5}]

{"sheet":"ST0049","index":6,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"Construction Quantity Surveying Technician (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1 Health and Safety","Understand the principles and responsibilities imposed by law and other regulations in a construction environment",null,null,null,null,null,null,{"$f":"IF(D5:D11 = \"FULLY MET\",1,IF(D5:D11 = \"PARTIALLY MET\",0.5,IF(D5:D11 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2 Sustainability","Understand the sustainability issues in projects across economic, social and environmental aspects",null,null,null,null,null,null,0,null,"NONE"]
["K3 Construction Technology","Understand different construction techniques and materials and the principles of design",null,null,null,null,null,null,0,null,"NONE"]
["K4 Contracts","Understand different forms of contracts used in construction and why they are applied in different situations",null,null,null,null,null,null,0,null,"NONE"]
["K5 Procurement","Understand the different types of procurement process and negotiation requirements",null,null,null,null,null,null,0,null,"NONE"]
["K6 Cost control","Understand the importance of controlling costs during a construction project and the effect of changes to the project",null,null,null,null,null,null,0,null,"NONE"]
["K7 Financial reporting","Understand the various forms of reporting on project progress",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1 Health and Safety","Apply health and safety issues to all activities",null,null,null,null,null,null,{"$f":"IF(D13:D20 = \"FULLY MET\",1,IF(D13:D20 = \"PARTIALLY MET\",0.5,IF(D13:D20 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2 Sustainability","Demonstrate application of the principles of sustainability",null,null,null,null,null,null,0,null,"NONE"]
["S3 Construction Technology","Assist in the implementation of the most appropriate solutions for construction projects",null,null,null,null,null,null,0,null,"NONE"]
["S4 Contracts","Be able to apply different types of contracts to different situations",null,null,null,null,null,null,0,null,"PARTIAL"]
["S5 Procurement","Assist in the selection of and negotiation with specialist contractors for a construction project",null,null,null,null,null,null,0,null,"PARTIAL"]
["S6 Cost control","Assist in the measurement and costing of construction works during a project.",null,null,null,null,null,null,0,null,"NONE"]
["S7 Financial reporting","Assist in the preparation of financial reports, cash flow and cost forecasts for a construction project",null,null,null,null,null,null,0,null,"NONE"]
["S8 Administration","Assist in the collection, collation and storage of relevant data and its analysis",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1 Commitment to Code of Ethics","Understand and apply the Code of Conduct and conduct regulations, ethics and professional standards relevant to industry’s recognised professional bodies.",null,null,null,null,null,null,{"$f":"IF(D22:D28 = \"FULLY MET\",1,IF(D22:D28 = \"PARTIALLY MET\",0.5,IF(D22:D28 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2 Continuing Professional Development","Identify own development needs and take action to meet those needs. Use own knowledge and expertise to help others when requested.",null,null,null,null,null,null,0,null,"NONE"]
["B3 Commitment to Equality and Diversity","Understand the importance of equality and diversity and demonstrate these attributes so as to meet the requirements of fairness at work.",null,null,null,null,null,null,0,null,"NONE"]
["B4 Communicate Effectively","Be able to contribute effectively to meetings and present information in a variety of ways including oral and written.",null,null,null,null,null,null,0,null,"NONE"]
["B5 Conflict avoidance","Be able to assist in planning to avoid conflict and resolving issues that do arise",null,null,null,null,null,null,0,null,"NONE"]
["B6 Work in Teams","Be able to work with others in a collaborative and non-confrontational way.",null,null,null,null,null,null,0,null,"NONE"]
["B7 Demonstrate Innovation","Be able to identify areas for improvement and suggest innovative solutions.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J28)","v":0},"Net Score",{"$f":"SUM(L5:L28)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J31/L35","v":0},"total CoE KSB coverage",{"$f":"L31/L38","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",22]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L35-L36-(L37*0.5)","v":21}]

{"sheet":"ST0484","index":7,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[null,"Facilities Manager"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
[null,"Property asset management:"]
["K1","Implications of property ownership",null,null,null,null,null,null,{"$f":"IF(D6:D10 = \"FULLY MET\",1,IF(D6:D10 = \"PARTIALLY MET\",0.5,IF(D6:D10 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","Establishment & management of registers for property & fixed assets",null,null,null,null,null,null,0,null,"NONE"]
["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"]
["K4","Relocation requirements & factors involved",null,null,null,null,null,null,0,null,"NONE"]
["K5","Layout, flow management & space planning techniques; accessibility & inclusion",null,null,null,null,null,null,0,null,"NONE"]
[null,"Service delivery"]
["K6","Principles of contract management",null,null,null,null,null,null,{"$f":"IF(D12:D14 = \"FULLY MET\",1,IF(D12:D14 = \"PARTIALLY MET\",0.5,IF(D12:D14 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K7","Problem solving techniques, prevention measures, corrective actions",null,null,null,null,null,null,0,null,"NONE"]
["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"]
[null,"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(D16:D18 = \"FULLY MET\",1,IF(D16:D18 = \"PARTIALLY MET\",0.5,IF(D16:D18 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K10","The impact of FM on the environment",null,null,null,null,null,null,0,null,"NONE"]
["K11","Principles of risk management; business continuity planning",null,null,null,null,null,null,0,null,"NONE"]
[null,"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(D20 = \"FULLY MET\",1,IF(D20 = \"PARTIALLY MET\",0.5,IF(D20 = \"NOT MET\",0,)))","v":0},null,"NONE"]
[null,"Policy implementation and change management"]
["K13","FM organizational and service requirements, targets & objectives",null,null,null,null,null,null,{"$f":"IF(D22:D24 = \"FULLY MET\",1,IF(D22:D24 = \"PARTIALLY MET\",0.5,IF(D22:D24 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["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"]
["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"]
[null,"Quality and stakeholder management"]
["K16","Quality management in FM",null,null,null,null,null,null,{"$f":"IF(D26:D29 = \"FULLY MET\",1,IF(D26:D29 = \"PARTIALLY MET\",0.5,IF(D26:D29 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K17","Client objectives, requirements & value; Service Level Agreements (SLAs)",null,null,null,null,null,null,0,null,"NONE"]
["K18","Survey & benchmarking techniques",null,null,null,null,null,null,0,null,"NONE"]
["K19","Uses of customer feedback; principles of continuous improvement; influencing techniques",null,null,null,null,null,null,0,null,"NONE"]
[null,"People management"]
["K20","Ways of recording and tracking human resources capabilities",null,null,null,null,null,null,{"$f":"IF(D31:D33 = \"FULLY MET\",1,IF(D31:D33 = \"PARTIALLY MET\",0.5,IF(D31:D33 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K21","The impact of change on people HR-related legislation affecting FM",null,null,null,null,null,null,0,null,"NONE"]
["K22","Capability building, HR tools and techniques",null,null,null,null,null,null,0,null,"NONE"]
[null,"Financial and procurement management"]
["K23","Financial/budget/resource management & reporting systems and processes & techniques",null,null,null,null,null,null,{"$f":"IF(D35:D36 = \"FULLY MET\",1,IF(D35:D36 = \"PARTIALLY MET\",0.5,IF(D35:D36 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K24","Accountability within delegated financial authorities Organizational procurement policies and processes & client objectives and requirements",null,null,null,null,null,null,0,null,"PARTIAL"]
[null,"Skills"]
[null,"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(D39 = \"FULLY MET\",1,IF(D39 = \"PARTIALLY MET\",0.5,IF(D39 = \"NOT MET\",0,)))","v":0},null,"NONE"]
[null,"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(D41 = \"FULLY MET\",1,IF(D41 = \"PARTIALLY MET\",0.5,IF(D41 = \"NOT MET\",0,)))","v":0},null,"NONE"]
[null,"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(D43 = \"FULLY MET\",1,IF(D43 = \"PARTIALLY MET\",0.5,IF(D43 = \"NOT MET\",0,)))","v":0},null,"NONE"]
[null,"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(D45 = \"FULLY MET\",1,IF(D45 = \"PARTIALLY MET\",0.5,IF(D45 = \"NOT MET\",0,)))","v":0},null,"FULL"]
[null,"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(D47 = \"FULLY MET\",1,IF(D47 = \"PARTIALLY MET\",0.5,IF(D47 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
[null,"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(D49 = \"FULLY MET\",1,IF(D49 = \"PARTIALLY MET\",0.5,IF(D49 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
[null,"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(D51 = \"FULLY MET\",1,IF(D51 = \"PARTIALLY MET\",0.5,IF(D51 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
[null,"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(D53 = \"FULLY MET\",1,IF(D53 = \"PARTIALLY MET\",0.5,IF(D53 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
[null,"Behaviours"]
["B1 Customer focus","Exceed customer expectations and add value",null,null,null,null,null,null,{"$f":"IF(D55:D61 = \"FULLY MET\",1,IF(D55:D61 = \"PARTIALLY MET\",0.5,IF(D55:D61 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["B2 Collaboration","Work in partnership with others for the common good",null,null,null,null,null,null,0,null,"NONE"]
["B3 Influencing","Anticipating and responding to others’ needs and influencing them to enhance performance",null,null,null,null,null,null,0,null,"NONE"]
["B4 Innovation & quality","Aim for a higher level of excellence",null,null,null,null,null,null,0,null,"NONE"]
["B5 Ethics & integrity","Work for the greater good and not sacrifice high standards for immediate gain or personal benefit",null,null,null,null,null,null,0,null,"NONE"]
["B6 Leading people","Foster the growth of themselves and others, inspiring them to exceed their personal and professional goal",null,null,null,null,null,null,0,null,"NONE"]
["B7 Systematic approach","Approach work in an orderly way",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J6:J61)","v":0},"Net Score",{"$f":"SUM(L6:L61)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J64/L68","v":0},"total CoE KSB coverage",{"$f":"L64/L71","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",1]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",6]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L68-L69-(L70*0.5)","v":35}]

{"sheet":"ST0613","index":8,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,"Acoustics Technician (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","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(D5:D14 = \"FULLY MET\",1,IF(D5:D14 = \"PARTIALLY MET\",0.5,IF(D5:D14 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["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"]
["K3","Level 4 mathematics for undertaking hand and spreadsheet based acoustic calculations.",null,null,null,null,null,null,0,null,"NONE"]
["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"]
["K5","Sound and vibration measuring and recording techniques in laboratory, internal and external environments.",null,null,null,null,null,null,0,null,"NONE"]
["K6","Sustainable practices in the design and manufacture of acoustic products.",null,null,null,null,null,null,0,null,"NONE"]
["K7","Technical drawing using Computer Aided Design software packages.",null,null,null,null,null,null,0,null,"NONE"]
["K8","Acoustic modelling software and methods and their use in the sector.",null,null,null,null,null,null,0,null,"NONE"]
["K9","Technical report writing techniques for both internal and external audiences.",null,null,null,null,null,null,0,null,"NONE"]
["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"]
[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(D16:D26 = \"FULLY MET\",1,IF(D16:D26 = \"PARTIALLY MET\",0.5,IF(D16:D26 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["S2","Plan, measure, analyse and report acoustic data.",null,null,null,null,null,null,0,null,"NONE"]
["S3","Operate acoustic modelling software appropriate to their organisation.",null,null,null,null,null,null,0,null,"NONE"]
["S4","Operate Computer Aided Design software packages.",null,null,null,null,null,null,0,null,"NONE"]
["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"]
["S6","Undertake acoustics calculations manually and using spreadsheets.",null,null,null,null,null,null,0,null,"NONE"]
["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"]
["S8","Listen critically and interpret sound correctly.",null,null,null,null,null,null,0,null,"NONE"]
["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"]
["S10","Produce succinct and understandable reports for the end user.",null,null,null,null,null,null,0,null,"NONE"]
["S11","Think critically, analyse and clearly present the outputs of acoustic information.",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","Accuracy and diligence in practical work in both laboratory and site contexts.",null,null,null,null,null,null,{"$f":"IF(D28:D32 = \"FULLY MET\",1,IF(D28:D32 = \"PARTIALLY MET\",0.5,IF(D28:D32 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["B2","Team working with others in a collaborative and non-confrontational way.",null,null,null,null,null,null,0,null,"NONE"]
["B3","Attention to detail in results outputs against standards, guidance and client briefs.",null,null,null,null,null,null,0,null,"NONE"]
["B4","Time management",null,null,null,null,null,null,0,null,"NONE"]
["B5","Commitment to Equality and Diversity",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J32)","v":0},"Net Score",{"$f":"SUM(L5:L32)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J35/L39","v":0},"total CoE KSB coverage",{"$f":"L35/L42","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,"partialy mitigated",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L39-L40-(L41*0.5)","v":25}]

{"sheet":"ST0629","index":9,"n_rows":66,"n_cols":17,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,"BEMS (Building energy management systems) controls engineer (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
["-","Knowledge"]
["K1","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(D5:D23 = \"FULLY MET\",1,IF(D5:D23 = \"PARTIALLY MET\",0.5,IF(D5:D23 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","K2: Understand the fundamentals of controlling HVAC (heating, ventilation and air conditioning) and building technology",null,null,null,null,null,null,0,null,"NONE"]
["K3","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"]
["K4","K4: Understand thermodynamic relationships in air conditioning systems",null,null,null,null,null,null,0,null,"NONE"]
["K5","K5: Understand cooling systems, heat generation and renewable technology",null,null,null,null,null,null,0,null,"NONE"]
["K6","K6: Understand the principles and practices of measurement technology",null,null,null,null,null,null,0,null,"NONE"]
["K7","K7: Understand Control Panel wiring, construction and relay logic",null,null,null,null,null,null,0,null,"NONE"]
["K8","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"]
["K9","K9: Understand communications technology protocols and media",null,null,null,null,null,null,0,null,"NONE"]
["K10","K10: Understand the practices and procedures for the installation of BEMS wiring systems",null,null,null,null,null,null,0,null,"NONE"]
["K11","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"]
["K12","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"]
["K13","K13: Understand the energy efficiency and comfort control requirement within buildings",null,null,null,null,null,null,0,null,"NONE"]
["K14","K14: Understand the testing, inspection and certification of BEMS related controls equipment",null,null,null,null,null,null,0,null,"NONE"]
["K15","K15: Understand the operation and application of BEMS field devices e.g. sensors",null,null,null,null,null,null,0,null,"NONE"]
["K16","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"]
["K17","K17: Understand the general characteristics of electrical installations and how to assess them",null,null,null,null,null,null,0,null,"NONE"]
["K18","K18: Understand the requirements of inspection and testing of BEMS element of electrical installations",null,null,null,null,null,null,0,null,"NONE"]
["K19","K19: Understand the principles of control logic including the fundamentals of proportional and integral control",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","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(D25:D43 = \"FULLY MET\",1,IF(D25:D43 = \"PARTIALLY MET\",0.5,IF(D25:D43 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","S2: Incorporating hydrodynamics/ hydronic systems into designs",null,null,null,null,null,null,0,null,"NONE"]
["S3","S3: Applying the principles and practices of measurement technology",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4: Incorporating cooling systems, heat generation and renewable technology into designs as applicable",null,null,null,null,null,null,0,null,"NONE"]
["S5","S5: Incorporating Control Panel wiring, construction and relay logic into the design process",null,null,null,null,null,null,0,null,"NONE"]
["S6","S6: Applying communications technology protocols and media e.g. MODBUS and BACNET",null,null,null,null,null,null,0,null,"NONE"]
["S7","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"]
["S8","S8: Identifying requirements for protection of electrical installations",null,null,null,null,null,null,0,null,"NONE"]
["S9","S9: Incorporating the needs of a variety of building stakeholders (e.g. owners/ operators) within the design of the BEMS system",null,null,null,null,null,null,0,null,"NONE"]
["S10","S10: Applying the practices and procedures for the installation of BEMS wiring systems",null,null,null,null,null,null,0,null,"NONE"]
["S11","S11: Interpreting the requirements for the BEMS element of electrical installations",null,null,null,null,null,null,0,null,"NONE"]
["S12","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"]
["S13","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"]
["S14","S14: Applying the principles for completing conditional site surveys, along with associated recommendations",null,null,null,null,null,null,0,null,"NONE"]
["S15","S15: Applying knowledge of energy efficiency to optimise comfort in buildings whilst minimising energy usage",null,null,null,null,null,null,0,null,"NONE"]
["S16","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"]
["S17","S17: Carrying out the testing, inspection and certification of BEMS related controls and equipment",null,null,null,null,null,null,0,null,"NONE"]
["S18","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"]
["S19","S19: Carrying out updates to BEMS system hardware to ensure compatibility with latest products",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","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(D45:D56 = \"FULLY MET\",1,IF(D45:D56 = \"PARTIALLY MET\",0.5,IF(D45:D56 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","B2: Create maintain, and enhance productive working relationships",null,null,null,null,null,null,0,null,"NONE"]
["B3","B3: Commit to compliance with health and safety",null,null,null,null,null,null,0,null,"NONE"]
["B4","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"]
["B5","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"]
["B6","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"]
["B7","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"]
["B8","B8: Accepting, prioritizing, delegating and undertaking technical and other tasks effectively",null,null,null,null,null,null,0,null,"NONE"]
["B9","B9: Committed to working effectively with colleagues, the public, clients and other stakeholders",null,null,null,null,null,null,0,null,"FULL"]
["B10","B10: Take responsibility for personal development, demonstrating commitment to learning and self-improvement",null,null,null,null,null,null,0,null,"NONE"]
["B11","B11: Exercise responsibilities in an ethical manner",null,null,null,null,null,null,0,null,"NONE"]
["B12","B12: Undertake work in a way that contributes to sustainable development",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J56)","v":0},"Net Score",{"$f":"SUM(L5:L56)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J59/L63","v":0},"total CoE KSB coverage",{"$f":"L59/L66","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",1]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L63-L64-(L65*0.5)","v":49}]

{"sheet":"ST0877","index":10,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"Land Referencer (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","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(D5:D20 = \"FULLY MET\",1,IF(D5:D20 = \"PARTIALLY MET\",0.5,IF(D5:D20 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["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"]
["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"]
["K4","UK consent methods and instruments.",null,null,null,null,null,null,0,null,"NONE"]
["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"]
["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"]
["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"]
["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"]
["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"]
["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"]
["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"]
["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"]
["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"]
["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"]
["K15","The definition, significance, identification and recording of special category land and crown land.",null,null,null,null,null,null,0,null,"NONE"]
["K16","The process of site notice planning, production, erection, maintenance and proof of service.",null,null,null,null,null,null,0,null,"NONE"]
[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(D22:D31 = \"FULLY MET\",1,IF(D22:D31 = \"PARTIALLY MET\",0.5,IF(D22:D31 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["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"]
["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"]
["S4","Maintain accurate records in accordance with company procedures.",null,null,null,null,null,null,0,null,"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,"FULL"]
["S6","Plan site visits to enable the required data collection.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S7","Analyse land features and how they impact or inform legal interest in the land.",null,null,null,null,null,null,0,null,"NONE"]
["S8","Serve notices, evidencing that they have been successfully served in accordance with relevant legislation.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S9","Monitor site notices and provide a prompt response to returned notices or queries from affected parties.",null,null,null,null,null,null,0,null,"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,"PARTIAL"]
[null,"Behaviours"]
["B1","Adopt a professional approach to work, respect confidentiality and work collaboratively across multiple disciplines.",null,null,null,null,null,null,{"$f":"IF(D33:D36 = \"FULLY MET\",1,IF(D33:D36 = \"PARTIALLY MET\",0.5,IF(D33:D36 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["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"]
["B3","Work independently, self-manage and prioritise work and own professional development.",null,null,null,null,null,null,0,null,"NONE"]
["B4","Demonstrate a commitment to equality, diversity and inclusion.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J36)","v":0},"Net Score",{"$f":"SUM(L5:L36)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J39/L43","v":0},"total CoE KSB coverage",{"$f":"L39/L46","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",2]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",5]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L43-L44-(L45*0.5)","v":25.5}]

{"sheet":"Source filters ","index":11,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Additional content","YES","Standard 1","FULLY MET",null,"PARTIAL"]
[null,"NO","Standard 2","PARTIALLY MET",null,"FULL"]
["ST0043",null,"Standard 3","NOT MET "]
["ST0048",null,"Standard 4"]
["ST0049",null,"Standard 5"]
["ST0484",null,"Standard 6"]
["ST0613",null,"NO COVERAGE "]
["ST0629"]
["ST0877"]
[null,null,"Provider setting (e.g. classroom)"]
[null,null,"Online"]
[null,null,"Distance"]
[null,null,"Placement"]
[null,null,"Mixed"]
[]
[]
[]
[]
[]
[]
[]
[]
["Year 1"]
["Year 2"]
["Year 3"]
["Year 4"]
["Across years"]
["Core "]
["Option"]
[]
["Yes"]
["No"]
[]
[4]
[5]