===B. WORK TO BE PERFORMED BY GRANTEE=== *1. Project Management and Administration **1.1 Provide all technical and administrative services as needed for project completion; monitor, supervise and review all work performed; and coordinate budgeting, scheduling, to assure that the agreement is completed within budget, on schedule, and in accordance with approved procedures, applicable laws and regulations. **1.2 Ensure that contract requirements are met through completion of quarterly progress reports submitted to the Contract Manager by the 10th of the month following the end of each calendar quarter (March, June, September and December) and through regular communication with the Contract Manager. The quarterly progress reports shall describe activities undertaken and accomplishments of each work item during the quarter, milestones achieved, and any problems encountered in the performance of the work under this contract. The description of activities and accomplishments of each work item during the quarter shall be in sufficient detail to provide a basis for payment of invoices. **1.3 Prepare a draft report documenting and summarizing Work items 2 through 7. The Project Director shall submit one reproducible paper copy of the draft report to the Contract Manager for review and approval. **1.4 Prepare a final report that addresses, to the extent feasible, comments made on the draft report by the Contract Manager. The Project Director shall submit one reproducible paper copy and an electronic copy (in MS-Word, pdf, or equivalent format) of the final report to the Contract Manager for review and acceptance. *2. Needs Assessment **2.1. Conduct needs assessment of grant project data types. Grantees will be informally surveyed for the type of data to be delivered to the California Environmental Data Exchange Network (CEDEN), so that the full range of information types will be addressed by data transfer tools. **2.2. Conduct needs assessment of grant project data quality assurance documentation. Grant projects will be informally surveyed for the level of detail required to be delivered to CEDEN to support quality assurance decision making for various data uses (such as 303(d) listing, 305(b) assessment and other assessment efforts). This work item will include consideration of the Surface Water Ambient Monitoring Program (SWAMP) tiering approach to data usability. *3. Develop Design Description Document **3.1. Develop system data model that will document the internal structure and functions of the data transfer system, through both a narrative description and flow charts. **3.2. Develop data dictionary, including all tables contained in the data transfer system and data tables, lookup tables, crosswalk tables, and schema tables (describing the linkage between databases, tables, and columns of information). *4. Basic System Implementation **4.1. Set up hardware staging system for testing and running draft versions of the system that will allow the Financial Assistance Application Submittal Tool (FAAST) and CEDEN databases to exchange selected data. **4.2. Expand and add improvements to the existing California Data Upload and Checking System (CalDUCS), developed for the Central Coast Regional Water Quality Control Board (Region 3) and Monterey Bay National Marine Sanctuary, for statewide use by the Grants program. **4.3. Develop administrative functions that will allow system administrators and managers to configure and manage the statewide upload system. **4.4. Develop data entry forms and implement the importation of data using the various data forms identified by the needs assessment, using MS Excel spreadsheets, web project registration data entry forms, or other web-based data transfer techniques (such as inter-database communications). **4.5. Develop and expand on existing basic validation, error, and exception handling software to check delivered files at a level of data integrity identified in the needs assessment. *5. Deploy Staging Website for Review **5.1. Deploy web-based transfer tool test system for use by a select number of Water Board staff and external users for system validation. **5.2. Adjust web-based transfer tool test system in response to beta-user requests and concerns. *6. Deploy Website for Data Delivery **6.1. Finalize hardware specification and setup information that will be delivered to CEDEN via CEDEN compatible tables, including final documentation for installing and maintaining the hardware selected for the web-based data transfer tools. **6.2. Finalize software and associated documentation required to run the web-based data delivery system for statewide use and deliver it to CEDEN. **6.3. Install production version of software on an appropriate server as designated by the Project Manager to run the web-based data delivery system for grants data throughout the State. *7. Develop Tools for Data Reporting **7.1. Develop upload system tabular queries, mapping and charting, which will allow the system users immediate access to uploaded data using data summaries, monitoring site mapping, and basic charting capabilities. This will improve user capacity to check data before transferring it to the CEDEN system. **7.2. Under direction of State Water Board staff and Contract Manager, develop and provide data summaries, mapping and charting capabilities for data queried from the CEDEN system that is accessible through scalable watershed navigation, water body navigation, and pollutant navigation. *8. Provide User Support and Issue Resolution **8.1 Develop Wiki issue tracking to track and resolve issues raised by system users and provide system modifications and enhancements required for the initial year of deployment.