{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["GUIDE TO KSB MAPPING","ST0116","ST0117","ST0118","ST0127","ST0129","ST0345","ST0825","ST0863","ST1021","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"ST0116","index":1,"n_rows":72,"n_cols":18,"rows_kept":72,"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,"Software Developer (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","All stages of the software development life-cycle (what each stage contains, including the inputs and outputs)",null,null,null,null,null,null,{"$f":"IF(C22:C33 = \"FULLY MET\",1,IF(C22:C33 = \"PARTIALLY MET\",0.5,IF(C22:C33 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Roles and responsibilities within the software development lifecycle (who is responsible for what)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The roles and responsibilities of the project life-cycle within your organisation, and your role",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","How best to communicate using the different communication methods and how to adapt appropriately to different audiences",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The similarities and differences between different software development methodologies, such as agile and waterfall.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","How teams work effectively to produce software and how to contribute appropriately",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Software design approaches and patterns, to identify reusable solutions to commonly occurring problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Organisational policies and procedures relating to the tasks being undertaken, and when to follow them. For example the storage and treatment of GDPR sensitive data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Algorithms, logic and data structures relevant to software development for example:- arrays- stacks- queues- linked lists- trees- graphs- hash tables- sorting algorithms- searching algorithms- critical sections and race conditions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Principles and uses of relational and non-relational databases",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Software designs and functional or technical specifications",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Software testing frameworks and methodologies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Create logical and maintainable code",null,null,null,null,null,null,{"$f":"IF(C35:C51 = \"FULLY MET\",1,IF(C35:C51 = \"PARTIALLY MET\",0.5,IF(C35:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J35=1,1,IF(J35=0.5,0.5,IF(J35=0,0)))","v":0},{"$f":"IF(L35=1,\"NONE\",IF(L35=0.5,\"PARTIAL\",IF(L35=0,\"FULL\")))","v":"FULL"}]
["S2","Develop effective user interfaces",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Link code to data sets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Test code and analyse results to correct errors found using unit testing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Conduct a range of test types, such as Integration, System, User Acceptance, Non-Functional, Performance and Security testing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Identify and create test scenarios",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Apply structured techniques to problem solving, debug code and understand the structure of programmes in order to identify and resolve issues",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Create simple software designs to effectively communicate understanding of the program",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Create analysis artefacts, such as use cases and/or user stories",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Build, manage and deploy code into the relevant environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Apply an appropriate software development approach according to the relevant paradigm (for example object oriented, event driven or procedural)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Follow software designs and functional or technical specifications",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Follow testing frameworks and methodologies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Follow company, team or client approaches to continuous integration, version and source control",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J48=1,0.5,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=0.5,\"NONE\",IF(L48=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Communicate software solutions and ideas to technical and non-technical stakeholders",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J49=1,1,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=1,\"NONE\",IF(L49=0.5,\"PARTIAL\",IF(L49=0,\"FULL\")))","v":"FULL"}]
["S16","Apply algorithms, logic and data structures",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"}]
["S17","Interpret and implement a given design whist remaining compliant with security and maintainability requirements",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Works independently and takes responsibility. For example, has a disciplined and responsible approach to risk and stays motivated and committed when facing challenges",null,null,null,null,null,null,{"$f":"IF(C53:C62 = \"FULLY MET\",1,IF(C53:C62 = \"PARTIALLY MET\",0.5,IF(C53:C62 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J53=1,1,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=1,\"NONE\",IF(L53=0.5,\"PARTIAL\",IF(L53=0,\"FULL\")))","v":"FULL"}]
["B2","Applies logical thinking. For example, uses clear and valid reasoning when making decisions related to undertaking work instructions",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=1,\"NONE\",IF(L54=0.5,\"PARTIAL\",IF(L54=0,\"FULL\")))","v":"FULL"}]
["B3","Maintains a productive, professional and secure working environment",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J55=1,0.5,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=0.5,\"NONE\",IF(L55=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B4","Works collaboratively with a wide range of people in different roles, internally and externally, with a positive attitude to inclusion & diversity",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J56=1,0.5,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=0.5,\"NONE\",IF(L56=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Acts with integrity with respect to ethical, legal and regulatory ensuring the protection of personal data, safety and security.",null,null,null,null,null,null,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"}]
["B6","Shows initiative and takes responsibility for solving problems within their own remit, being resourceful when faced with a problem to solve.",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"}]
["B7","Communicates effectively in a variety of situations to both a technical and non-technical audience.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J59=1,1,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=1,\"NONE\",IF(L59=0.5,\"PARTIAL\",IF(L59=0,\"FULL\")))","v":"FULL"}]
["B8","Shows curiosity to the business context in which the solution will be used, displaying an inquisitive approach to solving the problem. This includes the curiosity to explore new opportunities, techniques and the tenacity to improve methods and maximise performance of the solution and creativity in their approach to solutions.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J60=1,0.5,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=0.5,\"NONE\",IF(L60=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B9","Demonstrates creativity and tenacity in their approach to solutions and the methods used to come to a solution for example, sees the task through to the end by devising new solutions and despite obstacles and problems along the way.",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"}]
["B10","Committed to continued professional development.",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"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J62)","v":0},"Net Score",{"$f":"SUM(L22:L62)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J65/L69","v":0},"total CoE KSB coverage",{"$f":"L65/L72","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",39]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",6]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L69-L70-(L71*0.5)","v":36}]

{"sheet":"ST0117","index":2,"n_rows":104,"n_cols":18,"rows_kept":104,"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,"Business Analyst (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 definition of Business Analysis and the range of activities that constitute it",null,null,null,null,null,null,{"$f":"IF(C22:C49 = \"FULLY MET\",1,IF(C22:C49 = \"PARTIALLY MET\",0.5,IF(C22:C49 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The value of Business Analysis in enabling business improvement and delivering IT system changes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The role of the Business Analyst, and its relationship with other roles on a business change initiative, including those with system development responsibility",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Business change and system development life cycles, including the use of appropriate methodologies and the impact of organisational culture and context",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The principles, features and differences of waterfall and agile methodologies for project delivery and software development",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The importance of effective communication and engagement with a range of stakeholders in relation to Business Analysis assignments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The purpose and value of quality assurance techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Approaches to conducting internal and external environmental analysis of an industry domain",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The advantages and disadvantages of a range of investigative techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The purpose of process modelling and the importance of an organisational view of business processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Different approaches to document business processes including when it is most appropriate to use each",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Techniques to elicit requirements, including when it is most appropriate to use each",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The importance of eliciting requirements rather than gathering solution descriptions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Approaches to categorise, validate and prioritise requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The importance of requirements management including change control",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","A broad range of non-functional requirement areas and the importance of including these within requirements engineering",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The importance of considering user experience, accessibility and usability requirements in the design of digital solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The value of data to an organisation, and how data needs are considered in business improvement",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The purpose and activities of the gap analysis process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The role of the business analyst in facilitating business acceptance of changes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","The different phases of testing of business and system changes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The importance and the principles of engaging internal and external stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Techniques to support the identification and analysis of internal and external stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","The purpose and importance of business change impact assessment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","The concepts of benefits realisation and management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Legislation and industry standards relevant to the organisation and sector",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Data protection regulations and the importance of managing information and data in linewith legislation and organisational policies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Technology and industry trends across the digital sector, and the opportunities thesebring for business improvement and IT solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply appropriate approaches to scope, plan and perform Business Analysis",null,null,null,null,null,null,{"$f":"IF(C51:C80 = \"FULLY MET\",1,IF(C51:C80 = \"PARTIALLY MET\",0.5,IF(C51:C80 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
["S2","Communicate effectively in a variety of situations with a range of stakeholders",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J52=1,0.5,IF(J52=0.5,0.5,IF(J52=0,0)))","v":0},{"$f":"IF(L52=0.5,\"NONE\",IF(L52=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S3","Apply a range of structured investigation techniques to a business situation",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J53=1,1,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=1,\"NONE\",IF(L53=0.5,\"PARTIAL\",IF(L53=0,\"FULL\")))","v":"FULL"}]
["S4","Produce an outline definition of a business situation using an appropriate technique",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Apply appropriate techniques to identify problems and opportunities within a business situation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Support the identification and presentation of proposed actions to stakeholders in order to gain agreement for further analysis activity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Apply appropriate techniques to analyse and document options and recommendations for change",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Elicit process information from stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Model business processes using relevant techniques, standards, notation and software tools",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Analyse business process models to identify opportunities for improvement",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Produce models of redesigned business processes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Elicit requirements from stakeholders to identify business and user needs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Document clear functional and non-functional requirements in line with local standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Analyse documented requirements to remove duplication, conflict and overlap",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Prioritise requirements using an appropriate prioritisation approach",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Validate requirements with stakeholders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Support the establishment of requirements traceability",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Elicit business data needs from relevant sources",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Support the development of simple data models using relevant techniques, standards, notation and software tools",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Document current business situations to enable gap analysis and decision making",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Support the development of models of future state business situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Identify key differences between current and future business situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Identify actions required to move from the current to future business situation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Define acceptance criteria for business and system changes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Support business acceptance of business and system changes",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J75=1,0.5,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},{"$f":"IF(L75=0.5,\"NONE\",IF(L75=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S26","Apply relevant techniques to research and identify stakeholders",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},{"$f":"IF(L76=1,\"NONE\",IF(L76=0.5,\"PARTIAL\",IF(L76=0,\"FULL\")))","v":"FULL"}]
["S27","Analyse and document stakeholders' areas of interest and influence",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J77=1,1,IF(J77=0.5,0.5,IF(J77=0,0)))","v":0},{"$f":"IF(L77=1,\"NONE\",IF(L77=0.5,\"PARTIAL\",IF(L77=0,\"FULL\")))","v":"FULL"}]
["S28","Support the development of cost/benefit analysis for proposed business changes",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J78=1,1,IF(J78=0.5,0.5,IF(J78=0,0)))","v":0},{"$f":"IF(L78=1,\"NONE\",IF(L78=0.5,\"PARTIAL\",IF(L78=0,\"FULL\")))","v":"FULL"}]
["S29","Evaluate and document the key impacts on people, process, organisation, technology and information",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J79=1,1,IF(J79=0.5,0.5,IF(J79=0,0)))","v":0},{"$f":"IF(L79=1,\"NONE\",IF(L79=0.5,\"PARTIAL\",IF(L79=0,\"FULL\")))","v":"FULL"}]
["S30","Present information in a manner appropriate to the audience",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J80=1,1,IF(J80=0.5,0.5,IF(J80=0,0)))","v":0},{"$f":"IF(L80=1,\"NONE\",IF(L80=0.5,\"PARTIAL\",IF(L80=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Act logically, analytically and objectively in a range of situations",null,null,null,null,null,null,{"$f":"IF(C82:C94 = \"FULLY MET\",1,IF(C82:C94 = \"PARTIALLY MET\",0.5,IF(C82:C94 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J82=1,1,IF(J82=0.5,0.5,IF(J82=0,0)))","v":0},{"$f":"IF(L82=1,\"NONE\",IF(L82=0.5,\"PARTIAL\",IF(L82=0,\"FULL\")))","v":"FULL"}]
["B2","Apply creative thinking when problem solving",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J83=1,1,IF(J83=0.5,0.5,IF(J83=0,0)))","v":0},{"$f":"IF(L83=1,\"NONE\",IF(L83=0.5,\"PARTIAL\",IF(L83=0,\"FULL\")))","v":"FULL"}]
["B3","Work independently and collaboratively",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J84=1,1,IF(J84=0.5,0.5,IF(J84=0,0)))","v":0},{"$f":"IF(L84=1,\"NONE\",IF(L84=0.5,\"PARTIAL\",IF(L84=0,\"FULL\")))","v":"FULL"}]
["B4","Use own initiative and take responsibility appropriate to the role of Business Analyst",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J85=1,0.5,IF(J85=0.5,0.5,IF(J85=0,0)))","v":0},{"$f":"IF(L85=0.5,\"NONE\",IF(L85=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Take a thorough and organised approach and plan analysis activities in line with business priorities",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J86=1,0,IF(J86=0.5,0,IF(J86=0,0)))","v":0},{"$f":"IF(L86=0,\"NONE\")","v":"NONE"}]
["B6","Build and maintain positive working relationships with a range of people",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J87=1,1,IF(J87=0.5,0.5,IF(J87=0,0)))","v":0},{"$f":"IF(L87=1,\"NONE\",IF(L87=0.5,\"PARTIAL\",IF(L87=0,\"FULL\")))","v":"FULL"}]
["B7","Use a range of methods of communication appropriate to the situation",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J88=1,1,IF(J88=0.5,0.5,IF(J88=0,0)))","v":0},{"$f":"IF(L88=1,\"NONE\",IF(L88=0.5,\"PARTIAL\",IF(L88=0,\"FULL\")))","v":"FULL"}]
["B8","Maintain a productive, professional and secure working environment",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J89=1,0.5,IF(J89=0.5,0.5,IF(J89=0,0)))","v":0},{"$f":"IF(L89=0.5,\"NONE\",IF(L89=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B9","Aware of the wider business environment and own contribution to business objectives",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J90=1,0.5,IF(J90=0.5,0.5,IF(J90=0,0)))","v":0},{"$f":"IF(L90=0.5,\"NONE\",IF(L90=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B10","Be comfortable and confident interacting with people from technical and non-technical backgrounds",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J91=1,1,IF(J91=0.5,0.5,IF(J91=0,0)))","v":0},{"$f":"IF(L91=1,\"NONE\",IF(L91=0.5,\"PARTIAL\",IF(L91=0,\"FULL\")))","v":"FULL"}]
["B11","Tailor manner of presentation to be appropriate to the audience",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J92=1,1,IF(J92=0.5,0.5,IF(J92=0,0)))","v":0},{"$f":"IF(L92=1,\"NONE\",IF(L92=0.5,\"PARTIAL\",IF(L92=0,\"FULL\")))","v":"FULL"}]
["B12","Work flexibly and effectively as part of a multidisciplinary team throughout the full lifecycle",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J93=1,1,IF(J93=0.5,0.5,IF(J93=0,0)))","v":0},{"$f":"IF(L93=1,\"NONE\",IF(L93=0.5,\"PARTIAL\",IF(L93=0,\"FULL\")))","v":"FULL"}]
["B13","Demonstrate commitment to continuous professional development in relation to Business Analysis and the digital sector",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J94=1,0.5,IF(J94=0.5,0.5,IF(J94=0,0)))","v":0},{"$f":"IF(L94=0.5,\"NONE\",IF(L94=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J94)","v":0},"Net Score",{"$f":"SUM(L22:L94)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J97/L101","v":0},"total CoE KSB coverage",{"$f":"L97/L104","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",71]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",6]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L101-L102-(L103*0.5)","v":67}]

