{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["GUIDE TO KSB MAPPING","ST0208","ST0921","ST0924","ST0926","ST0946","ST1320","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"ST0208","index":1,"n_rows":83,"n_cols":18,"rows_kept":83,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Golf course manager (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","All relevant health, safety and environmental legislation and regulations to ensure a safe working environment for self, team and others.",null,null,null,null,null,null,{"$f":"IF(C22:C40 = \"FULLY MET\",1,IF(C22:C40 = \"PARTIALLY MET\",0.5,IF(C22:C40 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","How to conduct and review risk assessments using methods relevant to the management and maintenance of the golf course.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","The advanced aspects of soil and plant biology in order to produce sustainable playing surfaces.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","How to identify and control weeds, pests, diseases and disorders and their impact on sustainable playing surfaces, legislation and record keeping.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J25=1,1,IF(J25=0.5,0.5,IF(J25=0,0)))","v":0},{"$f":"IF(L25=1,\"NONE\",IF(L25=0.5,\"PARTIAL\",IF(L25=0,\"FULL\")))","v":"FULL"}]
["K5","How to plan, manage and review maintenance, improvement and renovation programmes for the golf course making the optimum use of resources available.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The importance of maintaining quality standards through the collection and evaluation of data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","How to plan, manage and construct golf course features.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The environmental and ecological best practice to maintain a sustainable golf course and the impact of current legislation.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J29=1,1,IF(J29=0.5,0.5,IF(J29=0,0)))","v":0},{"$f":"IF(L29=1,\"NONE\",IF(L29=0.5,\"PARTIAL\",IF(L29=0,\"FULL\")))","v":"FULL"}]
["K9","How to design, install and manage drainage and irrigation systems and the importance of water management on the golf course.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","How to plan, manage and review machinery and equipment maintenance programmes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How to develop and review a tactical and strategic business management plan, in line with the Golf Course Policy document.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The importance of customer service to the business.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The principles of recruitment, appraisal, conflict, teamwork, staff co-ordination, supply chain management, performance management and the development of staff.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","The importance of good working relationships, the needs of others and equality and diversity of others in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How to plan, lead and record meetings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","The different forms of communication (written, verbal, electronic) and evaluate the best solution for different circumstances.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How to identify the appropriate software systems to ensure effective communication and record keeping.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The Rules of Golf, golf course etiquette and how they impact on events and the playing of the game of golf.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The importance of personal and professional development of themselves and their team.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Manage, promote and maintain a healthy, safe and secure maintenance facility and golf course for their staff, golfers and members of the public.",null,null,null,null,null,null,{"$f":"IF(C42:C63 = \"FULLY MET\",1,IF(C42:C63 = \"PARTIALLY MET\",0.5,IF(C42:C63 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J42=1,0.5,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=0.5,\"NONE\",IF(L42=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Plan, monitor, evaluate and manage golf course maintenance and the environment in accordance with the Golf Course Policy document.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J43=1,1,IF(J43=0.5,0.5,IF(J43=0,0)))","v":0},{"$f":"IF(L43=1,\"NONE\",IF(L43=0.5,\"PARTIAL\",IF(L43=0,\"FULL\")))","v":"FULL"}]
["S3","Manage the allocation of human and physical resources, equipment and supply chain for projects and tasks on a day to day basis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Plan and manage the maintenance and replacement of machinery and equipment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Plan and manage the control of weeds, pests and diseases and their impact on plant health and pathology.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Analyse and interpret a range of data collected from the golf course and the management of sustainable playing surfaces.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Plan and manage projects, including the construction of golf course features and events.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Manage water applied and removed from the golf course, including irrigation and drainage.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Develop and review a Golf Course Policy document in co-operation with the employer.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Identify and determine policies and strategies for the development of the golf course, in line with Golf Course Policy document.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Prepare, submit and manage maintenance budgets and capital expenditure proposals.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Conduct, manage and review risk assessments on equipment, materials, people and facilities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Communicate to golf course staff, colleagues, golfers and others on a range of subjects.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Manage the recruitment, selection and induction of staff and the performance, training, equality and diversity of the greenkeeping team.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J55=1,0.5,IF(J55=0.5,0.5,IF(J55=0,0)))","v":0},{"$f":"IF(L55=0.5,\"NONE\",IF(L55=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Manage conflict, discipline and grievances within the team and others.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J56=1,1,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=1,\"NONE\",IF(L56=0.5,\"PARTIAL\",IF(L56=0,\"FULL\")))","v":"FULL"}]
["S16","Motivate and encourage excellence within the greenkeeping team.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Organise and manage meetings with the greenkeeping team and others.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Promote the golf club and its core values, as determined by the employer.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Encourage a customer service culture within the greenkeeping team.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Manage their own Continuing Professional Development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Make presentations both written and verbal to the greenkeeping team, management and golfers.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Use information technology to manage the golf course through data collection and analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Ensure a strong work ethic including pride in work, attention to detail, integrity and good time management",null,null,null,null,null,null,{"$f":"IF(C65:C73 = \"FULLY MET\",1,IF(C65:C73 = \"PARTIALLY MET\",0.5,IF(C65:C73 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=1,\"NONE\",IF(L65=0.5,\"PARTIAL\",IF(L65=0,\"FULL\")))","v":"FULL"}]
["B2","Have a flexible, positive attitude to work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","The ability to work as a lone worker and as a member of a team",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","A willingness to learn and contribute to their own continuing professional development",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J68=1,0.5,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=0.5,\"NONE\",IF(L68=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Ensure a safety mindset for self, the greenkeeping team, golfers and members of the public.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"}]
["B6","A clear and effective communicator who can use a variety of communication methods to give/receive information accurately and in a timely and positive manner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Problem solving and effective decision making",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Represent the golf club in a professional manner at all times.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Recognise and deliver exceptional customer service.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J73)","v":0},"Net Score",{"$f":"SUM(L22:L73)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J76/L80","v":0},"total CoE KSB coverage",{"$f":"L76/L83","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",50]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L80-L81-(L82*0.5)","v":48.5}]

