{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["GUIDE TO KSB MAPPING","ST0055","ST0425","ST0488","ST0696","ST0749","ST0912","ST0933","ST0940","ST0944","ST1324","ST1325","ST1388","Source filters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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 (E-I for ST0055, F-J for ST01325 or G-K for ST0488;) 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":"ST0055","index":1,"n_rows":146,"n_cols":20,"rows_kept":146,"cut":false,"hidden":false,"merged":[[112,10,112,14],[124,10,124,14],[136,10,136,14],[9,0,9,8],[10,2,10,3],[23,2,23,3],[20,1,21,3]]}
[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\n\n(this list contain the core KSBs for the Bespoke cutter and tailor occupation, plus the specific KSBs for Cutter and Tailor options)","Included in: ",null,"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 H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G 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,null,"Bespoke cutter and tailor (level 5) - Cutter","Bespoke cutter and tailor (level 5) - Tailor"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","YES","YES","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","YES","YES","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,"Bespoke cutter and tailor (level 5)"]
[null,"Return to Guide"]
[null,"Two options are available (columns C-D). Please check if the KSB needs to be mapped against the option of your choice. If you map against two options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
[]
["KSB","KSB Statement\n\n(this list contain the core KSBs for the Bespoke cutter and tailor occupation, plus the specific KSBs for Cutter and Tailor options)","Included in: ",null,"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 H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G 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","Bespoke cutter and tailor (level 5) - Cutter","Bespoke cutter and tailor (level 5) - Tailor"]
["K1","Material manufacturing processes from raw material to finished product. How they meet British and international standards.","YES","YES",null,null,null,null,null,null,{"$f":"IF(E26:E67 = \"FULLY MET\",1,IF(E26:E67 = \"PARTIALLY MET\",0.5,IF(E26:E67 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L26=1,1,IF(L26=0.5,0.5,IF(L26=0,0)))","v":0},{"$f":"IF(N26=1,\"NONE\",IF(N26=0.5,\"PARTIAL\",IF(N26=0,\"FULL\")))","v":"FULL"}]
["K2","Properties and characteristics of cloth.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Professional client relationship management. For example, liaising on suitability of cloth, materials and trimmings when agreeing specifications for bespoke garments.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Properties and characteristics of trimmings.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Data protection laws and confidentiality protocols for the setting and the impact on the role including social media policy.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","How to interpret figure and posture to produce a bespoke fit.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The range of bespoke individual styles and their suitability to clients.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Roles and responsibilities of the cutter and tailor. Agreed communication channels with the client.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Bespoke cutting and tailoring terminology.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Recognising defects in materials and the impact on the bespoke garment.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Quality control throughout the bespoke process.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","How to maintain and safely use tools, equipment and machinery.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","The importance of timely workflow to meet the agreed specification.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Efficient use of resources, time and materials.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Health and safety at work legislation.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How to handle and store bespoke cut components in the making process.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How to handle and store finished bespoke garments.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Processes to log and number each bespoke garment and methods of tracking for example an order book or checklist.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Quality assurance including formal recording methods for alterations to a bespoke garment.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How to decide if an adjustment or repair is both sustainable and viable to a bespoke garment.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","The availability and cost of bespoke materials.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","How to establish component costs.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Costing of a bespoke garment.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","How to measure a client and observe figure variations for the construction of a bespoke cutting pattern.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","How to organise purchasing of materials.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Stock control methods such as taking inventories.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","The bespoke process to meet the specification.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Technical planning of the client commission for a range of bespoke garments, such as jackets, trousers, waistcoats.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Bespoke cutter review and approval processes in relation to the specification for example in relation to fit, quality and cost.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Client aftercare.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","How to interpret body measurements and figure variations to inform the construction of bespoke cutting patterns.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Preparation of component bespoke garment parts.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","How to prepare and produce economical lay plans.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Inspection of garment components and finished garments at defined process stages.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","How to read and interpret cutter instructions.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Different work methods, appropriate to the use of a range of materials.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Construction details of style elements including pocket types such as double jetted, welted or slanted.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","How to baste and re-baste bespoke garments through a process of adjustments.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","How to complete and press bespoke garments to specification.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","Figure and body types and how these impact on the bespoke garment construction process.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","How to adapt bespoke features to different body proportions.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","Adjustments as instructed by the cutter.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Produce a bespoke specification to deliver against agreed client requirements such as design, material and timeframe.","YES","YES",null,null,null,null,null,null,{"$f":"IF(E69:E105 = \"FULLY MET\",1,IF(E69:E105 = \"PARTIALLY MET\",0.5,IF(E69:E105 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L69=1,1,IF(L69=0.5,0.5,IF(L69=0,0)))","v":0},{"$f":"IF(N69=1,\"NONE\",IF(N69=0.5,\"PARTIAL\",IF(N69=0,\"FULL\")))","v":"FULL"}]
["S2","Professional communication with stakeholders.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Interpret specification, managing expectations both internally and externally.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Professional communication with colleagues to ensure a productive work environment.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Maintain comprehensive records relating to the sale and production of bespoke garments.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Identify defects in materials and take the correct course of action to rectify.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Select materials suitable for intended use.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Diagnose and improve on issues against the specification of the bespoke garment.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Store tools and equipment for example shears and scissors.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Identify and minimise hazards and control risks in the workplace to maintain work procedures ensuring health and safety requirements are met.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Select, prepare, and test tools and machinery, including adjustments for different materials.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Correctly handle and store bespoke cut components in the making process.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Evaluate the effectiveness of the bespoke cutting and tailoring process.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Handle and store finished bespoke garments in a safe and suitable location ready for client fitting or collection.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Assess bespoke garment and implement the appropriate method to remedy a problem.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Carry out cost calculation for a bespoke garment.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Carry out bespoke selling and after care.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Take a full set of body measurements. Observe and record client posture and figure.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Implement efficient and effective use of resources, time and materials.","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Organise purchasing of materials.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Record materials on receipt from suppliers. Manage stock levels.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Coordination of the bespoke process to meet the specification.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Produce bespoke cutting patterns according to customer requirements.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Lay out cutting patterns to create an efficient lay plan and mark the cloth.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Cut cloth and trimmings for the bespoke garment. Include sufficient inlays to ensure the bespoke garment has longevity.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Create bundle with all component parts including the specification for onward progression storing any spare cloth and trimmings.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Carry out fittings ensuring that the bespoke garment meets the specification such as adapting to figure and posture.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Adjust bespoke cutting patterns following fittings.","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S29","Disassemble a garment and amend construction as per cutters instructions.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S30","Inspect bespoke garment components to confirm it is complete and meets the specification. Report issues to cutter.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Make proportionate style details to suit body shape such as lapel size.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S32","Interpret body shapes to achieve a correctly proportioned bespoke garment.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S33","Prepare the bespoke garment by hand for fitting. For example, canvas a coat.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S34","Prepare the bespoke garment for any required additional fittings having completed all adjustments as instructed by the cutter such as pocket placement and size.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S35","Construct style elements for a bespoke garment including making pockets such as double jetted, welted or slanted.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S36","Complete final adjustments and hand stich buttonholes. Hand finish the bespoke garment inside and out.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S37","Inspect the quality of construction during the bespoke process.","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Commitment to maintaining high standards of precision and excellence.","YES","YES",null,null,null,null,null,null,{"$f":"IF(E107:E110 = \"FULLY MET\",1,IF(E107:E110 = \"PARTIALLY MET\",0.5,IF(E107:E110 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(L107=1,1,IF(L107=0.5,0.5,IF(L107=0,0)))","v":0},{"$f":"IF(N107=1,\"NONE\",IF(N107=0.5,\"PARTIAL\",IF(N107=0,\"FULL\")))","v":"FULL"}]
["B2","Focus on the requirements of the customer in a respectful and professional manner.","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L108=1,1,IF(L108=0.5,0.5,IF(L108=0,0)))","v":0},{"$f":"IF(N108=1,\"NONE\",IF(N108=0.5,\"PARTIAL\",IF(N108=0,\"FULL\")))","v":"FULL"}]
["B3","Strong work ethic and commitment in order to meet the standards required.","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L109=1,1,IF(L109=0.5,0.5,IF(L109=0,0)))","v":0},{"$f":"IF(N109=1,\"NONE\",IF(N109=0.5,\"PARTIAL\",IF(N109=0,\"FULL\")))","v":"FULL"}]
["B4","Recognition and appreciation of equality and diversity in the workplace.","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(L110=1,1,IF(L110=0.5,0.5,IF(L110=0,0)))","v":0},{"$f":"IF(N110=1,\"NONE\",IF(N110=0.5,\"PARTIAL\",IF(N110=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Bespoke cutter and tailor (level 5) - Cutter"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(, L26:L59, L69:L96, L107:L110)","v":0},"Net Score",{"$f":"SUM(, N26:N59, N69:N96, N107:N110)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L115/N119","v":0},"total CoE KSB coverage",{"$f":"N115/N122","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",66]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N119-N120-(N121*0.5)","v":66}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Bespoke cutter and tailor (level 5) - Tailor"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(, L26:L46, L60:L67, L69:L83, L87, L97:L105, L107:L110)","v":0},"Net Score",{"$f":"SUM(, N26:N46, N60:N67, N69:N83, N87, N97:N105, N107:N110)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L127/N131","v":0},"total CoE KSB coverage",{"$f":"N127/N134","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",58]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N131-N132-(N133*0.5)","v":58}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KBSs"]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(L26:L110)","v":0},"Net Score",{"$f":"SUM(N26:N110)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"L139/N143","v":0},"total CoE KSB coverage",{"$f":"N139/N146","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",83]
[null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"partially mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"N143-N144-(N145*0.5)","v":83}]

{"sheet":"ST0425","index":2,"n_rows":120,"n_cols":18,"rows_kept":120,"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,"Broadcast and media systems technician (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","Know where to source the correct maintenance procedures and schedules relevant to own role",null,null,null,null,null,null,{"$f":"IF(C22:C63 = \"FULLY MET\",1,IF(C22:C63 = \"PARTIALLY MET\",0.5,IF(C22:C63 = \"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 obtain functional and specification documentation such as equipment manuals, system specifications, manufacturers’ maintenance plans, design documents, fault logs/databases, regulatory requirements, functional specifications and operational handbooks for maintenance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","Understand the maintenance characteristics that are particularly critical to the broadcast and media equipment or system, including electrical, electronic, mechanical, software, environmental and ergonomics",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Understand the safe systems of work and isolation for working on antennas, high voltage, power boards, switchboards and uninterruptable power supplies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Know and understand the factors affecting decisions about ongoing maintenance versus replacement, including cost, downtime, reliability",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","How to connect broadcast systems and equipment to IT systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Understand the types of faults that may occur in broadcast and media systems and how to identify these",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How to conduct root cause analysis",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Why it is important to minimise equipment and systems downtime, and to solve problems quickly e.g. loss of service and potential reputational damage, or financial penalties for breach of service level agreements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Know and understand own Business Continuity procedures",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J31=1,0.5,IF(J31=0.5,0.5,IF(J31=0,0)))","v":0},{"$f":"IF(L31=0.5,\"NONE\",IF(L31=0,\"PARTIAL\"))","v":"PARTIAL"}]
["K11","Know and understand own workplace Health and Safety legislation, processes and procedures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Know how to safely use and maintain Personal Protective Equipment (PPE), tools and equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Understand the company procedures for reporting hazards and risks to the appropriate personnel",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Understand the main hazards to personal health and safety within own role such as electrical voltage and radio frequencies (RF)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Understand the different types and uses of broadcast and media systems test equipment such as analysers or meters",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Know and understand the importance of keeping testing equipment clean and accurately calibrated",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J37=1,1,IF(J37=0.5,0.5,IF(J37=0,0)))","v":0},"FULL"]
["K17","Understand the correct procedures for storing and transporting testing equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Know and understand how to use the testing equipment correctly and safely",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Know when, and who to report faults with the testing equipment to",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Understand elementary analogue and digital electronic techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Understand the fundamentals of digital signals, coding techniques, modulation and multiplexing techniques and fibre optic communication",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Understand Radio Frequency (RF) communication principles, wave propagation, transmission media and RF radiators",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Understand the principles, techniques and applications of computer network systems, ethernet and IP technology, network components, server systems, virtualisation and remote access technology",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Understand the purpose, benefits, limitations and risks of the different equipment and software required for broadcast and media systems and when it is appropriate to use them",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","How to operate the broadcast and media systems, software and equipment required",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Know the types of problem that can occur with the operation of broadcast and media systems such as loss of power, signal degradation, overheating etc.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","How to prioritise operational problems and why it is important to solve a problem quickly",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Understand the technical quality of service requirements that affect your work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Understand how to adapt communication style and supporting information to meet audience requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Understand how to identify and advise on the most effective and realistic solution in each circumstance, taking constraints into account",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Understand the importance of and methods for, organising and storing information such as written descriptions, diagrams, note taking from meetings, feedback from reports, presentations and change control",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Understand how to use the organisational recording systems correctly",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Understand broadcast technical operations, technical systems and equipment and the context of their use in workplace activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Understand the broadcasting and media systems industry; its heritage and its future direction.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","Know how to use resources, such as online sites, to update knowledge and find out what others are doing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Understand how and when to ask questions to improve your practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Understand the principles of design, architecture, development and maintenance of broadcast and media systems and networks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","Understand the brief for the work and how to interpret requirements and parameters as provided by the customer or line manager, or project manager and/or senior engineer",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","Understand the file transfer protocols, relating to broadcast and media systems, software and equipment including file access rights",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","Know how to connect broadcast and media systems and equipment to networks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","Know and understand the appropriate formats required for different broadcast methods such as Joint Photographic Experts Group Standard (JPEG) or Moving Picture Experts Group Standard (MPEG) files or MP3 (audio format of MPEG)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","How to protect content and the importance of information security",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Conduct planned maintenance on all systems in line with organisational procedures",null,null,null,null,null,null,{"$f":"IF(C65:C103 = \"FULLY MET\",1,IF(C65:C103 = \"PARTIALLY MET\",0.5,IF(C65:C103 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J65=1,0.5,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=0.5,\"NONE\",IF(L65=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S2","Ensure maintenance work complies with all relevant regulations and guidelines",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"}]
["S3","Take prompt action to respond to and diagnose any problems encountered",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Record maintenance carried out and actions taken in appropriate systems in line with organisational procedures",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"}]
["S5","Identify problems to broadcast media service or systems, conducting in-depth root cause analysis and fault finding as required",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"}]
["S6","Take ownership to resolve and/or escalate faults and incidents following the correct company procedures",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=0.5,\"NONE\",IF(L70=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S7","Communicate fault conditions in a timely manner, to colleagues, customers and service suppliers",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J71=1,1,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=1,\"NONE\",IF(L71=0.5,\"PARTIAL\",IF(L71=0,\"FULL\")))","v":"FULL"}]
["S8","Log faults and report them to the relevant operational business area",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"}]
["S9","Comply with organisational Health and Safety policies, practices and procedures",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J73=1,0.5,IF(J73=0.5,0.5,IF(J73=0,0)))","v":0},{"$f":"IF(L73=0.5,\"NONE\",IF(L73=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S10","Identify, mitigate and report any incidents or risks to the appropriate personnel",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J74=1,0.5,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=0.5,\"NONE\",IF(L74=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S11","Complete Risk Assessments for tasks and work activities within and relevant to, own role",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"}]
["S12","Work safely and follow procedures for working on antennas, high voltage, power boards, switchboards and with uninterruptable power supplies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Identify and obtain the appropriate test equipment required",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Ensure the equipment is in working condition and calibrated correctly",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Safely transport and store the testing equipment in line with organisational procedures",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J79=1,0.5,IF(J79=0.5,0.5,IF(J79=0,0)))","v":0},{"$f":"IF(L79=0.5,\"NONE\",IF(L79=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S16","Report any faults with the test equipment, rectifying these if appropriate",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J80=1,1,IF(J80=0.5,0.5,IF(J80=0,0)))","v":0},{"$f":"IF(L80=1,\"NONE\",IF(L80=0.5,\"PARTIAL\",IF(L80=0,\"FULL\")))","v":"FULL"}]
["S17","Test and evaluate the performance of electronic circuits",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Use software and hardware diagnostics tools and connectivity protocols to interface and integrate broadcast systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Use test equipment correctly, evaluating results and taking the appropriate course of action",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Interconnect and trouble-shoot video and audio signals",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Identify and advise on the most effective and realistic solution in each circumstance taking into account constraints",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Use a level of technical terminology that meets the technical understanding of the person receiving the advice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Adapt your communications style according to the audience",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Use supporting information that aids others’ understanding of advice when required such as system diagrams",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Check that the advice given complies with all relevant regulations and guidelines",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Ensure the delivery of systems/services to customers in line with agree service levels",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J90=1,0.5,IF(J90=0.5,0.5,IF(J90=0,0)))","v":0},{"$f":"IF(L90=0.5,\"NONE\",IF(L90=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S27","Comply with organisational systems for reporting and recording information",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J91=1,0.5,IF(J91=0.5,0.5,IF(J91=0,0)))","v":0},{"$f":"IF(L91=0.5,\"NONE\",IF(L91=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S28","Ensure records relating to planned and corrective maintenance are correctly completed and updated",null,null,null,null,null,null,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"}]
["S29","Create and maintain a professional development record to document progress against key competencies and enable effective learning from the workplace",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J93=1,0.5,IF(J93=0.5,0.5,IF(J93=0,0)))","v":0},{"$f":"IF(L93=0.5,\"NONE\",IF(L93=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S30","S30: Seek help or advice from appropriate people or information sources when limitations in your knowledge or expertise will impact on your work",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J94=1,1,IF(J94=0.5,0.5,IF(J94=0,0)))","v":0},{"$f":"IF(L94=1,\"NONE\",IF(L94=0.5,\"PARTIAL\",IF(L94=0,\"FULL\")))","v":"FULL"}]
["S31","Seek out learning and networking opportunities that will be most beneficial to you",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S32","S32: Remain flexible, adaptable and positive to new directions, creative requirements and technical developments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S33","Check that specifications are capable of being implemented and operated",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S34","Implement upgrades or modifications in line with organisational procedures and specification",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J98=1,0.5,IF(J98=0.5,0.5,IF(J98=0,0)))","v":0},{"$f":"IF(L98=0.5,\"NONE\",IF(L98=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S35","Check ingested data or transport streams against workflow requirements",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J99=1,1,IF(J99=0.5,0.5,IF(J99=0,0)))","v":0},{"$f":"IF(L99=1,\"NONE\",IF(L99=0.5,\"PARTIAL\",IF(L99=0,\"FULL\")))","v":"FULL"}]
["S36","Operate broadcast and media systems using methods and procedures that meet requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S37","Comply with the organisational processes for ensuring physical and electronic security of data and systems",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J101=1,0.5,IF(J101=0.5,0.5,IF(J101=0,0)))","v":0},{"$f":"IF(L101=0.5,\"NONE\",IF(L101=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S38","Play out or export media in line with requirements",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J102=1,1,IF(J102=0.5,0.5,IF(J102=0,0)))","v":0},{"$f":"IF(L102=1,\"NONE\",IF(L102=0.5,\"PARTIAL\",IF(L102=0,\"FULL\")))","v":"FULL"}]
["S39","Check that outputs of broadcast and media systems comply with specifications, regulations, standards, guidelines and procedures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","A strong work ethic and commitment to meet the standards required",null,null,null,null,null,null,{"$f":"IF(C105:C110 = \"FULLY MET\",1,IF(C105:C110 = \"PARTIALLY MET\",0.5,IF(C105:C110 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J105=1,1,IF(J105=0.5,0.5,IF(J105=0,0)))","v":0},{"$f":"IF(L105=1,\"NONE\",IF(L105=0.5,\"PARTIAL\",IF(L105=0,\"FULL\")))","v":"FULL"}]
["B2","Desire to expand technical knowledge, and passion for working with broadcast and media systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Thinking creatively and logically to solve technical issues - contributing to a process of continual improvement",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Recognition and compliance with workplace legislation, policies and procedures",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J108=1,0.5,IF(J108=0.5,0.5,IF(J108=0,0)))","v":0},{"$f":"IF(L108=0.5,\"NONE\",IF(L108=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Displaying confidence in their approach to communicating with different audiences",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J109=1,0.5,IF(J109=0.5,0.5,IF(J109=0,0)))","v":0},"PARTIAL"]
["B6","Building and maintaining positive relationships with colleagues, customers and suppliers",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J110=1,0.5,IF(J110=0.5,0.5,IF(J110=0,0)))","v":0},"PARTIAL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J110)","v":0},"Net Score",{"$f":"SUM(L22:L110)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J113/L117","v":0},"total CoE KSB coverage",{"$f":"L113/L120","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",87]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",16]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L117-L118-(L119*0.5)","v":79}]

