{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Qualification structure","Data validation","Standard reference table","Notes for officials"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Qualification structure","index":0,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[9,1,9,4],[11,0,13,0],[16,0,27,0]]}
[null,null,null,"START HERE","Response"]
[null,null,null,"Awarding body/Applicant:","Please type the name of awarding body/applicant here"]
[null,null,null,"Qualification name:","Please type your qualification title here"]
[null,null,null,"Programme title (if applicable):","Please type the programme title here"]
[null,null,null,"Aligned standard (select all that apply):","OCC0116 Software developer, OCC0825 DevOps engineer"]
[null,null,null,"Placement included (yes / no): "]
[null,null,null,"Placement length:"]
[]
[]
[null,"PLEASE LIST ALL THE MODULES/UNITS IN THE QUALIFICATION"]
[]
["Example rows","Module/Unit Code","Module/Unit title","Mandatory or optional?","Have you referenced this module in your KSB mapping sheet?","If your qualification is aligned to multiple standards, state which standard this module is aligned to \n\n(if your qualification is only aligned to one standard please leave this column blank)","Credits","Module/Unit Level","Delivery Method\n\n\n\n\n\n(multiple dropdown - please enable macros and select all that apply)","Have you submitted a SAM for this unit?\n\n(Please remember you must provide THREE (3) complete sets of SAMs. Each set of SAMs must be from a different unit or module within your qualification. Where a qualification contains multiple pathways, applicants are required to submit additional SAMs for each pathway)","Documents submitted (Institute use only)"]
[null,"EXAMPLE001","Introduction to programming","Mandatory","Yes","Software developer, DevOps engineer",30,4,"Provider setting (e.g. classroom)","Yes"]
[null,"EXAMPLE002","Further engineering and simulation","Optional","No","Software developer",20,5,"Mixed","No"]
[]
[]
["For completion by applicant","Module/Unit Code","Module/Unit title","Mandatory or optional?","Have you referenced this module in your KSB mapping sheet?","If your qualification is aligned to multiple standards, state which standard this module is aligned to \n\n(if your qualification is only aligned to one standard please leave this column blank)","Credits","Module/Unit Level","Delivery Method\n\n(multiple dropdown - please enable macros and select all that apply)","Have you submitted a SAM for this unit?\n\n(Please remember you must provide THREE (3) complete sets of SAMs. Each set of SAMs must be from a different unit or module within your qualification. Where a qualification contains multiple pathways, applicants are required to submit additional SAMs for each pathway)","Documents submitted (Institute use only)"]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Data validation","index":1,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Mandatory"]
["Optional"]
[]
["Provider setting (e.g. classroom)"]
["Online/Distance"]
["Placement"]
["Mixed"]
["Other"]
[]
[]
["Yes"]
["No"]

