{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["GUIDE TO KSB MAPPING","ST0406","ST0580","ST0624","ST0695","ST0841","ST0847","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"GUIDE TO KSB MAPPING","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,2,3],[9,0,9,3],[10,0,10,3],[5,0,5,3],[3,0,3,3],[4,0,4,3],[6,0,6,3],[7,0,7,3],[8,0,8,3]]}
["GUIDE TO KSB MAPPING  "]
["Applicants must show how their qualification will enable a person to demonstrate that they have attained as many of the knowledge, skills and behaviours set out in the standard as may be reasonably expected by undertaking a course of education. "]
[]
["1. You can map your qualification to one or more occupational standards. "]
["2. Select the occupational standard(s) you wish to map to your qualification from the tabs in this spreadsheet. You may delete sheets/tabs that are not relevant to your qualification. "]
["3. Please fill in the following details in cells B1-7 on your selected tab: Awarding Body/Applicant, Qualification name, Programme title if applicable."]
["4. Please respond to each KSB statement."]
["5. Populate columns C-G as shown in the example at the top of each standard tab. "]
["6. Please be as specific as possible about which content in the qualification aligns to each KSB statement. "]
["7. Submit the completed spreadsheet along with 'Qualification structure' spreadsheet and any documents you have cited in the 'EVIDENCE UPLOAD' part of the application form. Where we have capacity we are happy to feedback on early drafts of your KSB mapping."]
["8. Please contact HTQ.approvals@education.gov.uk if you need further help or guidance on mapping."]

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

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

