1 of 50

Michigan Data Hub�Vendor Update�August 2022�

Don Dailey, Director – Kevin Bullard, Support Manager – Dirk Bradley, Operations Manager

Tim Davis, Vendor Relations – Windee Wagner, Tier 1 Support Specialist

2 of 50

Agenda�

  • Welcome and overview of agenda
  • 2022-2023 Plans
  • MSDS Reporting Plans
  • Implementation of Michigan Services
  • Data Needs
  • Enrollment Transfer and Concurrent Enrollment Processes
  • Data Quality
  • Management Portal
  • Q&A

​

3 of 50

2022-2023 Plans

  • No Ed-Fi version updates – sticking with v3.1 for the year
  • Minimal changes to descriptors
  • Data Governance and Data Quality focus
    • Dynamic Data Dictionary
    • Product Profile Definition Collection
  • Management Portal Plans
  • MSDS Reporting Emphasis

4 of 50

MSDS Reporting Plans

  • The ability to generate MSDS from MiDataHub has been a goal since inception
  • In the 21-22 school year, 16 Skyward Qmlativ districts completed MSDS submissions from MiDataHub, with plans to continue for 22-23
    • General Collection
    • TSDL
    • Third Grade Retention
  • Testing of additional submissions from MiDataHub
    • Early Childhood
    • Early Roster
    • Student Record Maintenance (SRM)

5 of 50

Benefits of MSDS Reporting from MiDataHub

  • Eliminates dual work by no longer having to do both XML files and Ed-Fi data submission
  • MiDataHub serves as a great merge location for data from other systems, like Special Education
  • Vendor focus can shift to ensuring improved data flow and quality to MiDataHub
  • Allows data quality checking to occur early and often, rather than just during count periods, allowing for better data quality all year round

6 of 50

MSDS Reporting Tools

  • Descriptor Mapping – Provides the ability to indicate which descriptor values tie to which state required values
  • Error Check – Checks submission data against CEPI rules. When paired with Alert functionality, a district can get an email any time there are data issues.
  • MSDS Reports – Patterned after CEPI reports, these reports provide a preview of what the data will look like when uploaded to CEPI and are helpful for troubleshooting.
  • File Generation – Creates the XML file structure currently accepted by CEPI
  • File Comparison – Provide a comparison of data in MiDataHub to a vendor’s separately produced XML file. Excellent for validating completeness of integration.
  • Count Day Data Management – For a select number of fields where data cannot be determined to have occurred on or before count date, this allows a user to select which value is used for reporting when a change occurs within the count window.
  • As-of-Date Override Management – Allows a district to override the established MSDS count dates due to factors such as weather delays

​

7 of 50

CEPI Plans and Hopes for MiDataHub MSDS Reporting

  • Trina Anderson, Director, Office of Integration & Support, CEPI
  • Joel Thiele, PK-12 Student Services Manager, CEPI

8 of 50

MSDS Next Steps

  • 2022-23 CEPI Mappings Documents are available on the Vendor Resources page
  • Ensure that your SIS is able to send all data needed for state reporting
  • Work to pilot 1-2 districts for parallel submission testing of the process
  • Based on piloting work, identify when it makes sense to begin promoting the process to districts

9 of 50

Implementation of CEPI Services

  • Adding a Match Status to UIC Services (/identities/searchv2)
    • Will be added to 8.22 sprint, so it should be available by sometime in September
  • Snackpack – Ability to look up data for a new student from the last district attended according to CEPI records
    • /identities/snackpack
    • /identities/snackpack/extended – Includes version to be returned
  • Direct Certification Services
    • /identities/directcert/student – Get Direct Certification information for one or more students
    • /identities/directcert/entity – Get all Direct Certification information for the entity of the calling client.

10 of 50

11 of 50

12 of 50

13 of 50

14 of 50

Student Snack-Pack

Portable Student Records

14

Backpack

Lunchbox

Snack-Pack

15 of 50

Snack-Pack Version 1: Variables & Option Sets

15

Variable Name

Possible Values

Days Attended, Total Possible Attendance

Numbers

District Exit Status

MSDS Collected Values

Economically Disadvantaged

Yes/No

English Learner Eligible

Yes/No

EL Instructional Program

MSDS Collected Values

Foster Care

Yes/No

Grade

MSDS Collected Values

Homeless

Yes/No

Migrant

Yes/No

Previous School District

5-digit state-assigned district code

Variable Name

Possible Values

Program Participations

MSDS Collected Values

Special Education Participant - Most recent IEP/Plan Date

Date

Special Education Participant - Primary Disability

MSDS Collected Values

Special Education Participant - Program Service Code

MSDS Collected Values

Special Education Participant - Program Service Name

MSDS Collected Values

As of Date

Date

Previous School was CEP

Yes/No

16 of 50

Snack-Pack Version 2: Variables & Option Sets

16

Variable Name

Possible Values

District Exit Date

Date

Early Childhood Program

MSDS Collected Values

End of Term Status

MSDS Collected Values

English Learner Exit Date

Date

General Education FTE

Number

Home Language

MSDS Collected Values

Previous School District Name

String

Variable Name

Possible Values

Primary Language

MSDS Collected Values

Reading Deficiency Identified

Yes/No

Section 52 FTE

Number

Section 53 FTE

Number

Special Education Exit Date

Date

State English Learner Exit Date

Date

Total Number of Days Removed

Calculated Number

17 of 50

