ANGLICAN DIOCESAN DEVELOPMENT AND RELEF ORGANISATION (ADDRO)
TERMS OF REFERENCE FOR CONSULTANCY SERVICES: DEVELOPMENT OF DATABASE FOR ADDRO LLIN FOLLOW-UP
The Anglican Diocesan Development and Relief Organization (ADDRO), with funding support from the Episcopal Relief & Development and Against Malaria Foundation, partnered with the National Malaria Control Program/Ghana Health Service and others for a universal Long Lasting Insecticidal Nets (LLINs) distribution campaign in 2016 in the Northern, Greater Accra and Upper West Regions. The distribution of LLINs in homes of beneficiaries was done in a systematic manner through prior identification and registration.
Follow-up of LLIN distribution campaign at the household level is key to ensure correct and consistent use of the nets and to promote a net culture in all the communities. For this reason, monthly household follow up to educate and sensitize household members on LLIN use, care and maintenance as well as promoting healthy behaviours on malaria, diarrhoea and pneumonia prevention are conducted by volunteers. Additionally, household data are collected quarterly by the trained volunteers.
The quarterly household follow-up data collection will be carried out in all the three regions that benefitted from the LLIN distribution campaign. To facilitate this, four thousand two hundred and fifty-three (4,253) volunteers will visit sampled households in their respective communities. It is estimated that about 85,060 household data forms will be filled (manually) and collected every quarter in all the selected sub-districts/communities. Given the size of the data to be generated every quarter and the need to document and keep the data safe for analysis and usage, ADDRO and Episcopal Relief & Development intends to develop a database to address these needs. Besides, this will enable data entry clerks to enter data simultaneously and merged them into a single database for the organization.
2.0 TERMS OF REFERENCE
2.1 Purpose of Consultancy
The purpose of this consultancy is to develop a database for entering quarterly data generated from the communities by volunteers.
2.2 Objectives: The objectives of this consultancy are to:
- Create a standardized and secure database for the quarterly data collection by volunteers.
- Develop standardized procedures to maintain the database.
- Support ADDRO staff in developing the needed competencies for using and maintaining the database.
3.0 Scope of Work
The Consultant shall develop the database to be used for entering data collected from the quarterly follow-up activities in the Greater Accra, Northern and Upper West Regions. The details of the scope of work of the consultant are spelt out in the assigned task s/he is expected to accomplish.
3.1 Assigned Task of the consultant:
The Consultant shall carry out the following tasks:
- Develop and submit a written plan for the database. The plan should include the following:
- The database platform to be used.
- The data standards to be employed.
- The procedures to be used to ensure quality, accuracy, integrity and completeness.
- How data storage and preservation will be handled.
- How data security management (access, erasure, security, privacy) will be ensured.
- How access to data will be ensured in long-term.
- The procedures to be used to upload/transfer/share data.
- Data cleaning and uploading. The consultant will write the program for cleaning and uploading data to other software and will test these with ADDRO.
- The consultant will develop a standard operating procedures manual that should include an explanation on how:
- data is entered
- to use the data cleaning program
- to aggregate data from different time periods
- to aggregate data across different sites and/or regions
- to store and freeze data
- to protect data
- to perform other functions as needed / requested
- Data entry and use. The consultant will train ADDRO staff on the database. In addition, the consultant will support ADDRO to train the data entry clerks.
- Written plan for Database development available and shared
- Developed Database capable of analyzing the data based on indicators or exporting data to other software like Excel or IBM SPSS for analysis
- Standard Operating Procedures manual for data base developed
- Written plan for maintenance of database
- Testing of database and training ADDRO staff to use database done
- Database ownership and management transferred to ADDRO
6.0 Time Frame
The period for this Consultancy shall be one month from the day of signing the contract.
7.0 Experience & Qualification
Applicants should have the following skills and qualifications:
- Advanced degree in the relevant field such as computer science, data/information management, econometrics, advanced statistical analysis, information technology, software engineering, etc.
- Minimum of 5 years’ working experience related to data management/database development and archiving, including use of web-enabled platforms and common statistical analysis tools like IMB SPSS, epi Info, epi data, etc.
- Prior experience with data management is highly commended.
- Excellent communication and writing skills.
8.0 How to Apply
Interested applicants should submit a proposal to include the following;
- Consultant’s background and experience
- Contact details to include physical location, telephone number (s) and email address
- Detailed description of the services/work to be performed
- Proposed methodology
- Proposed team
- Estimated budget
- Delivery schedule
All applications must be submitted by 23rd September 2017 to the address below;
The Executive Director
Anglican Diocesan Development and Relief Organization (ADDRO)
Post Office Box 545
Tel: 03820-22986 / 0203214314 / 0208784567
Please refer to ANNEXES as follows:
Annex A Continue reading