U.S. Department of Education: Promoting Educational Excellence for all Americans

Exhibit 300 FY2009

PART I: SUMMARY INFORMATION AND JUSTIFICATION

In Part I, complete Sections A, B, C, and D for all capital assets (IT and non-IT). Complete Sections E and F for IT capital assets.

Section A: Overview (All Capital Assets)

The following series of questions are to be completed for all investments.

I. A. 1. Date of Submission:
2007-09-10

I. A. 2. Agency:
018

I. A. 3. Bureau:
24

I. A. 4. Name of this Capital Asset:
(short text - 250 characters)
Data Warehouse

I. A. 5. Unique Project (Investment) Identifier:
For IT investment only, see section 53. For all other, use agency ID system.
018-24-03-00-01-1020-00

I. A. 6. What kind of investment will this be in FY2009?
Please NOTE: Investments moving to O&M in FY2009, with Planning/Acquisition activities prior to FY2009 should not select O&M. These investments should indicate their current status.
Operations and Maintenance

I. A. 7. What was the first budget year this investment was submitted to OMB?
FY2005

I. A. 8. Provide a brief summary and justification for this investment, including a brief description of how this, closes in part or in whole, an identified agency performance gap:
(long text - 2500 characters)
The "EDFacts" data warehouse (EDW) capability enables customers to link information from the supplying systems to perform analysis that would otherwise be too difficult to perform from the supplying system information in isolation. The data warehouse provides a common enabling service that may be leveraged for providing central reporting for existing and future systems. This investment is retired (in FY07) and rolled into "EDNet" and it's successor "EDUCATE" - Departmental Infrastructure Service. Hence, the funding to operate and maintain this investment will be requested in the EDNet/EDUCATE business case. The capabilities and services provided by this investment will be covered through the EDUCATE initiative. No funding was allocated for this investment in FY07. Hence, there are no milestones beyond FY06.

I. A. 9. Did the Agency's Executive/Investment Committee approve this request?
yes

I. A. 9. a. If "yes," what was the date of this approval?
2007-06-14

I. A. 10. Did the Project Manager review this Exhibit?
yes

I. A. 11. Contact information of Project Manager

Name
(short text - 250 characters)

Phone Number
(short text - 250 characters)

E-mail
(short text - 250 characters)

I. A. 11. a. What is the current FAC-P/PM certification level of the project/program manager?

I. A. 12. Has the agency developed and/or promoted cost effective, energy-efficient and environmentally sustainable techniques or practices for this project?
no

I. A. 12. a. Will this investment include electronic assets (including computers)?
yes

I. A. 12. b. Is this investment for new construction or major retrofit of a Federal building or facility? (answer applicable to non-IT assets only)
no

I. A. 12. b. 1. If "yes," is an ESPC or UESC being used to help fund this investment?

I. A. 12. b. 2. If "yes," will this investment meet sustainable design principles?

I. A. 12. b. 3. If "yes," is it designed to be 30% more energy efficient than relevant code?

I. A. 13. Does this investment directly support one of the PMA initiatives?
yes

I. A. 13. a. If "yes," check all that apply:
Financial Performance
Eliminating Improper Payments

I. A. 13. b. Briefly and specifically describe for each selected how this asset directly supports the identified initiative(s)? (e.g. If E-Gov is selected, is it an approved shared service provider or the managing partner?)
(medium text - 500 characters)
EDW supports "Financial Performance" and "Eliminating Improper Payments" by improving Grants Management and reducing the the funds transferred to Treasury. This investment improves Grants Management by making grants data more readily available for analysis and decision making.

I. A. 14. Does this investment support a program assessed using the Program Assessment Rating Tool (PART)? (For more information about the PART, visit www.whitehouse.gov/omb/part.)
no

I. A. 14. a. If "yes," does this investment address a weakness found during the PART review?

I. A. 14. b. If "yes," what is the name of the PARTed Program?
(short text - 250 characters)

I. A. 14. c. If "yes," what PART rating did it receive?

I. A. 15. Is this investment for information technology?
yes

