For information technology investments only:
| Hardware | 0 |
| Software | 1 |
| Services | 99 |
| Other | 0 |
|
Table 1:
SUMMARY OF SPENDING FOR PROJECT PHASES |
|||||||||
| PY-1 and earlier | PY 2008 | CY 2009 | BY 2010 | BY+1 2011 | BY+2 2012 | BY+3 2013 | BY+4 and beyond | Total | |
|---|---|---|---|---|---|---|---|---|---|
| Planning: | 0.913 | 2.193 | 0.676 | 0.6 | |||||
| Acquisition: | 0 | 5.44 | 1.26 | 1.15 | |||||
| Subtotal Planning amp; Acquisition: | 0.913 | 7.633 | 1.936 | 1.75 | |||||
| Operations & Maintenance: | 0 | 0 | 3.136 | 1.79 | |||||
| TOTAL: | 0.913 | 7.633 | 5.072 | 3.54 | |||||
|
Government FTE Costs should not be included in the amounts provided above. |
|||||||||
| Government FTE Costs | 0.107 | 0.224 | 0.243 | 0.45 | |||||
| Number of FTE represented by Costs: | 1 | 1 | 1 | 2 | |||||
|
Performance Information Table |
|||||||
| Fiscal Year | Strategic Goal(s) Supported | Measurement Area | Measurement Grouping | Measurement Indicator | Baseline | Target | Actual Results |
|---|---|---|---|---|---|---|---|
| 2005 | Goal 2: Increase the academic achievement of all high school students. | Mission and Business Results | Customer Services | Percentage of planning and acquisition activities that can be accomplished on time | 0% | 100% | 100% of all required documentation was submitted and approved in the timeframe as planned. |
| 2005 | Goal 2: Increase the academic achievement of all high school students. | Customer Results | Delivery Time | Percentage of user group involvement in requirements definition | 0% | 100% | 100% of user groups have been established and user group meetings have been conducted. |
| 2006 | Goal 2: Increase the academic achievement of all high school students. | Mission and Business Results | Customer Services | Percentage of Design and development that can be accomplished. | 0% | 100% | System is 100% completely designed and 90% developed. It will be completed at the end of Sept. 2007. |
| 2006 | Goal 2: Increase the academic achievement of all high school students.Goal 2 | Customer Results | Delivery Time | Percentage of user group involvement in user interface design issues and other relevant user discussions | 0% | 50% | Users were 100% involved in user interface design during the two pilots and three user group meetings. |
| 2007 | Goal 2: Increase the academic achievement of all high school students.Goal 2 | Mission and Business Results | Information Management | Percentage of states that can track migrant student data via MSIX | 0% | 25% | Based on the 9 states that participated in the pilots, 100% could track student data during the pilot period. The system will not be fully operational until the end of Sep 2007. |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Customer Results | Customer Satisfaction | Reduced number of days in response time for States to request and receive migrant student information. | 14 days | 4 days | This measure was achieved during the MSIX Pilots. States could receive migrant student information within 4-days using the test data loaded in the MSIX System. |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Technology | Data Reliability and Quality | Percentage of States with improved data reliability, quality and standardization. | 25% | 50% | 50% of states have improved data quality due to the special assistance the MSIX team provides to states to improve their data transmission capabilities. |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Processes and Activities | Timeliness | Average number of days for the SEAs to report migrant student data to MSIX | 0 days | 7 days | This requirement was changed to 10 days based on SEA feedback and program needs. |
| 2008 | Goal 2: Increase the academic achievement of all high school students. | Processes and Activities | Cycle Time | Average number of days for SEAs to report migrant student data to MSIX | 7 days | 4 days | SEAs could produce migrant student in 4-days based on test data in MSIX. The system does not have operational data so this measure will be reported in FY09. |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Processes and Activities | Cycle Time | Average number of hours for the Department to produce nationwide migrant child counts | 160 hours | 2 hours | Based on the test data from MSIX, ED was able to produce student counts within the 2 hour target. However, the system does not have operational data to conduct full nationwide migrant student count. |
| 2006 | Goal 2: Increase the academic achievement of all high school students. | Technology | Data Reliability and Quality | Percentage of states using the same data standards to achieve improved data reliability, quality and standardization. | 0% | 50% | 50% of states are currently using the same data standards to transmit data to MSIX. |
| 2006 | Goal 2: Increase the academic achievement of all high school students. | Processes and Activities | Cycle Time | Average number of hours per SEA to produce Statewide migrant child counts | 30 hours | 22.5 hours | This has not been demonstrated yet since the system is not operational. |
| 2008 | Goal 2: Increase the academic achievement of all high school students. | Customer Results | Delivery Time | Number of user groups involved in user interface design issues and other relevant user discussions | 6 groups | 9 groups | 10 user groups were held over the course of FY08 surpassing the target of 9 groups. |
| 2008 | Goal 2: Increase the academic achievement of all high school students. | Mission and Business Results | Customer Services | Percentage of MSIX Help Desk Issues that are resolved | 0% | 100% | 95% of help desk calls were resolved by the MSIX Help Desk |
| 2006 | Goal 2: Increase the academic achievement of all high school students. | Technology | Data Reliability and Quality | Percentage of States with improved data reliability, quality and standardization. | 50% | 50% | 50% of states have improved data quality due to the special assistance the MSIX team provides to states to improve their data transmission capabilities. |
| 2008 | Goal 2: Increase the academic achievement of all high school students. | Technology | Data Reliability and Quality | Percentage of States with improved data reliability, quality and standardization | 50% | 100% | 100% of states have developed interfaces and submitted test data to MSIX. |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Customer Results | Customer Satisfaction | Percentage of pilot and implementation activities performed within cost and schedule | 0% | 95% | 100% of pilots have been conducted on schedule. One additional user meetings are planned before national rollout. |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Customer Results | Delivery Time | Number of user groups involved in user interface design issues and other relevant user discussions. | 0 groups | 6 groups | 8 users groups were conducted in FY07 surpassing the 6 groups that were planned as the target in FY07. |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Mission and Business Results | Information Management | Percentage of MSIX functional requirements that are traceable per inspection | 0% | 100% | 95% |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Mission and Business Results | Customer Services | Percentage of MSIX design and development activities that are accomplished (measure was moved from FY06 due to delay in contract award) | 0% | 100% | 95% |
| 2008 | Goal 2: Increase the academic achievement of all high school students. | Processes and Activities | Timeliness | Average number of hours per SEA to produce statewide migrant child counts | 30 Hours | 22.5 Hours | The measure is no longer applicable given that EDFAX is collecting information to produce statewide migrant child counts. |
| 2007 | Goal 2: Increase the academic achievement of all high school students. | Technology | Data Reliability and Quality | Number of states using the same data standards to achieve improved data reliability, quality, and standardization | 0 States | 8 States | 25 states have improved data quality due to the special assistance the MSIX team provides to states to improve their data transmission capabilities. |
| 2008 | Goal 2: Increase the academic achievement of all high school students. | Technology | Data Reliability and Quality | Number of states using the same data standards to achieve improved data reliability, quality, and standardization | 25 states | 30 states | 30-states have successfully completed MSIX Interface Testing. |
| 2009 | Goal 2: Increase the academic achievement of all high school students. | Technology | Service Availability | System Uptime is 99.5% after deployment of MSIX except for periods of routine maintenance | 99.5% Availability | 99.5% Availability | Actual results will be reported at the end of FY09 |
| 2009 | Goal 2: Increase the academic achievement of all high school students. | Technology | Data Reliability and Quality | Number of states reporting improved data reliability, quality, and standardization from MSIX | 0 States | 25 States | Actual results will be reported at the end of FY09 |
| 2009 | Goal 2: Increase the academic achievement of all high school students. | Mission and Business Results | Customer Services | Percentage of help desk problems that are resolved in one business day | 0% | 50% | Actual results will be reported at the end of FY09 |
| 2009 | Goal 2: Increase the academic achievement of all high school students. | Processes and Activities | Timeliness | Average number of hours per SEA to produce statewide migrant child counts | 22.5 Hours | 19 Hours | Actual results will be reported at the end of FY09 |
| 2009 | Goal 2: Increase the academic achievement of all high school students. | Customer Results | Delivery Time | Number of user groups involved in user interface design issues after implementation of MSIX | 9 Groups | 12 Groups | Actual results will be reported at the end of FY09 |
| 2010 | Goal 2: Increase the academic achievement of all high school students. | Technology | Service Availability | System Uptime is 99.5% after deployment of MSIX except for periods of routine maintenance | 99.5% Availability | 99.5% Availability | Actual results will be reported at the end of FY10 |
| 2010 | Goal 2: Increase the academic achievement of all high school students. | Technology | Data Reliability and Quality | Number of states reporting improving data reliability, quality, and standardization from MSIX | 25 States | 35 States | Actual results will be reported at the end of FY10 |
| 2010 | Goal 2: Increase the academic achievement of all high school students. | Mission and Business Results | Customer Services | Percentage of help desk problems that are resolved in one business day | 50% | 75% | Actual results will be reported at the end of FY10 |
| 2010 | Goal 2: Increase the academic achievement of all high school students. | Processes and Activities | Timeliness | Average number of hours per SEA to produce statewide migrant child counts | 19 Hours | 16 Hours | Actual results will be reported at the end of FY10 |
| 2010 | Goal 2: Increase the academic achievement of all high school students. | Customer Results | Delivery Time | Number of user groups involved in user interface design issues after implementation of MSIX | 12 Groups | 15 Groups | Actual results will be reported at the end of FY10 |
|
4. Service Component Reference Model (SRM) Table : |
|||||||
| Agency Component Name | Agency Component Description | FEA SRM Service Type | FEA SRM Component | Service Component Reused | Internal or External Reuse? | BY Funding Percentage | |
|---|---|---|---|---|---|---|---|
| Component Name | UPI | ||||||
| Tracking and Workflow | Process tracking has been determined to be a key component of any future MSIX System. However, the software design for the MSIX System will not be complete until after the contract has been awarded, and the contractor has started work on the design. | Tracking and Workflow | Process Tracking | [Not answered] | [Not answered] | No Reuse | 10 |
| Information Retrieval | Information retrieval has been determined to be a key component of any future MSIX System. However, the software design for the MSIX System will not be complete until after the contract has been awarded, and the contractor has started work on the design. | Knowledge Management | Information Retrieval | [Not answered] | [Not answered] | No Reuse | 15 |
| Information Sharing | Information sharing has been determined to be a key component of any future MSIX System. However, the software design for the MSIX System will not be complete until after the contract has been awarded, and the contractor has started work on the design. | Knowledge Management | Information Sharing | [Not answered] | [Not answered] | No Reuse | 10 |
| Standardized/Canned Reporting | Standardized/Canned Reporting has been determined to be a key component of any future MSIX System. However, the software design for the MSIX System will not be complete until after the contract has been awarded, and the contractor has started work on the design. | Reporting | Standardized / Canned | [Not answered] | [Not answered] | No Reuse | 10 |
| Data Management | Data exchange has been determined to be a key component of any future MSIX System. However, the software design for the MSIX System will not be complete until after the contract has been awarded, and the contractor has started work on the design. | Data Management | Data Exchange | [Not answered] | [Not answered] | No Reuse | 30 |
| Development and Integration | Data integration has been determined to be a key component of any future MSIX System. However, the software design for the MSIX System will not be complete until after the contract has been awarded, and the contractor has started work on the design. | Development and Integration | Data Integration | [Not answered] | [Not answered] | No Reuse | 10 |
| Search | Query has been determined to be a key component of any future MSIX System. However, the software design for the MSIX System will not be complete until after the contract has been awarded, and the contractor has started work on the design. | Search | Query | [Not answered] | [Not answered] | No Reuse | 15 |
|
5. Technical Reference Model (TRM) Table: |
||||
| FEA SRM Component | FEA TRM Service Area | FEA TRM Service Category | FEA TRM Service Standard | Service Specification |
|---|---|---|---|---|
| Information Retrieval | Service Access and Delivery | Delivery Channels | Internet | ? https protocol (i.e., https://msix.ed.gov) ? Supported browsers: o Internet Explorer v5.5 or higher o Firefox 1.5 or higher o Netscape v7.0 or higher o Safari v2.0 or higher |
| Process Tracking | Service Access and Delivery | Service Requirements | Legislative / Compliance | EDICS and ROCUS |
| Data Integration | Service Platform and Infrastructure | Delivery Servers | Web Servers | ? Software: Oracle Internet Application server 10, WebCache ? Hardware: 4 - Sun Fire X4100 Server with 2 x AMD Opteron Model 2216 2.4 GHz Processors, 4 GB memory (2 for PROD, 1 for TEST, 1 for DEV) |
| Data Exchange | Service Platform and Infrastructure | Database / Storage | Database | ? Software: Oracle Enterprise 10g ? Hardware: 2 - Sun Fire V490 (4 Processing Cores) and 16 GB memory (1 for PROD, 1 for TEST/DEV) for DB servers; 1 ? Sun StorEdge 3510 Fibre Channel Storage Array with 12 X 73GB 15K Disk Drives, Dual RAID Controller |
| Query | Component Framework | Data Interchange | Data Exchange | ? sFTP protocol ? ProFTP software to support accounts ? Integration with Oracle OID (LDAP) |
| Standardized / Canned | Component Framework | Data Management | Reporting and Analysis | ? Software: Oracle Internet Application server 10, Discoverer; COGNOS 8 BI Suite |
| Information Sharing | Service Interface and Integration | Interoperability | Data Transformation | ? Software: Custom ETL code using PL/SQL & Java ? Hardware: 2 Sun Fire X4100 Server with 2 x AMD Opteron Model 2216 2.4 GHz Processors, 4 GB memory (1 PROD, 1 TEST/DEV) |
|
2. Alternatives Analysis Results: |
|||
| Alternative Analyzed | Description of Alternative | Risk Adjusted Lifecycle Costs estimate | Risk Adjusted Lifecycle Benefits estimate |
|---|---|---|---|
| Alternative 1: The Selected Alternative for MSIX - Consolidated Replica Database | Create the MSIX by requiring states to upload data into a consolidated repository that states would query to retreive informaiton on any migrant student in the U.S. The term ?Consolidated? refers to the fact that the system stores records from multiple component systems in one data repository. The term ?replica? indicates that the system contains non-authoritative versions, or replicas, of migrant student records. | 9.711 | 0.087 |
| Alternative 2 - Transaction Broker | A batch process running on an application server or a component system user executing a query in real-time connects to the Transaction Broker. The Transaction Broker then issues multiple queries, one to each component system, in order to locate the appropriate record. Once the appropriate record is located, it is downloaded to the component system. The Transaction Broker issues queries on a user?s behalf. | 10.385 | 0.07 |
| Alternative 3 - Transaction Broker with Directory Service | This architecture is similar to that of Alternative 2, except that it implements a directory server that improves system performance by shortening query times. The directory server provides information to the transaction broker, which allows the transaction broker to execute more intelligent queries. The transaction broker, index or directory, allows requests to be directed to the appropriate repository, instead of submitting a query to each component reposition until the query located the data. | 10.787 | 0.072 |
| Alternative 4- Peer-to-Peer | This solution differs from the transaction broker and transaction broker alternative with directory service alternatives in that it eliminates the transaction broker. Instead, each requesting component system is responsible for issuing queries directly to other component systems. This is similar to the architecture used by file sharing systems e.g. music sharing applications, except that the systems communicating peer-to-peer are MSIX component systems (sharing migrant student records). | 11.725 | 0.059 |
|
5. Federal Quantitative Benefits ($millions): |
||||
| Budgeted Cost Savings | Cost Avoidance | Justification for Budgeted Cost Savings | Justification for Budgeted Cost Avoidance | |
|---|---|---|---|---|
| PY-1 and Prior | ||||
| PY | ||||
| CY | ||||
| BY | 0 | 170 | Cost avoidance savings are based on Budget Year (BY) 2010. MSIX has calculated the costs of a centralized migrant student information system to be $3.54 Million. If each of the 48-states were required to implement a migrant student education system based on BY-2010 dollars the overall costs would be $170 Million. | Cost avoidance is based on the develop of a federal migrant student information system as oppossed to developing a migrant student system at the state level. In order to achieve the goal related to migrant student record exchange as documented in the "No Child Left Behind Act," the centralized system eliminates for multiple migrant student record systems at the state level. |
| BY+1 | ||||
| BY+2 | ||||
| BY+3 | ||||
| BY+4 and Beyond | ||||
| Total LCC Benefit | 0 | 170 | LCC = Life-cycle cost | |
|
List of Legacy Investment or Systems |
||
| Name of the Legacy Investment or Systems | UPI if available | Date of the System Retirement |
|---|---|---|
| There are no Legacy Investment or Systems. | ||
|
4. Comparison of Initial Baseline and Current Approved Baseline: |
|||||||||
| Description of Milestone | Initial Baseline | Current Baseline | Current Baseline Variance | ||||||
|---|---|---|---|---|---|---|---|---|---|
| Planned Completion Date | Total Cost ($M) Estimated | Completion Date Planned:Actual |
Total Cost ($M) Planned:Actual |
Schedule:Cost (# days:$M) |
Percent Complete | ||||
| DME Milestone 1: System Planning and Design | Jan 31, 2007 | 2.17 | Jan 31, 2007 | Feb 15, 2007 | 2.17 | -0.0136 | 0 | -0.63 | 100 |
| DME Milestone 2: Pilot 1 | Mar 30, 2007 | 1.11 | Mar 30, 2007 | Mar 30, 2007 | 1.11 | 1.06 | 0 | 0.506 | 100 |
| DME Milestone 3: Pilot 2 | Jun 29, 2007 | 1.894 | Jun 29, 2007 | Jun 29, 2007 | 1.894 | 1.771 | 0 | 0.123 | 100 |
| DME Milestone 4: Nationwide Deployment (Incl State Support) | Sep 28, 2007 | 2.68 | Sep 28, 2007 | Nov 30, 2007 | 2.68 | 3.457 | 0 | -0.773 | 100 |
| FY 07 Maintenance | Sep 28, 2007 | 0.126 | Sep 28, 2007 | [Not answered] | 0.126 | [Not answered] | 0 | 0 | 100 |
| FY08 MSIX Help Desk | Sep 30, 2008 | 0.478 | Sep 30, 2008 | [Not answered] | 0.478 | 0 | 0 | 0 | 0 |
| FY08 MSIX Enhancements - System Improvements | Sep 30, 2008 | 0.34 | Sep 30, 2008 | [Not answered] | 0.34 | 0 | 0 | 0 | 0 |
| FY08 MSIX Enhancements - Training Environment | Sep 30, 2008 | 0.185 | Sep 30, 2008 | [Not answered] | 0.185 | 0 | 0 | 0 | 0 |
| MSIX State Support and Data Loading - FY 08 | Sep 30, 2008 | 0.537 | Sep 30, 2008 | [Not answered] | 0.537 | [Not answered] | [Not answered] | [Not answered] | 0 |
| Development Overhead and ODC | Sep 30, 2008 | 0.202 | Sep 30, 2008 | [Not answered] | 0.202 | [Not answered] | [Not answered] | [Not answered] | 0 |
| EVM, Financials and Award Fee | Sep 30, 2008 | 0.133 | Sep 30, 2008 | [Not answered] | 0.133 | [Not answered] | [Not answered] | [Not answered] | 0 |
| FY08 MSIX Maintenance | Sep 30, 2008 | 2.03 | Sep 30, 2008 | [Not answered] | 2.03 | 0 | 0 | 0 | 55 |
| FY 09 MSIX Development | Sep 30, 2009 | 1.15 | Sep 30, 2009 | [Not answered] | 1.15 | [Not answered] | [Not answered] | [Not answered] | 0 |
| MSIX State Support - FY 09 | Sep 30, 2009 | 0.1 | Sep 30, 2009 | [Not answered] | 0.1 | [Not answered] | [Not answered] | [Not answered] | 0 |
| FY 09 MSIX Maintenance | Sep 30, 2009 | 1.79 | Sep 30, 2009 | [Not answered] | 1.79 | [Not answered] | [Not answered] | [Not answered] | 0 |
| FY10 MSIX | Sep 30, 2010 | 2.73 | Sep 30, 2010 | [Not answered] | 2.73 | [Not answered] | [Not answered] | [Not answered] | 0 |
| FY10 MSIX Development | Sep 30, 2010 | 1.15 | Sep 30, 2010 | [Not answered] | 1.15 | [Not answered] | [Not answered] | [Not answered] | 0 |
| MSIX State Support - FY 10 | Sep 30, 2010 | 0.1 | Sep 30, 2010 | [Not answered] | 0.1 | [Not answered] | [Not answered] | [Not answered] | 0 |
| FY 10 MSIX Maintenance | Sep 30, 2010 | 1.599 | Sep 30, 2010 | [Not answered] | 1.599 | [Not answered] | [Not answered] | [Not answered] | 0 |
| Independent Validation and Verification | Sep 29, 2008 | 3.033 | Sep 29, 2008 | [Not answered] | 3.033 | 2.677 | [Not answered] | [Not answered] | 75 |
| Independent Validation and Verification | Sep 29, 2009 | 1 | Sep 29, 2009 | [Not answered] | 1 | [Not answered] | [Not answered] | [Not answered] | 0 |
| Independent Validation and Verification | Sep 29, 2010 | 1 | Sep 29, 2010 | [Not answered] | 1 | [Not answered] | [Not answered] | [Not answered] | 0 |