{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["GUIDE TO KSB MAPPING","ST0406","ST0475","ST0540","ST0580","ST0588","ST0605","ST0624","ST0662","ST0841","ST0847","ST0855","ST0861","ST0875","ST0999","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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 (or I-M for ST0475; E-I for ST0588, ST0624, ST0847; H-L for ST0605) 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":"ST0406","index":1,"n_rows":71,"n_cols":18,"rows_kept":71,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Vehicle damage assessor (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Vehicles construction and materials",null,null,null,null,null,null,{"$f":"IF(C22:C38 = \"FULLY MET\",1,IF(C22:C38 = \"PARTIALLY MET\",0.5,IF(C22:C38 = \"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","Steering, suspension and braking, systems and operations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Transmission and drivelines",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The principles of electrical systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Electrical/electronic components",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Vehicle safety systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Tools and equipment used in the process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Understand current Health & Safety legislation in the workplace",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The structure of their organisation or workplace",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The importance of teamwork in the workplace",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How to communicate effectively",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Up to date vehicle repair technologies including Paint, Panel and MET",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Good understanding of commercial aspects of a body shop",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How to produce a job card",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Non-accidental related damage",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Electronic costings systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Industry vehicle Repair methods",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Recognise properties of different types of vehicle damage",null,null,null,null,null,null,{"$f":"IF(C40:C53 = \"FULLY MET\",1,IF(C40:C53 = \"PARTIALLY MET\",0.5,IF(C40:C53 = \"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"}]
["S2","Maintain records",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Use manual and digital image technology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Locate vehicle unique identification details",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Diagnose safety faults on vehicles",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Read, adhere to and apply relevant legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Use repair methods",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Make judgements on vehicle damage, taking into account safety and cost",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Commercial decision making",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Prepare costings based on parts and labour ratios",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Oral communication, listening and negotiation skills",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Use industry guidelines appropriately",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Recognises importance of gaining approval before work commences",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Use of estimating software, spreadsheets, on-line databases",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Customer focussed – demonstrate behaviour that puts the customer first",null,null,null,null,null,null,{"$f":"IF(C55:C61 = \"FULLY MET\",1,IF(C55:C61 = \"PARTIALLY MET\",0.5,IF(C55:C61 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J55=1,1,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=1,\"NONE\",IF(L55=0.5,\"PARTIAL\",IF(L55=0,\"FULL\")))","v":"FULL"}]
["B2","A right first time approach committed to delivering and maintaining high quality workplace standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","A calm and reasoned approach",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","A professional approach, demonstrates integrity and confidence in daily activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Adherence to company values, shows passion and enthusiasm for the industry",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Take responsibility for health and safety",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Attention to detail",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J61)","v":0},"Net Score",{"$f":"SUM(L22: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",38]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L68-L69-(L70*0.5)","v":38}]

{"sheet":"ST0475","index":2,"n_rows":180,"n_cols":24,"rows_kept":180,"cut":false,"hidden":false,"merged":[[110,14,110,18],[134,14,134,18],[146,14,146,18],[158,14,158,18],[170,14,170,18],[122,14,122,18],[9,0,9,12],[10,2,10,7],[20,1,21,7],[23,2,23,7],[98,14,98,18]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Electrical power networks engineer  occupation, plus the specific KSBs for Asset Management Engineer, Planning Engineer, Design Engineer, Control Engineer, Electrical Project Engineer and Operational Delivery Engineer options)","Included in:",null,null,null,null,null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column L) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column K does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,null,"Electrical power networks engineer (level 4) - Asset Management Engineer","Electrical power networks engineer (level 4) - Planning Engineer","Electrical power networks engineer (level 4) - Design Engineer","Electrical power networks engineer (level 4) - Control Engineer","Electrical power networks engineer (level 4) - Electrical Project Engineer","Electrical power networks engineer (level 4) - Operational Delivery Engineer"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","YES","YES","YES","YES","YES","YES","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","YES","YES","YES","YES","YES","YES","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,"Electrical power networks engineer (level 4)"]
[null,"Return to Guide"]
[null,"Six options are available (columns C-H). Please check if the KSB needs to be mapped against the option of your choice. If you map against two or more options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
[]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Electrical power networks engineer  occupation, plus the specific KSBs for Asset Management Engineer, Planning Engineer, Design Engineer, Control Engineer, Electrical Project Engineer and Operational Delivery Engineer options)","Included in:",null,null,null,null,null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column L) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column K does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge - an Electrical Power Network Engineer understands:","Electrical power networks engineer (level 4) - Asset Management Engineer","Electrical power networks engineer (level 4) - Planning Engineer","Electrical power networks engineer (level 4) - Design Engineer","Electrical power networks engineer (level 4) - Control Engineer","Electrical power networks engineer (level 4) - Electrical Project Engineer","Electrical power networks engineer (level 4) - Operational Delivery Engineer"]
["K1","Electrical power principles: alternating current/direct current theories; dynamic/static engineering systems; application of electrical and electronic circuit theory; the use of complex wave forms","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(I26:I35 = \"FULLY MET\",1,IF(I26:I35 = \"PARTIALLY MET\",0.5,IF(I26:I35 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(P26=1,1,IF(P26=0.5,0.5,IF(P26=0,0)))","v":0},{"$f":"IF(R26=1,\"NONE\",IF(R26=0.5,\"PARTIAL\",IF(R26=0,\"FULL\")))","v":"FULL"}]
["K2","Three-phase systems with consideration being given to harmonics and their effects and the methods of power distribution","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Electricity network design, capabilities, complexities, operations and topologies; operation and limitations of plant and equipment","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The operation of the electricity network in normal and fault conditions","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Safe systems of work and risk management; the application of Electricity Supply Standards, Regulations including environmental requirements. These are Health and Safety at Work Act 1974, Electricity at Work Regulations 1989, Management of Health & Safety at Work Regulations 2003, Control of Substances Hazardous to Health (COSHH) Regulations 2002, The Electricity Safety, Quality and Continuity Regulations 2002, The Environmental Protection Act 1990","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Company requirements with regard to project management tools, techniques and processes","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Company engineering policies appropriate to their role","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Engineering problems including how to identify the problem, gather and analyse all relevant information, provide and implement a workable solution and monitoring its effectiveness","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Company business planning and resource control measures","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The key interfaces of the electricity network and the impact of those interfaces","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills - an Electrical Power Network Engineer will apply their knowledge of the electricity network to safely perform their activities. This requires them to:"]
["S1","Comply with company and Industry health, safety and environmental standards, regulations, company operating procedures and working practices","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(I37:I89 = \"FULLY MET\",1,IF(I37:I89 = \"PARTIALLY MET\",0.5,IF(I37:I89 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(P37=1,1,IF(P37=0.5,0.5,IF(P37=0,0)))","v":0},{"$f":"IF(R37=1,\"NONE\",IF(R37=0.5,\"PARTIAL\",IF(R37=0,\"FULL\")))","v":"FULL"}]
["S2","Ensure that all safety considerations are incorporated and evident in all working practices","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(P38=1,1,IF(P38=0.5,0.5,IF(P38=0,0)))","v":0},{"$f":"IF(R38=1,\"NONE\",IF(R38=0.5,\"PARTIAL\",IF(R38=0,\"FULL\")))","v":"FULL"}]
["S3","Apply asset management, design, planning, control, electrical project or operational engineering principles, as appropriate to their role, to maintain and improve the integrity, safety and longevity of the transmission/distribution electrical network","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Produce timely communications providing information to stakeholders both in writing and verbally in relation to their role activities","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Read, understand and interpret technical information relative to their role, identified in company strategies and policies and work in compliance with technical specifications","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(P41=1,0.5,IF(P41=0.5,0.5,IF(P41=0,0)))","v":0},{"$f":"IF(R41=0.5,\"NONE\",IF(R41=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S6","Produce clear and precise reports in relation to their activities to line management, other business departments and to external stakeholders","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Develop and agree project plans to undertake their activities. These plans will contain clear objectives, budgets, desired outcomes and timescales. Also included will be implementation criteria, monitoring process controls and evaluation records","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Use company IT systems to provide accurate and reliable data to support business decisions","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Demonstrate that their work activities supports the business to achieve its regulatory incentive mechanisms","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Provide information to support business planning processes in relation to their role activities.","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Uses company risk tools and techniques to evaluate and predict the reliability of engineering systems and equipment","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Support the development of innovative policy solutions to best serve the needs of customers and stakeholders","YES","NO","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Plan, develop and produce long term network reinforcement plans taking into account emerging technologies and projected future load requirements","YES","NO","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Understand and interpret Regulatory requirements and business plans and contribute to the production of Regulatory technical returns","YES","NO","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Assimilate complex external information to inform company decisions","YES","NO","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Evaluate plant and equipment proposals and recommend company approaches","YES","NO","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Instigate, as appropriate, investigations into asset, systems or process failures as well as undertaking network performance analysis","YES","NO","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Support the identification of new and existing innovation projects","YES","NO","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Identify the implications of the next generation of low carbon energy and how it influences the way the network is operated","YES","NO","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Build and be accountable for a rolling and dynamic plan, including managing conflicts and changes, for all operational and capital works","NO","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Prioritise all works to be delivered taking into account capital delivery and contractor resources ensuring that all outcome targets are considered","NO","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Ensure area plans are built optimally, utilising resource skill sets and plan the appropriate outages, negotiating and confirming these by utilising the switching matrix","NO","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Ensure all risk assessments are initiated in a timely manner, that any constraints are assessed and managed and any mitigating actions are determined","NO","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Ensure all planning decisions are documented in the relevant systems and are communicated with reasoning to all relevant stakeholders","NO","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Ensure assets are compliant with statutory requirements, company policy obligations and optimal/limit dates and assess asset condition data against maintenance policy risk & criticality criteria","NO","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(P61=1,0.5,IF(P61=0.5,0.5,IF(P61=0,0)))","v":0},{"$f":"IF(R61=0.5,\"NONE\",IF(R61=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S26","Be accountable for both resource and outage planning ownership and authority of work to be included or removed from the plan","NO","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Taking the long term network plan into consideration, translate company strategies into specific designs","NO","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(P63=1,0.5,IF(P63=0.5,0.5,IF(P63=0,0)))","v":0},{"$f":"IF(R63=0.5,\"NONE\",IF(R63=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S28","Make proposals regarding appropriate plant & equipment to be used and the benefits of the proposals","NO","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S29","Undertake all aspects of design from outlines to detailed plans. This involves approvals, wayleaves, consents, appropriate regulations and costing information","NO","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S30","Take into account the implications of safety and environmental requirements, statutory and industry standards, technical system requirements and commercial constraints on design plans","NO","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Demonstrate the application of appropriate methods to identify correct load calculations and produce network diagrams","NO","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S32","Ensure that proposed designs meet commercial, investment requirements and take into account innovation developments ","NO","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S33","Remotely control the electrical network, in accordance with operating procedures and safety rules to ensure the safe and efficient operation of the power system. ","NO","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S34","Control all outages and network access requests ensuring risks to the network and system security are minimised","NO","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S35","Manage planned and fault operations and activities on the network to provide a safe and secure electricity supply","NO","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S36","Undertake work in complex, dynamic and reactive environments and provide technical and operational guidance to the rest of the business. ","NO","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S37","Agree and co-ordinate the work of others to maximise network availability and minimise network risks","NO","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S38","Escalate significant network incidents throughout the business as appropriate and monitoring of real time impacts on the system","NO","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S39","Ensure interface arrangements and impact of embedded generation are considered where appropriate","NO","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S40","Gain appropriate Control Engineer Authorisation in-line with company requirements","NO","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S41","Project manage activities to ensure projects are delivered on time, meet stakeholder and budget requirements","NO","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S42","Understand and work to project designs and interpret requirements to fit the specific environment the project is being constructed in","NO","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S43","Manage stakeholder relations and produce final construction plans. ","NO","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S44","Undertake contractor management of external parties, agreeing work specifications, variations and acceptance of work completion in-line with company processes and procedures","NO","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(P80=1,0.5,IF(P80=0.5,0.5,IF(P80=0,0)))","v":0},{"$f":"IF(R80=0.5,\"NONE\",IF(R80=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S45","Be Authorised to work on the electricity network in-line with company/asset owner requirements","NO","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S46","Issue, review and communicate to all site personnel the agreed safe systems of works associated with the activities being carried out. ","NO","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S47","Ensure the completion of final hand back documentation to the agreed specifications and timescales. ","NO","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S48","Plan, manage and undertake a range of engineering activities and operations to the electricity network, to meet design, safety, time and commercial requirements","NO","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S49","Be Authorised to work on the electricity network in-line with company/asset owner requirements","NO","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S50","Understand and take control of reactive activities including testing, inspection and maintenance of appropriate plant and equipment to meet operational requirements","NO","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S51","Take responsibility for and control others who may be working on the network","NO","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S52","Issue, review and communicate to all site personnel the agreed safe systems of works associated with the activities being carried out","NO","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S53","Ensure the completion of final hand back documentation to the agreed specifications and timescales","NO","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Health, Safety & Environment – follows health, safety and environmental policies and procedures and is prepared to challenge unsafe behaviour using appropriate techniques to ensure the protection of people and property when working alone and/or with teams. Demonstrates high concentration and the desire to reduce risks through regular monitoring and checking information","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(I91:I96 = \"FULLY MET\",1,IF(I91:I96  = \"PARTIALLY MET\",0.5,IF(I91:I96  = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(P91=1,1,IF(P91=0.5,0.5,IF(P91=0,0)))","v":0},{"$f":"IF(R91=1,\"NONE\",IF(R91=0.5,\"PARTIAL\",IF(R91=0,\"FULL\")))","v":"FULL"}]
["B2","Stakeholder management – is proactive in identifying their stakeholders and managing their expectations, presenting appropriate information to them clearly and concisely.","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Interpersonal skills - works well with people from different disciplines, backgrounds and expertise. Takes others’ needs and concerns into account and supports them to accomplish an activity safely and on time. ","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Analysing and solving problems – takes responsibility for solving problems by identifying and analysing the issues and drawing logical, sound solutions that benefit customers and the business. ","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Risk awareness – has the embedded desire to reduce risks through systematic monitoring and checking of information identifying mitigation actions on an on- going basis to achieve safe systems of work","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Planning & organising – takes a forward looking perspective when considering the delivery of decisions, activities and projects and ensure plans are in place to manage anticipated issues, considers contingency planning","YES","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(P96=1,1,IF(P96=0.5,0.5,IF(P96=0,0)))","v":0},{"$f":"IF(R96=1,\"NONE\",IF(R96=0.5,\"PARTIAL\",IF(R96=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical power networks engineer (level 4) - Asset Management Engineer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":" SUM(P26:P35,P37:P55,P91:P96)","v":0},"Net Score",{"$f":" SUM(R26:R35,R37:R55,R91:R96)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"P101/R105","v":0},"total CoE KSB coverage",{"$f":"R101/R108","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"R105-R106-(R107*0.5)","v":34.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical power networks engineer (level 4) - Planning Engineer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(P26:P35,P37:P47,P56:P62,P91:P96)","v":0},"Net Score",{"$f":"SUM(R26:R35,R37:R47,R56:R62,R91:R96)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"P113/R117","v":0},"total CoE KSB coverage",{"$f":"R113/R120","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"R117-R118-(R119*0.5)","v":33}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical power networks engineer (level 4) - Design Engineer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(P26:P35,P37:P47,P63:P68,P91:P96)","v":0},"Net Score",{"$f":"SUM(R35:R38,R37:R47,R63:R68,R91:R96)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"P125/R129","v":0},"total CoE KSB coverage",{"$f":"R125/R132","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"R129-R130-(R131*0.5)","v":32}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical power networks engineer (level 4) - Control Engineer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(P26:P35,P37:P47,P69:P76,P91:P96)","v":0},"Net Score",{"$f":"SUM(R26:R35,R37:R47,R69:R76,R91:R96)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"P137/R141","v":0},"total CoE KSB coverage",{"$f":"R137/R144","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"R141-R142-(R143*0.5)","v":34.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical power networks engineer (level 4) - Electrical Project Engineer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(P26:P35,P37:P47,P77:P83,P91:P96)","v":0},"Net Score",{"$f":"SUM(R26:R35,R37:R47,R77:R83,R91:R96)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"P149/R153","v":0},"total CoE KSB coverage",{"$f":"R149/R156","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"R153-R154-(R155*0.5)","v":33}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical power networks engineer (level 4) - Operational Delivery Engineer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(P26:P35,P37:P47,P84:P89,P91:P96)","v":0},"Net Score",{"$f":"SUM(R26:R35,R37:R47,R84:R89,R91:R96)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"P161/R165","v":0},"total CoE KSB coverage",{"$f":"R161/R168","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"R165-R166-(R167*0.5)","v":32.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KBSs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(P26:P96)","v":0},"Net Score",{"$f":"SUM(R26:R96)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"P173/R177","v":0},"total CoE KSB coverage",{"$f":"R173/R180","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"R177-R178-(R179*0.5)","v":67}]