{"sheet":"Standard reference table","index":2,"n_rows":163,"n_cols":5,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
["Occupational Standard Reference","Occupational Standard Name","Combined name and code"," Level","Route"]
["OCC0208","Golf course manager","OCC0208 Golf course manager",5,"Agriculture, environmental and animal care"]
["OCC0398","Animal training instructor","OCC0398 Animal training instructor",4,"Agriculture, environmental and animal care"]
["OCC0921","Arboriculturist","OCC0921 Arboriculturist",4,"Agriculture, environmental and animal care"]
["OCC0924","Horticulture and landscape technical manager","OCC0924 Horticulture and landscape technical manager",5,"Agriculture, environmental and animal care"]
["OCC0926","Countryside ranger","OCC0926 Countryside ranger",4,"Agriculture, environmental and animal care"]
["OCC0946","Vet technician livestock","OCC0946 Vet technician livestock",5,"Agriculture, environmental and animal care"]
["OCC1320","Assistant farm manager","OCC1320 Assistant farm manager",4,"Agriculture, environmental and animal care"]
["OCC0092","Community energy specialist","OCC0092 Community energy specialist",4,"Business and administration"]
["OCC0109","Dental practice manager","OCC0109 Dental practice manager",4,"Business and administration"]
["OCC0192","Improvement practitioner","OCC0192 Improvement practitioner",4,"Business and administration"]
["OCC0238","People professional","OCC0238 People professional",5,"Business and administration"]
["OCC0273","Junior management consultant","OCC0273 Junior management consultant",4,"Business and administration"]
["OCC0310","Associate project manager","OCC0310 Associate project manager",4,"Business and administration"]
["OCC0385","Operations manager","OCC0385 Operations manager",5,"Business and administration"]
["OCC0430","Regulatory compliance officer","OCC0430 Regulatory compliance officer",4,"Business and administration"]
["OCC0526","Policy officer","OCC0526 Policy officer",4,"Business and administration"]
["OCC0555","Improvement specialist","OCC0555 Improvement specialist",5,"Business and administration"]
["OCC0563","Learning and development consultant business partner","OCC0563 Learning and development consultant business partner",5,"Business and administration"]
["OCC0575","School business professional","OCC0575 School business professional",4,"Business and administration"]
["OCC0602","Revenues and welfare benefits practitioner","OCC0602 Revenues and welfare benefits practitioner",4,"Business and administration"]
["OCC0663","Employability practitioner","OCC0663 Employability practitioner",4,"Business and administration"]
["OCC0762","Information manager","OCC0762 Information manager",4,"Business and administration"]
["OCC0809","Coaching professional","OCC0809 Coaching professional",5,"Business and administration"]
["OCC0815","Trade union official","OCC0815 Trade union official",4,"Business and administration"]
["OCC0853","Quality practitioner","OCC0853 Quality practitioner",4,"Business and administration"]
["OCC0934","Corporate responsibility and sustainability practitioner","OCC0934 Corporate responsibility and sustainability practitioner",4,"Business and administration"]
["OCC0967","Data protection and information governance practitioner","OCC0967 Data protection and information governance practitioner",4,"Business and administration"]
["OCC1302","Governance officer","OCC1302 Governance officer",4,"Business and administration"]
["OCC0007","Lead practitioner in adult care","OCC0007 Lead practitioner in adult care",4,"Care services"]
["OCC0008","Leader in adult care","OCC0008 Leader in adult care",5,"Care services"]
["OCC0087","Children, young people and families manager ","OCC0087 Children, young people and families manager ",5,"Care services"]
["OCC0088","Children, young people and families practitioner","OCC0088 Children, young people and families practitioner",4,"Care services"]
["OCC0862","Domestic and sexual abuse support worker ","OCC0862 Domestic and sexual abuse support worker ",4,"Care services"]
["OCC0868","Early intervention practitioner","OCC0868 Early intervention practitioner",4,"Care services"]
["OCC0229","Hospitality manager","OCC0229 Hospitality manager",4,"Catering and hospitality"]
["OCC0864","Senior culinary chef","OCC0864 Senior culinary chef",4,"Catering and hospitality"]
["OCC0041","Building services engineering senior technician","OCC0041 Building services engineering senior technician",4,"Construction and the built environment"]
["OCC0043","Construction design and build technician","OCC0043 Construction design and build technician",4,"Construction and the built environment"]
["OCC0046","Civil engineering senior technician","OCC0046 Civil engineering senior technician",4,"Construction and the built environment"]
["OCC0048","Construction site supervisor","OCC0048 Construction site supervisor",4,"Construction and the built environment"]
["OCC0049","Construction quantity surveying technician","OCC0049 Construction quantity surveying technician",4,"Construction and the built environment"]
["OCC0484","Facilities manager","OCC0484 Facilities manager",4,"Construction and the built environment"]
["OCC0613","Acoustics technician","OCC0613 Acoustics technician",4,"Construction and the built environment"]
["OCC0629","BEMS building energy management systems controls engineer","OCC0629 BEMS building energy management systems controls engineer",4,"Construction and the built environment"]
["OCC0877","Land referencer","OCC0877 Land referencer",4,"Construction and the built environment"]
["OCC0936","Town planning assistant","OCC0936 Town planning assistant",4,"Construction and the built environment"]
["OCC1105","Heritage construction specialist","OCC1105 Heritage construction specialist",5,"Construction and the built environment"]
["OCC1299","Cellular network field engineer","OCC1299 Cellular network field engineer",4,"Construction and the built environment"]
["OCC0055","Bespoke cutter and tailor ","OCC0055 Bespoke cutter and tailor ",5,"Creative and design"]
["OCC0425","Broadcast and media systems technician","OCC0425 Broadcast and media systems technician",5,"Creative and design"]
["OCC0488","Junior animator","OCC0488 Junior animator",4,"Creative and design"]
["OCC0611","Cultural heritage conservation technician","OCC0611 Cultural heritage conservation technician",4,"Creative and design"]
["OCC0696","Post production technical operator","OCC0696 Post production technical operator",4,"Creative and design"]
["OCC0749","Historic environment advice assistant","OCC0749 Historic environment advice assistant",4,"Creative and design"]
["OCC0792","Junior production coordinator","OCC0792 Junior production coordinator",4,"Creative and design"]
["OCC0912","Stained glass craftsperson","OCC0912 Stained glass craftsperson",4,"Creative and design"]
["OCC0933","Post production engineer","OCC0933 Post production engineer",5,"Creative and design"]
["OCC0940","Audiovisual technician","OCC0940 Audiovisual technician",5,"Creative and design"]
["OCC0944","Assistant recording technician","OCC0944 Assistant recording technician",4,"Creative and design"]
["OCC1324","Journalist","OCC1324 Journalist",5,"Creative and design"]
["OCC1325","Junior visual effects","OCC1325 Junior visual effects",4,"Creative and design"]
["OCC1388","Photographer","OCC1388 Photographer",4,"Creative and design"]
["OCC1442","Publishing Professional","OCC1442 Publishing Professional",4,"Creative and design"]
["OCC0116","Software developer","OCC0116 Software developer",4,"Digital"]
["OCC0117","Business Analyst","OCC0117 Business Analyst",4,"Digital"]
["OCC0118","Data analyst","OCC0118 Data analyst",4,"Digital"]
["OCC0127","Network engineer","OCC0127 Network engineer",4,"Digital"]
["OCC0129","Software tester","OCC0129 Software tester",4,"Digital"]
["OCC0345","Digital community manager","OCC0345 Digital community manager",4,"Digital"]
["OCC0825","DevOps engineer","OCC0825 DevOps engineer",4,"Digital"]
["OCC0863","Digital accessibility specialist","OCC0863 Digital accessibility specialist",4,"Digital"]
["OCC0949","Applications support lead","OCC0949 Applications support lead",4,"Digital"]
["OCC0964","Digital product manager","OCC0964 Digital product manager",4,"Digital"]
["OCC0974","Digital learning designer","OCC0974 Digital learning designer",5,"Digital"]
["OCC1021","Cyber security technologist ","OCC1021 Cyber security technologist ",4,"Digital"]
["OCC1343","Digital forensic technician","OCC1343 Digital forensic technician",4,"Digital"]
["OCC1386","Data engineer","OCC1386 Data engineer",5,"Digital"]
["OCC0149","Learning and skills teacher","OCC0149 Learning and skills teacher",5,"Education and early years"]
["OCC0551","Early years lead practitioner","OCC0551 Early years lead practitioner",5,"Education and early years"]
["OCC1379","Learning and skills mentor","OCC1379 Learning and skills mentor",4,"Education and early years"]
["OCC1414","Specialist teaching assistant","OCC1414 Specialist teaching assistant",5,"Education and early years"]
["OCC0019","Aircraft certifying engineer","OCC0019 Aircraft certifying engineer",4,"Engineering and manufacturing"]
["OCC0066","Road transport engineering manager","OCC0066 Road transport engineering manager",4,"Engineering and manufacturing"]
["OCC0157","Electrical power protection and plant commissioning engineer","OCC0157 Electrical power protection and plant commissioning engineer",4,"Engineering and manufacturing"]
["OCC0292","Nuclear welding inspection technician nwit","OCC0292 Nuclear welding inspection technician nwit",4,"Engineering and manufacturing"]
["OCC0316","Rail engineering advanced technician","OCC0316 Rail engineering advanced technician",4,"Engineering and manufacturing"]
["OCC0380","Nuclear technician","OCC0380 Nuclear technician",5,"Engineering and manufacturing"]
["OCC0406","Vehicle damage assessor","OCC0406 Vehicle damage assessor",4,"Engineering and manufacturing"]
["OCC0475","Electrical power networks engineer","OCC0475 Electrical power networks engineer",4,"Engineering and manufacturing"]
["OCC0495","Rail and rail systems engineer ","OCC0495 Rail and rail systems engineer ",5,"Engineering and manufacturing"]
["OCC0528","High speed rail and infrastructure technician","OCC0528 High speed rail and infrastructure technician",4,"Engineering and manufacturing"]
["OCC0540","Fashion and textiles product technologist","OCC0540 Fashion and textiles product technologist",4,"Engineering and manufacturing"]
["OCC0580","Brewer","OCC0580 Brewer",4,"Engineering and manufacturing"]
["OCC0581","Textile technical specialist","OCC0581 Textile technical specialist",4,"Engineering and manufacturing"]
["OCC0588","Propulsion technician - Engine Build & Process Technician","OCC0588 Propulsion technician - Engine Build & Process Technician",4,"Engineering and manufacturing"]
["OCC0605","Mineral products technician ","OCC0605 Mineral products technician ",5,"Engineering and manufacturing"]
["OCC0624","Food and drink engineer ","OCC0624 Food and drink engineer ",5,"Engineering and manufacturing"]
["OCC0662","Automation and controls engineering technician","OCC0662 Automation and controls engineering technician",4,"Engineering and manufacturing"]
["OCC0678","Technical dyer and colourist","OCC0678 Technical dyer and colourist",4,"Engineering and manufacturing"]
["OCC0695","Process leader","OCC0695 Process leader",4,"Engineering and manufacturing"]
["OCC0823","Metal Recycling Technical Manager","OCC0823 Metal Recycling Technical Manager",5,"Engineering and manufacturing"]
["OCC0833","Ordnance munitions explosives technician","OCC0833 Ordnance munitions explosives technician",4,"Engineering and manufacturing"]
["OCC0841","Engineering manufacturing technician","OCC0841 Engineering manufacturing technician",4,"Engineering and manufacturing"]
["OCC0847","Engineer surveyor","OCC0847 Engineer surveyor",4,"Engineering and manufacturing"]
["OCC0855","Space engineering technician","OCC0855 Space engineering technician",4,"Engineering and manufacturing"]
["OCC0861","Asset manager","OCC0861 Asset manager",4,"Engineering and manufacturing"]
["OCC0875","Small vessel chief engineer","OCC0875 Small vessel chief engineer",4,"Engineering and manufacturing"]
["OCC0999","Lead engineering maintenance technician","OCC0999 Lead engineering maintenance technician",4,"Engineering and manufacturing"]
["OCC0108","Dental technician","OCC0108 Dental technician",5,"Health and science"]
["OCC0215","Assistant practitioner (health)","OCC0215 Assistant practitioner (health)",5,"Health and science"]
["OCC0220","Healthcare science associate","OCC0220 Healthcare science associate",4,"Health and science"]
["OCC0283","Senior metrology technician","OCC0283 Senior metrology technician",5,"Health and science"]
["OCC0287","Associate ambulance practitioner","OCC0287 Associate ambulance practitioner",4,"Health and science"]
["OCC0393","Dairy technologist","OCC0393 Dairy technologist",5,"Health and science"]
["OCC0431","Vision rehabilitation specialist","OCC0431 Vision rehabilitation specialist",5,"Health and science"]
["OCC0542","Oral health practitioner","OCC0542 Oral health practitioner",4,"Health and science"]
["OCC0543","Clinical dental technician","OCC0543 Clinical dental technician",5,"Health and science"]
["OCC0583","Mammography associate","OCC0583 Mammography associate",4,"Health and science"]
["OCC0597","Technician scientist","OCC0597 Technician scientist",5,"Health and science"]
["OCC0600","Hearing aid dispenser","OCC0600 Hearing aid dispenser",5,"Health and science"]
["OCC0701","Orthodontic therapist","OCC0701 Orthodontic therapist",4,"Health and science"]
["OCC0770","Sports coach ","OCC0770 Sports coach ",4,"Health and science"]
["OCC0786","Associate continuing healthcare practitioner","OCC0786 Associate continuing healthcare practitioner",5,"Health and science"]
["OCC0827","Nursing associate","OCC0827 Nursing associate",5,"Health and science"]
["OCC0829","Health play specialist","OCC0829 Health play specialist",5,"Health and science"]
["OCC0873","Hygiene specialist","OCC0873 Hygiene specialist",4,"Health and science"]
["OCC0890","Embalmer","OCC0890 Embalmer",5,"Health and science"]
["OCC0945","Outdoor learning specialist","OCC0945 Outdoor learning specialist",5,"Health and science"]
["OCC1192","Counsellor","OCC1192 Counsellor",4,"Health and science"]
["OCC1432","Dental Technician","OCC1432 Dental Technician",5,"Health and science"]
["OCC1433","Clinical Dental Technician","OCC1433 Clinical Dental Technician",5,"Health and science"]
["OCC1434","Orthodontic Therapist","OCC1434 Orthodontic Therapist",4,"Health and science"]
["OCC0003","Professional accounting or taxation technician ","OCC0003 Professional accounting or taxation technician ",4,"Legal, finance and accounting"]
["OCC0004","Actuarial technician","OCC0004 Actuarial technician",4,"Legal, finance and accounting"]
["OCC0180","Investment operations specialist","OCC0180 Investment operations specialist",4,"Legal, finance and accounting"]
["OCC0183","Paraplanner","OCC0183 Paraplanner",4,"Legal, finance and accounting"]
["OCC0241","Insurance professional","OCC0241 Insurance professional",4,"Legal, finance and accounting"]
["OCC0374","Financial adviser","OCC0374 Financial adviser",4,"Legal, finance and accounting"]
["OCC0587","Internal audit practitioner","OCC0587 Internal audit practitioner",4,"Legal, finance and accounting"]
["OCC0869","Payroll assistant manager","OCC0869 Payroll assistant manager",5,"Legal, finance and accounting"]
["OCC1312","Legal technician ","OCC1312 Legal technician ",4,"Legal, finance and accounting"]
["OCC0487","Specialist rescue operative","OCC0487 Specialist rescue operative",4,"Protective services"]
["OCC0509","Police community support officer","OCC0509 Police community support officer",4,"Protective services"]
["OCC0516","Intelligence analyst","OCC0516 Intelligence analyst",4,"Protective services"]
["OCC0746","Fire safety inspector","OCC0746 Fire safety inspector",4,"Protective services"]
["OCC0747","Counter fraud investigator","OCC0747 Counter fraud investigator",4,"Protective services"]
["OCC0764","Non home office police officer ","OCC0764 Non home office police officer ",4,"Protective services"]
["OCC0878","Youth justice practitioner","OCC0878 Youth justice practitioner",5,"Protective services"]
["OCC0930","Anti-Social behaviour and community safety officer","OCC0930 Anti-Social behaviour and community safety officer",4,"Protective services"]
["OCC0236","Senior housing and property management","OCC0236 Senior housing and property management",4,"Sales, marketing and procurement"]
["OCC0311","Public relations and communications assistant","OCC0311 Public relations and communications assistant",4,"Sales, marketing and procurement"]
["OCC0313","Procurement and supply chain practitioner","OCC0313 Procurement and supply chain practitioner",4,"Sales, marketing and procurement"]
["OCC0325","Retail manager","OCC0325 Retail manager",4,"Sales, marketing and procurement"]
["OCC0572","Sales executive","OCC0572 Sales executive",4,"Sales, marketing and procurement"]
["OCC0596","Marketing executive","OCC0596 Marketing executive",4,"Sales, marketing and procurement"]
["OCC0683","Buying and merchandising assistant ","OCC0683 Buying and merchandising assistant ",4,"Sales, marketing and procurement"]
["OCC0883","Market research executive","OCC0883 Market research executive",4,"Sales, marketing and procurement"]
["OCC0039","Aviation operations manager ","OCC0039 Aviation operations manager ",4,"Transport and logistics"]
["OCC0337","Passenger transport operations manager","OCC0337 Passenger transport operations manager",4,"Transport and logistics"]
["OCC0427","Marine pilot","OCC0427 Marine pilot",5,"Transport and logistics"]
["OCC0428","Port marine operations officer","OCC0428 Port marine operations officer",4,"Transport and logistics"]
["OCC0595","Air traffic controller","OCC0595 Air traffic controller",5,"Transport and logistics"]

{"sheet":"Notes for officials","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"This tab does not need to be completed by the applicant, it is for officials to record some of their initial analysis"]
[]
["Step",null,"Notes"]
["A","Compare qualification structure template with the qualification structure in the programme specification: Note any discrepancies between these two such as: module title names; module codes; credit values; core or optional modules; full time vs part time structures"]
[]
["B","Are there any pathways? Do students enrol onto one qualification and then choose a pathway or do they enrol onto different qualifications which share modules between them."]
[]
["C","Mandatory vs optional modules. Are all modules mandatory? Are there modules not mapped to any KSBs? Are there lots of optional modules?"]
["C1","Where there are optional modules, how do students choose them?"]
[]
["D","Check if different delivery partners deliver this qualification:"]
["D1","if so, confirm if the structure of submitted qualification is the same for all of them or there are any discrepancies"]