May 2009

Pilot Districts TrainingSummer OASIS

• Introductions• Unity Project Overview• Automated Data Collection Process and Summer OASIS

– SRM Overview– OASIS File Layout– Data Validation Rules– Data Collection Process Demonstration

• Wrap-up

Agenda

Who Are These Guys?

Steven King Vice President

sking@espsg.com

UNITY Project

Data Dictionary

Education Data Warehouse

Reporting Portal

Automated CollectionSIF Deployment

Phase 1

Phase 2

Phase 3

Phase 4

2005 2006 2007 2008 2009 2010

Automated Data Collection• State Report Manager from ESP Solutions Group• Upload CSV, TXT (tab delimited) or SIF file• Immediate Data Validation prior to Certification• Friendly Interface• Embedded in Unity Portal

– Single Sign on

Collection Schedule

Collection Pilot Collection Full State Roll-outFall OASIS Nov ’08 Nov ’09Spring OASIS Apr ’09 Apr ’10Summer OASIS Jun ’09 Jun ’10Fall Certified Staff Sep ’09 Sep ’10Fall Paraprofessional Sep ’09 Sep ‘10

The ProcessDistrict

Creates The File

Upload the File to SRM

Any Errors

?

Correct the Source

Correct Errors

Revalidate

Certify SubmissionFix Source

Systems

No

Yes

Yes

No

Correct Submission

File

The File Spec Document• Collection Information• Item Details• Data Validation Rules• Option Sets

Item Details

Data Validation Rules

Option Sets

Data Validation Rules74000 Missing required field74001 Field exceeds its maximum length74100 The reported Alaska Student Identification Number was not found in

the Student ID system74101 The first name, last name, and/or birth date of the student does not

match the student ID system

Data Validation Rules74201 City/Town/Village is invalid74202 The Zip Code is invalid74203 Gender is Invalid74204 Race/ethnicity code is invalid 74205 School ID is Invalid74206 Grade level code is invalid74207 Disability Category is Invalid74208 IEP in Place July 1 is Invalid74209 Transfer to General Ed Code is Invalid74210 Entry Type is Invalid74211 Exit/withdrawal Type is Invalid74212 Enrolled Last Day is Invalid74213 LEP Status code is invalid74214 LEP Language is Invalid

Data Validation Rules74215 Former LEP Progress is Invalid74216 Is Economically Disadvantaged is invalid74217 Is Title 1A is Invalid74218 Is Immigrant is Invalid74219 Is Homeless is Invalid74220 Homeless Residence is Invalid

Data Validation Rules74300 The zip code is not valid for the place74301 The grade level is not taught in the school74400 The first or middle name can contain only alphabetic characters,

period, apostrophe, space, or hyphen74401 Zip+4 can only contain the numeric digits 0 - 974402 Local student ID can only contain the digits 0-974403 Date Format is Invalid74404 Format for Aggregate Days Membership or Attendance is Invalid74405 Immigrant First US Entry Date Format is Invalid74501 Open schools serving any of grades PK-12 should have students74502 Grade served does not have students74503 There must be at least one record n the district submission

Data Validation Rules74701 Student with disability younger than 3 or older than 2174702 Regular education student age must be between 4 and 20 inclusive

(except Adults)74703 The age of the student falls outside the expected bounds.74704 Age is outside the allowable range for this grade level74705 LEP Language Mismatch74706 Days in Attendance exceeds Days in Membership74707 Disability Code / IEP in Place July 1 code mismatch74708 Language for non LEP student74709 Former LEP Progress is Required

Data Validation Rules74710 Other Language Type Missing74711 Missing Homeless Primary Nighttime Residence74712 Days Attendance more than possible74713 Days Membership more than possible74714 Membership and Attendance must be zero (0) for grade Adult (AD)74715 Graduates with Waiver must have waiver on file74716 The Transfer to General Ed Date is required when Transfer to

General Ed is "Y"74717 Exit/Withdrawal Date without Exit/Withdrawal Type74718 Immigrant without a US Entry Date

Data Validation Rules74901 Exit Date before Entry Date74902 Entry Date before first day of School74903 Exit Date after last day of School74904 Entry Date before Birth date74905 Transfer to General Ed prior to Entry74906 Immigrant US Entry Date prior to student's Date of Birth74907 Immigrant US Entry Date after School Entry Date

State Report Manager

http://spea.eed.alaska.gov/srm