Consulting Firm for Development of Common Operational Datasets for Population Dynamics and Reproductive Health (RE-TENDER)

The consultancy firm should be able to design consolidated and indicator-specific matrices that will contain various fully-disaggregated population dynamics and reproductive health indicators and broken down up to the barangay level. The matrices will be MS Excel-based and should make use of the software’s data management and automation features and functions such as formulas, macros, cell referencing across worksheets, lookup, charts and others.

 The consultancy firm should be able to use national/sub-national data and rates from the latest official surveys, censuses and government data publications, populate the matrices with relevant data. Ensure that the matrices are inter-linked and that the consolidated matrix will essentially have a summary.

The consultancy firm should be able to reflect in their output the Population dynamics and reproductive health indicators, broken down by age and sex and, if possible, geographically (national, regional, provincial, municipal/city, barangay), will include, among others (the list may be expanded):

• Population count
• Population growth rate
• Employment/unemployment rate
• Prevalent occupation
• GDP growth
• Household size
• Education level
• Income level
• Health insurance coverage rate
• Health insurance availment rate
• Total fertility rate
• Adolescent childbirth rate
• Marital status
• Facility-based delivery
• Skilled-birth attendance
• HIV/AIDS knowledge
• Ideal/wanted fertility rates
• Contraceptive use
• Unmet need for family planning – total/modern
• Infant mortality rate
• Ante-natal visit rate
• Delivery by Caesarean operation
• Post-natal health check
• Maternal mortality rate
• Married women’s employment
• Experience of physical and sexual violence
• Relevant RH policies/ordinances

The consultancy firm should be able to prepare a manual of operations that discusses how to periodically maintain and upgrade the data document system. The draft data document system and manual of operations need to be presented with the UNFPA Philippines Country Office System, which will be incorporated in the development of the final version of the outputs.