Docstoc

Superintendent Contract

Document Sample
Superintendent Contract Powered By Docstoc
					Statewide SIS Project Overview
          Presented by
     Howard C. Woodard, Ed.D
     Executive Project Director

      Summer GAMIS Meeting
           July, 2004
                 Georgia Department of Education,
             Kathy Cox, State Superintendent of Schools
Statewide SIS Project Overview
          Presented by
     Howard C. Woodard, Ed.D
     Executive Project Director

      Summer GAEL Meeting
          July, 2004
                 Georgia Department of Education,
             Kathy Cox, State Superintendent of Schools
      High Level Schedule
RFP Release                                                         2/25/04
Vendor Questions Due                                                3/11/04
Post Answers to Questions                                           3/16/04
Offeror’s Conference                                                3/17/04
Proposals Due                                                       3/25/04
Technical Evaluation                                        3/29/04-4/23/04
Cost Evaluation                                              5/4/04-5/17/04
Negotiations                                                5/18/04-6/28/04
Award Contract                                                      6/29/04

                   Georgia Department of Education,
               Kathy Cox, State Superintendent of Schools
      High Level Schedule
Vendor Begins Work                                          6/30/04
Detailed Requirements                                       8/12/04
Documentation
Detailed Project Plan                                       8/12/04
Completion of Initial Phase                                12/31/05




                  Georgia Department of Education,
              Kathy Cox, State Superintendent of Schools
         Contract Award
BearingPoint
– Named Prime Contractor for SSIS
– Contract signed and awarded on 6/29/04




                   Georgia Department of Education,
               Kathy Cox, State Superintendent of Schools
                Mission
Develop and Implement best in class
statewide student information system




                 Georgia Department of Education,
             Kathy Cox, State Superintendent of Schools
                     Vision
A fully implemented statewide student
information system delivering information
for regulatory reporting to state and federal
agencies and supporting critical decision
making by policymakers, educators and
members of the public.



                   Georgia Department of Education,
               Kathy Cox, State Superintendent of Schools
  Statewide Student Information
             System

                                              Statewide SIS



                                                                       Unique Testing Identifier
                    Decision Support System
                                                                               System



Analytical & Reporting Tools                       Data Warehouse




                                   Georgia Department of Education,
                               Kathy Cox, State Superintendent of Schools
                       Goals
Robust decision support analytical tools for
policymakers & educators at the state and local
level.

Standard and ad hoc reporting tools for GDOE &
School Systems.

Assignment of a unique testing identifier to each
student in the state and the creation of a system
to track, create and maintain the unique record

                    Georgia Department of Education,
                Kathy Cox, State Superintendent of Schools
   Core Elements of Project
Data Extraction
Data Warehouse
Business Intelligence Tools
Unique Testing Identifier System
Training




                 Georgia Department of Education,
             Kathy Cox, State Superintendent of Schools
Proposed Reference Architecture




              Georgia Department of Education,
          Kathy Cox, State Superintendent of Schools
            Data Extraction
Two primary methods will be used
– “Push”, whereby data extraction is initiated by district
  on a time basis from the local SIS and “pushed” to the
  GDOE data storage facilities for error checking and
  merging into data warehouse
– “Pull”, whereby data extraction is initiated automated
  trigger and the data is retrieved from local repository
  and “pulled” into the GDOE data storage facilities
  error checking and merging into data warehouse



                      Georgia Department of Education,
                  Kathy Cox, State Superintendent of Schools
Basic Elements of a Data Warehouse
                                                                               Data Presentation             Data Access Tools
  Operational Source               Data Staging Area                                                              (DSS, BI)
                                                                                     Area
      Systems




                                 Services:
                                   Clean, combine, and
      Database     Extract
                                      Standaridize                   Load
                                   Conform Dimensions                                               Access
                                                                                                              Ad Hoc Query Tools

                                                                                                              Report Writers
                                                                                  Data Warehouse
                                 NO USER QUERY
                                 SERVICES                                                                     Analytic Applications
                                                                                  DIMENSIONAL
       Database        Extract                                                    Atomic and                  Modeling:
                                                                                  summary data                 Forecasting
                                 Data Store:                                                                   Scoring
                                     Flat Files and relational                    Based on single              Data Mining
                                       tables                                     business
                                                                                  processes
                                 Processing:
                                                                                                    Access
                                    Sorting and sequential
                                      processing
                                                                     Load
       Database        Extract




                                  Ralph Kimball, The Data Warehouse Toolkit, 2nd ed, 2002




                                                         Georgia Department of Education,
                                                     Kathy Cox, State Superintendent of Schools