{"sheet":"ST0488","index":3,"n_rows":243,"n_cols":22,"rows_kept":243,"cut":false,"hidden":false,"merged":[[185,12,185,16],[197,12,197,16],[209,12,209,16],[221,12,221,16],[233,12,233,16],[8,0,8,10],[9,2,9,5],[16,1,16,5],[18,1,18,5],[20,2,20,5]]}
[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 \n\n(this list contains the core KSBs for the Junior animator occupation, plus the specific KSBs for 2D Animation, Stop-Motion Animation, 3D Animation and Interactive media and immersive reality options)","Included in:",null,null,null,"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 H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G 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,null,"Junior animator (level 4) - 2D Animation","Junior animator (level 4) - Stop-motion Animation","Junior animator (level 4) - 3D Animation","Junior animator (level 4) - Interactive media and immersive reality"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","YES","YES","YES","YES","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","YES","YES","YES","YES","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,"Junior animator (level 4)"]
[null,"Return to Guide"]
[null,"Four options are available (columns C-F). Please check if the KSB needs to be mapped against the option of your choice. If you map against two or three options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
["KSB","KSB Statement \n\n(this list contains the core KSBs for the Junior animator occupation, plus the specific KSBs for 2D Animation, Stop-Motion Animation, 3D Animation and Interactive media and immersive reality options)","Included in:",null,null,null,"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 H) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column G 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","Junior animator (level 4) - 2D Animation","Junior animator (level 4) - Stop-Motion Animation","Junior animator (level 4) - 3D Animation","Junior animator (level 4) - Interactive media and immersive reality"]
["K1","How to use own surroundings and research of visual, written and empirical and physical references to inspire and inform animated creations","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(G23:G96 = \"FULLY MET\",1,IF(G23:G96 = \"PARTIALLY MET\",0.5,IF(G23:G96 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(N23=1,1,IF(N23=0.5,0.5,IF(N23=0,0)))","v":0},{"$f":"IF(P23=1,\"NONE\",IF(P23=0.5,\"PARTIAL\",IF(P23=0,\"FULL\")))","v":"FULL"}]
["K2","Know and understand the traditional and digital methods for producing animated sequences such as hand drawn or computer generated animation","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(N24=1,1,IF(N24=0.5,0.5,IF(N24=0,0)))","v":0},"FULL"]
["K3","Understand the brand guidelines or subject matter of the animation to be created","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Understand the history and development of the animation industry and animation genres including, but not limited to, children's, family, adult, experimental, information content","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Know and understand the different animation styles, core techniques and technologies used such as 2D, 3D and Stop Motion","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Understand the dynamics of the animation sector and current and future trends in animation","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Know and understand own responsibility for identifying and reporting risks relating to Health and Safety","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How to work effectively, both individually or as part of a team","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Understand the context within the production of own role, the department they are working in, and the subsequent stages of the workflow process","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Understand the animation production pipeline and how own role interacts with this","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Know and understand the technical and production parameters and client requirements for the project, such as; the schedule, timelines, budget, animation medium, frame count, field size, aspect ratio and format","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Understand the particular operational and technical standards of others departments and the challenges they face","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How good, timely communication can contribute to productive working relationships with clients and customers","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Understand the brand, market position, departments, communication methods, financial processes, culture and ways of working for animation productions you work on","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How live action reference can influence your ability to animate characters/objects/creatures","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Understand character/object/creature development and your role in that development","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The principles of anatomy and how these affect movement","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Understand shot construction and composition","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Understand shot breakdown and continuity","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(N41=1,1,IF(N41=0.5,0.5,IF(N41=0,0)))","v":0},"FULL"]
["K20","How to present ideas and information effectively using story/playboards or story telling","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","How to use language which is clear, avoids jargon and is appropriate to the audience","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Understand the effect your voice tone, pace, volume and body language can have on your audience during presentations","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","How to encourage questions in both oral and written presentations","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Understand the creative style, overall concept and level of animation required for the production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Understand any performance guidelines for the characters they are working on, such as how they may react and behave in different situations","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Understand the logic of physical motion, weight, balance, texture and form","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Understand character movement and lip sync","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Know how to use the relevant graphics, animation and compositing software for an animation production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","How to maintain record systems of drawings and associated information","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Understand the possibilities and constraints offered by the software you are using for the animation production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Understand the importance of maintaining data security and following your organisation's guidelines and file structures for storage","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","The legal and regulatory requirements which apply to animated assets such as copyright and intellectual property rights","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Understand the rendering requirements for the production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Understand the intended appearance and required degree of realism of the finished image you are working on","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","Know and understand the factors affecting render speed, such as size of texture map, ray and reflection depth, global illumination, ambient occlusion, anti-aliasing, blurry reflections or area shadows","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Know and understand rendering techniques, such as: ray tracing, texture mapping to define the colour, texture and reflectance of objects and environments, exposure depth of field to alter the sense of depth or focus on objects and environments, toon rendering and stereo rendering","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","How to use z-buffering techniques to simulate a sense of perspective to describe the distance between objects and environments","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","How creative blurring and transforms give the appearance of live-action","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","Understand the surface properties and how shading models can be applied to represent variations in different materials","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","How to save and duplicate render settings across multiple files","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","Understand the principles of 2D animation","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","How to use interpolated morphing to make animation more fluid","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K43","How rotoscopy is used in 2D animation","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K44","Understand the concepts of key animation and in-between animation","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K45","Understand shot breakdown and continuity","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K46","Recognise and understand the drawing skills that are needed for the animation or artwork being produced","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K47","Understand the traditional and digital methods for producing animated sequences","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K48","Understand how to use industry-standard 2D animation software","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K49","Understand the use of 2D vector graphics and manipulation of images","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K50","Understand why it is important to evaluate progress and seek feedback on your work in animation","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K51","The principles of stop motion animation","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K52","Understand the media and techniques used in stop motion animation","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K53","The materials used and how they are resistant to movement e.g. joints, stability, plasticine preservation","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K54","How to improvise rigging and when it is appropriate for you to do so","NO","YES","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K55","Understand the capabilities and limitations of models","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K56","Understand the importance of lighting, camera angles and frame rates for stop motion","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K57","Understand shot construction, composition, breakdown and continuity of shots","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(N79=1,1,IF(N79=0.5,0.5,IF(N79=0,0)))","v":0},"FULL"]
["K58","Understand the development of the animated character through its movement and timing","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K59","Understand the need to work methodically in an organised and concentrated manner, paying attention to detail","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K60","Understand the principles and techniques of digital animation, such as hi and low resolution modelling, meshing, colouring, matte making, digital sculpting of 3D animation","NO","YES","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K61","Understand the physics of motion and resistance","NO","YES","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K62","Know and understand the techniques, issues, costs and output of motion-capture, and when it is appropriate to use it","NO","YES","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K63","How to use industry-standard 3D animation software","NO","YES","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K64","How to achieve different looks in computer generated assets including shininess, reflectivity, texture, roughness","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K65","Understand the physical properties and mechanics of particle systems, structures, cloths, fluids and crowds and how they react and respond to different stimuli","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K66","How to create renditions of naturalistic physical or magical phenomena such as fire, water, clouds, smoke and physical destruction","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,{"$f":"IF(P88=1,\"NONE\",IF(P88=0.5,\"PARTIAL\",IF(P88=0,\"FULL\")))","v":"FULL"}]
["K67","Understand the requirements and expectations of other team members who will use the animations you create","NO","NO","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K68","Understand relevant standards and conventions relating to user-interface design","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K69","Understand the principles of interaction design, especially regarding usability and accessibility","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K70","When and why an animation might be cut-off prematurely, and how to minimise the risk of this adversely affecting the user’s experience of the product","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K71","Understand the impact on own work of technical parameters such as the processing power, memory, bandwidth, screen size, resolution, colour depth, physical user interface etc. of the target platform(s)","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K72","Which of the events or user interactions will trigger your animations","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K73","Understand how each animation will be used in the product such as whether it will play once, loop several times or indefinitely, etc.)","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K74","Understand the purpose and target users for the animated assets being created","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Determine what is required for their own work as a junior animator by analysing briefs, specifications, visual references, technical and production parameters","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(G98:G175 = \"FULLY MET\",1,IF(G98:G175 = \"PARTIALLY MET\",0.5,IF(G98:G175 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(N98=1,1,IF(N98=0.5,0.5,IF(N98=0,0)))","v":0},"FULL"]
["S2","Research ideas and information for the animation being created","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Read and interpret the relevant sources of information for the production, such as; the script, animatic, x-sheet or dope-sheet, character, colour and model reference and soundtrack","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Continue to update own animation skills, use new tools, software, data and other related technology","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Adapt and be able to meet the requirements of the animation style or genre specified for the production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Use reliable information to keep-up-to date with the laws, regulations, codes of practice, standards and guidelines that govern animation and how they affect your work","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Maintain an awareness of the current priorities, constraints and opportunities of your work as junior animator at all times","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Comply with relevant legislation and organisational policies and procedures such as Health and Safety","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(N105=1,0.5,IF(N105=0.5,0.5,IF(N105=0,0)))","v":0},{"$f":"IF(P105=0.5,\"NONE\",IF(P105=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S9","Work methodically in an organised and concentrated manner, paying particular attention to detail","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(N106=1,1,IF(N106=0.5,0.5,IF(N106=0,0)))","v":0},"FULL"]
["S10","Identify the information you need to carry out your work to expected standards on each animation production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Work effectively both individually and as part of a wider animation team","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Operate within and adhere to agreed organisational policies, standards and procedures","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(N109=1,0.5,IF(N109=0.5,0.5,IF(N109=0,0)))","v":0},{"$f":"IF(P109=0.5,\"NONE\",IF(P109=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S13","Maintain an awareness of the current priorities, constraints and opportunities of the client's budget or production requirements at all times","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(N110=1,1,IF(N110=0.5,0.5,IF(N110=0,0)))","v":0},"FULL"]
["S14","Move characters on set in whatever style is required to meet the creative, narrative and technical demands of the production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Respond to feedback about the animated material you create in a positive way, making refinements as requested by clients or supervisors","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Deliver good customer service in a creative environment","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Develop an animated character/object/creature through its movement and timing","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Contribute ideas to aid the creative development of the character, shot and overall production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Create animations using given camera angles, or make adjustments to camera animations according to the production demands and schedule","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Create the assets that meet the requirements of the animation department","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Plan story/playboards to communicate key ideas with the team or clients","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Create story/playboards that depict the script and narrative","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Present work in progress, or completed animations to colleagues or clients","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Respond carefully to questions, making sure you provide the information the audience is asking for","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Animate primary and secondary characters/objects/creatures and elements","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Interpret the personality and traits of the character/object/creature, conveying the emotions, behaviours and actions within a scene","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Ensure that animations are in sync with the soundtrack","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Create animation in line with production demands, and ensure the output is correct for the next stage of the process","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S29","Select and use the industry standard software package required by the particular animation production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S30","Adapt to the various styles, techniques, procedures and software that may be required by the animation production","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Prepare and store files in line with production requirements, to enable the next stage of animation production to run efficiently","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S32","Undertake test renders at appropriate times to determine the length of time required for rendering and check for errors","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S33","Establish the render settings that gain the required appearance and create sufficient flexibility for compositing","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S34","Apply render settings that enable the required degree of realism","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S35","Prioritise renders in accordance with production priorities","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S36","Calculate render times and storage space required to meet production requirements","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S37","Create a series of key frames to structure the animation that are appropriate to the animation production","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S38","Provide the key frames and check they meet the needs of the production with the director","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S39","Work in line with shot breakdown ensuring continuity","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S40","Create the movement and performance required by the production to in-between the animation, adding frames or cleaning up as required","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S41","Test animated sequences to confirm the effects and continuity meet requirements","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S42","Use the appropriate software for the techniques and procedures required","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S43","Use rotoscoping to produce animated frames","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S44","Create animation according to the production demands","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S45","Review output with relevant people and offer suggestions to assist others with the production","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S46","Respond positively to feedback about the animations you create, making refinements as needed","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S47","Remain constantly flexible and adaptable to new directions, creative requirements and software developments","YES","NO","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S48","Adjust lighting and camera equipment to meet production and aesthetic requirements of specific scenes throughout the production","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S49","Plan and block through shots under direction, where appropriate recording real life videos to try out the performance as a reference","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S50","Create pop through or rehearsal movie and agree with the director an appropriate series of key frames to structure the animation","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S51","Time out each shot that is appropriate to the production and agree these with the director","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S52","Prepare for and re-animate individual shots according to the director’s notes","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S53","Move characters on set in whatever style is required to meet the creative, narrative and technical demands of the production","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S54","Review models with relevant people and offer suggestions that assist others with the animation production","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S55","Test the stop motion animation characters and sequences you have created against the production specifications","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,{"$f":"IF(P152=1,\"NONE\",IF(P152=0.5,\"PARTIAL\",IF(P152=0,\"FULL\")))","v":"FULL"}]
["S56","Review animations created with the relevant people, offering suggestions to assist others with the production","NO","YES","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S57","Respond positively to feedback about the stop motion animations you create, making refinements as needed","NO","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S58","Remain constantly flexible and adaptable to changes in the creative requirements of the production","NO","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S59","Prepare and store assets and files in line with production requirements to enable the next stage of production to run efficiently","NO","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S60","Block animation using stepped or spline techniques, structuring the animation appropriately for the production and in agreement with the director","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S61","Create animation layers that work on top of existing motion capture data and polish captured performances to meet production requirements","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S62","Create the movement and performance required by the production to in-between the animation, adjusting the curves and adding extras keys as appropriate","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S63","Script rigs for animated characters in line with production requirements","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S64","Ensure rigging techniques and references create credible animation with movements that are realistic for the type of object being modelled and the style of animation required","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S65","Ensure that animations maintain continuity of character/performance with other shots in the sequence and/or other animators work","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S66","Create animations using given camera angles or make adjustments to camera animations according to the production demands and schedule","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S67","Test the 3D animations you have created against the production specifications","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S68","Review animations created with the relevant people, offering suggestions to assist others with the production","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S69","Respond positively to feedback about the 3D animations you create, making refinements as needed","NO","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S70","Design animations within specified parameters and constraints relating to the target platform and medium","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S71","Create animations that are attractive, easy to use and fit for purpose","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S72","Save your animations in appropriate formats so that they can be easily incorporated into the product","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S73","Provide clear documentation for others to incorporate your animations into the product","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S74","Organise animations using appropriate filing and naming conventions so that they can be located easily by others","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S75","Liaise with colleagues, such as designers and developers, to ensure your animations are appropriate and meet requirements","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S76","Test the animated assets you have created against the production specifications and to ensure they are easy to use and fit-for-purpose","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S77","Review assets created with the relevant people, offering suggestions to assist others with the production","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(N174=1,1,IF(N174=0.5,0.5,IF(N174=0,0)))","v":0},"FULL"]
["S78","Respond positively to feedback about the assets you create, making refinements as needed","NO","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Self motivation - a self-starter, with a proactive approach to tasks and managing own development","YES","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(G177:G183 = \"FULLY MET\",1,IF(G177:G183 = \"PARTIALLY MET\",0.5,IF(G177:G183 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(N177=1,1,IF(N177=0.5,0.5,IF(N177=0,0)))","v":0},{"$f":"IF(P177=1,\"NONE\",IF(P177=0.5,\"PARTIAL\",IF(P177=0,\"FULL\")))","v":"FULL"}]
["B2","Adaptability- Adapts positively to changing work priorities and patterns, ensuring productions deadlines continue to be met","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Flexibility – A positive approach to working independently and collaboratively as part of a team","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Strong work ethic - motivated, proactive, committed punctual and reliable","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Maintains company and customer confidentiality, acting as an ambassador for their employer","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(N181=1,0.5,IF(N181=0.5,0.5,IF(N181=0,0)))","v":0},{"$f":"IF(P181=0.5,\"NONE\",IF(P181=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B6","Displays a passion for animation and creative media creation","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(N182=1,1,IF(N182=0.5,0.5,IF(N182=0,0)))","v":0},{"$f":"IF(P182=1,\"NONE\",IF(P182=0.5,\"PARTIAL\",IF(P182=0,\"FULL\")))","v":"FULL"}]
["B7","Displays a positive attitude - constructive thinking and motivated to succeed","YES","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Junior animator (Level 4) - 2D Animation    "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(N23:N72,N98:N144,N177:N183)","v":0},"Net Score",{"$f":"SUM(P23:P72,P98:P144,P177:P183)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"N188/P192","v":0},"total CoE KSB coverage",{"$f":"P188/P195","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"P192-P193-(P194*0.5)","v":102.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Junior animator (Level 4) - Stop-Motion Animation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(N23:N62,N72:N85,N98:N133,N145:N156,N177:N183)","v":0},"Net Score",{"$f":"SUM(P23:P62,P72:P85,P98:P133,P145:P156,P177:P183)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"N200/P204","v":0},"total CoE KSB coverage",{"$f":"P200/P207","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"P204-P205-(P206*0.5)","v":107.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Junior animator (Level 4) - 3D Animation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(N23:N62,N72,N76,N82:N89,N98:N133,N155:N166,N177:N183)","v":0},"Net Score",{"$f":"SUM(P23:P62,P72,P76,P82:P89,P98:P133,P155:P166,P177:P183)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"N212/P216","v":0},"total CoE KSB coverage",{"$f":"P212/P219","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"P216-P217-(P218*0.5)","v":103.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Junior animator (Level 4) - Interactive media and immersive reality"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(N23:N62,N72,N89:N96,N98:N133,N153,N155:N156,N167:N175,N177:N183)","v":0},"Net Score",{"$f":"SUM(P23:P62,P72,P89:P96,P98:P133,P153,P155:P156,P167:P175,P177:P183)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"N224/P228","v":0},"total CoE KSB coverage",{"$f":"P224/P231","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"P228-P229-(P230*0.5)","v":102.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KSBs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(N23:N183)","v":0},"Net Score",{"$f":"SUM(P23:P183)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"N236/P240","v":0},"total CoE KSB coverage",{"$f":"P236/P243","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"P240-P241-(P242*0.5)","v":157.5}]

