Transcript SIF and Data Warehousing

SIF
Schools
Interoperability
Framework
IASBO Conference – May, 14 2008

Dave Moravec




Business Development Manager @
Integrity Technology Solutions
Co-Lead of the SIF Association’s
Marketing and Membership Committee
Committee Participation: Certification,
Implementation Task Force, Data Modeling
Task Force
IASBO Technology Committee Member
What do you know about SIF?
Have heard of SIF?
 Do you have a basic understanding of
SIF?
 Do you know other districts that have
implemented SIF?

“Pains” Addressed by SIF

Situational




Fast growth
Legacy systems
Large enrollment
Data





Redundant data entry
Data accuracy
Data integrity
Data latency
Leverage entrenched legacy systems
SIF Review
Cafeteria
• The situation in many
schools and school
systems is that there
are a series of
software applications
which all may require
the same data, but
which have no way to
talk to each other.
• It may be possible for
one or two
applications to share
data through
proprietary methods,
but open, dynamic
and synchronized
data sharing does not
occur.
?
SIS
?
?
Network
Accounts
?
?
Library
Transportation
Official Specification
Releases
2000
2001
2003
2004
2006
1.0
1.0r1
1.1
1.5r1
2.0
SIF Reporting Web Services Specification
Version 1.0 released October 18, 2006
Copyright © SIF Association
2007
2.0r1
Two (2) Major Components of SIF
1. Infrastructure
 How
you move data in a standard way
2. Data Model
you define the data in a standard
format
 How
1. Infrastructure






How you move data

HTTP/S
Security
 Authentication
 Encryption
Message based
Asynchronous (like e-mail)
Reliable
Adaptable to many scenarios
 Fast networks
 Slow networks
 School-based systems
 District-based systems
 State and federal
systems
1. Infrastructure (continued)

Zones and Zone Integration Servers





A Zone is group of "systems" that want to
share data
Data flow among systems is controlled by the
Zone
Various "topologies" exit for zones
A Zone Integration Server is a software
server that can support one to many zones
Agents and Applications


SIF Agents connect software applications to
zones/ZIS's
Translate data between the application's
format and the SIF data model
2. Data Model

How you define the data
Standard way to represent data in
K12 schools
 Defined using XML (a standardized
data language)
 SIF Objects

 StudentPersonal
 StaffPersonal
 SchoolInfo
Administrative Software











Student Information System
Food Service
Transportation
Library Science
Directory Services
Learning Management
Parent Communications
Special Education
Healthcare Management
Human Resources – Finance
Maintenance & Inventory
Agents: The Universal
Translator



From an
implementation
perspective, SIF
Agents have 2
“faces”
Translate
between your
application and
the SIF data
model
Responsible for
generating and
processing SIF
objects
ZIS
SIF
Data
Model
Application
“Native”
Agent
Application
Applications of SIF
Horizontal / Intra-District Application

Facilitates the flow of data from system to system
within the confines of a district
3 Basic Vertical Applications



System 2
Facilitates the flow of data from a district to other
entities
District to District


System 1
Entity 2
K-8 District  9-12 District
District to State
District to Federal
Entity 1
SIF Review
Required Software

Zone Integration
Server (ZIS)

SIF Agents

Applications

SIF Data Objects
The SIF Language
Skyward
Novell EDirectory
H.R. &
Finance
Follett
Destiny
WinSNAP
Grade
Book
VersaTrans
Renaissance
Place
eTranscript Choreography
SIF _Event:
“Time for matriculation”
SIF _Request:
“Please send the
transcripts”
SIF _Response:
“Here are the transcripts”
Legend
Event
Request
Response
High
School
District
Association
Zone
Agent
ZIS
K-8
District
#1
Agent
K–8
District
#2
Agent
K-8
District
#3
Agent
K -8
District
#4
Agent
Business Processes
Data Entry for Students & Staff
 Network Account Management
 Associated Software Packages
 Student and Data Synchronization
 District Reports
 State Reports

