New CIO Training 2012-2013

Phase I: Intro to Data Warehousing

S

What Is SIRS?

S The New York State Student Information Repository System (SIRS) provides a source of standardized individual student records for analysis at the local, regional, and State levels to improve student performance and to meet State and federal reporting and accountability requirements. S There are multiple data collection points within SIRS. The first point is the local student management system (SMS) used by your school. If you have a local SMS, you can import your data files from your SMS into “Level 0,” the second point within SIRS. Schools that do not have a local SMS can enter their data directly into “Level 0.”

What is Level 0?

S Web-based application hosted by NERIC. This applications provides your school with the ability to enter and verify data. Data can be electronically imported or you can manually enter data directly into this system. S Verified data is uploaded from Level 0 by you and then migrated by NERIC directly into Level 1.

What is Level 1?

S Level 1 is operated by NERIC. S The data collected at this level that came from Level 0, are used for local data analysis and reporting (L1 Reports). Level 1 is also used by NERIC for pre-printing scannable assessment answer sheets. S Level 1 prepares data to upload to the Level 1 Container, which is the last stop at NERIC, before data uploads to the State database.

What is the Level 1 Container?

S After passing more sophisticated errors (M2L1C errors), all data migrates into what is called the Level 1 Container. S Here it waits until SED comes through once a week (on the weekend) and grab all across from the containers across the State, to upload to their database, Level 2.

What is Level 2?

S L2 is a single, statewide data warehouse, where all required student data from all schools in New York State are combined. S In the Level 2 Repository, each student record is uniquely identified with a 10-digit NYSSIS number assigned after NERIC sends a file for the student to NYSSIS when he/she first enters a school. S Level 2 provides data for determining the accountability status of public and charter schools and districts, to meet federal reporting requirements, to inform policy decisions, and to meet other State needs for individual student data.

What is NYSSIS?

S NYSED developed this system to assign a stable, unique student identifier (or NYSSIS ID) to every student. S Each student record is uniquely identified with a 10-digit ID number assigned when the student first enters a NYS school.

S These unique IDs improve data quality and ensure that students can be tracked longitudinally as they transfer between schools. This unique ID will follow the student through his or her entire academic career, including college.

S The NYSSIS System is a web-based application that is used to identify a student and either create a new Unique ID or match to an existing ID for that child.

“PD System” and “L2RPTs?”

S Special Education Data, after uploading successfully to Level 2, moves to the “PD System.” This is where your CSE department will verify and certify VR-Reports. S Data, after uploading successfully to Level 2, become available to authorized users in the Level 2 reporting environment (L2RPTs), a statewide Web-based data reporting service that provides your school with a group of reports for accountability and analysis purposes. These reports are used by your administrators to verify and certify SIRS Data for the State.

Data Migration Diagram

Do NOT upload to L1 twice in one day

Why are we doing this?

S Data reported by your school can now be used to help guide instruction and improve student learning.

S Public/charter schools are held accountable for the testing, performance, and graduation of their students according to federal No Child Left Behind (NCLB) and state regulations. These schools are assigned a "status" based on their performance and are subject to certain consequences if their performance is not satisfactory. Data you submit through Level 0 is used for this purpose. S Level 0 is used to report TSDL (teacher-student-data-linkage) records and evaluation scores for teacher and principal accountability.

Terminology

Terminology:

SYSTEMS:

S

SIRS =

NY State Student Information Repository System. Provides a single source of student records for analysis at the local, regional and State levels. There are multiple collection points within SIRS (SMS, Level 0, Level 1, and Level 2 Repository) S

NYSSIS =

NY State Student Identification System. This is a system that assigns and allows you to search for a student UNIQUE state identification number. This is where a student who starts school for the first time in NY is assigned a unique ID, where a student who moves from one district to another is matched to an existing unique ID, or where you would go to “confirm” a match for a transfer student that NYSSIS identifies as possibly the same student from a previous district.

SIRS LEVELS:

S

SMS (Local Level) =

