1 / 23

Essential Elements of An Aggregate Database

Essential Elements of An Aggregate Database. Frank Oronsaye and Chiedozie Anunobi ICAP Nigeria M&E . Importance of aggregate databases. Aggregate databases are an important M&E tool for data collection, reporting, analysis and use

deon
Download Presentation

Essential Elements of An Aggregate Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Essential Elements of An Aggregate Database Frank Oronsaye and Chiedozie Anunobi ICAP Nigeria M&E

  2. Importance of aggregate databases • Aggregate databases are an important M&E tool for data collection, reporting, analysis and use • A flexible aggregate database can be tailored to accommodate local ICAP program needs while meeting reporting needs of external groups (ICAP-NY, country CDC offices, MoH) • Data entry into duplicative systems can be eliminated • Aggregate databases can provide ICAP country program technical teams immediate access to relevant data

  3. Aggregate Databases Should Support Data Collection and Use Cycle

  4. 5 Elements of Aggregate Database • User-defined Sites and Indicators • Data Collection & Validation • Import/Export • Reporting • Feedback and Dissemination

  5. User Defined Sites and Indicators • Ability to add new sites and assign attributes to each site • Geographic location • Support tart date, stop date • Supported Program Areas and Targets • Ability to design and modify program specific indicators

  6. Site Setup

  7. Program Area Setup

  8. Sub Program Area Setup

  9. Data Collection & Validation • Decentralized data entry • Entry should occur at central, regional and ideally site level • Systematic and streamlined data entry process • Information can be entered in a timely fashion by data entry staff • Integrated data quality checks and validation rules • Identify and resolve data issues at the point of data entry

  10. Data Entry • Essential features • Site Profile • Reporting Period • Program Area • Clearly Defined indicators • Note: The indicator frame should mimic the collection tools

  11. Import/Export • Internal import/export • Offline data entry at regional level exported and sent to central office • External import/export • Submission of data to external system such as ICAP-URS or government aggregate databases

  12. Uploaded to NG central DB

  13. Reporting • Automated generation of quarterly reporting tables • CDC Track 1.0 table • Tables for quarterly CDC submission • User-specified reports • Reports by reporting period, region and program area

  14. User-specified Reports • Essential Features • Site Profile • Reporting period • Relevant program area or indicator • Reporting Format

  15. Example of report

  16. Data Use & Dissemination • User-specified reports and graphs for program evaluation • Reports by reporting period, region and program area • Graphs illustrating regional differences and trends • Automated feedback reports tailored for key audiences • Site-level staff • National and regional government staff

  17. Graphs

  18. Sample Trend Graph 1

  19. Sample Trend Graph 2

  20. Important Considerations • Application use and flexibility of design • Flexible Database Programming • Parameter Driven • Computer Literacy • Scalability • Database developer support • Design, tailor and/or maintain database • IT Support for system • Servers, flash drives, internet access, routine system backup

  21. Summary • Aggregate databases are an important M&E tool for data collection, reporting, analysis and use • A robust, flexible system will include the five essential elements • With adequate resources and support, a local aggregate database can streamline data collection/reporting and enhance data use and dissemination

More Related