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

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

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

{"sheet":"ST0484","index":4,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":false,"merged":[[56,0,56,6],[58,0,58,6],[50,0,50,6],[75,0,75,6],[77,0,77,6],[60,0,60,6],[62,0,62,6],[64,0,64,6],[66,0,66,6],[68,0,68,6],[9,0,9,6],[9,8,9,15],[10,8,11,15],[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]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING",null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Facilities Manager (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["Property Asset management"]
["K1","Implications of property ownership",null,null,null,null,null,null,{"$f":"IF(C23:C27 = \"FULLY MET\",1,IF(C23:C27 = \"PARTIALLY MET\",0.5,IF(C23:C27 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K2","Establishment & management of registers for property & fixed assets",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J24=1,1,IF(J24=0.5,0.5,IF(J24=0,0)))","v":0},{"$f":"IF(L24=1,\"NONE\",IF(L24=0.5,\"PARTIAL\",IF(L24=0,\"FULL\")))","v":"FULL"}]
["K3","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",{"$f":"IF(J25=1,1,IF(J25=0.5,0.5,IF(J25=0,0)))","v":0},{"$f":"IF(L25=1,\"NONE\",IF(L25=0.5,\"PARTIAL\",IF(L25=0,\"FULL\")))","v":"FULL"}]
["K4","Relocation requirements & factors involved",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J26=1,1,IF(J26=0.5,0.5,IF(J26=0,0)))","v":0},{"$f":"IF(L26=1,\"NONE\",IF(L26=0.5,\"PARTIAL\",IF(L26=0,\"FULL\")))","v":"FULL"}]
["K5","Layout, flow management & space planning techniques; accessibility & inclusion",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J27=1,1,IF(J27=0.5,0.5,IF(J27=0,0)))","v":0},{"$f":"IF(L27=1,\"NONE\",IF(L27=0.5,\"PARTIAL\",IF(L27=0,\"FULL\")))","v":"FULL"}]
["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},{"$f":"IF(L29=1,\"NONE\",IF(L29=0.5,\"PARTIAL\",IF(L29=0,\"FULL\")))","v":"FULL"}]
["K7","Problem solving techniques, prevention measures, corrective actions",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J30=1,1,IF(J30=0.5,0.5,IF(J30=0,0)))","v":0},{"$f":"IF(L30=1,\"NONE\",IF(L30=0.5,\"PARTIAL\",IF(L30=0,\"FULL\")))","v":"FULL"}]
["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",{"$f":"IF(J31=1,1,IF(J31=0.5,0.5,IF(J31=0,0)))","v":0},{"$f":"IF(L31=1,\"NONE\",IF(L31=0.5,\"PARTIAL\",IF(L31=0,\"FULL\")))","v":"FULL"}]
["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},{"$f":"IF(L33=1,\"NONE\",IF(L33=0.5,\"PARTIAL\",IF(L33=0,\"FULL\")))","v":"FULL"}]
["K10","The impact of FM on the environment",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"}]
["K11","Principles of risk management; business continuity planning",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J35=1,1,IF(J35=0.5,0.5,IF(J35=0,0)))","v":0},{"$f":"IF(L35=1,\"NONE\",IF(L35=0.5,\"PARTIAL\",IF(L35=0,\"FULL\")))","v":"FULL"}]
["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},{"$f":"IF(L37=1,\"NONE\",IF(L37=0.5,\"PARTIAL\",IF(L37=0,\"FULL\")))","v":"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},{"$f":"IF(L39=1,\"NONE\",IF(L39=0.5,\"PARTIAL\",IF(L39=0,\"FULL\")))","v":"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",{"$f":"IF(J40=1,1,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=1,\"NONE\",IF(L40=0.5,\"PARTIAL\",IF(L40=0,\"FULL\")))","v":"FULL"}]
["K15","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",{"$f":"IF(J41=1,1,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=1,\"NONE\",IF(L41=0.5,\"PARTIAL\",IF(L41=0,\"FULL\")))","v":"FULL"}]
["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},{"$f":"IF(L43=1,\"NONE\",IF(L43=0.5,\"PARTIAL\",IF(L43=0,\"FULL\")))","v":"FULL"}]
["K17","Client objectives, requirements & value; Service Level Agreements (SLAs)",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"}]
["K18","Survey & benchmarking techniques",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"FULL"}]
["K19","Uses of customer feedback; principles of continuous improvement; influencing techniques",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"}]
["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},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["K21","The impact of change on people HR-related legislation affecting FM",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"}]
["K22","Capability building, HR tools and techniques",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"}]
["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},{"$f":"IF(L52=1,\"NONE\",IF(L52=0.5,\"PARTIAL\",IF(L52=0,\"FULL\")))","v":"FULL"}]
["K24","Accountability within delegated financial authorities Organizational procurement policies and processes & client objectives and requirements",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J53=1,0.5,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=0.5,\"NONE\",IF(L53=0,\"PARTIAL\"))","v":"PARTIAL"}]
[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:C56 = \"FULLY MET\",1,IF(C56:C56 = \"PARTIALLY MET\",0.5,IF(C56: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:C58 = \"FULLY MET\",1,IF(C58:C58 = \"PARTIALLY MET\",0.5,IF(C58: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:C60 = \"FULLY MET\",1,IF(C60:C60 = \"PARTIALLY MET\",0.5,IF(C60: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,"FULL",{"$f":"IF(J62=1,0,IF(J62=0.5,0,IF(J62=0,0)))","v":0},{"$f":"IF(L62=0,\"NONE\")","v":"NONE"}]
["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:C64 = \"FULLY MET\",1,IF(C64:C64 = \"PARTIALLY MET\",0.5,IF(C64:C64 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J64=1,0.5,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=0.5,\"NONE\",IF(L64=0,\"PARTIAL\"))","v":"PARTIAL"}]
["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:C66 = \"FULLY MET\",1,IF(C66:C66 = \"PARTIALLY MET\",0.5,IF(C66:C66 = \"NOT MET\",0,)))","v":0},null,"FULL",{"$f":"IF(J66=1,0,IF(J66=0.5,0,IF(J66=0,0)))","v":0},{"$f":"IF(L66=0,\"NONE\")","v":"NONE"}]
["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:C68 = \"FULLY MET\",1,IF(C68:C68 = \"PARTIALLY MET\",0.5,IF(C68: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:C70 = \"FULLY MET\",1,IF(C70:C70 = \"PARTIALLY MET\",0.5,IF(C70: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:C73 = \"FULLY MET\",1,IF(C73:C73 = \"PARTIALLY MET\",0.5,IF(C73: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:C75 = \"FULLY MET\",1,IF(C75:C75 = \"PARTIALLY MET\",0.5,IF(C75: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":"J90/L94","v":0},"total CoE KSB coverage",{"$f":"L90/L97","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",2]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L94-L95-(L96*0.5)","v":35}]

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

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