Transcript 2012-2013 Human Resources Data Services Unit Annette Severson Topics to Cover  2012-2013 HR Collection  Timeline  Changes  2013-2014 Update  RISE  Data Pipeline System 

2012-2013 Human Resources
Data Services Unit
Annette Severson
Topics to Cover
 2012-2013 HR Collection
 Timeline
 Changes
 2013-2014 Update
 RISE
 Data Pipeline System
 TSDL
2012-2013
Human Resources Data Collection
Quick
Recap
 2 files:
 Header File A: Staff Demographics
 Detail File B: Employment Information
 Files Submitted through the Automated
Data Exchange (ADE)
 All regular education staff reported
 Highly Qualified Status for teachers and
Title I paras determined within collection
 Approved data will be posted onto
SchoolView.org
Submit Early
and Often!
Submit
Current
Submission
Process
Overview
Edits
Review
APPROVE!
• District submits data on all staff
• Uses ADE (https://cdeapps.cde.state.co.us/)
• Preliminary Edits-checks file length
• 1st Level Edits- checks validity of codes
• 2nd Level Edits- checks for data accuracy between fields
• Districts Review Data Summary Reports
• Districts Review Special Ed Staff Report
• Approves once all accurate!
Sun
Timeline
Nov 7 th –
OPENS
D e c 7 t h - S U B M IT
at least once
1 7 th
Dec
– Pa s s
1 st L ev e l a n d
o nto 2 n d l ev e l
edits (if not
further)
J a n 3 rd – 9 t h :
Rev i ew S p e c i a l
Ed S t a f f Re p o r t s
Mon
Tues
Wed
(training)
Thurs
NOV 1
Fri
2
Sat
3
4
5
6
7 OPENS
8 (training) 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 (training) DEC 1
2
3
4
5 (training) 6
7
9
10
11
12
13
14
15
16
17 onto 2nd
18
19
20
21
22
23
24
25
26
27
28
29
30
31
JAN 1
2
3 (Review) 4 (Review)
5
6
7 (Review)
8 (Review) 9 (Review)
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Submit 1x
8
Timeline
Sun
Mon
Tues
Wed
Thurs
(cont)
Fri
Sat
FEB 1
2
3
4 HQ ONLY
5
6
7
8
9
Fe b 4 t h – O n l y
H Q re l a te d
E r ro rs
re m a i n i n g
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
MAR 1
2
March 4 th CLOSES
3
4 CLOSES
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
File Layout Changes- Deleted Fields
 Technology Proficiency Level
 Type of Technology Assessment Used
 Date of Technology Assessment
 ALL IMPACT THE FILE LENGTH FOR FILE A
 Decreased to 153 bytes
Teacher Probationary Status Updated
 Additional coding option 03 for At -Will Teachers
 Current Definition: The probationary status of the teacher,
defined by statue 22 -603-203(2)(a): ‘During the first three years
school years that a teacher is employed on a full -time
continuous basis by a school district, such teacher shall be
considered to be a probationary teacher…’ THIS FIELD IS
REQUIRED for all records of teachers.
*Definition does not apply to At -Will Staff
New Definition of A School
 ALL Schools must report at least 1 teacher (including online)
 ALL Prekindergarten only Schools must report either 1 teacher or
1 paraprofessional, Job Classification Code 415:
 415 Teaching Assistant, Regular Education – Performs the day-to-day
activities of teaching students while under the supervision of a teacher,
program director or principal and may or may not be licensed by CDE. In
preschool settings, this includes individuals who are functioning as
assistants to a preschool lead teacher or are actually functioning as the
preschool lead teacher. The teaching assistant does not make diagnostic
or long-term evaluative decisions; however, individuals functioning as a
preschool lead teacher are participants in teams of professionals making
these types of determinations.
Where can I find out more information?
 By reviewing the File Layout and Definitions found at:
 https://cdeapps.cde.state.co.us/doc_toc.htm#human
 Training material, personnel form, file format in excel,
respondent form can all be found at:
 https://cdeapps.cde.state.co.us/ade_news.htm#human
 Or, by contacting Annette Severson
 [email protected]
 303-866-6824
Where can I find more information
for HQ requirements?
 For Highly Qualified Online System Training:
 http://www.cde.state.co.us/FedPrograms/tii/a_hqt_dc.asp
 For Highly Qualified Rules and FAQ:
 http://www.cde.state.co.us/FedPrograms/tii/a_hqt.asp
 Or, contact Cheryl Miller
 [email protected]
2013-2014
CDE DATA COLLECTIONS UPDATED
Overview of RISE, Data Pipeline Project and
Teacher Student Data Link
RISE
Data Pipeline
Staff
Interchange
Other
Interchanges
and Data Files
Teacher
Student Data
Link
Collection of
EDIDs, SASIDs,
& SSCCs
EDID = Educator Identifier
SASID = Student Identifier
SSCCs = Common Course Code
How well
are we
preparing
students
for college?
What types
of
preschool
programs
are most
effective?
15
What
academic
information
can a teacher
obtain on
his/her
students prior
to class?
Can we give
parents better
information so
they can more
effectively
engage in
their child’s
education?
16
Functionality and Quality
Constantly Evolving
2013
2014
Capture & Link Data
Provide Enhanced
Information
Ultimate Performance
 Analysis Conducted
 Modeling
 Predictors Developed
 Student Personalization
 Link Preschool to
Career Data
 Define Essential
Questions
RISE Users
• Data Coordinators
• OIT
• Researchers
 Predictors
 Marketplace Learning
Apps
+
RISE Users
• Program Experts
• Data owners
• Agency Data Analysts
User Base
17
2015
+
RISE Users
• Educators
• Students
• Legislators
• Parents
• Community
Capture
Capture important information about every
student and educator in Colorado.
Accomplished through 2 main projects and
one expansion:
1. Data Pipeline
2. State Equalization Re-Write
3. Data Warehouse Expansion
(Operational Data Store)
18
Where Does Capture Take Us?
FROM
19
TO
Cumbersome, time consuming process
of collecting data
Streamlined data collection process
Program focused data collection
Student focused data collection
Point-in-time data
Transactional data processing
Multiple technology platforms gathering
data
Single technology platform gathering
data
Link
Link data and digital content about
students and educators with records
from relevant state agencies using a
state-of-the-art data system.
Accomplished through 3 main projects:
1. Enterprise Architecture foundation (complete)
2. Teacher-Student Data Link
3. P-20* Data Link
* P-20: Preschool to workforce
20
Where Does Link Take Us?
FROM
21
TO
Lack of data standards amongst
agencies
Consistent data standards
Inconsistent definitions – data and
course codes
Consistent definitions – data and
course codes
Preschool through career (P-20) data
siloed in agencies
Sharing data throughout agencies and
districts
“One size fits all” education plans
Ability to customize education plans
K-12 data only, educators not linked to
students/courses
P-20 data available and linked
Only districts see teacher/student
relationships (within their districts) as
long as students stay in same district
State will be able to provide
stakeholders with “big picture”
teacher/student relationships across
districts and agencies
Provide
Provide timely, student-focused
information to parents, students,
educators, policymakers and educators
through the Schoolview portal.
Current grant funding supports:
1. SchoolView Extension
2. Colorado Growth Model updates
3. EdFacts updates
22
Where Does Provide Take Us?
FROM
23
TO
Data time lag
Timely reporting of results
Stakeholders have limited analysis
capabilities
Stakeholders have more effective
analysis tools
Very little data associated with specific
students linked to educators
Information from multiple aspects
included in data “view” of specific
students, enabling broader spectrum
of analysis/modeling
Minimal instructional practice materials
available and accessible
Rich bank of learning materials
available and accessible
Perform
Use the data to drive increased student
performance through personalized
instructional practices, innovative learning
programs and dynamic professional
development.
Current grant funding supports:
1. A portion of SLI (Shared Learning Infrastructure)
including learning maps and initial curriculum
frameworks
2. Third party applications – initial pilots
24
Where Does Perform Take Us?
25
FROM
TO
Historical, point-in-time data that is difficult to
analyze and use
Timely, forward-looking data that users can
more easily analyze and use proactively to
inform education decisions
Uneven capacity across local education
agencies to leverage data to best address
student performance
Local education agencies have timely
information and analysis to proactively
make decisions that affect student
performance
Compliance-oriented focus
Performance management focus
Data systems built for a single use
Nimble, dynamic system
Challenging to find digital learning resources,
instructional materials and professional
development tied to standards
Digital learning resources, instructional
materials and professional development
are searchable by standards and
assignable to students and teachers based
on data
A Picture of Success
Better Workforce
Preparation
Better Learning
Experiences
Better Support
for Teachers
9
8
7
6
5
4
3
2
1
0
yr
yr
yr
yr
yr
yr
Better Data
26
Better
Decision-making
How you can plug in
 Spread the word about RISE and what it means to your
constituents, teams, etc
 Participate in pilots and focus groups
 Offer us feedback and ideas – it is never too late as RISE
is constantly evolving
 Be part of our working groups to ensure we build this
together
 Visit RISE website for more information at:
http://www.cde.state.co.us/rise
27
Overview of RISE, Data Pipeline Project and
Teacher Student Data Link
RISE
Data Pipeline
Staff
Interchange
Other
Interchanges
and Data Files
Teacher
Student Data
Link
Collection of
EDIDs, SASIDs,
& SSCCs
EDID = Educator Identifier
SASID = Student Identifier
SSCCs = Common Course Code
Data Pipeline Overview
What is it?
Replacement of the Automated Data Exchange (ADE) system with a
new method of capturing data that will reduce the data burden on
Local Education Agencies (LEAs).
• Move from a program-centric to a student-centric data collection
model
Why are we
doing this?
• Reduce the burden of correcting data prior to state reporting
• Reduce the data redundancy placed on LEAs
• Provide actionable data back to LEAs that support decision making
What does
this mean for
my district?
•
•
•
•
•
File layouts will change
More roles in Pipeline will allow more people to see reports
Errors can be corrected on-line
Reports on all collections can be run at any time (i.e. HQ)
Data may be submitted at any time
Collection Submission Process
 Current Process
 Point-in-time
 Level 1 & 2 edits – collection specific
 Flat files only
 Each collection has a collection owner
 New Process
 Interchanges rather than collections
 Ed-Fi data model (national standard)
 Level 1 business rules
 Snapshots
 Level 2 business rules
 Submission options
 Process for interchanges will need to be developed
Interchanges
Interchange
Student & Enrollment
Collections Represented
Student October
Student End of Year
Special Education December Count (student)
Special Education End of Year
Pre-coded Labels
SBD (CELA, TCAP, ACT)
Files Required
Student
Student School Association
Advanced Course Completion
Staff & Assignments
Human Resource
Special Education December Count (staff)
Staff
Staff Assignment Association
SPED Discipline
Special Education Discipline
Discipline Incident
Discipline Action
Special Education IEP’s
Special Education December Count (student)
Special Education End of Year
Special Education Child
Student Admin Unit Association
Student Special Education Participation
Student Parent Association
Teacher/Student Data Link
Math and Science Partnerships
Math Science Partnership
Title 1 Interchange
Consolidated State Performance Report (CSPR) TBD
New
Non-Interchange Collections
Collections Represented
Files Required
READ (formerly CBLA)
1 flat file
Colorado English Language Assessment (CELA)
1 flat file
Transitional Colorado Assessment Program
(TCAP)
American College Testing (ACT)
1 flat file
Report Card March
N/A – Online web form
December Finance
1 flat file
RITS (Batch & Read)
1 flat file each
EDIS (Batch & Read)
1 flat file each
Organizational Profile - Directory
N/A – Online web form
11th Grade Alternate Assessment
N/A – Online web form
1 flat file
Benefits of the new process










Earlier clean up of data
Centralized set of student demographics
No longer just about state reporting
Getting ahead of the cross -LEA errors and post collection
processes
Data on transferred students – dropout rates
Ability to run snapshots at any time (i.e. HQ)
RITS/EDIS Optimizer now in Pipeline
Web services will reduce data submissions
More roles in the Pipeline
Online error corrections
What does this mean for you?
 File layouts will change
 New process will need to be developed
 More coordination with AU’s/Districts
Implementation Approach
• Piloting Pipeline
– Phase I - 3-5 districts per collection; 1-3 months
– Phase II – additional districts through June 2013
• Retiring ADE
– Year round collections (Directory, RITS Batch, EDIS Batch) will open
in Pipeline on July 1, 2013.
– All other data will begin in Data Pipeline on September 1, 2013*.
– Collections opening in ADE during 2013 will also close in the ADE
system. Example, Student End of Year will open in ADE around May
2013 and close in ADE around November 2013. At the same time
data for the new collections will also be submitted in the Data
Pipeline beginning September 1, 2013.
– Officially close on December 31, 2013.
*Exception being the Safety and Discipline Indicators Collection
Timeline
Getting Started with Pipeline
 Familiarize yourself with the new system roles within Pipeline.
Role
Primary Function
LEA Submitter
The LEA Submitter’s main role is to upload data for a dataset
and to make corrections to that data.
LEA Approver
LEA Approver’s main role is to provide final sign-off for an LEA’s
data. This role also has all the permissions of the LEA User role.
LEA Viewer
The LEA Viewer’s main role is to view an LEA’s data. This role
will not have any write access.
Getting Started with Pipeline
 Familiarize yourself with the new system roles within Pipeline.
 List the collections, role and people filling the role for your
records. Send to your Local Access Manager before Pipeline is in
production.
Collection
System Role
Name
Email
Staff Profile
LEA Submitter
Lisa Bradley
[email protected]
Staff Profile
LEA Viewer
Jan Petro
Human Resources
LEA Submitter
Kevin Smith
Human Resources
LEA Approver
Jan Petro
Human Resources
LEA Reviewer
Annette Severson
Where can I find out more information?
 Data Pipeline Project
 Lisa Bradley - [email protected]
 303-866-4902
 Or visit http://www.cde.state.co.us/rise/ADEReplacement.asp
Overview of RISE, Data Pipeline Project and
Teacher Student Data Link
RISE
Data Pipeline
Staff
Interchange
Other
Interchanges
and Data Files
Teacher
Student Data
Link
Collection of
EDIDs, SASIDs,
& SSCCs
EDID = Educator Identifier
SASID = Student Identifier
SSCCs = Common Course Code
Staff Interchange
Data Pipeline Project
Staff Interchange Overview
 Will include all data from current ADE Collections:
 Human Resources
 Special Education December Count (Staff)
 2 files included
 Staff Profile
 Staff Assignment Association
 Files may be submitted throughout school year
 Data may be corrected online
 All data must be reviewed and accurate for ‘snapshots’ taken for
HR and Special Ed Staff data requirements
Staff Interchange: Human Resources
Snapshot Workflow
Staff Interchange – Next Steps
 A few districts will be trained and piloting system
November/December
 Training to occur in November
 Additional districts may pilot system starting in
January/February
 Additional training opportunities will be available throughout
next year
 Staff Interchange File Layout now available at:
 http://www.cde.state.co.us/rise/ADEReplacement-Rationale.asp
Overview of RISE, Data Pipeline Project and
Teacher Student Data Link
RISE
Data Pipeline
Staff
Interchange
Other
Interchanges
and Data Files
Teacher
Student Data
Link
Collection of
EDIDs, SASIDs,
& SSCCs
EDID = Educator Identifier
SASID = Student Identifier
SSCCs = Common Course Code
Teacher – Student
Data Link
(TSDL)
Educator Identifier Project
Phase I: Assign IDs
Mary Jones
555-23-7621
Phase II: Data
Collections
54682934
Phase III: Link with
Students
54682934
54682934
Purpose
 CDE's educator identifier system links student data to educators
for the purposes of:
 Improving instruction;
 Informing and increasing educator effectiveness; and
 Supporting the continuous improvement of teaching and learning.
 These three elements comprise the core components of the
state's performance management system. As such, the educator
identifier system serves as a foundational data infrastructure to
support and inform the state's performance management
system.
Objectives
 Allow users to evaluate and measure teacher effectiveness by
examining and improving educator preparation programs,
induction and professional development
 Allow the state, districts and schools to study educator mobility,
recruitment and retention issues
 Identify highly effective teachers as well as address inequities in
their distribution between high and low poverty schools as well
as schools with high and low minority populations
 Enhance the ability to develop strategies for improving teaching
and learning by linking student achievement data to the
student's teacher(s)
How Will the State Use Linked Data?
Example: Teacher Portal on
SchoolView
Information
Management and
Research
To be
defined
(local)
Evaluation
and
Accountability
Policy Making
and Technical
Assistance
Example: Assistance
CDE is providing to
the 30 districts with
a Teacher Gap.
Proposed Plan for Linking Educators
and Students
Common
Course Codes
37662184
• HS Math Teacher
• Colorado HS
378193216
th
• 10 Grade Student
• Colorado HS
Educator of
Record
 Five digit common codes for all courses PK -12
 Based on the Prior-to-Secondary and Secondary School
Common
Course
Codes
Course Classification System: School Codes for the
Exchange of Data (SCED).
 Statewide course codes create a standard
 Provides more reliable and consistent data across districts.
 Middle & High School required Feb 1 st 2013;
Elementary required May 2013
 Districts are to MAP their current codes, not
change their existing codes
 To find out more information:
 http://www.cde.state.co.us/EDIDProject/FAQ-SSCCProject.asp
 Or contact Kevin Smith:
[email protected]
 Educator(s) of Record: An individual or
Defining
Educator
of Record
individuals who have been assigned
responsibility for a student's learning in a
subject/course with corresponding aligned
performance measures in both state and
local assessments.
 Contributing Professional(s): An individual
or individuals who have been assigned
responsibility to provide additional
services that support and increase a
student's learning in a subject/course with
corresponding aligned performance
measures in both state and local
assessments.
Data Collected for TSDL






School Code
SASID
EDID
Course
Section*
Role*
 Educator of Record
 Contributing Professional
 Weight*
 Start Date*
 End Date*
 Verified*
*Not Required at this time
TSDL System Overview
 Collection System will not be in Pipeline
 Very similar to the Statewide Standard Course Code System (SSCC)
 Batelle Roster Verification is a resource that may be used to assist
with reporting data – more info will be provided
 All must have courses mapped to a Statewide Standard Course
Code within the SSCC prior to reporting linked data
TSDL Collection Timeframe
 New Collection-beginning Fall 2013
 Districts MUST have courses mapped to the Statewide Standard
Course Codes prior to TSDL opening
 Districts will be piloting the new system soon
 Currently determining reports for both:
 verification of data and
 useful information for districts
Where can I find out more information?
 By visiting: http://www.cde.state.co.us/rise/TSDL.asp
 Or, by contacting Annette Severson
 [email protected]
 303-866-6824
THANK YOU!
Annette Severson