{"sheet":"ST0540","index":3,"n_rows":108,"n_cols":18,"rows_kept":108,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Fashion and textiles product technologist (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
[null,"Supply chain and customer base:"]
["K1","Different customer requirements e.g. quality standards, product finish, timescale",null,null,null,null,null,null,{"$f":"IF(C23:C25 = \"FULLY MET\",1,IF(C23:C25 = \"PARTIALLY MET\",0.5,IF(C23:C25 = \"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","Brand standards and ethics ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The supply chain; management systems and considerations e.g. sourcing methods service level agreements, problem solving, availability of materials, late deliveries, cost increases",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Materials used in production:"]
["K4","The properties, behaviour and characteristics of raw materials",null,null,null,null,null,null,{"$f":"IF(C27:C31 = \"FULLY MET\",1,IF(C27:C31 = \"PARTIALLY MET\",0.5,IF(C27:C31 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J27=1,1,IF(J27=0.5,0.5,IF(J27=0,0)))","v":0},{"$f":"IF(L27=1,\"NONE\",IF(L27=0.5,\"PARTIAL\",IF(L27=0,\"FULL\")))","v":"FULL"}]
["K5","Fabric and trim analysis to meet design briefs e.g. the function, performance, aesthetics ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Contingency planning e.g. alternative materials, buttons, trim",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Testing of materials for suitability in relation to design and function e.g. tension, compression, bending, durability, ductility, impact, creep, wash and fatigue tests",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Product labelling e.g. regulations, care, size, fibre content",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null," The product and production process:"]
["K9","Production and material costs",null,null,null,null,null,null,{"$f":"IF(C33:C40= \"FULLY MET\",1,IF(C33:C40 = \"PARTIALLY MET\",0.5,IF(C33:C40 = \"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","Industrial machines and other equipment relevant to the production of products including specialist machinery e.g. cover stitch machines, buttonholers, jigs, blind hemmers,",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Different manufacturing, procurement and distribution methods",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Plan production schedules and workloads to meet targets and deadlines",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The end- to-end main product production process (pattern production, cutting, manufacturing, quality checking, packing and distribution",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The product life cycle e.g. the period over which an item is developed, brought to market and eventually removed from the market",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Continual improvement in relation to product and production processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Critical path management processes relevant to product production",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Working practices:"]
["K17","Review and evaluation of product designs e.g. style, feasibility, cost, fit, size, body shape, foot mechanics ",null,null,null,null,null,null,{"$f":"IF(C42:C54 = \"FULLY MET\",1,IF(C42:C54 = \"PARTIALLY MET\",0.5,IF(C42:C54 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J42=1,1,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=1,\"NONE\",IF(L42=0.5,\"PARTIAL\",IF(L42=0,\"FULL\")))","v":"FULL"}]
["K18","Product specifications, quality and compliance requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Pattern production, sizes, grading and cutting techniques e.g. pattern drafting, sizing, lay planning",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Manufacturing techniques e.g. assembly sequence, construction methods",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Different types of product samples e.g. fit, samples proto samples, production samples",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The sample analysis and review process e.g. fit sessions, user trails, measurements, design and pattern assessment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Sample sealing systems e.g. blue, silver, gold seal",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Risk assessment processes e.g. risk related to safety, colour, cost, time, process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Critical path management e.g. managing production deadlines, timescales and target setting",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Overseas manufacturing implications e.g. lead times, minimum quotes, costs, legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Returns and faults analysis and the impact of faulty products on future business",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Logistics and distribution systems e.g. costs, storage, shipping, legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Information Technology (IT) and administration systems used e.g. tracking systems, production management systems, CAD/CAM (Computer Aided Design/Computer Aided Manufacturing)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Quality assurance procedures:"]
["K30","Quality standards and specifications for production e.g. seam types, stitch types, tolerances, product finish",null,null,null,null,null,null,{"$f":"IF(C56:C59 = \"FULLY MET\",1,IF(C56:C59 = \"PARTIALLY MET\",0.5,IF(C56:C59 = \"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"}]
["K31","Fault finding, diagnosis and rectification procedures e.g. poor fit, sizing, construction or finish ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Quality approval systems and control processes e.g. Inspection of materials and products during production, checks against specifications, spot checks, end checks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","International and British quality standards in relation to the manufacture of products e.g. British Standard Institute (BSI), International Organisation of Standardisation (ISO)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Communication:"]
["K20","Communication techniques, across all levels and departments involved in the sales, manufacturing and distribution process",null,null,null,null,null,null,{"$f":"IF(C61:C62 = \"FULLY MET\",1,IF(C61:C62 = \"PARTIALLY MET\",0.5,IF(C61:C62 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J61=1,1,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=1,\"NONE\",IF(L61=0.5,\"PARTIAL\",IF(L61=0,\"FULL\")))","v":"FULL"}]
["K21","Technical documents/records and electronic systems and the consequence of incorrectly completed records e.g. tech-packs, specifications, tracking, review notes, product history",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Policies and procedures:"]
["K22","Health, safety, welfare and environmental policies, safe working practices and risks relevant to a sewn product working environment ",null,null,null,null,null,null,{"$f":"IF(C64:C66 = \"FULLY MET\",1,IF(C64:C66 = \"PARTIALLY MET\",0.5,IF(C64:C66 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["K23","Employer and employee legal obligations, employees’ rights and responsibilities, equality and diversity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Legislation and regulations import regulations, safety regulations, trade regulations, duties and tariffs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
[null,"Develop and review samples:"]
["S1","Analyse, evaluate and cost the production of given designs and identify possible constraints",null,null,null,null,null,null,{"$f":"IF(C69:C75 = \"FULLY MET\",1,IF(C69:C75 = \"PARTIALLY MET\",0.5,IF(C69:C75 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"}]
["S2","Develop samples that meets design, end use and specifications.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Contribute to fit sessions and production meetings",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Analyse product samples with focus on quality, fit , risk and production processes e.g. size, shape, materials, timescales and costs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Carry out product risk assessments e.g. safety, colour, cost, time, fitness for purpose, production process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Approve samples and allocate sample seal if appropriate, maintaining a complete history of the sealing process ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Oversee material and product tests and analyse test results e.g. performance, function, wash, wearer/user trials",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Support production:"]
["S8","Develop product tech-packs e.g. specifications, working drawings, measurements, labelling, quality standards, tolerances, materials ",null,null,null,null,null,null,{"$f":"IF(C77:C78 = \"FULLY MET\",1,IF(C77:C78 = \"PARTIALLY MET\",0.5,IF(C77:C78 = \"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"}]
["S9","Ensure legislation and regulation requirements are met e.gimport regulations, safety regulations, trade regulations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Deal with product faults and returns:"]
["S10","Conduct product reviews on returned products",null,null,null,null,null,null,{"$f":"IF(C80:C82 = \"FULLY MET\",1,IF(C80:C82 = \"PARTIALLY MET\",0.5,IF(C80:C82 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J80=1,1,IF(J80=0.5,0.5,IF(J80=0,0)))","v":0},{"$f":"IF(L80=1,\"NONE\",IF(L80=0.5,\"PARTIAL\",IF(L80=0,\"FULL\")))","v":"FULL"}]
["S11","Analyse product returns and identify potential solutions e.g. change materials,  re-cut pattern",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Complete analysis reports ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Quality Assurance:"]
["S13","Manage quality problems and eradicate potential issues e.g. fabric, trim, construction faults ",null,null,null,null,null,null,{"$f":"IF(C84:C86 = \"FULLY MET\",1,IF(C84:C86 = \"PARTIALLY MET\",0.5,IF(C84:C86 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J84=1,1,IF(J84=0.5,0.5,IF(J84=0,0)))","v":0},{"$f":"IF(L84=1,\"NONE\",IF(L84=0.5,\"PARTIAL\",IF(L84=0,\"FULL\")))","v":"FULL"}]
["S14","Contribute to the solution of production issues e.g. thread breakage, missing components",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Work with the warehouse and distribution systems and processes to ensure, safe, punctual delivery of products",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J86=1,0.5,IF(J86=0.5,0.5,IF(J86=0,0)))","v":0},{"$f":"IF(L86=0.5,\"NONE\",IF(L86=0,\"PARTIAL\"))","v":"PARTIAL"}]
[null,"Communicate effectively:"]
["S16","Use relevant communication systems and accurately complete work records",null,null,null,null,null,null,{"$f":"IF(C88 = \"FULLY MET\",1,IF(C88 = \"PARTIALLY MET\",0.5,IF(C88 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J88=1,1,IF(J88=0.5,0.5,IF(J88=0,0)))","v":0},{"$f":"IF(L88=1,\"NONE\",IF(L88=0.5,\"PARTIAL\",IF(L88=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Take ownership and accept of responsibility for product technology work",null,null,null,null,null,null,{"$f":"IF(C90:C98 = \"FULLY MET\",1,IF(C90:C98 = \"PARTIALLY MET\",0.5,IF(C90:C98 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J90=1,1,IF(J90=0.5,0.5,IF(J90=0,0)))","v":0},{"$f":"IF(L90=1,\"NONE\",IF(L90=0.5,\"PARTIAL\",IF(L90=0,\"FULL\")))","v":"FULL"}]
["B2","Strive to improve product quality, production processes and production systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Are responsive to changing priorities and requirements of the product industry, demonstrating initiative, confidence and self-motivation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Work positively as part of a team, taking account of equality and diversity ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Build effective internal and external working relationships, networking across all levels and departments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Have a methodical and calm approach to workplace pressure, deadlines and production demands",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Are assertive, resilient and confident when communicating views and ideas that will benefit the product design and manufacturing process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Are reflective on skills, knowledge and behaviours and seek opportunities to develop and advance skills in response to the evolving production environment and technologies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Have a safety first attitude, ensuring the safety of self and others as appropriate in a sewn product manufacturing environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J98)","v":0},"Net Score",{"$f":"SUM(L23:L98)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J101/L105","v":0},"total CoE KSB coverage",{"$f":"L101/L108","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",49]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L105-L106-(L107*0.5)","v":48.5}]

{"sheet":"ST0580","index":4,"n_rows":67,"n_cols":18,"rows_kept":67,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Brewer (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The provenance, quality and characteristics of principle ingredients used for beer production and their combined contribution to beer style and character.",null,null,null,null,null,null,{"$f":"IF(C22:C34 = \"FULLY MET\",1,IF(C22:C34 = \"PARTIALLY MET\",0.5,IF(C22:C34 = \"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","Requirements for processing of ingredients prior to use in the brewery.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Importance of stock control, handling and storage of ingredients for use in the brewery to preserve ingredient quality and characteristics.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Principles of brewing, fermentation, yeast management, conditioning, maturation, stabilisation, clarification, processing and packaging, plant design, operation and the impact of processing conditions on the characteristics, quality and consistency of beer and beer style.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Principles and importance of plant hygiene and maintenance on production quality, safety and efficiency.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Transport and supply chain conditions, including beer dispense, required to ensure beer quality and consistency from brewery to glass.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Brewery monitoring systems to control the quality, consistency and safety of ingredients and raw materials as well as product within the process and at final package.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Drivers of brewery operation and performance, including costings, maintaining consistent, high quality and efficient output and process, responding to consumer expectations and developing market trends; financial and business pressures, meeting expectations of responsibility and sustainable production.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Commercial awareness of brewery operation and all brewery inputs and outputs. control of costs associated with production in response to drivers of brewery operation and performance, maintaining and upgrading brewery assets, plant and equipment as well as decisions on plant investment and improvements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Sustainability factors and environmental considerations connected with beer production and the supply chain; management and control of waste and effluent throughout production.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Regulatory compliance and responsibility associated with beer production, logistics and retail operation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Continuous Improvement (CI) processes, for example knowledge of 5 S, and Plan, Action, Review.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The heritage and structure of the beer industry, as well as the significance of changing market trends and drivers of consumer preferences.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Control and safe operation of automated and/or manual plant and equipment required for brewing, fermentation, processing and packaging of beer taking appropriate personal and operational responsibility for health and safety to protect self and others at all times.",null,null,null,null,null,null,{"$f":"IF(C36:C46 = \"FULLY MET\",1,IF(C36:C46 = \"PARTIALLY MET\",0.5,IF(C36:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J36=1,1,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=1,\"NONE\",IF(L36=0.5,\"PARTIAL\",IF(L36=0,\"FULL\")))","v":"FULL"}]
["S2","Maintains accurate records for existing beer recipes and as part of day to day brewhouse and production requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Design and adjustment of beer recipes and specifications where necessary.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Planning to ensure production schedules are met, with adjustments made in a timely way where necessary.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Quality and safety control checks (microbiological, chemical, physical, sensory) and maintains records required for traceability.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Monitoring quality control and consistency of ingredients, raw materials and product within the process and at final package and to demonstrate compliance with specification and regulations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Implementation and monitoring of cleaning and sanitation processes intended to ensure plant and process hygiene.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Monitoring and maintenance of yeast hygiene, vitality and viability.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Use of computer word processing and data manipulation packages.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Contribution to CI activities to improve and optimise production processes and troubleshoot/problem solve operational issues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Promotion of the brewery and attributes and characteristics of key brands and styles, when hosting or attending private and/or public events.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J46=1,0.5,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=0.5,\"NONE\",IF(L46=0,\"PARTIAL\"))","v":"PARTIAL"}]
[null,"Behaviours"]
["B1","Leads by example in behaviour and approach to working safely.",null,null,null,null,null,null,{"$f":"IF(C48:C57 = \"FULLY MET\",1,IF(C48:C57 = \"PARTIALLY MET\",0.5,IF(C48:C57 = \"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"}]
["B2","Passion for the industry and the product; acts as a role model and ambassador for brand and brewery.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J49=1,0.5,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=0.5,\"NONE\",IF(L49=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Demonstrates integrity and confidence in daily activities.",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"}]
["B4","Curiosity and desire to innovate and expand knowledge and experience of brewing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Calmly and consistently reacts to information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Committed to delivering and maintaining high-quality product and work place standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Demonstrates responsibility, personal accountability and professionalism in all aspects of the role.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Flexible and adaptable to working environment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Confidently and competently communicates relevant information to team members and others in an appropriate manner.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B10","Works collaboratively as part of a team.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J57)","v":0},"Net Score",{"$f":"SUM(L22:L57)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J60/L64","v":0},"total CoE KSB coverage",{"$f":"L60/L67","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",34]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L64-L65-(L66*0.5)","v":33}]

{"sheet":"ST0588","index":5,"n_rows":121,"n_cols":20,"rows_kept":121,"cut":false,"hidden":false,"merged":[[87,10,87,14],[99,10,99,14],[111,10,111,14],[9,0,9,8],[10,2,10,3],[19,1,21,3],[23,2,23,3]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Propulsion technician occupation, plus the specific KSBs for Propulsion test technician and Engine build and process technician options)","Included in:",null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,null,"Propulsion technician (level 4) - Propulsion test technician","Propulsion technician (level 4) - Engine build and process technician"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","YES","YES","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","YES","YES","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,"Propulsion technician (level 4)"]
[null,"Return to Guide"]
[null,"Two options are available (columns C-D). Please check if the KSB needs to be mapped against the option of your choice. If you map against two options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
[]
[]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Propulsion technician occupation, plus the specific KSBs for Propulsion test technician and Engine build and process technician options)","Included in:",null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","Propulsion technician (level 4) - Propulsion test technician","Propulsion technician (level 4) - Engine build and process technician"]
["K1","The statutory and organisation health and safety policies, procedures and regulations that must be adhered to in a propulsion environment","YES","YES",null,null,null,null,null,null,{"$f":"IF(E26:E51 = \"FULLY MET\",1,IF(E26:E51 = \"PARTIALLY MET\",0.5,IF(E26:E51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L26=1,1,IF(L26=0.5,0.5,IF(L26=0,0)))","v":0},{"$f":"IF(N26=1,\"NONE\",IF(N26=0.5,\"PARTIAL\",IF(N26=0,\"FULL\")))","v":"FULL"}]
["K2","The risk assessment process, procedures and documentation used within their own area of responsibility.","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L27=1,1,IF(L27=0.5,0.5,IF(L27=0,0)))","v":0},{"$f":"IF(N27=1,\"NONE\",IF(N27=0.5,\"PARTIAL\",IF(N27=0,\"FULL\")))","v":"FULL"}]
["K3","How to communicate effectively, listen, question, support and mentor others.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The relevant internal and external quality standards and procedures that apply to the design, development and manufacture of propulsion systems.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The principles and purpose of quality auditing.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The core engineering principles such as mathematics, science, mechanical and electrical/electronic applications relevant to their specialism","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The importance of developing and maintaining Standard Operating Procedures (SOP’s) in order to meet all the relevant requirements, i.e. legal & code of practice.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How to prioritise their own and their/team’s workload to ensure that targets are met and to ensure effective use of resource/equipment","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The various data collection systems used and their formats.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The principles and application of Measurement Systems Analysis methods and techniques.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How to analyse and interpret first line data accurately in order to, validate quality, draw conclusions, provide recommendations and communicate with others in a recognised format.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The use, benefits and applications of continuous improvement techniques and methods for engineering (such as Kaizen and Six Sigma).","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The importance for organisations to manage and monitor supplier performance ensuring that cost, service, quality and sustainability objectives are being achieved and their responsibilities in that process","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How to produce accurate, effective and concise plans, presentations and analysis of graphs/charts, process and lessons learnt documents.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The Internal and external audit compliance requirements (such as TS16949 and ISO 14001)","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The criteria used to determine the testing method(s) and equipment to be used.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The principles of how to create and edit test scripts to ensure data obtained is valid and reliable","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The preparation and set up requirements of testing and data collection equipment/ancillary systems.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The preparation and set up requirements of propulsion units to be tested.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How to run and operate propulsion testing equipment effectively to ensure quality and consistent outcomes including understanding limits of adjustment and parameters for safe running and standardisation.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","The different types and purpose of the tests that can be carried out on propulsion units/systems being developed such as performance, emissions, climatic, noise, vibration, durability, mechanical, electrical and calibration","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The importance of ensuring that engines are not contaminated during the build and the implications for the quality of the development programme data if this is not adhered to","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The importance of adhering to the quality criteria such as setting working clearances and torque settings","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","The different fault diagnostic methods used, their application and selection","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","The methodologies used for part and product quality investigations","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","How to validate tooling and build deviations and associated equipment and instrumentation","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Manage risk and the application of Health and Safety within their area of responsibility","YES","YES",null,null,null,null,null,null,{"$f":"IF(E53:E79 = \"FULLY MET\",1,IF(E53:E79 = \"PARTIALLY MET\",0.5,IF(E53:E79 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L53=1,1,IF(L53=0.5,0.5,IF(L53=0,0)))","v":0},{"$f":"IF(N53=1,\"NONE\",IF(N53=0.5,\"PARTIAL\",IF(N53=0,\"FULL\")))","v":"FULL"}]
["S2","Communicate effectively, listen, question, support and mentor others, whilst promoting an attention to detail throughout the propulsion development process","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Manage checks on test or build systems and problem solve where issues arise","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Demonstrate critical and analytical reasoning, robust planning and task co-ordination","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Lead the setting up of equipment and ancillary systems used for build or test and where applicable carry out any required modifications","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Ensure instrumentation captures high quality data in a systematic and repeatable way","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Carry out checks, measurement and calibration activities following approved procedures and processes","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Comply with internal processes and procedures to ensure equipment is fit for purpose, maintained correctly and in calibration","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Monitor and validate test or build data quality","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Implement proposals for test or build plan modifications based on quality and quantitative data","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Prioritise test or build output to maximise efficient use of specialist equipment","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Manage all internal and external customer needs throughout test or build execution","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Develop procedures and processes necessary to meet all relevant standards and requirements, i.e. legal & code of practice","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Guide and develop other team members","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Create internal test or build instructions and process documents.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Support the development of proposals to develop new/alternative technologies","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Lead the preparation and installation activities for propulsion units under test","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Lead the testing activity ensuring the test is carried out in line with manufacturer instructions and/or company standard operating procedures","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Check and monitor the test to ensure that it is carried out under the specified conditions set out in the test script/specification","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Ensure the servicing schedules and maintenance of propulsion testing equipment is carried out in line with manufacturer instructions and/or company standard operating procedures","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Lead the diagnosis and analysis of any faults found on propulsion units under test","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Check that all preparation activities to support the prototype engine build development programme have been carried out correctly","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Ensure that the specified components are available for the build and that they are in a usable condition","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Lead the build of the prototype/ development engine ensuring it has been built to the correct specification and is ready for testing","NO","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L76=1,1,IF(L76=0.5,0.5,IF(L76=0,0)))","v":0},"FULL"]
["S25","Lead the diagnosis and analysis of any faults identified during the development engine build","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Lead and support modification activities to improve engine build reliability and performance","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Lead the validation process for tooling and build deviations and associated equipment/instrumentation","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Personal Responsibility & Compliance: Complies with statutory and organisational health & safety regulations and policies at all times. Accepts responsibility for their work load with a responsible approach to risk. Continually demonstrates a high level of motivation and resilience when facing challenges","YES","YES",null,null,null,null,null,null,{"$f":"IF(E81:E85 = \"FULLY MET\",1,IF(E81:E85 = \"PARTIALLY MET\",0.5,IF(E81:E85 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L81=1,1,IF(L81=0.5,0.5,IF(L81=0,0)))","v":0},{"$f":"IF(N81=1,\"NONE\",IF(N81=0.5,\"PARTIAL\",IF(N81=0,\"FULL\")))","v":"FULL"}]
["B2","Working Effectively in Teams: Create and maintain positive, professional and trusting working relationships with the team and a wide range of internal, external and connected stakeholders. Maintains the highest standards of integrity and ethics in all business relationships.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Effective Communication & Interpersonal Skills: Maintain effective partnerships with suppliers and customers through the company processes to achieve sound objectives.Open and honest clear communication using appropriate methods. Always demonstrating a positive and respectful attitude.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Quality & Problem Solving: Strong desire to ensure that the root cause of a problem is identified and addressed, continually seeks opportunities to improve quality, speed and efficiency whilst also demonstrating technical leadership.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Continuous Personal Development. Reflect on skills, knowledge and behaviours and seeks opportunities to develop, adapt to different situations, environments or technologies and have a positive attitude to feedback and advice","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Propulsion technician (Level 4) - Propulsion test technician"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L46, L53:L73, L81:L85)","v":0},"Net Score",{"$f":"SUM(N26:N46, N53:N73, N81:N85)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L90/N94","v":0},"total CoE KSB coverage",{"$f":"N90/N97","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",47]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N94-N95-(N96*0.5)","v":47}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Propulsion technician (Level 4) - Engine build and process technician"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L40, L47:L51, L53:L68, L74:L79, L81:L85)","v":0},"Net Score",{"$f":"SUM(N26:N40, N47:N51, N53:N68, N74:N79, N81:N85)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L102/N106","v":0},"total CoE KSB coverage",{"$f":"N102/N109","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",47]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N106-N107-(N108*0.5)","v":47}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KBSs"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L85)","v":0},"Net Score",{"$f":"SUM(N26:N85)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L114/N118","v":0},"total CoE KSB coverage",{"$f":"N114/N121","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",58]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N118-N119-(N120*0.5)","v":58}]

{"sheet":"ST0605","index":6,"n_rows":241,"n_cols":23,"rows_kept":241,"cut":false,"hidden":false,"merged":[[231,13,231,17],[171,13,171,17],[195,13,195,17],[207,13,207,17],[219,13,219,17],[9,0,9,11],[10,2,10,6],[19,1,20,6],[23,2,23,6],[183,13,183,17]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Mineral products technician occupation, plus the specific KSBs for Mineral Extraction, Concrete (Readymix and Precast/Prestressed), Cement and cementitious products, Asphalt & Pavements and Clays (Heavy and White) options)","Included in:",null,null,null,null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column K) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column J does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,null,"Mineral products technician (level 5) - Mineral Extraction","Mineral products technician (level 5) - Concrete (Readymix and Precast/Prestressed)","Mineral products technician (level 5) - Cement and cementitious products","Mineral products technician (level 5) - Asphalt & Pavements","Mineral products technician (level 5) - Clays (Heavy and White)"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","YES","YES","YES","YES","YES","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","YES","YES","YES","YES","YES","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,"Mineral products technician (level 5)"]
[null,"Return to Guide"]
[null,"Five options are available (columns C-G). Please check if the KSB needs to be mapped against the option of your choice. If you map against two or more options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
[]
[]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Mineral products technician occupation, plus the specific KSBs for Mineral Extraction, Concrete (Readymix and Precast/Prestressed), Cement and cementitious products, Asphalt & Pavements and Clays (Heavy and White) options)","Included in:",null,null,null,null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column K) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column J does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","Mineral products technician (level 5) - Mineral Extraction","Mineral products technician (level 5) - Concrete (Readymix and Precast/Prestressed)","Mineral products technician (level 5) - Cement and cementitious products","Mineral products technician (level 5) - Asphalt & Pavements","Mineral products technician (level 5) - Clays (Heavy and White)"]
["K1","Relevant Health, Safety Environmental Legislation relevant to their workplace.","YES","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(H26:H95 = \"FULLY MET\",1,IF(H26:H95 = \"PARTIALLY MET\",0.5,IF(H26:H95 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(O26=1,1,IF(O26=0.5,0.5,IF(O26=0,0)))","v":0},{"$f":"IF(Q26=1,\"NONE\",IF(Q26=0.5,\"PARTIAL\",IF(Q26=0,\"FULL\")))","v":"FULL"}]
["K2","The health and safety hazards, major hazards, environmental aspects and risks associated with the operation.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(O27=1,1,IF(O27=0.5,0.5,IF(O27=0,0)))","v":0},{"$f":"IF(Q27=1,\"NONE\",IF(Q27=0.5,\"PARTIAL\",IF(Q27=0,\"FULL\")))","v":"FULL"}]
["K3","Major hazards associated with the operational site.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Emergency response, process and procedures.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The concepts, theories and practicalities underpinning the safe, efficient operation of the production site","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The performance and competency requirements for all operational roles on site including contractors and sub-contractors.\"","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Problem solving tools and techniques.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","An understanding of dynamic work Method Statements and Risk Assessments.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Understand the effect of production processes on the supply chain.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Understand the impact of production processes on sustainability","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Foundation geo-sciences, such as understanding the geology and chemistry of the materials and its application relevant to the mineral products sector.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The principles of operation of mobile and static plant equipment to produce and process a consistent product to customer and BS EN specifications minimising any waste.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The principles of predictive and preventative maintenance of all mineral products equipment.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Knowledge of relevant quality systems (such as ISO standards)","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","An understanding of typical customer requirements and constraints","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How to establish site costs including cost benefit analysis","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Communication techniques, including report writing and methods of making written and oral presentations.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The importance of communicating relevant information with the operational team, customers and all stakeholders.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The importance of liaison with local communities, official bodies and other stakeholders associated with site operations and any impacts they may have.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The minerals extraction processing operations that maximises the use of the resources, maximises products from raw materials, ensures availability of resources and restore spent or worked areas.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","The social and economic issues associated with the exploration, exploitation and development of a mineral extraction site.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Different methods of winning and extracting raw material.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Techniques employed to load extracted minerals and viable options to transport extracted minerals and its applications within the industry, including feeding, crushing, screening, washing, separation, classification and beneficiation techniques.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Sustainable development, reclamation of mineral workings, minerals planning, managing waste and an understanding of environmental law and legislation and its implication for the minerals extractive industry.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","The requirements of blasting in a safe and environmentally conscious manner, without risk of causing injury or damage whilst optimising overall operating costs.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","An understanding of chemical and physical properties of aggregates - their specifications in order to produce aggregates that are fit for purpose and the full range of end uses such as concrete, asphalt or rail ballast.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","An in depth understanding of how to sample and test the aggregates, including typical standard deviations and implications of analysis of the final products in use this includes adjusting operations to achieve the required quality levels.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Understand the maintenance processes required to maximise availability and cost base on the range of mobile and static plant including modes of failure, first line maintenance and specific maintenance activities.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Understand the principles required and constraints around both new site planning requirements and planning permissions extensions.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Deep understanding of the Quarry Regulations 1999.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","An understanding of fresh and hardened concrete, its constituents, specifications, mix design and its properties, in order to produce concrete that is fit for purpose and durable.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","An understanding of how to sample and test the end product in a fresh and hardened state.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Sustainable use of concrete in durable structures and its environmental impact.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Appropriate use of resources, admixtures, additives for constituent materials, and energy consumption.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","Cementitious materials including cement replacing materials; natural and recycled aggregates; admixtures; properties of fresh, hardening and hardened concrete for durable structures; standards, specifications and conformity control; production and placing.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Properties of concretes and cementitious mortars used for specialist end uses - including self-compacting, precast and fibre reinforced concrete; and mortars for masonry, render and screed.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Concrete in construction and a deep understanding of reinforced and pre-stressed concrete, including its use in concrete slabs, floors and external paving.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","The particular characteristics of fresh concrete required for specialist end uses such as pumped, sprayed, foamed and underwater concrete are also studied. Includes an understanding of the influence of formwork on the surface finish of hardened concrete.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","The factors that influence the long term durability of concrete used in structures, including the role of cracks. Compaction of placed product and impacts of the environmental conditions during placement","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","Methods used to investigate and analyse the causes and extent of deterioration in a concrete structure and how to repair and protect reinforced and pre-stressed concrete structures.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","The importance and various methods for curing concrete.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","The sequence of activities required to produce cement, including how the raw materials are sourced and blended; the chemical processes in the cement kiln; and the processing and blending of clinker to give the range of cements required by customers.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K43","The complex range of activities and processes that are used in relation to the extracted raw materials and other components required to prepare the dry or semi-dry material known as 'kiln feed.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K44","The balanced and efficient use of different fuels (including waste fuels) and their contribution to the economic and sustainable operation of a Portland cement kiln.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K45","Clinker processing - the processes that grind and blend the output from the cement kiln into a cement that can be sold to the customer in bulk or in packaging.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K46","The safe processes and procedures for site shutdown in both routine and emergency situations.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K47","Effective environmental management in line with the Part A process at the clinker manufacturing facility and also local permits at associated depots, including monitoring and reporting of CO2 and improvements in emissions (such as fugitive or respirable dust and gaseous emissions).","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K48","Quality control and end use of cement and cementitious products, including the correct use, maintenance and calibration of equipment, including XRF, chemical and physical testing equipment.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K49","Understand the end use of the cement, cementitious products and the properties which will impact on the final product, this covers conventional and special concretes such as self-compacting concrete.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K50","Correct dosing facilities and testing for Chromium(Cr)6+ in cement, reporting shelf life and testing required to confirm the suitability for use. Understand the health implications of Cr6+ in final product and COSHH of the chemicals used to reduce Cr6+","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K51","The technology, standards, specifications and other requirements that apply to bituminous products and asphalt mixtures.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K52","The technology and principles of designing bituminous mixtures including Recycled Asphalt Product (RAP), and of the specific processes and knowledge required to produce, transport and place the products.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K53","Techniques used to manage asphalt product quality so as to satisfy the needs of the customer and end use.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K54","Compaction of placed product and impacts of the environmental conditions during placement.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K55","Pavement products and how they work to protect the underlying substrates and the fundamental principles of pavement design.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K56","Pavement designed for lifespan and traffic predictions, design of treatments to maintain the structure.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K57","The ‘Asset Management’ approach to maintaining highways, and prioritisation of maintenance treatments.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K58","Fundamental properties of asphalt mixtures and their function in road pavements. The production of bitumen and special binders, such as emulsions and polymer modified binders.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K59","The fundamental requirements of an asphalt mix, durability, resistance to cracking and resistance to deformation.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K60","The major specialist treatments for the surface of roads, and their reinforcement.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K61","Sustainability through recycling and consideration of ‘alternatives aggregates’.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K62","The techniques used to identify potential sources of clay and their potential use in a range of clay products.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K63","The environmental and geological factors that can have an impact on the development of a clay extraction site.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K64","The methods and techniques used to investigate and evaluate a potential source of clay, including site survey and site investigation methods.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K65","Winning & Preparation - methods and techniques used to extract, stockpile and process clay so that it can be used for the production of clay products.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K66","The issues and constraints associated with crushing and size reduction of clay lumps and particles.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(O91=1,1,IF(O91=0.5,0.5,IF(O91=0,0)))","v":0},{"$f":"IF(Q91=1,\"NONE\",IF(Q91=0.5,\"PARTIAL\",IF(Q91=0,\"FULL\")))","v":"FULL"}]
["K67","Processes used to prepare clay so that it can be used to produce clay products in a safe way that also respects the environment.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K68","Forming - how the moulded clay can influence the dimensions and shape of the finished clay product.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K69","How surface treatments can be used to create particular surface characteristics and properties in the finished clay product and how surface finishes can be used to provide resistance to specified ground conditions and end-use environments.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K70","Techniques used to dry and then fire clay products. The drying and firing processes that produce different types of clay products and the influence of drying and firing techniques on their characteristics.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Work competently, safely and manage risks in accordance with HSE regulations.","YES","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(H97:H155 = \"FULLY MET\",1,IF(H97:H155 = \"PARTIALLY MET\",0.5,IF(H97:H155 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(O97=1,1,IF(O97=0.5,0.5,IF(O97=0,0)))","v":0},{"$f":"IF(Q97=1,\"NONE\",IF(Q97=0.5,\"PARTIAL\",IF(Q97=0,\"FULL\")))","v":"FULL"}]
["S2","Apply their knowledge of health and safety hazards, major hazards, environmental aspects and risks associated with the operation in order to train others to conduct full risk assessments, license to operate procedures and be able to fully investigate and evaluate health, safety and environmental accidents and incidents, report findings and implement improvements.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(O98=1,1,IF(O98=0.5,0.5,IF(O98=0,0)))","v":0},{"$f":"IF(Q98=1,\"NONE\",IF(Q98=0.5,\"PARTIAL\",IF(Q98=0,\"FULL\")))","v":"FULL"}]
["S3","Use their knowledge of emergency response processes and procedures to deal with emergency situations and ensure that in these circumstances the site is evacuated, secured and made safe as swiftly as possible.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Recommend and support improvements to environmental, health and safety culture, procedures, process and systems across the operation.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Obtain, evaluate and use information from the teams across the site to take critical operational decisions. This could include information on a range of matters such as the products, the equipment and the staffing levels.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Utilise communications technology for performing and supporting the business processes including, communications, work co-ordination, task analysis and problem solving.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Ensure that operational systems are adhered to by all employees in accordance with quality control plans and procedures.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Use appropriate Personal Protective Equipment in order to meet employers and regulatory health and safety requirements.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Apply root cause analysis","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Use the principles of predictive and preventative maintenance of all mineral products equipment in order to minimise downtime and costs.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Develop & write technical reports that meet business requirements including the optimisation and continuous improvement of processes and services","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Maximise the use of the resources, maximise products from raw materials, ensuring sustainability of resources.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Provide technical knowledge transfer to colleagues and continuous improvements in line with business requirements.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Optimise processes & products re: cost and performance in line with budget requirements.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Communicate all relevant information with the operational team, customers and all stakeholders by email, handheld radio, phone and face to face to keep them up to date with site production issues, ensuring information is passed clearly and promptly.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Plan and implement plans for work activities and projects.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Monitoring trends, interpreting results and making adjustments in production.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Use knowledge of the local communities, official bodies and other stakeholders associated with Mineral Products and their interests in the industry to liaise and engage with them to ensure positive working relationships are established, minimising disputes.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Ensure safe and effective utilisations of mineral extraction equipment and resources by following standard operating procedures and/or site rules.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Maximise operational and resource efficiency in a mineral extraction environment, in accordance with the quarry/mine plan.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Plans processes to win and extract mineral in a safe, efficient and environmentally sensitive manner applying blasting, digging or cutting techniques.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Plan to use, select and utilise face loading machines, dumptrucks, conveyor systems, processing and benefication equipment by planning material flow and matching equipment.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Use and apply the the quarry/mine plan to assess environmental impact, planning constraints, site restoration and the wider sustainability agenda.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Achieve and verify product quality meets both European Standards and customer specifications and optimizes the production process to achieve these in a cost effective manner and whilst maintaining end use applications.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Ensures all test equipment is maintained, used correctly and calibrated, retains appropriate records. Interprets all test results for accuracy, retesting as required, and taking appropriate actions and communications if results fall outside of specifications.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Conduct the full range of legislative and procedural inspections required in the quarry, processing plant and associated locations, record, document findings and take appropriate action. For inspections conducted by specialist third parties – can interpret, prioritize and action the recommendations.","YES","NO","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Planning work activities and production schedule with customer requirements","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Sampling and testing of concrete products to the relevant European standards.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S29","Monitoring trends, interpreting results and making adjustments in concrete mix designs.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S30","Management of product constituents to include secondary, alternative and recycled materials.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Demonstration of the selection and appropriate use of reinforcement materials in concrete applications.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S32","Planning the selection and utilisation of fresh concrete delivery systems by planning material flow and matching equipment.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S33","Able to apply different concrete batching techniques in the manufacture of concrete products.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S34","Undertaking of assessment, inspection and development of suitable repair strategies for existing concrete structures.","NO","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S35","Planning work activities and production schedule with customer and trend requirements.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S36","Managing risks specific to high energy and cost production processes.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S37","Sampling, testing and reporting of Cement, Lime and Cementitious products to the relevant European standards.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S38","Sampling, testing and reporting of incoming and intermediary materials supporting the adjustments in the cement manufacturing process.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S39","Management of product constituents to include secondary, alternative and recycled materials.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S40","Planning the selection and utilisation of milling, grinding and blending equipment by planning process flow and matching equipment","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S41","Demonstrate an understanding of the selection and use of different fuel types in order to maximise thermal efficiencies and minimise environmental impacts.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S42","Planning the selection and utilisation of Cement, Lime and Cementitious Products delivery systems.","NO","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S43","Planning work activities, production schedules, transport and delivery in line with customer requirements.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S44","Sampling source materials, bitumens and asphalt products.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S45","Defining different asphalt production processes and ancillary equipment to maximise production. Inspecting and optimising asphalt production plant and equipment.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S46","Inspecting and optimising laying and compaction plant and equipment.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S47","Managing risks to health and safety and the environment associated with the production, transport and laying of asphalt mixtures.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S48","Application and on going management of assets both in terms of production and laying equipment and in pavements, foundations, drainage, skid resistance, embankments, bridges and street furniture.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S49","Application of pavement design according to design speciications.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S50","Identifying pavement failure modes and subsequent remedial options.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S51","Application of specialist road surface treatments and sustainable recycled aggregates and recycling processes.","NO","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S52","Apply understanding of the nature and formation processes of clay deposits to the manufacture of heavy clay construction products to ensure product quality.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S53","Maximise operational and resource efficiency by using and understanding the quarry/clay pit plan in and minimising environmental impacts.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S54","Supervision of methods of extraction, transportation and stockpiling of clay raw materials to industry standards.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S55","Effective management of raw material processing in relation to the manufacturing operation.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S56","Recognise the influence of raw material properties in the selection of the appropriate clay forming equipment and drying processes.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S57","Appropriate selection and use of different surface texturing and colouring processes.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S58","Planning and control of the appropriate drying and firing cycles for the production process.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S59","Sampling, testing and reporting of intermediary and final clay products supporting the adjustments in the process.","NO","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","A strong personal commitment to health, mental wellbeing, safety and the environment.","YES","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(H157:H169 = \"FULLY MET\",1,IF(H157:H169  = \"PARTIALLY MET\",0.5,IF(H157:H169  = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(O157=1,1,IF(O157=0.5,0.5,IF(O157=0,0)))","v":0},{"$f":"IF(Q157=1,\"NONE\",IF(Q157=0.5,\"PARTIAL\",IF(Q157=0,\"FULL\")))","v":"FULL"}]
["B2","Leads from the front setting a high example to all employees.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Works within the company policies, procedures and regulations at all times.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(O159=1,0.5,IF(O159=0.5,0.5,IF(O159=0,0)))","v":0},{"$f":"IF(Q159=0.5,\"NONE\",IF(Q159=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B4","Remains calm, composed and maintains accuracy of detail under pressure.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(O160=1,1,IF(O160=0.5,0.5,IF(O160=0,0)))","v":0},{"$f":"IF(Q160=1,\"NONE\",IF(Q160=0.5,\"PARTIAL\",IF(Q160=0,\"FULL\")))","v":"FULL"}]
["B5","Takes responsibility for own behaviours, actions and standards of work.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(O161=1,1,IF(O161=0.5,0.5,IF(O161=0,0)))","v":0},{"$f":"IF(Q161=1,\"NONE\",IF(Q161=0.5,\"PARTIAL\",IF(Q161=0,\"FULL\")))","v":"FULL"}]
["B6","Identifies improvements that could be made and contributes to implementing new procedures or ways of safe and effective working.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Takes responsibility for on-going continuous professional development","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Ensures a customer focused approach and is an advocate for the business.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(O164=1,0.5,IF(O164=0.5,0.5,IF(O164=0,0)))","v":0},{"$f":"IF(Q164=0.5,\"NONE\",IF(Q164=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B9","Promotes a collaborative team ethic as well as a supportive and positive culture.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(O165=1,1,IF(O165=0.5,0.5,IF(O165=0,0)))","v":0},{"$f":"IF(Q165=1,\"NONE\",IF(Q165=0.5,\"PARTIAL\",IF(Q165=0,\"FULL\")))","v":"FULL"}]
["B10","Encourages innovation and supports suggestions and feedback.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B11","Demonstrates a commitment to equality and diversity and manages/challenges others to meet the requirements of fairness at work.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B12","Maintains a professional, courteous, polite and friendly approach at all times.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B13","Identify own development needs and takes action to meet those needs.","YES","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral products technician (level 5) - Mineral Extraction"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(O26:O55, O97:O122, O157:O169)","v":0},"Net Score",{"$f":"SUM(Q26:Q55, Q97:Q122, Q157:Q169)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"O174/Q178","v":0},"total CoE KSB coverage",{"$f":"Q174/Q181","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"Q178-Q179-(Q180*0.5)","v":68}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral products technician (level 5) - Concrete (Readymix and Precast/Prestressed)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(O26:O44,O56:O66,O97:O114,O123:O130,O157:O169)","v":0},"Net Score",{"$f":"SUM(Q26:Q44,Q56:Q66,Q97:Q114,Q123:Q130,Q157:Q169)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"O186/Q190","v":0},"total CoE KSB coverage",{"$f":"Q186/Q193","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"Q190-Q191-(Q192*0.5)","v":68}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral products technician (level 5) - Cement and cementitious products"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(O26:O44,O67:O75,O97:O114,O131:O138,O157:O169)","v":0},"Net Score",{"$f":"SUM(Q26:Q44,Q67:Q75,Q97:Q114,Q131:Q138,Q157:Q169)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"O198/Q202","v":0},"total CoE KSB coverage",{"$f":"Q198/Q205","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"Q202-Q203-(Q204*0.5)","v":66}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral products technician (level 5) - Asphalt & Pavements"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(O26:O44,O76:O86,O97:O114,O139:O147:O157:O169)","v":0},"Net Score",{"$f":"SUM(Q26:Q44,Q76:Q86,Q97:Q114,Q139:Q147:Q157:Q169)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"O210/Q214","v":0},"total CoE KSB coverage",{"$f":"Q210/Q217","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"Q214-Q215-(Q216*0.5)","v":68}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral products technician (level 5) - Clays (Heavy and White)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(O26:O44,O87:O95,O97:O114,O148:O155,O157:O169)","v":0},"Net Score",{"$f":"SUM(Q26:Q44,Q87:Q95,Q97:Q114,Q148:Q155,Q157:Q169)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"O222/Q226","v":0},"total CoE KSB coverage",{"$f":"Q222/Q229","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"Q226-Q227-(Q228*0.5)","v":66}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KBSs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(O26:O169)","v":0},"Net Score",{"$f":"SUM(Q26:Q169)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"O234/Q238","v":0},"total CoE KSB coverage",{"$f":"Q234/Q241","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",142]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"Q238-Q239-(Q240*0.5)","v":141}]

{"sheet":"ST0624","index":7,"n_rows":121,"n_cols":20,"rows_kept":121,"cut":false,"hidden":false,"merged":[[87,10,87,14],[99,10,99,14],[111,10,111,14],[9,0,9,8],[23,2,23,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[10,2,10,3]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Food and drink Engineer occupation, plus the specific KSBs for Mechanical Food and Drink Engineer and Electrical Food and Drink Engineer options)","Included in:",null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,null,"Food and drink Engineer (level 5) - Mechanical Food and Drink Engineer","Food and drink Engineer (level 5) - Electrical Food and Drink Engineer"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","Yes","Yes","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","Yes","Yes","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,"Food and drink engineer (level 5)"]
[null,"Return to Guide"]
[null,"Two options are available (columns C-D). Please check if the KSB needs to be mapped against the option of your choice. If you map against two options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
[]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Food and drink Engineer occupation, plus the specific KSBs for Mechanical Food and Drink Engineer and Electrical Food and Drink Engineer options)","Included in:",null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","Food and drink Engineer (level 5) - Mechanical Food and Drink Engineer","Food and drink Engineer (level 5) - Electrical Food and Drink Engineer"]
["K1","Legislative, regulatory and ethical requirements, such as Dangerous Substances and Explosive Atmospheres (DSEAR) and Atmospheres and Explosives (ATEX) regulations, and their application to food engineering processes; food safety, hazard analysis and critical control points (HACCP), health & safety and environmental considerations","YES","YES",null,null,null,null,null,null,{"$f":"IF(E26:E54 = \"FULLY MET\",1,IF(E26:E54 = \"PARTIALLY MET\",0.5,IF(E26:E54 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L26=1,1,IF(L26=0.5,0.5,IF(L26=0,0)))","v":0},{"$f":"IF(N26=1,\"NONE\",IF(N26=0.5,\"PARTIAL\",IF(N26=0,\"FULL\")))","v":"FULL"}]
["K2","Food science and technology; how engineering is used in food and drink production: heating processing, packaging, modified atmosphere packaging (MAP), preservation, chilling, freezing, sterilisation","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Engineering processes and equipment including automation and controls to make and deliver products to market: shaping forming equipment, ovens, chillers, freezers, sterilisers, MAP packing machines, check weighers, temperers, washing/cleaning, fillers, extruders, bulk solid handling & distribution and liquid systems process validation, sieving, filtration, metal detection, bar code verification metal detection wrapping and palletising","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Engineering theory and techniques to develop processes i.e. thermodynamic and thermo-fluid analysis heat transfer can be applied to design of baking, cooling, preserving, freezing, chilling systems","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Hygienic engineering principles relating to type of material, machine assembly, design and practice; and their importance to delivering food hygiene and safety and employee health and safety requirements in a food and drink process","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Packing materials in food; inter-relationships with food ingredients, final product and their effects on safety, quality and performance through the supply chain i.e. how to engineer correct seals on film, cardboard, tins, stable transportation, moisture barriers","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Problem solving tools to analyse e.g. Define, Measure, Analyse, Improve Control (DMAIC) principles","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Interpretation and evaluation techniques","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Overall Equipment Efficiencies (OEE), for example Smart Reliability Driven Maintenance approaches including Reliability Centred Maintenance (RCM)/ Failure mode, effects, and critical analysis (FMECA), Condition Monitoring Techniques and applications, Single minute change of Die (SMED), Line balance","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Risk management techniques, reliability/criticality tools and how they are used to reduce operational losses/wastage operations","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Life Cycle Asset Management (LCAM), Criticality Analysis & Technology Selection (CATS), Intelligent Maintenance, Repair and Operations (inventory) (MRO) Optimisation","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Product, machinery specifications: how they are used to set capability measurement, performance testing and maintenance requirements to deliver a standard set of operating conditions for consistent product delivery","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Effective planning and scheduling, including effective communication, team working and project management techniques","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Customer/food trade association standards, such as British Retail Consortium, Retailer and Engineering standards","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","General manufacturing services: steam, pneumatics and hydraulics, electrical supply, refrigeration, water supply and effluent","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Manufacturing services specific to food: air filtration, oil free compressors, cleanliness of steam for food, sieving of materials, use of food grade lubricant, primary secondary cooling chemicals for food, MAP gases and generation i.e. Nitrogen","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Factory digitisation/optimisation (Iot, Factory 2020 principles), for example principles of control engineering, logic controllers and data communication systems, sensors and devices, drives and transmissions, pumps and distribution systems, safety circuit systems, computer aided design, shop floor data gathering, PC use and computerised maintenance","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Digitisation: 4.0, modelling of lines/process, 3d modelling scanning and printing, product dimensional measurement, rheology measurement","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Mechanical design, mechanical analysis (static) performance of components, mechanisms and systems; study of friction wear; the science of interacting surfaces in relative motion (tribology)","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Laws of thermodynamics and its applications within a hygienic food and drink environment: the fundamentals of heat transfer, thermo-fluid analysis, entropy, energy efficiency; conservation and sustainability","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Steam fundamentals such as fuel types, combustion, feedwater, boiler controls and instrumentation, operation of boilers, safety and legal requirements and boiler efficiency","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Heat recovery systems and energy management including the requirements of efficient best practice","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Electrical and electronic systems, design techniques and their applications to British Standards","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Installation of systems and supply systems following food safety standards e.g. tray work","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Advanced electrical principles (low voltage (LV) to high voltage (HV))","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Instrumentation and calibration techniques for systems, for example thermo, weights and flow","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Automation and control systems primarily with the following low voltage systems, i.e. building automation systems, heating, ventilation and air conditioning (HVAC) controls, access control systems, data cabling and fiber optic cable installation and termination","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Supervisory control and data acquisition (SCADA) and network systems","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Electrical safety systems and smart solutions","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Use engineering principles to deliver products/packaged food","YES","YES",null,null,null,null,null,null,{"$f":"IF(E56:E76 = \"FULLY MET\",1,IF(E56:E76 = \"PARTIALLY MET\",0.5,IF(E56:E76 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L56=1,1,IF(L56=0.5,0.5,IF(L56=0,0)))","v":0},{"$f":"IF(N56=1,\"NONE\",IF(N56=0.5,\"PARTIAL\",IF(N56=0,\"FULL\")))","v":"FULL"}]
["S2","Comply with standard operating procedures, company, legal and regulatory requirements and customer/consumer and engineering standards","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Plan, for example labour and engineering materials","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Influence and communicate with colleagues and others, such as engineers, other functions and teams","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(L59=1,0.5,IF(L59=0.5,0.5,IF(L59=0,0)))","v":0},{"$f":"IF(N59=0.5,\"NONE\",IF(N59=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Assess team and individual performance, provide feedback to improve; coach and mentor","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(L60=1,0.5,IF(L60=0.5,0.5,IF(L60=0,0)))","v":0},"PARTIAL"]
["S6","Use continuous improvement techniques, for example apply quality management principles, participate in failure investigations and contribute to and implement practical engineering solutions for efficiency and/or profitability","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L61=1,1,IF(L61=0.5,0.5,IF(L61=0,0)))","v":0},{"$f":"IF(N61=1,\"NONE\",IF(N61=0.5,\"PARTIAL\",IF(N61=0,\"FULL\")))","v":"FULL"}]
["S7","Use IT, digitisation and manual methods to collect data from systems to support engineering activity within the business","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Use and develop planned preventative maintenance (PPM) strategies, incorporate appropriate proactive maintenance routines, such as vibration analysis, thermography, simple visual/part measurement","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Analyse operational performance, specification and data","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Evaluate possible failure modes and identify strategy, for example technical risk assessment methods, PPM to RCM techniques","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Contribute to the construction and commissioning of equipment and machinery used for producing preserved/fresh and safe food and drink products","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(L66=1,0.5,IF(L66=0.5,0.5,IF(L66=0,0)))","v":0},{"$f":"IF(N66=0.5,\"NONE\",IF(N66=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S12","Design, produce, and operate mechanical machinery","YES","NO",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(L67=1,0.5,IF(L67=0.5,0.5,IF(L67=0,0)))","v":0},"PARTIAL"]
["S13","Design power circuits, utilising software and calculation","YES","NO",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L68=1,1,IF(L68=0.5,0.5,IF(L68=0,0)))","v":0},{"$f":"IF(N68=1,\"NONE\",IF(N68=0.5,\"PARTIAL\",IF(N68=0,\"FULL\")))","v":"FULL"}]
["S14","Apply specialist reliability engineering techniques to prevent or reduce the likelihood or frequency of failures i.e. vibration analysis, oil sampling, heat mapping, non-destructive testing","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Apply thermodynamic theory to more complex engineering systems, for example tempering chocolate, cleaning systems, sterilisation, vacuum cooling","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Design and improve systems, for example steam, water or air","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Design and configure electrical systems i.e. add distribution boards to circuits","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Modell dynamic systems utilising software tools","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Design and modify electrical control engineering systems i.e.: Engineering LAN/ network","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Diagnose faults on complex control systems","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Decipher complex programme sequences in higher and lower level languages","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Safe working, for example promotes a culture of food safety and safe working practices","YES","YES",null,null,null,null,null,null,{"$f":"IF(E78:E85 = \"FULLY MET\",1,IF(E78:E85 = \"PARTIALLY MET\",0.5,IF(E78:E85 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L78=1,1,IF(L78=0.5,0.5,IF(L78=0,0)))","v":0},{"$f":"IF(N78=1,\"NONE\",IF(N78=0.5,\"PARTIAL\",IF(N78=0,\"FULL\")))","v":"FULL"}]
["B2","Takes ownership of work, for example takes responsibility and ownership of decision making for good food practice; is proactive, and demonstrates initiative; plans work: dependable; works autonomously within own sphere of responsibility","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Shows pride in work, for example strong work ethic; displays a positive mind set; pays attention to detail; looks for new ways of working that improve outcomes and results","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Committed to self-development, for example seeks learning, drives the development of self and others; maintains and enhances own practice through continuing professional development activity","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(L81=1,0.5,IF(L81=0.5,0.5,IF(L81=0,0)))","v":0},{"$f":"IF(N81=0.5,\"NONE\",IF(N81=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Shows integrity and respect, for example promotes integrity in process and site standards, respects others, promotes good communication at all levels, adapts personal style to meet work needs","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L82=1,1,IF(L82=0.5,0.5,IF(L82=0,0)))","v":0},{"$f":"IF(N82=1,\"NONE\",IF(N82=0.5,\"PARTIAL\",IF(N82=0,\"FULL\")))","v":"FULL"}]
["B6","Team player, for example drives good relationships with others, works collaboratively, contributes ideas and challenges appropriately","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Responsive to change, for example flexible to changing working environment and demands; resilient under pressure","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Shows company/industry perspective, for example promotes the position of the business in relation to market and competition, keeps up to date with industry and market advancement, commercially aware","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(L85=1,0.5,IF(L85=0.5,0.5,IF(L85=0,0)))","v":0},{"$f":"IF(N85=0.5,\"NONE\",IF(N85=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Food and Drink Engineer (level 5) (ST0624) - Mechanical Food and Drink Engineer   "]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L47, L56:L71, L78:L85)","v":0},"Net Score",{"$f":"SUM(N26:N47, N56:N71, N78:N85)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L90/N94","v":0},"total CoE KSB coverage",{"$f":"N90/N97","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",46]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",6]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N94-N95-(N96*0.5)","v":43}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Food and Drink Engineer (level 5) (ST0624) - Electrical Food and Drink Engineer   "]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L43, L47:L54, L56:L66, L72:L76, L78:L85)","v":0},"Net Score",{"$f":"SUM(N26:N43, N47:N54, N56:N66, N72:N76, N78:N85)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L102/N106","v":0},"total CoE KSB coverage",{"$f":"N102/N109","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",49]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",5]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N106-N107-(N108*0.5)","v":46.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KBSs"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L85)","v":0},"Net Score",{"$f":"SUM(N26:N85)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L114/N118","v":0},"total CoE KSB coverage",{"$f":"N114/N121","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",58]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",6]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N118-N119-(N120*0.5)","v":55}]