{"sheet":"ST0696","index":4,"n_rows":130,"n_cols":18,"rows_kept":130,"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,"Post production technical operator (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","Understand the purpose of post-production within the end-to-end production process",null,null,null,null,null,null,{"$f":"IF(C22:C59 = \"FULLY MET\",1,IF(C22:C59 = \"PARTIALLY MET\",0.5,IF(C22:C59 = \"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","Understand the commercial context of post-production with the film, TV and advertising industry",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","Understand the importance of agreed workflows and how to adapt these to meet the needs of a production",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Understand the importance of accurate, effective and timely communication with own team, other departments and customers to ensure efficient progress of the work in hand",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Know the relevant health and safety legislation and company policies to ensure a safe working environment for themselves, colleagues and customers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Understand the principles of video signals for film and TV in the digital and analogue domains including: resolution, sampling, colour science, display technologies and emerging and legacy video formats/standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Understand the principles of audio signals in the digital and analogue domains including: Signal path basics, mono, stereo, surround sound, object-based audio, audio levels and loudness",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Understand the use of metadata and other forms of content documentation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Understand the use of timecode and other frame labelling protocols",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Understand why it is business critical to use unambiguous labelling of content, clock numbers and file naming conventions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Understand the importance of agreed workflows and how these may be adapted to meet the bespoke needs of a production",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Know and understand the structure of and appropriate application of, audio and video file formats in common use in production, post-production and delivery",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Know the fomats that are used for still images and graphics held as bitmaps or vector images, and which file formats are used for moving images held as sequential single frame files",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Understand the principles of encoding, transcoding and compression of digital audio and video",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Understand the capabilities of different connection standards for portable storage devices",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Understand the principles of high speed file transfer across Local Area Networks (LAN) and Wider Area Networks (WAN)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Know and understand the protocols for secure, audited receipt and dispatch of content via physical and electronic transfer",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Understand the principles of computer systems, IP networks and shared storage systems as applied in post production",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","How media is managed throughout the data lifecycle including production storage, shared storage, nearline storage and archive, whether on premises or in the cloud",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Understand the bandwidth requirements and disk configurations necessary to ensure reliable playback and record performance at the required resolution for one or more clients from shared storage or directly connected storage",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","Understand the principles of good digital content governance, resilience, RAID (redundant array of inexpensive disks), security, confidentiality",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Understand the value of media content to the business and its customers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Understand the principles of non-linear editing systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Understand the functional role, capabilities and limitations of the equipment used in offline editing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","How to provide operational assistance and first-line support to creative personnel and problem solve within agreed governance constraints",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Understand the principles of non-linear picture and sound finishing systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Understand the functional role, capabilities and limitations of the equipment used in online editing, colour grading and audio dubbing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Understand the technical standards and customer specifications used for UK and international delivery of programmes, films and commercials to cinema, TV broadcast and online distribution platforms",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Understand the requirements of international productions to aid localisation, such as textless backgrounds and audio stems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","Understand the correct environment in which to perform quality control and assessment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Understand the European Broadcasting Union (EBU) classification of quality issues and the International Telecommunications Union (ITU) 5-point quality assessment scale",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","Know and understand the regulations to comply with in regard to flashing images and stimuli causing photo sensitive epilepsy",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","Understand the regulations and specifications for on-screen text and graphics such as: safe areas, minimum text height and minimum durations for legal information in commercials",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","Understand the importance of intelligibility of dialogue and how this is impacted by a complex range of factors, especially age-related hearing loss",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","Know and understand the relevant health and safety legislation and company policies",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","Know and understand legacy video standards such as standard definition PAL and NTSC and their conversion to contemporary standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","Know and understand legacy video and audio tape formats",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","Understand the implications of using legacy formats in contemporary workflows",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Work in line with agreed workflows, adapting to operational changes as they occur",null,null,null,null,null,null,{"$f":"IF(C61:C108 = \"FULLY MET\",1,IF(C61:C108 = \"PARTIALLY MET\",0.5,IF(C61:C108 = \"NOT MET\",0,)))","v":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"}]
["S2","Multitask on simultaneous projects, often for different clients, prioritising the work to ensure that all tasks are completed on schedule",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"}]
["S3","Analyse and interpret the work order and technical specification to complete the scheduled tasks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Use process documentation and work order reporting systems for efficient, accurate and timely communication with other departments about the progress of the work in hand",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"}]
["S5","Work accurately with a high degree of attention to detail",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"}]
["S6","Analyse and advise on the quality of audio, video and data throughout the post production process to colleagues, customers and suppliers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Follow post production processes to ensure the necessary quality is achieved",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Access and interpret the relevant information pertaining to technical specifications and client requirements, and apply to the post production process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Use appropriate technical vocabulary to document and communicate compliance with, or exceptions from, technical standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Assimilate information from multiple sources and apply to task in hand",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Ensure data is transferred securely between client supplied sources and post production storage systems, performing data integrity and virus checks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Ingest and export media content and metadata to/from post-production systems, syncing the audio to video and applying colour transforms (LUTs) as required",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Arrange media content in agreed folder structures, using consistent and unambiguous folder and file naming conventions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Prepare graphics and still images for ingest using software such as Photoshop where basic manipulation is required.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Encode and transcode audio and video data to required specifications",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Export finished content or work-in-progress with metadata from post-production systems to required specifications and naming conventions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Provide technical advice to clients and colleagues on an appropriate file specification for a given requirement",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Dispatch and receive physical assets to/from external organisations and audit the process",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Use file transfer software for fast, secure and audited delivery of assets to external destinations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Communicate work progress to colleagues and clients as appropriate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Manage access by clients to shared storage systems according to company protocols",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"}]
["S22","Ensure data integrity when moving media between storage systems",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},{"$f":"IF(L82=1,\"NONE\",IF(L82=0.5,\"PARTIAL\",IF(L82=0,\"FULL\")))","v":"FULL"}]
["S23","Backup, archive and restore media, sequences and metadata according to company practice",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J83=1,0.5,IF(J83=0.5,0.5,IF(J83=0,0)))","v":0},{"$f":"IF(L83=0.5,\"NONE\",IF(L83=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S24","Safely delete media as instructed and complying with company protocols",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J84=1,0.5,IF(J84=0.5,0.5,IF(J84=0,0)))","v":0},"PARTIAL"]
["S25","Maintain content security measures, both electronic and physical as required by the employer and their clients",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J85=1,0.5,IF(J85=0.5,0.5,IF(J85=0,0)))","v":0},"PARTIAL"]
["S26","Enact business continuity procedures",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J86=1,0.5,IF(J86=0.5,0.5,IF(J86=0,0)))","v":0},"PARTIAL"]
["S27","Prioritise the workload to ensure the scheduled tasks are completed on time, liaising with colleagues and clients",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},{"$f":"IF(L87=1,\"NONE\",IF(L87=0.5,\"PARTIAL\",IF(L87=0,\"FULL\")))","v":"FULL"}]
["S28","Provide frontline operational support to clients in editing suites, to ensure that they can find and work with their media",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S29","Take ownership to resolve and/or escalate faults/incidents to the appropriate person, within agreed governance constraints",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J89=1,0.5,IF(J89=0.5,0.5,IF(J89=0,0)))","v":0},{"$f":"IF(L89=0.5,\"NONE\",IF(L89=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S30","Connect and set-up post production editing equipment using appropriate cables and connectors",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J90=1,1,IF(J90=0.5,0.5,IF(J90=0,0)))","v":0},{"$f":"IF(L90=1,\"NONE\",IF(L90=0.5,\"PARTIAL\",IF(L90=0,\"FULL\")))","v":"FULL"}]
["S31","Perform and check data conforms of sequences prior to colour grading or online editing",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S32","Transfer picture data between grading and editing systems, ensuring the data integrity of content and sequences is maintained",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S33","Relink ingested media to updated sequences as editorial changes occur",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S34","Prepare and transfer audio data to the dubbing suite",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S35","Perform basic editing functions necessary for the preparation of media and sequences for creative processes, or for formatting of finished content for delivery (e.g. adding line-up signals, idents, patching in QC fixes, audio laybacks)",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S36","Analyse and interpret the results of reports from audio and video test equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S37","Consistently assess and identify faults in content, using the correct terminology to accurately describe and record them",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S38","Use own judgement and discretion to decide what is acceptable and what is not in relation to quality control, depending on the context of the material, its intended use and the required technical specifications and customer requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S39","Deliver accurate and concise Quality Assessment Reports with clear indications of mandatory failures, advisory warnings and client approved exceptions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S40","Provide technical advice on remedial action to correct faults identified",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S41","Communicate findings to both clients and colleagues accurately, and in a diplomatic manner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S42","Comply with company Health and Safety policies and practices, identifying, mitigating and reporting any incidents or risk to the appropriate person",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S43","Consistently work in a safe manner for self, colleagues and clients.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S44","Use appropriate legacy media physical handling procedures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S45","Carry out basic operation of videotape recorders and audio recorders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S46","Digitise tape content into editing systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S47","Playout finished content from editing systems to tape",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S48","Provide technical advice to clients and colleagues on the implications of using legacy format in contemporary workflows",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Displays a strong work ethic and commitment to meet the standards required - upholding ethical and professional standards",null,null,null,null,null,null,{"$f":"IF(C110:C120 = \"FULLY MET\",1,IF(C110:C120 = \"PARTIALLY MET\",0.5,IF(C110:C120 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J110=1,1,IF(J110=0.5,0.5,IF(J110=0,0)))","v":0},{"$f":"IF(L110=1,\"NONE\",IF(L110=0.5,\"PARTIAL\",IF(L110=0,\"FULL\")))","v":"FULL"}]
["B2","Demonstrates a passion for post production, the media industry and its productions - proactively keeping up to date with latest developments within the industry",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Maintains company and customer confidentiality, acting as an ambassador for their employer",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J112=1,0.5,IF(J112=0.5,0.5,IF(J112=0,0)))","v":0},{"$f":"IF(L112=0.5,\"NONE\",IF(L112=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B4","Acts in a manner that supports the commercial customer relationship acting as an ambassador for their employer",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J113=1,0.5,IF(J113=0.5,0.5,IF(J113=0,0)))","v":0},"PARTIAL"]
["B5","Demonstrates attention to detail and not willingly accepting second best; whilst at the same time being pragmatic about balancing client expectations against the available time and budget",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J114=1,1,IF(J114=0.5,0.5,IF(J114=0,0)))","v":0},{"$f":"IF(L114=1,\"NONE\",IF(L114=0.5,\"PARTIAL\",IF(L114=0,\"FULL\")))","v":"FULL"}]
["B6","Proactively keeping up to date with latest developments within the industry",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Thinks creatively and logically to solve technical issues - contribute to a process of continual improvement of workflow and technique",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Delivers good customer service in a creative environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Balances the quality threshold which it is practical to achieve within time and budget constraints, and the customer expectations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B10","Works with a high level of sustained concentration and attention to detail",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B11","Works safely to ensure a safe working environment for themselves, colleagues and customers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J120)","v":0},"Net Score",{"$f":"SUM(L22:L120)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J123/L127","v":0},"total CoE KSB coverage",{"$f":"L123/L130","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",97]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",10]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L127-L128-(L129*0.5)","v":92}]

{"sheet":"ST0749","index":5,"n_rows":70,"n_cols":18,"rows_kept":70,"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,"Historic environment advice assistant (level 4) "]
[null,"Return to Guide"]
["KSB","KSB Statement ","KSB coverage\n\nSelect the coverage provided by the qualification from the dropdown box","Where in the qualification is the relevant content?\n\nPlease reference precisely where the content you are citing as evidence is within the submitted documents - Document name/Module name/Specific page number ","Evidence\n\nQuote or copy & paste the relevant content from your referenced qualification documents. Please provide 1 - 3 references that best evidence the KSB and only refer to content that all students will cover regardless of option choice. The information you supply in this column, in conjunction with the Supporting Comments / Rationale column (Column F) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column E does not clearly and explicitly provide the declared level of coverage or might not be obvious to someone who is not an expert in your qualification, use this space to explain how the level of KSB coverage is achieved by the qualification content - please be specific to the wording and meaning of the KSB statement. Where a KSB is not fully met, please provide the rationale for why you feel this is not achievable.","Assessment method\n\nProvide information on the method(s) used to assess this KSB and relevant assessment materials.",null,"AB Score","IM Score","Mitigations ","CoE Score","Outstanding Requirement","IM Comment","IM moderation","G7 QA","IM G7 Response","Conclusion"]
[null,"Knowledge"]
["K1","How to respond to client or public requests and organisational requirements e.g. requests for advice from owners of Listing Buildings, or requests for record information about Listed Buildings from colleagues",null,null,null,null,null,null,{"$f":"IF(C22:C35 = \"FULLY MET\",1,IF(C22:C35 = \"PARTIALLY MET\",0.5,IF(C22:C35 = \"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","Knowledge of stakeholder communication methods and strategies and how to maintain honest and constructive relationships.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The requirements for projects, including timescales, deadlines, cost implications, and identifying milestones/targets.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Heritage policies, frameworks, strategies, and best practice Standards for historic building conservation and archaeological work e.g. National Planning Policy Framework (NPPF), Historic England: Conservation Principles, Policies and Guidance for the sustainable management of the Historic Environment, DCMS: Principles of selection for listing buildings",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Where and how to find the relevant statutory legislation and other guidance concerning change in the historic environment, e.g. Planning (Listed Buildings and Conservation Areas) Act 1990, Ancient Monuments and Archaeological Areas Act 1979, National Planning Policy Framework, Protection of Wrecks Act 1973, Town and Country Planning (Environmental Impact Assessment) Regulations 2017, Ecclesiastical Exemption Order 2010",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The Historic Environment conservation principles (BS7913) and other published criteria for assessment and design",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The fundamentals of archaeological, landscape or architectural history and building practice and chronology, including a broad understanding and recognition of archaeological site or building types, styles, technologies, materials and periods",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The wider context of the historic environment, and the roles and responsibilities of statutory authorities, heritage organisations of all types and specialists, e.g. public, private and third sector organisations, subject specialist networks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Documentation used in the identification, management, design or recording of the Historic Environment, e.g. assessments of significance, Local Development Plans, listing and designation statements, desk-based assessments, Historic Environment Records.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Compliance processes for the historic environment, including heritage at risk and enforcement.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J31=1,1,IF(J31=0.5,0.5,IF(J31=0,0)))","v":0},"FULL"]
["K11","Their employer’s health and safety policy and procedures and operational procedures and how those relate to industry standards, and the fundamentals of relevant Health and Safety legislation and construction site Health & Safety. How to recognise and report risks.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Their role in the context of the project which they are working, what is required of them, and the implications of the project on the wider context of the historic environment. The limits of their own understanding, abilities and responsibilities, and how to practice within them. The ethical requirements of the relevant professional body.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Knowledge of learning and self-development opportunities within the sector and how to develop a personal action plan",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How to identify archaeological sites or building types, styles, technologies, materials and periods in practice.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Work as part of a team and communicate effectively with colleagues, clients and stakeholders",null,null,null,null,null,null,{"$f":"IF(C37:C52 = \"FULLY MET\",1,IF(C37:C52 = \"PARTIALLY MET\",0.5,IF(C37:C52 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J37=1,1,IF(J37=0.5,0.5,IF(J37=0,0)))","v":0},"FULL"]
["S2","Coordinate and administer casework and projects, manage projects for clients or organisations including using systems and processes specific to the historic environment sector",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Demonstrate time management skills, prioritise workload, work under pressure and be able to meet critical deadlines",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Write reports, specifications and briefs for projects that are complex and non-routine but well defined, e.g. Written Schemes of Investigation, Conservation Management Plans, listing and designation advice, desk-based assessments",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Interpret technical information and documents on the historic environment, e.g architectural plans, design and access statements, listed building consent orders",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Link, contextualise and apply legislation, policy, standards and guidance to projects, e.g. Planning (Listed Buildings and Conservation Areas) Act 1990, Ancient Monuments and Archaeological Areas Act 1979, National Planning Policy Framework, Protection of Wrecks Act 1973, Town and Country Planning (Environmental Impact Assessment) Regulations 2017, Ecclesiastical Exemption Order 2010",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Assess and describe the condition of the historic environment, e.g conducting evaluation visits, desk-based assessment, assessments of significance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Problem solve and evaluate proposals for change and gauge appropriateness of proposed actions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Apply relevant historic environment sector standards to check and review work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Identify, compile and process data on the historic environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Review and maintain records on the historic environment in accordance with relevant standards",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Exercise appropriate judgement and decision making, escalating to/involving others when dealing with complex queries or sensitive cases",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Recognise the potential for work in the historic environment to deliver public benefit, identify opportunities for research and to deliver new knowledge for society",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Be responsible for mapping and working to data standards, carrying out information reviews or technical investigation on the historic environment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Work in a variety of outdoor and indoor site types safely, recognise and report risks in order to reduce the risk of incidents",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Identify and use of range of methods and techniques to identify archaeological sites or building types, styles, technologies, materials and periods in practice",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Take reasonable care for the health and safety of themselves and of others who may be affected by their acts or omissions at work",null,null,null,null,null,null,{"$f":"IF(C54:C60 = \"FULLY MET\",1,IF(C54:C60 = \"PARTIALLY MET\",0.5,IF(C54:C60 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},"FULL"]
["B2","Focus and pay attention to detail",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Ability to problem-solve and negotiate",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Commit to quality and their continuous professional development",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J57=1,0.5,IF(J57=0.5,0.5,IF(J57=0,0)))","v":0},{"$f":"IF(L57=0.5,\"NONE\",IF(L57=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Work effectively individually and as part of a team",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J58=1,1,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},"FULL"]
["B6","Be approachable and able to communicate with all levels of their own and other organisations, as well as the general public, in workplace settings, as well as during site visits and stakeholder meetings",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"}]
["B7","Be sensitive to and aware of the significance of the historic environment, and the needs of its stakeholders, being conscious of integrity, honesty and professional ethical requirements",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J60=1,1,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J60)","v":0},"Net Score",{"$f":"SUM(L22:L60)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J63/L67","v":0},"total CoE KSB coverage",{"$f":"L63/L70","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",37]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",2]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L67-L68-(L69*0.5)","v":36}]

{"sheet":"ST0912","index":6,"n_rows":76,"n_cols":18,"rows_kept":76,"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,"Stained glass craftsperson (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","Basic health and safety requirements associated within the workshop and on-site, including COSHH legislation, risk assessment method statements, working at height, use of tools, materials and associated processes.",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","The hazards associated with different materials and sustainable waste disposal processes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The importance and requirements of clear communication to staff team, clients and external colleagues.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The context of each project through research and consider this in your working process. E.g. monetary, historical or cultural value.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The developments of artistic styles, processes and materials as well as the wider architectural and historic context of stained glass within a particular building/setting.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Appropriate research for each project and how to utilise a range of relevant and credible sources.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","The information required to be collected during site visits to enable project work to progress e.g. measurements required and how to use templates.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The requirements for developing designs and which methods should be used to inform the designs e.g. knowing when to use a rubbing or a cut-line drawing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","How to dismantle and assemble glass panels to ensure glass can be removed or replaced without damage.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The importance of accurate documentation e.g. recording of positioning, damage and previous repairs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Materials commonly used in architectural glass windows including different types of glass e.g. flash glass, hand blown and machine-made glass.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","How to safely and correctly cut specialist glass using appropriate hand tools e.g. correct hand positioning when using glass cutter.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Different storage and handling considerations for fragile/large/heavy glass panels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","How to select and handle appropriate materials for fabrication. E.g. Lead types.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How to cut and shape materials when fabricating. E.g. Lead or other materials.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How to construct a large-scale architectural glass panel to maximize stability. E.g. lead matrix.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Joining or soldering processes specific to fabrication. E.g. Stained glass fabrication or bonding techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The importance of correct waterproofing procedures and selection of materials. E.g. cementing or sealants.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The importance of building and environmental regulations and security requirements for a window within an architectural context.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Apply health and safety precautions associated within the workshop and on-site, including COSHH, safe handling and useage of tools, materials and associated processes, use of PPE, adhering to risk assessment method statements and complying with working at height legislation.",null,null,null,null,null,null,{"$f":"IF(C42:C56 = \"FULLY MET\",1,IF(C42:C56 = \"PARTIALLY MET\",0.5,IF(C42:C56 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J42=1,1,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=1,\"NONE\",IF(L42=0.5,\"PARTIAL\",IF(L42=0,\"FULL\")))","v":"FULL"}]
["S2","Clearly communicate information to staff colleagues and external clients/stakeholders.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Collecting, documenting and applying appropriate research for each project and utilising a range of relevant and credible sources including photography, sketches and note-taking.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Accurately measure widths, heights, bar positions, lead profiles, etc. of openings e.g. using tape measures and fabricating templates of openings.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Preparing accurate drawings and cartoons using measurements and templates taken on-site.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Create rubbings using paper and wax method to faithfully reproduce original designs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Accurately and appropriately document existing condition of panel through photography, drawing and note-taking.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Safely and systematically dismantle or assemble glass panels using the appropriate tools to ensure glass can be removed or re-assembled without damage.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Safely and correctly cut specialist glass using appropriate hand tools e.g. glass cutter, using appropriate positioning for both hand and type of glass.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Ensure correct storage and safe handling is used for fragile/ large/heavy glass panels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Undertake construction processes appropriate to project including preparation and cleaning. E.g. using a soldering iron for stained-glass or bonding glass elements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Application of correct waterproofing procedures, selecting correct materials. E.g. cementing or sealing.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Select and handle correct specialist materials appropriate to the task e.g. flat leads, convex leads.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Safely cut and shape specialist materials using appropriate tools. E.g. lead or glass",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Construct using appropriate methods depending on fabricating technique. E.g. lead matrices to maximize stability which ensures longevity.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Awareness and proactive approach towards the legal health and safety obligations required in the workplace, both individually and towards others.",null,null,null,null,null,null,{"$f":"IF(C58:C66 = \"FULLY MET\",1,IF(C58:C66 = \"PARTIALLY MET\",0.5,IF(C58:C66 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J58=1,1,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=1,\"NONE\",IF(L58=0.5,\"PARTIAL\",IF(L58=0,\"FULL\")))","v":"FULL"}]
["B2","Awareness of effective communication and teamwork within studio and external stakeholder engagements including appreciation of allied trades and how they all contribute to the project.",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"}]
["B3","A methodical and organised approach to collecting, clearly presenting and applying research.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J60=1,1,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=1,\"NONE\",IF(L60=0.5,\"PARTIAL\",IF(L60=0,\"FULL\")))","v":"FULL"}]
["B4","Maintaining accuracy and an eye for detail when conducting all work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Consistently selecting most appropriate methods and ways of working for each project.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Maintaining systematic an organised approach to tasks.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Respect and care of tools and equipment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Care and appreciation of the artefact being worked on e.g. sentimental, historic and monetary value.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B9","Appreciate own knowledge and skill levels and recognise when the situation may be beyond own capabilities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J66)","v":0},"Net Score",{"$f":"SUM(L22:L66)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J69/L73","v":0},"total CoE KSB coverage",{"$f":"L69/L76","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",43]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",1]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L73-L74-(L75*0.5)","v":42.5}]

{"sheet":"ST0933","index":7,"n_rows":87,"n_cols":18,"rows_kept":87,"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,"Post production engineer (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","How SMPTE (Society of Motion Picture Television Engineers) standards impact on the work of post-production organisations",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","The common industry standards for computer networks that impact on post production systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","How to identify the operational state of systems and equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","K4: How to identify when issues are technology related and when they may require user training",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The key software and operating systems used by the organisation e.g. SALT, ANSIBLE, PUPPET",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Understanding of the overall facility infrastructure including cabling, servers, studios",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","How key post-production software applications are used within the organisation to balance sound, colour, visual effects and transition between sections.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The common faults that can arise with Post Production systems and software",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","The solutions that can be applied to common system and software faults",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The creative workflow used within the organisation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How to recognise the organisational priorities and how they impact on the planning of work activities in the immediate, short and long term",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Hardware set up including location of gear, cabling, video routers and relevant labelling",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","Basic TCP (Transmission Control Protocol) used to allow computers to communicate on a network such as the internet",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Where and when internal and external general and specialist expertise can be sought",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How problem-solving techniques (such as root cause analysis) can be applied to resolve routine and bespoke problems and how triage methods can be used to prioritise activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How to manage the expectations of internal and external customers",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How configuration of new equipment is managed",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The processes in place for data and physical security and its critical importance to the organisation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Environmental and Health and Safety policies and procedures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Engage with clients to determine system requirements and establish hardware and software needs",null,null,null,null,null,null,{"$f":"IF(C42:C68 = \"FULLY MET\",1,IF(C42:C68 = \"PARTIALLY MET\",0.5,IF(C42:C68 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J42=1,1,IF(J42=0.5,0.5,IF(J42=0,0)))","v":0},{"$f":"IF(L42=1,\"NONE\",IF(L42=0.5,\"PARTIAL\",IF(L42=0,\"FULL\")))","v":"FULL"}]
["S2","Determine the scope of the task and agrees the specification",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Set up new hardware and software systems to specification and to meet security requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Apply and follow defined procedures for maintenance and set up activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Monitor and adjust calibration of equipment using SMPTE standards as a benchmark",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Identify correct operational state of equipment and the operational status of applications",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Select and use appropriate test equipment and software",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Monitor and identify when applications and equipment are not working correctly",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Operate and use IT hardware and auxiliary equipment effectively",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Implement regular analysis to establish the on-going performance of systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Gather and interpret information to identify the root cause of technical problems and apply a triage process in identifying faults",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Apply diagnostic processes to identify and assess the scale of bespoke hardware and software problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Evaluate possible solutions taking into account cost, time and priority",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Reproduce and document fault conditions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Utilise helpdesk systems to track backlog and maintain customer service",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Implement checks to review and evaluate the effectiveness of solutions",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Log the progress of work and key actions on organisational systems",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J58=1,0.5,IF(J58=0.5,0.5,IF(J58=0,0)))","v":0},{"$f":"IF(L58=0.5,\"NONE\",IF(L58=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S18","Schedule and implement work to take account of workflow to minimise negative impact",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J59=1,1,IF(J59=0.5,0.5,IF(J59=0,0)))","v":0},{"$f":"IF(L59=1,\"NONE\",IF(L59=0.5,\"PARTIAL\",IF(L59=0,\"FULL\")))","v":"FULL"}]
["S19","Implement creative workarounds until a permanent solution can be put in place",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Brief other specialists to assist with the resolution of problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Respond effectively in pressurised periods of work",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Take ownership of the work environment and identified problems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Able to assess user state, user goals and user difficulties",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Manage creative issues and establish trust with colleagues in order to minimise conflict",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Describe complex problems in a simple and clear way to users and colleagues",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Support junior staff by providing guidance on how to resolve system problems, checking the quality of their work and providing constructive feedback",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J67=1,0.5,IF(J67=0.5,0.5,IF(J67=0,0)))","v":0},{"$f":"IF(L67=0.5,\"NONE\",IF(L67=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S27","Complies with Environmental and Health and Safety polices and procedures.",null,null,null,null,null,null,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"}]
[null,"Behaviours"]
["B1","Champions the importance of adherence to the organisation’s Environmental, Health and Safety management systems:- actively displays and promotes a safety first culture within the organisation",null,null,null,null,null,null,{"$f":"IF(C70:C77 = \"FULLY MET\",1,IF(C70:C77 = \"PARTIALLY MET\",0.5,IF(C70:C77 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=0.5,\"NONE\",IF(L70=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Operates in a systematic, proactive and transparent way",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J71=1,1,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=1,\"NONE\",IF(L71=0.5,\"PARTIAL\",IF(L71=0,\"FULL\")))","v":"FULL"}]
["B3","Actively promotes the case for the adoption of emerging and advanced technologies to optimise performance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Takes full responsibility for own professional development, seeking opportunities to enhance knowledge, skills and experience. Keeps abreast of developments in emerging technologies",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J73=1,0.5,IF(J73=0.5,0.5,IF(J73=0,0)))","v":0},{"$f":"IF(L73=0.5,\"NONE\",IF(L73=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B5","Accepts responsibility for their workload with a responsible approach to risk",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J74=1,1,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=1,\"NONE\",IF(L74=0.5,\"PARTIAL\",IF(L74=0,\"FULL\")))","v":"FULL"}]
["B6","Demonstrates a high level of motivation and resilience when facing challenging situations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Creates and maintains positive, professional, trusting and ethical working relationships with their team and the wider range of internal, external and connected stakeholders",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J76=1,0.5,IF(J76=0.5,0.5,IF(J76=0,0)))","v":0},{"$f":"IF(L76=0.5,\"NONE\",IF(L76=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B8","Acts professionally when engaging with colleagues and clients",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"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J77)","v":0},"Net Score",{"$f":"SUM(L22:L77)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J80/L84","v":0},"total CoE KSB coverage",{"$f":"L80/L87","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",54]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",5]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L84-L85-(L86*0.5)","v":51.5}]

{"sheet":"ST0940","index":8,"n_rows":102,"n_cols":18,"rows_kept":102,"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,"Audiovisual technician (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","Connection of audio system components, signal flow and conversion",null,null,null,null,null,null,{"$f":"IF(C22:C52 = \"FULLY MET\",1,IF(C22:C52 = \"PARTIALLY MET\",0.5,IF(C22:C52 = \"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","Methods of configuring and testing wireless microphones and what are common issues and adequate problem solving techniques",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The impact of microphone placement and room acoustics on an audio signal",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Audio mixing desk routing and operation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Digital Audio Workstation fundamental operations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Unmanaged audio mixing scenarios",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","Lighting design and fixtures/controller connections",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Synchronisation of video signals for multi-camera setups",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Principals of photography for moving image",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Appropriate audiovisual equipment and/or applications for a given brief",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Project management principles: planning, change, budgets, and documentation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Integrated audiovisual solutions for specific requirements",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How to use CAD drawings when designing systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","AV over IP concepts and operation: servers, digital signage, channel distribution, and access",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Awareness of the strengths, weaknesses, and limitations of videoconferencing systems and platforms",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Videoconferencing booking systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Redundancy and backup systems relevant to the project",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Hardware/software configurations for streaming online audiovisual content",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Installation/configuration of personal computers and common computer operating systems general functionality",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Project mastering",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","Designation of video resolutions, frame rates, and output options",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Video compression and decompression through codec and bitrate workflows",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","Required workflows for online and offline edits utilising a media server",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Designation of sampling rate, bit depth, and channel options",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Audio deliverables within the context of a specific project",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","Different types of online events, their requirements and key considerations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Interactive solutions for online events",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","Audiovisual accessibility considerations and systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","Personal data management in accordance with relevant data protection legislation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","National, employer, and context specific health and safety regulations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","Potential hazards and preventative measures",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Operate a video camera and vision mixer",null,null,null,null,null,null,{"$f":"IF(C54:C81 = \"FULLY MET\",1,IF(C54:C81 = \"PARTIALLY MET\",0.5,IF(C54:C81 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J54=1,1,IF(J54=0.5,0.5,IF(J54=0,0)))","v":0},{"$f":"IF(L54=1,\"NONE\",IF(L54=0.5,\"PARTIAL\",IF(L54=0,\"FULL\")))","v":"FULL"}]
["S2","Integrate a projector and/or display as part of an audiovisual presentation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Audio mixing; loudness, timbre, spatialisation, and channel management",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Apply and problem solve video signal flow for live production",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Operate and program lighting control software/hardware",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Root cause analysis & problem solving",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Collate, compare, and synthesise information from various sources",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Work collaboratively; Building and maintaining positive relationships with stakeholders (such as performers, public speakers, presenters, clients and event organisers)",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"}]
["S9","Communicate technical concepts with clarity in person and in writing to end users of all skill levels and seniority",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"}]
["S10","Install, test, and commission relevant hardware",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Configure and manage remote participation systems",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Edit audio and video content",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Prepare, maintain, and manipulate audio and video assets through post-production",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Create digital assets for video workflows",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Manual camera operating for a range of contemporary S35mm digital cameras",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Audio capture",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Deliver virtual event technical operations",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Clearly advise and guide event participants",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Devise a learning program intended to cover a particular device/system",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Identify personal training and professional development needs via research and investigation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Organise appropriate personal professional development activities to develop and enhance own role and skills",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Use collaborative online environments to schedule and update projects and tasks",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Complete risk assessment documentation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Accurately assesses level of risk to health and safety of themselves and others",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Test and maintain audiovisual equipment, cables, and connectors: substitute items where necessary",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Document and record maintenance activities",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Safe storage of equipment",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Create a coherent planning document",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Think and act independently and safely whilst working within company guidelines",null,null,null,null,null,null,{"$f":"IF(C83:C92 = \"FULLY MET\",1,IF(C83:C92 = \"PARTIALLY MET\",0.5,IF(C83:C92 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J83=1,0.5,IF(J83=0.5,0.5,IF(J83=0,0)))","v":0},{"$f":"IF(L83=0.5,\"NONE\",IF(L83=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Work calmly and methodically in time-sensitive situations",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J84=1,1,IF(J84=0.5,0.5,IF(J84=0,0)))","v":0},{"$f":"IF(L84=1,\"NONE\",IF(L84=0.5,\"PARTIAL\",IF(L84=0,\"FULL\")))","v":"FULL"}]
["B3","Reference user manuals and manufacturer guidance",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Awareness of the importance of regular contact, when appropriate, to offer updated information and documentation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Able to modify personal approach based on the situation",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B6","Challenges approaches to work in a constructive manner",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B7","Confident & effective communicator",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B8","Online researcher of new equipment and training opportunities, communicate with professionals and organisations to prioritise personal training goals and activities",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J90=1,0.5,IF(J90=0.5,0.5,IF(J90=0,0)))","v":0},{"$f":"IF(L90=0.5,\"NONE\",IF(L90=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B9","Well prepared, anticipates issues ahead of time",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J91=1,1,IF(J91=0.5,0.5,IF(J91=0,0)))","v":0},{"$f":"IF(L91=1,\"NONE\",IF(L91=0.5,\"PARTIAL\",IF(L91=0,\"FULL\")))","v":"FULL"}]
["B10","Take initiative e.g. seek the source of an issue of own accord and take necessary action",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J92)","v":0},"Net Score",{"$f":"SUM(L22:L92)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J95/L99","v":0},"total CoE KSB coverage",{"$f":"L95/L102","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",69]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L99-L100-(L101*0.5)","v":67.5}]

{"sheet":"ST0944","index":9,"n_rows":81,"n_cols":18,"rows_kept":81,"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 recording technician (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","Audio equipment set up requirements to meet differing recording specifications and its final application.",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","How to use software to edit and mix sound.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","How to regulate volume levels and the impact on sound quality.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","How to minimise unwanted sounds.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Audio dynamics of the studio and how this impacts on the quality of the recording.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","What different items of audio equipment are for, their functions and ideal uses, and in what situations they should be deployed. Different types of microphones and the situations in which they could be used to best effect.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","How to set up inputs and outputs on the mixing console and its impact on the final sound. To include pre-amp, EQ, pan/mute and fader.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How to mix input sound signals and send them to the outputs (aux sends, subgroups and main mix).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Procedures to identify and diagnose problems with audio equipment and common solutions for their resolution.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","When to refer issues with equipment to a technician for repair/maintenance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","Boundaries of responsibility in regard to recording sessions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","How the set-up of the studio is impacted by the type of music/sound being recorded and its final application.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How to identify studio equipment and integrate with client's own equipment. The set up and operation of recording software and hardware protocols.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Inputs and outputs assignment and how to set these up on equipment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","The protocols for labelling and documenting channels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Back up procedures for digital sound files and sound library requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","How the security of sound files and physical assets on site can be protected.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","How credits are assigned and the implications this has upon the recording.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","How to collaborate with producers and performers.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How the requirements of different media can vary according to where the sound recording will be used (e.g. tv/film, computer games).",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","The Health and Safety at Work Act 1974. Assessing the risks and potential health and safety issues that apply, particularly in relation to ear protection and electrical safety.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The Control of Noise at Work Regulations 2005 (CNWR), and the relevant guidance for the music and entertainment sector.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The importance of meeting deadlines during sessions that use several external paid musicians. The need to maintain the momentum of the recording session to minimise costs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Establish editor, producer and client requirements. Determines hardware and software needed to achieve the sound specification.",null,null,null,null,null,null,{"$f":"IF(C46:C63 = \"FULLY MET\",1,IF(C46:C63 = \"PARTIALLY MET\",0.5,IF(C46:C63 = \"NOT MET\",0,)))","v":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"}]
["S2","Sets up the studio and equipment to meet sound brief. Takes into account acoustics to produce the best quality outputs tailored to the purpose. Positions microphones, sets up amps and sound levels.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Reviews the effectiveness of the setup and adjusts equipment to achieve the required specification and quality.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Evaluates information and makes recommendations, for different sound requirements. Supports stakeholders preparing for and during the live recording and maintains client relationships.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J49=1,0.5,IF(J49=0.5,0.5,IF(J49=0,0)))","v":0},{"$f":"IF(L49=0.5,\"NONE\",IF(L49=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S5","Sets up and assists with the operation of the mixing console. Balances and adjust sound sources using equalization and audio effects, mixing, reproduction, and reinforcement of sound.",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","Plans work in a methodical way to ensure the efficiency of the recording session and takes into account competing priorities.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Balance the differing needs required by clients and the priorities of the organisation/ studio.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Manage the security and format of different types of sound files.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Uses problem solving techniques to diagnose equipment faults/issues. Escalates faults/issues when they are outside the levels of their own responsibility.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Implements solutions to address equipment faults in a live environment to ensure the continuing running of the recording session. Considers cost and artist requirements when implementing the solution.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Produce records related to the set-up of the studio and particular equipment for future reference/ continuous improvement and to ensure repeatability.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Log when credits may be due to self or other individuals involved with the recording.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Synchronises audio with other mediums/ productions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Restore work area and store equipment maintaining equipment integrity and to ensure the condition of the equipment is not compromised",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Monitor the maintenance requirements of electrical equipment in line with company procedures. Consider the frequency of checks required, the inspection requirements and testing needed.",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"}]
["S16","Complies with statutory and organisational health & safety regulations and policies.",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},"PARTIAL"]
["S17","Supports stakeholders preparing for and during the live recording and maintains client relationships.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J62=1,0.5,IF(J62=0.5,0.5,IF(J62=0,0)))","v":0},"PARTIAL"]
["S18","Follow protocol to correctly label file names and archive the different mixes and multitrack recordings for easy retrieval.",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},{"$f":"IF(L63=1,\"NONE\",IF(L63=0.5,\"PARTIAL\",IF(L63=0,\"FULL\")))","v":"FULL"}]
[null,"Behaviours"]
["B1","Champions the importance of adherence to the organisation’s Environmental, Health and Safety management systems. Actively displays and promotes a safety first culture within the organisation.",null,null,null,null,null,null,{"$f":"IF(C65:C71 = \"FULLY MET\",1,IF(C65:C71 = \"PARTIALLY MET\",0.5,IF(C65:C71 = \"NOT MET\",0,)))","v":0},null,"PARTIAL",{"$f":"IF(J65=1,0.5,IF(J65=0.5,0.5,IF(J65=0,0)))","v":0},{"$f":"IF(L65=0.5,\"NONE\",IF(L65=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B2","Operates in a systematic, proactive and transparent way.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J66=1,1,IF(J66=0.5,0.5,IF(J66=0,0)))","v":0},{"$f":"IF(L66=1,\"NONE\",IF(L66=0.5,\"PARTIAL\",IF(L66=0,\"FULL\")))","v":"FULL"}]
["B3","Keeps abreast of developments in emerging technologies and actively promotes the use of new technologies to optimise performance.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Takes full responsibility for own professional development, seeking opportunities to enhance knowledge, skills and experience.",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","Accepts responsibility for their workload with a responsible approach to risk. Demonstrates a high level of motivation and resilience when facing challenge.",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","Sensitive to the needs of artists. Creates and maintains positive, professional, trusting and ethical working relationships with their team and the wider range of internal, external and connected stakeholders.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J70=1,0.5,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=0.5,\"NONE\",IF(L70=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B7","Acts professionally with a positive and respectful attitude.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J71=1,1,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=1,\"NONE\",IF(L71=0.5,\"PARTIAL\",IF(L71=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J71)","v":0},"Net Score",{"$f":"SUM(L22:L71)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J74/L78","v":0},"total CoE KSB coverage",{"$f":"L74/L81","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",48]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",7]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L78-L79-(L80*0.5)","v":44.5}]