SIF in Illinois
Addison Elementary District 4
Bloomington District 87
Harlem Consolidated District 122
Huntley/Algonquin District 158
Lake Zurich District 95
McLean County Unit 5
Naperville District 203
Pekin Elementary District 108
Ottawa Elementary 141
St. Charles District 303
Tinley Park District 146
Implementation Examples

Naperville, IL District 203

Huntley, IL District 158

Tinley Park, IL District 146
Comalex
SchoolInfo
StudentPersonal
StudentSchoolEnrollment
Data
Warehouse
SchoolInfo
StudentPersonal
StudentSchoolEnrollment
SchoolCourseInfo
SectionInfo
StudentSectionEnrollment
TermInfo
RoomInfo
StudentDailyAttendance
AttendanceCodeInfo
Universal
Agent
Lawson
Financial
VersaTrans
Agent
Target System =
VersaTrans v9.3
District Zone
Zone Integration Server
Universal
Agent
SchoolMax
StaffPersonal
StaffAssignment
StudentPersonal
StudentSchoolEnrollment
Schoolnfo
StudentContact
SchoolInfo
StudentPersonal
StudentSchoolEnrollment
StudentContact
SchoolCourseInfo
SectionInfo
StudentSectionEnrollment
TermInfo
RoomInfo
StudentDailyAttendance
AttendanceCodeInfo
Universal
Agent
CarterPertain
StaffPersonal
StaffPersonal
Universal
Agent
CarterPertain
Zone Integration Server
Universal
Agent
SchoolMax
Universal
Agent
SchoolMax
StudentPersonal
StudentContact
ParentLink
Kennedy Junior
High
StudentPersonal
StudentContact
StaffPersonal
Central High
School
StudentPersonal
StudentContact
StaffPersonal
StudentPersonal
StudentContact
ParentLink
Assessment
Data
Reports &
Analytics
OLAP
Transactional
Data Staging
Integrity
Data
Warehouse
Agent
RoomInfo
SchoolCourseInfo
SchoolInfo
SectionInfo
StudentContact
StudentPersonal
StudentSchoolEnrollment
StudentSectionEnrollment
TermInfo
StudentDailyAttendance
District Zone
Consolidated 158
(Huntley/Algonquin)
Universal Agent
Target System =
PowerSchool
Primary Publisher
Destiny Agent
Authentication
SchoolInfo
StaffPersonal
StaffAssignment
StudentContact
StudentPersonal
StudentSchoolEnrollment
SchoolInfo
StaffPersonal
StaffAssignment
StudentPersonal
StudentSchoolEnrollment
Authentication
SchoolInfo
StudentPersonal
StudentSchoolEnrollment
Target System =
Follett Destiny v5.5
VC Agent for AD/
Exchange
TargetSystem =
Active Directory
Zone 1
Zone Name = d158
SIF Version = 1.5r1
Server = CPSI SIF Connect Server
SchoolInfo
StaffPersonal
StaffAssignment
StudentPersonal
StudentSchoolEnrollment
SL Agent
Target System =
SNAP, MyCard
SchoolInfo
StudentContact
StudentPersonal
StudentSchoolEnrollment
VersaTrans Agent
Target System =
VersaTrans v9.3
Tinley Park District 146
Systems Integration Plan
Special Ed/IEP Flags
Legend
Current Students
Publish
Subscribe
PowerSchool
Historical Students
FileMaker
Historical SIS
Special Ed
Periodic
Export/Import
One-Time
Export/Import
SIF
Application
Follett
Circulation Plus
(per building)
Non-SIF
Application
SIF
Zone
Active Directory
Narrative
1. SIF will be implemented to
automate data exchange among SIF
enabled applications including
PowerSchool, Follett Circulation Plus,
Versatrans, and Active Directory.
Setting up SIF involves implementing
a Zone Integration Server and SIF
Agents for each of the applications.
School Zones
District Zone
VersaTrans
2. Ideally, the current special
education system will be replaced
with a SIF certified system at some
point in time. PowerSchool’s SIF
agent will need to support
subscription to SIF Special Programs
data in order to completely automate
data exchange.
3. In the interim, special education
data import and export can be
automated using server-based
techniques to minimize the burden on
staff. A one-time export/import of
historical student data will
consolidate general student data
within PowerSchool.
© 2007 Integrity Technology Solutions. All rights reserved.
Page 1
Author: Jason Wrage
Updated: 5/14/2008
Hard Costs: SIF Software
 Zone