{"sheet":"ST0662","index":8,"n_rows":65,"n_cols":18,"rows_kept":65,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Automation and controls engineering technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Engineering maths - mathematical principles and theories that underpin engineering",null,null,null,null,null,null,{"$f":"IF(C22:C34 = \"FULLY MET\",1,IF(C22:C34 = \"PARTIALLY MET\",0.5,IF(C22:C34 = \"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","Engineering principles - the underlying principles of electrical and electronic circuits and devices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Functional solutions - Create functional solutions; identifying and justifying a solution to a given engineering need",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Safety procedures - relevant safety procedures required to operate on automation equipment in an industrial environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Single and three phase circuits - single phase and three phase supplies on AC and DC motor and control circuits",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Automation knowledge - Programmable Logic Controllers (PLC), Variable Speed Drives (VSD), Human Machine Interface (HMI) & Supervisory Control and Data Acquisition (SCADA), robotics hardware and software tools to carry out configuration, programming and fault finding duties",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Instrumentation knowledge - instrumentation used to measure flow, temperature, pressure etc and the means by which they transmit measurement data",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Use of software tools - Justification in the utilisation of software tools would be for but not limited to the changing of hardware configurations, firmware updates, software modifications and commissioning",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Industrial networking knowledge - the application, installation and operational characteristics of industrial communication networks at Supervisory (e.g. Ethernet), Cell (e.g. PROFINET/PROFIBUS) and Field (e.g. AS-Interface) levels",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Use of diagnostic tools - diagnostic tools and equipment including web-based diagnostics incorporated into network devices and other software tools (e.g. PROFITrace)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Understand technical documents - Ability to follow electrical system circuit diagrams, understand the operation of the various components that make up an automation system",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Safety legislation and responsibilities - electrical safety system legislation & directives",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Quality systems - quality assurance principles to ensure operation, consistency and quantification of enhancement of manufacturing and process applications",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Safety Effective - The ability to work safely in an industrial environment and where required, produce risk assessment/method statement documentation. Be able to apply the principles of functional machinery and/or process safety including SIL (Safety Integrated Level) and PL (Performance Level) terminology",null,null,null,null,null,null,{"$f":"IF(C36:C43 = \"FULLY MET\",1,IF(C36:C43 = \"PARTIALLY MET\",0.5,IF(C36:C43 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J36=1,1,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=1,\"NONE\",IF(L36=0.5,\"PARTIAL\",IF(L36=0,\"FULL\")))","v":"FULL"}]
["S2","Engineering documentation - Production and interpretation of a range of technical documentation (device manuals, operating procedures, schematics, fault reports etc), and working with company documentation systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Project engineering capabilities - Support of installation, commissioning, shut-down, start-up and maintenance/service/support of a wide range of systems and devices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Diagnostic capabilities - Fault finding, diagnosis, rectification and reporting of automation control systems and controls applications via the utilisation of formal problem solving methods and diagnostic tools/software",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Instrumentation configuration and calibration - Set-up, calibrate and commission a wide variety of field level instrumentation that interfaces to automation & control systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Industrial Networks configuration and support - configure, assist commissioning and continued support of industrial network solutions at all hierarchical levels of control system integration using the requisite tools and or software",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","HMI & SCADA configuration and programming - Make changes to existing systems or implement new configurations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","PLC/Robot configuration and programming - Implement complex PLC/Robot program content and configurations to affect changes to increase availability and or efficiency of automation controlled machinery and the ability to configure PLC and or Robot hardware and program a wide variety of PLC’s and or Robot’s",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Zero Harm - Always prioritise on Health and Safety best practice",null,null,null,null,null,null,{"$f":"IF(C45:C55 = \"FULLY MET\",1,IF(C45:C55 = \"PARTIALLY MET\",0.5,IF(C45:C55 = \"NOT MET\",0,)))","v":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"}]
["B2","Resilience - Sound and established ability to work effectively both in a team and alone",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Personal excellence - Interact professionally with clients and stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Communicative - High quality communication skills",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Ethical - Strong professional and business ethics",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Commitment - A focus on quality in all the tasks assigned",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Continual development - Willingness to learn new processes, methods and technologies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Responsibility - Strong commitment and accountability and ability to apply independent judgement",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Personal Values - Respect and tolerance of others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B10","Ambassadorial - To be a role model of engineering practice and to promote engineering in order to sustain a pipeline of future talent",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J54=1,0.5,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=0.5,\"NONE\",IF(L54=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B11","Reflection - Evaluate outcomes of own performance across all duties",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J55=1,1,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=1,\"NONE\",IF(L55=0.5,\"PARTIAL\",IF(L55=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J55)","v":0},"Net Score",{"$f":"SUM(L22:L55)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J58/L62","v":0},"total CoE KSB coverage",{"$f":"L58/L65","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",32]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L62-L63-(L64*0.5)","v":31.5}]

{"sheet":"ST0841","index":9,"n_rows":73,"n_cols":18,"rows_kept":73,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Engineering manufacturing technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Problem solving tools/techniques. Such as practical problem solving (PPS), root cause analysis (RCA) and process failure mode effects analysis (PFMEA).",null,null,null,null,null,null,{"$f":"IF(C22:C44 = \"FULLY MET\",1,IF(C22:C44 = \"PARTIALLY MET\",0.5,IF(C22:C44 = \"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","Effective communication techniques including listening, questioning and support of others.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Use, benefits and applications of lean methods and tools used in manufacturing and engineering (such as Kaizen, Six Sigma and 8 wastes).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","How Industry 4.0 will impact organisations, including the integration of automation, digital systems and manufacturing engineering systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Quality management systems used such as ISO9001, AS9100, ISO 14001 and TS16949, its purpose and internal governance arrangements to ensure compliance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Different manufacturing methods used, their applications, such as machining, joining, forming, assembling, shaping, processing, printing, moulding, extruding and casting.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Principles of quality control and quality assurance in a manufacturing and engineering environment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Team integration techniques, including conflict resolution and managing difficult conversations (team working).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Core engineering principles such as mathematics, science, mechanical and electrical/electronic applications relevant to manufacturing and engineering activity undertaken.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Importance for individuals to use and follow the organisations approved Standard Operating Procedures (SOP’s) and documentation recording systems and the potential implications on safety, quality and delivery if they are not adhered to.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Statutory and organisation health and safety policies, procedures and regulations that must be adhered to in a manufacturing and engineering environment including the risk assessment process, procedures and documentation used within the work area.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Project management techniques, such as Strengths, Weaknesses, Opportunities, Threats (SWOT), stakeholder matrices, risk mapping, radar chart and summary risk profiles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How human factors (organisational, environment and job factors) can influence and impact individual characteristics, performance and behaviours in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Engineering and manufacturing related documentation used such as job cards / build records, 2D & 3D drawing/models, Bill of Materials (BOM), Cost Analysis Reports, Compliance  Report, Standard Operating Instructions (SOI's), Standard Process Instructions (POI's), Engineering Query Notifications (EQN's) and Drawing Query Notifications (DQN's).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Prioritisation of workload/time management techniques to ensure that personal and team objectives are achieved effectively.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Engineering and manufacturing data collection systems used, their format and content.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How organisations manage and monitor internal and or supplier performance to ensure that cost, quality, delivery and sustainability objectives are being delivered.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Use and applications of common metallic and non – metallic materials used in manufacturing and engineering.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Different production methods used and their applications such as single, batch, flow and mass.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Different methods, tools and frequency used to check quality in manufacturing and engineering including measurements such as (dimensions, weight, signal, temperature, time,) and testing (such as non-destructive and destructive).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Departmental process used to create, record and review financial data and information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The different applications and limitations of computer based software system/packages used such as Computer Aided Design (CAD), Data Analytics and Databases.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The impact of sustainability and environmental efficiency and how such matters influence manufacturing decisions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Read and extract relevant engineering and manufacturing related data and information (such as workplans/project plans ,schedules,  drawings, specifications, production data, quality reports, costing data, statistical information) drawing accurate conclusions and making informed decisions.",null,null,null,null,null,null,{"$f":"IF(C46:C55 = \"FULLY MET\",1,IF(C46:C55 = \"PARTIALLY MET\",0.5,IF(C46:C55 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J46=1,1,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=1,\"NONE\",IF(L46=0.5,\"PARTIAL\",IF(L46=0,\"FULL\")))","v":"FULL"}]
["S2","Use project management tools, such as Strengths, Weaknesses, Opportunities, Threats (SWOT), stakeholder matrices, risk mapping, radar chart and summary risk profiles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Use problem solving tools such as Root Cause Analysis (RCA) Process Failure Modes Effects Analysis (PFMEA), Fishbone, Practical Problem Solving (PPS) and Advanced Product Quality Planning (APQP).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Analyse and interpret data and information in order to generate manufacturing engineering documentation such as Parts Per Million (PPM) quality adherence, cost analysis and test data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Communicate using the appropriate method for the audience such as, formal and informal presentations, written reports, verbal, electronic, social media and incorporating relevant and appropriate data and/or metrics.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Use the approved process and quality compliance procedure to create or amend engineering and/or manufacturing documentation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Use lean tools and techniques, such as Six Sigma, 8 Wastes, Workplace organisation such as 5S's (sort, set in order, shine, standardise and sustain), Kaizen and Poka-Yoke (Error proofing).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Apply documentation control processes and procedures such as format, location, access, authorisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Use financial planning, recording and review processes and documentation such as departmental budgets, estimating, cost control, cost forecasting, and investment appraisal.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Use computer based software system/packages such as Computer Aided Design (CAD), Data Analytics and Databases.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Champions the importance of adherence to the organisation’s Environmental, Health and Safety management systems:- actively displays and promotes a safety first culture within the organisation.",null,null,null,null,null,null,{"$f":"IF(C57:C63 = \"FULLY MET\",1,IF(C57:C63 = \"PARTIALLY MET\",0.5,IF(C57:C63 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J57=1,0.5,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=0.5,\"NONE\",IF(L57=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Operates in a systematic, proactive and transparent way.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J58=1,1,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=1,\"NONE\",IF(L58=0.5,\"PARTIAL\",IF(L58=0,\"FULL\")))","v":"FULL"}]
["B3","Actively promotes the case for the adoption of emerging and advanced engineering and manufacturing technologies to optimise performance.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J59=1,0.5,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=0.5,\"NONE\",IF(L59=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B4","Takes full responsibility for own professional development, seeking opportunities to enhance knowledge, skills and experience. Keeping abreast of developments in engineering processes manufacturing and emerging technologies.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J60=1,1,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=1,\"NONE\",IF(L60=0.5,\"PARTIAL\",IF(L60=0,\"FULL\")))","v":"FULL"}]
["B5","Complies with statutory and organisational health & safety regulations and policies at all times. Accepts responsibility for their workload with a responsible approach to risk. Demonstrates a high level of motivation and resilience when facing challenge.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Creates and maintains positive, professional, trusting and ethical working relationships with their team and the wider range of internal, external and connected stakeholders.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J62=1,0.5,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=0.5,\"NONE\",IF(L62=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B7","Acts professionally with a positive and respectful attitude.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J63=1,1,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},{"$f":"IF(L63=1,\"NONE\",IF(L63=0.5,\"PARTIAL\",IF(L63=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J63)","v":0},"Net Score",{"$f":"SUM(L22:L63)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J66/L70","v":0},"total CoE KSB coverage",{"$f":"L66/L73","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",40]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L70-L71-(L72*0.5)","v":38.5}]

{"sheet":"ST0847","index":10,"n_rows":116,"n_cols":20,"rows_kept":116,"cut":false,"hidden":false,"merged":[[82,10,82,15],[94,10,94,15],[106,10,106,15],[9,0,9,8],[23,2,23,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[10,2,10,3]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Engineer Surveyor occupation, plus the specific KSBs for Engineer Surveyor (Mechanical) and Engineer Surveyor (Electrical) options)","Included in:",null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,null,"Engineer surveyor (level 4) - Engineer Surveyor (Mechanical)","Engineer surveyor (level 4) - Engineer Surveyor (Electrical)"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","Yes","Yes","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","Yes","Yes","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,"Engineer surveyor (level 4)"]
[null,"Return to Guide"]
[null,"Two options are available (columns C-D). Please check if the KSB needs to be mapped against the option of your choice. If you map against two options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
[]
["KSB","KSB Statement\n\n(this list contains the core KSBs for the Engineer Surveyor occupation, plus the specific KSBs for Engineer Surveyor (Mechanical) and Engineer Surveyor (Electrical) options)","Included in:",null,"KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","Engineer surveyor (level 4) - Engineer Surveyor (Mechanical)","Engineer surveyor (level 4) - Engineer Surveyor (Electrical)"]
["K1","Company inspection procedures and processes","YES","YES",null,null,null,null,null,null,{"$f":"IF(E26:E46 = \"FULLY MET\",1,IF(E26:E46 = \"PARTIALLY MET\",0.5,IF(E26:E46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L26=1,1,IF(L26=0.5,0.5,IF(L26=0,0)))","v":0},{"$f":"IF(N26=1,\"NONE\",IF(N26=0.5,\"PARTIAL\",IF(N26=0,\"FULL\")))","v":"FULL"}]
["K2","The equipment being inspected and how it is used","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Use a range of measurement tools and equipment to carry out inspections such as Vernier Calipers, Pressure Gauges, electrical test equipment, flow meters - where appropriate","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Management techniques including customer relationship management, negotiating and influencing techniques, commercial awareness, conflict management and assertiveness techniques","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Roles and responsibilities within the organisation, team dynamics and their own boundaries of authority","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Report writing tools and note taking techniques and correct use of Systems International (SI) units of abbreviations","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Risk assessment methodology and appropriate control measures","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How and when to use appropriate IT tools, including spreadsheets and word processing packages","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Appropriate legislation and standards including all relevant Health and Safety requirements","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Appropriate mathematical problem solving tools including engineering mathematics such as calculus, algebraic transformation techniques ,logarithmic and exponential functions and algebraic methods, trigonometric functions, the radian measure, trigonometric identities and graphs","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Engineering science, including the behavioural characteristics of elements of static engineering systems, the behavioural characteristics of elements of dynamic engineering systems","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Mechanical Materials science, including the properties, characteristics and selection criteria of materials from tests and data sources including, metallic, ceramic, polymer and composite material","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Principles of electrical engineering, including technical drawings, circuits, distribution boards, wiring, measurement and testing of electrical circuits","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","A detailed technical awareness of the equipment being inspected","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Safe access and egress","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Effective oral and written communication strategies, the terminology used in this occupation and the appropriate format of inspection reports","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Installation methods and practices","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","AC and DC theory and how this can be used to solve electrical and electronic engineering problems","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Principles of materials engineering, including the relationships between manufacturing processes and material behaviour, the impact of heat treatment, liquid processing and mechanical processing methods","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The in-service causes of failure of engineering materials, including the most common causes of in-service failure and appropriate remedial action","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Health and safety requirements which apply when inspecting, testing and commissioning principles of electrical installations. (Requirements for inspecting and testing electrical installations, requirements for the safe inspection of electrical installations, requirements for the safe testing of electrical installations, inspection and testing procedures of electrical installations.)","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Carry out inspections of engineering equipment in accordance with company policies, relevant legislation and standards","YES","YES",null,null,null,null,null,null,{"$f":"IF(E48:E65 = \"FULLY MET\",1,IF(E48:E65 = \"PARTIALLY MET\",0.5,IF(E48:E65 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L48=1,1,IF(L48=0.5,0.5,IF(L48=0,0)))","v":0},{"$f":"IF(N48=1,\"NONE\",IF(N48=0.5,\"PARTIAL\",IF(N48=0,\"FULL\")))","v":"FULL"}]
["S2","Identify equipment defects - both common and complex - and take appropriate action to advise a compliant outcome","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Use appropriate inspection equipment","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Use negotiating and influencing techniques to build and maintain customer relationships","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Prepare succinct inspection reports using appropriate IT systems","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Use engineering principles to reach an overall conclusion about the condition of the equipment","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Prepare Risk Assessments and apply Safe Systems of Work","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Identify and manage risks of health, safety and welfare","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Communicate professionally, effectively and appropriately - both verbally and in writing - with all stakeholders","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Manage own time and tasks","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Apply engineering science, to identify the behavioural characteristics of elements of static engineering systems, the behavioural characteristics of elements of dynamic engineering systems and AC and DC theory and use this knowledge to identify equipment defects and suggest solutions","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Apply the appropriate electrical engineering science principles when inspecting, testing and commissioning an electrical installation, to reach overall conclusions","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Apply the appropriate mechanical engineering science principles when inspecting a mechanical installation, to reach overall conclusions","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Manage and diffuse potential conflicts","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Work safely at height","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L62=1,1,IF(L62=0.5,0.5,IF(L62=0,0)))","v":0},{"$f":"IF(N62=1,\"NONE\",IF(N62=0.5,\"PARTIAL\",IF(N62=0,\"FULL\")))","v":"FULL"}]
["S16","Read and interpret drawings, data and other relevant information","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L63=1,1,IF(L63=0.5,0.5,IF(L63=0,0)))","v":0},{"$f":"IF(N63=1,\"NONE\",IF(N63=0.5,\"PARTIAL\",IF(N63=0,\"FULL\")))","v":"FULL"}]
["S17","Interpret appropriate engineering mathematical formulae and compare results with actual on-board readings, data/calculations and inspection findings","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Work competently and safely in the workplace to meet regulatory and legislative requirements","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Strong work ethic: Positive attitude, motivated by engineering, dependable, ethical, responsible and reliable","YES","YES",null,null,null,null,null,null,{"$f":"IF(E67:E79 = \"FULLY MET\",1,IF(E67:E79 = \"PARTIALLY MET\",0.5,IF(E67:E79 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L67=1,1,IF(L67=0.5,0.5,IF(L67=0,0)))","v":0},{"$f":"IF(N67=1,\"NONE\",IF(N67=0.5,\"PARTIAL\",IF(N67=0,\"FULL\")))","v":"FULL"}]
["B2","Logical approach: Able to structure a plan and develop activities following a logical thought process, but also able to quickly \"think on feet\" when working through them","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Problem solving orientation: Identifies issues quickly, enjoys solving complex problems and applies appropriate solutions. Has a strong desire to push to ensure the true root cause of any problem is found and a solution is identifies which prevents recurrence","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Quality focus: Follows rules, procedures and principles in ensuring work completed is fit for purpose and pays attention to detail. Checks for errors","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Personal responsibility and resilience: Motivated to succeed. Accountable and persistent to complete task","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Clear communicator: Uses a variety of communication methods to give and receive information accurately and in a positive manner","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Team player: Not only plays own part but able to work and communicate clearly and effectively within a team and interacts with and helps others when required. Does so in a respectful manner","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Maintains competence and keeps pace with change: Continuous improvement in driving effectiveness and efficiency and maintenance of regulations and rules","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(L74=1,0.5,IF(L74=0.5,0.5,IF(L74=0,0)))","v":0},{"$f":"IF(N74=0.5,\"NONE\",IF(N74=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B9","Adaptability: Able to adjust to different conditions, technologies, situations and environments","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L75=1,1,IF(L75=0.5,0.5,IF(L75=0,0)))","v":0},{"$f":"IF(N75=1,\"NONE\",IF(N75=0.5,\"PARTIAL\",IF(N75=0,\"FULL\")))","v":"FULL"}]
["B10","Self-motivation: A \"self-starter\" who wants to give their best, sets themselves challenging targets and can make their own decisions","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B11","Commitment: Able to commit to beliefs, goals and standards of their own employer and to the wider industry and its professional standards","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B12","Independence and impartiality: Maintains independence and impartiality at all times","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B13","Health and Safety: Maintains a health and safety focus at all times, challenging unacceptable behaviour","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Engineer Surveyor (level 4) - Engineer Surveyor (Mechanical) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L37, L39:L42, L44:L45, L48:L58, L60:L65, L67:L80)","v":0},"Net Score",{"$f":"SUM(N26:N37, N39:N42, N44:N45, N48:N58, N60:N65, N67:N80)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L85/N89","v":0},"total CoE KSB coverage",{"$f":"N85/N92","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",48]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N89-N90-(N91*0.5)","v":47.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Engineer Surveyor (level 4) - Engineer Surveyor (Electrical)"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L36, L38:L43, L46, L48:L59, L61:L65, L67:L79)","v":0},"Net Score",{"$f":"SUM(N26:N36, N38:N43, N46, N48:N59, N61:N65, N67:N79)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L97/N101","v":0},"total CoE KSB coverage",{"$f":"N97/N104","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",48]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N101-N102-(N103*0.5)","v":47.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KBSs"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L80)","v":0},"Net Score",{"$f":"SUM(N26:N80)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L109/N113","v":0},"total CoE KSB coverage",{"$f":"N109/N116","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",52]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N113-N114-(N115*0.5)","v":51.5}]

{"sheet":"ST0855","index":11,"n_rows":77,"n_cols":18,"rows_kept":77,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Space engineering technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Spacecraft Systems including power, attitude control, thermal, communications, data handling and propulsion.",null,null,null,null,null,null,{"$f":"IF(C22:C39 = \"FULLY MET\",1,IF(C22:C39 = \"PARTIALLY MET\",0.5,IF(C22:C39 = \"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","Engineering mathematical and scientific principles, methods, techniques, graphical expressions, symbols, formulae and calculations including: reference frame definitions, tolerancing, torque settings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Relationships between customers, partners & suppliers in the international space engineering and manufacturing sector.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Space system assembly, integration and test procedures, processes, techniques and tools such as vibration, thermal-vacuum, electromagnetic compatibility.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Purpose of approved processes, components, parts and materials lists and verification control documentation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Ground Support Equipment and Systems including electrical/electronic test equipment and mechanical handling equipment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Mechanical, Electrical and Electronic Analysis & Testing principles, including space industry-specific test standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Properties, handling and application of space qualified materials including Electrostatic Discharge (ESD) precautions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Quality and Product Assurance principles in space projects.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Principles, processes and techniques for thermal-vacuum, electromagnetic compatibility, shock, vibration and acoustic testing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Principles of Additive Manufacturing for application in space including powder quality and repeatability of build.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Configuration and Document Management Control Processes including issue control, incorporation of change and End Item Data Pack.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Adhesives, bonding, soldering and fastening techniques required to meet space qualification standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The space environment including thermal, vacuum, radiation, atomic oxygen and launch operations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Precision and uncertainty in measurement systems, including limitations and appropriate use.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Vacuum and pressurised systems and measurement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Disciplines and handling in cleanliness and contamination-controlled environments.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Application of Risk Assessment at point of work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Prepare and complete documentation including work instruction, build and change records, risk assessments and non-conformance reports in compliance with applicable space industry processes and standards.",null,null,null,null,null,null,{"$f":"IF(C41:C59 = \"FULLY MET\",1,IF(C41:C59 = \"PARTIALLY MET\",0.5,IF(C41:C59 = \"NOT MET\",0,)))","v":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"}]
["S2","Contribute to technical reviews such as assembly, integration and test readiness, and non-conformance reviews.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Assemble, integrate and test at equipment, subsystem and system level.",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"}]
["S4","Support and maintain ground support systems for spacecraft and subsystems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Interpret outputs from manufacturing software such as Computer Aided Design (CAD) / Computer Aided Manufacture (CAM) and Product Data Management / Product Lifecycle Management (PDM/PLM).",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"}]
["S6","Solve problems using procedures and methodologies commonly applied in the space engineering sector, such as Failure Mode and Effects Analysis (FMEA), Plan-Do-Check-Act (PDCA) Cycle, 8-Disciplines (8D), Ishikawa/Fishbone Diagrams.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Contribute to the definition of space engineering process improvement plans.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Use internal and external Quality Management Systems including Non-Conformance Reports (NCRs), Production Documentation, and published standards applicable to space engineering and manufacture such as EN9100, ISO9001.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Read, extract and interpret technical documentation (such as workplans/project plans, schedules, drawings, test plans, specifications, production data, quality reports, costing data, statistical information, assembly instructions and requirements) drawing accurate conclusions and making informed decisions, seeking clarification where required.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Perform electrical and electronic measurement and testing using equipment such as voltmeters, spectrum analysers, oscilloscopes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Perform appropriate joining techniques for example using adhesives, bonding, plating, soldering and fastening, following procedures for space quality standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Carry out assembly and functional testing of products such as electronics boards and mechanical assemblies, to design specifications and space industry standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Inspect electrical, mechanical or electronic equipment for quality assurance purposes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Use CAD software to create 3D models and part drawings to enable manufacture of components for spacecraft systems and ground support equipment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Apply space industry procedures in facilities such as cleanrooms, workshops and testing facilities (for example, ECSS-Q-ST-70-50C: Particles contamination monitoring for spacecraft systems and cleanrooms) in compliance with legislative and company Health, Safety and Environment requirements.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J55=1,1,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=1,\"NONE\",IF(L55=0.5,\"PARTIAL\",IF(L55=0,\"FULL\")))","v":"FULL"}]
["S16","Measure, test and analyse, using instruments such as pressure gauges, micrometers, balances and non-contact approaches.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J56=1,1,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=1,\"NONE\",IF(L56=0.5,\"PARTIAL\",IF(L56=0,\"FULL\")))","v":"FULL"}]
["S17","Use and maintain vacuum and pressure systems for space applications (such as environmental test chambers, pressure-fed propulsion systems, and gas supply lines for manufacturing & testing) including associated processes and documentation such as Piping & Instrumentation Diagrams.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Use and maintain cryogenic systems for space applications (such as propulsion, subsystem thermal control and ground support activities) including associated processes and documentation, in compliance with legislative and company Health, Safety and Environment requirements.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J58=1,0.5,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=0.5,\"NONE\",IF(L58=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S19","Communicate using verbal and written methods such as for formal and informal presentations, written reports and electronic dissemination, adjusting approach to take account of equality and diversity considerations, and listen to others.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J59=1,1,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=1,\"NONE\",IF(L59=0.5,\"PARTIAL\",IF(L59=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Takes personal responsibility and is resilient. For example, disciplined and responsible approach to risk, works diligently regardless of how much they are being supervised, accepts responsibility for managing their own time and workload and stays motivated and committed when facing challenges.",null,null,null,null,null,null,{"$f":"IF(C61:C67 = \"FULLY MET\",1,IF(C61:C67 = \"PARTIALLY MET\",0.5,IF(C61:C67 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J61=1,1,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=1,\"NONE\",IF(L61=0.5,\"PARTIAL\",IF(L61=0,\"FULL\")))","v":"FULL"}]
["B2","Focuses on quality and problem solving. For example, demonstrates attention to detail and seeks opportunities to improve quality, speed and efficiency.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J62=1,1,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=1,\"NONE\",IF(L62=0.5,\"PARTIAL\",IF(L62=0,\"FULL\")))","v":"FULL"}]
["B3","Committed to continuous personal improvement. For example, reflects on skills, knowledge and behaviours and seeks opportunities to develop, adapts to different situations, environments or technologies and has a positive attitude to feedback and advice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Is responsible and accountable. For example, is present in the workplace at the required times, completes all assigned tasks and takes responsibility for the duties assigned to the role. Shows a desire to succeed, approaches difficult or challenging problems with enthusiasm, shows initiative and supports the success of the team/organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Performs through co-operation and works effectively in teams. For example, has a clear understanding of role; voluntarily engages in open communication with team colleagues and line management; identifies individual contributions that can be made to reach collective goals; supports meetings and work sessions on request. Adopts a positive attitude to working with others, and supports discussion with facts and logic, and considers implications of their actions on other people and the business.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=1,\"NONE\",IF(L65=0.5,\"PARTIAL\",IF(L65=0,\"FULL\")))","v":"FULL"}]
["B6","Interacts appropriately with stakeholders. For example, works to understand stakeholder requirements and perspectives, and can present work positively and with confidence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Uses a safety-first approach in order to comply with legislative and company Health, Safety and Environment requirements.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J67=1,1,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=1,\"NONE\",IF(L67=0.5,\"PARTIAL\",IF(L67=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J67)","v":0},"Net Score",{"$f":"SUM(L22:L67)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J70/L74","v":0},"total CoE KSB coverage",{"$f":"L70/L77","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",44]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L74-L75-(L76*0.5)","v":43.5}]

{"sheet":"ST0861","index":12,"n_rows":84,"n_cols":18,"rows_kept":84,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Asset manager (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Asset management standards: ISO55000, British Standard Institute (BSI) Publicly Available Specification (PAS) 55.",null,null,null,null,null,null,{"$f":"IF(C22:C47 = \"FULLY MET\",1,IF(C22:C47 = \"PARTIALLY MET\",0.5,IF(C22:C47 = \"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","Management systems for asset management: policy, strategy, objectives, plans and continual improvement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Impact of organisational context on asset management: regulatory frameworks, stakeholders, governance and asset management policy, objectives strategy and plan.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Different types of assets and classification approaches; hierarchy, function and value.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Asset systems; effect of each asset on the system and impact of external factors.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Asset/system service and performance requirements; service level.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Continuous improvement techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Asset costing and valuation techniques; cost estimation (maintenance, operation, renewal), depreciation, whole life costing, and social, environmental, safety and reputational cost.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Optioneering, cost benefit analysis; asset management multi-criteria decision making (cost, risk, performance, sustainability, compliance and intangibles).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Creative thinking and problem-solving techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Asset life cycle activities: demand analysis and future requirements, creation and acquisition or rationalisation, operation, resilience, redundancy, shutdown, obsolescence, outage management, future asset capability.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Performance monitoring of asset life cycle activities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Asset and asset systems health, condition and performance assessment methods.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Project management, resource and time management techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Types of asset maintenance: preventive, predictive, corrective.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Risk management and its application to asset management: risk assessment, quantification, mitigation and impact.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Techniques to assess asset risk; causes and effects: Failure Mode Event/Effects Critically Analysis (FMEA/FMECA), Root cause analysis and Bow Tie analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Legislation: Health and Safety at Work, Environmental Protection.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Sustainable development; impact on environment of asset management and asset management activities.",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"}]
["K20","Supply chain; types of suppliers, their role and contractual relationships.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Collaborative working techniques: personality types, influencing, negotiating, networking, and equality, diversity and inclusion.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Communication techniques including plain English – verbal, written and presentation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Business ethics including corporate governance, bribery, discrimination, socially responsible organisations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Data analysis and interpretation techniques; data presentation techniques (charts, diagrams and tables).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Information technology (IT) systems and processes: asset registers, work management systems, word processing, spreadsheets, email, presentation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Information and data security/management requirements; cyber security, General Data Protection Regulations (GDPR), data protection and integrity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Identify the organisation’s context and constraints that affect asset management.",null,null,null,null,null,null,{"$f":"IF(C49:C66 = \"FULLY MET\",1,IF(C49:C66 = \"PARTIALLY MET\",0.5,IF(C49:C66 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J49=1,0.5,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=0.5,\"NONE\",IF(L49=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Identify asset service and performance requirements.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"}]
["S3","Estimate and calculate Life Cycle Cost (LCC) or Total Cost of Ownership (TCO) for assets/asset systems.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
["S4","Use techniques to identify interventions for assets/asset system and estimate benefits.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Apply multi criteria decision making methods to proposed intervention options.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Select and use decision support tools to make asset management recommendations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Develop asset life-cycle plans including performance monitoring and business case.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Classify assets, asset systems, life cycle stages and activities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Plan and manage projects.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Assess asset health; condition and performance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Select and apply fault finding technique(s) to identify causes and effects of assets/asset system failures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Apply continuous improvement techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Assess and quantify asset, asset system and asset management activity-related risks; identify mitigation options.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Comply with legislation, asset management standards and company policies.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J62=1,0.5,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=0.5,\"NONE\",IF(L62=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Use information technology systems and processes: for example, asset registers, work management systems, word processing, spreadsheets, email, presentation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Collate and analyse asset/asset system data and information.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["S17","Interpret and present data - qualitative and/or quantitative.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Communicate with colleagues and stakeholders – verbal, written and presentation.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Committed to compliance with legislation, asset management standards and company policies.",null,null,null,null,null,null,{"$f":"IF(C68:C74 = \"FULLY MET\",1,IF(C68:C74 = \"PARTIALLY MET\",0.5,IF(C68:C74 = \"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"}]
["B2","Focusses on value and outcomes in alignment with organisational objectives and stakeholders’ expectations.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J69=1,0.5,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=0.5,\"NONE\",IF(L69=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Collaborates, within teams and across disciplines.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J70=1,1,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=1,\"NONE\",IF(L70=0.5,\"PARTIAL\",IF(L70=0,\"FULL\")))","v":"FULL"}]
["B4","Shares knowledge and good practice, gives and receives feedback, help and support.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Adaptable for example, seeks new ways of working.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J72=1,1,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=1,\"NONE\",IF(L72=0.5,\"PARTIAL\",IF(L72=0,\"FULL\")))","v":"FULL"}]
["B6","Reliable and self-motivated, takes responsibility for work and seeks to deliver against personal objectives.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Committed to continued professional development.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J74=1,1,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=1,\"NONE\",IF(L74=0.5,\"PARTIAL\",IF(L74=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J74)","v":0},"Net Score",{"$f":"SUM(L22:L74)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J77/L81","v":0},"total CoE KSB coverage",{"$f":"L77/L84","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",51]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L81-L82-(L83*0.5)","v":49}]

{"sheet":"ST0875","index":13,"n_rows":111,"n_cols":18,"rows_kept":111,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Small vessel chief engineer (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Understand the reason for determining voyage needs; fuel, lubricants, water, stores, expendables. [MCA]",null,null,null,null,null,null,{"$f":"IF(C22:C71 = \"FULLY MET\",1,IF(C22:C71 = \"PARTIALLY MET\",0.5,IF(C22:C71 = \"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 necessity for routine maintenance and the reasons for maintaining records of machinery and its performance. [MCA]",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","Understand the consequences of sailing with certain items of machinery inoperative and the risks involved in doing so. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Understand the (Chief Engineer’s) responsibilities and duties concerning bunkering or refuelling operations. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The methods of dealing with fire on board ship. Prevention of the spread of fire. The organisation and direction of fire-fighting and lifesaving parties. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Care and management of steering systems and bow thrusters. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Care and management of pumping systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Care and management of oily water separator equipment. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","(a) Construction, maintenance and operation of fire-fighting equipment, (b) Fire detection and prevention. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","(a) Codes of safe working practices, risk assessment, permit to work (entry into enclosed space, hot work, electrical work), (b) The dangers of entering enclosed spaces. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Routine operational duties and the effect of legislation on engine room operations. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Working principles and constructional details of marine engines, gears, clutches and ancillary equipment. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Fuel oil, lubrication oil, and cooling systems of marine engines together with ancillary systems including filters, pumps, heat exchangers and controls. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","(a) Methods of manoeuvring, including bridge control systems, variable pitch propellers and bow thrusters, (b) Emergency controls. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Working principles and constructional details of air compressors, air receivers and associated equipment. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Operational testing and fault rectification of basic control systems and alarm panels. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Safe and efficient operation and maintenance of marine engines and propulsion systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Knowledge of the International Convention for the Prevention of Pollution from Ships (MARPOL) Annexes and implementations. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Principles of stability, water tight and watertight integrity, free surface effect and reserve buoyancy. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Basic understanding of International Safety Management (ISM). [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Principles and constructional details of sensing, monitoring and measuring devices associated with marine equipment. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Principles involved with the operation, testing and maintenance of propulsive transmission systems, including thrust and shaft bearings, stern tubes and propellers. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Principles involved with the operation, testing and maintenance of bilge and ballast pumps, pumping and priming systems including pollution prevention equipment and systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Principles involved with the operation, testing and maintenance of steering and stabilizing systems including bow thrusters. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Principles involved with operation, testing and maintenance of control and alarm systems associated with automatic operation of marine steam plant. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Principles involved with the operation, testing and maintenance of: a. marine diesel engines (medium and high speed); gearing systems and clutches; b. starting and reversing systems; c. cooling and lubrication systems; d. fuel oil preparation systems; e. air compressors, receivers and associated equipment; f. auxiliary diesel engines and associated equipment; g. control and alarm systems associated with automatic operation of a diesel plant. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Methods of assessment of power output and diesel plant efficiency and action to be taken to maintain safe and efficient operation of plant. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Methods of testing fuel oil, lubrication oil and cooling water and action to be taken to maintain safe conditions. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Types of information issued by the MCA with respect to safety at sea. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Responsibilities of a chief engineer officer with regard to the control and prevention of fire: a. precautions against fire or explosions, explosive mixtures and sources of ignition; b. principles and methods of fire prevention, detection and extinction in all areas of a ship; c. principles of the operation, testing and maintenance of fire detection and extinguishing systems; d. principles of the operation, testing and maintenance of fire pumps and associated pumping systems; e. control and organization of fire and damage control parties. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Knowledge and understanding of applications and maintenance of ISM codes and system. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Organisation and control procedures necessary for the safe and efficient operation in the Unmanned Maritime Systems (UMS) mode. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Principles of the operation, testing and maintenance of: a. alternators, generators, motors, switch gear and batteries; b. ac and dc distribution systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Fault finding and rectification of faults in electrical systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","Administration duties of a chief engineer associated with: a. organisation and training of staff for normal and emergency duties; b. organisation of temporary and permanent repairs and surveys – Company approval and Classification society. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Ensuring ship is in seaworthy condition prior to sailing taking into account nature of voyage. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Dry docking, hull surveys and repairs. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","The introduction of increased automation, artificial intelligence, and emerging technologies in the maritime sector.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","Project management techniques: setting objectives, planning and monitoring.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","Commercial awareness; costing and budgeting principles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","Resource management considerations: cost, quality, safety, security, and environmental impact.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","Problem solving tools and techniques: root cause analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K43","Marine industry terminology.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K44","Communication techniques: verbal and written.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K45","Report writing techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K46","Documentation requirements and importance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K47","Information technology: word processing, spreadsheets, e-mail, and presentation. IT applications for technical reporting.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K48","Sustainability: current practices and developments in the sector.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K49","Ethical practices.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K50","Equality, diversity, and inclusion awareness.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Take personal emergency action onboard a vessel. [MCA]",null,null,null,null,null,null,{"$f":"IF(C73:C93 = \"FULLY MET\",1,IF(C73:C93 = \"PARTIALLY MET\",0.5,IF(C73:C93 = \"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"}]
["S2","Respond to emergencies onboard a vessel. [MCA]",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J74=1,1,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=1,\"NONE\",IF(L74=0.5,\"PARTIAL\",IF(L74=0,\"FULL\")))","v":"FULL"}]
["S3","Take control of survival craft and rescue boats. [MCA]",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J75=1,0.5,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},{"$f":"IF(L75=0.5,\"NONE\",IF(L75=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S4","Take charge of an engine room watch. [MCA]",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J76=1,0.5,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},"PARTIAL"]
["S5","Prepare and operate vessel propulsion machinery and ancillary systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J77=1,1,IF(J77=0.5,0.5,IF(J77=0,0)))","v":0},{"$f":"IF(L77=1,\"NONE\",IF(L77=0.5,\"PARTIAL\",IF(L77=0,\"FULL\")))","v":"FULL"}]
["S6","Operate vessel ancillaries and service machinery. [MCA]",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J78=1,1,IF(J78=0.5,0.5,IF(J78=0,0)))","v":0},{"$f":"IF(L78=1,\"NONE\",IF(L78=0.5,\"PARTIAL\",IF(L78=0,\"FULL\")))","v":"FULL"}]
["S7","Operate and adjust vessel electrical systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Carry out maintenance to vessel electrical machinery and systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Carry out maintenance to vessel mechanical machinery and systems. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Maintain personal health, safety and environmental standards onboard a vessel. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Maintain safe, legal and effective working practices onboard a vessel. [MCA]",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Maintain and enhance productive working relationships onboard a vessel. [MCA]",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J84=1,0.5,IF(J84=0.5,0.5,IF(J84=0,0)))","v":0},{"$f":"IF(L84=0.5,\"NONE\",IF(L84=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S13","Identify costs and create a draft budget for sign-off.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Apply project management techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Identify, organise, and use resources to complete tasks.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Diagnose problems. Resolve or escalate problems in line with responsibilities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Review work to identify improvements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Communicate verbally and in writing with others for example, colleagues and contractors onboard or ashore.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Complete documentation for example, machinery space logbook and oil record book.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J91=1,1,IF(J91=0.5,0.5,IF(J91=0,0)))","v":0},{"$f":"IF(L91=1,\"NONE\",IF(L91=0.5,\"PARTIAL\",IF(L91=0,\"FULL\")))","v":"FULL"}]
["S20","Write technical reports.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J92=1,1,IF(J92=0.5,0.5,IF(J92=0,0)))","v":0},{"$f":"IF(L92=1,\"NONE\",IF(L92=0.5,\"PARTIAL\",IF(L92=0,\"FULL\")))","v":"FULL"}]
["S21","Use information technology for example, word processing, spreadsheets, email, and presentation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Promote and adopt a safety culture.",null,null,null,null,null,null,{"$f":"IF(C95:C100 = \"FULLY MET\",1,IF(C95:C100 = \"PARTIALLY MET\",0.5,IF(C95:C100 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J95=1,1,IF(J95=0.5,0.5,IF(J95=0,0)))","v":0},{"$f":"IF(L95=1,\"NONE\",IF(L95=0.5,\"PARTIAL\",IF(L95=0,\"FULL\")))","v":"FULL"}]
["B2","Committed to protecting the marine environment from pollution.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J96=1,1,IF(J96=0.5,0.5,IF(J96=0,0)))","v":0},"FULL"]
["B3","Take personal responsibility for their actions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Committed to quality and continuous improvement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Role-model equality and diversity expectations and requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Actively pursue professional development to maintain and enhance their competence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,null,null,null,null,null,null,null,null,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J101)","v":0},"Net Score",{"$f":"SUM(L22:L101)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J104/L108","v":0},"total CoE KSB coverage",{"$f":"L104/L111","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",77]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L108-L109-(L110*0.5)","v":75}]

{"sheet":"ST0999","index":14,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Lead engineering maintenance technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Awareness of health and safety regulations, relevance to the occupation and the technician's responsibilities. Health and safety regulations.",null,null,null,null,null,null,{"$f":"IF(C22:C46 = \"FULLY MET\",1,IF(C22:C46 = \"PARTIALLY MET\",0.5,IF(C22:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Risk identification, risk assessments, mitigations and safe systems of work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Awareness of environment and sustainability regulations, relevance to the occupation and the technician’s responsibilities. Environment and sustainability. Environmental Protection Act - responsibilities. Types of pollution and control measures: noise, smells, spills, and waste. Sustainability. Resource Management. Environmental permits. Waste management. Waste Electrical and Electronic Equipment Directive (WEEE). Hazardous waste regulations. Re-cyclable materials and waste disposal procedures. Energy consumption and usage profiling. Data logging to optimise energy performance. The Climate Change Agreements. Carbon Reduction Commitment (CRC).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Engineering mathematical and scientific principles: methods, techniques, graphical expressions, symbols, formulae and calculations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Engineering materials: characteristics, properties and impact on use.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Problem solving techniques: diagnostics, root cause analysis, 6 thinking hats, DMAIC (Define, Measure, Analyse, Improve, Control), PDCA (Plan Do Check Act). Fault finding techniques: root cause analysis, 5 Whys’, fishbone, half-split.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Maintenance and engineering strategies, practices and techniques: planned, preventative, predictive and reactive.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Standard operating procedures and work instructions: rationale, review and updates.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Engineering, manufacturing and maintenance technical information, related documentation, such as job records, service reports, checklists and condemn notices; representations, drawings, graphical information, visuals and symbols.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Manufacturers’ instructions: what they are and how to use them. Warranties: what they are and impact on engineering maintenance work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Awareness of engineering international, national and regulatory standards, relevance to the occupation and technician’s responsibilities. British Standards (BS). International Organisation for Standardisation standards (ISO). European Norm (EN).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The function of an engineering maintenance department. Limits of autonomy and reporting channels. Different teams and functions involved in operation and interdependencies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Leadership and management techniques: customer relationship management, negotiating, influencing, networking, commercial awareness, conflict management and assertiveness.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Workplace training and development and competence assurance techniques in the workplace. How to pass on knowledge to colleagues and provide guidance to customers or stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Planning, prioritising, work scheduling, workflow and time management techniques. Work management systems. Work categorisation systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Verbal communication techniques: Matching style to audience. Barriers in communication and how to overcome them. Engineering terminology.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Communication techniques: written. Writing using plain English principles. Report writing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The engineering maintenance sector. Regulators. Types of employers. Clients. Supply chain. Stakeholders. Audits.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Resources: Human, physical, space, documentation, tooling, specialist equipment, spares and materials: Stock and services considerations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Awareness of Quality Management Systems (QMS) and the principles of Quality Control and Assurance, principles and practice in a maintenance and engineering environment. Relevance to the occupation and the technician’s responsibilities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Continuous improvement techniques: lean, 6-sigma, KAIZEN, 5 S (Sort, set, shine, standardise and sustain).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Project management techniques: Strengths, Weaknesses, Opportunities, Threats (SWOT), stakeholder matrices, risk mapping and summary risk profiles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Information technology: Management Information Systems (MIS), spreadsheets, presentation, word processing, email, virtual communication and learning platforms. General Data Protection Regulation (GDPR). Documentation and data collection: principles, methods and requirements - electronic and paper. Analytical data, job records, timekeeping, service reports, checklists and condemn notices. Technological development and innovation in the engineering sector. Industry 4.0. IT networking and digital twinning.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Business operation considerations: efficiency, customer satisfaction, competitiveness, minimising risks to operation, finance, business ethics and licenses.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Equality, diversity and inclusion in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Comply with health and safety regulations and procedures. Apply safe systems of work.",null,null,null,null,null,null,{"$f":"IF(C48:C69 = \"FULLY MET\",1,IF(C48:C69 = \"PARTIALLY MET\",0.5,IF(C48:C69 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["S2","Comply with environmental and sustainability regulations and procedures when using resources. Segregate resources for re-use, recycling and disposal applying sustainability principles.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J49=1,1,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=1,\"NONE\",IF(L49=0.5,\"PARTIAL\",IF(L49=0,\"FULL\")))","v":"FULL"}]
["S3","Follow manufacturers’ instructions and standard maintenance procedures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Identify and document risks and hazards in the workplace. Advise on and apply control measures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Record or enter information - paper based or electronic. For example, job sheets, risk assessments, equipment service records, test results, handover documents and manufacturers' documentation, asset management records, work sheets, checklists, waste environmental records and any legal reporting requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Plan and schedule tasks, projects or resources in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Manage tasks, projects or resources in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Evaluate tasks, projects or resources in the workplace",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Communicate with colleagues and stakeholders verbally.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Communicate in writing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Negotiate with colleagues or stakeholders. For example, to access equipment or arrange system outage.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Identify potential conflicts and apply resolution strategies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Identify training needs of team members in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Provide technical leadership for maintenance practices and techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Provide technical leadership for repair practices and techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Provide technical leadership for fault finding techniques and practices.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Identify problems and apply methods to identify causes and solutions. Escalate issues or concerns.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Comply with engineering standards and regulations. For example, ISO9001.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Interpret and use information from engineering data sources to apply changes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Lead on continuous improvement projects. Apply continuous improvement techniques. Devise suggestions for improvement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Manage technical handover of completed repair or maintenance activity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Use information technology. For example, for document creation, communication, and information management in line with breakdown, repair and maintenance activities. Comply with GDPR.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Prioritise and promote the environment and sustainability.",null,null,null,null,null,null,{"$f":"IF(C71:C78 = \"FULLY MET\",1,IF(C71:C78 = \"PARTIALLY MET\",0.5,IF(C71:C78 = \"NOT MET\",0,)))","v":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"}]
["B2","Prioritise and promote health and safety.",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"}]
["B3","Apply a professional approach.",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"}]
["B4","Promote adoption of emerging and advanced engineering and maintenance technologies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Committed to professional development of self and others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Take responsibility for work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Act ethically.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Collaborate within teams, across disciplines and external stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J78)","v":0},"Net Score",{"$f":"SUM(L22:L78)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J81/L85","v":0},"total CoE KSB coverage",{"$f":"L81/L88","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",55]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L85-L86-(L87*0.5)","v":55}]

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