{"sheet":"ST1324","index":10,"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,"Journalist (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","Own role within the business, the brand's business model and target audience, both in terms of demographic and sociographic profile; and understand audiences’ needs from the media.",null,null,null,null,null,null,{"$f":"IF(C22:C42 = \"FULLY MET\",1,IF(C22:C42 = \"PARTIALLY MET\",0.5,IF(C22:C42 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J22=1,1,IF(J22=0.5,0.5,IF(J22=0,0)))","v":0},{"$f":"IF(L22=1,\"NONE\",IF(L22=0.5,\"PARTIAL\",IF(L22=0,\"FULL\")))","v":"FULL"}]
["K2","The relevant legislation affecting journalists: defamation; contempt of court; reporting restrictions; privacy, copyright, confidential sources.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The relevant regulations and more general ethical issues and how they can affect a journalist’s work including; the codes of conduct/practice and relevant regulatory bodies to comply with such as the Independent Press Standards Organisation (IPSO), the Ofcom Broadcasting Code, BBC editorial guidelines and employer guidelines.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","How to identify, find and establish physical and on-line contacts/sources to inform and contribute to content.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","How to use audience analytics to inform content selection and story telling.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The techniques for planning and structuring content narratives, including working to a brief, which adopt the brand’s tone and follow brand rules and conventions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","How to generate original and exclusive content, and the contexts within which the content can be used.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","How to identify and use techniques to extract data which will support content creation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Interviewing techniques, strategies and lines of questioning to extract the maximum, relevant information from interviewees whether face-to-face, by telephone or electronic means in many settings, including press conferences, formal one-to-one interviews, on-the-doorstep and in the street.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","How and when to obtain specialist subject knowledge selecting appropriate research techniques to ensure accuracy.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The theoretical and practical uses of social media platforms, the issues/risks of these and how this aligns with the employer’s target audience and protocols.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The technical requirements and use of multi-platform digital/social journalism recording equipment, editing and publishing applications/programs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How to shoot and edit video and audio to meet standards for publication on different platforms.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Own employer’s recording and editing protocols and programs; how to proof read content and edit as required.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How to maintain professional ethics and practices and keep abreast of new developments within the media industry.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How clear, timely communication contributes to productive working relationships.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","The value of brands, how they are developed and enhanced and how they can be damaged.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The requirements of health and safety legislation in day-to-day work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Own workplace terminology, equipment and programs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Procedures for dealing with complaints.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","How to integrate equality, diversity and inclusion in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Undertake research before reporting to ensure that journalistic content/material published or broadcast is accurate, impartial, balanced, engages the audience and is verifiable with industry standard use of English.",null,null,null,null,null,null,{"$f":"IF(C44:C62 = \"FULLY MET\",1,IF(C44:C62 = \"PARTIALLY MET\",0.5,IF(C44:C62 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J44=1,1,IF(J44=0.5,0.5,IF(J44=0,0)))","v":0},{"$f":"IF(L44=1,\"NONE\",IF(L44=0.5,\"PARTIAL\",IF(L44=0,\"FULL\")))","v":"FULL"}]
["S2","Identify, select, and verify multiple sources of information, including people, reports, data and social media, cross-checking and corroborating when necessary.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S3","Take accurate, relevant notes when and where needed, use shorthand where required by your employer.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Assess the strengths/weaknesses of available platforms and where and when journalistic content is likely to work best.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Assess and produce journalistic content in accordance with legal and regulatory requirements; ethical issues and organisational specifications, alerting senior managers when necessary.",null,null,null,null,null,null,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"}]
["S6","Make decisions and judgements at speed and when under pressure, on the way stories are researched and presented, aiming to lead when breaking news.",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"}]
["S7","Find and use contacts to create journalistic content and exclusive stories which meet the needs of the target audience. Verify information from contacts and critically review its short and long-term implications.",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"}]
["S8","Use audience analytics to evaluate the success of the journalistic content and how that can inform future decision-making.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Monitor relevant social media on a systematic basis. Proactively seek, verify and curate sources of user-generated content that will help improve targeted content, grow the audience and the depth of engagement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Produce journalistic content using language which resonates with the audience as measured by audience analytics, social media interaction and reach or other internal \"tools\" used by employers to understand audience sentiment.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Produce journalistic content in multimedia combinations as required which \"draw in\" the viewer/listener/user to tell the complete story.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Report live to the audience from the scene of an event using remote technologies.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Publish journalistic content, using all available tools to enhance the user experience.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Undertake different types of interviews to extract information, identifying and selecting the right interviewing technique to suit the interviewee and seeking to make a connection with the subject.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Evaluate answers from interviewees to inform further questioning, probing for detail and inconsistencies in replies given. If needed, identify other people to speak to.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Check and evaluate own work in relation to industry standards, adhering to employer guidelines. Ensure it is of a quality to maintain the organisation's reputation in the industry.",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"}]
["S17","Seek constructive feedback from relevant people about your performance; taking action as required.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J60=1,1,IF(J60=0.5,0.5,IF(J60=0,0)))","v":0},{"$f":"IF(L60=1,\"NONE\",IF(L60=0.5,\"PARTIAL\",IF(L60=0,\"FULL\")))","v":"FULL"}]
["S18","Consider the impact of equality and diversity practices on individuals and groups and ensure those practices are inclusive.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Locate, clean and interrogate datasets to inform content generation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Proactive and is curious, forward-looking, and open to change and emerging trends, to enhance the overall experience of the reader, viewer, or end-user.",null,null,null,null,null,null,{"$f":"IF(C64:C72 = \"FULLY MET\",1,IF(C64:C72 = \"PARTIALLY MET\",0.5,IF(C64:C72 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J64=1,1,IF(J64=0.5,0.5,IF(J64=0,0)))","v":0},{"$f":"IF(L64=1,\"NONE\",IF(L64=0.5,\"PARTIAL\",IF(L64=0,\"FULL\")))","v":"FULL"}]
["B2","Work on own initiative to prepare accurate journalistic content in the most eye-catching and compelling manner, getting it ‘right first time’. Takes responsibility for seeing the \"big picture\" amidst a mass of information or data.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B3","Work ethically and with integrity and knows when to seek advice from more senior staff.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Work in a transparent and open way; making judgements free from bias.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Act to build and enhance the brand (employer’s and personal) and considers the consequences of any actions.",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"}]
["B6","Works collaboratively with stakeholders and colleagues, developing strong working relationships to achieve common goals and promote mutual respect.",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(J69=1,0.5,IF(J69=0.5,0.5,IF(J69=0,0)))","v":0},"PARTIAL"]
["B7","Recognises and complies with equality, diversity and inclusion in the workplace.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J70=1,1,IF(J70=0.5,0.5,IF(J70=0,0)))","v":0},{"$f":"IF(L70=1,\"NONE\",IF(L70=0.5,\"PARTIAL\",IF(L70=0,\"FULL\")))","v":"FULL"}]
["B8","Is empathetic, builds trust and contact networks, recognising a duty of care may be owed to sources/contacts, and is a good listener while still critically evaluating the information being received.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J71=1,1,IF(J71=0.5,0.5,IF(J71=0,0)))","v":0},{"$f":"IF(L71=1,\"NONE\",IF(L71=0.5,\"PARTIAL\",IF(L71=0,\"FULL\")))","v":"FULL"}]
["B9","Adapts positively to changing work priorities and patterns, ensuring deadlines continue to be met.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J72=1,1,IF(J72=0.5,0.5,IF(J72=0,0)))","v":0},{"$f":"IF(L72=1,\"NONE\",IF(L72=0.5,\"PARTIAL\",IF(L72=0,\"FULL\")))","v":"FULL"}]
[]
[]
[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,"partialy mitigated",4]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L79-L80-(L81*0.5)","v":47}]

{"sheet":"ST1325","index":11,"n_rows":173,"n_cols":21,"rows_kept":173,"cut":false,"hidden":false,"merged":[[127,11,127,15],[139,11,139,15],[151,11,151,15],[163,11,163,15],[9,0,9,9],[10,2,10,4],[20,1,20,4],[22,2,22,4],[18,1,18,4]]}
[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 \n\n(this list contain the core KSBs for the Junior visual effects (VFX) artist or assistant technical director (ATD) occupation, plus the specific KSBs for Junior VFX Artist (2D), Junior VFX Artist (CG/3D) and Assistant Technical Director (VFX) options)","Included in:",null,null,"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 I) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column H 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,null,"Junior visual effects - VFX artist or assistant technical director - ATD (level 4) - Junior VFX Artist (2D)","Junior visual effects - VFX artist or assistant technical director - ATD (level 4) - Junior VFX Artist (CG/3D)","Junior visual effects - VFX artist or assistant technical director - ATD (level 4) - Assistant Technical Director (VFX)"]
["K7","Safe and professional working practices including health, safety, environment and legislative requirements relevant to the sector, the organisation and own role","YES","YES","YES","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","YES","YES","YES","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,"Junior visual effects - VFX artist or assistant technical director - ATD (level 4)"]
[null,"Return to Guide"]
[null,"Three options are available (columns C-E). Please check if the KSB needs to be mapped against the option of your choice. If you map against two or three options and the evidence is different for each option please mark which evidence corresponds to which option."]
[]
["KSB","KSB Statement \n\n(this list contain the core KSBs for the Junior visual effects (VFX) artist or assistant technical director (ATD) occupation, plus the specific KSBs for Junior VFX Artist (2D), Junior VFX Artist (CG/3D) andAssistant Technical Director (VFX) options)","Included in:",null,null,"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 I) should clearly and explicitly demonstrate the declared level of KSB coverage.","Supporting Comments/Rationale\n\nWhere the evidence in Column H 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","Junior visual effects - VFX artist or assistant technical director - ATD (level 4) - Junior VFX Artist (2D)","Junior visual effects - VFX artist or assistant technical director - ATD (level 4) - Junior VFX Artist (CG/3D)","Junior visual effects - VFX artist or assistant technical director - ATD (level 4) - Assistant Technical Director (VFX)"]
["K1","The value of VFX content and confidentiality to the business and its customers. Why it is important to maintain data security, and the legal and regulatory requirements which apply to VFX assets including copyright and intellectual property rights","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F25:F69 = \"FULLY MET\",1,IF(F25:F69 = \"PARTIALLY MET\",0.5,IF(F25:F69 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(M25=1,1,IF(M25=0.5,0.5,IF(M25=0,0)))","v":0},{"$f":"IF(O25=1,\"NONE\",IF(O25=0.5,\"PARTIAL\",IF(O25=0,\"FULL\")))","v":"FULL"}]
["K2","The in-camera creation pipeline, from pre-production, through shoot, editorial, VFX to grading","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K3","The importance and methods of retaining the quality of the source material\n","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","The VFX industry and the terminology, policies, standards and procedures, current tools and workflows used\n","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","The VFX production pipeline, including shot bidding, turn-over, briefing, reviews, client reviews, deliveries and final delivery","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","The importance of naming conventions, file formats and version control and the impact of not doing this correctly","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","How to identify production requirements from a brief; plan your approach to the work, techniques, optimisation and schedule","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","The requirements and expectations of the workflow, and of other team members who will use the assets you create","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Common artefacts in plate photography such as lens distortion, parallax and overscan","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","The principles of perspective, depth of field and scale, and how this relates to a believable final image","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","The principles of photographic composition, light and colour","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","The principles of computer systems, IP networks and shared storage systems as applied in VFX","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How assets are managed throughout the workflow including: production storage, shared storage, nearline storage and archive, whether on premises or in the cloud","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Why it is important to evaluate progress and seek feedback on your work in VFX","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","How to create assets that support the vision of the story and the purpose of the image","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","How computer generated imagery (CGI) can be rendered in multiple passes in order to be adjusted more efficiently in the composite. These passes can include: colour, diffuse, specular, shadow and beauty lighting.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","Research methods, techniques and tools that can be used and where to find credible and valid sources of information, reference materials and previously created assets.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","The different software and techniques that could be used; the implications of their use, how to customise these and how they can be used to solve problems.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","The rendering requirements for the production and how to optimise assets","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","How digital images are encoded and stored, especially colour spaces and their appropriate use","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","The differences in linear light, gamma encoded and logarithmic encoded pixel values","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","The implications of working with high and low dynamic range images","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","The VFX colour pipeline, from acquisition to working space, balance grades, look grades and delivery","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","How to determine the most appropriate method for removing unwanted artefacts in live action footage","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K25","Camera moves and how they impact patching or frame-by-frame painting","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K26","How to determine which technique is the correct method to generate the matte and how the matte will be used in the composite","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K27","Motion blur, how it affects the matte and the principals of animation to effectively replicate in the generated matte","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K28","How to analyse the shot to determine the most efficient breakdown of shapes and keyframes","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K29","The concept and purpose of a template or hero script as appropriate","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K30","How to identify and select the different rendering techniques and tools to use, and how to save and duplicate render settings across multiple files","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K31","The types of data and information you might receive from an on-set environment","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K32","The fundamentals of data structures, structured and unstructured data, database system design, implementation and maintenance","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K33","The quality issues that can arise with data and how to avoid and/or resolve these","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K34","How to identify where your asset or shot fits within a sequence","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K35","The process of following image features across a series of frames to record the position of an object in the source footage","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K36","How the camera moves, the impact on the tracking process and how to select the most appropriate method to produce an accurate track","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K37","The technical process of tracking and how you can improve the accuracy and efficiency of tracking the shot","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K38","How to interrogate software to solve issues with and/or create: simple shot lighting, basic simulations, a model, a rig or blocked animation","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K39","The organisation's data architecture","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K40","Grid computing and its use within VFX render queues - at a basic level","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K41","How to balance resource needs within the company’s physical capacity","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K42","Principles of software development, the software design process and the importance of design before development","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K43","How workflow diagrams, prototyping and presenting to intended users can aid in designing better solutions","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K44","Application specific scripting languages e.g. general scripting languages such as python alongside application specific scripting Mel, vex , Hscript etc. as appropriate","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K45","The concept and purpose of a template or hero script as appropriate","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Identify the information required, and gather the appropriate research or reference materials to carry out your work to expected creative, narrative and technical standards on each production","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F71:F117 = \"FULLY MET\",1,IF(F71:F117 = \"PARTIALLY MET\",0.5,IF(F71:F117 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(M71=1,1,IF(M71=0.5,0.5,IF(M71=0,0)))","v":0},{"$f":"IF(O71=1,\"NONE\",IF(O71=0.5,\"PARTIAL\",IF(O71=0,\"FULL\")))","v":"FULL"}]
["S2","Select the appropriate software and technique to meet the required standards and tasks, taking into account the needs of other departments in the production pipeline","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M72=1,1,IF(M72=0.5,0.5,IF(M72=0,0)))","v":0},{"$f":"IF(O72=1,\"NONE\",IF(O72=0.5,\"PARTIAL\",IF(O72=0,\"FULL\")))","v":"FULL"}]
["S3","Use appropriate techniques to reduce degradation of the source material","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M73=1,1,IF(M73=0.5,0.5,IF(M73=0,0)))","v":0},{"$f":"IF(O73=1,\"NONE\",IF(O73=0.5,\"PARTIAL\",IF(O73=0,\"FULL\")))","v":"FULL"}]
["S4","Identify render errors and fix/escalate them as appropriate","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M74=1,1,IF(M74=0.5,0.5,IF(M74=0,0)))","v":0},{"$f":"IF(O74=1,\"NONE\",IF(O74=0.5,\"PARTIAL\",IF(O74=0,\"FULL\")))","v":"FULL"}]
["S5","Work in line with agreed workflows, adapting to operational and creative changes as they occur","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M75=1,1,IF(M75=0.5,0.5,IF(M75=0,0)))","v":0},{"$f":"IF(O75=1,\"NONE\",IF(O75=0.5,\"PARTIAL\",IF(O75=0,\"FULL\")))","v":"FULL"}]
["S6","Operate within and adhere to agreed organisational policies, standards and procedures such as health & safety, confidentiality, security, asset storage and legal and regulatory requirements","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M76=1,0.5,IF(M76=0.5,0.5,IF(M76=0,0)))","v":0},{"$f":"IF(O76=0.5,\"NONE\",IF(O76=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S7","Manage own workload and operate both individually and as part of a wider VFX team, keeping colleagues, clients and/or other departments updated on progress and report any issues arising","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M77=1,0.5,IF(M77=0.5,0.5,IF(M77=0,0)))","v":0},{"$f":"IF(O77=0.5,\"NONE\",IF(O77=0,\"PARTIAL\"))","v":"PARTIAL"}]
["S8","Use reliable information to keep-up-to date with the new tools, software, data and other related technology, and how they affect your work","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M78=1,1,IF(M78=0.5,0.5,IF(M78=0,0)))","v":0},{"$f":"IF(O78=1,\"NONE\",IF(O78=0.5,\"PARTIAL\",IF(O78=0,\"FULL\")))","v":"FULL"}]
["S9","Interpret and correct lens distortion, parallax and overscan","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Multitask on simultaneous projects, often for different clients, deciding how to prioritise the work to ensure that all tasks are completed on schedule","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Respond positively to feedback on work, making refinements as needed","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Apply the naming conventions, file formats and version control for the work","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Deliver content in the correct format as required by the employer and clients","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Use maths to describe problems, recreate physical systems or manipulate computer generated geometry","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Move, store and organise assets created, ensuring data integrity, in order to enable their use throughout the rest of the pipeline","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Analyse and determine the most appropriate approach to carry out the work","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Trouble shoot VFX problems, taking responsibility for the course of action followed, including identifying opportunities to deliver viable solutions and sharing these outcomes.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Convert between common colour spaces, selecting the appropriate colour space for the given task and combining images from multiple colour spaces","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Apply colour adjustments at the correct stage of the composite, using non-destructive adjustments where possible","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Use patching techniques to remove unwanted objects within the live action footage","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Use frame-by-frame painting to remove unwanted objects within the live action footage","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Generate mattes by roto-scoping and luminance, difference and colour keying","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Produce accurate roto-scope by correctly placing shapes, control points and keyframes","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Accurately replicate motion blur within the roto-scope generated matte","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Complete basic composites demonstrating keying, colour grading, re- timing and screen insertion","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S26","Complete basic live action and CGI composites demonstrating set extensions and simple CGI objects integrated into live action elements","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S27","Create accurate point tracks and planar tracks in line with production requirements","YES","NO","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S28","Apply render settings across multiple assets","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S29","Analyse, interpret and use on-set data and information","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S30","Model and manipulate geometry for scene reconstruction","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S31","Select and use software to create: a model, a texture map, puppet rig or blocked animation to meet the requirements of the brief","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S32","Review assets created with the relevant people, offering suggestions to assist others with the production","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S33","Capture and work with photogrammetry and convert it to useable 3D geometry and cameras","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S34","Optimise and rebuild assets/scenes for real time rendering","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S35","Assemble, layout and maintain assets into project, sequence, or shot based environments","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S36","Identify, collect and migrate data to/from a range of systems","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S37","Manipulate and link different data sets as required","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S38","Perform database queries across multiple tables to extract data for analysis","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S39","Monitor, manipulate and report on render queues","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S40","Monitor, track and report render resource usage","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S41","Investigate existing solutions or frameworks","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S42","Design and present proposed solutions and respond to feedback","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S43","Plan and document development roadmap","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S44","Troubleshoot individual artist input, output or archival problems","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S45","Develop small-scale tools, using existing pipeline frameworks and libraries","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S46","Support or troubleshoot pipeline and workflow tools","NO","NO","YES",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S47","Create accurate point tracks and planar tracks in line with production requirements","NO","YES","NO",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Work with sustained concentration and with attention to detail; able to self-check work for quality control","YES","YES","YES",null,null,null,null,null,null,{"$f":"IF(F119:F125 = \"FULLY MET\",1,IF(F119:F125 = \"PARTIALLY MET\",0.5,IF(F119:F125 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(M119=1,1,IF(M119=0.5,0.5,IF(M119=0,0)))","v":0},{"$f":"IF(O119=1,\"NONE\",IF(O119=0.5,\"PARTIAL\",IF(O119=0,\"FULL\")))","v":"FULL"}]
["B2","Work on own initiative, be proactive and inquisitive; but recognise your own level of authority and when it is necessary to escalate issues. Act in a professional and ethical manner, embracing equality, diversity and inclusion in the workplace.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M120=1,1,IF(M120=0.5,0.5,IF(M120=0,0)))","v":0},{"$f":"IF(O120=1,\"NONE\",IF(O120=0.5,\"PARTIAL\",IF(O120=0,\"FULL\")))","v":"FULL"}]
["B3","Think creatively and logically to solve technical problems - contribute to a process continual improvement of workflow and technique. Use initiative and innovation to problem solve, to provide creative solutions and opportunities for the production.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M121=1,1,IF(M121=0.5,0.5,IF(M121=0,0)))","v":0},{"$f":"IF(O121=1,\"NONE\",IF(O121=0.5,\"PARTIAL\",IF(O121=0,\"FULL\")))","v":"FULL"}]
["B4","Be flexible and able to work under pressure - managing and re-organising priorities and bringing multiple tasks to completion within deadlines, communicating progress as required","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M122=1,1,IF(M122=0.5,0.5,IF(M122=0,0)))","v":0},{"$f":"IF(O122=1,\"NONE\",IF(O122=0.5,\"PARTIAL\",IF(O122=0,\"FULL\")))","v":"FULL"}]
["B5","Demonstrate judgement in assessing the use of emerging practice within the constraints of a production environment. Do not willingly accept second best, and be pragmatic about balancing client expectations against the available time and budget.","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M123=1,1,IF(M123=0.5,0.5,IF(M123=0,0)))","v":0},{"$f":"IF(O123=1,\"NONE\",IF(O123=0.5,\"PARTIAL\",IF(O123=0,\"FULL\")))","v":"FULL"}]
["B6","Use different communication methods and tools to suit different audiences or situations and changes in circumstances to create and maintain positive, professional, trusting and ethical working relationships with your team and the wider range of internal, external and connected stakeholders.","YES","YES","YES",null,null,null,null,null,null,0,null,"PARTIAL",{"$f":"IF(M124=1,0.5,IF(M124=0.5,0.5,IF(M124=0,0)))","v":0},{"$f":"IF(O124=0.5,\"NONE\",IF(O124=0,\"PARTIAL\"))","v":"PARTIAL"}]
["B7","Maintain commercial confidentiality and professional practice at all times, and in all settings","YES","YES","YES",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(M125=1,1,IF(M125=0.5,0.5,IF(M125=0,0)))","v":0},{"$f":"IF(O125=1,\"NONE\",IF(O125=0.5,\"PARTIAL\",IF(O125=0,\"FULL\")))","v":"FULL"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Junior Visual Effects (VFX) Artist or Assistant Technical Director (ATD) (Level 4) - Junior VFX Artist (2D)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M25:M53,M71:M97,M119:M125)","v":0},"Net Score",{"$f":"SUM(O25:O53,O71:O97,O119:O125)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M130/O134","v":0},"total CoE KSB coverage",{"$f":"O130/O137","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O134-O135-(O136*0.5)","v":61.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Junior Visual Effects (VFX) Artist or Assistant Technical Director (ATD) (Level 4) - Junior VFX Artist (CG/3D)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M25:M43,M54:M55,M58:M62,M69,M71:M87,M98:M105,M117,M119:M125)","v":0},"Net Score",{"$f":"SUM(O25:O43,O54:O55,O58:O62,O69,O71:O87,O98:O105,O117,O119:O125)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M142/O146","v":0},"total CoE KSB coverage",{"$f":"O142/O149","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O146-O147-(O148*0.5)","v":58.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Junior Visual Effects (VFX) Artist or Assistant Technical Director (ATD) (Level 4) - Assistant Technical Director (VFX)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M25:M43,M56:M57,M63:M68,M71:M87,M106:M116,M119:M125)","v":0},"Net Score",{"$f":"SUM(O25:O43,O56:O57,O63:O68,O71:O87,O106:O116,O119:O125)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M154/O158","v":0},"total CoE KSB coverage",{"$f":"O154/O161","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O158-O159-(O160*0.5)","v":60.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL FOR ALL KSBs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(M25:M125)","v":0},"Net Score",{"$f":"SUM(O25:O125)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"M166/O170","v":0},"total CoE KSB coverage",{"$f":"O166/O173","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"total KSBs",99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"partialy mitigated",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"O170-O171-(O172*0.5)","v":97.5}]

