slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
CEDARS Data Warehouse (CDW) PowerPoint Presentation
Download Presentation
CEDARS Data Warehouse (CDW)

Loading in 2 Seconds...

play fullscreen
1 / 36

CEDARS Data Warehouse (CDW) - PowerPoint PPT Presentation


  • 169 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'CEDARS Data Warehouse (CDW)' - doris


Download Now 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1
CEDARS Data Warehouse (CDW)

CDW LEA Trainer’s WebinarSeptember 25th, 2012Terra DominguezData, Research & Federal Policycedars-info@dpi.nc.gov

house keeping
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

agenda
Agenda
  • Welcome
  • Review
  • CDW Improvements
  • State Training Events
  • Resources
  • CDW LEA Trainer Meetings
  • Reminders
the cdw is
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
The CDW IS NOT
  • Replacing any operational systems (NC WISE, CECAS, Licensure)
  • Real time, transactional data
  • Open to the public
data loads
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

data sources
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*

student level data submission

Yearly (June 30)*

Assessments

Course Enrollments

Marks

Discipline

Student Level Data Submission
  • Monthly
    • Demographics
    • Enrollment
    • Attendance
    • Program Participation*
  • Snapshots (periodic)
    • Program Specific
    • NC WISE
staff level data submission
Staff Level Data Submission
  • January
  • March
  • Year End (June 30)*
cdw data student staff
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
slide12

NC WISE

ID 1234567

CECAS

ID A729

UID Matching Engine

Migrant

ID 2779

program level data submission
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
lea school level submission
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
registration
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
user roles
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
security
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
detail vs aggregate
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
cdw improvements
CDW Improvements
  • Faster Queries
  • New Landing Page
  • New Dashboards
  • Posted Submission Schedule
  • Published Data Dictionary
new obiee landing page
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
new dashboards
New Dashboards

Aggregate

Detail

  • Consequences
  • Offenses
  • Suspension Days
  • School Crime
  • ACCESS Testing
  • Home Languages
  • LEP Roster
  • State Testing (ESL)
what dashboards would you like published
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
submission schedule
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
data dictionary
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
state hosted training events
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
resources
Resources
  • CEDARS Website
  • LEA Trainer Wiki
cdw trainer meetings
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
trainer meeting schedule
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

quarterly meetings full team
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

reminders
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
slide36

Terra Dominguez

Division of Data Research & Federal Policy

919.807.3272

cedars-info@dpi.nc.gov

Thank you!