{"sheet":"ST0118","index":3,"n_rows":70,"n_cols":18,"rows_kept":70,"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,"Data Analyst (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","Current relevant legislation and its application to the safe use of data",null,null,null,null,null,null,{"$f":"IF(C22:C36 = \"FULLY MET\",1,IF(C22:C36 = \"PARTIALLY MET\",0.5,IF(C22:C36 = \"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","Organisational data and information security standards, policies and procedures relevant to data management activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Principles of the data life cycle and the steps involved in carrying out routine data analysis tasks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Principles of data, including open and public data, administrative data, and research data",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The differences between structured and unstructured data",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The fundamentals of data structures, database system design, implementation and maintenance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Principles of user experience and domain context for data analytics",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Quality risks inherent in data and how to mitigate or resolve these",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Principal approaches to defining customer requirements for data analysis",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Approaches to combining data from different sources",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Approaches to organisational tools and methods for data analysis",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Organisational data architecture",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Principles of statistics for analysing datasets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The principles of descriptive, predictive and prescriptive analytics",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The ethical aspects associated with the use and collation of data",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Use data systems securely to meet requirements and in line with organisational procedures and legislation including principles of Privacy by Design",null,null,null,null,null,null,{"$f":"IF(C38:C52 = \"FULLY MET\",1,IF(C38:C52 = \"PARTIALLY MET\",0.5,IF(C38:C52 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J38=1,0.5,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=0.5,\"NONE\",IF(L38=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Implement the stages of the data analysis lifecycle",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J39=1,1,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=1,\"NONE\",IF(L39=0.5,\"PARTIAL\",IF(L39=0,\"FULL\")))","v":"FULL"}]
["S3","Apply principles of data classification within data analysis activity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Analyse data sets taking account of different data structures and database designs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Assess the impact on user experience and domain context on data analysis activity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Identify and escalate quality risks in data analysis with suggested mitigation or resolutions as appropriate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Undertake customer requirements analysis and implement findings in data analytics planning and outputs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Identify data sources and the risks and challenges to combination within data analysis activity",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Apply organizational architecture requirements to data analysis activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Apply statistical methodologies to data analysis tasks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Apply predictive analytics in the collation and use of data",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Collaborate and communicate with a range of internal and external stakeholders using appropriate styles and behaviours to suit the audience",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Use a range of analytical techniques such as data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Collate and interpret qualitative and quantitative data and convert into infographics, reports, tables, dashboards and graphs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Select and apply the most appropriate data tools to achieve the optimum outcome",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Maintain a productive, professional and secure working environment",null,null,null,null,null,null,{"$f":"IF(C54:C60 = \"FULLY MET\",1,IF(C54:C60 = \"PARTIALLY MET\",0.5,IF(C54:C60 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=1,\"NONE\",IF(L54=0.5,\"PARTIAL\",IF(L54=0,\"FULL\")))","v":"FULL"}]
["B2","Show initiative, being resourceful when faced with a problem and taking responsibility for solving problems within their own remit",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Work independently and collaboratively",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Logical and analytical",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Identify issues quickly, investigating and solving complex problems and applying appropriate solutions. Ensures the true root cause of any problem is found and a solution is identified which prevents recurrence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Resilient - viewing obstacles as challenges and learning from failure.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Adaptable to changing contexts within the scope of a project, direction of the organisation or Data Analyst role.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J60=1,0.5,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=0.5,\"NONE\",IF(L60=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J60)","v":0},"Net Score",{"$f":"SUM(L22:L60)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J63/L67","v":0},"total CoE KSB coverage",{"$f":"L63/L70","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",37]
[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":"L67-L68-(L69*0.5)","v":36}]

{"sheet":"ST0127","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,"Network Engineer (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The causes and consequences of network and IT infrastructure failures",null,null,null,null,null,null,{"$f":"IF(C22:C42 = \"FULLY MET\",1,IF(C22:C42 = \"PARTIALLY MET\",0.5,IF(C22:C42 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The architecture of typical IT systems, including hardware, OS, server, virtualisation, voice, cloud and applications",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The techniques for systems performance and optimisation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Diagnostic techniques and tools to interrogate and gather information regarding systems performance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Organizational procedures to deal with recording information effectively and in line with protocols",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Service Level Agreements (SLAs) and their application to delivering network engineering activities in line with contractual obligations and customer service",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Their role in Business Continuity and Disaster Recovery",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The purposes and uses of ports and protocols",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Devices, applications, protocols and services at their appropriate OSI and, or, TCP or IP layers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The concepts and characteristics of routing and switching",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The characteristics of network topologies, types and technologies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Wireless technologies and configurations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Cloud concepts and their purposes",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Functions of network services",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The different types of network maintenance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How current legislation relates to or impacts occupation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Troubleshooting methodologies for network and IT infrastructure",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","How to integrate a server into a network",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The types of security threats to networks and IT infrastructure assets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How to use tools to automate network tasks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Approaches to change management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply the appropriate tools and techniques when securely operating and testing networks",null,null,null,null,null,null,{"$f":"IF(C44:C63 = \"FULLY MET\",1,IF(C44:C63 = \"PARTIALLY MET\",0.5,IF(C44:C63 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"}]
["S2","Install and configure the elements required to maintain and manage a secure network",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Implement techniques to monitor and record systems performance in line with defined specifications",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Maintain security and performance of the system against known and standard threats",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Apply the appropriate tools and techniques to identify systems performance issues",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Apply the appropriate tools and techniques to gather information to troubleshoot issues and isolate, repair or escalate faults",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Communicate outcomes of tasks and record in line with organisational procedures and SLAs including adherence to customer service standards",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J50=1,0.5,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=0.5,\"NONE\",IF(L50=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S8","Upgrade, apply and test components to systems configurations ensuring that the system meets the organisation’s requirements and minimises downtime. This should include backup processes",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J51=1,0.5,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=0.5,\"NONE\",IF(L51=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Record task details whether face-to-face, remote or in writing in line with ogranisational requirements",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J52=1,1,IF(J52=0.5,0.5,IF(J52=0,0)))","v":0},{"$f":"IF(L52=1,\"NONE\",IF(L52=0.5,\"PARTIAL\",IF(L52=0,\"FULL\")))","v":"FULL"}]
["S10","Interpret information received from a manager, customer or technical specialist and accurately implement the defined requirements",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J53=1,0.5,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=0.5,\"NONE\",IF(L53=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S11","Monitor, identify and implement required maintenance procedures",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=1,\"NONE\",IF(L54=0.5,\"PARTIAL\",IF(L54=0,\"FULL\")))","v":"FULL"}]
["S12","Implement techniques to optimise systems performance in line with defined specifications",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J55=1,1,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=1,\"NONE\",IF(L55=0.5,\"PARTIAL\",IF(L55=0,\"FULL\")))","v":"FULL"}]
["S13","Organise and prioritise clients or stakeholders’ requests in line with SLAs and organization processes",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J56=1,0.5,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=0.5,\"NONE\",IF(L56=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S14","Explain their job role within the business context to stakeholders to enable a clear understanding on both sides of what their remit is and convey technical constraints in appropriate language considering accessibility and diversity implications",null,null,null,null,null,null,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"}]
["S15","Operate securely and apply the appropriate process, policies and legislation within their business responsibilities",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J58=1,0.5,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=0.5,\"NONE\",IF(L58=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S16","Communicate with a range of stakeholders taking into consideration the organisations cultural awareness and technical ability",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"}]
["S17","Apply the appropriate level of responsibility when planning and prioritising work tasks",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J60=1,0,IF(J60=0.5,0,IF(J60=0,0)))","v":0},{"$f":"IF(L60=0,\"NONE\")","v":"NONE"}]
["S18","Apply the relevant numerical skills (Binary, dotted decimal notation) required to meet the defined specifications",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"}]
["S19","Ensure compliance of network engineering outputs with change management processes",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J62=1,1,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=1,\"NONE\",IF(L62=0.5,\"PARTIAL\",IF(L62=0,\"FULL\")))","v":"FULL"}]
["S20","Select the appropriate tools and comply with organisation policies and processes when upgrading systems",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J63=1,0.5,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},{"$f":"IF(L63=0.5,\"NONE\",IF(L63=0,\"PARTIAL\"))","v":"PARTIAL"}]
[null,"Behaviours"]
["B1","Work independently and demonstrate initiative being resourceful when faced with a problem and taking responsibility for solving problems within their own remit",null,null,null,null,null,null,{"$f":"IF(C65:C72 = \"FULLY MET\",1,IF(C65:C72 = \"PARTIALLY MET\",0.5,IF(C65:C72 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=1,\"NONE\",IF(L65=0.5,\"PARTIAL\",IF(L65=0,\"FULL\")))","v":"FULL"}]
["B2","Work securely within the business",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J66=1,0.5,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=0.5,\"NONE\",IF(L66=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Work within the goals, vision and values of the organisation",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J67=1,0,IF(J67=0.5,0,IF(J67=0,0)))","v":0},{"$f":"IF(L67=0,\"NONE\")","v":"NONE"}]
["B4","Take a wider view of the strategic objectives of the tasks or projects they are working on including the implications for accessibility by users and diversity",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J68=1,0.5,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=0.5,\"NONE\",IF(L68=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Works to meet or exceed customers’ requirements and expectations",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J69=1,0,IF(J69=0.5,0,IF(J69=0,0)))","v":0},{"$f":"IF(L69=0,\"NONE\")","v":"NONE"}]
["B6","Identifies issues quickly, investigates and solves complex problems and applies appropriate solutions. Ensures the true root cause of any problem is found and a solution is identified which prevents recurrence",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J70=1,1,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=1,\"NONE\",IF(L70=0.5,\"PARTIAL\",IF(L70=0,\"FULL\")))","v":"FULL"}]
["B7","Committed to continued professional development in order to ensure growth in professional skill and knowledge",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J71=1,0.5,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=0.5,\"NONE\",IF(L71=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B8","Work effectively under pressure showing resilience",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J72=1,1,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=1,\"NONE\",IF(L72=0.5,\"PARTIAL\",IF(L72=0,\"FULL\")))","v":"FULL"}]
[]
[]
[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",3]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",11]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L79-L80-(L81*0.5)","v":40.5}]