Integration Server
 Subscription
vs. outright
purchase
 Pricing models generally by
district size
 Agents
 Varied
pricing models
 Installation and
configuration pricing
Hard Costs: Infrastructure
 Zone
Integration Server
 Hardware
 Operating
system
 Supporting software
 Agents
may or may not need
dedicated hardware
 Adequate bandwidth – T1 or better
Hard Costs: Consultants

Consultants and integrators
Provide advice and/or implementation
services
 Prior SIF experience is required!
 Scope-based fees or hourly/daily rates


Consider joining the
SIF Association
Networking opportunities
 Learn from others
 Communicate your needs

Soft Costs
 Mainly
staff
time for:
Research
Planning
Training
Implementation
Support
Implementation vs.
Operational Costs


Implementation costs
 Up front investments
 Phasing can spread implementation
costs over time
Operational costs
 Resources to support and maintain the
implementation
 Software subscriptions or maintenance
fees
 ZIS hardware lifecycle
Financial Benefits
Saving Money

Reduce costs
Creating and maintaining
customizations and
processes
 Purchasing data extraction
software


Maximize efficiency
Staff time to run manual
export/import processes
 Data entry time
 Quality and timeliness of data

Non-Financial Benefits

SIF is the conduit for high quality data

Combining…
1.
2.
3.
Data quality
Teaching & learning and
SIF
… results in improved student achievement

Expedited user provisioning

Improved productivity to students, teacher,
administrator
Determining Your ROI
SIF Balance Sheet
Costs
Financial Benefits
Money Saved
Money Earned
Non-Financial Benefits
- Student achievement
- Data quality
- Productivity
Benefits
Hard Costs
$20,000
SIF Software
$50,000
Infrastructure
Applications
SIF Agent Development
Consultants
Soft Costs
Staff Time
Total Estimated Benefits
$10,000
$0
$0
$0
$5,000
$70,000 Total Estimated Costs
Total Estimated ROI (Financial)
$52,000
$3,000
$18,000
Cost-Benefit Example

Network Account Creation and Management
 SIF capability
 Student directory accounts created at
registration into SIS
 Example
 SIF is used to create and manage user
accounts, eliminating the additional manual
step as the student is enrolled
 Benefit
 Huge time savings to I.T. department
Does your I.T. staff have more valuable
ways to spend its time?
Cost-Benefit Example

Transportation
 SIF capability
 Data accuracy & Saved data entry time
 Example
 SIF is used to update the transportation system
data from the student information system as
the student is enrolled in school
 Benefit
 Real time communication of bus stop
information is possible for every student
 Potential liability issues are avoided
How many phone calls could be saved?
How much bad publicity could be avoided?
Cost-Benefit Example

Library
 SIF capability
 Near real time information dissemination
 Example
 SIF is used to send the school media services
specialist an e-mail when a student is leaving
the district
 Benefit
 The media specialist can coordinate the return
of all materials prior to the student’s departure
How many books leave the district per
year?
Cost-Benefit Example

Food Services
 SIF capability
 Data accuracy
 Example
 SIF is used to update the student management
system with meal status information that is
stored in the food services system
 Benefit
 Accurate free/reduced lunch count possible.
How much additional funding could be
generated?
Thank You!
SIF Website: www.sifinfo.org
Integrity Website:
http://k12.integrityts.com
Dave Moravec
[email protected]
309-664-8115