I. A. 16. What is the level of the IT Project? (per CIO Council PM Guidance)
Level 1 - Projects with low-to-moderate complexity and risk. Example: Bureau-level project such as a stand-alone information system that has low- to-moderate complexity and risk.
Level 2 - Projects with high complexity and/or risk which are critical to the mission of the organization. Examples: Projects that are part of a portfolio of projects/systems that impact each other and/or impact mission activities. Department-wide projects that impact cross-organizational missions, such as an agency-wide system integration that includes large scale Enterprise Resource Planning (e.g., the DoD Business Mgmt Modernization Program).
Level 3 - Projects that have high complexity, and/or risk, and have government-wide impact. Examples: Government-wide initiative (E-GOV, President's Management Agenda). High interest projects with Congress, GAO, OMB, or the general public. Cross-cutting initiative (Homeland Security).

Level 2

I. A. 17. What project management qualifications does the Project Manager have? (per CIO Council's PM Guidance):
(1) Project manager has been validated as qualified for this investment;(2) Project manager qualification is under review for this investment;(3) Project manager assigned to investment, but does not meet requirements;(4) Project manager assigned but qualification status review has not yet started;(5) No Project manager has yet been assigned to this investment
(1) Project manager has been validated as qualified for this investment

I. A. 18. Is this investment identified as "high risk" on the Q4-FY 2007 agency high risk report (per OMB Memorandum M-05-23)?
yes

I. A. 19. Is this a financial management system?
no

I. A. 19. a. If "yes," does this investment address a FFMIA compliance area?

I. A. 19. a. 1. If "yes," which compliance area
(short text - 250 characters)

I. A. 19. a. 2. If "no," what does it address?
(medium text - 500 characters)

I. A. 19. b. If "yes," please identify the system name(s) and system acronym(s) as reported in the most recent financial systems inventory update required by Circular A-11 section 52
(long text - 2500 characters)

I. A. 20. What is the percentage breakout for the total FY2009 funding request for the following? (This should total 100%)

I. A. 20. a. Hardware
0

I. A. 20. b. Software
11

I. A. 20. c. Services
89

I. A. 20. d. Other
0

I. A. 21. If this project produces information dissemination products for the public, are these products published to the Internet in conformance with OMB Memorandum 05-04 and included in your agency inventory, schedules and priorities?
n/a

I. A. 22. Contact information of individual responsible for privacy related questions:

I. A. 22. a. Name
(short text - 250 characters)

I. A. 22. b. Phone Number
(short text - 250 characters)

I. A. 22. c. Title
(short text - 250 characters)

I. A. 22. d. E-mail
(short text - 250 characters)

I. A. 23. Are the records produced by this investment appropriately scheduled with the National Archives and Records Administration's approval?
no

I. A. 24. Does this investment directly support one of the GAO High Risk Areas?
Question 24 must be answered by all Investments:
no

Section B: Summary of Spending (All Capital Assets)

I. B. 1. Provide the total estimated life-cycle cost for this investment by completing the following table. All amounts represent budget authority in millions, and are rounded to three decimal places. Federal personnel costs should be included only in the row designated "Government FTE Cost," and should be excluded from the amounts shown for "Planning," "Full Acquisition," and "Operation/Maintenance." The "TOTAL" estimated annual cost of the investment is the sum of costs for "Planning," "Full Acquisition," and "Operation/Maintenance." For Federal buildings and facilities, life-cycle costs should include long term energy, environmental, decommissioning, and/or restoration costs. The costs associated with the entire life-cycle of the investment should be included in this report.
Note: For the cross-agency investments, this table should include all funding (both managing and partner agencies).
Government FTE Costs should not be included as part of the TOTAL represented.

  PY-1 and Spending Prior to 2007 PY 2007 CY 2008 BY 2009 BY+1 2010 BY+2 2011 BY+3 2012 BY+4 2013 and Beyond
Planning 4.361 0.000 0.000 0.000        
Acquisition 0.000 0.000 0.000 0.000        
Subtotal Planning & Acquisition                
Operations & Maintenance 0.550 0.000 0.000 0.000        
Total                
Government FTE Costs 0.242 0.000 0.000 0.000        
Number of FTE represented by cost 1 0 0 0        

I. B. 2. Will this project require the agency to hire additional FTE's?
no

I. B. 2. a. If "yes," How many and in what year?
(medium text - 500 characters)

I. B. 3. If the summary of spending has changed from the FY2008 President's budget request, briefly explain those changes.
(long text - 2500 characters)
This investment is retired and rolled into "EDNet" and it's successor "EDUCATE" - Departmental Infrastructure Service. Hence, the funding to operate and maintain this investment will be requested in the EDNet/EDUCATE business case. No funding is requested for EDW for FY08-09.

Section C: Acquisition/Contract Strategy (All Capital Assets)

I. C. 1. Complete the table for all (including all non-Federal) contracts and/or task orders currently in place or planned for this investment. Total Value should include all option years for each contract. Contracts and/or task orders completed do not need to be included.
SIS - Share in Services contract; ESPC - Energy savings performance contract ; UESC - Utility energy efficiency service contract; EUL - Enhanced use lease contract; N/A - no alternative financing used.
(Character Limitations: Contract or Task Order Number - 250 Characters; Type of Contract/Task Order - 250 Characters; Name of CO - 250 Characters; CO Contact Information - 250 Characters)

  Type of Contract/Task Order Has the contract been awarded? If so what is the date of the award? If not, what is the planned award date? Start date of Contract/Task Order End date of Contract/Task Order Total Value of Contract/Task Order ($M) Is this an Interagency Acquisition? Is it performance based? Competitively awarded? What, if any, alternative financing option is being used? Is EVM in the contract? Does the contract include the required security & privacy clauses? Name of CO CO Contact Information (phone/email) Contracting officer certification level If N/A, has the agency determined the CO assigned has the competencies and skills necessary to support this aquistion?
                                 

I. C. 2. If earned value is not required or will not be a contract requirement for any of the contracts or task orders above, explain why:
(long text - 2500 characters)
Original development and implementation contract was FFP for development and implementation of the initial data warehouse capability. The current task order is steady-state operations and maintenance. Hence EVM is not required.

I. C. 3. Do the contracts ensure Section 508 compliance?
yes

I. C. 3. a. Explain Why:
(medium text - 500 characters)
Development efforts and system changes are required to be 508 compliant and are tracked as performance measures by the Department.

I. C. 4. Is there an acquisition plan which has been approved in accordance with agency requirements?
yes

I. C. 4. a. If "yes," what is the date?
2004-08-14

I. C. 4. b. If "no," will an acquisition plan be developed?

I. C. 4. b. 1. If "no," briefly explain why:
(medium text - 500 characters)

Section D: Performance Information (All Capital Assets)

In order to successfully address this area of the exhibit 300, performance goals must be provided for the agency and be linked to the annual performance plan. The investment must discuss the agency's mission and strategic goals, and performance measures (indicators) must be provided. These goals need to map to the gap in the agency's strategic goals and objectives this investment is designed to fill. They are the internal and external performance benefits this investment is expected to deliver to the agency (e.g., improve efficiency by 60 percent, increase citizen participation by 300 percent a year to achieve an overall citizen participation rate of 75 percent by FY 2xxx, etc.). The goals must be clearly measurable investment outcomes, and if applicable, investment outputs. They do not include the completion date of the module, milestones, or investment, or general goals, such as, significant, better, improved that do not have a quantitative measure.

I. D. 1. Table 1. Performance Information Table
In order to successfully address this area of the exhibit 300, performance goals must be provided for the agency and be linked to the annual performance plan. The investment must discuss the agency's mission and strategic goals, and performance measures (indicators) must be provided. These goals need to map to the gap in the agency's strategic goals and objectives this investment is designed to fill. They are the internal and external performance benefits this investment is expected to deliver to the agency (e.g., improve efficiency by 60 percent, increase citizen participation by 300 percent a year to achieve an overall citizen participation rate of 75 percent by FY 2xxx, etc.). The goals must be clearly measurable investment outcomes, and if applicable, investment outputs. They do not include the completion date of the module, milestones, or investment, or general goals, such as, significant, better, improved that do not have a quantitative measure.

Agencies must use the following table to report performance goals and measures for the major investment and use the Federal Enterprise Architecture (FEA) Performance Reference Model (PRM). Map all Measurement Indicators to the corresponding "Measurement Area" and "Measurement Grouping" identified in the PRM. There should be at least one Measurement Indicator for each of the four different Measurement Areas (for each fiscal year). The PRM is available at www.egov.gov. The table can be extended to include performance measures for years beyond FY 2009.

  Strategic Goal(s) Supported Measurement Area Measurement Grouping Measurement Indicator Baseline Target Actual Results
2006 Cross-goal Strategy on Managment: Obejctive 1: Maintain and strengthen financial integrity and management and internal controls. Mission and Business Results Elementary, Secondary, and Vocational Education New capabilities launched deliver demonstrable improvements in grants fund usage and compliance. Unit of measurement equals number of capabililties in place. 1 4 4 new capabilities in place (Grants Monitoring Reports, Grants Risk Monitoring Reports, EDEN Profile Reports, and ad hoc Grants Reports). This measure was discontinued for future years.
2006 Cross-goal Strategy on Managment: Obejctive 1: Maintain and strengthen financial integrity and management and internal controls. Customer Results Customer Impact or Burden        
2006 Cross-goal Strategy on Managment: Obejctive 1: Maintain and strengthen financial integrity and management and internal controls. Processes and Activities Knowledge Management Number of Program Offices that have benefited from improved knowledge management in the grants and evaluation areas. Unit of Measurement is number of Program Offices. 1 3 3 Investment retired -- no performance metrics tracked and reported beyond FY06.
2006 Cross-goal Strategy on Managment: Obejctive 1: Maintain and strengthen financial integrity and management and internal controls. Technology Interoperability Interoperability measurement. Unit of measurement is the number of new applications. Number of new capabilities that share common data definitions, data repository (data warehouse) and end user data access and analysis tools 1 4 4 new applications share data and service components. The Data Warehouse contains EDEN Submission data, GAPS data, CSPR data, and EDEN profile data. EDW realized cost savings of over $600K as a result of merging EDEN reporting with the EDW.

Section E: Security and Privacy (IT Capital Assets only)

In order to successfully address this area of the business case, each question below must be answered at the system/application level, not at a program or agency level. Systems supporting this investment on the planning and operational systems security tables should match the systems on the privacy table below. Systems on the Operational Security Table must be included on your agency FISMA system inventory and should be easily referenced in the inventory (i.e., should use the same name or identifier).

For existing Mixed-Life Cycle investments where enhancement, development, and/or modernization is planned, include the investment in both the "Systems in Planning" table (Table 3) and the "Operational Systems" table (Table 4). Systems which are already operational, but have enhancement, development, and/or modernization activity, should be included in both Table 3 and Table 4. Table 3 should reflect the planned date for the system changes to be complete and operational, and the planned date for the associated C&A update. Table 4 should reflect the current status of the requirements listed. In this context, information contained within Table 3 should characterize what updates to testing and documentation will occur before implementing the enhancements; and Table 4 should characterize the current state of the materials associated with the existing system.

All systems listed in the two security tables should be identified in the privacy table. The list of systems in the "Name of System" column of the privacy table (Table 8) should match the systems listed in columns titled "Name of System" in the security tables (Tables 3 and 4). For the Privacy table, it is possible that there may not be a one-to-one ratio between the list of systems and the related privacy documents. For example, one PIA could cover multiple systems. If this is the case, a working link to the PIA may be listed in column (d) of the privacy table more than once (for each system covered by the PIA).

I. E. 1. Have the IT security costs for the system(s) been identified and integrated into the overall costs of the investment?

I. E. 1. a. If "yes," provide the "Percentage IT Security" for the budget year:

I. E. 2. Is identifying and assessing security and privacy risks a part of the overall risk management effort for each system supporting or part of this investment?

I. E. 3. Systems in Planning and Undergoing Enhancement(s) – Security Table:
The questions asking whether there is a PIA which covers the system and whether a SORN is required for the system are discrete from the narrative fields. The narrative column provides an opportunity for free text explanation why a working link is not provided. For example, a SORN may be required for the system, but the system is not yet operational. In this circumstance, answer "yes" for column (e) and in the narrative in column (f), explain that because the system is not operational the SORN is not yet required to be published.

  Agency/or Contractor Operated System Planned Operational Date Date of Planned C & A update (for existing mixed life cycle systems) or Planned Completion Date (for new systems)

I. E. 4. Operational Systems - Security:

  Agency/or contractor Operated System? NIST FIPS 199 Risk Impact level (High, Moderate, Low) Has C & A been Completed, using NIST 800-37? (Y/N) Date Completed: C & A What standards were used for the Security Controls tests? (FIPS 200/NIST 800-53, Other, N/A) Date Completed: Security Control Testing Date the contingency plan tested
               

I. E. 5. Have any weaknesses related to any of the systems part of or supporting this investment been identified by the agency or IG?

I. E. 5. a. If "yes," have those weaknesses been incorporated into the agency's plan of action and milestone process?

I. E. 6. Indicate whether an increase in IT security funding is requested to remediate IT security weaknesses?

I. E. 6. a. If "yes," specify the amount, provide a general description of the weakness, and explain how the funding request will remediate the weakness.
(long text - 2500 characters)

I. E. 7. How are contractor security procedures monitored, verified, and validated by the agency for the contractor systems above?
(long text - 2500 characters)

I. E. 8. Planning & Operational Systems - Privacy Table:
Details for Text Options:
Column (d): If yes to (c), provide the link(s) to the publicly posted PIA(s) with which this system is associated. If no to (c), provide an explanation why the PIA has not been publicly posted or why the PIA has not been conducted.

Column (f): If yes to (e), provide the link(s) to where the current and up to date SORN(s) is published in the federal register. If no to (e), provide an explanation why the SORN has not been published or why there isn't a current and up to date SORN.

Note: Links must be provided to specific documents not general privacy websites.

  (b) Is this a new system? (Y/N) (c) Is there a Privacy Impact Assessment (PIA) that covers this system? (Y/N) (d) Internet Link or Explanation (e) Is a System of Records Notice (SORN) required for this system? (Y/N) (f) Internet Link or Explanation
           

Section F: Enterprise Architecture (EA) (IT Capital Assets only)

In order to successfully address this area of the business case and capital asset plan you must ensure the investment is included in the agency's EA and Capital Planning and Invesment Control (CPIC) process, and is mapped to and supports the FEA. You must also ensure the business case demonstrates the relationship between the investment and the business, performance, data, services, application, and technology layers of the agency's EA.

I. F. 1. Is this investment included in your agency's target enterprise architecture?
yes

I. F. 1. a. If "no," please explain why?
(long text - 2500 characters)

I. F. 2. Is this investment included in the agency's EA Transition Strategy?
yes

I. F. 2. a. If "yes," provide the investment name as identified in the Transition Strategy provided in the agency's most recent annual EA Assessment.
(medium text - 500 characters)
Enterprise Data Warehouse (EDW)

I. F. 2. b. If "no," please explain why?
(long text - 2500 characters)

I. F. 3. Is this investment identified in a completed (contains a target architecture) and approved segment architecture?
yes

I. F. 3. a. If "yes," provide the name of the segment architecture.
(medium text - 500 characters)
Knowledge and Data Services Segment

I. F. 4. Service Component Reference Model (SRM) Table :
Identify the service components funded by this major IT investment (e.g., knowledge management, content management, customer relationship management, etc.). Provide this information in the format of the following table. For detailed guidance regarding components, please refer to http://www.egov.gov.

a. Use existing SRM Components or identify as "NEW". A "NEW" component is one not already identified as a service component in the FEA SRM.
b. A reused component is one being funded by another investment, but being used by this investment. Rather than answer yes or no, identify the reused service component funded by the other investment and identify the other investment using the Unique Project Identifier (UPI) code from the OMB Ex 300 or Ex 53 submission.
c. 'Internal' reuse is within an agency. For example, one agency within a department is reusing a service component provided by another agency within the same department. 'External' reuse is one agency within a department reusing a service component provided by another agency in another department. A good example of this is an E-Gov initiative service being reused by multiple organizations across the federal government.
d. Please provide the percentage of the BY requested funding amount used for each service component listed in the table. If external, provide the percentage of the BY requested funding amount transferred to another agency to pay for the service. The percentages in this column can, but are not required to, add up to 100%.

  Agency Component Description FEA SRM Service Type FEA SRM Component (a) Service Component Reused - Component Name (b) Service Component Reused - UPI (b) Internal or External Reuse? (c) BY Funding Percentage (d)
DW Security O&M security services that cover the current production environment, features, and functionality. Security Management Certification and Accreditation     No Reuse 2
eMonitoring Support O&M services for the eMonitoring ColdFusion application Data Management Meta Data Management     No Reuse 4
eMonitoring Support O&M services for the eMonitoring ColdFusion application Development and Integration Software Development     No Reuse 11
Enhanced Reporting on Existing Data Sets DME services to develop new reports or enhance existing reports on preexisting data sets within the Data Warehouse. Reporting Standardized / Canned     No Reuse 5
Incorporate Additional Data Sets DME services to incorporate additional departmental databases into the Data Warehouse, thereby increasing access to and visibility of departmental data. Data Management Data Mart     No Reuse 5
Incorporate Additional Data Sets DME services to incorporate additional departmental databases into the Data Warehouse, thereby increasing access to and visibility of departmental data. Data Management Extraction and Transformation     No Reuse 4
Incorporate Additional Data Sets DME services to incorporate additional departmental databases into the Data Warehouse, thereby increasing access to and visibility of departmental data. Data Management Loading and Archiving     No Reuse 2
Incorporate Additional Data Sets DME services to incorporate additional departmental databases into the Data Warehouse, thereby increasing access to and visibility of departmental data. Knowledge Discovery Modeling     No Reuse 2
Incorporate Additional Data Sets DME services to incorporate additional departmental databases into the Data Warehouse, thereby increasing access to and visibility of departmental data. Reporting Ad Hoc     No Reuse 2
Incorporate Additional Data Sets DME services to incorporate additional departmental databases into the Data Warehouse, thereby increasing access to and visibility of departmental data. Reporting OLAP     No Reuse 5
Program Planning and Support O&M program oversight and planning services associated with the data warehouse and eMonitoring applications Management of Processes Program / Project Management     No Reuse 8
Program Planning and Support O&M program oversight and planning services associated with the data warehouse and eMonitoring applications Management of Processes Quality Management     No Reuse 6
Program Planning and Support O&M program oversight and planning services associated with the data warehouse and eMonitoring applications Management of Processes Requirements Management     No Reuse 4
Program Planning and Support O&M program oversight and planning services associated with the data warehouse and eMonitoring applications Management of Processes Risk Management     No Reuse 2
Software Licenses DME software license management services that support the purchase, upgrade, and tracking of legal usage contracts for data warehouse software and applications Systems Management License Management     No Reuse 10
System Management O&M services for the data warehouse Cognos application Data Management Data Mart     No Reuse 5
System Management O&M services for the data warehouse Cognos application Data Management Data Warehouse     No Reuse 9
System Management O&M services for the data warehouse Cognos application Data Management Extraction and Transformation     No Reuse 4
System Management O&M services for the data warehouse Cognos application Data Management Loading and Archiving     No Reuse 3
System Management O&M services for the data warehouse Cognos application Data Management Meta Data Management     No Reuse 3
System Management O&M services for the data warehouse Cognos application Management of Processes Change Management     No Reuse 2
System Management O&M services for the data warehouse Cognos application Management of Processes Configuration Management     No Reuse 2
EDNet Services Information Technology Infrastructure Services provided by the DoED EDNet Investment. Asset / Materials Management Computers / Automation Management Computers / Automation Management 018-24-02-00-01-1020-00 Internal 0
EDNet Services Information Technology Infrstructure Services provided by teh DoED EDNet Investment. Development and Integration Instrumentation and Testing Instrumentation and Testing 018-24-02-00-01-1020-00 Internal 0
EDNet Services Information Technology Infrastructure Services provided by teh DoED EDNet Investment. Organizational Management Network Management Network Management 018-24-02-00-01-1020-00 Internal 0
EDNet Services Information Technology Infrastructure Services provided by teh DoED EDNet Investment. Collaboration Email Email 018-24-02-00-01-1020-00 Internal 0
EDNet Services Information Technology Infrastructure Services provided by teh DoED EDNet Investment. Security Management Access Control Access Control 018-24-02-00-01-1020-00 Internal 0
EDNet Services Information Technology Infrastructure Services provided by teh DoED EDNet Investment. Security Management Cryptography Cryptography 018-24-02-00-01-1020-00 Internal 0
EDNet Services Information Technology Infrastructure Services provided by teh DoED EDNet Investment. Security Management Identification and Authentication Identification and Authentication 018-24-02-00-01-1020-00 Internal 0
EDNet Services Information Technology Infrastructure Services provided by teh DoED EDNet Investment. Security Management Intrusion Detection Intrusion Detection 018-24-02-00-01-1020-00 Internal 0
EDNet Services Information Technology Infrastructure Services provided by teh DoED EDNet Investment. Systems Management License Management License Management 018-24-02-00-01-1020-00 Internal 0

I. F. 5. Table 1. Technical Reference Model (TRM) Table:
To demonstrate how this major IT investment aligns with the FEA Technical Reference Model (TRM), please list the Service Areas, Categories, Standards, and Service Specifications supporting this IT investment.

a. Service Components identified in the previous question should be entered in this column. Please enter multiple rows for FEA SRM Components supported by multiple TRM Service Specifications
b. In the Service Specification field, agencies should provide information on the specified technical standard or vendor product mapped to the FEA TRM Service Standard, including model or version numbers, as appropriate.

  FEA TRM Service Area FEA TRM Service Category FEA TRM Service Standard Service Specification (i.e., vendor and product name)
Network Management Service Access and Delivery Service Requirements Hosting Provided by EDNet
Network Management Service Access and Delivery Service Transport Service Transport Provided by EDNet
Data Warehouse Service Platform and Infrastructure Support Platforms Platform Dependent IBM AIX
Data Warehouse Service Platform and Infrastructure Delivery Servers Web Servers IBM P520 / Cognos ReportNet Gateway / IBM HTTP Web Server
Data Warehouse Service Platform and Infrastructure Delivery Servers Application Servers IBM P520 / Cognos ReportNet
Configuration Management Service Platform and Infrastructure Software Engineering Software Configuration Management Microsoft SharePoint, SeaPine TestTrack
Instrumentation and Testing Service Platform and Infrastructure Software Engineering Test Management Mercury Loadrunner provided by EDNet; JAWS provided by EDNet
Modeling Service Platform and Infrastructure Software Engineering Modeling ERWin provided by EDNet
Data Warehouse Service Platform and Infrastructure Database / Storage Database Oracle
Data Warehouse Service Platform and Infrastructure Database / Storage Storage IBM DS8100 SAN
Data Warehouse Service Platform and Infrastructure Hardware / Infrastructure Servers / Computers IBM P520, IBM P570, IBM DS8100 SAN
Network Management Service Platform and Infrastructure Hardware / Infrastructure Network Devices / Standards Provided by EDNet
Cryptography Component Framework Security Certificates / Digital Signatures Verisign Secure Socket Layer (SSL)
Data Mart Component Framework Presentation / Interface Static Display Cognos Report Net; Cognos Power Play - HTML
Data Mart Component Framework Presentation / Interface Dynamic Server-Side Display Cognos Report Net; Cognos Power Play - CGI/ISAPI
Data Mart Component Framework Presentation / Interface Content Rendering Cognos Report Net; Cognos Power Play - Cascading Style Sheets (CSS)
Data Mart Component Framework Business Logic Platform Independent Cognos ReportNet, IBM DataStage - C,C++; Cognos ReportNet - JavaScript
Extraction and Transformation Component Framework Data Interchange Data Exchange IBM DataStage - XML
Data Warehouse Component Framework Data Management Database Connectivity Oracle - JDBC,ODBC; DataDirect - ODBC
Extraction and Transformation Service Interface and Integration Integration Middleware IBM DataStage
Data Mart Service Interface and Integration Interoperability Data Types / Validation Cognos ReportNet - XML Schema, DTD; IBM DataStage - XML Schema
Data Mart Service Interface and Integration Interoperability Data Transformation Cognos ReportNet - XSLT
Extraction and Transformation Service Interface and Integration Interface Service Description / Interface API
Ad Hoc Component Framework Data Management Reporting and Analysis Cognos Report Net; Cognos Power Play - OLAP
Standardized / Canned Component Framework Data Management Reporting and Analysis Cognos Report Net; Cognos Power Play - OLAP
OLAP Component Framework Data Management Reporting and Analysis Cognos Report Net; Cognos Power Play - OLAP
Data Mart Service Interface and Integration Interoperability Data Format / Classification Cognos ReportNet - XML
Data Warehouse Service Platform and Infrastructure Software Engineering Integrated Development Environment Cognos ReportNet; IBM DataStage Administrator; Oracle Enterprise Manager
Network Management Service Access and Delivery Service Transport Supporting Network Services Provided by EDNet
Data Warehouse Service Platform and Infrastructure Software Engineering Test Management SeaPine TestTrack

I. F. 6. Will the application leverage existing components and/or applications across the Government (i.e., FirstGov, Pay.Gov, etc)?
no

I. F. 6. a. If "yes," please describe.
(long text - 2500 characters)

PART II: PLANNING, ACQUISITION AND PERFORMANCE INFORMATION

Part II should be completed only for investments identified as "Planning" or "Full Acquisition," or "Mixed Life-Cycle" investments in response to Question 6 in Part I, Section A above

Section A: Alternatives Analysis (All Capital Assets)

In selecting the best capital asset, you should identify and consider at least three viable alternatives, in addition to the current baseline, i.e., the status quo. Use OMB Circular A-94 for all investments and the Clinger Cohen Act of 1996 for IT investments to determine the criteria you should use in your Benefit/Cost Analysis.

II. A. 1. Did you conduct an alternatives analysis for this project?

II. A. 1. a. If "yes," provide the date the analysis was completed?

II. A. 1. b. If "no," what is the anticipated date this analysis will be completed?

II. A. 1. c. If no analysis is planned, please briefly explain why:
(medium text - 500 characters)

II. A. 2. Use the results of your alternatives analysis to complete the following table:
(Character Limitations: Alternative Analyzed - 250 characters; Description of Alternative - 500 Characters)

  Description of Alternative Risk Lifecycle Cost Estimate Risk Lifecycle Benefits Estimate
    NaN NaN

II. A. 3. Which alternative was selected by the Agency's Executive/Investment Committee and why was it chosen?
(long text - 2500 characters)

II. A. 4. What specific qualitative benefits will be realized?
(long text - 2500 characters)

II. A. 5. Will the selected alternative replace a legacy system in-part or in-whole?

II. A. 5. a. If "yes," are the migration costs associated with the migration to the selected alternative included in this investment, the legacy investment, or in a separate migration investment?

II. A. 5. b. Table 1. If "yes," please provide the following information:

  UPI if available Date of the System Retirement
     

Section B: Risk Management (All Capital Assets)

You should have performed a risk assessment during the early planning and initial concept phase of this investment's life-cycle, developed a risk-adjusted life-cycle cost estimate and a plan to eliminate, mitigate or manage risk, and be actively managing risk throughout the investment's life-cycle.

II. B. 1. Does the investment have a Risk Management Plan?

II. B. 1. a. If "yes," what is the date of the plan?

II. B. 1. b. Has the Risk Management Plan been significantly changed since last year's submission to OMB?

II. B. 1. c. If "yes," describe any significant changes:
(long text - 2500 characters)

II. B. 2. If there currently is no plan, will a plan be developed?

II. B. 2. a. If "yes," what is the planned completion date?

II. B. 2. b. If "no," what is the strategy for managing the risks?
(long text - 2500 characters)

II. B. 3. Briefly describe how investment risks are reflected in the life cycle cost estimate and investment schedule:
(long text - 2500 characters)

Section C: Cost and Schedule Performance (All Capital Assets)

EVM is required only on DME portions of investments. For mixed lifecycle investments, O&M milestones should still be included in the table (Comparison of Initial Baseline and Current Approved Baseline). This table should accurately reflect the milestones in the initial baseline, as well as milestones in the current baseline.

II. C. 1. Does the earned value management system meet the criteria in ANSI/EIA Standard - 748?

II. C. 2. Is the CV or SV greater than 10%?

II. C. 2. a. If "yes," was it the CV or SV or both ?

II. C. 2. b. If "yes," explain the causes of the variance:
(long text - 2500 characters)

II. C. 2. c. If "yes," describe the corrective actions:
(long text - 2500 characters)

II. C. 3. Has the investment re-baselined during the past fiscal year?

II. C. 3. a. If "yes," when was it approved by the agency head?

II. C. 4. Comparison of Initial Baseline and Current Approved Baseline
Complete the following table to compare actual performance against the current performance baseline and to the initial performance baseline. In the Current Baseline section, for all milestones listed, you should provide both the baseline and actual completion dates (e.g., "03/23/2003"/ "04/28/2004") and the baseline and actual total costs (in $ Millions). In the event that a milestone is not found in both the initial and current baseline, leave the associated cells blank. Note that the 'Description of Milestone' and 'Percent Complete' fields are required. Indicate '0' for any milestone no longer active. (Character Limitations: Description of Milestone - 500 characters)

  Initial Baseline - Planned Completion Date Initial Baseline - Total Cost Current Baseline - Planned Completion Date Current Baseline - Actual Completion Date Current Baseline - Planned Total Cost Current Baseline - Actual Total Cost Current Baseline Variance - Schedule Current Baseline Variance - Cost Percent Complete
                  0

PART III: FOR "OPERATION AND MAINTENANCE" INVESTMENTS ONLY (STEADY-STATE)

Part III should be completed only for investments identified as "Operation and Maintenance" (Steady State) in response to Question 6 in Part I, Section A above.

Section A: Risk Management (All Capital Assets)

You should have performed a risk assessment during the early planning and initial concept phase of this investment's life-cycle, developed a risk-adjusted life-cycle cost estimate and a plan to eliminate, mitigate or manage risk, and be actively managing risk throughout the investment's life-cycle.

III. A. 1. Does the investment have a Risk Management Plan?
yes

III. A. 1. a. If "yes," what is the date of the plan?
2007-05-07

III. A. 1. b. Has the Risk Management Plan been significantly changed since last year's submission to OMB?
yes

III. A. 1. c. If "yes," describe any significant changes:
(long text - 2500 characters)
This investment has been retired and rolled into EDNET and it's successor EDUCATE.

III. A. 2. If there currently is no plan, will a plan be developed?

III. A. 2. a. If "yes," what is the planned completion date?

III. A. 2. b. If "no," what is the strategy for managing the risks?
(long text - 2500 characters)

Section B: Cost and Schedule Performance (All Capital Assets)

III. B. 1. Was operational analysis conducted?
no

III. B. 1. a. If "yes," provide the date the analysis was completed.

III. B. 1. b. If "yes," what were the results?
(long text - 2500 characters)

III. B. 1. c. If "no," please explain why it was not conducted and if there are any plans to conduct operational analysis in the future:
(long text - 2500 characters)
No. The U.S. Department of Education has recognized the requirement for conducting an operational analysis and is working to sufficiently respond to the requirement request as released in the OMB Memorandum M-05-023.

III. B. 2. Complete the following table to compare actual cost performance against the planned cost performance baseline. Milestones reported may include specific individual scheduled preventative and predictable corrective maintenance activities, or may be the total of planned annual operation and maintenance efforts).

(Character Limitations: Description of Milestone - 250 Characters)

III. B. 2. a. What costs are included in the reported Cost/Schedule Performance information (Government Only/Contractor Only/Both)?
Contractor Only

III. B. 2. b. Comparison of Planned and Actual Cost

  Planned Completion Date Planned Total Cost Actual Completion Date Actual Total Cost Variance - Schedule Variance - Cost
Initial Data Warehouse Capability (e.g, GAPS Data, Risk Model, ETL Tool, initial EDEN, related equipment and licenses)            
Delivery and Configuration of Hardware Platform            
Delivery and Installation of Software Licenses            
Development and Deployment of the Data Warehouse with Data Sourced from the GAPS and EDEN Databases            
Comprehensive Testing of the Data Warehouse            
Delivery of Training Plan, Training Materials, and "Train-the-Trainer" Training            

PART IV: Planning For "Multi-Agency Collaboration" ONLY

Part IV should be completed only for investments identified as an E-Gov initiative, an Line of Business (LOB) Initiative, or a Multi-Agency Collaboration effort., selected the "Multi-Agency Collaboration" choice in response to Question 6 in Part I, Section A above. Investments identified as "Multi-Agency Collaboration" will complete only Parts I and IV of the exhibit 300.

Section A: Multi-Agency Collaboration Oversight (All Capital Assets)

Multi-agency Collaborations, such as E-Gov and LOB initiatives, should develop a joint exhibit 300.

IV. A. 1. Stakeholder Table
As a joint exhibit 300, please identify the agency stakeholders. Provide the partner agency and partner agency approval date for this joint exhibit 300.

  Joint exhibit approval date
   

IV. A. 2. Partner Capital Assets within this Investment
Provide the partnering strategies you are implementing with the participating agencies and organizations. Identify all partner agency capital assets supporting the common solution (section 300.7); Managing Partner capital assets should also be included in this joint exhibit 300. These capital assets should be included in the Summary of Spending table of Part I, Section B. All partner agency migration investments (section 53.4) should also be included in this table. Funding contributions/fee-for-service transfers should not be included in this table. (Partner Agency Asset UPIs should also appear on the Partner Agency's exhibit 53)

  Partner Agency Asset Title Partner Agency Exhibit 53 UPI
     

IV. A. 3. Partner Funding Strategies ($millions)
For jointly funded initiative activities, provide in the "Partner Funding Strategies Table": the name(s) of partner agencies; the UPI of the partner agency investments; and the partner agency contributions for CY and BY. Please indicate partner contribution amounts (in-kind contributions should also be included in this amount) and fee-for-service amounts. (Partner Agency Asset UPIs should also appear on the Partner Agency's exhibit 53. For non-IT fee-for-service amounts the Partner exhibit 53 UPI can be left blank) (IT migration investments should not be included in this table)

  Partner Exhibit 53 UPI CY Contribution CY Fee-for-Service BY Contribution BY Fee-for-Service
    NaN NaN NaN NaN

IV. A. 4. Did you conduct an alternatives analysis for this project?

IV. A. 4. a. If "yes," provide the date the analysis was completed?

IV. A. 4. b. If "no," what is the anticipated date this analysis will be completed?

IV. A. 4. c. If no analysis is planned, please briefly explain why:
(medium text - 500 characters)

IV. A. 5. Use the results of your alternatives analysis to complete the following table:

  Description of Alternative Risk Adjusted Lifecycle Costs estimate Risk Adjusted Lifecycle Benefits estimate
Baseline Status Quo NaN NaN

IV. A. 6. Which alternative was selected by the Initiative Governance process and why was it chosen?
(long text - 2500 characters)

IV. A. 7. What specific qualitative benefits will be realized?
(long text - 2500 characters)

IV. A. 8. Table 1. Federal Quantitative Benefits ($millions):
What specific quantitative benefits will be realized (using current dollars)
Use the results of your alternatives analysis to complete the following table:

  Budgeted Cost Savings Cost Avoidance Justification for Budgeted Cost Savings Justification for Cost Avoidance
  NaN NaN    

IV. A. 9. Will the selected alternative replace a legacy system in-part or in-whole?

IV. A. 9. a. If "yes," are the migration costs associated with the migration to the selected alternative included in this investment, the legacy investment, or in a separate migration investment?

IV. A. 9. b. Table 1. If "yes," please provide the following information:

  UPI if available Date of the System Retirement
     

Section B: Risk Management (All Capital Assets)

You should have performed a risk assessment during the early planning and initial concept phase of this investment's life-cycle, developed a risk-adjusted life-cycle cost estimate and a plan to eliminate, mitigate or manage risk, and be actively managing risk throughout the investment's life-cycle.

IV. B. 1. Does the investment have a Risk Management Plan?

IV. B. 1. a. If "yes," what is the date of the plan?

IV. B. 1. b. Has the Risk Management Plan been significantly changed since last year's submission to OMB?

IV. B. 1. c. If "yes," describe any significant changes:
(long text - 2500 characters)

IV. B. 2. If there currently is no plan, will a plan be developed?

IV. B. 2. a. If "yes," what is the planned completion date?

IV. B. 2. b. If "no," what is the strategy for managing the risks?
(long text - 2500 characters)

Section C: Cost and Schedule Performance (All Capital Assets)

You should also periodically be measuring the performance of operational assets against the baseline established during the planning or full acquisition phase (i.e., operational analysis), and be properly operating and maintaining the asset to maximize its useful life. Operational analysis may identify the need to redesign or modify an asset by identifying previously undetected faults in design, construction, or installation/integration, highlighting whether actual operation and maintenance costs vary significantly from budgeted costs, or documenting that the asset is failing to meet program requirements.

EVM is required only on DME portions of investments. For mixed lifecycle investments, O&M milestones should still be included in the table (Comparison of Initial Baseline and Current Approved Baseline). This table should accurately reflect the milestones in the initial baseline, as well as milestones in the current baseline.

Answer the following questions about the status of this investment. Include information on all appropriate capital assets supporting this investment except for assets in which the performance information is reported in a separate exhibit 300.

IV. C. 1. Are you using EVM to manage this investment?

IV. C. 1. a. If "yes," does the earned value management system meet the criteria in ANSI/EIA Standard - 748?

IV. C. 1. b. If "no," explain plans to implement EVM:
(long text - 2500 characters)

IV. C. 1. c. If "N/A," please provide date operational analysis was conducted and a brief summary of the results?
(long text - 2500 characters)

IV. C. 2. Is the CV% or SV% greater than ± 10%? (CV% = CV/EV x 100; SV% = SV/PV x 100)
NOT applicable for capital assets with ONLY O&M.

IV. C. 2. a. If "yes," was it the CV or SV or both ?

IV. C. 2. b. If "yes," explain the causes of the variance:
(long text - 2500 characters)

IV. C. 2. c. If "yes," describe the corrective actions:
(long text - 2500 characters)

IV. C. 3. Has the investment re-baselined during the past fiscal year?
Applicable to ALL capital assets

IV. C. 3. a. If "yes," when was it approved by the agency head?
Applicable to ALL capital assets

IV. C. 4. Comparison of Initial Baseline and Current Approved Baseline
Complete the following table to compare actual performance against the current performance baseline and to the initial performance baseline. In the Current Baseline section, for all milestones listed, you should provide both the baseline and actual completion dates (e.g., "03/23/2003"/ "04/28/2004") and the baseline and actual total costs (in $ Millions). In the event that a milestone is not found in both the initial and current baseline, leave the associated cells blank. Note that the 'Description of Milestone' and 'Percent Complete' fields are required. Indicate '0' for any milestone no longer active.

  Initial Baseline - Planned Completion Date Initial Baseline - Total Cost Current Baseline - Planned Completion Date Current Baseline - Actual Completion Date Current Baseline - Planned Total Cost Current Baseline - Actual Total Cost Current Baseline Variance - Schedule Current Baseline Variance - Cost Percent Complete Agency responsible for activity
                  NaN  

Return to OMB Exhibit 300 page