800 likes | 825 Views
EFIS 2.0 School Board Training. March 17 th to 26th. User Training for EFIS 2.0 Introduction. EFIS 2.0.
E N D
EFIS 2.0 School Board Training March 17th to 26th
User Training for EFIS 2.0 Introduction
EFIS 2.0 Centralized planning and budgeting application that supports fund and grant management within the Ministry of Education. Application is developed using Oracle Hyperion Planning technology – commonly referred to as “Planning”. Web based application for data entry, grant calculation, reporting and workflow management. Integrated into Microsoft Office suite of products with emphasis on integration with Excel.
Training Overview • Two training applications will be used: • Module 1 to 3 will use a simplified application containing only a few EFIS forms • Module 4 to 8 will use a more detailed application similar to what you will see in EFIS 2.0
Training Overview Training Modules • Basic Planning through Workspace • Basic Planning through Smart View • Advanced Planning through Smart View • Overview and Data Input • Data Validation • Versioning • Sign-off and Approvals • Mid Cycle Change
Training Overview Components of training modules: • Module Overview • Follow-me: Hands-on exercise presentation • User Hands-on Exercise • Documentation hand-outs (Reference Sheet, Hands-on Exercise, Hands-on Exercise Solutions)
Task List EFIS 1.0 – All-in-one forms (i.e. input, result and explanation of calculation all on one form) EFIS 2.0 – Input, result and explanation of calculation are separated and organized in a task list.
Historical Data EFIS 1.0 will not be available from October, 2014 for school boards EFIS 2.0 will contain 2013/14 Estimates, Revised Estimates active versions Boards are encourage to print PDF of submissions from EFIS 1.0 if they want to keep a record FO/FA will provide printed PDF of 12/13 Financial Statements FO submission to boards if adjustment is made in or after October, 2014.
Basic Planning through Workspace Module The Planning through Workspace module overview will focus on the following major user elements: • Login • Task Lists • Input • Report • Results
Planning through Workspace Login • Log into workspace through the URL • Workspace URL– See reference Sheet • After logging in, you can open the application through four different methods: • Navigate -> Application -> Planning -> TRAIN1 • File -> Open -> Applications - > Planning -> TRAIN1 • Recently opened • Quick links
Planning through Workspace My Task List • Task Lists are used to organize user input, calculation and review process (similar to suggested order of entry in EFIS 1.0) • Web forms are used for data entry and data review • Financial Reports are used for standard reporting
Planning through Workspace Input • In order to input data, user click on an input cell and use the keyboard to input your data • To navigate between cells, in addition to mouse navigation, the keyboard can be utilized: • Tab – move selected cell to next cell in horizontal order • Shift + Tab – move selected cell backwards, in horizontal order • Enter – move to the next cell
Planning through Workspace Report By selectingExercise 1 – Report from the Task List you will see a PDF version of a report generated from results, driven by your Input. The report will open in its own tab.
Planning through Workspace Results • By selecting Exercise 1 -Results, you will be able to review the results generated by the calculation, driven by your Input values. If you wish to make any changes or alterations to the Results, navigate back to the Input Form.
Basic Planning through Smart View Hyperion Planning is integrated with Microsoft Excel through Smart View Performs same tasks as Hyperion Planning. Users can view planning data forms within Excel with the same functionality An alternative ‘window’ on the data - more intuitive for those familiar with Excel Main tasks: Input data, review results
Basic Planning through Smart View • Main tasks: Input data, review results • In the exercise, we will demonstrate: • Connecting to Hyperion Planning • Opening forms from task lists • Entering data into the input form • Calculating values after data submission • Reviewing data in result form (all read-only cells)
Planning through Smart ViewConnection • Open Microsoft Excel • Under the Smart View tab, clickPanel and go to Shared Connections • Connect to Oracle Hyperion Planning
Planning through Smart ViewInput Open an application and task list Open input form by double-clicking Choose POV and refresh White / Yellow coloured cells: Input cells Grey cells: read-only cells Enter data and submit data (Calculate values)
Planning through Smart ViewResults Open result form to review and verify all data All cells are greyed out (read-only) in the result form. To modify the data, return to the input form
Advanced Smart View • As mentioned before, Smart View allows for all the same functionality as Workspace through Excel • Advantage of using Smart View comes when inputting data and using the existing functionality available in Excel
Advanced Smart View • Highlight of advantages • Copy / Paste
Advanced Smart View • Highlight of advantages • Formulas
Advanced Smart View • Highlight of advantages • Linking data
Advanced Smart View • Highlight of advantages • Saving forms and submitting at a later point
EFIS 2.0 Overview Certain processes in EFIS 2.0 differ from how they were done in EFIS 1.0 Just like the prior exercises demonstrated EFIS 2.0 is organized using Task Lists Task Lists are a logical grouping of tasks with a suggested order required to complete the submission
EFIS 2.0 Overview Data Input • EFIS 2.0 vs. EFIS 1.0 • Combined input in some areas • Input for all Sections is combined on one form, divided into many tabs • Input for Data Forms B, C, and D is combined on another form, with separate tabs • Input for most Appendices also combined onto one form, with separate tabs • Should result in faster data entry
EFIS 2.0 Overview Data Input • EFIS 2.0 vs. EFIS 1.0 • Schedule 3 now divided into several separate schedules:
EFIS 2.0 Overview Data Input • EFIS 2.0 vs. EFIS 1.0 • Schedule 5.5 now tracks committed capital projects for both depreciable assets and land • In EFIS 1.0, Schedule 5.6 had a section for tracking committed land projects • EFIS 2.0 has combined all committed capital projects on one page, Schedule 5.5 page 1
EFIS 2.0 Overview Data Input • EFIS 2.0 vs. EFIS 1.0 • Schedules 10, 10.1 and 10.2 • In EFIS 1.0, most expense data was entered on Schedules 10.1 (Elementary) and 10.2 (Secondary), then the sum was calculated on Schedule 10 • In EFIS 2.0, boards will enter total expense data directly on Schedule 10, then enter the Secondary portion on Schedule 10.2; the difference is then calculated on Schedule 10.1
EFIS 2.0 Overview Data InputSchedule 10 Expenses Option 1 Option 2
EFIS 2.0 Overview Data InputTemporary Accommodation • Operating Expenses moved from Schedule 3 to Allocations Section 11
EFIS 2.0 Overview Data InputTax Revenue • Section 14 and Schedule 11A on one form with multiple tabs
EFIS 2.0 Overview Data InputPrior Year Data • Prior Year data is loaded into cells that can be updated, no more adjustment cell in most cases. These cells are in blue.
EFIS 2.0 Overview Data InputWarning Description • Warning Descriptions are now input in EFIS 2.0. Submission can not be promoted until Warning Descriptions are entered.
EFIS 2.0 Overview Task Lists • EFIS 2.0 vs. EFIS 1.0 • Appendix C no longer exists • School Level Enrolment Data is now entered directly into School Level Enrolment – Input form
EFIS 2.0 Overview Task Lists • EFIS 2.0 vs. EFIS 1.0 • Appendix C no longer exists • Calculated results can be seen in the Detail results for each related form – e.g. Section 1.3
EFIS 2.0 Overview Data InputSchool Level Data • FTE, Number of Staff entered at school level
EFIS 2.0 Overview Data InputBoard Level Data • Number of Full-Time & Part-Time pupils, High Credit Full-Time & Part-Time FTE, and Independent Study ADE is entered at board level
EFIS 2.0 Overview Task Lists • EFIS 2.0 vs. EFIS 1.0 • New concept: Reference Data • Includes any pre-loaded data such as: • Benchmarks • Notional Shares • Table Amounts • Approved Amounts
EFIS 2.0 Overview Task Lists Task List Overview • Input • Reports • Results • Reference Data • Validation Formats • Submission Management
EFIS 2.0 Overview Task Lists • Input • Allows for input of data • Enrolment Data • Allocations • Appendices • Schedules • Data Forms
EFIS 2.0 Overview Task Lists • Reports • Show final results of calculated submission • Mimic EFIS 1.0 reporting structure • Formatted to output in PDF
EFIS 2.0 Overview Task Lists • Results • Used as a “Quick View” of results generated by calculation of submission • Shows calculated results, without the supporting details that the report provides
EFIS 2.0 Overview Task Lists • Reference Data • Shows all pre-loaded data that is used to calculate submission • Will be discussed in more detail in a later exercise
EFIS 2.0 Overview Task Lists • Validation Formats • Validation format form exists for each input form in the application • Dictates which cells should allow input and which cells should be locked on input forms • Dictates the validation rules for input data of each input cell