{"sheet":"ST1388","index":12,"n_rows":87,"n_cols":18,"rows_kept":87,"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,"Photographer (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","Range of functions, roles and skills within photo imaging and employers and professional bodies representing the industry.",null,null,null,null,null,null,{"$f":"IF(C22:C45 = \"FULLY MET\",1,IF(C22:C45 = \"PARTIALLY MET\",0.5,IF(C22:C45 = \"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","Approaches to and resources for maintaining up-to-date knowledge of existing and evolving technology, trends and platforms.",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","Own responsibilities towards health and safety and how to recognise and address environmental hazards in their workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K4","Legislation, regulations and guidance for the photo imaging industry including copyright and intellectual property, GDPR, model release and photography of children.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K5","Insurance requirements including professional indemnity and public liability.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K6","Camera settings and the relationship between; aperture, shutter speed and ISO.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K7","How to interpret a photographic brief prior to a shoot including client/colleague engagement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K8","Potential factors that can affect what can be achieved upon receiving the brief including aesthetics, own personal style, legal and ethical matters.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K9","Resource requirements including budget, time, suppliers, technical specifications and sustainability considerations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K10","Own business or organisation’s strategy and objectives, the business environment and business issues related to photographic projects and customer needs.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K11","How and when to work independently or interact within a team, understanding own role within the organisation.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K12","Importance of communications and customer/client service to the organisation, including how to handle enquiries, comments and complaints.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K13","How to safely set up, operate and store photographic equipment in different environments and situations.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K14","Causes of common faults/issues in photographic equipment, fault- finding, the maintenance and fixing of faults and knowing when to escalate an issue.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K15","Principles of light including using available light combinations (e.g., daylight, free- standing lights and camera mounted flash), lenses and exposure.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K16","Principles of composition such as rule of thirds, leading lines and symmetry.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K17","End-to-end photographic workflow and planning process, the key stages including postproduction and own role and responsibilities within this.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K18","Importance of metadata and keywording in allowing for the search and proper identifications of stored images and how to enter key metadata to store specific information in photo editing software in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K19","Range of available industry-standard software relevant to image retouching and how to use it.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K20","Colour management – the reasons for, and use of, colour profiles and the calibration of monitors for printing purposes.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K21","How to manage different formats, including the digitisation of historic images and how to convert file formats, selecting the most appropriate file format and the significance of lossy or lossless compression.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K22","Concepts and techniques of video editing required to construct video sequences and edit points to tell a story using industry-standard editing systems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K23","How to make sure the imaging system is secure, free from viruses and password protected.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["K24","Own organisation’s procedures relating to sending and receiving material in the format to meet the customer/client brief.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Skills"]
["S1","Comply with legislation, regulations and guidance including copyright and health & safety.",null,null,null,null,null,null,{"$f":"IF(C47:C71 = \"FULLY MET\",1,IF(C47:C71 = \"PARTIALLY MET\",0.5,IF(C47:C71 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J47=1,1,IF(J47=0.5,0.5,IF(J47=0,0)))","v":0},{"$f":"IF(L47=1,\"NONE\",IF(L47=0.5,\"PARTIAL\",IF(L47=0,\"FULL\")))","v":"FULL"}]
["S2","Provide necessary permissions for use of images and issue licenses for own work as required.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J48=1,1,IF(J48=0.5,0.5,IF(J48=0,0)))","v":0},{"$f":"IF(L48=1,\"NONE\",IF(L48=0.5,\"PARTIAL\",IF(L48=0,\"FULL\")))","v":"FULL"}]
["S3","Use reliable information to keep up-to-date with the new tools, equipment, and other related technology, and how they affect own work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S4","Discuss with the customer/client the purpose of the work, objectives, the deadline, budget and amount of flexibility in meeting the brief.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S5","Use the information gathered from the customer/client to review, evaluate and select the preferred approach to the work.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S6","Prepare and present the possible approaches to the brief to the client/customer.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S7","Identify and mitigate health and safety issues likely to arise from the brief.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S8","Manage own workload and operate both individually and as part of a wider photographic team, keeping internal and external stakeholders updated on progress and reporting any issues arising.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S9","Manage developing situations with customers/clients such as customer relations, complaints, dissatisfaction and business environment and know when to escalate these as required.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S10","Select equipment and resources suitable for the task considering, the end purpose of the imagery, the location and existing light conditions.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S11","Assemble and position equipment safely, checking for any issues and carrying out repairs as required.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S12","Determine the camera settings and lighting arrangements to meet the task and adjust if required.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S13","Take images that achieve the viewpoint, composition and point of focus.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S14","Record, clearly and accurately, information required throughout workflow.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S15","Embed copyright and other key metadata information in images in standard image file formats.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S16","Assign keywords to classify images including by content, topic and concept.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S17","Manage key metadata so it is preserved throughout the workflow to storage.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S18","Export finished content or work-in-progress with metadata, from post-production systems to the customer/client.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S19","Determine an agreed approach with the client/customer to be adopted for retouching the image(s) in line with their requirements.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S20","Produce retouched images, check the quality of the retouched images against client requirements and workplace standards.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S21","Follow protocol to save the retouched image files in the correct format ready for outputting or storage.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S22","Implement workplace security procedures to check the system security, virus protection and file security.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S23","Diagnose any problems in the imaging system using problem solving techniques.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S24","Review and implement procedures in place to maintain a history of all image files.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["S25","Undertake continuing professional development within the role, reflecting systematically on progress and identifying opportunities for meaningful improvement.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[null,"Behaviours"]
["B1","Works collaboratively to build and maintain positive relationships with colleagues, customers/clients and suppliers.",null,null,null,null,null,null,{"$f":"IF(C73:C77 = \"FULLY MET\",1,IF(C73:C77 = \"PARTIALLY MET\",0.5,IF(C73:C77 = \"NOT MET\",0,)))","v":0},null,"NONE",{"$f":"IF(J73=1,1,IF(J73=0.5,0.5,IF(J73=0,0)))","v":0},{"$f":"IF(L73=1,\"NONE\",IF(L73=0.5,\"PARTIAL\",IF(L73=0,\"FULL\")))","v":"FULL"}]
["B2","Takes ownership of work, with a strong work ethic and commitment to achieving high standards.",null,null,null,null,null,null,0,null,"NONE",{"$f":"IF(J74=1,1,IF(J74=0.5,0.5,IF(J74=0,0)))","v":0},{"$f":"IF(L74=1,\"NONE\",IF(L74=0.5,\"PARTIAL\",IF(L74=0,\"FULL\")))","v":"FULL"}]
["B3","Committed to keeping up to date with new technologies, including viable sustainability solutions, and industry best practice. Resourceful in finding creative solutions to solve problems.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B4","Works in a professional and ethical manner, embracing equality, diversity and inclusion in the workplace.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
["B5","Reflective. Considers the results of the images or videography created and identifies areas for improvement or re-use.",null,null,null,null,null,null,0,null,"NONE",0,"FULL"]
[]
[]
[null,null,null,null,null,null,null,null,"Gross score",{"$f":"SUM(J22:J77)","v":0},"Net Score",{"$f":"SUM(L22:L77)","v":0}]
[null,null,null,null,null,null,null,null,"total KSB coverage",{"$f":"J80/L84","v":0},"total CoE KSB coverage",{"$f":"L80/L87","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"total KSBs",54]
[null,null,null,null,null,null,null,null,null,null,"fully mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"partialy mitigated",0]
[null,null,null,null,null,null,null,null,null,null,"net KSB",{"$f":"L84-L85-(L86*0.5)","v":54}]

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