What a Data Warehouse Is
  The data warehouse, by design, contains
   current as well as historical data.
    The DW primary purpose is to enable the user to
     see a time dimension with regard to data and to
     enable extraction of trends and time-oriented
     analysis.
    The DW is a snapshot of the enterprise.




                     Georgia Department of Education,
                 Kathy Cox, State Superintendent of Schools
What a Data Warehouse Is
  Read only repository
       Data is current, historical, summarized, static at both a
       summary and an atomic level
    Unidirectional
    Integrated
    Subject oriented
    Time oriented
    Analytical
       Used to answer comparative and “what if” questions
  Reporting friendly
  Dynamic
  Only as good as the source data


                           Georgia Department of Education,
                       Kathy Cox, State Superintendent of Schools
What a Data Warehouse Is Not
    Operational
    Volatile data
    Bi Directional
    Source of data for operational systems
    Omniscient
       Due to ever changing requirements, no data warehouse or
       reporting repository can anticipate every need that will ever
       exist.
  Not a substitute for well defined business
   processes
  A Silver bullet
                           Georgia Department of Education,
                       Kathy Cox, State Superintendent of Schools
  Data Warehouse Domains
Assessment                                    Daily Attendance
Assessment Item                               Finance
Assessment Item &                             Location History
Program                                       Program Participation
Assessment & Program                          School Days
Course Attendance                             School Enrollment
Course Enrollment                             Special Education Events
Course Intstructor                            Special Education
                                              Services


                    Georgia Department of Education,
                Kathy Cox, State Superintendent of Schools
  Data Warehouse Domains
Staff Attendance                              Student Infraction
Staff Certifications                          Student Infraction
Staff Demographics                            Responses
Student
Demographics
Student
Demographics with
Reporting Districts
Student Grades
                    Georgia Department of Education,
                Kathy Cox, State Superintendent of Schools
 Business Intelligence Tools
Allow creation of reports
– Pre-defined
– User-created reports from data warehouse
  elements
Solution is customizable to meet needs of
different stakeholders



                  Georgia Department of Education,
              Kathy Cox, State Superintendent of Schools
Unique Testing Identifier System
System will provide a single, unique ID that will
be used for all program participation
Will create, assign and track a unique ID for
each student enrolled in a Georgia public PK-12
education system
System will allow both
– automatic creation of ID’s submitted through batch
  process, or
– Individual creation through direct online interaction
  with ID system
                       Georgia Department of Education,
                   Kathy Cox, State Superintendent of Schools
                Training
Training will be offered close final “go live”
date of SSIS
Training offered to local systems will be
coordinated by BearingPoint, GDOE and
ETTC’s
Training will cover
– Data Extraction
– Unique Testing ID System
– Business Intelligence Tools
                   Georgia Department of Education,
               Kathy Cox, State Superintendent of Schools
Proposed SSIS Architecture
        Topology




            Georgia Department of Education,
        Kathy Cox, State Superintendent of Schools
High Level Events for Rollout
Oct, Nov 04
– Prototype Data Warehouse Architecture
Dec 04, Jan 05
– Use FTE data from October count to populate
  Unique Testing Identifier System
Jan, Feb 05
– Begin test extraction from local SIS to GDOE
  data store from pilot districts

                   Georgia Department of Education,
               Kathy Cox, State Superintendent of Schools
What is needed for success
  First and foremost, consensus of the business
   problems to be solved
  Partnership between GDOE and the Districts
     We must all work as a team
  Establishment and adherence to business
   processes for handling data at the local level




                     Georgia Department of Education,
                 Kathy Cox, State Superintendent of Schools
What is needed for success
  Documentation of all local data handling
   business rules
  For best results, business processes should
   be identified and implemented before design
   segment of the DW definition.
     If this is not possible, at a minimum, they
     should be agreed to before Dimension
     creation is started.



                    Georgia Department of Education,
                Kathy Cox, State Superintendent of Schools

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:8/18/2011
language:English
pages:25
Description: Superintendent Contract document sample