{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Header","Introduction","Training Scope","Business Area 1","Business Area 2","Lists DO NOT EDIT"],"not_rendered":{"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Header","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[4,1,4,4],[7,1,7,7],[11,1,11,2]]}
[]
[null,"Training Needs Analysis"]
[null,"<enter phase/wave/drop as required>",{"$nulls":3},"ADD ANY LOGO/BRANDING"]
[null,"<Enter customer/company name>"]
[]
[]
[null,"Purpose"]
[null,"The purpose of this document is to outline the scope and training curriculum for <project name>, mapped to audiences, roles and courses for <e.g. business areas of customer>"]
[]
[null,"Document Control"]
[]
[null,"Change Record"]
[]
[null,"Author","Date","Version","Change Reference"]
[{"$nulls":3},0.1]
{"$rows_empty":12}
[null,"Reviewers"]
[]
[null,"Name","Position","Date"]

{"sheet":"Introduction","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"merged":[[2,0,2,1],[4,0,4,1],[5,0,5,5],[6,0,6,6],[7,0,7,1],[10,0,10,13],[11,0,11,13],[12,0,12,13],[14,0,14,3],[16,0,17,1],[16,2,17,6],[18,0,18,1],[18,2,18,6],[19,0,19,1],[19,2,19,6],[20,0,20,1],[20,2,20,6],[21,0,21,1],[21,2,21,6],[22,0,22,1],[22,2,22,6],[23,0,23,1],[23,2,23,6],[24,0,24,1],[24,2,24,6],[26,0,26,6],[27,0,27,6]]}
[]
["Scope"]
["The scope of this TNA is to cover the <name of customer/ business area> "]
[]
["How to Follow this Guide"]
["The Training Scope Tab provides a landscape of the Business areas, the training Courses and the modules contained within each course"]
["The brown tabs represent each workstream area containing only content relevant to that workstream. This is a template so duplicate and change tab names as required per project"]
["As the TNA review is conducted, all tabs will be updated accordingly"]
[]
["Methodology"]
["This document will be used to validate the scoping from the change/program team. When complete this will confirm the scope of the training design. Any changes to this after sign off will be subject to a change request"]
["Training will be mapped to users who have the correct Oracle System Roles (security access) to perform the steps. This has been grouped in Functional \"Business\" Roles which the training maps to."]
["Classroom and/or Virtual Classroom training courses will include hands on practice exercises for the users to be familiar with the Oracle process"]
[]
["The completion of the TNA is subject to dependencies and risks.  <add to the list as required per project>"]
[]
["Example Dependencies",null,"Example Risks"]
[]
["Role Mapping is complete (Business roles to Oracle System roles) by the business and a TOM (Target Operating Model) is available for reference",null,"If the role mapping is not compete, the courses cannot be mapped to the roles"]
["Business SMEs are available to assist with TNA",null,"Non availability of SMEs will result in delay of completed TNA"]
["Oracle configuration solution is stable",null,"Continuous changes will affect the accuracy of the TNA and potential delays for completion"]
["Process Maps are available",null,"If process maps are not defined then the training cannot be mapped correctly "]
[]
[]
[]
[]
["<If the programme has identified any Key Business Scenarios, use these to ensure the TNA is aligned to vision of the programme and other activities like UAT>"]
["Example Business Scenarios - The following are the key End to End Business Scenarios for which the training must cover. "]

{"sheet":"Training Scope","index":2,"n_rows":23,"n_cols":15,"rows_kept":23,"merged":[[0,0,0,16],[1,0,1,16],[3,0,4,0],[3,2,4,3],[3,5,4,6],[3,8,4,9],[3,11,4,12],[3,14,4,15],[5,2,5,3],[5,5,5,6],[5,8,5,9],[5,11,5,12],[5,14,5,15],[6,2,6,3],[6,5,6,6],[6,8,6,9],[6,11,6,12],[6,14,6,15],[7,5,7,6],[7,8,7,9],[7,11,7,12],[7,14,7,15],[8,5,8,6],[8,8,8,9],[8,11,8,12],[8,14,8,15],[10,2,10,3],[10,5,10,6],[10,8,10,9],[10,11,10,12],[10,14,10,15],[11,2,11,3],[11,5,11,6],[11,8,11,9],[11,11,11,12],[11,14,11,15],[12,2,12,3],[13,5,13,6],[13,8,13,9],[13,11,13,12],[13,14,13,15],[14,2,14,3],[14,5,14,6],[14,8,14,9],[14,11,14,12],[14,14,14,15],[15,2,15,3],[15,5,15,6],[15,8,15,9],[15,11,15,12],[15,14,15,15],[16,2,16,3],[16,5,16,6],[16,11,16,12],[16,14,16,15],[17,5,17,6],[17,8,17,9],[17,14,17,15],[18,8,18,9],[18,11,18,12],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[20,5,20,6],[20,11,20,12],[20,14,20,15],[21,5,21,6],[21,11,21,12],[21,14,21,15],[22,5,22,6]]}
["Use this as a template for workstreams, course and module names etc. Edit and delete as required."]
["Training Scope"]
["LEGEND"]
["Business Process Area/Workstream",null,"Introduction and Overview",null,null,"Business Process Area/Workstream",null,null,"Business Process Area/Workstream",null,null,"Business Process Area/Workstream",null,null,"Business Process Area/Workstream"]
[]
["Course Groups\n(Classroom Courses)",null,"Course Groups\n(Classroom Courses)",null,null,"Course Groups\n(Classroom Courses)",null,null,"Course Groups\n(Classroom Courses)",null,null,"Course Groups\n(Classroom Courses)",null,null,"Course Groups\n(Classroom Courses)"]
["Modules",null,"Modules",null,null,"Modules",null,null,"Modules",null,null,"Modules",null,null,"Modules"]
["Out of scope for <this phase>",{"$nulls":4},"Out of scope for <this phase>",null,null,"Out of scope for <this phase>",null,null,"Out of scope for <this phase>",null,null,"Out of scope for <this phase>"]
["Out of Scope for <project>",{"$nulls":4},"Out of Scope for <project>",null,null,"Out of Scope for <project>",null,null,"Out of Scope for <project>",null,null,"Out of Scope for <project>"]
[]
[null,null,"Course 1",null,null,"Course 1",null,null,"Course 1",null,null,"Course 1",null,null,"Course 1"]
[null,null,"Module1",null,null,"Module1",null,null,"Module1",null,null,"Module1",null,null,"Module1"]
[null,null,"Module 2"]
[{"$nulls":5},"Course 2",null,null,"Course 2",null,null,"Course 2",null,null,"Course 2"]
[null,null,"Course 2",null,null,"Module1",null,null,"Module1",null,null,"Module1",null,null,"Module1"]
[null,null,"Module1",null,null,"Module 2",null,null,"Module 2",null,null,"Module 2",null,null,"Module 2"]
[null,null,"Module 2",null,null,"Module 3",{"$nulls":5},"Module 3",null,null,"Module 3"]
[{"$nulls":5},"Module 4",null,null,"Course 3",{"$nulls":5},"Module 4"]
[{"$nulls":8},"Module1",null,null,"Course 3"]
[{"$nulls":5},"Course 3",null,null,"Module 2",null,null,"Module1",null,null,"Course 3"]
[{"$nulls":5},"Module1",{"$nulls":5},"Module 2",null,null,"Module1"]
[{"$nulls":5},"Module 2",{"$nulls":5},"Module 3",null,null,"Module 2"]
[{"$nulls":5},"Module 3"]

{"sheet":"Business Area 1","index":3,"n_rows":18,"n_cols":21,"rows_kept":18,"merged":[[0,11,0,17],[3,1,5,1],[3,2,5,2],[3,7,5,7],[3,8,5,8],[3,9,5,9],[6,1,8,1],[6,2,8,2],[6,7,8,7],[6,8,8,8],[6,9,8,9],[9,1,10,1],[9,2,10,2],[9,7,10,7],[9,8,10,8],[9,9,10,9],[12,0,17,0],[12,1,17,1],[12,2,12,3],[12,4,17,4],[12,5,17,5],[12,6,17,6],[12,7,17,7],[12,8,17,8],[12,9,17,9],[12,10,17,10],[12,11,12,17],[12,18,17,18],[12,19,17,19],[12,20,17,20]]}
[{"$nulls":11},"What assets are required to be developed per module "]
["Subject Matter Expert (SME)/Business Process Owner (BPO)","Business Stakeholders","Training Course  -  Process Level 3"," Module - Process Level L4","Business Roles","Process Map Link","Key Learning Objectives","Numbers to be trained","Type of Training","Duration of Training\n(hours or days)","If Classroom - What exercises are required?","Exercise workbook","PowerPoint Presentation","Quick Reference Guides","Video Storyboard and Video","Job Aids","Simulations","E-learning","\nAny Pre-requisites? \n(State - e.g. Navigation or previous module in this workstream)\n","Any translation required? If yes, state language.\n","Notes - e.g. any data requirements for exercises"]
[null,null,"Introduction to Procurement","Introduction to Procurement"]
[null,null,"Self Service Procurement","Raising a Catalog Requisition"]
[{"$nulls":3},"Raising a Non Catalog Requestion"]
[{"$nulls":3},"Using Smart Forms"]
[null,null,"Receipting Goods and Services","Receipting Goods"]
[{"$nulls":3},"Receipting Services"]
[{"$nulls":3},"Managing Damaged Items"]
[null,null,"etc etc "]
[]
[]
["List the person/s you are completing the TNA with. The terminology will change per project but could be SMEs or BPO etc.\n\nThis could be per module or course, so split or merge cells as required.","List the Business Stakeholders as identified in the project.  These maybe the final reviewers or a role where only sight of material is required and they designated the sign off to SME/BPO","DEFINITION OF PROCESS LEVELS",null,"List business roles to be mapped to the module. The System Implementers are usually responsible for the Mapping of Oracle System roles to Business Roles. Ensure have you have access for reference.\n\nIf a module is being delivered more than once, because of different audiences this column should have split cells so the mapping is correct for each version of the course/module.\n\n","Include a link to the process map documentation.  This must be available to ensure the  processes are mapped to the correct module.","High level from SME/BPO at this point. (If system design or config is not finalised it may not be possible to write accurate objectives).\n\nTo be discussed and then the detailed and final versions must be included in the module outlines.","Enter the numbers to be trained per course/module.\n\nBe aware that there maybe individual modules being delivered, so if these have been identified (as per role mapping) this must  be identified too.\n\nIf the modality is Video, then numbers do not need to be identified.","Agree with SME/BPO how the course/module is going to be delivered.  There may already be a project driven directive for classroom, but consider all options especially for geographically diverse audiences.  \n\nIf delivering via Teams/Zoom etc. keep sessions short to aid learning and participation and never have more than one module per session. ","Be flexible, if using hours, don’t schedule too many in one day. E.g. 3x2hr sessions would be the maximum for one day.","Agree with the SME/BPO what exercises need to be included in the workbook. These must be mapped to the level  5 processes to allow users to get hands on practice of the processes they will be performing when live.\n\nMake a note of data requirements that will be required. (col U can be used if necessary)","Mark what is needed Y/N and as this is a template delete/hide any columns that are not required",{"$nulls":6},"List any pre-requisite courses of videos that attendees of each module should have completed. \n\nE.g. Navigation or if the courses are in a sequential flow - ensure the predecessors are listed. ","Note what, if any, asset translation is required.  Be aware of deadlines as adequate time must be allowed for this exercise. ","Use this column to capture any points that arose during discussions. \n\nCan also be used to note any data requirements for exercises etc. "]
[null,null,"Level 5 - Module hands on exercises","To allow the practice and execution of processes by the appropriate users (according to role mapping)"]
[null,null,"Level 4 - Workbook/Module","There maybe multiple versions of a module as it is role dependent.. If a particular role group only need this module but not the others in the course group then it must be identified as a separate stand alone course deliverable"]
[null,null,"Level 3 - Course","A deliverable of one or many modules grouped together by roles"]
[null,null,"Level 2 - Workstream","The business area the process training relates to."]
[null,null,"Level 1 - ERP/EPM/HCM etc (product)","The Oracle (or other) product being used "]

{"sheet":"Business Area 2","index":4,"n_rows":18,"n_cols":21,"rows_kept":18,"merged":[[0,11,0,17],[3,1,5,1],[3,2,5,2],[3,7,5,7],[3,8,5,8],[3,9,5,9],[6,1,8,1],[6,2,8,2],[6,7,8,7],[6,8,8,8],[6,9,8,9],[9,1,10,1],[9,2,10,2],[9,7,10,7],[9,8,10,8],[9,9,10,9],[12,0,17,0],[12,1,17,1],[12,2,12,3],[12,4,17,4],[12,5,17,5],[12,6,17,6],[12,7,17,7],[12,8,17,8],[12,9,17,9],[12,10,17,10],[12,11,12,17],[12,18,17,18],[12,19,17,19],[12,20,17,20]]}
[{"$nulls":11},"What assets are required to be developed per module "]
["Subject Matter Expert (SME)/Business Process Owner (BPO)","Business Stakeholders","Training Course  -  Process Level 3"," Module - Process Level L4","Business Roles","Process Map Link","Key Learning Objectives","Numbers to be trained","Type of Training","Duration of Training\n(hours or days)","If Classroom - What exercises are required?","Exercise workbook","PowerPoint Presentation","Quick Reference Guides","Video Storyboard and Video","Job Aids","Simulations","E-learning","\nAny Pre-requisites? \n(State - e.g. Navigation or previous module in this workstream)\n","Any translation required? If yes, state language.\n","Notes - e.g. any data requirements for exercises"]
[null,null,"Introduction to Procurement","Introduction to Procurement"]
[null,null,"Self Service Procurement","Raising a Catalog Requisition"]
[{"$nulls":3},"Raising a Non Catalog Requestion"]
[{"$nulls":3},"Using Smart Forms"]
[null,null,"Receipting Goods and Services","Receipting Goods"]
[{"$nulls":3},"Receipting Services"]
[{"$nulls":3},"Managing Damaged Items"]
[null,null,"etc etc "]
[]
[]
["List the person/s you are completing the TNA with. The terminology will change per project but could be SMEs or BPO etc.\n\nThis could be per module or course, so split or merge cells as required.","List the Business Stakeholders as identified in the project.  These maybe the final reviewers or a role where only sight of material is required and they designated the sign off to SME/BPO","DEFINITION OF PROCESS LEVELS",null,"List business roles to be mapped to the module. The System Implementers are usually responsible for the Mapping of Oracle System roles to Business Roles. Ensure have you have access for reference.\n\nIf a module is being delivered more than once, because of different audiences this column should have split cells so the mapping is correct for each version of the course/module.\n\n","Include a link to the process map documentation.  This must be available to ensure the  processes are mapped to the correct module.","High level from SME/BPO at this point. (If system design or config is not finalised it may not be possible to write accurate objectives).\n\nTo be discussed and then the detailed and final versions must be included in the module outlines.","Enter the numbers to be trained per course/module.\n\nBe aware that there maybe individual modules being delivered, so if these have been identified (as per role mapping) this must  be identified too.\n\nIf the modality is Video, then numbers do not need to be identified.","Agree with SME/BPO how the course/module is going to be delivered.  There may already be a project driven directive for classroom, but consider all options especially for geographically diverse audiences.  \n\nIf delivering via Teams/Zoom etc. keep sessions short to aid learning and participation and never have more than one module per session. ","Be flexible, if using hours, don’t schedule too many in one day. E.g. 3x2hr sessions would be the maximum for one day.","Agree with the SME/BPO what exercises need to be included in the workbook. These must be mapped to the level  5 processes to allow users to get hands on practice of the processes they will be performing when live.\n\nMake a note of data requirements that will be required. (col U can be used if necessary)","Mark what is needed Y/N and as this is a template delete/hide any columns that are not required",{"$nulls":6},"List any pre-requisite courses of videos that attendees of each module should have completed. \n\nE.g. Navigation or if the courses are in a sequential flow - ensure the predecessors are listed. ","Note what, if any, asset translation is required.  Be aware of deadlines as adequate time must be allowed for this exercise. ","Use this column to capture any points that arose during discussions. \n\nCan also be used to note any data requirements for exercises etc. "]
[null,null,"Level 5 - Module hands on exercises","To allow the practice and execution of processes by the appropriate users (according to role mapping)"]
[null,null,"Level 4 - Workbook/Module","There maybe multiple versions of a module as it is role dependent.. If a particular role group only need this module but not the others in the course group then it must be identified as a separate stand alone course deliverable"]
[null,null,"Level 3 - Course","A deliverable of one or many modules grouped together by roles"]
[null,null,"Level 2 - Workstream","The business area the process training relates to."]
[null,null,"Level 1 - ERP/EPM/HCM etc (product)","The Oracle (or other) product being used "]

{"sheet":"Lists DO NOT EDIT","index":5,"n_rows":5,"n_cols":4,"rows_kept":5}
["Subject Matter Expert (SME)/Business Process Owner (BPO)","Business Stakeholders","Type Of Training","Various Columns"]
[null,null,"Onsite Classroom","Yes"]
[null,null,"Remote Virtual Classroom","No"]
[null,null,"Video","TBC"]
[null,null,"Town Hall/Presentation"]