NC CEDARS Presentation 2009 Conference
Content
NC Common Education Data Analysis and Reporting System (CEDARS)
FBS Conference July 30, 2009
Overview
CEDARS objectives, components, plan Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
Overview
CEDARS objectives, components, plan Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
CEDARS Objectives
Enable State, local, and federal policy makers and service providers to make data-driven decisions based on analysis of trends and relationships
– across different types of data
– over time
CEDARS Objectives
Increase the quality and accessibility of PreK- grade 13 (P-13) educational data – student & teacher demographic – course, assessment – program – financial
CEDARS Components
State Longitudinal Data System (SLDS): • A statewide unique ID (UID) system for students and staff that enables linking of different types of data across collections and over time • A longitudinal data store (LDS), along with analytical tools and reports, that enables analysis of trends and relationships
CEDARS Components
Unique ID System (UID)
Ensures that relevant source systems have properly matched students and staff with unique IDs
Data Transfer
Data Repositories
Data Access
ABC
Source Systems
Financial systems Transportation
LDS
Standard reports Query tools Automated submission e.g. EDEN
LEAs, schools
Teacher licensure (LIC/SAL)
School data managers
ABC
Data marts
State, federal
Program information (CECAS, Title 1, etc.) Student information (NCWISE) • Matches based on UID • Checks to ensure quality • Stores data over time • Organized into domains based on type of data
Other access, e.g. online portal • Common location for data access (‘info library’) • Different tools based on type of user • “Data Dictionary”
Teachers Students
Testing Data (Assessment)
Source: DPI Enterprise Architecture, 2/2008, BCG Interviews
CEDARS: Meeting User Needs
User Information needs
• Ensure compliance • Identify those who need support • Inform policy and program initiatives • Receive mandated information • Ensure data accuracy • Review and compare performance and reports for their districts / schools
CEDARS Approach
• Direct access to CEDARS – Established reports – Ad-hoc queries/data extracts • Federal submission via EDEN • Direct access to CEDARS, but filtered for specific LEA or school • Mediated data extracts – Requests filtered through review process – Ensure appropriate user and usage
Current data on specific students will NOT be provided by CEDARS NC WISE will provide current year adhoc reporting capabilities for LEAs
DPI
Federal LEA central offices and principals
Researchers, higher ed, other State agencies
• Analyze educational trends
Teachers Students and parents
• Review performance of students • Compare performance to standards • Understand performance of an individual student
CEDARS: Data Sources
DPI Data System/Source
SNA NCWISE LIC / SAL CECAS Accountability SES / Choice MIS2000 Title I / TAS CTE USDDC Child Nutrition / FRL
“Data/metadata dictionary” will provide clear definitions of all data elements in the repository
Homeless Immigrant LEP
Dropout DBS Internal and External AMTR
Neglected and Delinquent
More at Four PPAR PMR Data MFR/AFR
CEDARS Reporting
Priority reports
EDEN/EdFacts submission Consolidated State Performance Report (CSPR) ABCs of Public Education and Adequate Yearly Progress (AYP) reports State Performance Plan/Annual Performance Report (SPP/APR) Migrant Student Information Exchange (MSIX) State Plan for Highly Qualified Teachers (HQT) School Report Cards (SRC) Report on Dropout Events and Rates Report on School Crime and Violence Study of Suspensions and Expulsions Legislative More at Four (MAF) report
CEDARS will provide capability, training for re how to build/modify reports
CEDARS: 6 Key Deliverables
Deliverable
Unique Student Identifier Unique Staff Identifier Longitudinal Data Store (LDS) Analysis & Reporting Tools EDEN / EDFacts Reporting Transcript Service • Reliably match student level records over time and across DPI applications • Reliably match staff level records over time and across DPI applications • Provide robust, secure warehouse of high quality P-13 longitudinal data • Provide user-friendly access and tools to enable longitudinal analysis and reporting • Automate required annual Federal reporting
How addressed
• Deloitte / eScholar UID solution (on-track for completion 8/09)
• Data Warehouse and Reporting (DWR) RFP - 8 bidders being evaluated (target completion 7/2010) • Oracle Service Oriented Architecture (“Enterprise Services”); installed 12/09 • Proposal: Link to a national transcript exchange by 7/2010
• Streamline and automate exchange of student transcripts among schools and with higher ed
CEDARS: Project Structure
Steering Committee LEA Advisory
• Various LEA contacts • Existing User Advisory Boards from NCWISE, other existing applications Bill Harrison J. Atkinson R. Garland P. Price P. Asmar A. Quick A. Levinson
DPI IT Leadership
Peter Asmar Mike Veckenstedt John Wetsch Annette Murphy Ken Thompson
External Advisory
• Higher education • Researchers • Representatives from other state agencies • LEAs
Project Leadership
Adam Levinson, Project Sponsor Mike Veckenstedt, IT Lead Ben Comer, Project Manager Belinda Black, Non-technical Lead
DPI Directors
Data Management Group Technical Team
John Wetsch Gary Blumenthal Lily Ebron George Phelps Robin Lucarelli Frank Vierling Steve Bergene Jerry Bunn Betsy Baugess Angela Pope-Lett Suresh Pothireddy Vicki Humphreys
Non-tech Team
Kayla Mathis Tom Field Karl Pond Joe Dietzel Traci Blount Jessica Exline Daniel Boyette Gwen Tucker Denise Jackson Alexis Bouchard Vanessa Jeter Michele Burton Kris Knower
Karl Pond Traci Blount Lillie Ebron Tom Field Ashley Herring Joanne Marino Alicia McGee George Phelps Alexis Schauss Rhonda Welfare John Brim
Betsy Baugess Joe Dietzel KC Elander Kenneth Gattis Ken Little Kayla Mathis Quentin Parker Susan Ruiz Loreto Tessini Gary Williamson
Overview
CEDARS objectives, components, plan Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
Goals of UID System
1. All students assigned an NCWISE UID at the first point of contact with the public education system
PreK - 13 • NCWISE • CECAS • MIS2000 PreK • LEP • More at Four
Goals of UID System
2. All staff will be assigned a unique statewide ID
Note: new Staff file (provided by LEA/Charter payroll vendors) serves as source
eScholar Uniq-ID
Step: 1. Basic demographic information sent to Uniq-ID server via web interface or batch upload 2. System uses multiple matching techniques to determine if NCWISE or Staff UID already exists 3. System provides an NCWISE UID via file or web
• • • If match, system will return existing UID If no match, system can assign a UID or leave blank If near match, system will initiate near-match resolution process
Human intervention!
Match Resolution
Overview
CEDARS objectives, components, plan Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
UID Pilot: At-a-Glance
• July 14 – 28, 2009 • 10 LEAs, 2 Charters, More at Four • Varying sizes, geographic regions, technology capabilities, and business processes • Using all source systems
UID Pilot: LEA/Charter Activities
• Established contacts for student & staff • Participated in training webinars and follow up conference calls • Reviewed and resolved near-matches for students & staff • Provided feedback to the DPI project team • Will now act as a resource for other LEAs during statewide rollout
Statewide Rollout
• Time Line: August 2009
– All LEAs/Charters* notified of training dates – Webinars & Follow-up Calls scheduled
• Key Activities for LEAs/Charters
– Registration, Training, Follow-up (as needed) – Resolving near matches!! – Making changes to source data – Plan for “Cascading” the training (to schools?) – Providing feedback to DPI!
Overview
CEDARS objectives & components Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
Questions/Next Steps
CEDARS Webpage: www.ncpublicschools.org/cedars or www.dpi.state.nc.us/cedars
Questions/Next Steps
Questions about UID or CEDARS in general?
Please contact us at: [email protected]
FBS Conference July 30, 2009
Overview
CEDARS objectives, components, plan Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
Overview
CEDARS objectives, components, plan Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
CEDARS Objectives
Enable State, local, and federal policy makers and service providers to make data-driven decisions based on analysis of trends and relationships
– across different types of data
– over time
CEDARS Objectives
Increase the quality and accessibility of PreK- grade 13 (P-13) educational data – student & teacher demographic – course, assessment – program – financial
CEDARS Components
State Longitudinal Data System (SLDS): • A statewide unique ID (UID) system for students and staff that enables linking of different types of data across collections and over time • A longitudinal data store (LDS), along with analytical tools and reports, that enables analysis of trends and relationships
CEDARS Components
Unique ID System (UID)
Ensures that relevant source systems have properly matched students and staff with unique IDs
Data Transfer
Data Repositories
Data Access
ABC
Source Systems
Financial systems Transportation
LDS
Standard reports Query tools Automated submission e.g. EDEN
LEAs, schools
Teacher licensure (LIC/SAL)
School data managers
ABC
Data marts
State, federal
Program information (CECAS, Title 1, etc.) Student information (NCWISE) • Matches based on UID • Checks to ensure quality • Stores data over time • Organized into domains based on type of data
Other access, e.g. online portal • Common location for data access (‘info library’) • Different tools based on type of user • “Data Dictionary”
Teachers Students
Testing Data (Assessment)
Source: DPI Enterprise Architecture, 2/2008, BCG Interviews
CEDARS: Meeting User Needs
User Information needs
• Ensure compliance • Identify those who need support • Inform policy and program initiatives • Receive mandated information • Ensure data accuracy • Review and compare performance and reports for their districts / schools
CEDARS Approach
• Direct access to CEDARS – Established reports – Ad-hoc queries/data extracts • Federal submission via EDEN • Direct access to CEDARS, but filtered for specific LEA or school • Mediated data extracts – Requests filtered through review process – Ensure appropriate user and usage
Current data on specific students will NOT be provided by CEDARS NC WISE will provide current year adhoc reporting capabilities for LEAs
DPI
Federal LEA central offices and principals
Researchers, higher ed, other State agencies
• Analyze educational trends
Teachers Students and parents
• Review performance of students • Compare performance to standards • Understand performance of an individual student
CEDARS: Data Sources
DPI Data System/Source
SNA NCWISE LIC / SAL CECAS Accountability SES / Choice MIS2000 Title I / TAS CTE USDDC Child Nutrition / FRL
“Data/metadata dictionary” will provide clear definitions of all data elements in the repository
Homeless Immigrant LEP
Dropout DBS Internal and External AMTR
Neglected and Delinquent
More at Four PPAR PMR Data MFR/AFR
CEDARS Reporting
Priority reports
EDEN/EdFacts submission Consolidated State Performance Report (CSPR) ABCs of Public Education and Adequate Yearly Progress (AYP) reports State Performance Plan/Annual Performance Report (SPP/APR) Migrant Student Information Exchange (MSIX) State Plan for Highly Qualified Teachers (HQT) School Report Cards (SRC) Report on Dropout Events and Rates Report on School Crime and Violence Study of Suspensions and Expulsions Legislative More at Four (MAF) report
CEDARS will provide capability, training for re how to build/modify reports
CEDARS: 6 Key Deliverables
Deliverable
Unique Student Identifier Unique Staff Identifier Longitudinal Data Store (LDS) Analysis & Reporting Tools EDEN / EDFacts Reporting Transcript Service • Reliably match student level records over time and across DPI applications • Reliably match staff level records over time and across DPI applications • Provide robust, secure warehouse of high quality P-13 longitudinal data • Provide user-friendly access and tools to enable longitudinal analysis and reporting • Automate required annual Federal reporting
How addressed
• Deloitte / eScholar UID solution (on-track for completion 8/09)
• Data Warehouse and Reporting (DWR) RFP - 8 bidders being evaluated (target completion 7/2010) • Oracle Service Oriented Architecture (“Enterprise Services”); installed 12/09 • Proposal: Link to a national transcript exchange by 7/2010
• Streamline and automate exchange of student transcripts among schools and with higher ed
CEDARS: Project Structure
Steering Committee LEA Advisory
• Various LEA contacts • Existing User Advisory Boards from NCWISE, other existing applications Bill Harrison J. Atkinson R. Garland P. Price P. Asmar A. Quick A. Levinson
DPI IT Leadership
Peter Asmar Mike Veckenstedt John Wetsch Annette Murphy Ken Thompson
External Advisory
• Higher education • Researchers • Representatives from other state agencies • LEAs
Project Leadership
Adam Levinson, Project Sponsor Mike Veckenstedt, IT Lead Ben Comer, Project Manager Belinda Black, Non-technical Lead
DPI Directors
Data Management Group Technical Team
John Wetsch Gary Blumenthal Lily Ebron George Phelps Robin Lucarelli Frank Vierling Steve Bergene Jerry Bunn Betsy Baugess Angela Pope-Lett Suresh Pothireddy Vicki Humphreys
Non-tech Team
Kayla Mathis Tom Field Karl Pond Joe Dietzel Traci Blount Jessica Exline Daniel Boyette Gwen Tucker Denise Jackson Alexis Bouchard Vanessa Jeter Michele Burton Kris Knower
Karl Pond Traci Blount Lillie Ebron Tom Field Ashley Herring Joanne Marino Alicia McGee George Phelps Alexis Schauss Rhonda Welfare John Brim
Betsy Baugess Joe Dietzel KC Elander Kenneth Gattis Ken Little Kayla Mathis Quentin Parker Susan Ruiz Loreto Tessini Gary Williamson
Overview
CEDARS objectives, components, plan Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
Goals of UID System
1. All students assigned an NCWISE UID at the first point of contact with the public education system
PreK - 13 • NCWISE • CECAS • MIS2000 PreK • LEP • More at Four
Goals of UID System
2. All staff will be assigned a unique statewide ID
Note: new Staff file (provided by LEA/Charter payroll vendors) serves as source
eScholar Uniq-ID
Step: 1. Basic demographic information sent to Uniq-ID server via web interface or batch upload 2. System uses multiple matching techniques to determine if NCWISE or Staff UID already exists 3. System provides an NCWISE UID via file or web
• • • If match, system will return existing UID If no match, system can assign a UID or leave blank If near match, system will initiate near-match resolution process
Human intervention!
Match Resolution
Overview
CEDARS objectives, components, plan Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
UID Pilot: At-a-Glance
• July 14 – 28, 2009 • 10 LEAs, 2 Charters, More at Four • Varying sizes, geographic regions, technology capabilities, and business processes • Using all source systems
UID Pilot: LEA/Charter Activities
• Established contacts for student & staff • Participated in training webinars and follow up conference calls • Reviewed and resolved near-matches for students & staff • Provided feedback to the DPI project team • Will now act as a resource for other LEAs during statewide rollout
Statewide Rollout
• Time Line: August 2009
– All LEAs/Charters* notified of training dates – Webinars & Follow-up Calls scheduled
• Key Activities for LEAs/Charters
– Registration, Training, Follow-up (as needed) – Resolving near matches!! – Making changes to source data – Plan for “Cascading” the training (to schools?) – Providing feedback to DPI!
Overview
CEDARS objectives & components Spotlight on UID UID Pilot & Statewide Rollout Questions/Next Steps
Questions/Next Steps
CEDARS Webpage: www.ncpublicschools.org/cedars or www.dpi.state.nc.us/cedars
Questions/Next Steps
Questions about UID or CEDARS in general?
Please contact us at: [email protected]