Direct Certification�MI Data Hub integration

17

18 of 50

Direct Certification – MI Data Hub Integration

18

Provide users of Food Service Systems the ability to:

  1. perform a single-student lookup to determine eligibility and
  2. retrieve the report of eligible students (i.e. Direct Cert report) directly within their system

​

Benefits:

  • Eliminates the need to login to a state system, download and import
  • Minimizes files with sensitive data residing on local computer/networks
  • Allows districts to determine eligibility as soon as a new student is enrolled

19 of 50

Direct Certification – 2 options:

19

Single Student Direct Cert Lookup

  • An authorized FSS district user will be able to search CEPI’s direct cert data to determine whether a child is eligible for free/reduced meals via direct certification.

Report of Direct Cert Eligibility

  • An authorized FSS district user will be able to request data from the most recently updated Direct Certification report for their district. This report contains all students directly certified to receive free/reduced meals.

20 of 50

Direct Certification – variables and option sets:

20

OUTPUT NAME

Field

Option Sets

IdentificationCode

UIC

10-digit number, including leading zeros

SchoolID

School Facility Number

5-digit number, including leading zeros

StudentUniqueID

Local Student ID

Alpha-numeric, up to 50 characters

DirectCertificationEligibilityDHHSCategory

Eligibility Category

SNAP, �TANF, �Foster Care, �Medicaid Free,�Medicaid Reduced

ExitWithdrawDate

District Exit Date

Date (MM/DD/YYYY)

DirectCertificationEligibilityBeginDate

Eligibility Date

Date (MM/DD/YYYY)

21 of 50

22 of 50

Education matters. Discover what’s working in Michigan.

Thank You.

23 of 50

CEPI Services

24 of 50

Implementation of MDE Services

  • MDE has updated the assessment services API to provide to the district ODS
    • M-STEP
    • PSAT
    • SAT
  • Multiple years of data are provided for these resources
  • WIDA and MiAccess are next in line and are expected in the 22-23 school year
  • Mapping documents exist for the existing assessments on www.midatahub.org vendor resources page

25 of 50

Data Needs – Data to be Provided

  • GPA information in StudentAcademicRecords resource (previously covered)
    • CumulativeGradePointAverage
    • SessionGradePointAverage
    • Any other credit fields that can be provided
  • StudentPreRegistration Information
    • Course Requests
    • Next Year School
  • Digital Equity (provided as studentIndicators collection of studentEducationOrganizationAssociation

​

26 of 50

27 of 50

28 of 50

29 of 50

Digital Equity Data Collection

​

30 of 50

Data Needs – Data to be Consumed

  • Districts desire to use the following data back in their SIS, dashboard systems and other places:
    • Assessment data, include M-STEP, SAT, PSAT, DRC, Acadience, i-Ready, NWEA, Star and more\
    • SWIS Referral Data – Discipline Incident, Discipline Action Taken and Student Discipline Incident Association
    • Special Education Data
      • PCG now able to provide data for state reporting
      • Illuminate Special Education (ISE) completing work to provide data for state reporting

31 of 50

Enrollment Transfer and Concurrent Enrollment Processes�

  • Relies on Michigan Data Exchange Architecture
  • Districts must opt into record sharing
  • Result will be composite of Ed-Fi resources – schema TBD
  • Enrollment Transfer is for the case where a student moves from one district to another
  • Concurrent Enrollment is for the case where a student is enrolled in a primary district/school and concurrently enrolled in a program with a separate entity (an ISD often)
    • Program entity would like up-to-date enrollment and demographics info
    • Primary educating entity would often like attendance and grades

32 of 50

33 of 50

34 of 50

35 of 50

36 of 50

37 of 50

38 of 50

Data Quality

  • Most common issue in 2021-22, studentEducationOrganizationAssociation not provided for students fully enrolled
    • This leaves out identificationCodes, Gender, Race, Languages, Address, Phone, Email
  • Another major issues is when a student is added with an incorrect identifier (PIC or district student number), and the student is re-sent with the corrected value, the original student is not removed and sometimes gets attached to other data
    • Use Delete operation of Student resource to perform cascading delete
  • StudentUniqueId – UIC preferred value
  • Descriptor Management

39 of 50

Management Portal

  • Work is in progress on the portal
  • It will allow vendors to:
    • Log into the portal
    • Define and manage products/integrations
    • Provide documentation
    • Access key/secret data where permitted
    • Access SFTP data where permitted
    • Run data quality error check reports where defined
    • Eventually SSO options may also be available
  • Some of these features may come at a cost to use and/or customize

40 of 50

41 of 50

42 of 50

43 of 50

44 of 50

45 of 50

46 of 50

47 of 50

48 of 50

49 of 50

Q/A

50 of 50

More Information:

Michigan Data Hub

Kalamazoo RESA, Fiscal Agent

1819 E. Milham Road

Portage, MI 49002

​

Don Dailey Dirk Bradley Kevin Bullard Tim Davis

Project Manager Operations Manager Support Manager Outreach Coordinator

Cell: 269-217-4427 Cell: 269-267-8632 Cell: 269-910-5343 Cell: 231-342-5407

Ddailey@gomaisa.org dirk.Bradley@kresa.org Kevin.Bullard@kresa.org tdavis@gomaisa.org

​

Windee Wagner

Tier I Support Specialist

Windee.Wagner@kresa.org

support@midatahub.org

​

http://www.midatahub.org