{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Option Lists","GUIDE TO KSB MAPPING","OCC1031","OCC0810","OCC0887","OCC0584","OCC0056","OCC0644","OCC0071","OCC0168","OCC0077","OCC0340","OCC0115","OCC0326","OCC0234"],"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":"Option Lists","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["All","All","All","All","All"]
["01 - Coach Builder","01 - Track","01 -Aerospace Manufacturing Fitter","01 - Heritage Engineering Aviation Technician","01 - Modern Upholsterer"]
["02 - Electrical","02 - Electrification","02 - Aerospace Manufacturing Electrical / Mechanical & Systems Fitter","02 - Heritage Engineering Marine Technician","02 - Traditional Upholsterer"]
["03 - Mechanical","03 - Overhead Lines","03 - Aircraft Maintenance Fitter/Technician (Fixed & Rotary Wing)","03 - Heritage Engineering Steam (Mechanical Overhaul) Technicians"]
["04 - Mechelec","04 - Signalling","04 -  Airworthiness, Planning, Quality & Safety Technician","04 - Heritage Engineering Steam (Boiler-smith) Technicians"]
[null,"05 - Telecoms","10 - Mechatronics Maintenance Technician","05 - Heritage Engineering Vehicle Mechanical Technicians"]
[null,"06 - Traction & Rolling Stock",null,"06 - Heritage Engineering Coach-building & Trim Technicians"]
[null,"07 - Rail Systems"]

{"sheet":"GUIDE TO KSB MAPPING","index":1,"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 Ifate.Post16@education.gov.uk if you need further help or guidance on mapping."]

{"sheet":"OCC1031","index":2,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","11/12/2023"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC1031 - Multi-channel marketer"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["Adults Only","Core","K1","Marketing theory, concepts and basic principles such as what marketing is, the marketing mix the promotional mix and the differences between each channel used.","FULLY MET"]
["Adults Only","Core","K2","The business’ structure, vision, priorities, and objectives, and how their marketing role supports these.","FULLY MET"]
["Adults Only","Core","K3","Business tools used to measure the impact of business objectives, the wider environment and sustainability on marketing activities.","FULLY MET"]
["Adults Only","Core","K4","What a marketing plan is, how it is built and its purpose.","FULLY MET"]
["Adults Only","Core","K5","The importance of competitor analysis and how to undertake it.","FULLY MET"]
["Adults Only","Core","K6","Brand theory such as positioning, value, identity, guidelines, and tone of voice.","FULLY MET"]
["Adults Only","Core","K7","Create content using principles of design and copywriting, and how to adapt for online and offline mediums e.g., writing digital content for the web compared to leaflets.","FULLY MET"]
["Adults Only","Core","K8","Current and emerging technologies, software and systems which impact on marketing.","FULLY MET"]
["Adults Only","Core","K9","Relevant regulatory and legislative requirements such as data protection, GDPR, cyber security, trading laws, and copyright law for the handling and processing of data and its application.","FULLY MET"]
["Adults Only","Core","K10","Principles of conducting marketing communications in an ethical and diverse manner.","FULLY MET"]
["Adults Only","Core","K11","How internal stakeholders work to support the delivery of all marketing campaigns.","FULLY MET"]
["Adults Only","Core","K12","Common marketing channels, cross channel behaviour, and how to manage and operate an integrated campaign using online and offline channels.","FULLY MET"]
["Adults Only","Core","K13","How to brief and manage external marketing suppliers.","FULLY MET"]
["Adults Only","Core","K14","Adapt communications for appropriate stakeholders and internal audiences.","FULLY MET"]
["Adults Only","Core","K15","The principles of content marketing, and content creation.","FULLY MET"]
["Adults Only","Core","K16","Budget management and how to measure return on investment (ROI).","FULLY MET"]
["Adults Only","Core","K17","The metrics for the delivery and evaluation of marketing activity","FULLY MET"]
["Adults Only","Core","K18","The importance of reviewing campaigns regularly to ensure effectiveness and optimisation.","FULLY MET"]
["Adults Only","Core","K19","The campaign management process including research, planning, budgeting, implementation, and delivery.","FULLY MET"]
["Adults Only","Core","K20","Tools used to support campaign management such as social media, Gantt charts, data analytics, and project management software.","FULLY MET"]
["Adults Only","Core","K21","The customer journey including customer offline and digital touchpoints, customer personas, how to engage customers at different stages of their journey, sales funnels and how to segment an audience for targeting.","FULLY MET"]
["Adults Only","Core","K22","The impact marketing has on the level of customer service or the customer experience, including community management channels","FULLY MET"]
["Adults Only","Core","K23","Quality management and the maintenance of online and offline assets.","FULLY MET"]
[null,null,null,"Skills"]
["Adults Only","Core","S1","Develop or interpret briefs for external or internal stakeholders and measure delivery in-line with the specification and agreed timelines","FULLY MET"]
["Adults Only","Core","S2","Plan and coordinate a marketing activity using marketing tactics to acquire and retain one or more customer segments using available resources.","FULLY MET"]
["Adults Only","Core","S3","Contribute to the generation of innovative and creative approaches across video, images, and other formats, both online and offline, to support campaign development.","FULLY MET"]
["Adults Only","Core","S4","Use research/survey software to gather audience insight and/or evaluation to support the project.","FULLY MET"]
["Adults Only","Core","S5","Use copywriting techniques to write persuasive text/copy to meet a communications objective ensuring it is in-line with organisational brand guidelines.","FULLY MET"]
["Adults Only","Core","S6","Build and implement multi-channel campaigns across a variety of platforms, either offline or digital media.","FULLY MET"]
["Adults Only","Core","S7","Proofread marketing copy ensuring it is accurate, persuasive and is on brand.","FULLY MET"]
["Adults Only","Core","S8","Use software to design and create marketing assets to meet the technical specification.","FULLY MET"]
["Adults Only","Core","S9","Contribute to the research of external suppliers to support recommendations and procurement of marketing goods and services.","FULLY MET"]
["Adults Only","Core","S10","Organise offline and digital assets ensuring they are co-ordinated and legally compliant.","FULLY MET"]
["Adults Only","Core","S11","Use a website content management system to publish text, images, and video/animated content.","FULLY MET"]
["Adults Only","Core","S12","Create and maintain spreadsheets to support marketing activities such as project/budget planning and organisation of marketing assets.","FULLY MET"]
["Adults Only","Core","S13","Use technology and software packages to support day to day activities, e.g., stakeholder communications, development of briefs, data analysis, report writing, presentations and project management.","FULLY MET"]
["Adults Only","Core","S14","Identify and use data and technologies to achieve marketing objectives.","FULLY MET"]
["Adults Only","Core","S15","Monitor and amend campaigns to meet budget requirements including time and monetary costs.","FULLY MET"]
["Adults Only","Core","S16","Review campaigns regularly to ensure effectiveness, to optimise the results.","FULLY MET"]
["Adults Only","Core","S17","Measure and evaluate campaign delivery to identify areas for improvement.","FULLY MET"]
["Adults Only","Core","S18","Use data analysis tools to record, interpret and analyse customer or campaign data.","FULLY MET"]
[null,null,null,"Behaviours"]
["Adults Only","Core","B1","Has accountability and ownership of their tasks and workload.","FULLY MET"]
["Adults Only","Core","B2","Takes responsibility, shows initiative and is organised.","FULLY MET"]
["Adults Only","Core","B3","Works flexibly and adapts to circumstances.","FULLY MET"]
["Adults Only","Core","B4","Works collaboratively with others across the organisation and external stakeholders.","FULLY MET"]
["Adults Only","Core","B5","Seeks learning opportunities and continuous professional development.","FULLY MET"]
["Adults Only","Core","B6","Acts in a professional manner with integrity and confidentiality.","FULLY MET"]

{"sheet":"OCC0810","index":3,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","24/08/2020"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0810 - Procurement and supply assistant"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","The role of Procurement within the organisation and the relevant organisational procurement regulations, policies and processes which must be followed,such as, procedures for obtaining quotes and tenders, purchase order processing and purchase to pay.","FULLY MET"]
["16 - 19 & Adults","Core","K2","Value for money concepts including the balancing of quality, price and sustainable considerations or most economically advantageous tender (meat), whole lifecycle costing, 5 rights of procurement and added value opportunities.","FULLY MET"]
["16 - 19 & Adults","Core","K3","Supplier approval process and the importance of due diligence checks including legal entity checks, financial appraisal, quality checks and relevant sector approvals, certification and policies.","FULLY MET"]
["16 - 19 & Adults","Core","K4","Demand and spend management, analysis and forecasting techniques including quantitative methods such as historical usage, spend and trend analysis,  inventory records and re-order levels or qualitative techniques based on stakeholders estimates using internal databases and spreadsheets.","FULLY MET"]
["16 - 19 & Adults","Core","K5","The importance of developing and managing key stakeholder relationships such as the internal customer and supplier and the need for prompt and effective communication to support efficient and effective procurement.","FULLY MET"]
["16 - 19 & Adults","Core","K6","The need for accurate specifications of requirements which reflect the organisations needs and provides equality of opportunity for suppliers when providing quotes and tenders.","FULLY MET"]
["16 - 19 & Adults","Core","K7","Levels of authority and autonomy both for self and other internal stakeholders and how that relates to the relevant procurement procedure and when issues should be escalated to senior procurement colleagues.","FULLY MET"]
["16 - 19 & Adults","Core","K8","Development and evaluation of requests for quotes and tenders and use of appropriate terms, conditions and templates","FULLY MET"]
["16 - 19 & Adults","Core","K9","The importance of maintaining accurate records and files for procurement in line with organisational and regulatory requirements and for audit purposes.","FULLY MET"]
["16 - 19 & Adults","Core","K10","Effective and appropriate communication methods according to organisational requirements, service level agreements and the degree of risk involved and appropriate to the task required e.g. expediting supplies, resolving invoice queries and supplier review meetings.","FULLY MET"]
["16 - 19 & Adults","Core","K11","Responsible procurement practices, in making procurement decisions, consideration of the impact of those decisions during the full procurement process on the environment (the circumstances, objects, or conditions by which they operate in) and social (people or groups they work with) elements across the supply chain. This may include the sustainability impacts of procurement and supply decisions on both upstream supply chain and the use of materials, products or applications over the lifetime.","FULLY MET"]
["16 - 19 & Adults","Core","K12","Research methods for Procurement  including market, supplier and sector research which may include subscription databases, market reports, internet research, trade bodies, press and events, use of market 'experts', supplier engagement events etc.","FULLY MET"]
["16 - 19 & Adults","Core","K13","The legal and regulatory environment effecting procurement, including the supply of goods and services act and/or public contract regulations.","FULLY MET"]
["16 - 19 & Adults","Core","K14","Awareness of the organisation's contractual obligations towards suppliers e.g. payment terms","FULLY MET"]
["16 - 19 & Adults","Core","K15","Understand the 4 processes of negotiation (preparation, opening, bargaining and closure).","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Monitor and order products, stock, equipment and services at appropriate times using the appropriate procurement method.","FULLY MET"]
["16 - 19 & Adults","Core","S2","Communicate to procurement's internal stakeholders, suppliers and other stakeholders in order to develop effective relationships and networks","FULLY MET"]
["16 - 19 & Adults","Core","S3","Create, maintain and amend purchase order and contract records.","FULLY MET"]
["16 - 19 & Adults","Core","S4","Interpret, evaluate and compare procurement  information such as historical spend and usage using databases and spreadsheets.","FULLY MET"]
["16 - 19 & Adults","Core","S5","Present findings and data in all formats e.g. mathematically, written and oral.","FULLY MET"]
["16 - 19 & Adults","Core","S6","Determine value for money (VFM) and added value through the use of Total Cost of Ownership during the evaluation process, and apply the most economically advantageous tender (MEAT) criteria to the evaluation of quotes and tenders to support the recommendation at award. This may include the inclusion of green, low carbon, sustainability, and ethical criteria.","FULLY MET"]
["16 - 19 & Adults","Core","S7","Utilise relevant Procurement computer systems or internal databases.","FULLY MET"]
["16 - 19 & Adults","Core","S8","Select the supplier of the most appropriate products and services for purchases within their remit and place purchase order.","FULLY MET"]
["16 - 19 & Adults","Core","S9","Undertake appraisal of adhoc and low spend suppliers including setting them up on the purchasing system.","FULLY MET"]
["16 - 19 & Adults","Core","S10","Effectively research and analyse demand, spend, trends, potential suppliers and industries utilising qualitative and quantitative methods.","FULLY MET"]
["16 - 19 & Adults","Core","S11","Develop specifications of requirements and requests for quotes/tenders in line with organisational requirements.","FULLY MET"]
["16 - 19 & Adults","Core","S12","Apply considerations of responsible procurement in evaluating potential suppliers, quotes and tenders.","FULLY MET"]
["16 - 19 & Adults","Core","S13","Investigate and resolve purchase order, delivery and invoice queries.","FULLY MET"]
["16 - 19 & Adults","Core","S14","Own low risk value projects such as supply contracts for stationery, personal protective equipment (PPE) or other consumables, and contribute to higher risk activities such as contracts for building services or machinery,  and track, log, expedite and review outstanding orders and stock availability where applicable.","FULLY MET"]
["16 - 19 & Adults","Core","S15","Maintain knowledge on all open orders and their status' and provide assistance to all purchasing staff e.g. expediting and feeding information back to the relevant stakeholders.","FULLY MET"]
["16 - 19 & Adults","Core","S16","Able to consider the impact of the decision making process when interacting with the supply chain.","FULLY MET"]
["16 - 19 & Adults","Core","S17","Able to support the contract negotiations and mini competitions with suppliers.","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Be open to change, amend working practices in response to changes in process with a positive attitude.","FULLY MET"]
["16 - 19 & Adults","Core","B2","Establish strong relationships with internal and external stakeholders","FULLY MET"]
["16 - 19 & Adults","Core","B3","Be open, honest, respectful and reliable..","FULLY MET"]
["16 - 19 & Adults","Core","B4","Be enthusiastic and passionate when adhering to company values and engaging in your personal development","FULLY MET"]
["16 - 19 & Adults","Core","B5","Be attentive to the detail in any procurement and negotiation activity.","FULLY MET"]
["16 - 19 & Adults","Core","B6","Be professional, impartial and unbiased in your communication, advice and recommendations to procurement stakeholders or colleagues.","FULLY MET"]
["16 - 19 & Adults","Core","B7","Be self-motivated to develop and learn.","FULLY MET"]

{"sheet":"OCC0887","index":4,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","10/07/2020"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0887 - Fundraiser"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","Commercial understanding of the third sector and fundraising environment, such as external and market factors that impact fundraising performance and the role of competitors and collaborators","FULLY MET"]
["16 - 19 & Adults","Core","K2","The different types of fundraising methods and how they are used, such as Community, Events, Philanthropy, Major Gifts, Individual Giving, Legacy, Monthly Giving, Foundations, Corporate Fundraising, Gift Aid","FULLY MET"]
["16 - 19 & Adults","Core","K3","Regulation, legislation and codes of practice relating to the fundraising environment, such as fundraising regulations, data protection compliance and ethical codes of practice,","FULLY MET"]
["16 - 19 & Adults","Core","K4","Methodologies to undertake internal and external analysis and evaluation of fundraising products and services, such as cost benefit analysis, statistical evaluation, principles of surveys, stakeholder analysis, STEEPLE, SWOT and ERIC frameworks","FULLY MET"]
["16 - 19 & Adults","Core","K5","The elementary Financial principles, such as income streams, cash flow, taxation, budgeting, forecasting, cost control and applying best procurement practice","FULLY MET"]
["16 - 19 & Adults","Core","K6",": The key components of a 'Case for Support', such as organisational aims, creative content to showcase the cause to supporters, impact of the work of the organisation, strategic aims, stakeholders and how these meet the needs of a supporter ","FULLY MET"]
["16 - 19 & Adults","Core","K7","The key components of a supporter journey, such as reward and recognition, maximising supporter commitment, appropriate communication, understanding donor motivation and tailoring supporter journey accordingly","FULLY MET"]
["16 - 19 & Adults","Core","K8","The key components of a Fundraising Plan, such as recording fundraising activities over a period of time, including campaign dates, area marketing and acquisition strategies, impact analysis, evaluation and budgeting","FULLY MET"]
["16 - 19 & Adults","Core","K9","Organisational understanding, such as purpose, mission statement, organisational strategy, values, company policies, brand guidelines, volunteering policies, complaints policy, health & safety policy, cash handling, lone working policy","FULLY MET"]
["16 - 19 & Adults","Core","K10","Different methods of communication to internal and external stakeholders, such as verbal, non-verbal, building rapport, designing fundraising and marketing materials, digital, mailings and newsletters","FULLY MET"]
["16 - 19 & Adults","Core","K11","Importance of accurately recording supporter information on a supporter relationship management system, to help inform fundraising activities and ensure data is compliant","FULLY MET"]
["16 - 19 & Adults","Core","K12","The internal and external dependencies that influence the success of fundraising, such as legal, health & safety, finance, operations, volunteers and suppliers","FULLY MET"]
["16 - 19 & Adults","Core","K13","How to approach and engage new and existing supporters to ask for both financial and non-financial support","FULLY MET"]
["16 - 19 & Adults","Core","K14","The different forms of donor motivation and how they influence the method of fundraising employed, the impact that has on the donor and their continued engagement with the cause","FULLY MET"]
["16 - 19 & Adults","Core","K15","How to approach, analyse and address problems","FULLY MET"]
["16 - 19 & Adults","Core","K16","Regulation, legislation, codes of practice and policies relating to inclusion, safeguarding and whistle-blowing","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Uses the most appropriate communication method for the message through the use of good questions and listening techniques","FULLY MET"]
["16 - 19 & Adults","Core","S2","Identify and apply pragmatic solutions using a range of methods to maximise value to the organisation","FULLY MET"]
["16 - 19 & Adults","Core","S3","Use data management (compliant with data protection regulation) and analysis to produce and present evidence to support, validate and/or review fundraising activity to different stakeholders, such as analysing the effectiveness of a fundraising event","FULLY MET"]
["16 - 19 & Adults","Core","S4","Evaluate and make unsupervised decisions quickly based on the current situation or environment","FULLY MET"]
["16 - 19 & Adults","Core","S5","Control, monitor and analyse expenditure and/or financial fundraising transactions to maximise spend on the organisation's charitable cause, including Gift Aid","FULLY MET"]
["16 - 19 & Adults","Core","S6","Use a variety of information sources (compliant with data protection regulation) to identify individuals, groups or organisations who can potentially provide effective support for the organisation","FULLY MET"]
["16 - 19 & Adults","Core","S7","Plan and prioritise time to ensure fundraising activities are managed well and fundraising potential is maximised","FULLY MET"]
["16 - 19 & Adults","Core","S8","Build relationships and identify, engage, sustain and satisfy the on-going needs of supporters and stakeholders by building rapport and trust, and resolve conflicts constructively","FULLY MET"]
["16 - 19 & Adults","Core","S9","Identify and apply appropriate technological solutions to improve the effectiveness of processes, procedures and development of fundraising activity","FULLY MET"]
["16 - 19 & Adults","Core","S10","Demonstrates self-awareness and recognises their own emotions and their impact on self and others.","FULLY MET"]
["16 - 19 & Adults","Core","S11","Adapt and tailor presentation style and technique to meet the needs of the audience","FULLY MET"]
["16 - 19 & Adults","Core","S12","Build a diverse network both internally and externally","FULLY MET"]
["16 - 19 & Adults","Core","S13","Articulate and communicate the mission, goals and activities of your organisation to influence others to engage with your cause, applying appropriate fundraising techniques such as networking, handling objections, negotiating and making an ask ","FULLY MET"]
["16 - 19 & Adults","Core","S14","Adapt working style depending on the situation or needs of the other person","FULLY MET"]
["16 - 19 & Adults","Core","S15","Identify, evaluate and apply solutions to problems as they arise","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Resilient and maintains a positive attitude","FULLY MET"]
["16 - 19 & Adults","Core","B2","Acts to put the organisation’s cause, and the needs of stakeholders at the centre of their fundraising activity","FULLY MET"]
["16 - 19 & Adults","Core","B3","Sources effective solutions, and seeks to continuously improve and develop","FULLY MET"]
["16 - 19 & Adults","Core","B4","Reliable and acts with integrity, empathy, honesty and trustworthiness","FULLY MET"]
["16 - 19 & Adults","Core","B5","Works collaboratively to deliver fundraising activities","FULLY MET"]

{"sheet":"OCC0584","index":5,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","18/02/2019"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0584 - Funeral director"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","How to support team members to establish client needs and wishes when dealing with clients during the grieving process. The importance of accurately assessing client needs. The profile of the current client base and the business aims and objectives for client services. The importance of acting on behalf of the client. How to handle client concerns, complaints and compliments escalated to them.","FULLY MET"]
["16 - 19 & Adults","Core","K2","How to manage the protection of the business reputation based on business values, vision, aims and behaviours. The market share of the business and their competition. The local demographic/community and how to use it to cultivate a positive reputation of the business. How technology and applications affect business objectives and reputation.","FULLY MET"]
["16 - 19 & Adults","Core","K3","How to organise the team on a daily basis to achieve short and long-term objectives. How and why to carry out a team brief / debrief. Team dynamics and different leadership styles. How to lead by example and the importance of doing so. The importance of and how and when to make contingency plans. How to support team members during the funeral arrangement process. Limits of own authority within the business and who decision makers/stakeholders are in the business.","FULLY MET"]
["16 - 19 & Adults","Core","K4","All legislation relating to the sector, including the roles and responsibilities of external agencies and authorities. Business governance requirements relating to funeral procedures and working with the deceased and the client. The legalities surrounding specialist funeral services. ","FULLY MET"]
["16 - 19 & Adults","Core","K5","The importance of and know how to develop self and team. How development affects both business and team objectives. Where and how to source development activities for self and team.  The importance of acting as a role model, mentor and coach for your team.","FULLY MET"]
["16 - 19 & Adults","Core","K6","The developments in industry products and services and where to access information regarding these. The importance of keeping the team up to date with new and current products and services. How to promote products and services to the team and local community.","FULLY MET"]
["16 - 19 & Adults","Core","K7","How to support effective communication, quickly determining the situation and needs of individuals. How to respond in the most appropriate way using a variety of techniques. The way that technology assists with internal and external communications according to business guidelines. The importance of managing and avoiding conflict.","FULLY MET"]
["16 - 19 & Adults","Core","K8","The business operating procedures, for example the processing and security of donations and debt management. The principles of operating commercially and ethically (social responsibility). Future client markets to help grow the business. The need to gather feedback, analyse it and its contribution to business improvements.","FULLY MET"]
["16 - 19 & Adults","Core","K9","The importance of and how to monitor pre-funeral checks in accordance with business needs. How to plan, resource and conduct a funeral in accordance with the client’s wishes.","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Lead the team to use established strategies when handling grieving clients. Build a rapport with clients anticipating their requirements and providing excellent service. Handle and resolve clients concerns, complaints and compliments.","FULLY MET"]
["16 - 19 & Adults","Core","S2","Lead a service, which delivers business vision and values when dealing with clients, colleagues and all stakeholders. Work to improve the profitability and reputation of the business whilst being respectful to competitors. Create opportunities to introduce / promote the business at local events, assist with fund raising and support community services. Manage and monitor the appropriate use of technologies meeting business objectives.","FULLY MET"]
["16 - 19 & Adults","Core","S3","Supervise and manage the day-to-day running of the business. Carry out briefings and debriefings to organise the team to meet business objectives. Lead the team effectively responding positively to different group dynamics and personalities. Design and manage contingencies according to own role and business needs. Act within limits of own authority making decisions and escalating to business decision makers/stakeholders when necessary.","FULLY MET"]
["16 - 19 & Adults","Core","S4","Apply legal requirements for the sector whilst supervising staff working with external agencies and authorities. Supervise operations according to the business’ governance, policies and procedures. Organise and support colleagues to coordinate specialist funeral services within legal requirements.","FULLY MET"]
["16 - 19 & Adults","Core","S5","Facilitate continuous professional development activities and use newly acquired skills and knowledge to improve business, self and others. Research, source and implement development activities. Identify training needs with team members, arrange and/or deliver development activities to others.","FULLY MET"]
["16 - 19 & Adults","Core","S6","Cascade up-to-date information to the team regarding new and current products and services. Empower the team to be confident when offering choice to the client.","FULLY MET"]
["16 - 19 & Adults","Core","S7","Give appropriate responses to all forms of communication, showing an ability to interpret a range of cues. Monitor the effectiveness of and encourage excellent communications across all operations that achieve the best result for the business.","FULLY MET"]
["16 - 19 & Adults","Core","S8","Manage business information systems and procedures. Use ethical practices to support profitability and maintain own business’ social responsibilities. Analyse management information and suggest ways to improve business performance.","FULLY MET"]
["16 - 19 & Adults","Core","S9","Show ability to take control and ownership of events on the day of the funeral.","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Lead the team to use empathy and sensitivity during all interactions with clients from first call through to final contact. Act as a role model remaining calm, managing concerns, complaints and compliments and seeking resolutions in a timely manner.","FULLY MET"]
["16 - 19 & Adults","Core","B2","Be an ambassador and lead by example to create a positive impression of the business at all times. Analyse information to keep informed of reputation, market share and competitors. Organise events in the local community utilising the skills of the team. Create opportunities to use technology in responsible and innovative ways.","FULLY MET"]
["16 - 19 & Adults","Core","B3","Adopt a leadership style that contributes to a harmonious, inclusive and safe work environment. Respond positively and calmly using own initiative to create solutions and seek assistance when necessary. Share positive feedback, successes and key learnings with the team and stakeholders.","FULLY MET"]
["16 - 19 & Adults","Core","B4","Lead by example, working safely, honestly and with integrity and respect at all times. Promote good working practices in line with all relevant legislation.","FULLY MET"]
["16 - 19 & Adults","Core","B5","Positively challenge and manage performance of self and others, identifying strengths and areas for development.\nInspire and motivate others through coaching and mentoring.","FULLY MET"]
["16 - 19 & Adults","Core","B6","Ethically promote own business and improve profitability.","FULLY MET"]
["16 - 19 & Adults","Core","B7","Promote the use of effective communication methods.","FULLY MET"]
["16 - 19 & Adults","Core","B8","Work ethically when operating and supervising administrative and financial duties.","FULLY MET"]
["16 - 19 & Adults","Core","B9","Lead by example and manage funeral services in a calm and respectful way, handling conflict when necessary.","FULLY MET"]

{"sheet":"OCC0056","index":6,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","29/01/2019"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0056 - Bid and proposal co-ordinator"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","Understanding the sales life cycle and how it all fits together; from opportunity tracking/pipeline, customer engagement, capture planning, competitive tendering, presentations, negotiations, contract award, implementation and delivery","FULLY MET"]
["16 - 19 & Adults","Core","K2","Understand and follow a detailed proposal process from opportunity qualification/Request for Information (RFI) stage, solution development, bid resource allocation, proposal writing and development, production and submission","FULLY MET"]
["16 - 19 & Adults","Core","K3","Understand when to use appropriate supporting templates and procedures, ensuring necessary steps, reviews and signatories are planned prior to proposal submissions","FULLY MET"]
["16 - 19 & Adults","Core","K4","Know how to use bid software to compile electronic submissions and understand how e-portals work, including how and where electronic tenders are handled","FULLY MET"]
["16 - 19 & Adults","Core","K5","Understand how to assist in the dissection of a bid and identify the customers key requirements","FULLY MET"]
["16 - 19 & Adults","Core","K6","Understand the relevant customer key issues and win strategy for individual proposals/bids","FULLY MET"]
["16 - 19 & Adults","Core","K7","Understand a range of tools and methods to analyse a proposal e.g. SWOT analysis","FULLY MET"]
["16 - 19 & Adults","Core","K8","Awareness of commercial and pricing positioning and frameworks “ to best describe value versus cost","FULLY MET"]
["16 - 19 & Adults","Core","K9","Understand the importance of contract management and the key areas for risk and mitigation of contracts","FULLY MET"]
["16 - 19 & Adults","Core","K10","Awareness of the importance of handling data, confidentiality, data protection, competition law and relevant business commercial policy","FULLY MET"]
["16 - 19 & Adults","Core","K11","The importance of relevant, high quality and up to date content including case studies and evidence","FULLY MET"]
["16 - 19 & Adults","Core","K12","Know how and when to use sensitive and confidential information","FULLY MET"]
["16 - 19 & Adults","Core","K13","Maintaining relevant certificates for registrations, accreditations memberships, frameworks, records and subscriptions","FULLY MET"]
["16 - 19 & Adults","Core","K14","Understand the roles and responsibilities required for each bid and proposal lifecycle, including bid managers, proposal management, writers, document managers, graphics and knowledge base managers","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Excellent organisational and time management skills to manage multiple activities simultaneously and prioritise own and others workloads","FULLY MET"]
["16 - 19 & Adults","Core","S2","Ability to meet defined deadlines and set own milestones to manage workload","FULLY MET"]
["16 - 19 & Adults","Core","S3","Ability to create and utilise a bid plan timetable and responsibility matrix, supporting virtual team adherence to process","FULLY MET"]
["16 - 19 & Adults","Core","S4","Contribute to proposal project timetable including the timely collection of data from various parties including sub-contractors, consultants and internal subject experts","FULLY MET"]
["16 - 19 & Adults","Core","S5","Ability to meet bid submission deadlines according to guidelines / instructions","FULLY MET"]
["16 - 19 & Adults","Core","S6","Logging and capture of all proposal data in central repository","FULLY MET"]
["16 - 19 & Adults","Core","S7","Able to maintain a healthy work life balance and understand the reasons why it is important to do so","FULLY MET"]
["16 - 19 & Adults","Core","S8","Maintain compliance matrices to ensure compliance to all questions Capable of managing multiple projects and deadlines","FULLY MET"]
["16 - 19 & Adults","Core","S9","Ability to proof read with an eye for detail","FULLY MET"]
["16 - 19 & Adults","Core","S10","Good creative writing skills and good grammar/authoring","FULLY MET"]
["16 - 19 & Adults","Core","S11","Collate proposal documents using library/information stores, search engines/corporate directories","FULLY MET"]
["16 - 19 & Adults","Core","S12","Ability to use a range of tools, methods and search engines, to analyse and assimilate data, such as competitor analysis or customer research","FULLY MET"]
["16 - 19 & Adults","Core","S13","Good verbal and written communication skills, and ability to communicate professionally with colleagues at all levels of the business","FULLY MET"]
["16 - 19 & Adults","Core","S14","Liaise with sales/legal/finance teams and other virtual team members as necessary","FULLY MET"]
["16 - 19 & Adults","Core","S15","The importance of putting the customer first and tailoring bid documents to their needs, wants and requirements","FULLY MET"]
["16 - 19 & Adults","Core","S16","Work and engage with colleagues and virtual teams, leveraging relationships and networks to support information gathering and writing","FULLY MET"]
["16 - 19 & Adults","Core","S17","Build relationships with colleagues and subject matter experts across the business, learning the go to people and how to manage their input","FULLY MET"]
["16 - 19 & Adults","Core","S18","Build rapport and trust","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","A self-starter, with a desire to succeed","FULLY MET"]
["16 - 19 & Adults","Core","B2","Uses initiative to ensure effective workload management, deadlines and co- ordination of activities","FULLY MET"]
["16 - 19 & Adults","Core","B3","Willing to work flexibly to ensure that workload is managed effectively and deadlines are achieved","FULLY MET"]
["16 - 19 & Adults","Core","B4","Awareness of self and impact on others","FULLY MET"]
["16 - 19 & Adults","Core","B5","Able to work across large and virtual teams","FULLY MET"]
["16 - 19 & Adults","Core","B6","A drive to win","FULLY MET"]
["16 - 19 & Adults","Core","B7","A desire to go the extra mile to deliver winning bids","FULLY MET"]
["16 - 19 & Adults","Core","B8","Always acts professionally and ethically, protecting confidentiality of the organisation and customers.","FULLY MET"]
["16 - 19 & Adults","Core","B9","Willingness to continuously look for new and better ways of working, whilst considering the underlining best practice processes","FULLY MET"]

{"sheet":"OCC0644","index":7,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","08/11/2018"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0644 - Advertising and media executive"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K1","The role creative and media plays for clients and the links to commercial objectives","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K2","Project management techniques","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K3","The systems and digital technologies that are used in agencies such as Sage, scheduling tools and Excel","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K4","Construction of accurate and timely reports and minutes","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K5","The lifecycle of an advertising campaign i.e. what needs to happen when","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K6","The different roles performed by different agencies (mainly media and creative), different parts of agencies and the core services of their own organisation","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K7","The key legal, regulatory and ethical issues for advertising  and media, e.g. advertising to children, data regulation with relevance to advertising, General Data Protection Regulation compliance","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K8","The commercial dynamics of advertising and media","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K9","The foundation advertising landscape and how it is changing e.g. the impact of digital technology and platforms, the proliferation of options for content and media, the complex consumer journey to purchase, the rise of big data, the corporate landscape, how advertising’s effectiveness is evaluated","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K10","Principles of third party (e.g. client, supplier, regulatory body) management and delivery","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K11","Understands the value the supply chain can provide e.g. digital marketing","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","K12"," Understands the digital landscape and how it impacts on any given campaign","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","K13","The creative process/dynamic and how people operate in that environment; how to communicate effectively with each group","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","K14"," New creative and production techniques, tools and trends e.g. using Influencers to reach audiences, using Snapchat Stories, how to use virtual reality, the possible benefits of Artificial Intelligence","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","K15","Understand the different elements of a creative idea (copy and art direction) and its execution, understanding the relative importance of those different elements, e.g. does a change to the execution change the idea?","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","K16"," Understand how the effectiveness of a campaign is measured against client business objectives","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","K17","Understand the fundamentals of why brand building is important","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","K18","How to influence people e.g. listen to them, always try for win:win","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","K19","The media buying process/dynamic and how people operate and negotiate in that environment","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","K20","New media buying techniques, tools and trends e.g. new programmatic (automated) media buying platforms; using new digital mediums such as Twitter, Spotify; new data sources from Google and others","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","K21","Up to date media metrics e.g. latest Google Adwords, latest viewing figures from Broadcasters Audience Research Board","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","K22"," Understands how the location and timing of media interacts with creative content","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","K23","Understand how media planning and buying is evaluated short and long term","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S1","Identify the ways in which creative and media can help organisations to achieve corporate objectives","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S2","Dispassionately structure problems and approaches to solving them","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S3","Manage projects using project management techniques in order to ensure campaigns are on track, e.g. accurate timing plans, and they are also successfully managing their to do list","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S4","Make use of the systems and technologies that are used in agencies to help plan, budget and bill","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S5","Produce professional communication e.g. correct names, spelling, grammar, branding on e.g. PowerPoint, emails, minutes, reports","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S6","Manage timelines effectively, prioritising appropriately","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S7"," Apply knowledge of the interface and the dynamics of the different agencies (mainly media and creative) for a smooth flow of work","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S8","Adhere to the legislative regulations that apply in the advertising and media industry plus their own organisational policies and procedures","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S9","Demonstrate some upward, some supplier and client management around commercial realities e.g. a new digital opportunity or a TV production problem","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S10","Help solve practical and creative problems (e.g. report on consumer habits, gathering useful data around evaluation) within defined budgets and timescales, influencing outcomes without jeopardising relationships","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S11"," Use third party management techniques combined with interpersonal skills (e.g. active listening, and influencing) to communicate effectively with all, e.g. coordinating response to a client brief","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S12","Ensures the delivery of that supply chain value, on time","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","S13","Deploy the right digital medium to guarantee the most effective result e.g, using Google Analytics to check key words","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","S14","Communicate with clients, colleagues, regulatory bodies (such as the Advertising Standards Authority or Clearcast), suppliers (such as photographers or research companies); by phone, in meetings, through presentations, in emails and written documents such as agendas, competitive reviews, proposals, minutes of calls/meetings, status reports.  Co-ordinate feedback.","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","S15","Apply their understanding of creative and production  techniques to help the idea appear in the correct  format","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","S16","Apply their understanding of the different elements of a creative idea to help evaluate the different elements and guide the execution phase to protect the most important ones","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","S17","Help obtain the right data","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","S18","Able to understand and report differences in ways competitor brands market themselves","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialist","S19","Ability to influence people e.g. clients to buy amended creative work or authorise a late invoice","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","S20"," Coordinate responses to media owners and intermediaries (including automated platforms), helping manage all aspects of the process","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","S21"," Apply their knowledge of media buying to communicate with clients, colleagues, regulatory bodies (such as the Advertising Standards Authority), media owners (such as commercial television channels, newspapers/magazines, billboard companies etc.), or media intermediaries/platforms (such as programmatic advertising platforms, Facebook, Google); by phone, in meetings, through presentations, in emails and written documents such as a media plan","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","S22","How to access the media metric data and report it accurately to the team regularly","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","S23","Help research how the message/creative idea might be best distributed to reach the target audience in the most effective way e.g. time of day, and make recommendations based on this","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","S24","Help obtain the right data","FULLY MET"]
["16 - 19 & Adults","Option 2: Advertising & media executive media specialist","S25","How to negotiate for long term relationships","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B1","Flexible problem solver with ability to help the team prioritise effectively","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B2"," Shows attention to detail","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B3","Embraces problems as challenges to be solved, displays 'can-do' attitude","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B4","Behaves with versatility and others respond positively to them (they are \"likable\")","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B5"," Display empathy and patience with a variety of different personality types and others respond positively to them","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B6","Exhibits curiosity about people, their motivations and how to get the best out of them","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B7","Exhibits curiosity about the industry, positive approach to learning","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B8","Shows resilience (e.g. doesn't take things too personally, keeps going through difficult situations)","FULLY MET"]
["16 - 19 & Adults","01: Advertising & media executive creative specialistOption 2: Advertising & media executive media specialist","B9","Takes responsibility for learning under pressure","FULLY MET"]

{"sheet":"OCC0071","index":8,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","10/05/2018"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0071 - Customer service specialist"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","Business: Understand what continuous improvement means in a service environment and how your recommendations for change impact your organisation","FULLY MET"]
["16 - 19 & Adults","Core","K2","Business: Understand the impact your service provision has on the wider organisation and the value it adds","FULLY MET"]
["16 - 19 & Adults","Core","K3","Business: Understand your organisation’s current business strategy in relation to customers and make recommendations for its future","FULLY MET"]
["16 - 19 & Adults","Core","K4","Business: Understand the principles and benefits of being able to think about the future when taking action or making service related decisions","FULLY MET"]
["16 - 19 & Adults","Core","K5","Business: Understand a range of leadership styles and apply them successfully in a customer service environment","FULLY MET"]
["16 - 19 & Adults","Core","K6","Customer Insight: Know your internal and external customers and how their behaviour may require different approaches from you","FULLY MET"]
["16 - 19 & Adults","Core","K7","Customer Insight: Understand how to analyse, use and present a range of information to provide customer insight","FULLY MET"]
["16 - 19 & Adults","Core","K8","Customer Insight: Understand what drives loyalty, retention and satisfaction and how they impact on your organisation","FULLY MET"]
["16 - 19 & Adults","Core","K9","Customer Insight: Understand different customer types and the role of emotions in bringing about a successful outcome","FULLY MET"]
["16 - 19 & Adults","Core","K10","Customer Insight: Understand how customer expectations can differ between cultures, ages and social profiles","FULLY MET"]
["16 - 19 & Adults","Core","K11","Customer Service culture & environment awareness: Keep current, knowledge and understanding of regulatory considerations, drivers and impacts in relation to how you deliver for customers","FULLY MET"]
["16 - 19 & Adults","Core","K12","Customer Service culture & environment awareness: Understand your business environment and culture and the position of customer service within it","FULLY MET"]
["16 - 19 & Adults","Core","K13","Customer Service culture & environment awareness: Understand your organisation structure and what role each department needs to play in delivering Customer Service and what the consequences are should things go wrong","FULLY MET"]
["16 - 19 & Adults","Core","K14","Customer Service culture & environment awareness: Understand how to find and use industry best practice to enhance your own knowledge","FULLY MET"]
["16 - 19 & Adults","Core","K15","Customer Journey: Understand and critically evaluate the possible journeys of your customers, including challenges and the end-to-end experience","FULLY MET"]
["16 - 19 & Adults","Core","K16","Customer Journey: Understand the reasons why customer issues and complex situations sometimes need referral or escalation for specialist attention","FULLY MET"]
["16 - 19 & Adults","Core","K17","Customer Journey: Understand commercial factors and authority limits for delivering the required customer experience","FULLY MET"]
["16 - 19 & Adults","Core","K18","Customer Journey: Understand the underpinning business processes that support you in bringing about the best outcome for customers and your organisation","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Business focused service delivery: Demonstrate a continuous improvement and future focussed approach to customer service delivery including decision making and providing recommendations or advice","FULLY MET"]
["16 - 19 & Adults","Core","S2","Business focused service delivery: Resolve complex issues by being able to choose from and successfully apply a wide range of approaches","FULLY MET"]
["16 - 19 & Adults","Core","S3","Business focused service delivery: Find solutions that meet your organisations needs as well as the customer requirements","FULLY MET"]
["16 - 19 & Adults","Core","S4","Providing a positive customer experience: Through advanced questioning, listening and summarising negotiate mutually beneficial outcomes","FULLY MET"]
["16 - 19 & Adults","Core","S5","Providing a positive customer experience: Manage challenging and complicated situations within your level of authority and make recommendations to enable and deliver change to service or strategy","FULLY MET"]
["16 - 19 & Adults","Core","S6","Providing a positive customer experience: Use clear explanations, provide options and solutions to influence and help customers make choices and agree next steps","FULLY MET"]
["16 - 19 & Adults","Core","S7","Providing a positive customer experience: Explore and interpret the customer experience to inform and influence achieving a positive result for customer satisfaction","FULLY MET"]
["16 - 19 & Adults","Core","S8","Providing a positive customer experience: Demonstrate a cost conscious mind-set when meeting customer and the business needs","FULLY MET"]
["16 - 19 & Adults","Core","S9","Providing a positive customer experience: Identifying where highs and lows of the customer journey produce a range of emotions in the customer","FULLY MET"]
["16 - 19 & Adults","Core","S10","Providing a positive customer experience: Use written and verbal communication to simplify and provide complex information in a way that supports positive customer outcome in the relevant format","FULLY MET"]
["16 - 19 & Adults","Core","S11","Working with customers/customer insights: Proactively gather customer feedback, through a variety of methods. Critically analyse, and evaluate the meaning, implication and facts and act upon it","FULLY MET"]
["16 - 19 & Adults","Core","S12","Working with customers/customer insights: Analyse your customer types, to identify or anticipate their potential needs and expectations when providing your service","FULLY MET"]
["16 - 19 & Adults","Core","S13","Customer Service performance: Maintain a positive relationship even when you are unable to deliver the customer’s expected outcome","FULLY MET"]
["16 - 19 & Adults","Core","S14","Customer Service performance: When managing referrals or escalations take into account historical interactions and challenges to determine next steps","FULLY MET"]
["16 - 19 & Adults","Core","S15","Service Improvement: Analyse the end to end service experience, seeking input from others where required, supporting development of solutions","FULLY MET"]
["16 - 19 & Adults","Core","S16","Service Improvement: Make recommendations based on your findings to enable improvement","FULLY MET"]
["16 - 19 & Adults","Core","S17","Service Improvement: Make recommendations and implement where possible, changes in line with new and relevant legislation, regulations and industry best practice","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Develop self: Proactively keep your service, industry and best practice knowledge and skills up-to-date","FULLY MET"]
["16 - 19 & Adults","Core","B2","Develop self: Consider personal goals related to service and take action towards achieving them","FULLY MET"]
["16 - 19 & Adults","Core","B3","Ownership/Responsibility: Personally commit to and take ownership for actions to resolve customer issues to the satisfaction of the customer and your organisation","FULLY MET"]
["16 - 19 & Adults","Core","B4","Ownership/Responsibility: Exercises proactivity and creativity when identifying solutions to customer and organisational issues","FULLY MET"]
["16 - 19 & Adults","Core","B5","Ownership/Responsibility: Make realistic promises and deliver on them","FULLY MET"]
["16 - 19 & Adults","Core","B6","Team Working: Work effectively and collaboratively with colleagues at all levels to achieve results","FULLY MET"]
["16 - 19 & Adults","Core","B7","Team Working: Recognise colleagues as internal customers","FULLY MET"]
["16 - 19 & Adults","Core","B8","Team Working: Share knowledge and experience with others to support colleague development","FULLY MET"]
["16 - 19 & Adults","Core","B9","Equality: Adopt a positive and enthusiastic attitude being open minded and able to tailor your service to each customer","FULLY MET"]
["16 - 19 & Adults","Core","B10","Equality: Be adaptable and flexible to your customer needs whilst continuing to work within the agreed customer service environment","FULLY MET"]
["16 - 19 & Adults","Core","B11","Presentation: Demonstrate brand advocacy, values and belief when dealing with customer requests to build trust, credibility and satisfaction","FULLY MET"]
["16 - 19 & Adults","Core","B12","Presentation: Ensure your personal presentation, in all forms of communication, reflects positively on your organisation’s brand","FULLY MET"]

{"sheet":"OCC0168","index":9,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","12/01/2017"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0168 - Event assistant"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","Operational: How an event moves through its lifecycle from research and planning to delivery and evaluation.","FULLY MET"]
["16 - 19 & Adults","Core","K2","Operational: The respective roles of different functions: logistics, production, creative and design in event management; what each area is responsible for and how they contribute to the successful delivery of an event.","FULLY MET"]
["16 - 19 & Adults","Core","K3","Operational: How different venues may be suited a particular event based on clients’ needs.","FULLY MET"]
["16 - 19 & Adults","Core","K4","Operational: How event logistics can impact on the smooth running of an event.","FULLY MET"]
["16 - 19 & Adults","Core","K5","Operational: Each aspect of event logistics: the venue, delegate management, transportation, accommodation, catering.","FULLY MET"]
["16 - 19 & Adults","Core","K6","Operational: How the event suppliers combine to contribute to deliver an event.","FULLY MET"]
["16 - 19 & Adults","Core","K7","Operational: What the onsite team at an event are responsible for and how they work to ensure  that the client’s and all the delegates needs are met.","FULLY MET"]
["16 - 19 & Adults","Core","K8","Operational: Regulation and policies that are relevant to your job role.","FULLY MET"]
["16 - 19 & Adults","Core","K9","Professional: Why clients’ choose to hold events, what purpose they serve, and how they would evaluate different types of events.","FULLY MET"]
["16 - 19 & Adults","Core","K10","Professional: What clients typically expect from a department or company who is organising the event, and the importance of meeting or exceeding clients’ expectations.","FULLY MET"]
["16 - 19 & Adults","Core","K11","Professional: The importance of client feedback – dealing with it and using it to improve.","FULLY MET"]
["16 - 19 & Adults","Core","K12","Professional: Importance of time-keeping, attendance, personal presentation and conduct and how this reflects on the company or department that is responsible for organising events for clients.","FULLY MET"]
["16 - 19 & Adults","Core","K13","Professional: The importance of being flexible to the needs of urgent requirements for an event.","FULLY MET"]
["16 - 19 & Adults","Core","K14","Commercial: Develop an understanding of the business, its competitors, and how success is measured.","FULLY MET"]
["16 - 19 & Adults","Core","K15","Commercial: How the role of the Event Assistant contributes to business success.","FULLY MET"]
["16 - 19 & Adults","Core","K16","Commercial: Understand how an event budget is constructed and managed.","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Operational: Gather facts and collate information in response to a brief or request, like searching for the right location and venue for an event.","FULLY MET"]
["16 - 19 & Adults","Core","S2","Operational: Respond to requests from the different functional teams and carry out a variety of daily and weekly tasks to assist in the planning and preparation of an event.","FULLY MET"]
["16 - 19 & Adults","Core","S3","Operational: Provide assistance onsite at an event by registering delegates or by helping to assist the onsite team with a variety of tasks.","FULLY MET"]
["16 - 19 & Adults","Core","S4","Operational: Manage your time effectively by understanding how to prioritise tasks according to their importance and urgency for the stakeholders of an event.","FULLY MET"]
["16 - 19 & Adults","Core","S5","Operational: Use software packages to create word processing and spreadsheet documents.","FULLY MET"]
["16 - 19 & Adults","Core","S6","Operational: Contribute to reports, event project plans and written presentations for clients","FULLY MET"]
["16 - 19 & Adults","Core","S7","Operational: Use a range of event technology platforms and in-house bespoke software systems and databases.","FULLY MET"]
["16 - 19 & Adults","Core","S8","Operational: Show careful attention to regulations and internal policies.","FULLY MET"]
["16 - 19 & Adults","Core","S9","Professional: Listen, interpret, understand, vocalise and respond to clients’ needs.","FULLY MET"]
["16 - 19 & Adults","Core","S10","Professional: Speak and write clearly in order to prepare written communications or provide instructions that are needed for a client, supplier or team member.","FULLY MET"]
["16 - 19 & Adults","Core","S11","Professional: Build rapport and trust with the stakeholders of an event so that stakeholders can collaborate well throughout the planning and organisation processes.","FULLY MET"]
["16 - 19 & Adults","Core","S12","Professional: Question effectively to ensure understanding of what is required from clients or colleagues.","FULLY MET"]
["16 - 19 & Adults","Core","S13","Professional: Have the skills to maintain relationships with colleagues, suppliers or clients once they are built, and be able to repair them when they are damaged.","FULLY MET"]
["16 - 19 & Adults","Core","S14","Professional: Work effectively within a group environment to prepare for, deliver and/or follow up after an event takes place.","FULLY MET"]
["16 - 19 & Adults","Core","S15","Commercial: Assist in the preparation, management and reconciliation of event budgets by collecting information, checking data and making calculations.","FULLY MET"]
["16 - 19 & Adults","Core","S16","Commercial: Show how commercial awareness has been applied through task and time management, specifically using efficient and effective measures to conclude a project in the most proficient way.","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Have an enthusiastic and positive approach to providing swift and accurate service.","FULLY MET"]
["16 - 19 & Adults","Core","B2","Show tact and discretion with sensitive information.","FULLY MET"]
["16 - 19 & Adults","Core","B3","Contribute to conversations with team members and share ideas with confidence.","FULLY MET"]
["16 - 19 & Adults","Core","B4","Remain calm and positive under pressure.","FULLY MET"]
["16 - 19 & Adults","Core","B5","Take pride in producing accurate work with a consistently strong attention to detail, seeking clarity where necessary.","FULLY MET"]
["16 - 19 & Adults","Core","B6","Use initiative when faced with problems or challenges, and be flexible to the needs of the project.","FULLY MET"]
["16 - 19 & Adults","Core","B7","Demonstrate consideration and respect for team members regardless of sex, race, religion and other differences.","FULLY MET"]
["16 - 19 & Adults","Core","B8","Frequently seek and act upon feedback, reflect on performance and show commitment to self-development","FULLY MET"]
["16 - 19 & Adults","Core","B9","Demonstrate personal commitment to sustainability by minimising the negative affect on the environment caused by work activities.","FULLY MET"]

{"sheet":"OCC0077","index":10,"n_rows":72,"n_cols":9,"rows_kept":72,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.1"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","10/09/2018"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0077 - Advanced butcher"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","The management of food safety & hygiene practices including cleaning and disinfection arrangements","FULLY MET"]
["16 - 19 & Adults","Core","K2","The implementation of health and safety policy and application within the business or function. Also understanding of equality and diversity regulations and good practice","FULLY MET"]
["16 - 19 & Adults","Core","K3","The principles and comparisons involved in the science of various meat and poultry species and effects on the selection, cutting and production process","FULLY MET"]
["16 - 19 & Adults","Core","K4","The principles of animal welfare, selection, procurement and purchasing processes and the influence that provenance may contribute in the farm to fork supply chain for various red and white meat","FULLY MET"]
["16 - 19 & Adults","Core","K5","C: The end to end process for primal butchery in the meat business that starts from carcass selection, sides, or quarters, moving to separation from carcass and yield controls","FULLY MET"]
["16 - 19 & Adults","Core","K6","The principles and variations involved in the chilling, maturation, handling and storage of red and white meat as it goes through the cutting and/or processing","FULLY MET"]
["16 - 19 & Adults","Core","K7","The origins and nature of animal organs and tissues specified as Offal which is intended for sale to the customer /consumer in accordance with purchasing specifications and trade description requirement and Law","FULLY MET"]
["16 - 19 & Adults","Core","K8","The standard operating procedures for grading meat, stock handling, cold storage, temperature controls and maturation","FULLY MET"]
["16 - 19 & Adults","Core","K9","How to respond to the various needs of customers from across communities, religions and dietary requirements and develop new plated and/or oven ready products and pastries","FULLY MET"]
["16 - 19 & Adults","Core","K10","Cold and hot meat curing and smoking techniques","FULLY MET"]
["16 - 19 & Adults","Core","K11","Merchandising, labelling, food allergen awareness and wider food store products","FULLY MET"]
["16 - 19 & Adults","Core","K12","Management techniques including delegation, team building, mentoring, interviewing. appraisal and performance of self and team members as required","FULLY MET"]
["16 - 19 & Adults","Core","K13","Sales practices including wholesale distribution and meat procurement","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","K14","Understand and display a thorough knowledge of the procurement of meat through the retail business and be able to champion fresh meat","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","K15","Understand the principles of artisan butchery and be able to cut and bone at least four meat species including poultry &/or game whilst displaying associated techniques that apply to the retail environment","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","K16","Understand marketing and promotional techniques used to ‘sell’ the retail business making use of social /web media to maximise the exposure of the business","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","K17","Understand how to plan, co-ordinate and advise on cooking methods such as roasting, steam & bake-off operations in the retail environment","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","K18","Know how to recruit locally, retain, train and develop the right people for the right roles in the retail business.","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","K19","Understand how to implement and manage stock control systems for the shop environment including effective procurement and purchase of non-meat products for sale to domestic customers","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","K20","Understand key business operations such as energy supply, insurance registrations, payroll systems, and basic bookkeeping and filing returns","FULLY MET"]
["16 - 19 & Adults","02: Processing plant","K21","Understand and apply the legislative and regulatory requirements that apply for the safe, healthy and clean processing environment adhering to standard operating practices","FULLY MET"]
["16 - 19 & Adults","02: Processing plant","K22","Understand the sales, procurement and selection process within the processing business environment","FULLY MET"]
["16 - 19 & Adults","02: Processing plant","K23","Understand minimisation approaches to the management of meat ensure staff and teams are adhering to business operating practices","FULLY MET"]
["16 - 19 & Adults","02: Processing plant","K24","Understand how to plan and manage production schedules and change over methods in the meat processing environment","FULLY MET"]
["16 - 19 & Adults","02: Processing plant","K25","Understand how to co-ordinate despatch and transport of orders in food operations","FULLY MET"]
["16 - 19 & Adults","03: In store butchery in a supermarket","K26","Understand the supermarket product offer, display of pre-pack meat via cabinet, merchandising and placement policies keeping self and team up to date with brand developments and promotions","FULLY MET"]
["16 - 19 & Adults","03: In store butchery in a supermarket","K27","Understand the stock management and control (eg IPOS) system to minimise losses on out of date or damaged meat products. Ensure rotational processes are in place and react quickly to results to maintain business standards and stock requirements","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Demonstrate full awareness and take responsibility for food safety, HACCP and health and safety practices with in their respective butchery functions and/or retailing environments","FULLY MET"]
["16 - 19 & Adults","Core","S2","Demonstrate technical abilities & support others in the use of knives, hand saws, cleavers, banding needles and other relevant hand tools used in the process of primal cutting, boning, slicing, dicing, rolling, trimming and filleting as applicable to the butchery business","FULLY MET"]
["16 - 19 & Adults","Core","S3","Produce/Contribute to making of company recipe sausages/pies and/or develop new meat products made to the specifications of local markets and/or customer requests","FULLY MET"]
["16 - 19 & Adults","Core","S4","Take responsibility for the cold storage and cutting environment including temperature control, staff supervision, safety, hanging, handling and storage of meat","FULLY MET"]
["16 - 19 & Adults","Core","S5","Communicate effectively in a variety of ways with internal colleagues and with customers. This will involve compilation of reports, presentations to staff/customers and competent use of ICT systems","FULLY MET"]
["16 - 19 & Adults","Core","S6","Monitor and respond to the sales environment suggesting new and improved products for development and using initiative to prevent or solve problems as they may occur","FULLY MET"]
["16 - 19 & Adults","Core","S7","Supervise the sales environment, organising self and others to ensure deadlines are met including cash, stock and financial administration of the business or area of responsibility","FULLY MET"]
["16 - 19 & Adults","Core","S8","Monitor, manage and respond to the sales performance of the retail business, including review of customer behaviour, sales patterns and product enhancement and/or placement","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","S9","Develop and implement sales strategies and methods for maximising income including loyalty schemes, promotions and additional product development","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","S10","Produce a range of meat & poultry products including joints, portions, cooked and hot products, sausages, burgers, pasties, curing, smoking, air drying & value added products","FULLY MET"]
["16 - 19 & Adults","01: Retail shop","S11","Be able to advise on and handle a range of customer orders and at times deal with customer complaints","FULLY MET"]
["16 - 19 & Adults","02: Processing plant","S12","Demonstrate knife skills and precision cutting of at least one species of meat (applying to current environment) including technical understanding of muscle and primary carcass management","FULLY MET"]
["16 - 19 & Adults","02: Processing plant","S13","Manage the production line team ensuring customer orders are delivered in a timely and accurate fashion and within tolerances for size and weights","FULLY MET"]
["16 - 19 & Adults","02: Processing plant","S14","Be able to prepare effectively for audits and respond appropriately to findings including the implementation of improvement actions across the area of responsibility","FULLY MET"]
["16 - 19 & Adults","03: In store butchery in a supermarket","S15","Manage the store department sales targets through regular monitoring of performance against results, identifying high and low performance meat products communicating results to line management","FULLY MET"]
["16 - 19 & Adults","03: In store butchery in a supermarket","S16","Plan and manage the staff scheduling arrangements for the section area staff and team including for peak times and seasons","FULLY MET"]
["16 - 19 & Adults","03: In store butchery in a supermarket","S17","Take control for audit, inventory and traceability processes as required by the business","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Take personal operational responsibility for both health and food safety, apply safe working practices when using knives, hazardous tools and/or related equipment\nBe punctual, reliable, diligent and respectful towards customers, peers and colleagues at all times","FULLY MET"]
["16 - 19 & Adults","Core","B2","Be able to plan and organise self and others in the butchery area of responsibility","FULLY MET"]
["16 - 19 & Adults","Core","B3","Cultivate and maintain productive relationships with internal colleagues and external customers","FULLY MET"]
["16 - 19 & Adults","Core","B4","Keeping self and team/colleagues up to date with brand developments. Take pride in new products actively promoting these with colleagues and customers","FULLY MET"]
["16 - 19 & Adults","Core","B5","C: Leading by example in terms of meeting targets, solving problems, managing pressure and\nattaining the quality assurance expectations of the business","FULLY MET"]
["16 - 19 & Adults","Core","B6","Take responsibility for personal continuous professional development (CPD)","FULLY MET"]

{"sheet":"OCC0340","index":11,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.1"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","04/05/2020"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0340 - Travel consultant"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","Geography:Know a varied range of world-wide geography and popular travel destinations to help inform customers’ travel plans","FULLY MET"]
["16 - 19 & Adults","Core","K2","Travel Information: Know travel information including: passport and visa requirements, diversity for example local cultures, customs and tradition, differences in time zones, climate, medical safety information, foreign office advice and foreign exchange information","FULLY MET"]
["16 - 19 & Adults","Core","K3","Industry Practice: Know the travel industry and the systems that support it, including those for reservations and booking, the importance of booking the correct product / service and key information such as travel terminology, abbreviated industry codes, preferred operators’ current fare and ticketing rules, and travel regulations","FULLY MET"]
["16 - 19 & Adults","Core","K4","Travel Options: Know the variety and alternative combination of travel options that are available to customers including modes of transportation, types of accommodation and how to produce an itinerary that will meet customers’ precise needs","FULLY MET"]
["16 - 19 & Adults","Core","K5","Product and Service: Know the unique selling points of travel products and services and understand how to match their features to benefit the customer and provide an enhanced competitive proposition","FULLY MET"]
["16 - 19 & Adults","Core","K6","Customer: Know different customer profiles, including sole travellers and groups, how to recognise and identify their requirementsand individual needs, their preferred method(s) of booking travel, the need for providing a flexible service to support the process, and how to meet the increasing demand for an enhanced travel experience","FULLY MET"]
["16 - 19 & Adults","Core","K7","Legal and Compliance: Know how to keep customers’ details safely and to lawfully process business transactions, recognising the connection with travel industry regulations, business compliance and relevant legislation","FULLY MET"]
["16 - 19 & Adults","Core","K8","Industry Technology: Know how to utilise technology in line with customer and business requirements and the scope of technology used within the business and the industry as a whole","FULLY MET"]
["16 - 19 & Adults","Core","K9","Business: Know the business vision, objectives and brand standards, the market it competes in, external factors that affect customer behaviour and business performance and understand the importance of meeting customers’ needs profitably","FULLY MET"]
["16 - 19 & Adults","Core","K10","Sales: Know how to operate commercially with the aim of exceeding sales target, how to calculate complex travel costings, understanding the difference between turnover and profit, and how own targets contribute to achieving the overall sales budget","FULLY MET"]
["16 - 19 & Adults","Core","K11","Team and Personal Performance: Know and understand the factors that both motivate and impair individual and team performance and recognise how own and team dynamics impact on the experience of the customer and ultimately business success","FULLY MET"]
["16 - 19 & Adults","Core","K12","Communication: Understand how to professionally communicate to different audiences using a variety of methods, including available digital resources","FULLY MET"]
["16 - 19 & Adults","Core","K13","Sustainability: Understand the impact that the business activity has on the environment and the organisation’s approach to operate in a more responsible and sustainable manner","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Geography: Source and provide reliable and relevant geographical information that will help inform enquiries, support customers’ travel decisions and close sales","FULLY MET"]
["16 - 19 & Adults","Core","S2","Travel Information: Source and provide accurate and relevant travel information that will ensure customers have a positive travel experience","FULLY MET"]
["16 - 19 & Adults","Core","S3","Industry Practice: Carry out transactions, using a range of reservation and booking systems, according to standard industry practices and the procedures of the business, ensuring that customers are offered travel options that will meet their individual needs within agreed deadlines","FULLY MET"]
["16 - 19 & Adults","Core","S4","Travel Options: Source travel options, work with relevant industry suppliers and produce detailed itineraries that best meet customers’ needs","FULLY MET"]
["16 - 19 & Adults","Core","S5","Product and Service: Match customer needs to products and services and identify opportunities to upsell, suggest alternatives, introduce an enhanced competitive offer when appropriate and always aim to maximise profit when closing the sale","FULLY MET"]
["16 - 19 & Adults","Core","S6","Customer: Engage customers by building rapport and take opportunities to adapt communication styles to match their needs and deliver an enhanced service which encourages repeat business and consistently aims to exceed their expectations","FULLY MET"]
["16 - 19 & Adults","Core","S7","Legal and Compliance: Conduct the business transaction in compliance with travel industry regulations, approved codes of practice and business policy and continuously monitor the process to ensure accurate information and advice is given to customers","FULLY MET"]
["16 - 19 & Adults","Core","S8","Industry Technology: Use technology effectively and efficiently and input data accurately in accordance with business procedures","FULLY MET"]
["16 - 19 & Adults","Core","S9","Business: Actively support business performance by meeting agreed targets and providing travel solutions for customers varying needs and budgets in a way that is profitable to the business","FULLY MET"]
["16 - 19 & Adults","Core","S10","Sales: Achieve and exceed commercial targets by applying selling techniques that are appropriate to all customer types, take opportunities to maximise sales for example by selling promotions and preferred supplier programmes and maximise financial performance by upselling, cross-selling and calculating fares and refunds accurately","FULLY MET"]
["16 - 19 & Adults","Core","S11","Team and Personal Performance: Work constructively with team members to deliver travel plans and experiences that meet customer needs and recognise opportunities for self and team development to improve performance","FULLY MET"]
["16 - 19 & Adults","Core","S12","Communication: Select and use appropriate methods of communication including digital technologies according to the customer and the nature of the travel details being conveyed, ensuring quotes and prices are presented accurately","FULLY MET"]
["16 - 19 & Adults","Core","S13","Sustainability: Adapt working practices to minimise the negative effect on the environment","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Geography: Proactively keep up to date with worldwide geography and current affairs that could impact on customers","FULLY MET"]
["16 - 19 & Adults","Core","B2","Travel Information: Proactively keep up to date with travel information according to the customer profile of the business and the ever changing dynamics of the industry","FULLY MET"]
["16 - 19 & Adults","Core","B3","Industry Practice: Take a keen interest in travel industry developments to keep professional knowledge current and up to date","FULLY MET"]
["16 - 19 & Adults","Core","B4","Travel Options: Demonstrate commercial awareness and consideration for customers’ unique needs when selecting and combining different elements of customers’ travel plans","FULLY MET"]
["16 - 19 & Adults","Core","B5","Product and Service: Promote confidence in customers by demonstrating a passionand belief in the products and services being sold ","FULLY MET"]
["16 - 19 & Adults","Core","B6","Customer: Respond positively and imaginatively to customers’ requirements, demonstrating an enthusiasm to inspire and delight them","FULLY MET"]
["16 - 19 & Adults","Core","B7","Legal and Compliance: Be diligent in upholding protocols and business reputation to ensure customers receive the best quality service and advice and communicate and explain emerging issues and updates","FULLY MET"]
["16 - 19 & Adults","Core","B8","Industry Technology: Use technology responsibly and embrace developments in travel technology","FULLY MET"]
["16 - 19 & Adults","Core","B9","Business: Engage with the culture and ethos of the business and be a positive advocate and driver for high quality performance and achievement","FULLY MET"]
["16 - 19 & Adults","Core","B10","Sales: Proactively seek ways of engaging customers to increase and enhance sales","FULLY MET"]
["16 - 19 & Adults","Core","B11","Team and Personal performance: Evaluate own personal performance in a consistently positive and professional manner, take on feedback and welcome personal development opportunities","FULLY MET"]
["16 - 19 & Adults","Core","B12","Communication: Be clear and coherent to effectively communicate accurate and complex information professionally and confidently to a diverse audience, in line with business expectations","FULLY MET"]
["16 - 19 & Adults","Core","B13","Sustainability: Demonstrate an on-going commitment to reducing impact on the environment in all work activities","FULLY MET"]

{"sheet":"OCC0115","index":12,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.0"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","19/09/2016"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0115 - IT technical salesperson"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","Understands the basic elements and architecture of computer systems","FULLY MET"]
["16 - 19 & Adults","Core","K2","Has a working knowledge of Cloud and Cloud Services","FULLY MET"]
["16 - 19 & Adults","Core","K3","Understands the principles of secure coding","FULLY MET"]
["16 - 19 & Adults","Core","K4","Has a working knowledge of the role IT plays within the broader context of a business strategy","FULLY MET"]
["16 - 19 & Adults","Core","K5","Understands the main methodologies used for unified communications","FULLY MET"]
["16 - 19 & Adults","Core","K6","Understands the basics of how data storage works and the main technical options available","FULLY MET"]
["16 - 19 & Adults","Core","K7","Understands how to communicate using the appropriate language and terminology for audience and cultural awareness","FULLY MET"]
["16 - 19 & Adults","Core","K8","Understands the principles and ethics of sales, recognising the importance of delivering value to the customer","FULLY MET"]
["16 - 19 & Adults","Core","K9","Understands the sales life cycle, techniques & processes","FULLY MET"]
["16 - 19 & Adults","Core","K10","Understands how to negotiate, handle objections and close sales","FULLY MET"]
["16 - 19 & Adults","Core","K11","Understands the business product(s) they are responsible for selling including the relevant vendor product(s) as selected by the employer.","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Communication: works both independently and as part of a team and following the organisation’s code of practice; demonstrates an ability to communicate effectively and present both in writing and orally at all levels, using a range of tools.","FULLY MET"]
["16 - 19 & Adults","Core","S2","Customer Experience: demonstrates strong interpersonal skills and cultural awareness when dealing with colleagues, customers and clients during sales operations and whilst defining requirements with an emphasis on customer satisfaction and relationship management.","FULLY MET"]
["16 - 19 & Adults","Core","S3","Data Security: operates securely in line with organisational guidance, legislation and organisational software packages and complies with security of data and can effectively record, analyse and communicate data at the appropriate level using the organisation’s standard tools and processes throughout all sales interactions.","FULLY MET"]
["16 - 19 & Adults","Core","S4","Problem solving: applies structured techniques for troubleshooting, problem solving and analyses problems by selecting the appropriate tools and techniques in line with organisation guidance when dealing with sales as well as routine tasks","FULLY MET"]
["16 - 19 & Adults","Core","S5","Assesses and qualifies sales leads by developing a clear understanding of clients’ business needs and advising how these might be met with appropriate products, tools and techniques.","FULLY MET"]
["16 - 19 & Adults","Core","S6","Project management: works flexibly and demonstrates the ability to work under pressure independently and as part of a team to progress sales and manage their time, workflow, priorities and projects.","FULLY MET"]
["16 - 19 & Adults","Core","S7","Interprets and follows: health and safety legislation to securely and professional work productively in the work environment; Data Protection Act 1998; Sales of Goods Act 1979.","FULLY MET"]
["16 - 19 & Adults","Core","S8","Sales process: professionally operates all sales-related tasks to maintain integrity, brand and company image during negotiations, handling of objections and closing sales with an understanding of the markets and external competitors","FULLY MET"]
["16 - 19 & Adults","Core","S9","Technical: ability to understand and explain the technical portfolio and technical systems sold within the organisation and can use the current hardware and operating systems available.","FULLY MET"]
["16 - 19 & Adults","Core","S10","Database and Campaign Management: prioritises their contacts and keeps an up to date database knowing when and why to contact current consumers or prospects in line with organisational requirements.","FULLY MET"]
["16 - 19 & Adults","Core","S11","Context / CPD: identifies and negotiates personal development in the context of the wider business and how their role relates to other roles in the business.","FULLY MET"]
["16 - 19 & Adults","Core","S12","Logical and creative thinking skills","FULLY MET"]
["16 - 19 & Adults","Core","S13","The ability to interact effectively and professionally with a range of different types of customer","FULLY MET"]
["16 - 19 & Adults","Core","S14","Ability to think analytically and to solve problems","FULLY MET"]
["16 - 19 & Adults","Core","S15","Ability to work independently and to take responsibility","FULLY MET"]
["16 - 19 & Adults","Core","S16","Ability to work with a range of internal and external people","FULLY MET"]
["16 - 19 & Adults","Core","S17","Ability to communicate effectively in a variety of situations","FULLY MET"]
["16 - 19 & Adults","Core","S18","Ability to operate in a secure manner","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Can use own initiative","FULLY MET"]
["16 - 19 & Adults","Core","B2","A thorough and organised approach","FULLY MET"]
["16 - 19 & Adults","Core","B3","Maintain productive, professional and secure working environment","FULLY MET"]

{"sheet":"OCC0326","index":13,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.2"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","17/05/2023"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0326 - Retail team leader"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","Customer: Understand the customer profile of the business, their purchasing habits across a retail calendar year and how to meet and exceed their needs. Know the best ways to drive the team to increase sales, secure customer loyalty and attain business targets","FULLY MET"]
["16 - 19 & Adults","Core","K2","Business: Understand the purpose of the business including its vision, objectives and brand / business standards, how they compare to its competitors and how own role, and the team, help to achieve them","FULLY MET"]
["16 - 19 & Adults","Core","K3","Financial: Understand how own actions and those of the team can contribute to the overall financial performance of the business by increasing sales e.g. through product positioning, and minimising costs through effective stock control and prevention of theft","FULLY MET"]
["16 - 19 & Adults","Core","K4","Leadership: Understand how to organise the team on a daily basis to achieve objectives, and recognise the importance of contingency planning to meet business requirements; know limits of authority when deputising for line manager","FULLY MET"]
["16 - 19 & Adults","Core","K5","Marketing: Understand how the brand / business is positioned externally, particularly in relation to local and online competitors and how its products / services meet consumer trends. Understand how own actions, and those of the team can impact on customers’ perception of the brand / business","FULLY MET"]
["16 - 19 & Adults","Core","K6","Communication: Understand how to support effective communication, quickly determining the situation and needs of individuals and how to respond in the most appropriate way using a variety of techniques and methods, for example face to face and / or remotely to include on-line","FULLY MET"]
["16 - 19 & Adults","Core","K7","Sales and Promotion: Understand the factors which can determine and affect sales and promotions throughout the retail year and how to coordinate and implement them to support business objectives","FULLY MET"]
["16 - 19 & Adults","Core","K8","Product and Service: Know and promote the features and benefits of products / services, their unique selling points, the skills required to sell them, where items fit into product ranges, associated  products and services, where to find detailed information if required and other relevant information such as delivery lead time, accessibility and source","FULLY MET"]
["16 - 19 & Adults","Core","K9","Merchandising: Know methods of merchandising throughout the retail operation, including point of sale, the retail calendar and local needs e.g. geographical, topical or weather based","FULLY MET"]
["16 - 19 & Adults","Core","K10","Stock: \t\nUnderstand the principles of stock control from sourcing to sale / supply. Understand the management of stock levels, security, restrictions (e.g. age restricted products), wastage and effective systems for recording them","FULLY MET"]
["16 - 19 & Adults","Core","K11","Technology: Understand how current and emerging technologies support retail operations and sales whether customer facing or remote, and how best to operate them to achieve an efficient and effective service","FULLY MET"]
["16 - 19 & Adults","Core","K12","Developing self and Others: Understand the knowledge, skills and behaviours required of self and others to develop a high performing team in the business. Understand team dynamics and the importance of enabling team members to appreciate their role in the wider organisation and in meeting business objectives","FULLY MET"]
["16 - 19 & Adults","Core","K13","Team performance: Know how to identify and develop excellent team performance. Understand how the performance of the team contributes to the overall success of the business","FULLY MET"]
["16 - 19 & Adults","Core","K14","Legal and Governance: Understand the importance of business compliance to legal requirements and supporting the team to operate in line with business policy and procedures","FULLY MET"]
["16 - 19 & Adults","Core","K15","Diversity: Understand how to work with and support people from a wide range of backgrounds and cultures and the business policy on diversity","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Customer: Monitor customers’ enquiries and service requirements; coach and support team members to use appropriate methods e.g. face to face or remote such as on-line facilities, to deliver consistent and exceptional service that provides customers with a positive experience","FULLY MET"]
["16 - 19 & Adults","Core","S2","Business: Work with the team to maintain brand / business standards at all times and identify and address any potential risks according to business procedures","FULLY MET"]
["16 - 19 & Adults","Core","S3","Financial: Support the achievement of financial targets by planning and monitoring resources. Use resources effectively and efficiently to meet expected demand. Oversee the areas that impact on financial performance in own area of the business in line with business procedures","FULLY MET"]
["16 - 19 & Adults","Core","S4","Leadership: Use available information to coordinate the work of the team so that the right people and resources are in the right place at the right time to ensure consistent brand / business standards are delivered. Deputise for line manager within limits of own authority","FULLY MET"]
["16 - 19 & Adults","Core","S5","Marketing: Support the team to ensure they understand and engage in the marketing activities and plans of the business and help ensure that customers have the best possible experience","FULLY MET"]
["16 - 19 & Adults","Core","S6","Communication: Adapt style of communication according to the audience, monitor the effectiveness of and encourage excellent communications across all operations that achieve the best result for the business including verbal, written and on-line communications","FULLY MET"]
["16 - 19 & Adults","Core","S7","Sales and Promotion: Communicate sales targets to the team and support them, recognising and acting on opportunities to maximise revenue, for example through link selling and drawing customers’ attention to promotional offers","FULLY MET"]
["16 - 19 & Adults","Core","S8","Product and Service: Maximise opportunities to increase sales by ensuring team know and understand the features, benefits, unique selling points and other relevant information relating to products, product ranges and services offered by the business","FULLY MET"]
["16 - 19 & Adults","Core","S9","Merchandising: Ensure team replenish and maintain merchandising according to business requirements, the retail calendar and local needs e.g. geographical, topical or weather based","FULLY MET"]
["16 - 19 & Adults","Core","S10","Stock: Ensure team complies with stock procedures to minimise stock damage or loss, maximise income and comply with legal requirements; and take appropriate action to sell stock that is near the end of its product, promotional or shelf life","FULLY MET"]
["16 - 19 & Adults","Core","S11","Technology: Oversee the appropriate use of technology in line with business policy and follow the appropriate procedures to deal with service issues","FULLY MET"]
["16 - 19 & Adults","Core","S12","Developing self and others: Plan, organise, prioritise and oversee own and team members’ activities, supporting their induction, training, development and coaching, and delegating tasks fairly and appropriately to meet business objectives","FULLY MET"]
["16 - 19 & Adults","Core","S13","Team Performance: Lead the team on a daily basis, setting targets and reviewing progress against them. Motivate team members, provide coaching and on job training. Identify conflict within the team and work to resolve this with support from others","FULLY MET"]
["16 - 19 & Adults","Core","S14","Legal and Governance: Ensure self and team always comply with legal requirements, respond quickly to identified risks and ensure they are dealt with in line with business procedures and reported to the appropriate member(s) of the management team","FULLY MET"]
["16 - 19 & Adults","Core","S15","Diversity: Ensure team members are aware of and follow business policies relating to diversity. Make reasonable adjustments as required for customers or team members","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Customer: Act as a role model to champion excellent customer service by always looking to improve customers’ experience through a welcoming and professional approach which builds strong customer relationships","FULLY MET"]
["16 - 19 & Adults","Core","B2","Business: Demonstrate personal responsibility for meeting the objectives of the team and the business","FULLY MET"]
["16 - 19 & Adults","Core","B3","Financial: Demonstrate commercial awareness and act responsibly and with integrity to protect the financial position of the business","FULLY MET"]
["16 - 19 & Adults","Core","B4","Leadership: Display decisive thinking when making decisions that are in the best interest of the business. Use sound judgement; take prompt action in the case of problems relating to resources","FULLY MET"]
["16 - 19 & Adults","Core","B5","Marketing: Proactively seek to understand local consumer trends, competitors’ offers and promotions, and customer needs and expectations, report to manager, seek feedback and take action in area of responsibility","FULLY MET"]
["16 - 19 & Adults","Core","B6","Communication: Demonstrate positive verbal and body language using concise and clear methods of communication, taking on board other peoples’ points of view and responding in a way that is considerate to the audience","FULLY MET"]
["16 - 19 & Adults","Core","B7","Sales and Promotion: Proactive in looking for cost effective sales opportunities and ways to enhance revenue","FULLY MET"]
["16 - 19 & Adults","Core","B8","Product and Service: Promote all products and services confidently, demonstrating excellent knowledge and understanding of them","FULLY MET"]
["16 - 19 & Adults","Core","B9","Merchandising: Communicate and encourage the merchandising principles, standards and commerciality to the team","FULLY MET"]
["16 - 19 & Adults","Core","B10","Stock: Take a proactive approach and lead the team to effective stock management, ensuring stock is accessible and available in line with quality requirements, where and when needed","FULLY MET"]
["16 - 19 & Adults","Core","B11","Technology: Is an advocate for the effective and efficient use of technology","FULLY MET"]
["16 - 19 & Adults","Core","B12","Developing self and others: Take responsibility for own performance, learning and development. Develop positive relationships with team members, embracing new and better ways of working","FULLY MET"]
["16 - 19 & Adults","Core","B13","Team Performance: Positively and confidently challenge poor performance and reward excellent performance in line with business procedures","FULLY MET"]
["16 - 19 & Adults","Core","B14","Legal and Governance: Be responsible, advocate and adhere to the importance of working legally in the best interests of all people","FULLY MET"]
["16 - 19 & Adults","Core","B15","Diversity: Operate in an empathic, fair and professional manner with all individuals regardless of background and circumstances","FULLY MET"]

{"sheet":"OCC0234","index":14,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[null,null,null,"START HERE","Standard: Key Information"]
[null,null,null,"Awarding body/Applicant:","Version Number:"]
[null,null,null,"Please type the name of awarding body/applicant here","1.4"]
[null,null,null,"Qualification name:","Date Updated:"]
[null,null,null,"Please type your qualification title here","17/05/2023"]
[null,null,null,"Programme title if applicable:"]
[null,null,null,"Please type the programme title here"]
[]
[]
[null,null,"EXAMPLE OF KSB MAPPING"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – Where the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
["16 - 19 & Adults","Core","K8","Health & Safety and compliance requirements of the bodyshop industry","FULLY MET","Qualification specification, pg 19-20\n\nModule 3: Health, safety and professional working practices, pg 7-8\n\n","Module 3: 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 19 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 3 - students will produce a written risk assessment report using a brief. There is also a short answer paper. Module 3 Assessment Brief pg 7 refers. \n"]
[]
[null,null,null,"Select as Appropriate: "]
[null,null,null,"CATEGORY"]
[null,null,null,"OPTIONS (If Applicable)"]
[null,null,null,"OCC0234 - Housing and property management"]
[null,null,null,"Return to Guide"]
["Category Available","Core & Options","KSB","KSB Statement ","KSB coverage - select the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content? Please reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number. \n\n","Evidence - Quote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale – \nWhere a KSB is not fully met, please provide the rationale for why you feel this is not achievable.\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. \n\n","Assessment method - Provide information on the method(s) used to assess this KSB and relevant assessment materials."]
[null,"Core",null,"Knowledge"]
["16 - 19 & Adults","Core","K1","Legislation and regulation: Understand the principles, practices and legislation relating to current landlord and tenant law for the letting, maintenance and termination of a variety of tenancy types, including but not limited to: shorthold, assured, secure, long leasehold and shared ownership.","FULLY MET"]
["16 - 19 & Adults","Core","K2","Legislation and regulation: Understand the principles, practices and legislation as it applies to governance, court proceedings, contracts, data protection, safeguarding and other relevant areas","FULLY MET"]
["16 - 19 & Adults","Core","K3","Legislation and regulation: Understand  legislation and regulations as they apply to housing standards","FULLY MET"]
["16 - 19 & Adults","Core","K4","Organisation background information: Understand the principles, priorities and values of the organisation they work for, including an awareness of the business plan,  the range of services available to clients and customers, , the roles and responsibilities of others and team targets and or Key Performance Indicators.","FULLY MET"]
["16 - 19 & Adults","Core","K5","Assets: Understand the social and physical context of estates, neighbourhoods and how to resolve defects, common problems, health and safety issues and repairs to dwellings.","FULLY MET"]
["16 - 19 & Adults","Core","K6","Customers: Understand the diversity of the communities which the business serves","FULLY MET"]
["16 - 19 & Adults","Core","K7","Context: Understand the current and historical context of social, rented, affordable, private housing and the broader housing market.","FULLY MET"]
["16 - 19 & Adults","Core","K8","Range of services: Have an appreciation of the range of applicable housing services  for example repairs and maintenance, allocations, lettings, tenancy sustainment, financial and social inclusion, anti- social behaviour, care and supported housing, rents, service charges and portfolio accounts and community involvement.","FULLY MET"]
["16 - 19 & Adults","Core","K9","Organisational Policies: Understand the principles, policies and practices of the organisation they work for in terms of customer and client care, employee code of conduct, team working, risk, personal safety, health and safety, equality and diversity, safeguarding and business communications.","FULLY MET"]
[null,null,null,"Skills"]
["16 - 19 & Adults","Core","S1","Customer Service: Apply a range of customer service skills in order to provide a professional, accurate, timely, ethical and non-judgemental front line service which meets the needs of a diverse range of customers and stakeholders","FULLY MET"]
["16 - 19 & Adults","Core","S2","Communication: Demonstrate appropriate communication skills to enable timely identification and/or resolution of issues for customers and appropriate signposting to other colleagues and/or partner agencies.","FULLY MET"]
["16 - 19 & Adults","Core","S3","Collaborative working: \tWork collaboratively with colleagues and partners to achieve individual, team and business targets. ","FULLY MET"]
["16 - 19 & Adults","Core","S4","Respond to vulnerability: Use skill and judgment to understand the needs of vulnerable individuals and groups(including those with complex needs) and respond appropriately","FULLY MET"]
["16 - 19 & Adults","Core","S5","Information collection and sharing: Use a variety of methods to identify, collect and communicate technical and other information in a confident and effective manner.","FULLY MET"]
["16 - 19 & Adults","Core","S6","Influencing and negotiating skills: Influence and negotiate with customers, partners and suppliers.","FULLY MET"]
["16 - 19 & Adults","Core","S7","Self Management: Organise and plan their own work to ensure tasks are completed and deadlines met.","FULLY MET"]
["16 - 19 & Adults","Core","S8","Problem Solving: Use a problem solving and flexible approach in their day to day duties.","FULLY MET"]
["16 - 19 & Adults","Core","S9","Tools and Equipment: Effective use of IT equipment and software, through administration and the appropriate use of work equipment","FULLY MET"]
["16 - 19 & Adults","Core","S10","Decision making: Effective decision making in order to apply the businesses objectives and priorities.","FULLY MET"]
[null,null,null,"Behaviours"]
["16 - 19 & Adults","Core","B1","Responsive: Takes timely and responsive action to address issues","FULLY MET"]
["16 - 19 & Adults","Core","B2","Trust and Integrity: Develop trust by working in a confidential, ethical and empathetic manner with a common sense and professional attitude.","FULLY MET"]
["16 - 19 & Adults","Core","B3","Adaptability: Willingness to accept changing priorities and work patterns","FULLY MET"]
["16 - 19 & Adults","Core","B4","Independence: Work independently and effectively without close supervision.","FULLY MET"]
["16 - 19 & Adults","Core","B5","Dependability: \t Meets personal commitments and expectations of others","FULLY MET"]
["16 - 19 & Adults","Core","B6","Personal Commitment: Takes responsibility for their own personal and professional development.","FULLY MET"]
["16 - 19 & Adults","Core","B7","Resilience: Has a high level of resilience, tenacity and calmness","FULLY MET"]
["16 - 19 & Adults","Core","B8","Role Model: Acts as an ambassador and role model for their employer with customers, clients and partners.","FULLY MET"]
["16 - 19 & Adults","Core","B9","Customer Care: Demonstrates a responsive approach to customer needs and understands their personal impact on customers and their lives","FULLY MET"]
["16 - 19 & Adults","Core","B10","Team Work: Values team work and is an effective team player, accepts responsibility for the work of themselves and others.","FULLY MET"]