{"sheet":"ST0921","index":2,"n_rows":106,"n_cols":18,"rows_kept":106,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Arboriculturist (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","British Standards relevant to arboricultural works including 3998 (tree works) and 5837 (trees in relation to design, demolition and construction).",null,null,null,null,null,null,{"$f":"IF(C22:C58 = \"FULLY MET\",1,IF(C22:C58 = \"PARTIALLY MET\",0.5,IF(C22:C58 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Principles of tree growth, physiology, characteristics and reaction to pruning.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","The life stages of a tree including propagation techniques, aging process, deadwood habitats and veteran tree management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Characteristics of tree pests and pathogens, their impact on the tree health and performance, and management responses.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Principles of soil science.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Hazard assessment methodologies in relation to a single tree.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Basic principles of woodland management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Types of tree works related to tree form, function, and client expectation, their specification and implications for tree health, safety and aesthetics.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Classification of trees and their taxonomy; application of nomenclature (including cultivars where appropriate) per scientific convention.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Implications of legislation and industry best practice guidance when undertaking tree work operations and their impact on team management, policy and process for example H&S Act, specialist training requirements, Working at Height, LOLER, PUWER, AFAG, COSSH.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Considerations when planting trees including planting systems, site factors, species selection, protection, aftercare and British Standard 8545",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Tree bracing styles, systems and uses.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Tree inventory systems and their uses.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Types of advanced diagnostic systems and their purpose in assessment of tree risk.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The legal framework around trees including statutory protection for trees and penalties associated with breaches of legislation and regulations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Health and Safety legislation and regulations; principles related to work placed risk assessment and management, including method statements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Conflicts between trees and the built environment including damage (direct or indirect) to infrastructure and subsidence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Benefits of trees (for example climate change adaptation, carbon sequestration, human health and wellbeing) and how these could influence management decisions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Tree valuation systems, methodologies and their purposes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The role of an arboriculturist and how this occupation collaborates with other professions for example engineers, land managers, ecologists, landscape architects and planners.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J41=1,1,IF(J41=0.5,0.5,IF(J41=0,0)))","v":0},"FULL"]
["K21","The principles for resilient tree populations and the application of biosecurity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The characteristics of ancient trees, veteran trees and trees of historical or cultural significance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Sources of information on funding schemes for tree planting and management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Project Management principles including working within budget, systems and processes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Contractual terms and processes for example the role of the client brief, the fee proposal, the scope and the instruction.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Tendering, procurement processes and scoring systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Principles and use of different communication tools.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Principles of customer service including confidentiality, data management, complaints and use of social media.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Principles of sales and marketing both direct service promotion and indirect industry promotion.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Roles of different stakeholders for example client, public, councillors in management of trees and techniques for engaging with the community.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Staff and team management principles including motivation, performance and work quality.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Principles of equality, safeguarding and diversity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Principles of managing and supporting meetings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Sources of information and techniques to research, collate and analyse arboricultural information and data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","The purpose and function of tree management plans and strategies and their implications for tree management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Methods for establishing and monitoring quality standards for tree work operations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Methodologies, techniques and tools for inspection and measurement of trees.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Tree inspection including assessment of health, defects, safety risks, site factors, planning requirements and aesthetics.",null,null,null,null,null,null,{"$f":"IF(C60:C90 = \"FULLY MET\",1,IF(C60:C90 = \"PARTIALLY MET\",0.5,IF(C60:C90 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J60=1,1,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},"FULL"]
["S2","Interpret maps and plans.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Assess tree risk to inform decision making.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Specify arboricultural works.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Select advanced diagnostic equipment for tree risk assessment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Select biosecurity protocols.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Follow instructions and processes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Write arboricultural reports.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Use software-based tree management systems, including associated laptop and handheld remote working equipment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Produce plans using digital mapping software (for example GIS).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Select and use different formats to communicate information (for example table, image, map, text, graph).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Collect, research and analyse arboricultural information and data including reliable information sources.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Advise on implications of arboricultural policy, legislation, regulation and best practice including local and national planning policy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Identification of tree species, their characteristics and requirements for healthy growth.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Manage projects including working within budget, systems and processes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Produce quotations or tenders including defining a scope/specification of work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Foster professional relationships with clients, customers and colleagues and engage with the community.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},{"$f":"IF(L76=1,\"NONE\",IF(L76=0.5,\"PARTIAL\",IF(L76=0,\"FULL\")))","v":"FULL"}]
["S18","Negotiate with colleagues and stakeholders to achieve desired outcomes.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J77=1,1,IF(J77=0.5,0.5,IF(J77=0,0)))","v":0},"FULL"]
["S19","Communicate information to technical and non- technical audiences using a range of techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Take meeting notes or minutes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Seek further information from managers, supervisors or colleagues, when necessary.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Create and evaluate relevant risk assessments and method statements for arboricultural operations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Provide customer service.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Identify soil type, properties, condition and implications for tree health.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Value trees as assets for both amenity and ecosystem service provision.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Establish and monitor quality standards for tree work operations.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J85=1,1,IF(J85=0.5,0.5,IF(J85=0,0)))","v":0},{"$f":"IF(L85=1,\"NONE\",IF(L85=0.5,\"PARTIAL\",IF(L85=0,\"FULL\")))","v":"FULL"}]
["S27","Promote the organisation, products, services or activities.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J86=1,1,IF(J86=0.5,0.5,IF(J86=0,0)))","v":0},{"$f":"IF(L86=1,\"NONE\",IF(L86=0.5,\"PARTIAL\",IF(L86=0,\"FULL\")))","v":"FULL"}]
["S28","Collect tree data including taking measurements.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J87=1,1,IF(J87=0.5,0.5,IF(J87=0,0)))","v":0},"FULL"]
["S29","Make tree management recommendations verbally.",null,null,null,null,null,null,0,null,"NONE",0,{"$f":"IF(L88=1,\"NONE\",IF(L88=0.5,\"PARTIAL\",IF(L88=0,\"FULL\")))","v":"FULL"}]
["S30","Identify tree pests and pathogens, assess impacts on tree health and suggest management responses.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Assess tree planting practices.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Act with integrity, for example being open and transparent in dealing with clients and respecting their confidentiality. Take full responsibility for your actions.",null,null,null,null,null,null,{"$f":"IF(C92:C96 = \"FULLY MET\",1,IF(C92:C96 = \"PARTIALLY MET\",0.5,IF(C92:C96 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J92=1,1,IF(J92=0.5,0.5,IF(J92=0,0)))","v":0},{"$f":"IF(L92=1,\"NONE\",IF(L92=0.5,\"PARTIAL\",IF(L92=0,\"FULL\")))","v":"FULL"}]
["B2","Communicates with others and takes into account cultural sensitivities and business practices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Act professionally, providing a high standard of service based on sound business evidence.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Adopt and promote a safety culture within the organisation and acts with regard to health, safety and wellbeing for self and others.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Embed sustainable working practices.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J96)","v":0},"Net Score",{"$f":"SUM(L22:L96)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J99/L103","v":0},"total CoE KSB coverage",{"$f":"L99/L106","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",73]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L103-L104-(L105*0.5)","v":73}]

