{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Guide","Structure","ST0116","ST0117","ST0118","ST0127","ST0129","ST0345","ST0825","ST0863","ST1021","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
["Quick reference guide to KSB mapping",null,"Table to assist with B11-13"]
[null,null,"Reference","Name of occupational standard"]
["1. START HERE",null,"ST0116","Software developer (level 4) (ST0116)"]
["Awarding body:",null,"ST0117","Business analyst (level 4) (ST0117)"]
["Please type the name of your awarding body here",null,"ST0118","Data analyst (level 4) (ST0118)"]
["Qualification name:",null,"ST0127","Network engineer (level 4) (ST0127)"]
["Please type your qualification title here",null,"ST0129","Software tester (level 4) (ST0129)"]
["Programme title if applicable:",null,"ST0345","Digital community manager (level 4) (ST0345)"]
["Please type the programme title here",null,"ST0825","DevOps engineer (level 4) (ST0825)"]
["Please select the occupational standard(s) you are mapping in this spreadsheet","Dropdown Options","ST0863","Digital accessibility specialist (level 4) (ST0863)"]
["Standard 1 - select from the dropdown list to the right",null,"ST1021 - CSE","Cyber security technologist (level 4) (ST1021) - Cyber security engineer"]
["Standard 2 - select from the dropdown list to the right",null,"ST1021 - CRA","Cyber security technologist (level 4) (ST1021) - Cyber risk analyst"]
["Standard 3 - select from the dropdown list to the right",null,"ST1021 - D&R","Cyber security technologist (level 4) (ST1021) - Cyber defend & respond"]
["If your qualification maps to more than three occupational standards, please contact us at HTQ.approvals@education.gov.uk"]
[]
["2. GUIDE TO KSB MAPPING  "]
["Awarding bodies must demonstrate that a qualification will enable a person to demonstrate that they have attained as many of the knowledge, skills and behaviours set out in the standard as may be reasonably expected by undertaking a course of education. "]
[]
["Before you begin, please list your qualification modules in the 'Structure' tab."]
["1. You can map your qualification to one or more occupational standards. "]
["2. Select the occupational standard(s) you wish to map to your qualification by clicking the blue STxxxx link in the reference column, to the right."]
["3. When the occupational standard opens, double check the name of the standard is correct. "]
["4. Please respond to each KSB statement."]
["5. Populate the Detailed page/paragraph reference, KSB coverage, Evidence, Assessment method and Supporting comments/rationale columns, as shown in the example below. "]
["6. Please be as specific as possible about which content in the qualification aligns to each KSB statement. "]
["7. You may delete sheets/tabs that are not relevant to  your qualification. "]
["8. Submit the completed spreadsheet along with any documents you have cited in the 'EVIDENCE UPLOAD' part of the application form. Where we have capacity we are happy to feedback on early drafts of your KSB mapping."]
["9. Please contact HTQ.approvals@education.gov.uk if you need further help or guidance on mapping."]
[]
["3. EXAMPLE OF KSB MAPPING"]
["Please see the KSB mapping examples to the right. ","KSB Number","This is the list of KSB statements","Where in the qualification is the content? \nIndicate the reference document(s)/module(s)/unit(s) and page/paragraph number(s) you are citing as evidence of coverage","Select the coverage from the drop down list","Paste or type clear evidence supporting your KSB coverage. For example, learning outcomes or indicative module content","Provide information on how this KSB is assessed, i.e. the method of assessment used.  ","Provide comments and/or a rationale to support the evidence you have cited. If the KSB mentions key terms not explicitly referenced in your evidence, please explain how they are covered. If you have partially met or not met a KSB, provide a rationale to support your judgement"]
[null,"KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale"]
[null,"K1","Understand the background legislation and regulatory frameworks (such as IBL 188) relating to the occupation. ","Module 1.1 Legal and Ethical Considerations; p44-45, para 4-7.\nModule 4.2 Professional Issues and CPD; p9, para 3-4. \nQualification specification p4.","FULLY MET","MO1.1 LO3 Understand and critically reflect on legislation relating to and affecting the occupation.\nIndicative content\nLegal background; legislation; role of industry bodies; national/international considerations. \n\nMO4.2 LO2 Understand the importance of staying up to date with professional developments in the field, including legal frameworks, industry best practice, guidelines and relevant standards. ","Students are required to produce a written report using a brief provided. Within this report students are expected to cover relevant laws, legislation and industry body standards relevant to the brief. ","The detailed coverage of relevant law and legislation is taught in Year 1. It is covered again in Year 2, where learners reflect on it from a  professional perspective. The national regulatory framework and industry body standards (e.g. IBL 188) are covered in detail. "]
[null,"K2","The principles, features and differences of waterfall and agile methodologies for project delivery and software development.","Module 3. Software development; p.6, para 4-7.","FULLY MET","MO3 LO 1 Critically analyse and evaluate approaches to software development methodologies. Theory, method and application.\n\nIndicative content \nUse of different software methodologies; matching methodology to function. \nA range of software methodologies are covered and applied to software problems.","K2 is assessed via a project. Within this project students will be expected to demonstrate practical application and produce written project report(s) which evidence methodologies and methods. ","Waterfall and agile are not explicitly referred to in the LO or indicative content, although they are both fully covered in this module. We cover four approaches to software development, providing background, theory and practical applications. Learners will get 'hands on' experience of evaluating waterfall and agile, including their use in real-world problem solving and project delivery."]

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

{"sheet":"ST0116","index":2,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"Software developer (level 4) (ST0116)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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(D5:D16 = \"FULLY MET\",1,IF(D5:D16 = \"PARTIALLY MET\",0.5,IF(D5:D16 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","K2: roles and responsibilities within the software development lifecycle (who is responsible for what)",null,null,null,null,null,null,0,null,"NONE"]
["K3","K3: the roles and responsibilities of the project life cycle within your organisation, and your role",null,null,null,null,null,null,0,null,"FULL"]
["K4","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"]
["K5","K5: the similarities and differences between different software development methodologies, such as agile and waterfall.",null,null,null,null,null,null,0,null,"NONE"]
["K6","K6: how teams work effectively to produce software and how to contribute appropriately ",null,null,null,null,null,null,0,null,"NONE"]
["K7","K7: software design approaches and patterns, to identify reusable solutions to commonly occurring problems",null,null,null,null,null,null,0,null,"NONE"]
["K8","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,"PARTIAL"]
["K9","K9: principles of 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"]
["K10","K10: principles and uses of relational and non-relational databases",null,null,null,null,null,null,0,null,"NONE"]
["K11","K11: software designs and functional/technical specifications",null,null,null,null,null,null,0,null,"NONE"]
["K12","K12: software testing frameworks and methodologies",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","S1: create logical and maintainable codes",null,null,null,null,null,null,{"$f":"IF(D18:D34 = \"FULLY MET\",1,IF(D18:D34 = \"PARTIALLY MET\",0.5,IF(D18:D34 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","S2: develop effective user interfaces",null,null,null,null,null,null,0,null,"NONE"]
["S3","S3: link code to data sets",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4: test code and analyse results to correct errors found using unit testing",null,null,null,null,null,null,0,null,"NONE"]
["S5","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"]
["S6","S6: identify and create test scenarios",null,null,null,null,null,null,0,null,"NONE"]
["S7","S7: apply structured techniques to problem solving, can debug code and can understand the structure of programmes to identify and resolve issues",null,null,null,null,null,null,0,null,"NONE"]
["S8","S8: create simple software designs to effectively communicate understanding of the program",null,null,null,null,null,null,0,null,"NONE"]
["S9","S9: create analysis artefacts, such as use cases and/or user stories",null,null,null,null,null,null,0,null,"NONE"]
["S10","S10: build, manage and deploy code into the relevant environment",null,null,null,null,null,null,0,null,"NONE"]
["S11","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"]
["S12","S12: follow software designs and functional/technical specifications",null,null,null,null,null,null,0,null,"NONE"]
["S13","S13: follow testing frameworks and methodologies",null,null,null,null,null,null,0,null,"NONE"]
["S14","S14: follow company, team or client approaches to continuous integration, version and source control",null,null,null,null,null,null,0,null,"PARTIAL"]
["S15","S15: communicate software solutions and ideas to technical and non-technical stakeholders",null,null,null,null,null,null,0,null,"NONE"]
["S16","S16: apply algorithms, logic and data structures",null,null,null,null,null,null,0,null,"NONE"]
["S17","S17: interpret and implement a given design whist remaining compliant with security and maintainability requirements",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","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(D36:D45 = \"FULLY MET\",1,IF(D36:D45 = \"PARTIALLY MET\",0.5,IF(D36:D45 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","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"]
["B3","B3: Maintains a productive, professional and secure working environment",null,null,null,null,null,null,0,null,"PARTIAL"]
["B4","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"]
["B5","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"]
["B6","B6: Shows initiative 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"]
["B7","B7: Communicates effectively in a variety of situations to both a technical and nontechnical audience.",null,null,null,null,null,null,0,null,"NONE"]
["B8","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, and techniques; 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"]
["B9","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"]
["B10","B10: Committed to continued professional development.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J45)","v":0},"Net Score",{"$f":"SUM(L5:L45)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J48/L52","v":0},"total CoE KSB coverage",{"$f":"L48/L55","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",39]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",6]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L52-L53-(L54*0.5)","v":35}]

{"sheet":"ST0117","index":3,"n_rows":87,"n_cols":17,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,"Business analyst (level 4) (ST0117)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","K1: The definition of Business Analysis and the range of activities that constitute it",null,null,null,null,null,null,{"$f":"IF(D5:D32 = \"FULLY MET\",1,IF(D5:D32 = \"PARTIALLY MET\",0.5,IF(D5:D32 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","K2: The value of Business Analysis in enabling business improvement and delivering IT system changes",null,null,null,null,null,null,0,null,"NONE"]
["K3","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"]
["K4","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"]
["K5","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"]
["K6","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"]
["K7","K7: The purpose and value of quality assurance techniques",null,null,null,null,null,null,0,null,"NONE"]
["K8","K8: Approaches to conducting internal and external environmental analysis of an industry domain",null,null,null,null,null,null,0,null,"NONE"]
["K9","K9: The advantages and disadvantages of a range of investigative techniques",null,null,null,null,null,null,0,null,"NONE"]
["K10","K10: The purpose of process modelling and the importance of an organisational view of business process",null,null,null,null,null,null,0,null,"NONE"]
["K11","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"]
["K12","K12: Techniques to elicit requirements, including when it is most appropriate to use each",null,null,null,null,null,null,0,null,"NONE"]
["K13","K13: The importance of eliciting requirements rather than gathering solution descriptions",null,null,null,null,null,null,0,null,"NONE"]
["K14","K14: Approaches to categorise, validate and prioritise requirements",null,null,null,null,null,null,0,null,"NONE"]
["K15","K15: The importance of requirements management including change control",null,null,null,null,null,null,0,null,"NONE"]
["K16","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"]
["K17","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"]
["K18","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"]
["K19","K19: The purpose and activities of the gap analysis process",null,null,null,null,null,null,0,null,"NONE"]
["K20","K20: The role of the business analyst in facilitating business acceptance of changes",null,null,null,null,null,null,0,null,"NONE"]
["K21","K21: The different phases of testing of business and system changes",null,null,null,null,null,null,0,null,"NONE"]
["K22","K22: The importance and the principles of engaging internal and external stakeholders",null,null,null,null,null,null,0,null,"NONE"]
["K23","K23: Techniques to support the identification and analysis of internal and external stakeholders",null,null,null,null,null,null,0,null,"NONE"]
["K24","K24: The purpose and importance of business change impact assessment",null,null,null,null,null,null,0,null,"NONE"]
["K25","K25: The concepts of benefits realisation and management",null,null,null,null,null,null,0,null,"NONE"]
["K26","K26: Legislation and industry standards relevant to the organisation and sector",null,null,null,null,null,null,0,null,"NONE"]
["K27","K27: Data protection regulations and the importance of managing information and data in line with legislation and organisational policies",null,null,null,null,null,null,0,null,"NONE"]
["K28","K28: Technology and industry trends across the digital sector, and the opportunities these bring for business improvement and IT solutions",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","S1: Apply appropriate approaches to scope, plan and perform Business Analysis",null,null,null,null,null,null,{"$f":"IF(D34:D63 = \"FULLY MET\",1,IF(D34:D63 = \"PARTIALLY MET\",0.5,IF(D34:D63 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","S2: Communicate effectively in a variety of situations with a range of stakeholders",null,null,null,null,null,null,0,null,"PARTIAL"]
["S3","S3: Apply a range of structured investigation techniques to a business situation",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4: Produce an outline definition of a business situation using an appropriate technique",null,null,null,null,null,null,0,null,"NONE"]
["S5","S5: Apply appropriate techniques to identify problems and opportunities within a business situation",null,null,null,null,null,null,0,null,"NONE"]
["S6","S6: Support the identification and presentation of proposed actions to stakeholders to gain agreement for further analysis activity",null,null,null,null,null,null,0,null,"NONE"]
["S7","S7: Apply appropriate techniques to analyse and document options and recommendations for change",null,null,null,null,null,null,0,null,"NONE"]
["S8","S8: Elicit process information from stakeholders",null,null,null,null,null,null,0,null,"NONE"]
["S9","S9: Model business processes using relevant techniques, standards, notation and software tools",null,null,null,null,null,null,0,null,"NONE"]
["S10","S10: Analyse business process models to identify opportunities for improvement",null,null,null,null,null,null,0,null,"NONE"]
["S11","S11: Produce models of redesigned business processes",null,null,null,null,null,null,0,null,"NONE"]
["S12","S12: Elicit requirements from stakeholders to identify business and user needs",null,null,null,null,null,null,0,null,"NONE"]
["S13","S13: Document clear functional and non-functional requirements in line with local standards",null,null,null,null,null,null,0,null,"NONE"]
["S14","S14: Analyse documented requirements to remove duplication, conflict and overlap",null,null,null,null,null,null,0,null,"NONE"]
["S15","S15: Prioritise requirements using an appropriate prioritisation approach",null,null,null,null,null,null,0,null,"NONE"]
["S16","S16: Validate requirements with stakeholders",null,null,null,null,null,null,0,null,"NONE"]
["S17","S17: Support the establishment of requirements traceability",null,null,null,null,null,null,0,null,"NONE"]
["S18","S18: Elicit business data needs from relevant sources",null,null,null,null,null,null,0,null,"NONE"]
["S19","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"]
["S20","S20: Document current business situations to enable gap analysis and decision making",null,null,null,null,null,null,0,null,"NONE"]
["S21","S21: Support the development of models of future state business situations",null,null,null,null,null,null,0,null,"NONE"]
["S22","S22: Identify key differences between current and future business situations",null,null,null,null,null,null,0,null,"NONE"]
["S23","S23: Identify actions required to move from the current to future business situation",null,null,null,null,null,null,0,null,"NONE"]
["S24","S24: Define acceptance criteria for business and system changes",null,null,null,null,null,null,0,null,"NONE"]
["S25","S25: Support business acceptance of business and system changes",null,null,null,null,null,null,0,null,"PARTIAL"]
["S26","S26: Apply relevant techniques to research and identify stakeholders",null,null,null,null,null,null,0,null,"PARTIAL"]
["S27","S27: Analyse and document stakeholders' areas of interest and influence",null,null,null,null,null,null,0,null,"PARTIAL"]
["S28","S28: Support the development of cost/benefit analysis for proposed business changes",null,null,null,null,null,null,0,null,"NONE"]
["S29","S29: Evaluate and document the key impacts on people, process, organisation, technology and information",null,null,null,null,null,null,0,null,"NONE"]
["S30","S30: Present information and concepts in a manner appropriate to the audience",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","B1: Act logically, analytically and objectively in a range of situations",null,null,null,null,null,null,{"$f":"IF(D65:D77 = \"FULLY MET\",1,IF(D65:D77 = \"PARTIALLY MET\",0.5,IF(D65:D77 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","B2: Apply creative thinking when problem solving",null,null,null,null,null,null,0,null,"NONE"]
["B3","B3: Work independently and collaboratively",null,null,null,null,null,null,0,null,"NONE"]
["B4","B4: Use own initiative and take responsibility appropriate to the role of Business Analyst",null,null,null,null,null,null,0,null,"PARTIAL"]
["B5","B5: Take a thorough and organised approach and plan analysis activities in line with business priorities",null,null,null,null,null,null,0,null,"PARTIAL"]
["B6","B6: Build and maintain positive working relationships with a range of people",null,null,null,null,null,null,0,null,"FULL"]
["B7","B7: Use a range of methods of communication appropriate to the situation",null,null,null,null,null,null,0,null,"NONE"]
["B8","B8: Maintain a productive, professional and secure working environment",null,null,null,null,null,null,0,null,"PARTIAL"]
["B9","B9: Aware of the wider business environment and own contribution to business objectives",null,null,null,null,null,null,0,null,"PARTIAL"]
["B10","B10: Be comfortable and confident interacting with people from technical and non-technical backgrounds",null,null,null,null,null,null,0,null,"NONE"]
["B11","B11: Tailor manner of presentation to be appropriate to the audience",null,null,null,null,null,null,0,null,"NONE"]
["B12","B12: Work flexibly and effectively as part of a multidisciplinary team throughout the full lifecycle",null,null,null,null,null,null,0,null,"NONE"]
["B13","B13: Demonstrate commitment to continuous professional development in relation to Business Analysis and the digital sector",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J77)","v":0},"Net Score",{"$f":"SUM(L5:L77)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J80/L84","v":0},"total CoE KSB coverage",{"$f":"L80/L87","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",8]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L84-L85-(L86*0.5)","v":66}]

{"sheet":"ST0118","index":4,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"Data analyst (level 4) (ST0118)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","K1: current relevant legislation and its application to the safe use of data",null,null,null,null,null,null,{"$f":"IF(D5:D19 = \"FULLY MET\",1,IF(D5:D19 = \"PARTIALLY MET\",0.5,IF(D5:D19 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","K2: organisational data and information security standards, policies and procedures relevant to data management activities",null,null,null,null,null,null,0,null,"NONE"]
["K3","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"]
["K4","K4: principles of data, including open and public data, administrative data, and research data",null,null,null,null,null,null,0,null,"NONE"]
["K5","K5: the differences between structured and unstructured data",null,null,null,null,null,null,0,null,"NONE"]
["K6","K6: the fundamentals of data structures, database system design, implementation and maintenance",null,null,null,null,null,null,0,null,"NONE"]
["K7","K7: principles of user experience and domain context for data analytics",null,null,null,null,null,null,0,null,"NONE"]
["K8","K8: quality risks inherent in data and how to mitigate/resolve these",null,null,null,null,null,null,0,null,"NONE"]
["K9","K9: principal approaches to defining customer requirements for data analysis",null,null,null,null,null,null,0,null,"NONE"]
["K10","K10: approaches to combining data from different sources",null,null,null,null,null,null,0,null,"NONE"]
["K11","K11: approaches to organisational tools and methods for data analysis",null,null,null,null,null,null,0,null,"PARTIAL"]
["K12","K12: organisational data architecture",null,null,null,null,null,null,0,null,"PARTIAL"]
["K13","K13: principles of statistics for analysing datasets",null,null,null,null,null,null,0,null,"NONE"]
["K14","K14: the principles of descriptive, predictive and prescriptive analytics",null,null,null,null,null,null,0,null,"NONE"]
["K15","K15: the ethical aspects associated with the use of and collation of data",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","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(D21:D35 = \"FULLY MET\",1,IF(D21:D35 = \"PARTIALLY MET\",0.5,IF(D21:D35 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["S2","S2 implement the stages of the data analysis lifecycle",null,null,null,null,null,null,0,null,"NONE"]
["S3","S3 apply principles of data classification within data analysis activity",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4 analyse data sets taking account of different data structures and database designs",null,null,null,null,null,null,0,null,"NONE"]
["S5","S5 assess the impact on user experience and domain context on the data analysis activity",null,null,null,null,null,null,0,null,"NONE"]
["S6","S6 identify and escalate quality risks in data analysis with suggested mitigation/resolutions as appropriate.",null,null,null,null,null,null,0,null,"NONE"]
["S7","S7 undertake customer requirements analysis and implement findings in data analytics planning and outputs",null,null,null,null,null,null,0,null,"NONE"]
["S8","S8 identify data sources and the risks, challenges to combination within data analysis activity",null,null,null,null,null,null,0,null,"NONE"]
["S9","S9 apply organizational architecture requirements to data analysis activities",null,null,null,null,null,null,0,null,"PARTIAL"]
["S10","S10 apply statistical methodologies to data analysis tasks",null,null,null,null,null,null,0,null,"NONE"]
["S11","S11 apply predictive analytics in the collation and use of data",null,null,null,null,null,null,0,null,"NONE"]
["S12","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"]
["S13","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"]
["S14","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"]
["S15","S15 select and apply the most appropriate data tools to achieve the best outcome",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","B1: maintain productive, professional and secure working environment",null,null,null,null,null,null,{"$f":"IF(D37:D43 = \"FULLY MET\",1,IF(D37:D43 = \"PARTIALLY MET\",0.5,IF(D37:D43 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","B2: shows 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"]
["B3","B3: works independently and collaboratively",null,null,null,null,null,null,0,null,"NONE"]
["B4","B4: logical and analytical",null,null,null,null,null,null,0,null,"NONE"]
["B5","B5: identifies issues quickly, enjoys investigating and solving complex problems and applies appropriate solutions. Has a strong desire to push to ensure true root cause of any problem is found and a solution is identified which prevents recurrence. the",null,null,null,null,null,null,0,null,"NONE"]
["B6","B6: demonstrates resilience by viewing obstacles as challenges and learning from failure.",null,null,null,null,null,null,0,null,"NONE"]
["B7","B7: demonstrates an ability to adapt 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"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J43)","v":0},"Net Score",{"$f":"SUM(L5:L43)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J46/L50","v":0},"total CoE KSB coverage",{"$f":"L46/L53","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",5]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L50-L51-(L52*0.5)","v":34.5}]

{"sheet":"ST0127","index":5,"n_rows":65,"n_cols":17,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,"Network engineer (level 4) (ST0127)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","K1: the causes and consequences of network and IT infrastructure failures",null,null,null,null,null,null,{"$f":"IF(D5:D25 = \"FULLY MET\",1,IF(D5:D25 = \"PARTIALLY MET\",0.5,IF(D5:D25 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","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"]
["K3","K3: the techniques for systems performance and optimisation",null,null,null,null,null,null,0,null,"NONE"]
["K4","K4: diagnostic techniques and tools to interrogate and gather information regarding systems performance",null,null,null,null,null,null,0,null,"NONE"]
["K5","K5: organizational procedures to deal with recording information effectively and in line with protocols",null,null,null,null,null,null,0,null,"PARTIAL"]
["K6","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,"PARTIAL"]
["K7","K7: their role in Business Continuity and Disaster Recovery",null,null,null,null,null,null,0,null,"PARTIAL"]
["K8","K8: the purposes and uses of ports and protocols",null,null,null,null,null,null,0,null,"NONE"]
["K9","K9: devices, applications, protocols, and services at their appropriate OSI and/or TCP/IP layers",null,null,null,null,null,null,0,null,"NONE"]
["K10","K10: the concepts and characteristics of routing and switching",null,null,null,null,null,null,0,null,"NONE"]
["K11","K11: the characteristics of network topologies, types, and technologies.",null,null,null,null,null,null,0,null,"NONE"]
["K12","K12: wireless technologies and configurations.",null,null,null,null,null,null,0,null,"NONE"]
["K13","K13: cloud concepts and their purposes.",null,null,null,null,null,null,0,null,"NONE"]
["K14","K14: functions of network services",null,null,null,null,null,null,0,null,"NONE"]
["K15","K15: the different types of network maintenance",null,null,null,null,null,null,0,null,"NONE"]
["K16","K16: how current legislation relates to or impacts occupation",null,null,null,null,null,null,0,null,"NONE"]
["K17","K17: troubleshooting methodologies for network and IT infrastructure",null,null,null,null,null,null,0,null,"NONE"]
["K18","K18: how to integrate a server into a network",null,null,null,null,null,null,0,null,"NONE"]
["K19","K19: the types of security threats to networks and IT infrastructure assets",null,null,null,null,null,null,0,null,"NONE"]
["K20","K20: how to use tools to automate network tasks",null,null,null,null,null,null,0,null,"NONE"]
["K21","K21: approaches to change management",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","S1: apply the appropriate tools and techniques when securely operating and testing Networks",null,null,null,null,null,null,{"$f":"IF(D27:D46 = \"FULLY MET\",1,IF(D27:D46 = \"PARTIALLY MET\",0.5,IF(D27:D46 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","S2: install and configure the elements required to maintain and manage a secure Network",null,null,null,null,null,null,0,null,"NONE"]
["S3","S3: implement techniques to monitor and record systems performance in line with defined specifications",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4: maintain security and performance of the system against known and standard threats",null,null,null,null,null,null,0,null,"NONE"]
["S5","S5: apply the appropriate tools and techniques to identify systems performance issues",null,null,null,null,null,null,0,null,"NONE"]
["S6","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"]
["S7","S7: communicate outcomes of tasks and record in line with organisational procedures and SLAs including adherence to good customer service standards",null,null,null,null,null,null,0,null,"FULL"]
["S8","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,"FULL"]
["S9","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,"PARTIAL"]
["S10","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"]
["S11","S11: monitor, identify and implement required maintenance procedures",null,null,null,null,null,null,0,null,"NONE"]
["S12","S12: implement techniques to optimise systems performance in line with defined specifications",null,null,null,null,null,null,0,null,"NONE"]
["S13","S13: organise and prioritise clients/stakeholders' requests in line with SLAs and organization processes",null,null,null,null,null,null,0,null,"PARTIAL"]
["S14","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,"FULL"]
["S15","S15: operate securely and apply the appropriate process, policies, and legislation within their business responsibilities",null,null,null,null,null,null,0,null,"PARTIAL"]
["S16","S16: communicate with a range of stakeholders taking into consideration of organisations cultural awareness and technical ability",null,null,null,null,null,null,0,null,"PARTIAL"]
["S17","S17: apply the appropriate level of responsibility when planning and prioritizing work tasks",null,null,null,null,null,null,0,null,"FULL"]
["S18","S18: apply the relevant numerical skills (Binary, dotted decimal notation) required to meet the defines specifications",null,null,null,null,null,null,0,null,"NONE"]
["S19","S19: ensure compliance of network engineering outputs with change management processes",null,null,null,null,null,null,0,null,"NONE"]
["S20","S20: select the appropriate tools and comply with organisation policies and processes when upgrading systems",null,null,null,null,null,null,0,null,"FULL"]
[null,"Behaviours"]
["B1","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(D48:D55 = \"FULLY MET\",1,IF(D48:D55 = \"PARTIALLY MET\",0.5,IF(D48:D55 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","B2: work securely within the business",null,null,null,null,null,null,0,null,"FULL"]
["B3","B3: work within the goals, vision, and values of the organisation",null,null,null,null,null,null,0,null,"FULL"]
["B4","B4: take a wider view of the strategic objectives of the tasks/ projects they are working on including the implications for accessibility by users and diversity.",null,null,null,null,null,null,0,null,"PARTIAL"]
["B5","B5: works to meet or exceed customers' requirements and expectations",null,null,null,null,null,null,0,null,"FULL"]
["B6","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"]
["B7","B7: Committed to continued professional development to ensure growth in professional skill and knowledge.",null,null,null,null,null,null,0,null,"NONE"]
["B8","B8: work effectively under pressure showing resilience",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J55)","v":0},"Net Score",{"$f":"SUM(L5:L55)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J58/L62","v":0},"total CoE KSB coverage",{"$f":"L58/L65","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",49]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",8]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",9]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L62-L63-(L64*0.5)","v":36.5}]

{"sheet":"ST0129","index":6,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,"Software tester (level 4) (ST0129)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","K1: the relationship between testing and quality assurance and how testing contributes to higher quality",null,null,null,null,null,null,{"$f":"IF(D5:D27 = \"FULLY MET\",1,IF(D5:D27 = \"PARTIALLY MET\",0.5,IF(D5:D27 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","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"]
["K3","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"]
["K4","K4: the need for traceability between the requirements/test basis and the test work products",null,null,null,null,null,null,0,null,"NONE"]
["K5","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"]
["K6","K6: the importance of accuracy and clear documentation of software tests and defects.",null,null,null,null,null,null,0,null,"NONE"]
["K7","K7: the relationship between test activities and software development activities in the Software Development Lifecycle.",null,null,null,null,null,null,0,null,"NONE"]
["K8","K8: the application of testing across different recognised software development methodologies (sequential and iterative)",null,null,null,null,null,null,0,null,"NONE"]
["K9","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"]
["K10","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"]
["K11","K11: the role of static testing techniques and the review process in early defect detection",null,null,null,null,null,null,0,null,"NONE"]
["K12","K12: the characteristics of Black Box, White Box and Experience-based Test Techniques",null,null,null,null,null,null,0,null,"NONE"]
["K13","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"]
["K14","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"]
["K15","K15 the defect management process",null,null,null,null,null,null,0,null,"NONE"]
["K16","K16 the typical metrics used to support the monitoring and control of testing",null,null,null,null,null,null,0,null,"NONE"]
["K17","K17 the classification of tools to support testing",null,null,null,null,null,null,0,null,"NONE"]
["K18","K18 the role of test automation in the context of the software development lifecycle",null,null,null,null,null,null,0,null,"NONE"]
["K19","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"]
["K20","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"]
["K21","K21 the characteristics of software architecture that impact on software testing in the development lifecycle",null,null,null,null,null,null,0,null,"NONE"]
["K22","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"]
["K23","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"]
[null,"Skills"]
["S1","S1: apply static test techniques",null,null,null,null,null,null,{"$f":"IF(D29:D41 = \"FULLY MET\",1,IF(D29:D41 = \"PARTIALLY MET\",0.5,IF(D29:D41 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","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"]
["S3","S3: analyse test objectives and requirements/test basis to define test scope and coverage criteria",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4: use tools to automate, manage or support any test activity.",null,null,null,null,null,null,0,null,"NONE"]
["S5","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"]
["S6","S6: use defect tracking tools",null,null,null,null,null,null,0,null,"NONE"]
["S7","S7: adapt and apply testing activities according to industry standard development methodologies (sequential and iterative).",null,null,null,null,null,null,0,null,"NONE"]
["S8","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"]
["S9","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"]
["S10","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"]
["S11","S11: maintain up to date knowledge of technological developments in the field of Software Testing",null,null,null,null,null,null,0,null,"NONE"]
["S12","S12. record and interpret test progress and results, communicating test status to the relevant stakeholders.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S13","S13. Design and follow tests to achieve coverage criteria",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","B1: maintains a productive, professional, and secure working environment",null,null,null,null,null,null,{"$f":"IF(D43:D49 = \"FULLY MET\",1,IF(D43:D49 = \"PARTIALLY MET\",0.5,IF(D43:D49 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["B2","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"]
["B3","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.",null,null,null,null,null,null,0,null,"NONE"]
["B4","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"]
["B5","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"]
["B6","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,"PARTIAL"]
["B7","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"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J49)","v":0},"Net Score",{"$f":"SUM(L5:L49)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J52/L56","v":0},"total CoE KSB coverage",{"$f":"L52/L59","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",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L56-L57-(L58*0.5)","v":41}]

{"sheet":"ST0345","index":7,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"Digital community manager (level 4) (ST0345)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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(D5:D21 = \"FULLY MET\",1,IF(D5:D21 = \"PARTIALLY MET\",0.5,IF(D5:D21 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["K2","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,"PARTIAL"]
["K3","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"]
["K4","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"]
["K5","K5: Internet forum software and content management systems.",null,null,null,null,null,null,0,null,"NONE"]
["K6","K6: Principles of data analytics and how to report findings.",null,null,null,null,null,null,0,null,"NONE"]
["K7","K7: Platform holder policies and best practice guidelines.",null,null,null,null,null,null,0,null,"NONE"]
["K8","K8: Company policy and standards.",null,null,null,null,null,null,0,null,"FULL"]
["K9","K9: Conflict management techniques and theories.",null,null,null,null,null,null,0,null,"NONE"]
["K10","K10: Demographics and how this impacts on online behaviour and communication",null,null,null,null,null,null,0,null,"NONE"]
["K11","K11: Neuro linguistic programming theory and practice",null,null,null,null,null,null,0,null,"NONE"]
["K12","K12: Understanding of best practice of community management in the relevant industry.",null,null,null,null,null,null,0,null,"NONE"]
["K13","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"]
["K14","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"]
["K15","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,"NONE"]
["K16","K16: Online security procedures as per company guidelines",null,null,null,null,null,null,0,null,"PARTIAL"]
["K17","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,"PARTIAL"]
[null,"Skills"]
["S1","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(D23:D37 = \"FULLY MET\",1,IF(D23:D37 = \"PARTIALLY MET\",0.5,IF(D23:D37 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["S2","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"]
["S3","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"]
["S4","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"]
["S5","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"]
["S6","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"]
["S7","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"]
["S8","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"]
["S9","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"]
["S10","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"]
["S11","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"]
["S12","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"]
["S13","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"]
["S14","S14: Ability to manage conflict positively.",null,null,null,null,null,null,0,null,"NONE"]
["S15","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"]
[null,"Behaviours"]
["B1","B1: Proactively stimulate and drive customer interaction with their brand.",null,null,null,null,null,null,{"$f":"IF(D39:D44 = \"FULLY MET\",1,IF(D39:D44 = \"PARTIALLY MET\",0.5,IF(D39:D44 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["B2","B2: Attention to detail and a high level of accuracy.",null,null,null,null,null,null,0,null,"NONE"]
["B3","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"]
["B4","B4: Interest in current trends and innovations in the relevant industry",null,null,null,null,null,null,0,null,"NONE"]
["B5","B5: Reliable with a high degree of professionalism",null,null,null,null,null,null,0,null,"NONE"]
["B6","B6: Maintain a positive and friendly manner.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J44)","v":0},"Net Score",{"$f":"SUM(L5:L44)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J47/L51","v":0},"total CoE KSB coverage",{"$f":"L47/L54","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",38]
[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",7]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L51-L52-(L53*0.5)","v":33.5}]

{"sheet":"ST0825","index":8,"n_rows":67,"n_cols":17,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[null,"DevOps engineer (level 4) (ST0825)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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(D5:D29 = \"FULLY MET\",1,IF(D5:D29 = \"PARTIALLY MET\",0.5,IF(D5:D29 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","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"]
["K3","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"]
["K4","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"]
["K5","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"]
["K6","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"]
["K7","K7: General purpose programming and infrastructure-as-code.",null,null,null,null,null,null,0,null,"NONE"]
["K8","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"]
["K9","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"]
["K10","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"]
["K11","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"]
["K12","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"]
["K13","K13: Automation techniques, such as scripting and use of APIs.",null,null,null,null,null,null,0,null,"NONE"]
["K14","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"]
["K15","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"]
["K16","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"]
["K17","K17: What an API is, how to find them and interpret the accompanying documentation.",null,null,null,null,null,null,0,null,"NONE"]
["K18","K18: Roles within a multidisciplinary team and the interfaces with other areas of an organisation.",null,null,null,null,null,null,0,null,"NONE"]
["K19","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"]
["K20","K20: Pair/mob programming techniques and when to use each technique.",null,null,null,null,null,null,0,null,"NONE"]
["K21","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"]
["K22","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"]
["K23","K23: The importance of continual improvement within a blameless culture.",null,null,null,null,null,null,0,null,"NONE"]
["K24","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"]
["K25","K25: Maintain an awareness of cloud certification requirements.",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","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(D31:D52 = \"FULLY MET\",1,IF(D31:D52 = \"PARTIALLY MET\",0.5,IF(D31:D52 = \"NOT MET\",0,)))","v":0},null,"PARTIAL"]
["S2","S2: Work within different organisational cultures with both internal and external parties",null,null,null,null,null,null,0,null,"FULL"]
["S3","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"]
["S4","S4: Initiate and facilitate knowledge sharing and technical collaboration",null,null,null,null,null,null,0,null,"NONE"]
["S5","S5: Deploy immutable infrastructure",null,null,null,null,null,null,0,null,"NONE"]
["S6","S6: Install, manage and troubleshoot monitoring tools",null,null,null,null,null,null,0,null,"NONE"]
["S7","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"]
["S8","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,"PARTIAL"]
["S9","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"]
["S10","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"]
["S11","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"]
["S12","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"]
["S13","S13: Engage in productive pair/mob programming.",null,null,null,null,null,null,0,null,"NONE"]
["S14","S14: Write tests and follow Test Driven Development discipline in various different contexts.",null,null,null,null,null,null,0,null,"NONE"]
["S15","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"]
["S16","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"]
["S17","S17: Code in a general purpose programming language.",null,null,null,null,null,null,0,null,"NONE"]
["S18","S18: Specify cloud infrastructure in an infrastructure-as-code domain-specific language.",null,null,null,null,null,null,0,null,"NONE"]
["S19","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"]
["S20","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"]
["S21","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"]
["S22","S22: Incremental refactoring by applying small behaviour-preserving code changes to evolve the architecture.",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","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(D54:D57 = \"FULLY MET\",1,IF(D54:D57 = \"PARTIALLY MET\",0.5,IF(D54:D57 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","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"]
["B3","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"]
["B4","B4: Is inclusive, professional and maintains a blameless culture.",null,null,null,null,null,null,0,null,"PARTIAL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J57)","v":0},"Net Score",{"$f":"SUM(L5:L57)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J60/L64","v":0},"total CoE KSB coverage",{"$f":"L60/L67","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",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",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L64-L65-(L66*0.5)","v":48.5}]

{"sheet":"ST0863","index":9,"n_rows":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[null,"Digital accessibility specialist (level 4) (ST0863)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","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(D5:D29 = \"FULLY MET\",1,IF(D5:D29 = \"PARTIALLY MET\",0.5,IF(D5:D29 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","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"]
["K3","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"]
["K4","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"]
["K5","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"]
["K6","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"]
["K7","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"]
["K8","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"]
["K9","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"]
["K10","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"]
["K11","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"]
["K12","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"]
["K13","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"]
["K14","K14: How assistive technologies interact with other digital technologies.",null,null,null,null,null,null,0,null,"NONE"]
["K15","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"]
["K16","K16: How to construct a business report (for example document layout and contents).",null,null,null,null,null,null,0,null,"NONE"]
["K17","K17: The purpose and importance of reasonable adjustments, and how these are managed.",null,null,null,null,null,null,0,null,"NONE"]
["K18","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,"PARTIAL"]
["K19","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"]
["K20","K20: How to communicate through different mediums, including tailoring communications to different user groups.",null,null,null,null,null,null,0,null,"NONE"]
["K21","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"]
["K22","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"]
["K23","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"]
["K24","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"]
["K25","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"]
[null,"Skills"]
["S1","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(D31:D48 = \"FULLY MET\",1,IF(D31:D48 = \"PARTIALLY MET\",0.5,IF(D31:D48 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","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"]
["S3","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"]
["S4","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"]
["S5","S5: Conduct workshops, surveys or focus groups, including the set-up, running and conclusion activities.",null,null,null,null,null,null,0,null,"NONE"]
["S6","S6: Both written and verbal communication skills when working as a team or individually.",null,null,null,null,null,null,0,null,"NONE"]
["S7","S7: Solve problems using a logical and analytical approach.",null,null,null,null,null,null,0,null,"NONE"]
["S8","S8: Identify appropriate assistive technologies and adaptive strategies for an individual's disability.",null,null,null,null,null,null,0,null,"NONE"]
["S9","S9: Practice disability etiquette, when communicating with individuals with disabilities.",null,null,null,null,null,null,0,null,"NONE"]
["S10","S10: Apply accessibility standards and regulations to practice.",null,null,null,null,null,null,0,null,"NONE"]
["S11","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"]
["S12","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"]
["S13","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"]
["S14","S14: Apply security best practices.",null,null,null,null,null,null,0,null,"NONE"]
["S15","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"]
["S16","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"]
["S17","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"]
["S18","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"]
[null,"Behaviours"]
["B1","B1: Motivated, empathetic and driven in the field of accessibility and the wider digital sphere.",null,null,null,null,null,null,{"$f":"IF(D50:D53 = \"FULLY MET\",1,IF(D50:D53 = \"PARTIALLY MET\",0.5,IF(D50:D53 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","B2: Proactively Inclusive.",null,null,null,null,null,null,0,null,"NONE"]
["B3","B3: Manages time effectively and adheres to timescales when producing work product.",null,null,null,null,null,null,0,null,"NONE"]
["B4","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"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J5:J53)","v":0},"Net Score",{"$f":"SUM(L5:L53)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J56/L60","v":0},"total CoE KSB coverage",{"$f":"L56/L63","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",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L60-L61-(L62*0.5)","v":46}]

{"sheet":"ST1021","index":10,"n_rows":210,"n_cols":17,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
[null,"Cyber security technologist (level 4) (ST1021)"]
[null,"Return to Guide"]
[null,"Three optrions are availale. Please choose. "]
[null,"Cyber security technologist (level 4) (ST1021) - Cyber security engineer"]
[null,"Cyber security technologist (level 4) (ST1021) - Cyber risk analyst"]
[null,"Cyber security technologist (level 4) (ST1021) - Cyber defend & respond"]
[]
[]
[null,"KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Cyber security technologist (level 4) (ST1021) - Cyber security engineer"]
[null,"This list contains the core KSBs for the Cyber security technologist occupation, plus the specific KSBs for the Cyber security engineer option. "]
[null,"Knowledge"]
["K1","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",null,null,null,null,null,null,{"$f":"IF(D13:D29 = \"FULLY MET\",1,IF(D13:D29 = \"PARTIALLY MET\",0.5,IF(D13:D29 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","K2: the concepts, main functions and features of at least three Operating Systems (OS) and their security functions and associated security features.",null,null,null,null,null,null,0,null,"NONE"]
["K3","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.",null,null,null,null,null,null,0,null,"NONE"]
["K4","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",null,null,null,null,null,null,0,null,"NONE"]
["K5","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.",null,null,null,null,null,null,0,null,"NONE"]
["K6","K6: lifecycle and service management practices to an established standard to a foundation level for example Information Technology Infrastructure Library (ITIL) foundation level.",null,null,null,null,null,null,0,null,"NONE"]
["K7","K7: cyber incident response processes, incident management processes and evidence collection/preservation requirements to support incident investigation",null,null,null,null,null,null,0,null,"NONE"]
["K8","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",null,null,null,null,null,null,0,null,"NONE"]
["K9","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.",null,null,null,null,null,null,0,null,"NONE"]
["K10","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",null,null,null,null,null,null,0,null,"NONE"]
["K11","K11: horizon scanning including use of recognised sources of threat intelligence and vulnerabilities.",null,null,null,null,null,null,0,null,"NONE"]
["K12","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",null,null,null,null,null,null,0,null,"NONE"]
["K13","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",null,null,null,null,null,null,0,null,"NONE"]
["K14","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",null,null,null,null,null,null,0,null,"NONE"]
["K15","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.",null,null,null,null,null,null,0,null,"NONE"]
["K16","K16: function and features of significant digital system components; typical architectures; common vulnerabilities in digital systems; principles and common practice in digital system security",null,null,null,null,null,null,0,null,"NONE"]
["K17","K17: programming or scripting languages",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","S1: Discover vulnerabilities in a system by using a mix of research and practical exploration",null,null,null,null,null,null,{"$f":"IF(D31:D48 = \"FULLY MET\",1,IF(D31:D48 = \"PARTIALLY MET\",0.5,IF(D31:D48 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","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",null,null,null,null,null,null,0,null,"NONE"]
["S3","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)",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4: Undertake security risk assessments for simple systems without direct supervision and propose basic remediation advice in the context of the employer.",null,null,null,null,null,null,0,null,"NONE"]
["S5","S5: Source and analyse security cases and describe what threats, vulnerability or risks are mitigated and identify any residual areas of concern.",null,null,null,null,null,null,0,null,"NONE"]
["S6","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",null,null,null,null,null,null,0,null,"PARTIAL"]
["S7","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.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S8","S8: Configure, deploy and use computer, digital network and cyber security technology.",null,null,null,null,null,null,0,null,"NONE"]
["S9","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.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S10","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.",null,null,null,null,null,null,0,null,"NONE"]
["S11","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.",null,null,null,null,null,null,0,null,"NONE"]
["S12","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",null,null,null,null,null,null,0,null,"NONE"]
["S13","S13: Write program code or scripts to meet a given design requirement in accordance with employers' coding standards",null,null,null,null,null,null,0,null,"FULL"]
["S14","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.",null,null,null,null,null,null,0,null,"NONE"]
["S15","S15: Use tools, techniques and processes to actively prevent breaches to digital system security.",null,null,null,null,null,null,0,null,"NONE"]
["S17","S17: Identify cyber security threats relevant to a defined context",null,null,null,null,null,null,0,null,"NONE"]
["S27","S27: Accurately, objectively and concisely record and report the appropriate cyber security information, including in written reports within a structure or template provided.",null,null,null,null,null,null,0,null,"NONE"]
["S28","S28: Configure digital system monitoring and analysis tools (e.g. SIEM tools), taking account of threat & vulnerability intelligence, indicators of compromise.",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","B1: Logical - 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,{"$f":"IF(D50:D59 = \"FULLY MET\",1,IF(D50:D59 = \"PARTIALLY MET\",0.5,IF(D50:D59 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","B2: Analytical - working with data effectively to see patterns, trends and draw meaningful conclusions.",null,null,null,null,null,null,0,null,"NONE"]
["B3","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",null,null,null,null,null,null,0,null,"NONE"]
["B4","B4: Shows 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"]
["B5","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",null,null,null,null,null,null,0,null,"NONE"]
["B6","B6: Works effectively with a wide range of people in different roles, internally and externally, with a regard to inclusion & diversity policy",null,null,null,null,null,null,0,null,"PARTIAL"]
["B7","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",null,null,null,null,null,null,0,null,"PARTIAL"]
["B8","B8: Maintains a productive, professional and secure working environment.",null,null,null,null,null,null,0,null,"PARTIAL"]
["B9","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",null,null,null,null,null,null,0,null,"NONE"]
["B10","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.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J13:J59)","v":0},"Net Score",{"$f":"SUM(L13:L59)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J62/L66","v":0},"total CoE KSB coverage",{"$f":"L62/L69","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",45]
[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":"L66-L67-(L68*0.5)","v":41}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Cyber security technologist (level 4) (ST1021) - Cyber risk analyst"]
[null,"This list contains the core KSBs for the Cyber security technologist occupation, plus the specific KSBs for the Cyber risk analyst option. "]
[null,"Knowledge"]
["K1","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",null,null,null,null,null,null,{"$f":"IF(D83:D99 = \"FULLY MET\",1,IF(D83:D99 = \"PARTIALLY MET\",0.5,IF(D83:D99 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","K2: the concepts, main functions and features of at least three Operating Systems (OS) and their security functions and associated security features.",null,null,null,null,null,null,0,null,"NONE"]
["K3","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.",null,null,null,null,null,null,0,null,"NONE"]
["K4","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",null,null,null,null,null,null,0,null,"NONE"]
["K5","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.",null,null,null,null,null,null,0,null,"NONE"]
["K6","K6: lifecycle and service management practices to an established standard to a foundation level for example Information Technology Infrastructure Library (ITIL) foundation level.",null,null,null,null,null,null,0,null,"NONE"]
["K7","K7: cyber incident response processes, incident management processes and evidence collection/preservation requirements to support incident investigation",null,null,null,null,null,null,0,null,"NONE"]
["K8","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",null,null,null,null,null,null,0,null,"NONE"]
["K9","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.",null,null,null,null,null,null,0,null,"NONE"]
["K10","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",null,null,null,null,null,null,0,null,"NONE"]
["K11","K11: horizon scanning including use of recognised sources of threat intelligence and vulnerabilities.",null,null,null,null,null,null,0,null,"NONE"]
["K12","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",null,null,null,null,null,null,0,null,"NONE"]
["K13","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",null,null,null,null,null,null,0,null,"NONE"]
["K14","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",null,null,null,null,null,null,0,null,"NONE"]
["K15","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.",null,null,null,null,null,null,0,null,"NONE"]
["K16","K16: function and features of significant digital system components; typical architectures; common vulnerabilities in digital systems; principles and common practice in digital system security",null,null,null,null,null,null,0,null,"NONE"]
["K17","K17: programming or scripting languages",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","S1: Discover vulnerabilities in a system by using a mix of research and practical exploration",null,null,null,null,null,null,{"$f":"IF(D101:D119 = \"FULLY MET\",1,IF(D101:D119 = \"PARTIALLY MET\",0.5,IF(D101:D119 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","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",null,null,null,null,null,null,0,null,"NONE"]
["S3","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)",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4: Undertake security risk assessments for simple systems without direct supervision and propose basic remediation advice in the context of the employer.",null,null,null,null,null,null,0,null,"NONE"]
["S5","S5: Source and analyse security cases and describe what threats, vulnerability or risks are mitigated and identify any residual areas of concern.\n\n\n",null,null,null,null,null,null,0,null,"NONE"]
["S6","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",null,null,null,null,null,null,0,null,"PARTIAL"]
["S7","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.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S8","S8: Configure, deploy and use computer, digital network and cyber security technology.",null,null,null,null,null,null,0,null,"NONE"]
["S9","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.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S13","S13: Write program code or scripts to meet a given design requirement in accordance with employers' coding standards",null,null,null,null,null,null,0,null,"FULL"]
["S16","S16: Conduct cyber-risk assessments against an externally (market) recognised cyber security standard using a recognised risk assessment methodology.",null,null,null,null,null,null,0,null,"NONE"]
["S17","S17: Identify cyber security threats relevant to a defined context",null,null,null,null,null,null,0,null,"NONE"]
["S18","S18: Develop information security policies or processes to address a set of identified risks, for example from security audit recommendations.",null,null,null,null,null,null,0,null,"NONE"]
["S19","S19: Develop information security policies within a defined scope to take account of legislation and regulation relevant to cyber security.",null,null,null,null,null,null,0,null,"NONE"]
["S20","S20: Take an active part in a security audits against recognised cyber security standards, undertake gap analysis and make recommendations for remediation..",null,null,null,null,null,null,0,null,"NONE"]
["S22","S22: Develop plans for local business continuity for approval within defined governance arrangements for business continuity.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S23","S23: Assess security culture using a recognised approach.",null,null,null,null,null,null,0,null,"NONE"]
["S24","S24: Design and implement a simple ‘security awareness’ campaign to address a specific aspect of a security culture.",null,null,null,null,null,null,0,null,"NONE"]
["S27","S27: Accurately, objectively and concisely record and report the appropriate cyber security information, including in written reports within a structure or template provided.",null,null,null,null,null,null,0,null,"NONE"]
[null,"Behaviours"]
["B1","B1: Logical - 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,{"$f":"IF(D121:D130 = \"FULLY MET\",1,IF(D121:D130 = \"PARTIALLY MET\",0.5,IF(D121:D130 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","B2: Analytical - working with data effectively to see patterns, trends and draw meaningful conclusions.",null,null,null,null,null,null,0,null,"NONE"]
["B3","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",null,null,null,null,null,null,0,null,"NONE"]
["B4","B4: Shows 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"]
["B5","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",null,null,null,null,null,null,0,null,"NONE"]
["B6","B6: Works effectively with a wide range of people in different roles, internally and externally, with a regard to inclusion & diversity policy",null,null,null,null,null,null,0,null,"PARTIAL"]
["B7","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",null,null,null,null,null,null,0,null,"PARTIAL"]
["B8","B8: Maintains a productive, professional and secure working environment.",null,null,null,null,null,null,0,null,"PARTIAL"]
["B9","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",null,null,null,null,null,null,0,null,"NONE"]
["B10","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.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J83:J130)","v":0},"Net Score",{"$f":"SUM(L83:L130)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J133/L137","v":0},"total CoE KSB coverage",{"$f":"L133/L140","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",46]
[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",7]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L137-L138-(L139*0.5)","v":41.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KSB Statement ","Detailed page/paragraph reference","KSB coverage","Evidence","Assessment method","Supporting comments/rationale","Documents Present","AB Score","IM Score","Mitigations ","CoE Score","Requirement","IM Comment","G7 QA","IM G7 Response","Conclusion"]
[null,"Cyber security technologist (level 4) (ST1021) - Cyber defend & respond"]
[null,"This list contains the core KSBs for the Cyber security technologist occupation, plus the specific KSBs for the Cyber defend & respond option. "]
[null,"Knowledge"]
["K1","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",null,null,null,null,null,null,{"$f":"IF(D154:D170 = \"FULLY MET\",1,IF(D154:D170 = \"PARTIALLY MET\",0.5,IF(D154:D170 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["K2","K2: the concepts, main functions and features of at least three Operating Systems (OS) and their security functions and associated security features.",null,null,null,null,null,null,0,null,"NONE"]
["K3","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.",null,null,null,null,null,null,0,null,"NONE"]
["K4","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",null,null,null,null,null,null,0,null,"NONE"]
["K5","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.",null,null,null,null,null,null,0,null,"NONE"]
["K6","K6: lifecycle and service management practices to an established standard to a foundation level for example Information Technology Infrastructure Library (ITIL) foundation level.",null,null,null,null,null,null,0,null,"NONE"]
["K7","K7: cyber incident response processes, incident management processes and evidence collection/preservation requirements to support incident investigation",null,null,null,null,null,null,0,null,"NONE"]
["K8","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",null,null,null,null,null,null,0,null,"NONE"]
["K9","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.",null,null,null,null,null,null,0,null,"NONE"]
["K10","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",null,null,null,null,null,null,0,null,"NONE"]
["K11","K11: horizon scanning including use of recognised sources of threat intelligence and vulnerabilities.",null,null,null,null,null,null,0,null,"NONE"]
["K12","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",null,null,null,null,null,null,0,null,"NONE"]
["K13","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",null,null,null,null,null,null,0,null,"NONE"]
["K14","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",null,null,null,null,null,null,0,null,"NONE"]
["K15","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.",null,null,null,null,null,null,0,null,"NONE"]
["K16","K16: function and features of significant digital system components; typical architectures; common vulnerabilities in digital systems; principles and common practice in digital system security",null,null,null,null,null,null,0,null,"NONE"]
["K17","K17: programming or scripting languages",null,null,null,null,null,null,0,null,"NONE"]
[null,"Skills"]
["S1","S1: Discover vulnerabilities in a system by using a mix of research and practical exploration",null,null,null,null,null,null,{"$f":"IF(D172:D189 = \"FULLY MET\",1,IF(D172:D189 = \"PARTIALLY MET\",0.5,IF(D172:D189 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["S2","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",null,null,null,null,null,null,0,null,"NONE"]
["S3","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)",null,null,null,null,null,null,0,null,"NONE"]
["S4","S4: Undertake security risk assessments for simple systems without direct supervision and propose basic remediation advice in the context of the employer.",null,null,null,null,null,null,0,null,"NONE"]
["S5","S5: Source and analyse security cases and describe what threats, vulnerability or risks are mitigated and identify any residual areas of concern.\n\n\n",null,null,null,null,null,null,0,null,"NONE"]
["S7","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.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S8","S8: Configure, deploy and use computer, digital network and cyber security technology.",null,null,null,null,null,null,0,null,"NONE"]
["S9","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.",null,null,null,null,null,null,0,null,"PARTIAL"]
["S13","S13: Write program code or scripts to meet a given design requirement in accordance with employers' coding standards",null,null,null,null,null,null,0,null,"FULL"]
["S15","S15: Use tools, techniques and processes to actively prevent breaches to digital system security.",null,null,null,null,null,null,0,null,"NONE"]
["S17","S17: Identify cyber security threats relevant to a defined context",null,null,null,null,null,null,0,null,"NONE"]
["S21","S21: Develop plans for incident response for approval within defined governance arrangements for incident response.",null,null,null,null,null,null,0,null,"NONE"]
["S25","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",null,null,null,null,null,null,0,null,"NONE"]
["S26","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.",null,null,null,null,null,null,0,null,"NONE"]
["S27","S27: Accurately, objectively and concisely record and report the appropriate cyber security information, including in written reports within a structure or template provided.",null,null,null,null,null,null,0,null,"NONE"]
["S28","S28: Configure digital system monitoring and analysis tools (e.g. SIEM tools), taking account of threat & vulnerability intelligence, indicators of compromise.",null,null,null,null,null,null,0,null,"NONE"]
["S29","S29: Undertake root cause analysis of events and make recommendations to reduce false positives and false negatives.",null,null,null,null,null,null,0,null,"NONE"]
["S30","S30: Manage local response to non-major incidents in accordance with a defined procedure.",null,null,null,null,null,null,0,null,"PARTIAL"]
[null,"Behaviours"]
["B1","B1: Logical - 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,{"$f":"IF(D191:D200 = \"FULLY MET\",1,IF(D191:D200 = \"PARTIALLY MET\",0.5,IF(D191:D200 = \"NOT MET\",0,)))","v":0},null,"NONE"]
["B2","B2: Analytical - working with data effectively to see patterns, trends and draw meaningful conclusions.",null,null,null,null,null,null,0,null,"NONE"]
["B3","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",null,null,null,null,null,null,0,null,"NONE"]
["B4","B4: Shows 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"]
["B5","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",null,null,null,null,null,null,0,null,"NONE"]
["B6","B6: Works effectively with a wide range of people in different roles, internally and externally, with a regard to inclusion & diversity policy",null,null,null,null,null,null,0,null,"PARTIAL"]
["B7","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",null,null,null,null,null,null,0,null,"PARTIAL"]
["B8","B8: Maintains a productive, professional and secure working environment.",null,null,null,null,null,null,0,null,"PARTIAL"]
["B9","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",null,null,null,null,null,null,0,null,"NONE"]
["B10","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.",null,null,null,null,null,null,0,null,"NONE"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J154:J200)","v":0},"Net Score",{"$f":"SUM(L154:L200)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J203/L207","v":0},"total CoE KSB coverage",{"$f":"L203/L210","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",45]
[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":"L207-L208-(L209*0.5)","v":41}]

{"sheet":"Source filters ","index":11,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Additional content","YES","Standard 1","FULLY MET",null,"PARTIAL"]
["ST0116","NO","Standard 2","PARTIALLY MET",null,"FULL"]
["ST0117",null,"Standard 3","NOT MET "]
["ST0118",null,"Standard 4"]
["ST1021",null,"Standard 5"]
["ST0127",null,"Standard 6"]
["ST0129",null,"NO COVERAGE "]
["ST0345"]
["ST0825"]
["ST0863",null,"Provider setting (e.g. classroom)"]
[null,null,"Online"]
[null,null,"Distance"]
[null,null,"Placement"]
[null,null,"Mixed"]
[]
[]
[]
[]
[]
[]
[]
[]
["Year 1"]
["Year 2"]
["Year 3"]
["Year 4"]
["Across years"]
["Core "]
["Option"]
[]
["Yes"]
["No"]
[]
[4]
[5]
[]
[]
[null,null,null,null,null,null,null,null,"Business analyst (level 4) (ST0117)"]
[null,null,null,null,null,null,null,null,"Cyber-security technologist (level 4) (ST0124)"]
[null,null,null,null,null,null,null,null,"Data analyst (level 4) (ST0118)"]
[null,null,null,null,null,null,null,null,"DevOps engineer (level 4) (ST0825)"]
[null,null,null,null,null,null,null,null,"Digital accessibility specialist (level 4) (ST0863)"]
[null,null,null,null,null,null,null,null,"Digital community manager (level 4) (ST0345)"]
[null,null,null,null,null,null,null,null,"Network engineer (level 4) (ST0127)"]
[null,null,null,null,null,null,null,null,"Software developer (level 4) (ST0116)"]
[null,null,null,null,null,null,null,null,"Software tester (level 4) (ST0129)"]