Student Management System (i.e. eSchoolData, SchoolTool, PowerSchool) S Level 0 web-based application (Local Level) = A single point of access for importing all data from multiple systems used at your school. At this level, student records are identified by a local student ID. S S S S

Level 1 Repository (Regional Level) =

sheets are generated. A single point of access at NERIC for collecting all data from ALL schools in the Northeast region before uploading to the state. At this level, district & year specific reports (Level 1 reports, a.k.a. NERIC Production) and answer

Level 2 Repository (State Level) =

teacher. Statewide data warehouse, where all data from Level 1 (all RICs) are combined. At this level, student records are identified by the unique State ID (NYSSIS). Level 2 provides data for determining accountability, school and

PD System =

Web-based special education data reporting system. This is where only special education reports are generated and verified. These reports are certified directly in the PD system by the CSE chairperson.

L2RPTs =

Reports designed to help districts verify a variety of student demographic, enrollment, program, assessment, and graduation data, as well as teacher and principal accountability data.

Terminology Continued

TERMINOLOGY FOR IMPORTING & UPLOADING DATA IN LEVEL 0:

S

Import data =

To put data into Level 0 S S

Upload data =

To push data up to L1

Elect. Import =

Where you go in Level 0 to import a text file to load data into Level 0 S S S S

Manual input =

Screen in Level 0 where you manually enter or correct a single record

L1- Data Prep =

Where you go in Level 0 to upload each module (demo, enrollment, etc.) to Level 1

Reports =

Where you go in Level 0 to view a variety of reports regarding data in the current school year.

L0 Express =

Screen in Level 0 where you import or manually add Staff Snapshot and Course data.

MODULES (SCREENS) IN LEVEL 0:

S

Demographics (a.k.a Student Lite) =

unique State IDs. In Level 0 where a student’s demographic data is reported (name, guardian names, date of birth, address, cohort year, etc.). This data is used by NYSSIS to assign or match S

Enrollment (a.k.a Entry/Exit) =

In Level 0 where information regarding the student’s enrollment is reported (building the student is enrolled in/location code, date of entry, entry code, date of exit and exit code, etc.) S S

Program Fact (a.k.a Program Services) =

In Level 0 where information regarding additional services received is reported (i.e. free/reduced lunch, poverty, disability type, Title funding, etc.)

Assessment =

Where state assessments (ones that are not scanned and uploaded to Level 1 for you by NERIC) are reported (i.e. RCTs, COSF, CTE skill assessments) S S

SE Snapshot =

Screen in Level 0 where BEDS Days snapshot records and EOY Snapshot Records are entered.

SE Event =

Screen in Level 0 where SPED Events (IE, CPSE, CSE) records are entered.

Terminology Continued

TERMINOLOGY FOR IMPORTING & UPLOADING DATA IN LEVEL 0 (Continued):

S

Grade Detail

= Final COURSE outcome S

Staff/Student/Course

= Roster and Teacher Evaluation (aka Assessment Group) records. Two records per course: One roster and one evaluation record. S S

Accommodation

= Records showing accommodations given during a state test that was not scanned by NERIC (June 2012 new reporting rule)

Staff Evaluation =

Screen in Level 0 where the Assessments Growth, local, other and total composite scores are reported for teacher accountability.

ERRORS:

S

Import Error =

Error generated on import (when putting data into L0). Have to be corrected in order for this record to import into Level 0. S S S

Information Error =

Found under reports in L0 (after data has been put into L0). These may be errors or be just be warnings. Please check them!

Verification Error =

After records are imported into Level 0, verification errors are run before you can upload to L1. These errors need to be corrected before uploading can occur.

Level 0 to Level 1 =

Errors generated after data is uploaded from Level 0 before it enters Level 1. S S

M2L1C Errors = Dataflow Errors =

Errors that are generated going into the Level 1 container, before it moves to L2. If you are using Dataflow, these errors can be found in your

Contacts:

S Please email all questions to: [email protected]

S Or call our Data Warehouse Hotline at: 518-862-5409