{"sheet":"ST0924","index":3,"n_rows":99,"n_cols":18,"rows_kept":99,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Horticulture and landscaping technical manager (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Classification of plants using scientific, binomial, cultivars and common names as per the International Code of Plant Nomenclature.",null,null,null,null,null,null,{"$f":"IF(C22:C55 = \"FULLY MET\",1,IF(C22:C55 = \"PARTIALLY MET\",0.5,IF(C22:C55 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Plants common in the UK and their requirements for optimal growth including cultivated plants and weeds.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},"FULL"]
["K3","Implications of environmental factors for managing horticultural sites (for example ecology, waste management, biodiversity, pollution).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Purpose, value, and limitations of research and recording tools for horticultural sites, for example Geographic Information System (GIS) and databases.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Types of biosecurity threat for example pests and diseases, invasive species. Legislative requirements, prevention and response (for example quarantine, site hygiene, sourcing, recording and reporting).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Legislative requirements and best practice guidance in relation to horticultural sites including use of machinery, environmental, conservation, planning, designations, finance and data protection.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Techniques for promoting business, garden, open space, products or services",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Health and safety legislation and best practice guidance including, safeguarding, risk assessments and implications for public and staff on horticultural sites.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Functional factors, their relevance and implications for management of horticultural sites for example, infrastructure, features, services, users, conditions, hard structures and surfaces.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Historical site factors, their significance and implications for management, for example, heritage, archaeology, previous use.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Government, local or organisational strategies or policies that impact on horticultural sites including garden or landscape management strategies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Quality standards for horticultural sites including industry standards, setting of organisational standards and how to implement on site.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Operational methods (including associated tools, equipment and machinery) to carry out horticultural and landscape works; their impact on plants and the environment, for example, construction of hard structures and features, soil cultivation, propagation, lawn and tree care",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Social and cultural relevance of garden and landscape design through history.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Techniques for site interpretation, for example signage, mobile phone apps, tours.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Design techniques and tools for horticultural areas, for example simple plan sketches, CAD.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Services provided by contractors and specialists, for example surveys, construction specifications, planting plans.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J38=1,1,IF(J38=0.5,0.5,IF(J38=0,0)))","v":0},"FULL"]
["K18","Principles of sustainability and sustainable supply chains including measurement of energy use and advising on improved environmental standards to work towards a zero carbon economy for example selection of equipment, techniques, FSC timber supplies and peat.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Implications of climate change for horticultural sites and how to adapt and mitigate against these for example, alleviating flood risk, extreme temperatures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Biosecurity controls for example hygiene, provenance of plant material, plant passports, quarantine, control of harmful and notifiable organisms.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Communication techniques for different contexts for example verbal, published, social media, broadcast media.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","People management including legislation, performance management, recruitment, inclusion, induction, training and retention.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Benefits and purpose of organisational systems and processes, their role in compliance and how to follow them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Techniques for financial reporting and budgeting.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Benefits of horticultural sites for example health and wellbeing, ecosystem services.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Techniques for developing a business case for financing future projects. Methods for identifying audience and managing targets in business cases.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Principles of Integrated Pest Management (IPM) and Integrated Weed Management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Principles of customer service and managing relationships with clients and stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Procedures and principles for procurement of products and services including legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Components and purpose of specifications and operational work plans for horticultural sites.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Environmental factors and their impact on plant health and growth including temperature, soils, hydrology, light.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Survey, research and data analysis techniques for horticultural sites including features (for example paths, structures, utilities), abiotic factors (for example aspect, climate), ecology, horticultural elements (for example plants, soils), community engagement and people (for example usage, access, experience).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Invasive species and their implications for horticultural sites.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Project Management techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Plans and carries out a site survey and research to include features (for example paths, structures), abiotic factors (for example aspect, climate), ecology, horticultural elements (for example plants, soils), community engagement and people (for example usage, access, experience).",null,null,null,null,null,null,{"$f":"IF(C57:C83 = \"FULLY MET\",1,IF(C57:C83 = \"PARTIALLY MET\",0.5,IF(C57:C83 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J57=1,1,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},"FULL"]
["S2","Gathers site data through field and desk-based research methods.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Analyses and interprets survey results and other information, and proposes appropriate action.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Identifies biosecurity threats, selects and implements control or prevention measures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Identifies plants and determines their suitability and cultural requirements. Formats plant names as per the International Code of Plant Nomenclature.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Develops a management plan to enhance and maintain a horticultural site, including health and safety, user requirements, risk assessment, prioritising, feasibility, interactions between elements and resourcing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Interprets and implements operational work plans and manages resources in alignment with work plans (for example monitoring, and quality assurance).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Develops detailed work specifications and operational work plans incorporating input from internal or external colleagues to include waste management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Designs a horticultural area in keeping with site, for example historic interest, style, existing features.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Creates design briefs for horticultural areas to be used as basis for a design, outlining objectives, site requirements, projected use, treatment of existing features and style.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Communicates ideas to develop areas on site in order to gain agreement from clients, managers or stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Carries out an environmental impact assessment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Manages waste and implement waste management plan, for example application of waste hierarchy, segregation, composting.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Manages water usage and hydrology for horticultural sites, for example drainage, mulching, irrigation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Manages soil health, for example fertility, structure, micro-biology, avoiding compaction.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Manages plant health including mitigation of environmental factors, developing sustainable control methods, Integrated Pest Management (IPM), Integrated Weed Management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Selects communication method and communicates using a range of methods to technical and non technical audiences.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Promotes products or services identifying opportunities, audience and communication channels, generating written information.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Trains and mentors staff, contractors or volunteers.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J75=1,0.5,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},{"$f":"IF(L75=0.5,\"NONE\",IF(L75=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S20","Develops a business case to aid decision making and financial planning of future projects, including identifying audience and managing targets.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},"FULL"]
["S21","Prepares, reviews and analyses budgets, forecast and other profit and loss reporting including recommending efficiencies or improvements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Develops an invasive species management plan, including objectives, environmental considerations, resources, legal considerations and implementation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Manages people for example staff, contractors or volunteers.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J79=1,1,IF(J79=0.5,0.5,IF(J79=0,0)))","v":0},{"$f":"IF(L79=1,\"NONE\",IF(L79=0.5,\"PARTIAL\",IF(L79=0,\"FULL\")))","v":"FULL"}]
["S24","Manages a horticultural project.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Provides customer service and manages relationships with customers and stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Procures horticultural or landscaping products or services.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Assesses historic, cultural interest and values of the site and its features, their significance and implications for management for example archaeology, veteran trees, buildings and structures, and previous use.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Acts with integrity, for example being open and transparent in dealing with stakeholders and respecting their confidentiality. Takes full responsibility for your actions.",null,null,null,null,null,null,{"$f":"IF(C85:C89 = \"FULLY MET\",1,IF(C85:C89 = \"PARTIALLY MET\",0.5,IF(C85:C89 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J85=1,1,IF(J85=0.5,0.5,IF(J85=0,0)))","v":0},"FULL"]
["B2","Communicates effectively and respectfully towards clients and colleagues and takes into account cultural sensitivities and business practices.",null,null,null,null,null,null,0,null,"NONE",0,{"$f":"IF(L86=1,\"NONE\",IF(L86=0.5,\"PARTIAL\",IF(L86=0,\"FULL\")))","v":"FULL"}]
["B3","Acts professionally providing a high standard of service based on sound business evidence, including managing self, staying up to date with new developments, example, machinery, techniques, legislation or technology and continued professional development.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Adopts and promotes a safety culture within the organisation and acts with regard to health, safety and the wellbeing for self and others.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Embeds sustainable working practices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J89)","v":0},"Net Score",{"$f":"SUM(L22:L89)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J92/L96","v":0},"total CoE KSB coverage",{"$f":"L92/L99","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",66]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L96-L97-(L98*0.5)","v":65.5}]

{"sheet":"ST0926","index":4,"n_rows":93,"n_cols":18,"rows_kept":93,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Countryside ranger (Level 4) "]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Current legislation including health and safety, codes of practice, and work place policies and procedures relevant to their role and duties for example Provision and Use of Work Equipment Regulations, General Data Protection Regulations, safeguarding children, young people and vulnerable adults, waste management, risk management and assessment, record keeping and compliance",null,null,null,null,null,null,{"$f":"IF(C22:C43 = \"FULLY MET\",1,IF(C22:C43 = \"PARTIALLY MET\",0.5,IF(C22:C43 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Key UK environmental legislation, land and wildlife designations, permissions and licences relevant to the management of habitats and species and other countryside management works e.g. Conservation of Habitats and Species Regulations 2017, National Parks and Access to the Countryside Act and Natural Environment and Rural Communities Act",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},"FULL"]
["K3","Current legislation, planning regulation and legal processes and procedures in relation to managing public rights of way and other public access such as Highways Act, Countryside and Rights of Way Act and Definitive Maps and Statements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Ecology including main UK ecosystems, habitats and indicator species and identification and requirements of a complex range of native and invasive species and the relationship between them and the environment in relation to their local area",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Practical and technical land and habitat management techniques such as felling, pruning, planting, cutting, mowing, coppicing, thinning, spraying and uprooting, livestock grazing and controlling vegetation and invasive species such as Japanese Knotweed and best practice for a range of habitats and species and how to balance conflicting needs",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Main uses of land in UK such as a: Main uses of land in UK such as agriculture, forestry, housing, recreation and their interactionsgriculture, forestry, housing, recreation and their interactions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The structure, content, purpose and uses of work programmes, site, habitat and project plans to assist with the day to day and technical management of the delegated countryside sites, areas or projects. For example, habitat action plans, biodiversity action plans",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Principles of financial management including how to set up and manage a budget and the project management life cycle from business case to implementation including risk assessment, planning, financial management, resources, reporting and evaluation techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Methods for managing teams, allocating work and delegation and how their team’s work links to the organisational objectives, lines of responsibility and who to speak to if they need to escalate issues",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The types of UK funding streams relevant to organisational objectives. For example: Countryside Stewardship, farming subsidies, developer contributions and lottery funding",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Legislation, principles and best practice for the design, construction and management of assets and infrastructure such as steps, ramps, gates, stiles, bridges and drainage; boundaries such as fences, walls and hedges; and public access routes such as public rights of way and permissive access including a technical understanding of their type, usage, cost, lifespan, historic value and relationship with landscape, terrain and regional character",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Applications for different machinery, tools and equipment for a wide variety of habitat, access or asset management work, and their use e.g. 4WD vehicles, winches and other powered and non-powered tools such as chainsaws, mobile devices and other technology such as GPS and tablets",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J33=1,1,IF(J33=0.5,0.5,IF(J33=0,0)))","v":0},"FULL"]
["K13","Survey techniques and how to plan surveys, appropriateness of the surveys and techniques and technology used in their implementation for habitats and species, visitors or volunteers, assets and access work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How to examine and interpret survey data with particular attention to how this data is used internally such as Ecologists, externally, locally and nationally to assess current populations of flora and fauna and current and future habitat management and visitor management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How to recruit, train, supervise, motivate and manage volunteers and staff to maintain good team relations and provide a positive volunteer experience",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Communication methods used to influence and build effective relationships with colleagues, team members, volunteers, contractors, local community groups such as Friends of groups, interest groups such as British Horse Society, educational and corporate groups, neighbouring landowners, tenants and stakeholders and the public and how to promote the work of their organisation in a positive light",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Customer service principles including types and needs of different customers (internal and external to the organisation), their expectations and managing conflict",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The different types of minor and major emergencies and incidents in the sector such as landslips, flooding, snow and ice, fires, pollution, first aid emergencies or theft of equipment. How to manage them including safe working practices, limits of responsibility, organisational and legislative processes and the response/actions needed and how they impact upon the environment, natural habitats, assets and people",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Notifiable or other pests and diseases relevant to their role which affect plant, animal and human health and reporting procedures and biosecurity measures associated with them e.g. Phytophthora and Ash Dieback",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","The differences between environmental interpretation and information provision and methods of delivery, intended uses and benefits e.g. social media, public events, educational visits and Forest School, interactive displays, guided walks, leaflets and trails",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","How to plan, research, design, analyse and evaluate environmental interpretation and information provision including selecting methods, style and structure best suited to the needs of the audience, location and focus of content",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The importance of and organisational approaches to performance management and supervisory practices to improve performance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Assess, prioritise, maintain and evaluate a safe working environment following relevant legislation, work place policies and procedures including identifying hazards, assessing risk and minimising risk and implementing and complying with control measures",null,null,null,null,null,null,{"$f":"IF(C45:C69 = \"FULLY MET\",1,IF(C45:C69 = \"PARTIALLY MET\",0.5,IF(C45:C69 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J45=1,1,IF(J45=0.5,0.5,IF(J45=0,0)))","v":0},"FULL"]
["S2","Comply with and ensure others comply with legal requirements, industry regulations and standards and organisational policies, processes, procedures and professional codes and ethics",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J46=1,1,IF(J46=0.5,0.5,IF(J46=0,0)))","v":0},{"$f":"IF(L46=1,\"NONE\",IF(L46=0.5,\"PARTIAL\",IF(L46=0,\"FULL\")))","v":"FULL"}]
["S3","Comply with environmental best practices and procedures and follow sustainability and waste management practices",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J47=1,1,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},"FULL"]
["S4","Organise and prioritise environmental and land management work activities such as habitat management, work associated with public access or assets such as bridges and scheduled monuments. This includes assessing tasks, identifying and allocating the required resources to deliver the task effectively and review completed work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Manage a range of habitats and species using a variety of specialist techniques and resources which takes account of the local area, habitat, species of flora and fauna and levels of associated protection such as felling, pruning, planting, cutting, mowing, coppicing, thinning, spraying and uprooting, livestock grazing and controlling vegetation and invasive species such as Japanese Knotweed",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Produce short or medium term work, site, habitat action or small scale project plans for the delegated areas of responsibility for and in line with organisations requirement and based on sound knowledge of ecological principles and in line with relevant legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Delegate tasks to volunteers/ team members",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Deliver work and projects on time, to a high standard, using allocated resources, to planned budget, method and quality and represent value for money e.g. environmental and land management, public engagement, interpretation or survey work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Manage workload, taking into account competing and changes in priorities and demonstrate problem solving ability",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Communicate with the correct authorities and seek advice on land, nature conservation and asset management, such as Historic England for Scheduled Monuments or ecologists",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Organise and prioritise asset and infrastructure construction, maintenance and management works including any surveys and alternative plans",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Construct, maintain and manage a range of boundaries, public access routes, infrastructure and assets using a variety of specialist techniques, tools, equipment and resources",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J56=1,1,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},{"$f":"IF(L56=1,\"NONE\",IF(L56=0.5,\"PARTIAL\",IF(L56=0,\"FULL\")))","v":"FULL"}]
["S13","Correctly identify the unique range of native and invasive species and habitats in the geographical area",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J57=1,1,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},"FULL"]
["S14","Survey, analyse, communicate and evaluate results for habitats, species and countryside assets",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Select and use a range of work-based tools, machinery and equipment e.g. 4WD vehicles, trailers, winches and other powered and non-powered tools such as chainsaws, brushcutters, hedge trimmer and hand tools, mobile devices and other technology such as GPS, tablets and cameras",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J59=1,0.5,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=0.5,\"NONE\",IF(L59=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S16","Instruct others how to use tools and machinery correctly and safely and ensure operator competence",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J60=1,0.5,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=0.5,\"NONE\",IF(L60=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S17","Complete records associated with tools and machinery e.g. maintenance, use, vibration and noise levels etc",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S18","Engage and communicate clearly and effectively with stakeholders including the public, landowners, tenants, contractors and colleagues",null,null,null,null,null,null,0,null,"PARTIAL",0,"PARTIAL"]
["S19","Supervise, motivate and work alongside others while undertaking habitat management, construction and maintenance of boundaries, access routes and associated countryside assets",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J63=1,1,IF(J63=0.5,0.5,IF(J63=0,0)))","v":0},"FULL"]
["S20","Present information to the public and relevant stakeholders on planned works, site designation, its species and habitats and techniques used to manage an area",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["S21","Deal with emergencies and incidents as appropriate within the limits of their responsibility, authority and level of training",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},"FULL"]
["S22","Design, produce and evaluate various types of environmental interpretation and information provision for a range of audiences",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Speak in public and engage with a wide range of audiences such as stakeholders e.g. tenants, local community or interest groups, volunteers, educational and corporate groups and members of the public on a range of topics. For example, planned or ongoing habitat or access management, local flora and fauna or history and archaeology of an area",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Recognise strengths and areas for development, creates SMART objectives in line with organisational objectives, participates in development opportunities and regularly seeks feedback",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Make decisions based on the organisations principles and relevant and accurate information",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Has a self-disciplined, self-motivated, and proactive approach to work",null,null,null,null,null,null,{"$f":"IF(C71:C82 = \"FULLY MET\",1,IF(C71:C82 = \"PARTIALLY MET\",0.5,IF(C71:C82 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J71=1,1,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},"FULL"]
["B2","Is conscious of time constraints and takes personal responsibility for delivering their work to time and budget",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Responds positively to feedback and is open to change",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Considers other perspectives, options and the bigger picture to make a decision and focuses on solutions rather than problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Acts in accordance with the organisational policies, procedures, values and behaviours and in a polite, professional and inclusive manner",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J75=1,1,IF(J75=0.5,0.5,IF(J75=0,0)))","v":0},{"$f":"IF(L75=1,\"NONE\",IF(L75=0.5,\"PARTIAL\",IF(L75=0,\"FULL\")))","v":"FULL"}]
["B6","Communicates effectively - Adapts communication style and medium to suit the audience",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J76=1,1,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},"FULL"]
["B7","Acts as an ambassador for the organisation and takes personal responsibility for identifying and addressing the needs of customers and builds effective and collaborative working relationships",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J77=1,0.5,IF(J77=0.5,0.5,IF(J77=0,0)))","v":0},{"$f":"IF(L77=0.5,\"NONE\",IF(L77=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B8","Proactively promotes and champions health, safety and wellbeing within their organisation",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J78=1,1,IF(J78=0.5,0.5,IF(J78=0,0)))","v":0},"FULL"]
["B9","Takes personal responsibility for developing knowledge and skills and continually seeks to improve their performance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B10","Self awareness - Aware of own knowledge and limits of responsibility and seeks relevant advice and support when appropriate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B11","Establishes and promotes respect for the work of the organisation from customers, stakeholders and co-workers",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J81=1,0.5,IF(J81=0.5,0.5,IF(J81=0,0)))","v":0},{"$f":"IF(L81=0.5,\"NONE\",IF(L81=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B12","Takes a positive approach to working outside in differing weather conditions",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J82=1,1,IF(J82=0.5,0.5,IF(J82=0,0)))","v":0},"FULL"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J82)","v":0},"Net Score",{"$f":"SUM(L22:L82)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J86/L90","v":0},"total CoE KSB coverage",{"$f":"L86/L93","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",59]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",6]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L90-L91-(L92*0.5)","v":56}]

