{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["GUIDE TO KSB MAPPING","ST0311","ST0325","ST0572","ST0596","ST0683","ST0883","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":"ST0311","index":1,"n_rows":75,"n_cols":18,"rows_kept":75,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Public relations and communications assistant (level 4) "]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Current affairs, the media, the public relations industry, and how they impact their role.",null,null,null,null,null,null,{"$f":"IF(C22:C22 = \"FULLY MET\",1,IF(C22:C42 = \"PARTIALLY MET\",0.5,IF(C22:C42 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","How their role supports the wider organisation structure and works alongside other multi-disciplinary teams such as internal communications and marketing.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","The organisation structure and objectives and how these affect the work with stakeholders or clients.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The structure of communication plans and how these feed into the overall communications strategy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The creation and management of materials which support communication programmes, campaigns, or new business proposals.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The operational processes required to prioritise team and individual workloads to meet deadlines and objectives.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Technology and software used in the delivery of programmes and campaigns.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Production lead-times and deadlines for digital build, content creation, print, and media.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Communication techniques and approaches to interact with stakeholders to meet their requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The importance of horizon scanning for future changes and developments in relation to the industry or sector.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The principles of Qualitative and Quantitative research.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Risk assessment methodologies and approaches to mitigate or manage reputational impact and implementation of crisis plans.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The importance of evaluation in demonstrating the value and impact of public relations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Regulatory and legislative requirements relevant to their sector such as data protection and codes of practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How to analyse and interpret complex technical information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The support requirements or development needs of their team.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The tools used to measure the impact of organisational objectives, and the wider environment and sustainability on public relations and communications activities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Principles of conducting public relations and communications which are ethical and inclusive.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The principles of non-written content.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Approaches to distributing content using social media channels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Where to source information on career professional development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Use IT systems and software to support campaigns.",null,null,null,null,null,null,{"$f":"IF(C44:C59 = \"FULLY MET\",1,IF(C44:C59 = \"PARTIALLY MET\",0.5,IF(C44:C59 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"}]
["S2","Build stakeholder relationships including developing contacts within the media and presenting to them in both formal and informal settings.",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"}]
["S3","Support campaigns by undertaking tasks such as desk research, event co-ordination, and database management to ensure compliance with agreed service or performance levels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Produce written content such as news releases, articles, social media content, bulletins, and blogs, that is accessible to meet the needs of different audiences and channels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Able to adapt communication styles as appropriate to the audience.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Support the production of non-written content such as film production management, producing short user generated style content, live video streaming, social image creation, and infographic production.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Distribute content using social media channels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Use qualitative and quantitative research to analyse and evaluate public relations and communications activities and present findings to project stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Analyse and interpret complex subjects through different communication channels and identify areas for improvement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Input to and review communications programmes and plans with a focus on environmental, social and governance (ESG) principles.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Undertake risk assessment and provide information to support stakeholder planning and strategy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Plan and deliver engagement activities for stakeholders, such as curating the content, supporting events, and collating feedback.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Proofread and edit communications materials such as news releases, graphics and video, and social media content.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Support team and colleague development through buddying or coaching.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Contribute to activities which focus on improving sustainability within the organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Apply relevant legislation, regulations, codes of practice, and ethical guidance where appropriate to their work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Acts professionally and with integrity to build trust.",null,null,null,null,null,null,{"$f":"IF(C61:C65 = \"FULLY MET\",1,IF(C61:C65 = \"PARTIALLY MET\",0.5,IF(C61:C65 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J61=1,1,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=1,\"NONE\",IF(L61=0.5,\"PARTIAL\",IF(L61=0,\"FULL\")))","v":"FULL"}]
["B2","Works collaboratively and builds strong relationships with others across the organisation and external stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Has accountability and ownership of their tasks and workload.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Seeks learning opportunities and continuous professional development.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J64=1,0.5,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=0.5,\"NONE\",IF(L64=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Takes responsibility, shows initiative, and is organised.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J65)","v":0},"Net Score",{"$f":"SUM(L22:L65)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J68/L72","v":0},"total CoE KSB coverage",{"$f":"L68/L75","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",42]
[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":"L72-L73-(L74*0.5)","v":41}]

{"sheet":"ST0325","index":2,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Retail manager (level 4) "]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Customer: Understand key drivers of customer journeys and how managing positive customer experiences increases sales, customer spend and loyalty, and the resulting financial impact on the business",null,null,null,null,null,null,{"$f":"IF(C22:C36 = \"FULLY MET\",1,IF(C22:C36 = \"PARTIALLY MET\",0.5,IF(C22:C36 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Business: Understand the vision of the business, its competitive position and own role and responsibility in the delivery of business objectives. Understand the market in which the business operates and how this impacts on the products / services it offers",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","Financial: Understand the key drivers of profitable retail performance and the relationship of forecasting to the retail calendar; know how to analyse and use information for forecasting, and how to report on financial results. Identify the impact of different types of costs on the business and understand how to make effective use of resources",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Leadership: Understand different leadership styles used in retail businesses and when to use them effectively to motivate and inspire the team to do their best",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Marketing: Know the key factors influencing a marketing plan such as product launch and life cycle, pricing, discount and special offers and ways of marketing via physical and other media. Understand how own business has formed marketing plan and how own role can best utilise marketing strategies to address demand throughout the retail calendar",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Communication: Understand how to communicate and cascade information effectively at all levels and to a diverse audience. Know how to identify the information required for decision making, how it should be gathered and reported internally and externally",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Sales & Promotion: Understand how to set sales targets that are challenging but realistic and how to lead team members to achieve sales targets, maximising opportunities and reducing potential threats to sales across the retail calendar",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Product & Service: Keep up to date knowledge of product ranges, brand development, promotions, current and future trends. Understand how to analyse, interpret and share information and brief relevant stakeholders on products and services",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Brand Reputation: Understand the importance of upholding brand reputation,how brand reputation can become compromised and the impact on the business, and how threats can be managed. Identify the impact of social media on the industry and how it is used in own organisation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Merchandise: Understand key features of merchandising and how these link with the business’ merchandising plan to achieve sales targets. Know the particular requirements of related activities such as seasonal peaks and troughs over the retail calendar year",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Technology: Understand the technology requirements of the business and how to manage them to achieve effective and efficient retail operations and service; identify commonly used and emerging technology in the retail industry and identify its current and potential impact on the business",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Developing self: Identify a variety of ways to inspire and motivate team members, how to positively influence their approach to work and how to pass on knowledge and experience. Understand the importance of, and process for, ensuring team members’ and own development",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Team performance: Know how to recruit, retain and develop the right people for the right roles. Know the key theories of performance management and how to apply them to retail teams using own organisation’s tools and protocols to support them",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Legal & Governance: Understand environmental, legislative, corporate, data protection and social responsibilities relating to retail businesses",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Diversity: Understand how local demographics impact on business, customers, staff and products and how this impacts the business policies on diversity and equal opportunities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Customer: Manage the customer experience, including remotely e.g. on- line, through ensuring the team deliver to customers a positive experience that benchmarks favourably to its main competitors and meets customer service objectives",null,null,null,null,null,null,{"$f":"IF(C38:C53 = \"FULLY MET\",1,IF(C38:C53 = \"PARTIALLY MET\",0.5,IF(C38:C53 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J38=1,1,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},{"$f":"IF(L38=1,\"NONE\",IF(L38=0.5,\"PARTIAL\",IF(L38=0,\"FULL\")))","v":"FULL"}]
["S2","Business: Lead the team to achieve and exceed business objectives through forward planning, analysis and evaluation of own business area. Use sales and customer data to make sound and effective decisions which improve business performance",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J39=1,1,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},{"$f":"IF(L39=1,\"NONE\",IF(L39=0.5,\"PARTIAL\",IF(L39=0,\"FULL\")))","v":"FULL"}]
["S3","Financial: Manage the overall performance of the team to achieve financial targets taking into account the retail calendar year. Analyse reports to identify and determine key actions and recommendations. Produce and report on financial plans as required by the business, and identify and implement opportunities to increase profit and reduce waste",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Leadership: Provide clear direction and leadership to the team, giving open and honest feedback. Apply and adapt own leadership style to different retail situations and people to achieve the desired outcome",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Marketing: Communicate marketing objectives to team members and drive results. Analyse and evaluate the impact of marketing activities e.g. sales and customer feedback, and report the outcomes to senior management with relevant recommendations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Communication: Establish clear communication objectives, lead communications in a style and manner that is relevant to the target audience and achieves an effective result for the business",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Sales and Promotion: Manage the team to achieve sales targets through regular monitoring of performance against results, identifying high and low performance products / services and taking timely action to find and implement appropriate solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Product and Service: Analyse and interpret product / service sales information and use it to make recommendations for future planning e.g. of staff and resources, ideas for new initiatives. Research and demonstrate new products / services or initiatives to the team",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Brand Reputation: Ensure the team carry out activities in line with business and brand values that actively market the business, support competitiveness and help meet business objectives. Identify possible risks to brand reputation and take action to prevent or minimise their impact",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Merchandise: Ensure effective merchandising set up, monitoring and maintenance in own area of business. Measure the impact of merchandising on sales and report the outcome to colleagues and senior managers, providing recommendations for improvements, and implementing changes within own remit",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Stock: Monitor the stock management system to minimise the cost of damage to stock and the loss of stock to the business. Ensure audit compliance and react quickly to results to maintain business standards and stock requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Developing self: Work with team members to maximise their potential and achieve organisation’s objectives. Implement effective and accurate training on products, services and legislation governing sales, such as age restricted products, trading standards and weights and measures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Team performance: Recruit the right people into the right job, monitor team performance and recognise excellence, effectively manage performance that is below standard",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Legal and Governance: Manage and continuously review adherence to legislation and regulations / policies for due diligence; handle audits and regulatory authorities such as the Environmental Health Officer appropriately",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Diversity: Implement business policy on diversity, ensuring team are aware of and know how to work effectively with colleagues customers and other stakeholders from wide range of backgrounds and cultures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Technology: Ensure technology is sourced, located, available, maintained and secured in line with business needs; oversee the use of technology in line with business policy, identify and make recommendations for improvement",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Customer: Take overall accountability and responsibility for the customers’ experience. Make effective decisions by balancing the needs of the customer and the business",null,null,null,null,null,null,{"$f":"IF(C55:C70 = \"FULLY MET\",1,IF(C55:C70 = \"PARTIALLY MET\",0.5,IF(C55:C70 = \"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","Business: Demonstrate personal responsibility for the strategic direction and objectives for own area of the business",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J56=1,1,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=1,\"NONE\",IF(L56=0.5,\"PARTIAL\",IF(L56=0,\"FULL\")))","v":"FULL"}]
["B3","Financial: Demonstrate commercial acumen and confidence to initiate change to improve the financial performance and profitability in line with business policy, objectives and procedures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Leadership: Influence, challenge and involve others, aligning personal values with those of the company to instil a high performance culture",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Marketing: Proactively seek to understand the marketing strategy of the business, gain knowledge of local area and competition, take action, or upwardly communicate recommendations on action, to improve the implementation and drive marketing activities in area of responsibility",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Communication: Adapt style and method of communication to the circumstances and needs of individuals intuitively, demonstrating appropriate skills such as empathy, fairness and authority as appropriate; seek and provide feedback in a positive manner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Sales and Promotion: Think ahead and take positive actions to maximise opportunities for sales and effective marketing activities, make cost effective use of resources through robust processes to meet sales targets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Product and Service: Take ownership of the service offer, keeping self and team up to date with brand developments. Passionately take pride in new products and services actively promoting these with colleagues and customers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Brand Reputation: Champion the brand and work closely with team and management to ensure brand reputation is upheld at all times",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B10","Merchandising: Adapt merchandising principles to own environment, store configuration, local needs and sales patterns",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B11","Stock: Take ownership of stock management systems to meet current and projected business needs`",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B12","Technology: Drive efficiency in the implementation and use of new opportunities in technology for retail that will provide benefits to the business",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B13","Developing self: Help team members balance work and life priorities, realise their potential and see the benefits of self- development and improvement. Demonstrate commitment to self-improvement, championing a culture of continual development and progression",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"}]
["B14","Team Performance: Orchestrate effective team dynamics, build effective relationships that select the right person for the right task, recognise individual styles and preferences and use these to build a strong team",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B15","Legal and Governance: Be accountable, advocate and adhere to the importance of working legally in the best interests of all people",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B16","Diversity: Instil values which embrace the benefits of working in a culturally diverse environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J70)","v":0},"Net Score",{"$f":"SUM(L22:L70)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J73/L77","v":0},"total CoE KSB coverage",{"$f":"L73/L80","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",47]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L77-L78-(L79*0.5)","v":46.5}]

{"sheet":"ST0572","index":3,"n_rows":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Sales executive (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Organisational Knowledge: Understand your organisation’s vision, values and capabilities, the principle goals of its overall strategy, and the specific objectives of its marketing and sales strategies. Know how to analyse your organisation’s sales and marketing strategies and objectives and translate them into plans and actions for your role.",null,null,null,null,null,null,{"$f":"IF(C22:C27 = \"FULLY MET\",1,IF(C22:C27 = \"PARTIALLY MET\",0.5,IF(C22:C27 = \"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","Product, service and sector Knowledge: Identify the features and advantages of the product(s) and/or services(s) you sell, understand how these meet customer needs, and examine how they compare to competitor’s solutions. Understand the nature of your sector and the likely forthcoming changes to it. Understand the legal, regulatory and ethical frameworks relating to your sector and role.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","Market knowledge: Understand how your market is segmented and how to target specific segments through effective product or service positioning.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Customer knowledge: Know how to analyse the macro and micro environment of individual customers. Understand the challenges and purchasing motivations of your customers and the internal and external factors that impact their purchasing decisions. Understand expectations of what constitutes a high-quality customer experience.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Commercial and Financial Acumen: Understand the principles of finance for sales, such as profit and loss, return on investment and budgeting. Appreciate the impacts of different types of costs on the businsess and the drivers of profitable performance. Understand the impact of any discount or variation in terms that you may offer.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Digital Knowledge: Understands how to exploit digital technologies to aid the sales cycle.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Sales planning and preparation: Set effective targets using sales forecasts. Prioritise customers and activities to grow account value and maximise return-on-investment in line with your organisation’s strategy. Formulate or refine customer plans and objectives. Create efficient territory plans where appropriate.",null,null,null,null,null,null,{"$f":"IF(C29:C39 = \"FULLY MET\",1,IF(C29:C39 = \"PARTIALLY MET\",0.5,IF(C29:C39 = \"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"]
["S2","Customer engagement: Effectively communicate and interpret customer information exchanged through written, verbal and non-verbal communication. Develop a customer engagement style that effectively opens sales conversations, builds rapport, enhances customer relationships, and adapts to different customer’s social preferences.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J30=1,1,IF(J30=0.5,0.5,IF(J30=0,0)))","v":0},"FULL"]
["S3","Customer needs analysis: Be highly skilled at effective questioning and active listening techniques to understand the customer’s needs, guide the sales conversation appropriately, create mutual understanding, and build trust and affinity with customers.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Propose and present solutions: Develop sales proposals and deliver them using a presentation style and technique appropriate for your customer. Present relevant products and/or services, explain features and their advantages, and clearly articulate the value and benefit of the solution for the specific customer. Use and adapt a range of techniques to draw-out and overcome common sales objections.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Negotiate: Research the customer’s likely desired outcomes and negotiating stance. Develop responses to likely objections. Identify your own organisation’s needs, such as minimum price and acceptable terms. Negotiate or trade variables effectively.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Closing Sales: Be attuned to verbal and non-verbal buying-signals and move to close at an appropriate point in sales conversations. Develop ethical techniques to close sales and confirm customers’ purchase agreement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Gathering Intelligence: Collect, analyse and interpret market intelligence and share it appropriately and effectively within your organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Time Management: Use and adapt appropriate tools and techniques to prioritise and manage your time effectively.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Collaboration and team work: Contribute effectively within a team environment. Work collaboratively with both internal and external stakeholders. Manage communications with the cross-functional team in relation to the effective delivery of your sales, such as finance and service delivery. Support continual business improvement by sharing best practice with sales team colleagues and assist the marketing team to develop new marketing collateral.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Customer experience management: Deliver a positive customer experience. Manage customer enquiries and issues effectively. Take proactive action to prevent and minimise customer concerns and complaints. Handle all customer interactions professionally to the customer’s satisfaction.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Digital skills: Effectively use digital tools to conduct research and target customers in line with the overall sales strategy. Able to deliver presentations and meetings using digital communication. Complete accurate records and process sales in accordance with your organisation’s policies, procedures and digital CRM systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Ethics and Integrity: Present yourself as an ambassador for your employer’s brand, and act in accordance with your organisation’s values and code of conduct at all times. Maintain integrity in all business relationships. Challenge unethical behaviour.",null,null,null,null,null,null,{"$f":"IF(C41:C45 = \"FULLY MET\",1,IF(C41:C45 = \"PARTIALLY MET\",0.5,IF(C41:C45 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J41=1,0.5,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=0.5,\"NONE\",IF(L41=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Proactivity: Proactively develop new and existing customer relationships. Plan and lead sales conversations and make recommendations to support the customers’ requirements. Proactively monitor the customer experience.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J42=1,1,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=1,\"NONE\",IF(L42=0.5,\"PARTIAL\",IF(L42=0,\"FULL\")))","v":"FULL"}]
["B3","Self discipline: Demonstrate the ability to control your actions, reactions and emotions. Remain calm under pressure and be aware of your personal impact on others.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Resilience and self motivation: Demonstrate the ability to maintain optimism and professionalism in the face of rejection, quickly recover from setbacks, adapt well to change, and keep going in the face of adversity. Remain highly motivated to achieve both personal and professional goals.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Continuous professional development: Respond positively to coaching, guidance or instruction; demonstrate awareness and ownership of your continual professional development, and actively seek out development opportunities outside of formal learning situations.",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"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J45)","v":0},"Net Score",{"$f":"SUM(L22: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",22]
[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":"L52-L53-(L54*0.5)","v":21}]

{"sheet":"ST0596","index":4,"n_rows":66,"n_cols":18,"rows_kept":66,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Marketing executive (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The fundamentals of marketing theory that support the marketing process e.g. the extended marketing mix (7P’S: Product, Price, Place, Promotion, Physical environment, Process, People), product development, and segmentation",null,null,null,null,null,null,{"$f":"IF(C22:C32 = \"FULLY MET\",1,IF(C22:C32 = \"PARTIALLY MET\",0.5,IF(C22:C32 = \"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 concepts of brand positioning and management and implementing process to support corporate reputation",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","The principles of stakeholder management and customer relationship management (CRM), both internal and external, to facilitate effective cross-functional relationships internally, and channel and customer relationships externally.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The characteristics and plans of the business and sector they work within, including their vision and values",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","How marketing contributes to achieving wider business objectives",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The target audience’s decision making process and how that can influence marketing activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The sector specific legal, regulatory and compliance frameworks within which they must work, including current Data Protection regulations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The principles of effective market research and how this can influence marketing activity e.g. valid data collection sources and methodologies and usage, including digital sources, and when to use quantitative and qualitative methods.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Basic principles of product development and product/service portfolios",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The marketing landscape and how routes to market interplay most efficiently, e.g. franchise model, distribution",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The features and benefits of different marketing communications channels and media, both digital and offline, and when and how to apply these.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Coordinate and maintain key marketing channels (both digital and offline)",null,null,null,null,null,null,{"$f":"IF(C34:C47 = \"FULLY MET\",1,IF(C34:C47 = \"PARTIALLY MET\",0.5,IF(C34:C47 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J34=1,1,IF(J34=0.5,0.5,IF(J34=0,0)))","v":0},{"$f":"IF(L34=1,\"NONE\",IF(L34=0.5,\"PARTIAL\",IF(L34=0,\"FULL\")))","v":"FULL"}]
["S2","Plan and deliver tactical campaigns against SMART (Specific, Measurable, Achievable, Realistic, Time-bound) objectives",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Manage the production and distribution of marketing materials, e.g. digital, print and video content as appropriate.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Produce a wide range of creative and effective communications, including ability to write and proofread clear and innovative copy, project briefs, and give confident presentations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Able to engage and collaborate with a wide range of clients/stakeholders, across departments internally and with clients/suppliers externally to support marketing outcomes as required.",null,null,null,null,null,null,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"}]
["S6","Use good project and time management to deliver projects/tasks/events as appropriate, effectively. Including the ability to divide time effectively between reporting, planning and delivery",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Coordinate several marketing campaigns/projects/events to agreed deadlines",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Effectively liaise with, and manage, internal and external stakeholders including suppliers to deliver required outcomes.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J41=1,0.5,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},{"$f":"IF(L41=0.5,\"NONE\",IF(L41=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Monitor project budgets within their scope of work using appropriate systems and controls.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Evaluate the effectiveness of marketing campaigns by choosing the appropriate digital and offline data sources.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Assimilate and analyse data and information from a range of sources to support marketing activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Evaluate data and research findings to derive insights to support improvements to future campaigns.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Effectively use appropriate business systems and software to deliver marketing outcomes efficiently, for example to analyse data, produce reports and deliver copy",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Use appropriate technologies to deliver marketing outcomes e.g. digital/web analytics, social media, CRM.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","A tenacious and driven approach to see projects through to completion",null,null,null,null,null,null,{"$f":"IF(C49:C56 = \"FULLY MET\",1,IF(C49:C56 = \"PARTIALLY MET\",0.5,IF(C49:C56 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J49=1,1,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=1,\"NONE\",IF(L49=0.5,\"PARTIAL\",IF(L49=0,\"FULL\")))","v":"FULL"}]
["B2","Being a proven ‘self-starter’ and have an adaptable approach to meet changing work priorities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","A creative and analytical mind, with a willingness to think of new ways of doing things",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","They come up with ideas and solutions to support the delivery of their work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","A willingness to learn from mistakes, as not all activities go to plan, and improve their own performance as a result.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","A high level of professionalism, reliability and dependability with a passion for the customer",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","A collaborative approach is central to how they work, showing empathy and being mindful to the needs/views of others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Ethical behaviour in the way they approach marketing activities and their work, valuing equality & diversity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J56)","v":0},"Net Score",{"$f":"SUM(L22:L56)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J59/L63","v":0},"total CoE KSB coverage",{"$f":"L59/L66","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",33]
[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":"L63-L64-(L65*0.5)","v":32}]

{"sheet":"ST0683","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\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Buying and merchandising assistant (level 4) "]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","How to develop an operational or strategic approach to buying and / or merchandising",null,null,null,null,null,null,{"$f":"IF(C22:C42 = \"FULLY MET\",1,IF(C22:C42 = \"PARTIALLY MET\",0.5,IF(C22:C42 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Industry standards, regulations and legislation relating to the ethical and sustainable sourcing, purchasing and sale of goods to ensure compliance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Product lifecycle from development to customer and the critical path approach to support the buying and merchandising process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Principles of buying and merchandising and the specific role of each",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The brand position within the market, which includes both UK and global markets, retailer types and trading models",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Effective methods of negotiation, and how they relate to the organisation’s strategy, goals and ethical stance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Key aspects of the sector in respect of global and domestic trading patterns",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Principles of working within strategic operational buying and merchandising frameworks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Effective methods of communication to achieve operational success",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The principles of internal trend analysis and forecasting",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The principles of undertaking competitor analyses",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The different purchasing habits of customers, seasonality and the different customer journey across all purchasing channels",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The importance of keeping up with current trends within the industry",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The importance of customer profiles and how they impact buying and merchandising operations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The principles of team dynamics and relationships in order to achieve individual and organisational goals",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The importance of coaching and mentoring to support the development of the buying and merchandising teams",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The goals and targets of the business, the drivers of performance and the contribution of the team in order to achieve these",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The key performance indicators of the department, their performance and how to individually contribute to their success",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The range and impact of external factors such as currency fluctuation and global suppliers have on profit margin and costs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The impact of stock planning and densities on profitability and how it aligns to organisational/brand strategy",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Factors affecting and impacting seasonal planning to ensure availability of appropriate products and to drive profit",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Uses their market/industry knowledge to contribute to new product development and innovation",null,null,null,null,null,null,{"$f":"IF(C44:C66 = \"FULLY MET\",1,IF(C44:C66 = \"PARTIALLY MET\",0.5,IF(C44:C66 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"}]
["S2","Contributes to the building of customer focused ranges to meet the brand identity of the business",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Ensures product quality and legal compliance by working within industry standards, regulations and legislation to source, purchase and sell goods",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Ensures accurate implementation of the critical path prioritising actions accordingly",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Negotiates in a manner that balances the need for a sound financial return, with the need to operate ethically, honestly and fairly",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Monitors agreed performance targets with suppliers to manage ongoing supplier relationships",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Applies the organisation strategy to buying and/or merchandising to ensure strategic objectives are met",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J50=1,0.5,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=0.5,\"NONE\",IF(L50=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S8","Applies an ethical and sustainable approach to the buying and merchandising process in line with policies and procedures to achieve legal compliance",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J51=1,1,IF(J51=0.5,0.5,IF(J51=0,0)))","v":0},{"$f":"IF(L51=1,\"NONE\",IF(L51=0.5,\"PARTIAL\",IF(L51=0,\"FULL\")))","v":"FULL"}]
["S9","Ensures the agreed route to market is delivered and maintained successfully so that objectives are met",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Works with external and internal departments (for example, marketing, distribution, suppliers) to build relationships to drive sales activity and support the delivery of the business objectives across all channels",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Uses data to support decisions to influence both the strategic and operational direction of the buying and/or merchandising approach.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Demonstrates accurate application of systems in analysing data (for example, customer trends, buying patterns, stock rotation and levels)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Analyses and presents business data to support achievement of business strategies, brand and KPIs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Evaluates commercial performance to support proposed actions for both good and poor product performers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Demonstrates anticipation of customer buying and product patterns to forecast future demand",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Articulates relevant ideas and opinions towards trends and competitor activity so that opportunities may be identified",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Applies customer profile/trend data to inform the development of a range, products and services",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Formulates and communicates customer propositions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Develops self and individuals to improve personal and team performance and capability",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Demonstrates commercial buying and merchandising within a financial framework",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Operates in a manner that produces the required financial rate of return for the business",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Ensures effective stock management to support the delivery of the sales and profit forecasts",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Coaches and mentors new/less experienced colleagues",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Is creative thinking, and enthusiastic with a positive and professional attitude",null,null,null,null,null,null,{"$f":"IF(C68:C74 = \"FULLY MET\",1,IF(C68:C74 = \"PARTIALLY MET\",0.5,IF(C68:C74 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J68=1,1,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=1,\"NONE\",IF(L68=0.5,\"PARTIAL\",IF(L68=0,\"FULL\")))","v":"FULL"}]
["B2","Is confident accountable and pro-active",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Shows tenacity and is prepared to take risks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Is resilient, organised with an eye for attention to detail",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Is flexible, agile and adaptable to changing markets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Operates within professional code of ethics",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Is an ambassador for the business",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J74=1,0.5,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=0.5,\"NONE\",IF(L74=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J74)","v":0},"Net Score",{"$f":"SUM(L22:L74)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J77/L81","v":0},"total CoE KSB coverage",{"$f":"L77/L84","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",51]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",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":50}]

{"sheet":"ST0883","index":6,"n_rows":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Market research executive (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The role research plays in the business process, such as the target market, consumers (behaviour or attitudes), competitors or the industry as a whole.",null,null,null,null,null,null,{"$f":"IF(C22:C32 = \"FULLY MET\",1,IF(C22:C32 = \"PARTIALLY MET\",0.5,IF(C22:C32 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","How research is used to address business, customer and policy questions, such as information related to products, services or advertising etc.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The principles of Quantitative research and the underlying theories such as sampling, representativeness, statistical theory, data collection and analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The principles of Qualitative research and underlying theories of the social sciences e.g. representativeness, sampling theory analysis methods.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The research methodologies including face to face (f2f), telephone, online, and postal.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Approaches to primary research and the different sources of primary research data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Approaches to secondary research and how information is sourced and utilised from previously conducted studies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The principles of research project management such as time management, scheduling, resourcing, costs and budgeting.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Relevant regulatory and legislative requirements such as data protection, GDPR, confidentiality, informed consent and safeguarding, ethics and The Market Research Society Code of Conduct.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Technologies such as digital sources, systems and software, that can help deliver market research, delivery and evaluation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Technology and software used to provide appropriate representation of data and manipulate them into appropriate formats (tables, graphs and portfolios) for publication.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Liaise with and manage, clients, stakeholders, internal teams and external suppliers to deliver required outcomes.",null,null,null,null,null,null,{"$f":"IF(C34:C43 = \"FULLY MET\",1,IF(C34:C43 = \"PARTIALLY MET\",0.5,IF(C34:C43 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J34=1,0.5,IF(J34=0.5,0.5,IF(J34=0,0)))","v":0},{"$f":"IF(L34=0.5,\"NONE\",IF(L34=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Undertake data collection, data analysis, data presentation and data storage including analysis and validation of the outputs from primary or secondary research data sources.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J35=1,1,IF(J35=0.5,0.5,IF(J35=0,0)))","v":0},{"$f":"IF(L35=1,\"NONE\",IF(L35=0.5,\"PARTIAL\",IF(L35=0,\"FULL\")))","v":"FULL"}]
["S3","Interpret, prepare and communicate research findings such as presentations, reports, and workshops.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Make evidence-based recommendations from research results.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Use communications skills and techniques such as negotiation, collaboration, problem solving, and decision making.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Interpret research objectives and translate into research design and implementation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Use digital and IT software packages relevant to the role.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Use research/survey software to gather audience insight and/or evaluation such as SPSS (Statistical Product and Service Solutions).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Select and use appropriate research design techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Evaluate data and research findings to derive insights to support improvements to future research projects.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Works without bias.",null,null,null,null,null,null,{"$f":"IF(C45:C50 = \"FULLY MET\",1,IF(C45:C50 = \"PARTIALLY MET\",0.5,IF(C45:C50 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},{"$f":"IF(L45=1,\"NONE\",IF(L45=0.5,\"PARTIAL\",IF(L45=0,\"FULL\")))","v":"FULL"}]
["B2","Seeks learning opportunities and continuous professional development.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J46=1,0.5,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=0.5,\"NONE\",IF(L46=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B3","Works collaboratively.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Works ethically recognising participants needs and data privacy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Works flexibly and adapts to circumstances.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Takes responsibility, shows initiative and is organised.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J50)","v":0},"Net Score",{"$f":"SUM(L22:L50)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J53/L57","v":0},"total CoE KSB coverage",{"$f":"L53/L60","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",27]
[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":"L57-L58-(L59*0.5)","v":26}]

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