{"sheet":"ST0624","index":3,"n_rows":121,"n_cols":20,"rows_kept":121,"cut":false,"hidden":false,"merged":[[111,10,111,14],[9,0,9,8],[9,10,9,17],[10,10,12,17],[23,2,23,3],[87,10,87,14],[99,10,99,14],[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",null,null,null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["KSB","KSB Statement ","Included in:",null,"KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Knowledge","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 (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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","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",{"$f":"IF(L57=1,1,IF(L57=0.5,0.5,IF(L57=0,0)))","v":0},{"$f":"IF(N57=1,\"NONE\",IF(N57=0.5,\"PARTIAL\",IF(N57=0,\"FULL\")))","v":"FULL"}]
["S3","Plan, for example labour and engineering materials","Yes","Yes",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L58=1,1,IF(L58=0.5,0.5,IF(L58=0,0)))","v":0},{"$f":"IF(N58=1,\"NONE\",IF(N58=0.5,\"PARTIAL\",IF(N58=0,\"FULL\")))","v":"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},{"$f":"IF(N60=0.5,\"NONE\",IF(N60=0,\"PARTIAL\"))","v":"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",{"$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"}]
["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",{"$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"}]
["S9","Analyse operational performance, specification and data","Yes","Yes",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L64=1,1,IF(L64=0.5,0.5,IF(L64=0,0)))","v":0},{"$f":"IF(N64=1,\"NONE\",IF(N64=0.5,\"PARTIAL\",IF(N64=0,\"FULL\")))","v":"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",{"$f":"IF(L65=1,1,IF(L65=0.5,0.5,IF(L65=0,0)))","v":0},{"$f":"IF(N65=1,\"NONE\",IF(N65=0.5,\"PARTIAL\",IF(N65=0,\"FULL\")))","v":"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},{"$f":"IF(N67=0.5,\"NONE\",IF(N67=0,\"PARTIAL\"))","v":"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",0,"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)+SUM(L56:L71)+SUM(L78:L85)","v":0},"Net Score",{"$f":"SUM(N26:N47)+SUM(N56:N71)+SUM(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,"partialy 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)+SUM(L48:L54)+SUM(L56:L66)+SUM(L72:L76)+SUM(L78:L85)","v":0},"Net Score",{"$f":"SUM(N26:N43)+SUM(N48:N54)+SUM(N56:N66)+SUM(N72:N76)+SUM(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,"partialy 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,"partialy 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":"ST0695","index":4,"n_rows":82,"n_cols":18,"rows_kept":82,"cut":false,"hidden":false,"merged":[[9,0,9,6],[9,8,9,15],[10,8,11,15]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING",null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Process leader (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Principles of production/manufacturing techniques including: material handling systems, maintenance, production planning/scheduling, ergonomics, work place study, plant organisation, decommissioning, Statistical Process Control, process types such as flow and batch, product/raw material principles",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","How to identify and procure sufficient, suitable resources (e.g. finance, staff, equipment, supplies) including use of management tools such as the Internet of Things (IoT) and Industry 4.0",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Budgeting, forecasting and control of direct and indirect costs, fixed and variable costs including actual, accrued and committed costs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Lean operational and quality improvement practices such as workplace organisation, visual management, waste reduction and shop floor problem solving",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Delivery of quality management and assurance systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Problem definition: Cost of Poor Quality, problem analysis models such as Is/Is Not",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Production procedures and regulations to meet legislative/organisational requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Planning and project management principles, problem solving, relationship building and leading through KPIs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Employment law, employee rights and responsibilities, organisation staff management policies/procedures for e.g. recruitment, performance, development, discipline, grievance, equality/diversity, industrial relations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Theories of performance management and their use and organisations tools and policies for managing teams",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The theory of managing, motivating and developing people",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The purpose of organisational vision and goals and how these apply to teams",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Awareness of the differing strengths team members have and how these can be effectively applied in the workplace",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Approaches to colleague, stakeholder/ supplier relationship management including collaboration, negotiation, influencing, managing conflict, and networking",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How to communicate and cascade information effectively at all levels and to a diverse audience",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How to identify the information required for decision making, how it should be gathered and reported",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","How to develop and present a case to management when requesting change including single page reporting",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Undertake and direct production activities and operations",null,null,null,null,null,null,{"$f":"IF(C41:C65 = \"FULLY MET\",1,IF(C41:C65 = \"PARTIALLY MET\",0.5,IF(C41:C65 = \"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","Propose, undertake, manage and coordinate changes to the product, production operations, processes and equipment, to improve productivity, efficiency and quality",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J42=1,0.5,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=0.5,\"NONE\",IF(L42=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S3","Solve problems - predict and prevent failures through the analysis of data and information",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","Manage resources effectively to ensure their availability and the efficient running of department in line with organisational procedures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Deliver cost achievements against budget targets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Plan resources to support variations in production schedules",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Use KPIs as the basis of the continuous improvement cycle for quality, cost and volume achievement using lean operational and product improvement techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Undertake and manage quality resolutions as well as volume problem resolution",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Manage health, safety and the environment within area of responsibility, ensuring staff are compliant with all requirements and driving improvements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Conduct workplace risk assessments, manage near-miss or similar processes, conduct investigations as necessary",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Use project management tools to plan, organise and manage resources, to monitor progress, identify risks and mitigation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Recruit the right people into the right job",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J52=1,0,IF(J52=0.5,0,IF(J52=0,0)))","v":0},{"$f":"IF(L52=0,\"NONE\")","v":"NONE"}]
["S13","Develop, build and motivate teams by identifying strengths and enabling training and development within the workplace",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J53=1,0.5,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=0.5,\"NONE\",IF(L53=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S14","Recognise excellence, effectively manage performance, discipline, attendance, grievance",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S15","Manage industrial relations and equality and diversity",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S16","Support development through coaching and mentoring",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S17","Leading and communicating the management of change",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S18","Provide clear direction and leadership, giving open and honest feedback. Apply and adapt own leadership style to different production situations and people",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S19","Delegate and enable delivery though others",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S20","Build and maintain strong relationships across different disciplines. Negotiate and influence. Manages conflict",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"}]
["S21","Identify and share good practice, work collaboratively",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Utilise specialist advice and support to deliver plans",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Chair meetings and present (formally and informally) using a range of media. Listen actively, challenge, give feedback",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Analyse data/information to compellingly and succinctly present information to drive management decisions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Decision Making: Makes decisions based on personal initiative, technical knowledge, analysis and understanding of the different interests of stakeholders. Accepts responsibility for decisions and recognises limit to own authority",null,null,null,null,null,null,{"$f":"IF(C67:C72 = \"FULLY MET\",1,IF(C67:C72 = \"PARTIALLY MET\",0.5,IF(C67:C72 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J67=1,1,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=1,\"NONE\",IF(L67=0.5,\"PARTIAL\",IF(L67=0,\"FULL\")))","v":"FULL"}]
["B2","Agile: Flexible and adaptable to the needs of the organisation. Is creative, innovative and enterprising when seeking solutions to business needs. Positive and open to new ways of working, responds well to feedback and change",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Inclusive: Open, approachable, authentic, and able to build trust with others. Promotes a respectful culture embracing diversity and inclusion. Seeks and provides feedback to manage continuous development of self, team and processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Responsibility, Accountability and Resilience: Drive to achieve in all aspects of work. Demonstrates resilience and accountability. Determination when managing difficult situations. Seeks new opportunities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Professionalism: Sets an example, and is fair, consistent and impartial. Open and honest. Operates within organisational values. Promote and instil the values of the organisation to all colleagues",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Problem solver: Identifies issues quickly, enjoys solving complex problems and applies appropriate solutions. Has a strong desire to push to ensure the root cause of any problem is found and solutions identified which prevent recurrence",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J72)","v":0},"Net Score",{"$f":"SUM(L22:L72)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J75/L79","v":0},"total CoE KSB coverage",{"$f":"L75/L82","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",1]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",8]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L79-L80-(L81*0.5)","v":44}]

{"sheet":"ST0841","index":5,"n_rows":73,"n_cols":18,"rows_kept":73,"cut":false,"hidden":false,"merged":[[9,0,9,6],[9,8,9,15],[10,8,11,15]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING",null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Engineering Manufacturing Technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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",{"$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"}]
["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,"partialy 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":6,"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],[9,10,9,17],[10,10,12,17],[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",null,null,null,null,null,null,null,null,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["KSB","KSB Statement ","Included in:",null,"KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Knowledge","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 (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 - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge","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,"PARTIAL",{"$f":"IF(L62=1,0.5,IF(L62=0.5,0.5,IF(L62=0,0)))","v":0},{"$f":"IF(N62=0.5,\"NONE\",IF(N62=0,\"PARTIAL\"))","v":"PARTIAL"}]
["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",{"$f":"IF(L64=1,1,IF(L64=0.5,0.5,IF(L64=0,0)))","v":0},{"$f":"IF(N64=1,\"NONE\",IF(N64=0.5,\"PARTIAL\",IF(N64=0,\"FULL\")))","v":"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",{"$f":"IF(L65=1,1,IF(L65=0.5,0.5,IF(L65=0,0)))","v":0},{"$f":"IF(N65=1,\"NONE\",IF(N65=0.5,\"PARTIAL\",IF(N65=0,\"FULL\")))","v":"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:E80 = \"FULLY MET\",1,IF(E67:E80 = \"PARTIALLY MET\",0.5,IF(E67:E80 = \"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,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)+SUM(L39:L42)+SUM(L44:L45)+SUM(L48:L58)+SUM(L60:L65)+SUM(L67:L80)","v":0},"Net Score",{"$f":"SUM(N26:N37)+SUM(N39:N42)+SUM(N44:N45)+SUM(N48:N58)+SUM(N60:N65)+SUM(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,"partialy mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N89-N90-(N91*0.5)","v":47}]
[]
[]
[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)+SUM(L38:L43)+L46+SUM(L48:L59)+SUM(L61:L65)+SUM(L67:L80)","v":0},"Net Score",{"$f":"SUM(N26:N36)+SUM(N38:N43)+N46+SUM(N48:N59)+SUM(N61:N65)+SUM(N67:N80)","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,"partialy mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N101-N102-(N103*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: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,"partialy mitigated",2]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N113-N114-(N115*0.5)","v":51}]

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