220 likes | 325 Views
CEDARS – Comprehensive Education Data and Research System. May 2009. CEDARS Training Agenda. Welcome and Introductions Training Overview Evolution from CSRS to CEDARS (Fri) Submission and Editing Process (Tues)
E N D
CEDARS – Comprehensive Education Data and Research System May 2009
CEDARS Training Agenda • Welcome and Introductions • Training Overview • Evolution from CSRS to CEDARS (Fri) • Submission and Editing Process (Tues) • Course Catalog, Student Schedules, Grade History - including phase-in of State Course Codes (Wed) • Staff Information, including Certification Numbers (Thurs) • Expanded Program data and New Ethnicity and Race codes (Fri) May 2009
CEDARS Overview • CEDARS warehouse vs. CEDARS data collection • Purpose and outcomes of CEDARS Warehouse • CEDARS data collection overview • Implementation schedule May 2009
CEDARS Data Warehouse vs. CEDARS Submissions CEDARS Submissions Student, Course & Teacher Data Facilities& Transportation Assessment Certification Financial CEDARS Data Warehouse May 2009 4
CEDARS Data Warehouse vs. CEDARS Submissions CEDARS Submissions Student Enrollment Facilities& Transportation Student Demographics Assessment Certification Courses Financial Grade History Programs Staff Schedules CEDARS Data Warehouse May 2009 5
Additional Data for the Warehouse Assessment Statewide Assessments (WASL) Facilities& Transportation Certification Language Proficiency CEDARS Financial College Readiness Tests CEDARS Data Warehouse May 2009 6
Additional Data for the Warehouse Financial Grant Payments Forecasting Budgets Facilities& Transportation Assessment Certification Expenditures CEDARS Apportionment CEDARS Data Warehouse May 2009 7
Additional Data for the Warehouse Certification Teaching Certificates Fingerprints Teacher Test Scores Facilities& Transportation Assessment Natl. Board HQT CEDARS Financial CTE Certifications S275 CEDARS Data Warehouse May 2009 8
Additional Data for the Warehouse Facilities & Transportation Transportation Safety Assessment Certification School Inventory CEDARS Financial Facilities Data CEDARS Data Warehouse May 2009 9
CEDARS Warehouse Outcomes • Will reduce duplicate information requests from OSPI – CEDARS will be OSPI’s first stop for information • Allows OSPI to generate and consolidate reports for district viewing • Links data between Teachers, Students, Assessments, Financials and eventually Facilities to inform policy and funding decisions. • Integration will highlight Data Quality May 2009 10
Kinds of questions we will be able to answer with these data • Student achievement • Achievement over time for individual students and groups of students (e.g., students in the Transitional Bilingual Program, students in foster care) • “Rate at which English Language Learners are entering the state for the first time in high school and how they are doing on the state’s high school exit exam.” • Teacher preparation • “The relationship between the performance of each district’s low-income students on the end-of-course Algebra 1 exam and teacher preparation in that subject.” • Teacher deployment • National Board Certification rates in districts of high poverty. • Course taking patterns • “Number of and percent of students enrolling in and completing more rigorous courses in high school, disaggregated by ethnicity and income status.” • Grade history • Course grades vs. end of course assessment scores • Etc. May 2009 11
Sample Report #1 May 2009
CEDARS Data Collection • CEDARS data collection overview • CSRS on Caffeine– what changed & what stayed the same • 13 tables • But, before we get too detailed….. May 2009
A BIG THANK YOU!!!! • THANK YOU to the CEDARS STAKEHOLDERS!!!! • Auburn • Clover Park • Everett • Lake Washington • Mukilteo • Northshore • Spokane • Other districts periodically • Mark Schultz (WSIPC), Dean Taylor (Schoolmaster), and Val Nelson (VNA Solutions) • All good features are because of these great allies!! May 2009
CEDARS Data Submissions What Changed More Data Required (courses, teachers, grade history, and more detail on Special Education and Bilingual programs) Information from other systems New Submission Method Frequency of Submission Stronger Data Validation New Editing Process (no more backing out!) Reporting Options SSID Management (changed a little) May 2009 15
CEDARS Data Submissions What Stays the Same Current Reports Assessment Information (CAA/CIA) P210, P210Voc, P105, Student Learning Plans and other processes SSID upload/download process Customer Support is your resource May 2009 16
CEDARS Data Files A–Location File • Location File • Student Demographics • Student Enrollment Information • Course Catalog • Student Schedules* • Grade History B–District Student File (demographics) C–School Student File (enrollment) D–Course Catalog E-Student Schedules H-Grade History May 2009 17
CEDARS Data Files • Program Participation • ~ Bilingual • ~ Special Education • Other Programs • Staff Demographics & • Certification Numbers* • Staff Schedules I- Other Program Participation J–Student Bilingual Programs K–Student Special Education Programs F-Staff Demographics G-Staff Schedules L–Ethnicity File M-Race File May 2009 18
CEDARS Implementation Schedule • CEDARS submission practice Now! • CEDARS full implementation Sept 2009 • State Course codes phased in 2009-10 • Ethnicity & Racial groups submitted by 2010-11 • Warehouse Data integration and reporting… Ongoing May 2009
CEDARS Implementation – Getting Started • Check out CEDARS data manual • Determine where your information system(s) store new data elements • Map data elements to CEDARS file layouts • Build or have your vendor build data extract • Get an SFTP account from OSPI Customer Support • Practice submitting and interpreting errors • Correct errors in source data or extracts • YOU ARE READY!!! May 2009
Questions & Answers • This presentation and session recording will be posted to the K12 web site at http://www.k12.wa.us/DataAdmin/default.aspx • We will also post questions and answers: • That are asked/answered during the session • That we did not get to during the session • That we receive after the session May 2009
CEDARS Resources • Customer Support (360) 725-6371 or 1 (800) 725-4311customersupport@k12.wa.us • Data Manual and Appendices and Supporting Documents http://www.k12.wa.us/CEDARS/default.aspx • Feasibility Study report to the Legislature http://www.k12.wa.us/LegisGov/2009documents/DataFeasibilityReport.pdf May 2009