{"sheet":"ST0946","index":5,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Vet technician (livestock) (level 5)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","The appropriate level of professional conduct for Vet Technicians and the expectations of the vet practice.",null,null,null,null,null,null,{"$f":"IF(C22:C44 = \"FULLY MET\",1,IF(C22:C44 = \"PARTIALLY MET\",0.5,IF(C22:C44 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The scope of the business environment in which the vet practice operates and the need to meet ethical and legal responsibilities.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","The principles of infection control in livestock to control the spread of infection/ diseases. This includes using personal protective equipment (PPE), efficient hand washing techniques, the importance of biosecurity and the role of disinfection and sterilisation, particularly when working on multiple sites.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The complexities of different agricultural environments and how this affects animal health and welfare.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The principles and practices of handling unpredictable livestock in a safe manner and in line with Manual Handling Operations Regulations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Dynamic risk assessment processes and lone worker protocols for different environments and livestock. How risk assessments can be applied to reduce the stress and risk of injury to self and different types of livestock.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J27=1,1,IF(J27=0.5,0.5,IF(J27=0,0)))","v":0},"FULL"]
["K7","Principles of collecting data to form reports to meet regulatory requirements of medicine legislation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Principles and scope of vet led protocols for the administration of vaccinations and the antibody reaction, Principles, protocols and use of veterinary medicines in livestock treatments, including how to administer them: injection, oral bolus, topical application.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J29=1,1,IF(J29=0.5,0.5,IF(J29=0,0)))","v":0},"FULL"]
["K9","How to use a range of information and data to identify potential health and welfare issues and the preventative or reactive measures that could be applied.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The safe use of veterinary medicines and COSHH (Control of Substances Hazardous to Health) essentials for farmers.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Diseases (zoonoses) caused by micro-organisms, which are subject to the Control of Substances Hazardous to Health Regulations (COSHH).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Communication strategies to develop effective working relationships and engage clients and practice colleagues.",null,null,null,null,null,null,0,null,"NONE",0,{"$f":"IF(L33=1,\"NONE\",IF(L33=0.5,\"PARTIAL\",IF(L33=0,\"FULL\")))","v":"FULL"}]
["K13","Husbandry procedures such as disbudding, foot trimming, non-surgical castration and tail docking, mobility assessment and growth monitoring.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J34=1,1,IF(J34=0.5,0.5,IF(J34=0,0)))","v":0},"FULL"]
["K14","Strategies to ensure health and welfare of livestock and cost- effective preventative approaches.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How to report concerns with livestock and/ or human welfare.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Protocols for handling livestock during Vet Tech procedures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How collaboration with outside organisations can enhance animal health and welfare. E.g. Agricultural and Horticultural development board (AHDB).",null,null,null,null,null,null,0,null,"NONE",0,{"$f":"IF(L38=1,\"NONE\",IF(L38=0.5,\"PARTIAL\",IF(L38=0,\"FULL\")))","v":"FULL"}]
["K18","Evaluation methods including the use of software to measure the impact of treatments. The use of this information to inform future strategies across other locations/ environments.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J39=1,1,IF(J39=0.5,0.5,IF(J39=0,0)))","v":0},"FULL"]
["K19","Evaluating breeding values and methods of genetic improvements for health and productivity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Social responsibility to function sustainably and minimise waste.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Livestock weighing and how to carry out body condition scoring to national guidelines.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The Animal and Plant Health Agency (APHA) and vet led protocols and procedures when using blood sampling for diagnosis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The requirement to maintain client confidentiality and obligations under GDPR (General Data Protection Regulations).",null,null,null,null,null,null,0,null,"NONE",0,{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"}]
[null,"Skills"]
["S1","Plan and carry out dynamic risk assessments taking account of lone worker protocols and varying environments/ livestock. Develop courses of action to minimise risk.",null,null,null,null,null,null,{"$f":"IF(C46:C62 = \"FULLY MET\",1,IF(C46:C62 = \"PARTIALLY MET\",0.5,IF(C46:C62 = \"NOT MET\",0,)))","v":0},null,"NONE",0,"FULL"]
["S2","Manage data collection for health plans and reports.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Analyse, interpret, and evaluate data using appropriate software, to inform diagnosis/ recommendations for preventative treatment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Collaborate with agricultural staff to obtain information impacting on livestock health (e.g. feed rations).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Administer appropriate veterinary medicines, as set out within a vet led protocol, to treat livestock, such as by injection, oral bolus or topical application.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J50=1,1,IF(J50=0.5,0.5,IF(J50=0,0)))","v":0},{"$f":"IF(L50=1,\"NONE\",IF(L50=0.5,\"PARTIAL\",IF(L50=0,\"FULL\")))","v":"FULL"}]
["S6","Identify environmental factors that can have a positive and/or negative effect on animal health and welfare.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Plan and carry out livestock assessment, such as mobility assessment, weighing or body condition scoring.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Identify when samples are required for parasite identification. Collect relevant samples in accordance with protocols and lab procedures.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Complete disbudding/ horn removal of livestock.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J54=1,0.5,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=0.5,\"NONE\",IF(L54=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S10","Support the Vet in practice to carry out blood sampling for disease or health analysis/diagnosis. Complete documentation for further lab analysis and to ensure traceability.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Build rapport with clients whilst managing client expectations and competing priorities.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J56=1,1,IF(J56=0.5,0.5,IF(J56=0,0)))","v":0},"FULL"]
["S12","Manage own workload, balancing cost and efficiency with livestock health and welfare priorities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Use equipment, such as livestock crush and raise systems for safe handling and pharmaceutical equipment and products, in line with operating procedures and manufacturers guidelines.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Monitor and manage requirements for equipment maintenance and repair.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J59=1,0.5,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=0.5,\"NONE\",IF(L59=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Identify, use and dispose of correct PPE appropriate to the task.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Identify biosecurity risks and mitigate against them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Maintain client confidentiality in line with practice requirements and GDPR (General Data Protection Regulations).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Builds and maintains relationships with customers, colleagues, and suppliers.",null,null,null,null,null,null,{"$f":"IF(C64:C69 = \"FULLY MET\",1,IF(C64:C69 = \"PARTIALLY MET\",0.5,IF(C64:C69 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J64=1,0.5,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=0.5,\"NONE\",IF(L64=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Maintains ethical standards.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J65=1,1,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=1,\"NONE\",IF(L65=0.5,\"PARTIAL\",IF(L65=0,\"FULL\")))","v":"FULL"}]
["B3","Takes responsibility for planning and developing courses of action.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Undertakes career professional development to maintain technical knowledge.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Acts professionally and adapts style and method of communication to the circumstances and needs of individuals.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Adheres to the requirements of health and safety legislation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J69)","v":0},"Net Score",{"$f":"SUM(L22:L69)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J73/L77","v":0},"total CoE KSB coverage",{"$f":"L73/L80","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",46]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L77-L78-(L79*0.5)","v":44.5}]

