1 / 36

CEDARS Data Warehouse (CDW)

CEDARS Data Warehouse (CDW). CDW LEA Trainer’s Webinar September 25 th , 2012 Terra Dominguez Data, Research & Federal Policy cedars-info@dpi.nc.gov. House Keeping. Use the Hand icon to indicate you would like to communicate verbally

doris
Download Presentation

CEDARS Data Warehouse (CDW)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CEDARS Data Warehouse (CDW) CDW LEA Trainer’s WebinarSeptember 25th, 2012Terra DominguezData, Research & Federal Policycedars-info@dpi.nc.gov

  2. House Keeping Use the Hand icon to indicate you would like to communicate verbally Use the Question/Chat pane at any time to ask questions or make comments

  3. Poll – Who Is New?

  4. Agenda • Welcome • Review • CDW Improvements • State Training Events • Resources • CDW LEA Trainer Meetings • Reminders

  5. 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

  6. The CDW IS NOT • Replacing any operational systems (NC WISE, CECAS, Licensure) • Real time, transactional data • Open to the public

  7. Data Loads Last Year • SY 2008-2009 test data removed • SY 2009-2010 complete • SY 2010-2011 complete • SY 2011-2012 pending year end files • SY 2012-2013 on target This Year

  8. Data Sources • Instructional Technology • Choice • SES • TAS • REAP • MFR/AFR • Safety • EDDIE • Licensure • Payroll • UID Staff • Title I • LEA Improvement • School Improvement * MAF from 2009-2010 & 2010-2011 school years only NC WISE EC Migrant ESL Homeless N & D Accountability CTE MAF*

  9. Yearly (June 30)* Assessments Course Enrollments Marks Discipline Student Level Data Submission • Monthly • Demographics • Enrollment • Attendance • Program Participation* • Snapshots (periodic) • Program Specific • NC WISE

  10. Staff Level Data Submission • January • March • Year End (June 30)*

  11. 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

  12. NC WISE ID 1234567 CECAS ID A729 UID Matching Engine Migrant ID 2779

  13. With the help of UID, the CDW putsall the pieces in place CTE Immigrant LEP NC WISE Migrant EC

  14. Program Level Data Submission • Monthly • LEP & Migrant • Migrant • Snapshot (periodic) • CECAS • Homeless • N&D • Year End (June 30)* • ALP • Choice • LEA Improvement • Instructional Tech File • SES • TAS • REAP • Dropout • ESSR

  15. LEA & School Level Submission • July 1 • EDDIE • January • EDDIE • Instructional Tech File • REAP • February • EDDIE • ADM • School Safety • May • EDDIE • Year End (June 30)* • EDDIE • Instructional Tech File • Choice • REAP • Accountability • Dropout • LEA Improvement • ESSR • School Safety

  16. You still with me?

  17. Registration • Each individual must register and be approved for access to the CDW • Authentication is based on NCID for any ‘CEDARS’ related application • The NC Public Schools website offers a contact list of the LEA’s Security Officers

  18. User Roles LEA • Detail Answers • Detail - Dashboard • Aggregate - Dashboard • Security Officer School • Detail - Dashboard • Aggregate Dashboard SEA • Super User • User Detail • Report Writer • Aggregate - Dashboard • Security Officer

  19. Security • Security Officer role only provides access to the Registration System to manage accounts • The highest level of access to the CDW for an LEA user is Detail Answers • School level user roles only have access to Dashboards published by DPI • There is no Teacher user role in the CDW

  20. Detail Vs. Aggregate • User roles with the word Detail allow individuals access to data that is Personally Identifiable Information (PII) • Every user role that is approved has access to Aggregate Dashboards by default • Aggregate Dashboards are totals only and do not display any PII

  21. CDW Improvements • Faster Queries • New Landing Page • New Dashboards • Posted Submission Schedule • Published Data Dictionary

  22. New OBIEE Landing Page Users are routed to the dashboard TOC to which they have the highest level of authority • Dashboard users are the largest user base • Dashboard users have no immediate use for Home Page (previous Landing Page) • Keeps dashboard trainees focused on content and delivery

  23. New Dashboards Aggregate Detail • Consequences • Offenses • Suspension Days • School Crime • ACCESS Testing • Home Languages • LEP Roster • State Testing (ESL)

  24. What dashboards would you like published? • If you’ve created something that you’d like to have published, contact us • If you need assistance in creating a specific report, contact us

  25. Submission Schedule CEDARS Documents • When data is requested from program areas • Identifies the ‘as of’ date for extracts • View by • Calendar • Month, program area, data type • Actual load time varies

  26. Data Dictionary Published Pending • SEA, LEA & School Information • Student Data • Staff Information • Financial • Cross Program Analysis • Individual Program Data • Assessment Data • School Safety • School Enrollment Data • Membership • CTE • Course & Grade Data • Student Attendance

  27. State Hosted Training Events • CDW Overview • Oct 9, AM & PM Webinar • CDW Intro to Dashboards • Oct 23, AM & PM Webinar • CDW Subject Areas • Nov 13, AM & PM Webinar

  28. Resources • CEDARS Website • LEA Trainer Wiki

  29. Poll(s) – Wiki

  30. CDW Trainer Meetings • Smaller meetings once a month through November • No meeting in December • We will re-evaluate in January • Quarterly updates from NCDPI as well as any LEA Trainer who would like to share

  31. Trainer Meeting Schedule • Regions 1 – 4 9:00-10:00 AM • October 26th https://www1.gotomeeting.com/register/367460488 • November 30th https://www1.gotomeeting.com/register/466585248 • Regions 5-8 10:15 – 11:15 AM • October 26th https://www1.gotomeeting.com/register/153772712 • November 30th https://www1.gotomeeting.com/register/171102552

  32. Quarterly Meetings – Full Team • January 25th https://www1.gotomeeting.com/register/584350760 • April 26th https://www1.gotomeeting.com/register/830927800 • July 26th https://www1.gotomeeting.com/register/305847929 • October 26th 9:00 AM – 11:00AM, last Friday of the month

  33. Poll – What Region?

  34. Reminders • Every LEA must have a Security Officer • Most users need only one role (the highest level of authority) • Point staff to CDW Events page

  35. So….did you get all that?

  36. Terra Dominguez Division of Data Research & Federal Policy 919.807.3272 cedars-info@dpi.nc.gov Thank you!

More Related