130 likes | 241 Views
Join Jay Schupp, Project Manager at EUPISD, as he outlines the essential goals for developing good data habits and establishing a solid data culture at the 2011 DataDirector User Conference. Participants will learn about core data requirements, data validation, and how to rectify data errors at the source. Discover the importance of clean data and common data standards, and review critical resources for importing and exporting educational data. This session equips educators and administrators with the tools to ensure the integrity of their data systems.
E N D
2011 DataDirector User Conference“Data Detox” Jay Schupp, REDI Project Manager EUPISD
Welcome • Goals • Develop good data habits • Establish data culture • Where to go for help • Review “Processing your core data” handout
Data Requirements • 4 core files • Demographics, Roster, User, Course • How data is imported • How data is related • Longitudinal data explained • What other data can be imported • MEAP, MME, ACT Plan/Export, etc. • Regional assessments, STAR, Dibels, Dibels Next, ASVAB……………endless!
Relational Data Demographics File (implants record) StudentID (UIC) Fname Lname Gender …….. Roster File (activates record) StudentID (UIC) Teacher File PIC/TeacherID PIC/TeacherID CourseID Fname School Lname Grade Email Term …….. Period Course File CourseID Course Lname Course Sname
Data Validation • Exporting data from Student Systems • Review DataDirector import files • what to look for • Refer to “Processing your core data” • How to fix data errors • Fix data at the source • Data dictionary. Field mapping from student information systems to 4 core files
Data Dictionary - Mapping Demographics mapping example
Data Validation • “Data Detox” teams • Developing good data “habits” • Incorporate common data standards • commondatastandards.org • Garbage in = Garbage out • What is clean data and why is it necessary
“Fixing” Data • Correct data at the source (Student System) • Setup translations in your DataDirector site
State Reporting (TSDL) • Teacher PIC (change for SIS/Local ID) • Course ID • http://mi.gov/cepi/0,1607,7-113-986_50502_57560---,00.html • http://nces.ed.gov/pubs2007/2007341.pdf
Teacher PIC • Available from CEPI REP site • http://michigan.gov/cepi/0,1607,7-113-986_10478---,00.html • Available now in PowerSchool and Skyward
Wrap Up • Reporting to multiple State systems • TSDL, MSDS, Count Day, ??? • Requires clean data • Question and Answer • Thank you
Contact Information Jay Schupp REDI Grant Project Director/Network Systems Engineer EUPISD (906) 632-3373 x127 (office) (906) 440-2296 (cell) jschupp@eup.k12.mi.us http://www.eup.k12.mi.us/redi