130 likes | 231 Views
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
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