Growing Pains and Platform Migration

SIMARN SOLUTIONS: www.simarn.com

Simarn Solutions has partnership with Microsoft and together we provided the Consulting Services for the development of MiSIS Integration Project.

CLIENT PROFILE:

Los Angeles Unified School District (LAUSD) is the second largest school district in our nation with more than 615,000 students. The schools were from Core K-12 Grades. The Teachers and administration were using “MyData” built by Oracle software to track student’s personal information like their daily performance and attendance reports. They were able to pull more than 300 reports that gives administrators and teacher’s access to relevant district or campus history information the student may have transferred from.
These reports compile a wide range of data including California State Test (CST) scores; Periodic Assessment scores and performance levels in English/Language Arts (ELA); Mathematics, Science and Social Science Attendance data; interim and final marks for all secondary courses and elementary subjects; intervention history; discipline data; English Learner (EL) status and level; the Individualized Education Program (IEP) for special education students and the CA High School Exit Exam (CAHSEE) results. The reports generate current student performance data and prior year (s) student performance data which shows growth or decline.  These multi-measure rosters for the teacher are key in the District’s
Response thru Instruction and Intervention (RTII) program for instruction that emphasizes the use of data in decision making. LAUSD uses Oracle BI Suite EE Plus to pull data information from multiple internal sources, as well as to link to external systems to produce accurate student transcript.
Integrated Student Information System (ISIS) was mandated by a 1996 Federal Consent Decree with established completion milestones. LAUSD spent $100M for an integrated solution spanning 10 years from 1998-2008. The vendor missed the federally mandated milestones 1-5 and LAUSD subsequently cancelled the Fixed Fee procurement. In 2012, LAUSD decided to lead the effort themselves and Microsoft, along with other vendors, was brought in to ‘support and assist’ LAUSD under a time and materials contract as staff augmentation. The District changed the name from Integrated Student Information System (ISIS) to My Integrated Student Information System (MiSIS) and made the system available in LAUSD in August of 2013. The total of $173.8M YTD was spent on MiSIS integration project.

PROBLEM STATEMENT:

LAUSD didn’t have good system to track student information especially when students were transferred from one school to another. The duplication cost them in billions of dollars. They decided to use variety of technology to combine all student information for accuracy. The purpose of using various technologies is to reduce risk of getting sued by teachers or students.
Microsoft came into help and come up with a solutions to track the following:

  1. Attendance
  2. Special Ed
  3. Multilingual
  4. Compliance

Oracle database solution “MyData” was a web based tool. It was working all areas of administration except overloading and crashing when it came to tracking student activities.
My Integrated Student Information System (MiSIS) is information all-in-one solution database:

  • Provides teachers, counselors, administrators, and others with access to student information all in one place.
  • Shows how a student is progressing toward graduation at any point in time.
  • Follows every student through his or her educational lifespan—from pre-kindergarten to graduation.
  • Allows the user to view student information for as long as that student has been in the District.
  • Is designed around the educational life of a student, bringing together attendance, assignments, grades, test scores, health, program eligibility, and more.
  • Is being improved with the help of educators and others who use it every day to support students.
  • Is the first fully-integrated student information system in LAUSD.
  • Is the largest and most complex student data system in the United States.
  • Has the flexibility to adapt quickly to evolving needs and requirements.

This provided new way to approach the parents and win their interest in getting them involved more.
MiSIS main “Components” to track student database:

  • Enrollment
  • Scheduling
  • Attendance
  • Grades
  • Academic Intervention
  • Graduation Standards
  • Grade Book (classroom assignments)
  • Counseling
  • Discipline
  • Health
  • Cafeteria – Meal Eligibility
  • Transportation
  • Special Education
  • English Learner Processes
  • Gifted and Talented
  • Summer School
  • Student Testing
  • Flexible Reporting
  • Parent Access (future enhancement)
  • Mobile Access (future enhancement)

SERVICE/SOLUTION:

Microsoft was brought in and they come up with a solution by creating a database that tracked student attendance and compliance issues. The school didn’t have a system that can track appropriately therefore Microsoft built a system called “MISIS” to track accuracy for budgeting and to avoid duplications of students.
Modern Apps, Microsoft Domain, Analytical, SSRS, Database Engine Integration
Microsoft migrated their data from existing Oracle and legacy systems to Microsoft SQL Server Platform. The new application was developed on Microsoft technologies using the work done for Fresno School District as an IP. We have added new features to the MiSIS for predicting the graduation outcome of the student, ability to generate data/reports for state and compliance reporting that brings in $12 billion a year in grants to LAUSD.

THE BENEFITS:

  • Consolidation of multiple Oracle and legacy systems to one single platform i.e. Application Portfolio Rationalization.
  • Transparency of processes and data for schools and the district
  • Implementation of Graduation Standards (A-G) for LAUSD, CDE & CSU Tracking
  • Students performance and predicting their Graduation Outcome for proactive remediation’s (if necessary) Moved part of Dev & Test to Azure.
  • Ability to report on state requirements and compliance.
  • The Challenges to Win/Challenges to complete List of challenges to win and challenges to complete.
  • Changes to Scope and requirements. Lack of SME availability

CONCLUSION:

LAUSD finally has a MiSIS Database which helps track accurate student information. This is also a web based and all updates are done accurately but our MiSIS Team. This database is known to be cost effective and LAUSD saved money by not spending on licenses