MPDI Training Introduction - PowerPoint Presentation

Slide1

MPDI TrainingSlide2

Introduction

Welcome!

Let’s go around the room and introduce ourselves.OBJECTIVE: Today’s objective is to show you the new system and let you move around, enter data, and get acclimated to the new reporting application. Review AgendaBackground of the Change from ACS to MPDISystem Access and SecurityOverview of DashboardEmployee FTE ModuleMillages ModuleTuition and Fees ModuleBreakEnrollment ModuleExpenses ModuleRevenue ModuleNet Assets Module

2Slide3

Michigancc.net – outside vendor

Policy decision to move reporting from WDA to CEPI

Development of internally supported reporting application by DTMBConvene workgroup to discuss needed changes and designDesign online user interfaceImprove and update data manuals and instructionsRedesign, addition, elimination of tables System Testing 3Background of the Change from ACS to MPDIWhy are we doing this?... Slide4

4

System access and security

College President to designate/reaffirm Data CoordinatorData Coordinator – has full access to College’s siteDesignates users authorized to enter and save dataDesignates Submitter(s)

Designate Reviewer(s) (read only capability)

Only the Data Coordinator can certify College’s submission

Data Coordinator works with CEPI when issues are identified by either CEPI or the College

Access and Security Agreements must be completed for all (Coordinator, Data Entry, Submitters, and Reviewers) Slide5

5

Data collection timeframes

Tuition and Fees – July 2, 2018 – August 31, 2018Hard close date – no data entry allowed after end dateFull report of all colleges will not be published until collection period endsRemaining MCCDI Modules – August 1, 2018 – November 1, 2018

Hard close date - no data entry allowed after end date

Data Tables – under developmentSlide6

6

Dashboard

Welcome PagePage Set upModules across top – 7Click on Module name to navigateIndividual Modules listed down the page

Module Name

Status

Timestamp

Username

View History (Next Slide)

Action Radio KeySlide7

7

Dashboard – History screenSlide8

8

Employee fte

New Module – Did not look to previous way reported Request from ACS Committee to bring the reporting of FTE and Contracted Instruction back into Data Reporting.Reporting is by Overall Activity Classification Code (no sub-codes required)Instructional FTE This is a duplicated countExamples - Staff whose primary position is non-teaching but are also adjunct faculty will be counted as part-time in the instructional FTE and full-time in the non-instructional FTE in the appropriate activity classification code.. Faculty who teach in both credit and non-credit would be counted under both.

Contracted Instruction definition is in the MPDI manual.

Actual, paid positions only – not budgeted

Data is expected in both instructional (Activity Code 1.0) and non-instructional (2.0 – 7.0)

Any Zero entries will be a Data Quality check done by CEPISlide9

9

Valuation & Millages

Previous Screen:Millage and Taxable Value are on 1 screen broken out from Tuition and Fees and RevenueNow asking for voted and levied for all components of MillageData Rule – Levies cannot be more than voted

Taxable Value – will enter the Tax Levy for the year that the College’s Fiscal Year ends. i.e. Fiscal 2017-18 reporting will be the 2018 Levy amount.Slide10

10

Tuition and fees

Changes:Only requesting full year – what was approved for upcoming year at time of data entryNo longer have to report tuition rates during MCCDI reporting in the FallBillable hours was added as an option for primary method for charging tuitionData rulesAll data fields within the Tuition Charge section must be completed to allow submission.

If Other is chosen for primary method of charging tuition – have to include a description in explanation box

If Yes is answered on excess contact hours, have to include description in box

All tuition rates and fees must have a board approved date entered for each line

Ensure fees are entered in In-District, Out-of-District, and Out-of-State when applicable to all three residency types.Slide11

11

15 Minute BreakSlide12

12

enrollment

Changes:1.6 Human Development and 1.7 Personal Interest are now all in Activity Code 1.6 Personal Interest and Human DevelopmentAll inputs are on one screenDefinition of Occupational Contact Hours has been updated and is included in the glossary.Listing of Courses under each sub-classification is in the Appendix.Any questions regarding proper classification should be directed to CEPI for final determination.

Data rules

Number

of sections delivered has to be greater than or equal to the number of courses delivered.

Total duplicated student headcount for In-District and Out-of-District should be greater than the total unduplicated headcount

Total Occupational Contact Hours cannot be greater than the total Student Contact Hours

The data field for Occupational Contact Hours for sub-activity 1.6 will not allow data entry

Occupational Contact Hours recorded in 1.5 will have a Data Quality check by CEPISlide13

13

enrollment

REMINDERS --

Contact Hours are a measure of instructional contact, not billing contact hours

Credit Hours are a measure of instructional credit, not billing credit hours

Non credit instructional activity should be included in course, section, student and contact hour counts

COURSE TAXONOMY

Each college must have a taxonomy of courses indicating whether or not courses are occupational

OCCUPATIONAL CONTACT HOUR COUNTS

Course content determines eligibility for inclusion in occupational countsSlide14

14

expenses

Big Changes!1.6 Human Development and 1.7 Personal Interest are now all in Activity Code 1.6 Personal Interest and Human DevelopmentAll components are on one screenReporting Operating Funds as well as all other funds and elimination entries for an institutional total that should match institution Financial Statements2.0 Information Technology is added back into reporting4.0 Name change to Academic Support (was Instructional Support)

5.1 Name was shortened to Student Services

6.0 Name was changed to Institutional Support (was Institutional Administration)

7.0 Physical Plant Operation Total incorporated the reporting for Physical Plant Expenditures & Activity Measures under old ACS 7 into the Expenses Module

Interest and Depreciation added as 7.4 and 7.5

Data rules

Financial Statement Eliminations must be entered as a negative

Only positive numbers are allowed in all other data fields

Total Utility Costs must be greater than Water and Sewage amountsSlide15

15

revenues

Big Changes!State Appropriations from the Public Act (Operations, MPSERS UAAL, MPSERS Offset, and Ren Zone) are pre-populated in the Public Act Appropriations Section. If you note large discrepancies or do not agree with the amounts, contact CEPI.All components are on one screenComponents of Revenue broken out into more categories to better align with Financial StatementsReporting Operating Funds as well as all other funds and elimination entries for an institutional total that should match institution Financial StatementsData rules

Financial Statement Eliminations must be entered as a negative.

Only positive numbers are allowed in all other data fields

Certain data fields are greyed out as no data is expected in those fund typesSlide16

16

Net position

New ModuleAdded for Benchmarking and ComparisonsAdded for Fiscal Agency use in analysis of Debt and other areasProvided a mechanism for reporting the impact of GASB and reporting CFI scoresReporting will be available to the Colleges and State Agencies but will not be a public facing table in the Data Book.Will enter data for:Operating Funds (General and Designated Funds)

Impacts of GASB

All Other Funds

Greyed out data fields when no data is expected. Contact CEPI if your reporting does not align.Slide17

17

Output/tables

The Workgroup reviewed all the Data Tables - made changes, added, and eliminated some tablesData Tables will be available to colleges in the MPDI applicationThe Companion Databook will be available on MI School Data websiteNo historical information will be brought forward as the new reporting requirements have been significantly changedThe resulting tables and reporting continue to be developed by CEPI and DTMBSlide18

Questions/Feedback

Further Questions? Email:

Rachel Edmondson (EdmondsonR2@michigan.gov) Lisa Mazure (Pratt6@lcc.edu) 18Wrap Up

Thank You