{"sheet":"ST1320","index":6,"n_rows":82,"n_cols":18,"rows_kept":82,"cut":false,"hidden":false,"merged":[[9,0,9,6]]}
[null,"START HERE"]
[null,"Awarding body/Applicant:"]
[null,"Please type the name of awarding body/applicant here"]
[null,"Qualification name:"]
[null,"Please type your qualification title here"]
[null,"Programme title if applicable:"]
[null,"Please type the programme title here"]
[]
[]
["EXAMPLE OF KSB MAPPING"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials."]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","FULLY MET","Qualification specification, pg 14-16\n\nModule 2: Health, safety and professional working practices, pg 6\n\n","Module 2: LO1 - Understand the importance of health and safety in the workplace. LO2 - Understand the application of health and safety legislation in the workplace. LO3 - Understand how to apply safe working practices to work activities. \nIndicative content: local, regional, national health & safety regulations, codes of practice, site safety, health & safety promotion, health & safety measures, PPE, manual handling, equipment management, waste disposal, risk management, risk assessment","Learners will be able to show a full understanding of Health & Safety and legislative requirements relevant to the role. The indicative content on Pg 16 of the qualification specification shows they will cover Health & Safety across the wider sector, and then identify some measures that may be specific to certain organisations. Learners will also analyse the role of the employer and the environment with regards to applying Health & Safety working practices and processes.","Module 2 - students will produce a written report using a brief. There is also a short answer paper. Module 2 Assessment Brief pg 7-8 refers. \n"]
["S23 ","Communicate effectively (verbal, non-verbal, written, digital) in manner relevant to the target audience","FULLY MET","Qualification specification, pg 21-22\nModule 6: The Fundamentals of Practice, pg 12\nModule 9: Personal and Professional Development Skills, pg 11\n\n","Module 6: LO2 - Know how to use digital devices and databases relevant to your workplace. Module 9: LO1 - Understand the uses of different methods of communication. LO3 - Be able to communicate effectively with different audiences. \nIndicative content: verbal and non-verbal communication skills, presentation skills, academic and non-academic writing style, writing skills","Learners will cover verbal, non-verbal, written and digital communications, and demonstrate practical skills by completing assessment tasks which will include simulated work environments and preparing presentations targeting different audiences. Learners will develop the skills to communicate with people in a professional capacity including co-workers, line managers, clients, contractors and the public.","Module 6 - case study. \nModule 9 - scenarios in simulated work environment, students will produce presentation. Module 9 assessment pg 4. \n\n"]
[]
[]
[]
[]
[null,"Assistant farm manager (level 4)"]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","Physiological principles underpinning a production system and the impacts of husbandry or agronomy activities and inputs.",null,null,null,null,null,null,{"$f":"IF(C22:C46 = \"FULLY MET\",1,IF(C22:C46 = \"PARTIALLY MET\",0.5,IF(C22:C46 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","Importance of soil, types of soil and their impact on crop and husbandry decisions. Characteristics of poor and good soil structure, the impact of operations on soil and actions to improve structure. Soil fertility analysis data, and how to obtain and interpret it.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J23=1,1,IF(J23=0.5,0.5,IF(J23=0,0)))","v":0},{"$f":"IF(L23=1,\"NONE\",IF(L23=0.5,\"PARTIAL\",IF(L23=0,\"FULL\")))","v":"FULL"}]
["K3","Components of soil management plans and their purpose for managing soil health, nutrients, yields, runoff, erosion, flooding, soil carbon, external additives. Importance and principles of nutrient management guidance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Principles of managing plant or animal health, the importance and principles of biosecurity and how to comply with plant or animal health legislation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Main habitats found on production sites, how to obtain and interpret information on site biodiversity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Implications of environmental legislation and industry guidance for site management.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Threats to production from climate change, the principles of sustainability and net zero targets.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Techniques for optimising value of resources and by-products. Principles of the waste hierarchy (reduce, reuse, recycle).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Legislative and environmental regulation for management of by-products, inorganic waste, hazardous waste, Nitrate Vulnerable Zones, water and air and implications of non-compliance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Components of a farm or enterprise supply chain, how they interact and the interdependence of the supply chain to ensure quality and quantity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Technical content quality measures or specification requirements for farm products, why this important to meet customer needs and or commercial contracts.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Regulation, production standards and codes of practice for their area of work and the importance of compliance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Types of financial capital investment, sources of information and their suitability and risk.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Types of production, financial and business data, uses and analysis.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Factors impacting on the performance of farm or horticultural enterprises and techniques to set financial and production Key Performance Indicators, monitor and evaluate them.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Components of strategic plans, business plans, operational plans and business cases. Their relationships and importance for improving enterprise performance and response to external factors for example environmental, political, social or financial",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Know where to find reliable sources of information on production practices and new technologies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Principles of online safety, confidentiality and protection of data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Health, safety and wellbeing legislation, codes of practice and their implications for site management. The main hazards, risks to health, welfare and wellbeing found on farms or horticultural sites and mitigation methods. The risk from zoonoses. Factors when dealing with public, visitors or children on site.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Legislative requirements and codes of practice for use of chemicals, for example medicines or pesticides. Techniques for spraying chemicals or organic substances.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Factors when planning the safe and efficient use of machinery, equipment and facilities including legislation, operator competence, new technologies, maintenance requirements, suitability for task and business policy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Methods and techniques for communicating with professional and non-professional audiences including use of digital methods.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Principles of managing people including compliance with regulation, recruitment, performance management, informal training and appraisals.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Purpose and types of farm or enterprise records including compliance, legal, health and safety, human resources, production, environmental, finance and industry audit requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Factors that influence decisions about machinery and infrastructure including return on investment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply physiological principles to identify interventions to enhance productivity and maintain unit health.",null,null,null,null,null,null,{"$f":"IF(C48:C66 = \"FULLY MET\",1,IF(C48:C66 = \"PARTIALLY MET\",0.5,IF(C48:C66 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J48=1,0.5,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=0.5,\"NONE\",IF(L48=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Develop, implement and monitor a soil, manure or nutrient management plan to improve soil structure and fertility and monitor progress.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J49=1,1,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=1,\"NONE\",IF(L49=0.5,\"PARTIAL\",IF(L49=0,\"FULL\")))","v":"FULL"}]
["S3"," Implement and review plans to manage the health of the production system in line with legislation and company policy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Implement practices that comply with environmental protection legislation and industry guidance, including pollution avoidance and control, wildlife and countryside protection and protection of biodiversity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Improve environmental practices on site including protecting and enhancing biodiversity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Develop and implement plan(s) to optimise value of by-products and dispose of non reusable (single use) wastes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7"," Implement plans to produce products or services to customer specification, quality standards and production standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Collect and evaluate critical information using digital tools including production unit performance, identify opportunities for improvement and propose changes to technical production strategy and operational adjustments.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Analyse basic farm and or enterprise data (including financial and production) and research farm practices. Use this to benchmark against other farms and support recommendations for future actions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Develop and evaluate production unit plans to meet business requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Manage, review and monitor health, safety, welfare and wellbeing on production unit. Carry out risk management including assessment of risk and mitigation. Communicate health and safety information to staff or stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Manage own health and safety and promotes best practice to others when undertaking activity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Make recommendations on machinery and infrastructure for a farm or horticultural business activity including condition, replacements and return on investment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Use, maintain and oversee machinery and infrastructure in line with legislation, manufacturers guidance and business policy.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J61=1,0.5,IF(J61=0.5,0.5,IF(J61=0,0)))","v":0},{"$f":"IF(L61=0.5,\"NONE\",IF(L61=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S15","Communicates in a professional manner with staff and stakeholders, adapting approach to audience including technical audiences and use of technical industry terminology.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J62=1,1,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},{"$f":"IF(L62=1,\"NONE\",IF(L62=0.5,\"PARTIAL\",IF(L62=0,\"FULL\")))","v":"FULL"}]
["S16","Build relationships with stakeholders including negotiation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Supervise staff or contractors during the main stages of the production cycle.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J64=1,0.5,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=0.5,\"NONE\",IF(L64=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S18","Keep business records including using digital tools.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Oversees and uses agrochemicals or organic equivalents including using spraying equipment.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J66=1,0.5,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=0.5,\"NONE\",IF(L66=0,\"PARTIAL\"))","v":"PARTIAL"}]
[null,"Behaviours"]
["B1","Challenge approaches to current working practices in a constructive manner, identifying potential for improvement and development.",null,null,null,null,null,null,{"$f":"IF(C68:C72 = \"FULLY MET\",1,IF(C68:C72 = \"PARTIALLY MET\",0.5,IF(C68:C72 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J68=1,1,IF(J68=0.5,0.5,IF(J68=0,0)))","v":0},{"$f":"IF(L68=1,\"NONE\",IF(L68=0.5,\"PARTIAL\",IF(L68=0,\"FULL\")))","v":"FULL"}]
["B2","Champions health and safety across the team and embeds it in activities.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J69=1,1,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},{"$f":"IF(L69=1,\"NONE\",IF(L69=0.5,\"PARTIAL\",IF(L69=0,\"FULL\")))","v":"FULL"}]
["B3","Acts in a way that builds and maintains positive relationships with colleagues, customers and suppliers.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Acts in a professional and ethical manner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Committed to Continuous Professional Development",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J72=1,0.5,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=0.5,\"NONE\",IF(L72=0,\"PARTIAL\"))","v":"PARTIAL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J72)","v":0},"Net Score",{"$f":"SUM(L22:L72)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J75/L79","v":0},"total CoE KSB coverage",{"$f":"L75/L82","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",49]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partially mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L79-L80-(L81*0.5)","v":47}]

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