{"sheet":"ST0129","index":5,"n_rows":76,"n_cols":18,"rows_kept":76,"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,"Software Tester (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 relationship between testing and quality assurance and how testing contributes to higher quality",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","The difference between error, defect, and failure including the distinction between the root cause of a defect and its effects",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The impact of context on the test process including the activities, tasks and work products that support the test process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The need for traceability between the requirements/test basis and the test work products",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The principles underpinning the psychology of testing including how the required mindset differs from the development mindset, and how this can influence success of software testing activities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The importance of accuracy and clear documentation of software tests and defects.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The relationship between test activities and software development activities in the Software Development Lifecycle.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The application of testing across different recognised software development methodologies (sequential and iterative)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The range and features of software test types within the broad categories of Functional, Non-Functional, White Box/Structural and Change-related Testing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The objectives and approaches for testing at different Test Levels (such as Unit Testing, Component Integration Testing, System Testing, System Integration Testing and User Acceptance Testing).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The role of static testing techniques and the review process in early defect detection",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The characteristics of Black Box, White Box and Experience-based Test Techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The application of common Black Box Techniques to derive test conditions and test cases (Equivalence Partitioning, Boundary Value Analysis, Decision Table Testing and State Transition Testing)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The role of software testing within the context of project and product risk reduction in the systems development life cycle.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The defect management process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The typical metrics used to support the monitoring and control of testing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The classification of tools to support testing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The role of test automation in the context of the software development lifecycle",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The need for conformance to specific industry standards where appropriate (such as GDPR, health informatics, safety critical, etc.) related to software testing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Where Software Testers fit within the wider team and the roles and responsibilities that others play.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","The characteristics of software architecture that impact on software testing in the development lifecycle",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The core testing behaviours, skills and tools that are common to developers, testers, and multi-skilled roles in development lifecycles",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The typical security vulnerabilities that should be addressed by testing in general and specifically by penetration testing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply static test techniques",null,null,null,null,null,null,{"$f":"IF(C46:C58 = \"FULLY MET\",1,IF(C46:C58 = \"PARTIALLY MET\",0.5,IF(C46:C58 = \"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","Apply Black Box test techniques such as Equivalence Partitioning, Boundary Value Analysis, Decision Table Testing and State Transition Testing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Analyse test objectives and requirements/test basis to define test scope and coverage criteria",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Use tools to automate, manage or support any test activity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Apply a regression strategy including selection of tests, maintenance of regression suites and identifying tests suitable for automation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Use defect tracking tools",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Adapt and apply testing activities according to industry standard development methodologies (sequential and iterative)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Apply the range of different software test types within the broad categories of Functional, Non-Functional (Security, Performance & Usability), and White Box/Structural Testing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Apply and support testing at different Test Levels appropriate to the Software Development Lifecycle (such as Unit Testing, Component Integration Testing, System Testing, System Integration Testing and User Acceptance Testing), taking into account the fundamentals of testing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Conform to specific industry standards where appropriate (such as GDPR, health informatics, safety critical, etc.) related to software testing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Maintain up to date knowledge of technological developments in the field of Software Testing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Record and interpret test progress and results, communicating test status to the relevant stakeholders. ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Design and follow tests to achieve coverage criteria",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Maintains a productive, professional, and secure working environment\n",null,null,null,null,null,null,{"$f":"IF(C60:C66 = \"FULLY MET\",1,IF(C60:C66 = \"PARTIALLY MET\",0.5,IF(C60:C66 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J60=1,0.5,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=0.5,\"NONE\",IF(L60=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Works independently and takes responsibility. For example, disciplined and responsible approach to risk, works diligently regardless of how much they are being supervised, accepts responsibility for managing their own time and workload and stays motivated and committed when facing challenges",null,null,null,null,null,null,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"}]
["B3","A problem solving mindset within their own remit, being inquisitive and resourceful when faced with a problem to solve. Applies appropriate solutions. ensuring the true root cause of any problem is found and a solution is identified which prevents recurrence.\n",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J62=1,1,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=1,\"NONE\",IF(L62=0.5,\"PARTIAL\",IF(L62=0,\"FULL\")))","v":"FULL"}]
["B4","Applies logical thinking, for example, uses clear and valid reasoning when making decisions related to undertaking the work instructions.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J63=1,0.5,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},{"$f":"IF(L63=0.5,\"NONE\",IF(L63=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Analytical - uses informal and formal techniques to deconstruct a scenario or test basis to identify tests that will demonstrate software and systems are fit for purpose.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["B6","Works collaboratively with a wide range of people in different roles, internally and externally, with a positive attitude to inclusion & diversity",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=1,\"NONE\",IF(L65=0.5,\"PARTIAL\",IF(L65=0,\"FULL\")))","v":"FULL"}]
["B7","Communicates effectively in a wide variety of situations; for example, contributing effectively to meetings and presenting complex information to technical and non-technical audience",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J66)","v":0},"Net Score",{"$f":"SUM(L22:L66)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J69/L73","v":0},"total CoE KSB coverage",{"$f":"L69/L76","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",43]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L73-L74-(L75*0.5)","v":42}]

{"sheet":"ST0345","index":6,"n_rows":71,"n_cols":18,"rows_kept":71,"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,"Digital Community Manager (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Company brand, goals and commercial objectives in order to communicate effectively and appropriately with the wider community.",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","Expert level of familiarity with their product and brand in order to promptly address concerns and enquiries that are often complex and non-routine.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Social media platforms and their customer profiles, understanding that each platform caters for a different demographic of customer and that modifying communication to suit each platform can maximise the impact of the message.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Key competitors, wider trends and ‘hot topics’ in the relevant industry outside of own brand.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Internet forum software and content management systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Principles of data analytics and how to report findings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Platform holder policies and best practice guidelines.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Company policy and standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Conflict management techniques and theories.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Demographics and how this impacts on online behaviour and communication",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Neuro linguistic programming theory and practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Understanding of best practice of community management in the relevant industry.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Working safely online and understanding that interactions with the online community are on the behalf of the organisation and not personal",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Theory and practice of digital marketing, its role in overall communication strategy and how best to communicate a brand or product value",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Cyber security, how to spot potential threats and protect data and systems as per company guidelines and current data protection regulations",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J36=1,0.5,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=0.5,\"NONE\",IF(L36=0,\"PARTIAL\"))","v":"PARTIAL"}]
["K16","Online security procedures as per company guidelines",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J37=1,1,IF(J37=0.5,0.5,IF(J37=0,0)))","v":0},{"$f":"IF(L37=1,\"NONE\",IF(L37=0.5,\"PARTIAL\",IF(L37=0,\"FULL\")))","v":"FULL"}]
["K17","Basic understanding of how to identify and deal with any malicious or criminal activity as per company and legal guidelines",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J38=1,1,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=1,\"NONE\",IF(L38=0.5,\"PARTIAL\",IF(L38=0,\"FULL\")))","v":"FULL"}]
[null,"Skills"]
["S1","Actively moderate community forums, steering and encouraging debate and conversation in line with overall communication strategy and business objectives.",null,null,null,null,null,null,{"$f":"IF(C40:C54 = \"FULLY MET\",1,IF(C40:C54 = \"PARTIALLY MET\",0.5,IF(C40:C54 = \"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","Communicate clearly, in writing, adapting the message in order to address the particular audience appropriately.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J41=1,1,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=1,\"NONE\",IF(L41=0.5,\"PARTIAL\",IF(L41=0,\"FULL\")))","v":"FULL"}]
["S3","Work autonomously as online interaction and communication is fast moving and response to the community often needs to be delivered promptly.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J42=1,1,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=1,\"NONE\",IF(L42=0.5,\"PARTIAL\",IF(L42=0,\"FULL\")))","v":"FULL"}]
["S4","Create and contribute to creation of assets for publication online including written, visual, audio or video to engage community.",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"}]
["S5","Listen, assess, engage and react appropriately to an online situation or requests from the online community.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J44=1,0.5,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=0.5,\"NONE\",IF(L44=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S6","Use custom and internal forum software and Content Management System to manage and schedule posts and content delivery.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"FULL"}]
["S7","Craft the tone of communications to appeal to the different audiences on different digital platforms, in keeping with company brand and message.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Ability to deliver the organisations message and goals to the community in a manner appropriate to the community and forum",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Analyse, interpret and evaluate the information and ideas that are raised by the online community.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Deliver what the community may regard as unwelcome information about a product, such as a game release, in a positive manner, protecting brand reputation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Deliver effective written communication when messaging the online community via forums and online media channels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Use data analytics created by software packages and community tools dashboards to create reports for internal use",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Identify and moderate users who violate the forum or company policy, intervening to change behaviour or issuing warnings, suspensions and bans as appropriate.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Ability to manage conflict positively.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Analyse and evaluate the information created by data analytics to review the effectives of their actions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Proactively stimulate and drive customer interaction with their brand.",null,null,null,null,null,null,{"$f":"IF(C56:C61 = \"FULLY MET\",1,IF(C56:C61 = \"PARTIALLY MET\",0.5,IF(C56:C61 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J56=1,0.5,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=0.5,\"NONE\",IF(L56=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Attention to detail and a high level of accuracy.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J57=1,1,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=1,\"NONE\",IF(L57=0.5,\"PARTIAL\",IF(L57=0,\"FULL\")))","v":"FULL"}]
["B3","Self-motivated and comfortable working autonomously with good self judgement in a fast paced, challenging environment.",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"}]
["B4","Interest in current trends and innovations in the relevant industry",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J59=1,1,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=1,\"NONE\",IF(L59=0.5,\"PARTIAL\",IF(L59=0,\"FULL\")))","v":"FULL"}]
["B5","Reliable with a high degree of professionalism",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"}]
["B6","Maintain a positive and friendly manner.",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"}]
[]
[]
[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",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L68-L69-(L70*0.5)","v":36.5}]

{"sheet":"ST0825","index":7,"n_rows":84,"n_cols":18,"rows_kept":84,"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,"DevOps Engineer (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Continuous Integration - the benefits of frequent merging of code, the creation of build artefacts and ensuring all tests pass, with automation throughout - including common tooling.",null,null,null,null,null,null,{"$f":"IF(C22:C46 = \"FULLY MET\",1,IF(C22:C46 = \"PARTIALLY MET\",0.5,IF(C22:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The principles of distributed Source Control, including how to exploit the features of the tool, such as branching.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","How to use data ethically and the implications for wider society, with respect to the use of data, automation and artificial intelligence within the context of relevant data protection policy and legislation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The business value of DevOps in terms of Time, Cost, Quality, with an emphasis on building in internal Quality throughout the lifetime of the product.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","A range of modern security tools and techniques - e.g. threat modelling, vulnerability scanning and dependency checking, with a general awareness of penetration testing - in order to deal with threats and attack vectors within code and across the cyber domain.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","A range of problem solving techniques appropriate to the task at hand, such as affinity mapping, impact maps, plan-do-check-act/Deming.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","General purpose programming and infrastructure-as-code.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Immutable infrastructure and how it enables continuous refreshing of software, namely the updating of the operating system, container and security patching.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Different organisational cultures, the development frameworks utilised and how they can both complement each other and introduce constraints on delivery.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","How the user experience sits at the heart of modern development practices in terms of strategies to understand diverse user needs, accessibility and how to drive adoption.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Monitoring and alerting technologies and an awareness of the insights that can be derived from the infrastructure and applications - collecting logs and metrics, configuring alerting thresholds, firing alerts and visualising data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The persistence/data layer, including which database/storage technologies are appropriate to each platform type and application when considering non-functional and functional needs; e.g. monolith, microservice, read heavy, write heavy, recovery plans.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Automation techniques, such as scripting and use of APIs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Test Driven Development and the Test Pyramid. How the practice is underpinned by unit testing, the importance of automation, appropriate use of test doubles and mocking strategies, reducing a reliance on end-to-end testing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The principles and application of Continuous Integration, Continuous Delivery and Continuous Deployment, including the differences between them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How best to secure data; e.g. encryption in transit, encryption at rest and access control lists (ACL).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","What an API is, how to find them and interpret the accompanying documentation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Roles within a multidisciplinary team and the interfaces with other areas of an organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Different methods of communication and choosing the appropriate one - e.g. face-to-face (synchronous, high bandwidth), instant messaging, email (asynchronous, low bandwidth), visualisations vs. words.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Pair/mob programming techniques and when to use each technique.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Architecture principles, common patterns and common strategies for translating user needs into both cloud infrastructure and application code.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","How their occupation fits into the wider digital landscape and any current or future regulatory requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The importance of continual improvement within a blameless culture.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","The difference between Software-as-a-Service (SaaS) v bespoke v enterprise tooling and how to make an informed choice that suits each use case.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Maintain an awareness of cloud certification requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Communicate credibly with technical and non-technical people at all levels, using a range of methods; e.g. ‘Show and Tell’ and ‘Demonstrations’.",null,null,null,null,null,null,{"$f":"IF(C48:C69 = \"FULLY MET\",1,IF(C48:C69 = \"PARTIALLY MET\",0.5,IF(C48:C69 = \"NOT MET\",0,)))","v":0},null,"NONE",0,"FULL"]
["S2","Work within different organisational cultures with both internal and external parties",null,null,null,null,null,null,0,null,"FULL",{"$f":"IF(J49=1,0,IF(J49=0.5,0,IF(J49=0,0)))","v":0},{"$f":"IF(L49=0,\"NONE\")","v":"NONE"}]
["S3","Translate user needs into deliverable tasks, writing clear, concise and unambiguous user stories that the whole team can understand.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Initiate and facilitate knowledge sharing and technical collaboration",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Deploy immutable infrastructure",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Install, manage and troubleshoot monitoring tools",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Navigate and troubleshoot stateful distributed systems, in order to locate issues across the end-to-end service.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Work in agile, multi-disciplinary delivery teams, taking a flexible, collaborative and pragmatic approach to delivering tasks.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Application of a range of cloud security tools and techniques - e.g. threat modelling, vulnerability scanning, dependency checking, reducing attack surface area - incorporating these tools and techniques into the automated pipeline wherever possible.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Assess identified and potential security threats and take appropriate action based on likelihood v impact.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Employ a systematic approach to solving problems, using logic and hypotheses / experimentation to identify the source of issues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Automate tasks where it introduces improvements to the efficiency of business processes and reduces waste, considering the effort and cost of automation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Engage in productive pair/mob programming.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Write tests and follow Test Driven Development discipline in various different contexts.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Release automation and orchestration as part of a Continuous Integration workflow and Continuous Delivery pipeline, automating the delivery of code from source control to the end users.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Invest in continuous learning, both your own development and others, ensuring learning activities dovetail with changing job requirements. Keep up with cutting edge.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Code in a general purpose programming language.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Specify cloud infrastructure in an infrastructure-as-code domain-specific language.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Interpret logs and metrics data within the appropriate context to identify issues and make informed decisions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Writing code in such a way that makes merging easier and facilitates branching by abstraction - i.e. feature toggling.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Application of lightweight modelling techniques, such as whiteboarding, in order to gain consensus as a team on evolving architecture.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Incremental refactoring by applying small behaviour-preserving code changes to evolve the architecture.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Exhibits enthusiasm, openness and an aptitude for working as part of a collaborative community; e.g. sharing best practice, pairing with team members, learning from others and engaging in peer review practices.",null,null,null,null,null,null,{"$f":"IF(C71:C74 = \"FULLY MET\",1,IF(C71:C74 = \"PARTIALLY MET\",0.5,IF(C71:C74 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J71=1,0.5,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=0.5,\"NONE\",IF(L71=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Invests time and effort in their own development, recognising that technology evolves at a rapid rate.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J72=1,1,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=1,\"NONE\",IF(L72=0.5,\"PARTIAL\",IF(L72=0,\"FULL\")))","v":"FULL"}]
["B3","Displays a commitment to the mantra 'You build it, you run it', taking ownership of deployed code and being accountable for its continual improvement, learning from experience and taking collective responsibility when things fail.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Is inclusive, professional and maintains a blameless culture.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J74=1,0.5,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=0.5,\"NONE\",IF(L74=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J74)","v":0},"Net Score",{"$f":"SUM(L22:L74)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J77/L81","v":0},"total CoE KSB coverage",{"$f":"L77/L84","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",51]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",1]
[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":"L81-L82-(L83*0.5)","v":49}]

{"sheet":"ST0863","index":8,"n_rows":80,"n_cols":18,"rows_kept":80,"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,"Digital Accessibility Specialist (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 characteristics and categories of disabilities (including temporary, situational and permanent disabilities) and how these affect individuals.",null,null,null,null,null,null,{"$f":"IF(C22:C46 = \"FULLY MET\",1,IF(C22:C46 = \"PARTIALLY MET\",0.5,IF(C22:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Commonly used accessibility guidelines (for example the Web Content Accessibility Guidelines, EN301549 and Section508), methods to implement and achieve conformance and how these assist users with disabilities.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","How accessibility is managed and integrated within an enterprise environment including policies, and reasonable adjustments.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J24=1,0.5,IF(J24=0.5,0.5,IF(J24=0,0)))","v":0},{"$f":"IF(L24=0.5,\"NONE\",IF(L24=0,\"PARTIAL\"))","v":"PARTIAL"}]
["K4","How to utilise productivity suites ensuring output is accessible and advising on the implementation of accessibility features and content.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J25=1,1,IF(J25=0.5,0.5,IF(J25=0,0)))","v":0},{"$f":"IF(L25=1,\"NONE\",IF(L25=0.5,\"PARTIAL\",IF(L25=0,\"FULL\")))","v":"FULL"}]
["K5","The implications and effect on users with disabilities, and UK businesses of international disability legislation (including Equality Act 2010, Public Sector Bodies (Websites and Mobile Applications) No. 2 Accessibility Regulations 2018 and Accessible Canada Act C81 2018).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","How to present using relevant technologies and aids in a manner that communicates the information (including a business case) to the chosen target audience, and understand the key facts and figures relating to accessibility.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The process to set-up, moderate and conduct activities relating to hosting workshops including moderation usability testing, user research testing and end-user testing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The basics of Hyper Text Mark-up Language, Cascading Style Sheets, JavaScript and Accessibility Rich Internet Applications, and how these should be used to enhance the accessibility of services (for example alt text, dynamic content, colour contrast).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","How mobile applications are developed using appropriate development applications and the basics of the languages used.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The fundamentals of the Web Content Accessibility Guidelines (WCAG), including the purpose, application and utilisation of WCAG in a variety of situations (for example web, mobile, desktop applications).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The basic principles of project management (including project life cycle methodologies), and how accessibility considerations are integrated.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The accessibility considerations when designing and developing an application's user experience using related standards and guidelines including ISO9241 Ergonomics of human-system interaction, The Principles of Universal Design by the Centre for Universal Design and the Web Content Accessibility Guidelines to create an inclusive design.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How to use assistive technologies (both digital and physical), their use-cases and functionality, degrees of complexity (hi-tech, low-tech and no-tech).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How assistive technologies interact with other digital technologies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The principles and application of testing methodologies to accessibility criteria and assistive technologies, and the impact of accessibility findings (including test documentation).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How to construct a business report (for example document layout and contents).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The purpose and importance of reasonable adjustments, and how these are managed.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Best practices regarding digital security including General Data Protection Regulations 2018, how these are applied to an organisation and the factors which can result in these being effective and how these can be mitigated.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The security considerations relating to the installation and utilisation of assistive technologies, how these tools may be misidentified by common security practices and the methods to mitigate such security constraints.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How to communicate through different mediums, including tailoring communications to different user groups.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","How to use incident management tools, triage incidents and appropriately communicate with assistive technology users.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","How to audit digital applications (including web and mobile applications) against digital assistive technologies including screen readers, screen magnifiers, speech to text and literacy aids.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The preparation and processes required to conduct training with a variety of user groups for example project managers, web designers, developers, end users and line management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","How accessibility fits into the wider digital landscape, including current/future applicable regulatory requirements, and case law in the area of discriminating against employees with a disability.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","How to use data ethically and the implications for wider society, with respect to the use of data, automation and artificial intelligence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Present information, (for example business cases, testing findings, general information etc.) to a variety of audiences to ensure understanding.",null,null,null,null,null,null,{"$f":"IF(C48:C65 = \"FULLY MET\",1,IF(C48:C65 = \"PARTIALLY MET\",0.5,IF(C48:C65 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["S2","Use hardware and software based assistive technologies for a variety of applications (for example testing, training etc.)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Use Interpersonal skills to develop and maintain effective and credible professional relationships both within and outside the team.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Conduct testing against a variety of platforms using appropriate standards and/or guidelines and assistive technologies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Conduct workshops, surveys or focus groups, including the set-up, running and conclusion activities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Both written and verbal communication skills when working as a team or individually.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Solve problems using a logical and analytical approach.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Identify appropriate assistive technologies and adaptive strategies for an individual's disability.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Practice disability etiquette, when communicating with individuals with disabilities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Apply accessibility standards and regulations to practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Uses productivities suites and implementing accessibility best practices (for example reading level, colour contrast etc.) into produced documentation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Create business reports, business cases and documentation appropriate for the target audience (for example developers, management etc.)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Identifies and rectify issues being experienced using appropriate troubleshooting methods relating to a user's assistive technology.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Apply security best practices.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Apply accessibility guidelines (for example WCAG, ISO9241 Ergonomics of human-system interaction) when designing and developing solutions on a variety of platforms (for example web, mobile etc.)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Collate and research information, or statistics (for example disability statistics, appropriate assistive technology for specific disabilities and correct terminology) required to present, in a manner which is appropriate to the target audience of any training (for example project managers, web designers, developers, end users and line management).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Keep up-to-date with developments in technologies, trends and innovation using a range of sources.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Lead a group of individuals using basic leadership skills as to achieve a common goal.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Motivated, empathetic and driven in the field of accessibility and the wider digital sphere.",null,null,null,null,null,null,{"$f":"IF(C67:C70 = \"FULLY MET\",1,IF(C67:C70 = \"PARTIALLY MET\",0.5,IF(C67:C70 = \"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","Proactively Inclusive.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J68=1,1,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=1,\"NONE\",IF(L68=0.5,\"PARTIAL\",IF(L68=0,\"FULL\")))","v":"FULL"}]
["B3","Manages time effectively and adheres to timescales when producing work product.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"}]
["B4","Inquisitive, innovative and forward-thinking regarding digital technologies which could have beneficial implications for disabled individuals.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J70=1,1,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=1,\"NONE\",IF(L70=0.5,\"PARTIAL\",IF(L70=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J70)","v":0},"Net Score",{"$f":"SUM(L22:L70)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J73/L77","v":0},"total CoE KSB coverage",{"$f":"L73/L80","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",47]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L77-L78-(L79*0.5)","v":46.5}]

{"sheet":"ST1021","index":9,"n_rows":129,"n_cols":21,"rows_kept":129,"cut":false,"hidden":false,"merged":[[83,11,83,15],[95,11,95,15],[107,11,107,15],[119,11,119,15],[8,0,8,9],[8,11,8,18],[9,2,9,4],[9,11,12,18],[17,1,17,4],[20,2,20,4]]}
[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,null,"IM COMMENTS/OBSERVATIONS TEXT BOX"]
["KSB","KSB Statement (this list contains the core KSBs for the Cyber security technologist occupation, plus the specific KSBs for Cyber security engineer, Cyber risk analyst and Cyber defend & respond options.","Included in:",null,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","Cyber security technologist (level 4) - Cyber security engineer      ","Cyber security technologist (level 4) - Cyber risk analyst  ","Cyber security technologist (level 4) - Cyber defend & respond"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","YES","YES","YES","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","YES","YES","YES","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,"Cyber security technologist (level 4)"]
[null,"Three options are available (columns C-E). Please check if the KSB needs to be mapped against the option of your choice. If you map against two or three options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
[]
["KSB","KSB Statement (this list contain the core KSBs for the Cyber security technologist occupation, plus the specific KSBs for Cyber security engineer, Cyber risk analyst and Cyber defend & respond options).","Included in:",null,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","Cyber security technologist (level 4) - Cyber security engineer      ","Cyber security technologist (level 4) - Cyber risk analyst  ","Cyber security technologist (level 4) - Cyber defend & respond"]
["K1","Principles of networks: OSI and TCP/IP models, data, protocols and how they relate to each other; the main routing protocols; the main factors affecting network performance including typical failure modes in protocols and approaches to error control; virtual networking","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F23:F39 = \"FULLY MET\",1,IF(F23:F39 = \"PARTIALLY MET\",0.5,IF(F23:F39 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(M23=1,1,IF(M23=0.5,0.5,IF(M23=0,0)))","v":0},{"$f":"IF(O23=1,\"NONE\",IF(O23=0.5,\"PARTIAL\",IF(O23=0,\"FULL\")))","v":"FULL"}]
["K2","The concepts, main functions and features of at least three Operating Systems (OS) and their security functions and associated security features.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Cyber security concepts and why cyber security matters to business and society; Security assurance concepts and how assurance may be achieved in practice including penetration testing and extrinsic assurance methods.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The main types of common attack techniques; also the role of human behaviour, including the significance of the 'insider threat'. Including: how attack techniques combine with motive and opportunity to become a threat. Techniques and strategies to defend against attack techniques and mitigate hazards","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The significance of identified trends in cyber security threats and understand the value and risk of this analysis. How to deal with emerging attack techniques (including 'zero day'), hazards and vulnerabilities relevant to the digital systems and business environment.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Lifecycle and service management practices to an established standard to a foundation level for example Information Technology Infrastructure Library (ITIL) foundation level.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Cyber incident response processes, incident management processes and evidence collection/preservation requirements to support incident investigation","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Understands the main features, applicability and how to apply the significant law, regulations and standards relevant specifically to cyber security. To include: laws, regulations & standards relating to personal data and privacy (e.g. Data Protection Act 2018 implementing General Data Protection Regulation); use of digital systems (e.g. Computer Misuse Act 1990 ); regulatory standards for cyber security, intelligence collection and law enforcement (e.g. Intelligence Services Act 1994, Regulation of Investigatory Powers Act 2000; standards for good practice in cyber security (e.g. ISO 27001, CyberEssentials, NIST) and any updates or additions","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Ethical principles and codes of good practice of at least one significant cyber security professional body and the ethical responsibilities of a cyber security professional.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","How to analyse employer or customer requirements to derive security objectives and taking account of the threats and overall context develop a security case which sets out the proposed security measures in the context with reasoned justification","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Horizon scanning including use of recognised sources of threat intelligence and vulnerabilities.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Common security architectures and methodologies; be aware of reputable security architectures that incorporates hardware and software components, and sources of architecture patterns and guidance. How cyber security technology components are typically deployed in digital systems to provide security functionality including: hardware and software to implement security controls","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The basic terminology and concepts of cryptography; common cryptography techniques in use; the importance of effective key management and the main techniques used; legal, regulatory and export issues specific to the use of cryptography","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Risk assessment and audit methodologies and approaches to risk treatment; approaches to identifying the vulnerabilities in organisations and security management systems; the threat intelligence lifecycle; the role of the risk owner in contrast with other stakeholders","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Principles of security management systems, including governance, organisational structure, roles, policies, standards, guidelines and how these all work together to deliver the identified security outcomes.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Function and features of significant digital system components; typical architectures; common vulnerabilities in digital systems; principles and common practice in digital system security","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Programming or scripting languages","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Discover vulnerabilities in a system by using a mix of research and practical exploration","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F41:F70 = \"FULLY MET\",1,IF(F41:F70 = \"PARTIALLY MET\",0.5,IF(F41:F70 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(M41=1,1,IF(M41=0.5,0.5,IF(M41=0,0)))","v":0},{"$f":"IF(O41=1,\"NONE\",IF(O41=0.5,\"PARTIAL\",IF(O41=0,\"FULL\")))","v":"FULL"}]
["S2","Analyse and evaluate security threats and hazards to a system or service or processes. Use relevant external source of threat intelligence or advice (e.g. National Cyber Security Centre) Combine different sources to create an enriched view of cyber threats and hazards","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Research and investigate common attack techniques and relate these to normal and observed digital system behaviour and recommend how to defend against them. Interpret and demonstrate use of external source of vulnerabilities (e.g. OWASP, intelligence sharing initiatives, open source)","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Undertake security risk assessments for simple systems without direct supervision and propose basic remediation advice in the context of the employer.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Source and analyse security cases and describe what threats, vulnerability or risks are mitigated and identify any residual areas of concern.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Analyse employer or customer requirements to derive security objectives and taking account of the threats and overall context develop a security case which sets out the proposed security measures in the context with reasoned justification","YES","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Identify and follow organisational policies and standards for information and cyber security and operate according to service level agreements or other defined performance targets.","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M47=1,0.5,IF(M47=0.5,0.5,IF(M47=0,0)))","v":0},{"$f":"IF(O47=0.5,\"NONE\",IF(O47=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S8","Configure, deploy and use computer, digital network and cyber security technology.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M48=1,1,IF(M48=0.5,0.5,IF(M48=0,0)))","v":0},{"$f":"IF(O48=1,\"NONE\",IF(O48=0.5,\"PARTIAL\",IF(O48=0,\"FULL\")))","v":"FULL"}]
["S9","Recommend improvements to the cyber security posture of an employer or customer based on research into future potential cyber threats and considering threat trends.","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M49=1,0.5,IF(M49=0.5,0.5,IF(M49=0,0)))","v":0},{"$f":"IF(O49=0.5,\"NONE\",IF(O49=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S10","Design, build, test and troubleshoot a network incorporating more than one subnet with static and dynamic routes, to a given design requirement without supervision. Provide evidence that the system meets the design requirement.","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M50=1,1,IF(M50=0.5,0.5,IF(M50=0,0)))","v":0},{"$f":"IF(O50=1,\"NONE\",IF(O50=0.5,\"PARTIAL\",IF(O50=0,\"FULL\")))","v":"FULL"}]
["S11","Analyse security requirements given (functional and non-functional security requirements that may be presented in a security case) against other design requirements (e.g. usability, cost, size, weight, power, heat, supportability etc.) for a given system or product. Identify conflicting requirements and propose, with reasoning, resolution through appropriate trade-offs.","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Design and build, systems in accordance with a security case within broad but generally well-defined parameters. This should include selection and configuration of typical security hardware and software components. Provide evidence that the system has properly implemented the security controls required by the security case","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Write program code or scripts to meet a given design requirement in accordance with employers' coding standards","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Design systems employing encryption to meet defined security objectives. Develop and implement a plan for managing the associated encryption keys for the given scenario or system.","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Use tools, techniques and processes to actively prevent breaches to digital system security.","YES","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Conduct cyber-risk assessments against an externally (market) recognised cyber security standard using a recognised risk assessment methodology.","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Identify cyber security threats relevant to a defined context","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Develop information security policies or processes to address a set of identified risks, for example from security audit recommendations.","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Develop information security policies within a defined scope to take account of legislation and regulation relevant to cyber security.","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Take an active part in a security audits against recognised cyber security standards, undertake gap analysis and make recommendations for remediation.","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Develop plans for incident response for approval within defined governance arrangements for incident response.","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Develop plans for local business continuity for approval within defined governance arrangements for business continuity.","NO","YES","NO",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M62=1,0.5,IF(M62=0.5,0.5,IF(M62=0,0)))","v":0},{"$f":"IF(O62=0.5,\"NONE\",IF(O62=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S23","Assess security culture using a recognised approach.","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M63=1,1,IF(M63=0.5,0.5,IF(M63=0,0)))","v":0},{"$f":"IF(O63=1,\"NONE\",IF(O63=0.5,\"PARTIAL\",IF(O63=0,\"FULL\")))","v":"FULL"}]
["S24","Design and implement a simple ‘security awareness’ campaign to address a specific aspect of a security culture.","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Integrate and correlate information from various sources (including log files from different sources, digital system monitoring tools, Secure Information and Event Management (SIEM) tools, access control systems, physical security systems) and compare to known threat and vulnerability data to form a judgement based on evidence with reasoning that the anomaly represents a digital system security breach","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Recognise anomalies in observed digital system data structures (including by inspection of network packet data structures) and digital system behaviours (including by inspection of protocol behaviours) and by inspection of log files and by investigation of alerts raised by automated tools including SIEM tools.","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Accurately, objectively and concisely record and report the appropriate cyber security information, including in written reports within a structure or template provided.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Configure digital system monitoring and analysis tools (e.g. SIEM tools), taking account of threat & vulnerability intelligence, indicators of compromise.","YES","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S29","Undertake root cause analysis of events and make recommendations to reduce false positives and false negatives.","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S30","Manage local response to non-major incidents in accordance with a defined procedure.","NO","NO","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M70=1,0.5,IF(M70=0.5,0.5,IF(M70=0,0)))","v":0},{"$f":"IF(O70=0.5,\"NONE\",IF(O70=0,\"PARTIAL\"))","v":"PARTIAL"}]
[null,"Behaviours"]
["B1","Logical - Applies logical thinking, for example, uses clear and valid reasoning when making decisions related to undertaking the work instructions","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F72:F81 = \"FULLY MET\",1,IF(F72:F81 = \"PARTIALLY MET\",0.5,IF(F72:F81 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(M72=1,1,IF(M72=0.5,0.5,IF(M72=0,0)))","v":0},{"$f":"IF(O72=1,\"NONE\",IF(O72=0.5,\"PARTIAL\",IF(O72=0,\"FULL\")))","v":"FULL"}]
["B2","Analytical - working with data effectively to see patterns, trends and draw meaningful conclusions.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M73=1,1,IF(M73=0.5,0.5,IF(M73=0,0)))","v":0},{"$f":"IF(O73=1,\"NONE\",IF(O73=0.5,\"PARTIAL\",IF(O73=0,\"FULL\")))","v":"FULL"}]
["B3","Works independently and takes responsibility. For example works diligently regardless of how much they are being supervised, and stays motivated and committed when facing challenges","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M74=1,1,IF(M74=0.5,0.5,IF(M74=0,0)))","v":0},{"$f":"IF(O74=1,\"NONE\",IF(O74=0.5,\"PARTIAL\",IF(O74=0,\"FULL\")))","v":"FULL"}]
["B4","Shows initiative, being resourceful when faced with a problem and taking responsibility for solving problems within their own remit","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M75=1,1,IF(M75=0.5,0.5,IF(M75=0,0)))","v":0},{"$f":"IF(O75=1,\"NONE\",IF(O75=0.5,\"PARTIAL\",IF(O75=0,\"FULL\")))","v":"FULL"}]
["B5","Thorough & organised. For example uses their time effectively to complete work to schedule and takes responsibility for managing their own work load and time","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M76=1,1,IF(M76=0.5,0.5,IF(M76=0,0)))","v":0},{"$f":"IF(O76=1,\"NONE\",IF(O76=0.5,\"PARTIAL\",IF(O76=0,\"FULL\")))","v":"FULL"}]
["B6","Works effectively with a wide range of people in different roles, internally and externally, with a regard to inclusion & diversity policy","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M77=1,0.5,IF(M77=0.5,0.5,IF(M77=0,0)))","v":0},{"$f":"IF(O77=0.5,\"NONE\",IF(O77=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B7","Communicates effectively in a wide variety of situations for example contributing effectively to meetings and presenting complex information to technical and non-technical audiences","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M78=1,0.5,IF(M78=0.5,0.5,IF(M78=0,0)))","v":0},{"$f":"IF(O78=0.5,\"NONE\",IF(O78=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B8","Maintains a productive, professional and secure working environment.","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M79=1,0.5,IF(M79=0.5,0.5,IF(M79=0,0)))","v":0},{"$f":"IF(O79=0.5,\"NONE\",IF(O79=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B9","Creative - taking a variety of perspectives, taking account of unpredictable adversary and threat behaviours and approaches, bring novel and unexpected solutions to address cyber security challenges","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M80=1,1,IF(M80=0.5,0.5,IF(M80=0,0)))","v":0},{"$f":"IF(O80=1,\"NONE\",IF(O80=0.5,\"PARTIAL\",IF(O80=0,\"FULL\")))","v":"FULL"}]
["B10","Problem Solving - Identifies issues quickly, solves complex problems and applies appropriate solutions. Dedicated to finding the true root cause of any problem and find solutions that prevent recurrence.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M81=1,1,IF(M81=0.5,0.5,IF(M81=0,0)))","v":0},{"$f":"IF(O81=1,\"NONE\",IF(O81=0.5,\"PARTIAL\",IF(O81=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Cyber security technologist (level 4) - Cyber security engineer     "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M23:M39)+SUM(M41:M55)+M57+SUM(M67:M68)+SUM(M72:M81)","v":0},"Net Score",{"$f":"SUM(O23:O39)+SUM(O41:O55)+O57+SUM(O67:O68)+SUM(O72:O81)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M86/O90","v":0},"total CoE KSB coverage",{"$f":"O86/O93","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O90-O91-(O92*0.5)","v":42.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Cyber security technologist (level 4) - Cyber risk analyst"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M23:M39)+SUM(M41:M49)+M53+SUM(M56:M60)+SUM(M62:M64)+M67+SUM(M72:M81)","v":0},"Net Score",{"$f":"SUM(O23:O39)+SUM(O41:O49)+O53+SUM(O56:O60)+SUM(O62:O64)+O67+SUM(O72:O81)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M98/O102","v":0},"total CoE KSB coverage",{"$f":"O98/O105","v":0}]
[]
[]
[null,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,null,"fully mitigated",0]
[null,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,null,"net KSB",{"$f":"O102-O103-(O104*0.5)","v":43}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Cyber security technologist (level 4) - Cyber defend & respond"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M23:M39)+SUM(M41:M45)+SUM(M47:M49)+M53+M55+M57+M61+SUM(M65:M70)+SUM(M72:M81)","v":0},"Net Score",{"$f":"SUM(O23:O39)+SUM(O41:O45)+SUM(O47:O49)+O53+O55+O57+O61+SUM(O65:O70)+SUM(O72:O81)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M110/O114","v":0},"total CoE KSB coverage",{"$f":"O110/O117","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O114-O115-(O116*0.5)","v":42}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KBSs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M23:M81)","v":0},"Net Score",{"$f":"SUM(O23:O81)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M122/O126","v":0},"total CoE KSB coverage",{"$f":"O122/O129","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O126-O127-(O128*0.5)","v":53.5}]

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