Transcript Document

Data Warehouse
New Data Administrator Training
October 3, 2014
Data Coordinators: Larry Hunt & Angie Russell
Grounding
 Name, district, role
 Share your rating on the data survey and why
Data Skill Survey
5. Data? No problem. I invented data.
4. I’m OK. I taught high school statistics.
3. I used data to plan instruction, and it
helped a lot.
2. I was assigned this position, but not sure
what data skills I’ll need.
1. I like data except for the numbers part.
Goals of this session…
 Gain an understanding of the Data
Warehouse, SIRS and the NYS reporting
process in schools
 Discuss roles and responsibilities of the
District Data Coordinator
 Consider key personnel responsible for data
reporting
 Discuss roles and purpose of a data
verification team
What is a Data Warehouse?
A data warehouse is a storage facility
or repository that maintains large
quantities of data that would typically
reside in a number of disparate
locations.
What are the benefits of the Data
Warehouse?
 The Data Warehouses includes a wide variety
of current and historical information, including
demographic, enrollment, program service,
and assessment data, and others
 It allows for the merging of data sets and data
sources that are otherwise difficult to combine
or compare
Purposes of the Data Warehouse
 To help educators in NY make sound, databased plans and decisions about their work
 To help SED evaluate education in NYS
 To support funding decisions at the state and
federal level
 To hold school districts accountable
The Structure
of the Data Warehouse
How schools report data?
State Educ. Dept.
NYS School
Report Cards
Federal Reports
PD System
Statewide Repository – Level 2
Portal
COGNOS Level 2
reports
Regional Data Warehouse – Level 1
Level 0
Student
Management
System
Special Education
System/ Intervention
Tracking System
HR
Service
Package
COGNOS
Level
One
Food
Service
Package
Data Warehouse Terminology
 Various software
packages
 eScholar Templates (23)
 Level 1C (container)
 Level 2
 Level 0
 COGNOS State
Reporting (L2RPT)
 Level 1
 PD – VR reports
 COGNOS
Report/Cubes
 NYSSIS
 Level 0 Historical
Refresh Cycle for Loading Data










Level 0
Level 1 – From Level 0
Level 1 – From SIS/IEPD/
Nutrikids/etc.
Submit to NYSSIS
Level 1 Cognos Reports
Level 1 Cognos Cubes
Level 1 Container
Level 2 Reporting
PD System
From Level 1 nightly
Every 15 minutes (Mon-Thurs)
First thing Thursday
8 AM Thursdays
Instant from Level 1
As needed
Friday midnight
Monday @ 6 AM
Monday @ 6 AM
NYS Unique ID System
(NYSSIS)
District
SMS
Student ID
Data Set
Regional
Data
Warehouse
(Level 1)
NYSSIS
State ID
Near Match
Resolution
Level 0 Historical
NYSED Business Portal
The Role of the Data
Administrator
What is a data administrator and
what should they be doing?
A district level administrator who is responsible for the accuracy
and effective use of district’s data.
Key Responsibilities Include:
 Attend informational sessions provided for District Data Coordinators by
Level 1 data centers

Coordinate and facilitate district data team meetings

Monitor compliance with regard to data standards and maintenance of
records

Ensure data extracts conform to the Data Warehouse file format and
include all required fields as specified in the templates

Secure certification

Assist in the direction of the data analysis activities and instructional
improvement initiatives
Demographics
 Student demographics include basic student data
 Student ID, student name, grade, birthdate, gender,
ethnicity, and parent contact information
 Can change during the year
Student Enrollment
 Student enrollment - when the student
enters and/or leaves the school district
and/or changes program
Program Fact/Services
 These are facts about students
 They have a beginning date, and can have an
ending date
 Typical Program Facts would be Free and
Reduced Lunch, LEP, Disability, Reading First,
NCLB groups (Title One) Liberty Partnership
Assessment Fact
Assessment Response
 Assessment Fact
 Test Group Codes ( ALTREG, CTE, NYS,
NYSAA, Regents, NYSITELL etc.)
 Standard Achieved Codes
 Level 1, Level 2, Level 3, Level 4,
Medically Excused, Admin Error
 Assessment Response
 Item Response Data
So, What Should I Do To Get Started?
 Each district should identify a Data Administrator
 Contact CNYRIC DW team
 Develop a team, and establish processes
 This is not a one person task
 Review data reports monthly
 Make sure that others understand their roles in the
process. The State provides deadlines, make sure
deadlines are well communicated to team.
Certification Overview
 October – Staff Evaluation Rating
 December – August Graduates
 January – BEDS
 April – BEDS
 May – BEDS – Free and Reduced Lunch
 June – Teacher Student Data Linkage Staff Assignment
 August – End of Year
Effective Data Use
 Give data to teachers in a format they
are able to understand
 Investigate effective data facilitation
strategies
Contact Information
Donald DeJohn, Ph.D.
Lori DeForest
Project Manager,
Supervisor,
Data Warehouse
Data Analysis Services
[email protected]
[email protected]
(315) 433-2217
(315) 433-2247
Websites for Data Administrators
 Information Reporting Services (IRS): http://www.p12.nysed.gov/irs/
 Student Information Repository System:
http://www.p12.nysed.gov/irs/sirs
 IRS Calendar: http://www.p12.nysed.gov/irs/calendar-irs.html
 Business Portal: portal.nysed.gov (IRSP)
 LDS TAC: http://www.nysldstac.org/
 Templates: http://www.p12.nysed.gov/irs/vendors/templates.html
 Accountability: http://www.p12.nysed.gov/accountability/
 http://www.cnyric.org/teacherpage.cfm?teacher=1242
What is your one burning
question about being a Data
Administrator?