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?