streamlining data usage in michigan using ed fi
TRANSCRIPT
![Page 1: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/1.jpg)
Technology Readiness in Michigan
Streamlining Data Usage in Michigan Using Ed-Fi
![Page 2: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/2.jpg)
Agenda
Why we feel data integration is important How the data hub solution is designed What the data hubs will do Funding & Timeline Cockpit Walkthrough Questions
![Page 3: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/3.jpg)
I’m not from this Michigan
![Page 4: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/4.jpg)
Although I did graduate from Michigan State
![Page 5: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/5.jpg)
I guess OSU did ok last year, too
![Page 6: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/6.jpg)
Collaboration…
Competition is great in college football, but …
When it comes to educating kids, we need to work together to give all
kids a quality education.
![Page 7: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/7.jpg)
The Ed-Fi Alliance gives us a platform to do that
Open Source Toolkit Unified data model
based on CEDS Operational Data
Store (ODS) XML Interchange
Schemas RESTful API Dashboard Framework Sample Dashboards
![Page 8: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/8.jpg)
SEAs Licensed
LEAs and/or ESAs Licensed
Ed-Fi Usage Across the Country
![Page 9: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/9.jpg)
What data challenges do you/we face?
Inaccurate and Inconsistent Data
Various Data Formats
Data Security and Privacy
IntegrationsProne to Breaking
Timeliness of data
Need for actionable data
Cost
![Page 10: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/10.jpg)
What was the original request from the Michigan legislature?
Develop means of achieving common statewide SIS programs that address the proliferation of SIS
Develop standardized systems and move districts to fewer, common SIS
Transition to a statewide SIS program that offers no more than five SIS with one dedicated as a “state solution”
![Page 11: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/11.jpg)
2013-14
14 SIS87% Common
![Page 12: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/12.jpg)
![Page 13: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/13.jpg)
Data Integration Activity Vision
The Data Integration activity is designed to streamline the use of educational information statewide through common data & common
solutions
![Page 14: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/14.jpg)
This is a Major Cultural Change
We have been two years in planning and development
We desire to get every district on board• State’s timeline – this year• Realistically – the next two years
Initially there won’t be a huge benefit until vendors come on board
Eventually it will completely change the way we do business
![Page 15: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/15.jpg)
Concept of Project
System 1Ex: Student Information
System
System 2Ex: Special Education System
System 3:Ex: Food Service System
System 4:Ex: Data
Warehouse System
System 5:Ex:
Transportation System
Data Collected
• Student information
• Scheduling• Attendance• Grades
Data Collected
• Student information
• Individualized Education Plan (IEP)
• Accommodations
Data Collected
• Student information
• Lunch balance
• Payment information
Data Collected
• Student information
• Local assessments
• State assessments
Data Collected
• Student information
• Route information
District Perspective
Challenges:• Redundancy of data entry• Inaccuracy of data• Few if any systems “talk” to each other• Not one place to access all this data
![Page 16: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/16.jpg)
The Solution
System 1Ex: Student Information
System
System 2Ex: Special Education System
System 3:Ex: Food Service System
System 4:Ex: Data
Warehouse System
System 5:Ex:
Transportation System
Data HubData Quality
Method to validate that data is accurate and eliminate redundant input
Single Source of Actionable Data
• Reports• Dashboards
Advantages:• Eliminate the need for redundant data entry• Validate accuracy of data• Data can be shared between systems• Reporting allows all data to be viewed in one place
![Page 17: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/17.jpg)
How does this work?
MISTARMISTARMISTAR
Meal MagicPolyplot
PowerSchoolIlluminate SEData DirectorMeal Magic
Edulog
SynergyTienet SEIRIS/IGOR
Meal MagicVersaTrans
SkywardIlluminate SE
Illuminate DnATransfinder
PowerSchoolIlluminate SE
SchoolnetMeal Magic
Pilot Data HubKalamazoo RESA
Waterford(GMEC)
Ludington(IMC)
Wyoming(Kent)
Sault Area(RNMC)
BerrienSprings(SWMI)
KEY: Student Information SystemsSpecial Education SystemsData WarehousesFood ServicesTransportation Systems
Common Exchange Format
![Page 18: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/18.jpg)
Data Hubs align to TRIG Regions
Kalamazoo RESA
Copper Country Wexford-
Missaukee ISDKent ISD
OaklandSchools
![Page 19: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/19.jpg)
Data Hub Deployment
A QA Environment has been completed for testing new releases
A Staging (ST) Environment has been completed for preparing new releases
5 Production Data Hubs are in place Districts will come onto the data hub in their
TRIG Region (OnBoarding) TRIG Website provides the links:
http://22itrig.org/activities/data-integration/applications/
![Page 20: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/20.jpg)
![Page 21: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/21.jpg)
Data Hub/Ed-Fi Uses
![Page 22: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/22.jpg)
Systems Integration
Created cockpit application Primarily working with SIS vendors
• Edupoint Synergy• Infinite Campus• MISTAR• Pearson PowerSchool• Skyward• SunGard eSchoolPlus
![Page 23: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/23.jpg)
Systems Integration
Working with vendors on outbound integrations (both XML and Web Service)• Alert, Assessment, Data Warehouse Food
Service, Library, Special Education, Transportation
Added Reporting Capability Implemented Ed-Fi 2.0 ODS, XML and Web
Services API MSDF: System of Authority and Granular
Security
![Page 24: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/24.jpg)
Unification of Data Collections
Developing extensions for all CEPI MSDS fields not currently covered in Ed-Fi spec
Analysis and Design of State Reporting Generation
Coming Soon: Pilot state reporting generation, including request for UIC process
Potential: Reports for Pupil Accounting and Auditing
![Page 25: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/25.jpg)
Dashboards
Ed-Fi Solution has dashboard development framework and starter dashboards
Authentication being put into place and dashboards have been created for some pilot districts
The state is considering the data hubs for presentation of M-STEP assessment results for parents, students and educators.
Demo version of dashboards: https://dashboard-sample.midatahub.org/
![Page 26: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/26.jpg)
![Page 27: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/27.jpg)
Drill Down Capability
![Page 28: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/28.jpg)
![Page 29: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/29.jpg)
Identity and Access Control
Specifications for Statewide Single Sign-On (SSO) developed
Integrated EUPISD Regional Active Directory In Process:
• SSO Authentication for cockpit and dashboard• Integrating MISchoolData
![Page 30: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/30.jpg)
LocalLocalLocal
Active Directory Federation Services
Regional ODS rollup views
IDM Synchronization Server
(MicrosoftForefront Identity
Manager)
Federated SSO applications
State-wideActive Directory
AD or LDAP authentication-based
applications
SSO Environment
Local LDAP OrActive Directory
Active Directory Federation Services Or
Other Federation Service
![Page 31: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/31.jpg)
For Future Consideration
Student Record Movement Data Warehouse/Analytics Interventions App Store
![Page 32: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/32.jpg)
Ed-Fi Exchange
![Page 33: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/33.jpg)
Student Early Warning System
This system shows educators at the classroom, school, or district level metric indicators to provide caution and failure warnings about their students. Based on research by Dr. Robert Balfanz, the EWS focuses on 5 statistically significant predictors of dropout risk:• A daily attendance rate of less than 80 percent• More than 5 school code of conduct violations• One or more state reportable offense violations• A failing math grade• A failing English language arts grade
Pre-configured for the dashboard, students struggling in any of these areas are identified and flagged as a dropout risk in the EWS
![Page 34: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/34.jpg)
EWS Dashboard
![Page 35: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/35.jpg)
![Page 36: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/36.jpg)
Student Level Detail
![Page 37: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/37.jpg)
What has our funding looked like?
Funding Allocations• Year 1, 2013-14 - $1.0M• Year 2, 2014-15 - $1.0M• Year 3, 2015-16 - $2.0M• Year 4, 2016-17 - $2.2M
Everything accomplished to date has occurred with under $2.0M funding thanks to work from Ed-Fi Alliance and other states
![Page 38: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/38.jpg)
Governance Model(Draft)
![Page 39: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/39.jpg)
Support Model
![Page 40: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/40.jpg)
Cockpit Roles
Operations Manager (2 statewide) Data Hub Data Custodian (1 per region) Data Hub System Administrator (1-3/region) District Superintendent/Lead Admin Proxy for District Superintendent/Lead Admin Tech Contact Data Steward
![Page 41: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/41.jpg)
Timeline
11-1-2015 *Data Hubs Functional for
District Configuration
9-1-2016 *Pilot readiness of state
reporting
![Page 42: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/42.jpg)
Implementation Steps
Complete Data Hosting Agreement – Electronic Signature
Data Hub Support Specialist Assigned System Configuration SIS Integration Data Quality Verification Usage of Approved Third-Party Integrations Usage of Additional Data Hub Capabilities
![Page 43: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/43.jpg)
Login Page
![Page 44: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/44.jpg)
ISD List with Searching
![Page 45: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/45.jpg)
ISD List Expanded with Districts
![Page 46: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/46.jpg)
Selected District – Top Portion
![Page 47: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/47.jpg)
School District – Bottom Portion
![Page 48: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/48.jpg)
Inbound Integrations - Top
![Page 49: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/49.jpg)
InBound Integrations - Scheduling
![Page 50: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/50.jpg)
InBound Integrations - Log
![Page 51: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/51.jpg)
Build - Schedule
![Page 52: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/52.jpg)
Build - Log
![Page 53: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/53.jpg)
Outbound Integration
![Page 54: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/54.jpg)
Outbound Integration – Cont’d
![Page 55: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/55.jpg)
API Integration
![Page 56: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/56.jpg)
Reports
![Page 57: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/57.jpg)
At-A-Glance Report
![Page 58: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/58.jpg)
At-A-Glance Part2
![Page 59: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/59.jpg)
FAQ
![Page 60: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/60.jpg)
FAQ - Expanded
![Page 61: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/61.jpg)
Legal Agreements
![Page 62: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/62.jpg)
Systems Inventory
![Page 63: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/63.jpg)
Integration Status
![Page 64: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/64.jpg)
Summary
This has been a huge and complex project The collaboration on this project has been
tremendous This cannot be built in a day – It will evolve
over time• Year 1 – Planning• Year 2 – Development• Year 3 – Implementation• Year 4+ – Expansion
![Page 65: Streamlining data usage in michigan using ed fi](https://reader035.vdocuments.us/reader035/viewer/2022070514/58803ab31a28abfd0a8b4e3f/html5/thumbnails/65.jpg)
Questions
Visit our website at 22itrig.org for more information
Contact Information•Don Dailey•[email protected]•269-250-9264