230 likes | 353 Views
CEDARS Data Warehouse (CDW). CDW at 30,000 ft. May 09 th , 2013 Terra Dominguez Data, Research & Federal Policy cedars-info@dpi.nc.gov. Today’s Topics. Data Dashboard Demo Registration Resources. The CDW IS. Historical data for trending and analysis Multiple NCDPI authoritative sources
E N D
CEDARS Data Warehouse (CDW) CDW at 30,000 ft. May 09th, 2013Terra DominguezData, Research & Federal Policycedars-info@dpi.nc.gov
Today’s Topics • Data • Dashboard Demo • Registration • Resources
The CDW IS • Historical data for trending and analysis • Multiple NCDPI authoritative sources • Federal, state & local level reporting • Accessible to State, LEA & School level staff • Secure - authenticate using NCID
The CDW IS NOT • Replacing any operational systems (NC WISE, CECAS, Licensure) • Real time, transactional data • Open to the public
Data Sources • LEA/Charter Payroll • Title I • LEA Improvement • School Improvement • Digital Teaching and Learning • Choice & SES • MAF * • TAS • MFR/AFR • School Safety • CTE • N & D • EC • ESL • Homeless • Data Systems • NC WISE • EDDIE • Licensure • UID Staff • CECAS • CFDC • REAP • MIS2000 Sample * MAF from SY 2009-2010 & 2010-2011
Student Level Data Submission • Monthly • Demographics • Enrollment • Attendance • Program Participation • Snapshots (periodic) • Program Specific • NC WISE • Yearly (June 30) • Assessments • Course Enrollments • Marks • Discipline
Staff Level Data Submission • January • March • Year End (June 30)
CDW Data – Student & Staff • Collected at the Detail level, meaning records specific to the individual student are collected • PII – ‘Personally Identifiable Information’ and must be protected • No detail level data is used for Federal Reporting • FERPA guidelines are enforced and dictate how any detail level data is to be used • Solely dependent upon accurate UIDs
NC WISE ID 1234567 CECAS ID A729 Migrant ID 2779 UID Matching Engine
With the help of UID, the CDW putsall the pieces in place CTE Immigrant LEP NC WISE Migrant EC
Program Level Data Submission • Monthly • LEP & Migrant • Immigrant • Snapshot (periodic) • CECAS • Homeless • N&D • Year End (June 30) • ALP • Choice & SES • LEA Improvement • Instructional Tech File • TAS • REAP • Dropout • ESSR
SEA, LEA & School Level Data • Demographics • Indicators • AYP • Choice & SES • Percentages & Counts • Dropout • Graduation
UserDocumentation • Contact Lists • Submission Schedule • Data Dictionary • Quick Reference Documents http://www.ncpublicschools.org/cedars/reporting/ CEDARS Documents
CEDARS Data Warehouse Quick Sheet Longitudinal Data Store • Does not replace existing operational systems • Used for Federal, state and local reporting • From state authoritative system’s data • LEA & School • Staff & Finance • Student & Programs • Individual level data submitted as often as monthly* Aggregate and Detail Data • Data accessible based on user security levels • SEA created dashboards • Trending • Data Validation • Report Writer Access available to SEA, LEA and School Level Staff • Secure, authenticate with NCID • Must register and be approved based on SEA, LEA & School • http://www.ncpublicschools.org/cedars/reporting/registration/ Resources • http://www.ncpublicschools.org/cedars/reporting/documentation/ • Data Submission Schedule • Security Officer and LEA Trainer Contact Lists • Quick Reference Documents
Terra Dominguez Division of Data Research & Federal Policy 919.807.3272 cedars-info@dpi.nc.gov Thank you!