CEDARS Data Warehouse (CDW)
This presentation is the property of its rightful owner.
Sponsored Links
1 / 36

CEDARS Data Warehouse (CDW) PowerPoint PPT Presentation


  • 110 Views
  • Uploaded on
  • Presentation posted in: General

CEDARS Data Warehouse (CDW). CDW LEA Trainer’s Webinar September 25 th , 2012 Terra Dominguez Data, Research & Federal Policy [email protected] House Keeping. Use the Hand icon to indicate you would like to communicate verbally

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


Cedars data warehouse cdw

CEDARS Data Warehouse (CDW)

CDW LEA Trainer’s WebinarSeptember 25th, 2012Terra DominguezData, Research & Federal [email protected]


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


Poll who is new

Poll – Who Is New?


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


Cedars data warehouse cdw

NC WISE

ID 1234567

CECAS

ID A729

UID Matching Engine

Migrant

ID 2779


With the help of uid the cdw puts all the pieces in place

With the help of UID, the CDW putsall the pieces in place

CTE

Immigrant

LEP

NC WISE

Migrant

EC


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


You still with me

You still with me?


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


Poll s wiki

Poll(s) – 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


Poll what region

Poll – What Region?


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


So did y ou g et a ll t hat

So….did you get all that?


Cedars data warehouse cdw

Terra Dominguez

Division of Data Research & Federal Policy

919.807.3272

[email protected]

Thank you!


  • Login