{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["GUIDE TO KSB MAPPING","ST0004","ST0180","ST0241","ST0587","ST0869","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"ST0004","index":1,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Actuarial technician (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Mathematics and statistics that underpin actuarial work.",null,null,null,null,null,null,{"$f":"IF(C22:C38 = \"FULLY MET\",1,IF(C22:C38 = \"PARTIALLY MET\",0.5,IF(C22:C38 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Actuarial techniques including relevant finance and financial mathematics, cashflow models, compound interest and discounting, annuities, basics of investments and associated risks.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Actuarial processes and principles including the impact of the various actuarial concepts, models and approaches, for example: how changing the assumptions into a model affects the output.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4"," Approaches to software used by actuaries including how software, technology and tools can be used to provide answers and solutions to clients.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Regulation and legislation related to the handling of data and information including GDPR.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Cyber security principles, risks and vulnerabilities when working online.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Awareness of the wider commercial actuarial landscape including the Financial Services Market, sustainability and climate change and its effects on the actuarial profession, and the need for the organisation to benefit financially from the services offered.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Awareness of the regulatory environment relevant to the actuarial profession and the organisation such as anti-money laundering regulations and those relevant to their organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Awareness of actuarial professional standards and ethics including the Actuaries’ Code.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Awareness of the importance of commercial sensitivity in their work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11"," Approaches to providing external or internal service to agreed timescales and identifying stakeholder requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Approaches to collaborative working such as use of digital collaborative tools.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Principles of maintaining internal documentation to ensure a clear and identifiable audit trail of decision making and analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Approaches to prioritisation of workloads.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Principles of data analysis including approaches to obtaining, analysing, modelling and interpreting data to solve actuarial challenges.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Data visualisation techniques for example producing graphs or charts appropriate to the audience.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Approaches and techniques to problem solving.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Obtain, analyse, model and interpret data to solve actuarial challenges and meet stakeholder objectives.",null,null,null,null,null,null,{"$f":"IF(C40:C49 = \"FULLY MET\",1,IF(C40:C49 = \"PARTIALLY MET\",0.5,IF(C40:C49 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J40=1,1,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=1,\"NONE\",IF(L40=0.5,\"PARTIAL\",IF(L40=0,\"FULL\")))","v":"FULL"}]
["S2","Analyse and logically apply actuarial techniques to given requirements and understand actuarial principles and calculations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Plan and deliver actuarial tasks such as analysis and calculations within the required timescales.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Adapt to new requests or unforeseen events to maintain delivery of actuarial tasks.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J43=1,0.5,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},{"$f":"IF(L43=0.5,\"NONE\",IF(L43=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Develop and maintain stakeholder relationships through providing a responsive service.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J44=1,0.5,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},"PARTIAL"]
["S6","Identify internal stakeholder requirements and manage expectations as necessary.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"FULL"}]
["S7","Use digital applications and software to deliver data analysis, data visualisations and mathematical models to assist in actuarial tasks.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Use digital technologies safely and securely to protect the organisation from risks such as cyber-threats and data breaches.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Tailor communication techniques for different stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Maintain internal documentation to ensure a clear and identifiable audit trail of decision making and analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Collaborative mindset. Sharing information, effectively building on the ideas of others and proactively seeking work to support other members of the actuarial and non-actuarial team.",null,null,null,null,null,null,{"$f":"IF(C51:C54 = \"FULLY MET\",1,IF(C51:C54 = \"PARTIALLY MET\",0.5,IF(C51:C54 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
["B2","Professional. A role model for positive behaviours both understanding and complying with the principles of the Actuaries’ Code.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Problem solver. A logical thinker engaging with problems to solve them through a variety of techniques and approaches.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Inclusive mindset - considers approaches to equality, diversity and inclusion both when working with stakeholders and within teams.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J54)","v":0},"Net Score",{"$f":"SUM(L22:L54)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J57/L61","v":0},"total CoE KSB coverage",{"$f":"L57/L64","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",31]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L61-L62-(L63*0.5)","v":30}]

{"sheet":"ST0180","index":2,"n_rows":84,"n_cols":18,"rows_kept":84,"cut":false,"hidden":false,"merged":[[70,0,70,6],[72,0,72,6],[40,0,40,6],[46,0,46,6],[51,0,51,6],[55,0,55,6],[61,0,61,6],[67,0,67,6],[35,0,35,6],[9,0,9,6],[21,0,21,6],[26,0,26,6],[29,0,29,6],[31,0,31,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Investment operations specialist (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["Industry and company understanding"]
["K1","Sound understanding of the structure of the Financial Services industry and in particular the role and purpose of markets and the process of investing.",null,null,null,null,null,null,{"$f":"IF(C23:C26 = \"FULLY MET\",1,IF(C23:C26 = \"PARTIALLY MET\",0.5,IF(C23:C26 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K2","The role of the function in which they work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","How this role relates to other functions within their department and to the wider business.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Deeper knowledge of specific markets and supporting operational protocols as required by the employing organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Regulatory and compliance"]
["K5","Sound understanding of the Financial Services regulatory framework and ethics, and the ability to apply relevant rules and principles to their own role and within their team.",null,null,null,null,null,null,{"$f":"IF(C28:C29 = \"FULLY MET\",1,IF(C28:C29 = \"PARTIALLY MET\",0.5,IF(C28:C29 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J28=1,1,IF(J28=0.5,0.5,IF(J28=0,0)))","v":0},{"$f":"IF(L28=1,\"NONE\",IF(L28=0.5,\"PARTIAL\",IF(L28=0,\"FULL\")))","v":"FULL"}]
["K6","Able to identify and communicate risks to the relevant management or compliance personnel within the organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Products"]
["K7","Sound understanding of the technical, investment and settlement characteristics of the main investment products, instruments, currencies and markets, including derivative instruments and complex products. Understands how an investment instrument or product is typically used within the industry and how it may meet specified client objectives.",null,null,null,null,null,null,{"$f":"IF(C31 = \"FULLY MET\",1,IF(C31 = \"PARTIALLY MET\",0.5,IF(C31 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J31=1,1,IF(J31=0.5,0.5,IF(J31=0,0)))","v":0},{"$f":"IF(L31=1,\"NONE\",IF(L31=0.5,\"PARTIAL\",IF(L31=0,\"FULL\")))","v":"FULL"}]
["Systems and processes"]
["K8","Proficient in the IT skills, systems and processes required to deliver consistent outcomes. Aware of how these support and fit within the wider business and the sector.",null,null,null,null,null,null,{"$f":"IF(C33:C35 = \"FULLY MET\",1,IF(C33:C35 = \"PARTIALLY MET\",0.5,IF(C33:C35 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J33=1,1,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},{"$f":"IF(L33=1,\"NONE\",IF(L33=0.5,\"PARTIAL\",IF(L33=0,\"FULL\")))","v":"FULL"}]
["K9","Understands the types of risks that may arise through operational activities and how these risks can be mitigated.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Can utilise complex processes and multiple systems as required.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Client Service and Relationships"]
["K11","Communicates effectively and professionally with clients, external counterparties and internal staff.",null,null,null,null,null,null,{"$f":"IF(C37:C39 = \"FULLY MET\",1,IF(C37:C39 = \"PARTIALLY MET\",0.5,IF(C37:C39 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J37=1,1,IF(J37=0.5,0.5,IF(J37=0,0)))","v":0},{"$f":"IF(L37=1,\"NONE\",IF(L37=0.5,\"PARTIAL\",IF(L37=0,\"FULL\")))","v":"FULL"}]
["K12","Adheres to internal standards, market protocol and regulatory rules and principles for reporting purposes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Understands the relationships and service requirements between markets, clients and their intermediaries.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["Service delivery"]
["S1","Maintains a consistently high standard of service internally, towards clients and with intermediaries.",null,null,null,null,null,null,{"$f":"IF(C42:C46 = \"FULLY MET\",1,IF(C42:C46 = \"PARTIALLY MET\",0.5,IF(C42:C46 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J42=1,0.5,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=0.5,\"NONE\",IF(L42=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Adheres to well defined timeframes, systems and processes.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J43=1,1,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},{"$f":"IF(L43=1,\"NONE\",IF(L43=0.5,\"PARTIAL\",IF(L43=0,\"FULL\")))","v":"FULL"}]
["S3","Consistently attentive to accuracy, detail and timeliness; meets required risk, regulatory and governance requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Performs tasks which may be complex, specialised, or non-routine, such as bespoke (OTC) derivative settlement and margin calculations, monitoring and processing these complex transactions through to completion.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Preparing management, investment performance or review reports for internal and external clients.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Communicating and Influencing "]
["S6","Adopts high quality written and verbal communication skills as appropriate for communicating with internal and external clients.",null,null,null,null,null,null,{"$f":"IF(C48:C51 = \"FULLY MET\",1,IF(C48:C51 = \"PARTIALLY MET\",0.5,IF(C48:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["S7","Builds positive relationships with clients and colleagues using sound interpersonal and influencing skills.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Able to coach/train less experienced colleagues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Able to communicate and negotiate complex situations and issues that may arise.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Team working & collaboration"]
["S10","Consistently supports colleagues and the wider business, collaborating to achieve results. Aware of their role within team, how their team fits within the business and how the team’s decisions impacts on others.",null,null,null,null,null,null,{"$f":"IF(C53:C55 = \"FULLY MET\",1,IF(C53:C55 = \"PARTIALLY MET\",0.5,IF(C53:C55 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J53=1,0.5,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=0.5,\"NONE\",IF(L53=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S11","Takes a leadership role in the team when appropriate.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=1,\"NONE\",IF(L54=0.5,\"PARTIAL\",IF(L54=0,\"FULL\")))","v":"FULL"}]
["S12","Operates well under time pressure.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Ownership & Initiative"]
["S13","Takes ownership for delivery in their area of responsibility, both for the core role and for developing and implementing changes.",null,null,null,null,null,null,{"$f":"IF(C57:C61 = \"FULLY MET\",1,IF(C57:C61 = \"PARTIALLY MET\",0.5,IF(C57:C61 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J57=1,1,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=1,\"NONE\",IF(L57=0.5,\"PARTIAL\",IF(L57=0,\"FULL\")))","v":"FULL"}]
["S14","Able to exercise autonomy and judgement within fairly broad parameters.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Finds effective ways to resolve issues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Escalates decisions and issues when necessary. ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Capable of resolving complex issues that may involve other business areas.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Personal development"]
["S18","Proactively plans and records their own development.",null,null,null,null,null,null,{"$f":"IF(C63:C66 = \"FULLY MET\",1,IF(C63:C66 = \"PARTIALLY MET\",0.5,IF(C63:C66 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J63=1,1,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},{"$f":"IF(L63=1,\"NONE\",IF(L63=0.5,\"PARTIAL\",IF(L63=0,\"FULL\")))","v":"FULL"}]
["S19","Seeks constructive feedback and incorporates within development plan; ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Keeps up to date with changes in all areas of the role; ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Shows commitment to the job and the industry.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["Honesty & Integrity"]
["B1","Truthful, sincere in their actions and does the right thing (even when not the easiest).",null,null,null,null,null,null,{"$f":"IF(C69:C70 = \"FULLY MET\",1,IF(C69:C70 = \"PARTIALLY MET\",0.5,IF(C69:C70 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"}]
["B2","Handles client information confidentially.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
["B3","Willing to accept changing priorities and work patterns when new jobs need to be done, or when requirements change.",null,null,null,null,null,null,{"$f":"IF(C72 = \"FULLY MET\",1,IF(C72 = \"PARTIALLY MET\",0.5,IF(C72 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J72=1,1,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=1,\"NONE\",IF(L72=0.5,\"PARTIAL\",IF(L72=0,\"FULL\")))","v":"FULL"}]
[]
["B4","Shows drive and energy in their work, when things are going well and when challenges arise",null,null,null,null,null,null,{"$f":"IF(C74 = \"FULLY MET\",1,IF(C74 = \"PARTIALLY MET\",0.5,IF(C74 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J74=1,1,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=1,\"NONE\",IF(L74=0.5,\"PARTIAL\",IF(L74=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J74)","v":0},"Net Score",{"$f":"SUM(L23:L74)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J77/L81","v":0},"total CoE KSB coverage",{"$f":"L77/L84","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",38]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L81-L82-(L83*0.5)","v":37}]

{"sheet":"ST0241","index":3,"n_rows":77,"n_cols":18,"rows_kept":77,"cut":false,"hidden":false,"merged":[[9,0,9,6],[21,0,21,6],[23,0,23,6],[26,0,26,6],[30,0,30,6],[55,0,55,6],[59,0,59,6],[62,0,62,6],[64,0,64,6],[28,0,28,6],[37,0,37,6],[41,0,41,6],[46,0,46,6],[49,0,49,6],[52,0,52,6],[34,0,34,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Insurance professional (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["Insurance market"]
["K1","A comprehensive understanding of the insurance market and the available products and services.",null,null,null,null,null,null,{"$f":"IF(C23 = \"FULLY MET\",1,IF(C23 = \"PARTIALLY MET\",0.5,IF(C23 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["Risk and Regulatory"]
["K2","A comprehensive understanding of the Financial Services legal and regulatory framework and organisational policies and procedures to ensure compliance.",null,null,null,null,null,null,{"$f":"IF(C25:C26 = \"FULLY MET\",1,IF(C25:C26 = \"PARTIALLY MET\",0.5,IF(C25:C26 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J25=1,1,IF(J25=0.5,0.5,IF(J25=0,0)))","v":0},{"$f":"IF(L25=1,\"NONE\",IF(L25=0.5,\"PARTIAL\",IF(L25=0,\"FULL\")))","v":"FULL"}]
["K3","Demonstrates an understanding of how a range of situations may be affected by legal and insurance principles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Clients and Colleagues"]
["K4","An understanding of the importance of being proactive in developing the relationships and networks required to be successful in the role, whilst achieving business objectives and ensuring that client needs are met.",null,null,null,null,null,null,{"$f":"IF(C28 = \"FULLY MET\",1,IF(C28 = \"PARTIALLY MET\",0.5,IF(C28 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J28=1,1,IF(J28=0.5,0.5,IF(J28=0,0)))","v":0},{"$f":"IF(L28=1,\"NONE\",IF(L28=0.5,\"PARTIAL\",IF(L28=0,\"FULL\")))","v":"FULL"}]
["Processes and Procedures"]
["K5","A  clear  understanding  of  the  processes  and  procedures  relevant  to  the  technical requirements of the role and their impact on the wider organisation and industry.",null,null,null,null,null,null,{"$f":"IF(C30 = \"FULLY MET\",1,IF(C30 = \"PARTIALLY MET\",0.5,IF(C30 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J30=1,1,IF(J30=0.5,0.5,IF(J30=0,0)))","v":0},{"$f":"IF(L30=1,\"NONE\",IF(L30=0.5,\"PARTIAL\",IF(L30=0,\"FULL\")))","v":"FULL"}]
["Commercial Awareness"]
["K6","An understanding of the impact of change within the insurance market and how it affects  the role and the wider organisation. ",null,null,null,null,null,null,{"$f":"IF(C32:C33 = \"FULLY MET\",1,IF(C32:C33 = \"PARTIALLY MET\",0.5,IF(C32:C33 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J32=1,1,IF(J32=0.5,0.5,IF(J32=0,0)))","v":0},{"$f":"IF(L32=1,\"NONE\",IF(L32=0.5,\"PARTIAL\",IF(L32=0,\"FULL\")))","v":"FULL"}]
["K7","Understands and can differentiate between the organisation’s short, medium and long term business objectives.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["Technical Ability"]
["S1","Ability to apply technical knowledge and experience to deliver positive outcomes to all stakeholders utilising appropriate policies and procedures.",null,null,null,null,null,null,{"$f":"IF(C36:C37 = \"FULLY MET\",1,IF(C36:C37 = \"PARTIALLY MET\",0.5,IF(C36:C37 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J36=1,0.5,IF(J36=0.5,0.5,IF(J36=0,0)))","v":0},{"$f":"IF(L36=0.5,\"NONE\",IF(L36=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Ability to apply legal and insurance principles, knowledge of the market structure and its processes, procedures and documentation to a range of complex situations.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J37=1,1,IF(J37=0.5,0.5,IF(J37=0,0)))","v":0},{"$f":"IF(L37=1,\"NONE\",IF(L37=0.5,\"PARTIAL\",IF(L37=0,\"FULL\")))","v":"FULL"}]
["Relationship Development"]
["S3","Can proactively identify, generate and develop relationships and networks that support the role, including but not limited to internal/external/market led/professional and peer relationships.",null,null,null,null,null,null,{"$f":"IF(C39:C41 = \"FULLY MET\",1,IF(C39:C41 = \"PARTIALLY MET\",0.5,IF(C39:C41 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J39=1,0.5,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=0.5,\"NONE\",IF(L39=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S4","Can leverage relationships to improve the reliability of customer service based on customer feedback.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J40=1,0.5,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=0.5,\"NONE\",IF(L40=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Engages with and supports colleagues so that they are empowered to resolve customers issues within organisational guidelines.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J41=1,1,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=1,\"NONE\",IF(L41=0.5,\"PARTIAL\",IF(L41=0,\"FULL\")))","v":"FULL"}]
["Ownership and Initiative"]
["S6","Takes ownership for delivering in their area of responsibility.",null,null,null,null,null,null,{"$f":"IF(C43:C46 = \"FULLY MET\",1,IF(C43:C46 = \"PARTIALLY MET\",0.5,IF(C43:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J43=1,1,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},{"$f":"IF(L43=1,\"NONE\",IF(L43=0.5,\"PARTIAL\",IF(L43=0,\"FULL\")))","v":"FULL"}]
["S7","Finds ways to progress and meet commitments when issues arise, being creative where appropriate.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Escalates issues and decisions where necessary.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J45=1,0.5,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=0.5,\"NONE\",IF(L45=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Identifies and proposes business process improvements .",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J46=1,1,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=1,\"NONE\",IF(L46=0.5,\"PARTIAL\",IF(L46=0,\"FULL\")))","v":"FULL"}]
["Governance"]
["S10","Applies legal and regulatory requirements to work compliantly, whilst promoting a culture of treating customers fairly.",null,null,null,null,null,null,{"$f":"IF(C48:C49 = \"FULLY MET\",1,IF(C48:C49 = \"PARTIALLY MET\",0.5,IF(C48:C49 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["S11","Assesses whether organisational processes and procedures and those that follow them are compliant with legal and regulatory requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Advice and support"]
["S12","Provides technical advice and support to others on complex insurance matters.",null,null,null,null,null,null,{"$f":"IF(C51 = \"FULLY MET\",1,IF(C51 = \"PARTIALLY MET\",0.5,IF(C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["Drive to excel"]
["B1","An understanding of own and company performance measures and the application of this knowledge to contribute positively to key business objectives.",null,null,null,null,null,null,{"$f":"IF(C54:C55 = \"FULLY MET\",1,IF(C54:C55 = \"PARTIALLY MET\",0.5,IF(C54:C55 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=1,\"NONE\",IF(L54=0.5,\"PARTIAL\",IF(L54=0,\"FULL\")))","v":"FULL"}]
["B2","Shares own knowledge and experience to support others to achieve personal and business objectives.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Communication"]
["B3","Adapts communication and resources to take account of the target audience including less experienced colleagues. ",null,null,null,null,null,null,{"$f":"IF(C57:C59 = \"FULLY MET\",1,IF(C57:C59 = \"PARTIALLY MET\",0.5,IF(C57:C59 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J57=1,1,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=1,\"NONE\",IF(L57=0.5,\"PARTIAL\",IF(L57=0,\"FULL\")))","v":"FULL"}]
["B4","Presents information accurately and effectively using more complex communication methods such as reports and presentations. ",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Communicates using the necessary technical language but articulates this in a way that others can understand.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Personal Accountability"]
["B6","Acts using own initiative to accomplish objectives and seeks alternatives when barriers arise. ",null,null,null,null,null,null,{"$f":"IF(C61:C62 = \"FULLY MET\",1,IF(C61:C62 = \"PARTIALLY MET\",0.5,IF(C61:C62 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J61=1,1,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=1,\"NONE\",IF(L61=0.5,\"PARTIAL\",IF(L61=0,\"FULL\")))","v":"FULL"}]
["B7","Tenacious in finding the best solutions, demonstrating commitment to the role and the Insurance Industry.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Innovation"]
["B8","Proactively able to challenge the status quo by considering the feasibility of suggested ideas and improvement considering the impact they may have on business objectives.",null,null,null,null,null,null,{"$f":"IF(C64 = \"FULLY MET\",1,IF(C64 = \"PARTIALLY MET\",0.5,IF(C64 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["Professionalism"]
["B9","Truthful, sincere in their actions (even when not the easiest) and demonstrates Utmost Good faith. ",null,null,null,null,null,null,{"$f":"IF(C66:C67 = \"FULLY MET\",1,IF(C66:C67 = \"PARTIALLY MET\",0.5,IF(C66:C67 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"}]
["B10","Demonstrates role model behaviour in approach to colleagues, clients and partners.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J67)","v":0},"Net Score",{"$f":"SUM(L23:L67)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J70/L74","v":0},"total CoE KSB coverage",{"$f":"L70/L77","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",29]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L74-L75-(L76*0.5)","v":27}]

{"sheet":"ST0587","index":4,"n_rows":77,"n_cols":18,"rows_kept":77,"cut":false,"hidden":false,"merged":[[64,0,64,6],[50,0,50,6],[53,0,53,6],[57,0,57,6],[60,0,60,6],[62,0,62,6],[36,0,36,6],[38,0,38,6],[43,0,43,6],[45,0,45,6],[48,0,48,6],[9,0,9,6],[21,0,21,6],[23,0,23,6],[27,0,27,6],[31,0,31,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Internal Audit Practitioner (Level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["Commercial Awareness"]
["K1","IAPracs will understand the internal (operational transactions of the organisation/business area being audited) and external (political, commercial, economic, social, cultural, technological, legislative, environmental) environment of the organisation being audited.",null,null,null,null,null,null,{"$f":"IF(C23 = \"FULLY MET\",1,IF(C23 = \"PARTIALLY MET\",0.5,IF(C23 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["Corporate Governance and Risk Management"]
["K2","IAPracs will demonstrate an awareness of the characteristics of good corporate governance and risk management, and the role of Internal Audit, and ",null,null,null,null,null,null,{"$f":"IF(C25:C27 = \"FULLY MET\",1,IF(C25:C27 = \"PARTIALLY MET\",0.5,IF(C25:C27 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J25=1,1,IF(J25=0.5,0.5,IF(J25=0,0)))","v":0},"FULL"]
["K3","Will be able to assess the contribution they make to organisational effectiveness and assurance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","IAPracs will be expected to work with IAProfs in the audit of more complex topics, e.g. culture, risk management, strategy, fraud prevention.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Organisational Business Processes"]
["K5","IAPracs will have an understanding of their organisation’s strategy and success measures, and be cognisant of how their work contributes to the success of the function/organisation’s industry.",null,null,null,null,null,null,{"$f":"IF(C29:C31 = \"FULLY MET\",1,IF(C29:C31 = \"PARTIALLY MET\",0.5,IF(C29:C31 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J29=1,1,IF(J29=0.5,0.5,IF(J29=0,0)))","v":0},"FULL"]
["K6","They will also understand the risk and control implications of different organisational structures, business processes and IT Systems, and how these relate to specific audit work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","IAPracs will know where to find relevant internal policy, processes and standards relevant to business area being audited and external regulation/legislation which might impact the organisation.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J31=1,0.5,IF(J31=0.5,0.5,IF(J31=0,0)))","v":0},{"$f":"IF(L31=0.5,\"NONE\",IF(L31=0,\"PARTIAL\"))","v":"PARTIAL"}]
["Risk and Control / Audit Methodology\t"]
["K8","IAPracs will know the different types of controls, management control techniques, and internal control framework characteristics (e.g. Committee Organisations Sponsoring Treadway Commission (COSO), International Standards Organisation (ISO), Control Objectives for Information & Related Technologies (COBIT)) used within their organisation and industry.",null,null,null,null,null,null,{"$f":"IF(C33:C35 = \"FULLY MET\",1,IF(C33:C35 = \"PARTIALLY MET\",0.5,IF(C33:C35 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J33=1,1,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},{"$f":"IF(L33=1,\"NONE\",IF(L33=0.5,\"PARTIAL\",IF(L33=0,\"FULL\")))","v":"FULL"}]
["K9","IAPracs will demonstrate an understanding of how to apply internal auditing methodologies and standards throughout all stages of an internal audit assignment and",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Will contribute to changes/updates to the Internal Audit manual based on internal audits undertaken and on an appreciation of what is and isn’t working for the organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["Building Relationships"]
["S1","IAPracs will build sustainable relationships based on trust and respect, within their function and with stakeholders, on an audit by audit basis. This will drive two-way communication with the business being audited to inform the audit plan, support plan changes and aid Internal Audit’s understanding of the risk profile of the business, how the policy, processes and standards in an organisation are being applied by the business as detailed during process mapping, i.e. the walkthrough process.",null,null,null,null,null,null,{"$f":"IF(C38 = \"FULLY MET\",1,IF(C38 = \"PARTIALLY MET\",0.5,IF(C38 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J38=1,0.5,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=0.5,\"NONE\",IF(L38=0,\"PARTIAL\"))","v":"PARTIAL"}]
["Communication"]
["S2","IAPracs will communicate clearly and succinctly both verbally and in writing. ",null,null,null,null,null,null,{"$f":"IF(C40:C43 = \"FULLY MET\",1,IF(C40:C43 = \"PARTIALLY MET\",0.5,IF(C40:C43 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J40=1,1,IF(J40=0.5,0.5,IF(J40=0,0)))","v":0},{"$f":"IF(L40=1,\"NONE\",IF(L40=0.5,\"PARTIAL\",IF(L40=0,\"FULL\")))","v":"FULL"}]
["S3","IAPracs will adapt their communication style to suit different situations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","IAPracs will promote open communication, demonstrating the ability to apply appropriate interview techniques during delivery of their audit work and effectively articulating findings to IAProfs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","IAPracs will be able to effectively contribute to meetings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Collaboration"]
["S6","IAPracs will collaborate effectively with other audit colleagues to gain understanding and insights to inform audits and gather data to deliver results, and will be team players.",null,null,null,null,null,null,{"$f":"IF(C45 = \"FULLY MET\",1,IF(C45 = \"PARTIALLY MET\",0.5,IF(C45 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"FULL"}]
["Data Analysis"]
["S7","With guidance, IAPracs will select and use tools/techniques to obtain relevant data/information for specific audit assignments.",null,null,null,null,null,null,{"$f":"IF(C47:C48 = \"FULLY MET\",1,IF(C47:C48 = \"PARTIALLY MET\",0.5,IF(C47:C48 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J47=1,1,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},{"$f":"IF(L47=1,\"NONE\",IF(L47=0.5,\"PARTIAL\",IF(L47=0,\"FULL\")))","v":"FULL"}]
["S8","IAPracs will apply sampling, data analysis and other statistical techniques to analyse and assess data and draw preliminary conclusions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Time Management"]
["S18","IAPracs will manage their time effectively to deliver high quality work within appropriate timelines to deliver their audit assignments and other work requirements.",null,null,null,null,null,null,{"$f":"IF(C50 = \"FULLY MET\",1,IF(C50 = \"PARTIALLY MET\",0.5,IF(C50 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"}]
["Systems and IT Skills"]
["S10","IAPracs will be proficient in the use appropriate business systems and software e.g. sending emails, using word processing and spreadsheet software, documenting workpapers using organisation’s appropriate audit systems etc.",null,null,null,null,null,null,{"$f":"IF(C52 = \"FULLY MET\",1,IF(C52 = \"PARTIALLY MET\",0.5,IF(C52 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J52=1,1,IF(J52=0.5,0.5,IF(J52=0,0)))","v":0},{"$f":"IF(L52=1,\"NONE\",IF(L52=0.5,\"PARTIAL\",IF(L52=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["Ethics and Integrity"]
["B1","IAPracs will act with integrity to their profession and the ethical code of conduct of their organisation/auditee, ",null,null,null,null,null,null,{"$f":"IF(C55:C57 = \"FULLY MET\",1,IF(C55:C57 = \"PARTIALLY MET\",0.5,IF(C55:C57 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J55=1,1,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=1,\"NONE\",IF(L55=0.5,\"PARTIAL\",IF(L55=0,\"FULL\")))","v":"FULL"}]
["B2","Will demonstrate organisational values in how they work, and",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Will demonstrate confidentiality, independence and objectivity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Add Value/Continuous Improvement"]
["B4","IAPracs will add value to the organisation/department they are auditing by proactively sharing issues identified during the course of their audit work with their line manager.",null,null,null,null,null,null,{"$f":"IF(C59:C60 = \"FULLY MET\",1,IF(C59:C60 = \"PARTIALLY MET\",0.5,IF(C59:C60 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J59=1,1,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=1,\"NONE\",IF(L59=0.5,\"PARTIAL\",IF(L59=0,\"FULL\")))","v":"FULL"}]
["B5","IAPracs will support the continuous improvement of the risk and control environment of the organisation/business being audited by suggesting new ideas.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["Professional Development"]
["B6","IAPracs will take responsibility for their own professional development by seeking out opportunities to learn and grow.",null,null,null,null,null,null,{"$f":"IF(C62 = \"FULLY MET\",1,IF(C62 = \"PARTIALLY MET\",0.5,IF(C62 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J62=1,1,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=1,\"NONE\",IF(L62=0.5,\"PARTIAL\",IF(L62=0,\"FULL\")))","v":"FULL"}]
["Proactive and Adaptable"]
["B7","IAPracs will demonstrate drive and energy to get the job done and an open mindset in all their audit work, able to adapt in changing circumstances.",null,null,null,null,null,null,{"$f":"IF(C64 = \"FULLY MET\",1,IF(C64 = \"PARTIALLY MET\",0.5,IF(C64 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["Professional Scepticism"]
["B8","IAPracs will demonstrate an attitude that includes a questioning mind and being alert to conditions that may indicate possible misstatement of information due to error or fraud.",null,null,null,null,null,null,{"$f":"IF(C66:C67 = \"FULLY MET\",1,IF(C66:C67 = \"PARTIALLY MET\",0.5,IF(C66:C67 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"}]
["B9","IAPracs will be able to speak out courageously in their own organisation.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J67=1,0.5,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=0.5,\"NONE\",IF(L67=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J23:J67)","v":0},"Net Score",{"$f":"SUM(L23:L67)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J70/L74","v":0},"total CoE KSB coverage",{"$f":"L70/L77","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",29]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L74-L75-(L76*0.5)","v":27.5}]

{"sheet":"ST0869","index":5,"n_rows":84,"n_cols":18,"rows_kept":84,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Payroll Assistant Manager (Level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The range of different payroll provider/customer models and the stakeholders involved, including the risks / opportunities for service delivery improvements.",null,null,null,null,null,null,{"$f":"IF(C22:C51 = \"FULLY MET\",1,IF(C22:C51 = \"PARTIALLY MET\",0.5,IF(C22:C51 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The impact the organisational mission, objectives and values have on successful payroll delivery and how this is measured by key performance indicators.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The range and construction of payroll administrative procedures and guidance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Principles for recording statutory requirements for all sickness and parental leave payments (SMP, SAP etc).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Principles for recording new starter information, including the implications for mistimed payments of Income Tax and National Insurance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Eligibility for the Employment Allowance and the associated information requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The lifecycle of an organisation's payroll and the impact of business change.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Employer liability for UK taxes such as National Insurance, Apprenticeship Levy etc. including any implications of sharing with the devolved administrations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The techniques for negotiating and influencing stakeholders to achieve desired outcomes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","A range of verbal and written communication techniques for adapting approaches to suit audiences.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Tools and techniques for analysing and determining complex payroll cases, for example, researching the national insurance implications for late payments to starters.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The techniques for identifying and sourcing data that impacts the determination of complex payroll issues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The processes and manual calculations to follow when operating complex payroll including but not limited to National Insurance Contributions and Income Tax deductions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The different UK pension scheme tax relief mechanisms and the potential impact in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The techniques for manually calculating and processing benefits-in-kind and “payrolling”, including the benefit and expenses exemptions that exist and PAYE Settlement Agreements (PSAs).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The process for managing the processing of off-payroll workers (also known as IR35 and deemed workers) in the payroll system.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The range of payments made to leavers and termination payments (upon redundancy and/or voluntary leavers).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","How advances in technology (for example, evolving artificial intelligence (AI)and automation) and software increasingly impact the UK-wide payroll function. The comparative benefits and risks of cloud-based and integrated HR /payroll solutions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Techniques for managing and motivating diverse teams to meet client/customer payroll requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How payroll, employment and pensions legislation and guidance is created across each of the devolved nations that form the UK. This includes how to distinguish between primary and secondary legislation and how primary legislation and regulations work together.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","How caselaw is formed and how it impacts on legislation and guidance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The most up to date legislation, guidance and caselaw that may potentially affect any part of payroll operations. For example, the Agency Worker Regulations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The impact of data protection legislation on payroll and the processes for safely and legally storing and sharing information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","The range of payroll quality assurance approaches that can be utilised to determine the accuracy of calculations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Techniques for forecasting staffing requirements against the payroll workload.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","How the recruitment and selection lifecycle in different organisations impacts successful payroll delivery.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Techniques and requirements for preventing discrimination and promoting equal opportunity, in line with the Equality Act 2010 in Great Britain and the Disability Discrimination Act 1995 in Northern Ireland.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","The principles of how to develop yourself and your team.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Techniques for delivering process improvements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","How to identify and manage suspected fraud and criminal activity in the payroll environment, including, for example, the prevention money laundering, complying with the Money Laundering Regulations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Identify the risks and opportunities presented by a payroll provider/customer model. Recommend appropriate service delivery improvements.",null,null,null,null,null,null,{"$f":"IF(C53:C67 = \"FULLY MET\",1,IF(C53:C67 = \"PARTIALLY MET\",0.5,IF(C53:C67 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J53=1,1,IF(J53=0.5,0.5,IF(J53=0,0)))","v":0},{"$f":"IF(L53=1,\"NONE\",IF(L53=0.5,\"PARTIAL\",IF(L53=0,\"FULL\")))","v":"FULL"}]
["S2","Manage the provider/customer and other stakeholder relationships necessary to influence successful payroll outcomes (including delivery, customer care and enquiry handling).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Communicate complex payroll concepts to customers and other less technical stakeholders; Communicate effectively at different levels of the organisation, selecting an appropriate communication method for the audience.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Identify and source all of the information required in a complex payroll case to enable accurate calculation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Analyse and determine complex payroll cases, including pensions, pay and benefits, considering all relevant data and other evidence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Balance the trade-offs between automated and non-automated payroll approaches. Identify and complete payroll calculation manually where needed.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Match the payroll decision needed against the skill sets within your team and the risks involved when determining who should deliver the work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Design, implement and maintain payroll administrative procedures and guidance that enables payroll team delivery including technical data, and both business as usual and contingency (disaster recovery) handling.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Utilise available technological platforms when delivering payroll operations by balancing the benefits and risks of the system used. As an example, this might mean the latest HMRC reporting tool, or utilising AI/automation advancements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Adjust leadership style to achieve results, having regard to both individuals within the team and how the team works together.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Interpret and apply all payroll legislation, guidance and case law pertinent to a complex case.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Quality assure your own and your teams payroll calculations to ensure accuracy and compliance. Ensure that you and your team act compliantly when transacting customer payroll by deploying a quality assurance process proportionate to the payroll issues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Make recruitment and retention decisions/recommendations, as necessary.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Co-ordinate and manage your team's payroll workload in order to meet key performance indicators and contractual obligations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Reconcile your teams final payroll run.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Represents the payroll profession with integrity and professionalism.",null,null,null,null,null,null,{"$f":"IF(C69:C74 = \"FULLY MET\",1,IF(C69:C74 = \"PARTIALLY MET\",0.5,IF(C69:C74 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"}]
["B2","Work flexibility, adapting to changing work priorities and deadlines.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Open-minded to the needs of others. Self-aware of their own behaviours/values and the impact this can have on others.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Probes and questions issues to seek solutions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Anticipate problems and manages setbacks when they occur.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Reflects on own effectiveness and seeks out professional development to enhance performance. Encourages others to do the same.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J74)","v":0},"Net Score",{"$f":"SUM(L22:L74)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J77/L81","v":0},"total CoE KSB coverage",{"$f":"L77/L84","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",51]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L81-L82-(L83*0.5)","v":51}]

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