# Population Definition

Hello,

I’m trying to figure out the best way to define population in a way that it can be used to calculate indicators. We have population values, lowest level is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female) and area(rural, urban).

Based on you experience what do you consider to be the best approach for this?

Kind regards,

Paulo Grácio

So far (I’m only doing tests, no yet in production), I have imported population data using a dataset with annual data collection, populating 2012, 13 and 14 with the same data, so I can do indicator calculations on those years.

For your case, I will create 3 data elements, each one associated to a category combination for Age, Gender and Area.

Rodolfo

···

On Tue, Mar 26, 2013 at 3:53 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hello,

I’m trying to figure out the best way to define population in a way that it can be used to calculate indicators. We have population values, lowest level is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female) and area(rural, urban).

Based on you experience what do you consider to be the best approach for this?

Kind regards,

Paulo Grácio

Post to : dhis2-users@lists.launchpad.net

More help : https://help.launchpad.net/ListHelp

Rodolfo Meliá

Principal

rmelia@knowming.com

www.knowming.com

+1 708 872 7636

+44 777 576 4090

Skype: rod.melia

Note: Please note my new email address, which I will be using for PSI related work: rmelia@knowming.com

In Rwanda, we have tried to keep things simple by entering only total population figures for province, district, sector and health facility levels for each year.

We have then created indicators for each of the major target population groups by using census breakdowns and multiplying the total population by the following factors (we’re still waiting for results of 2012 census to update some of these):

···

Children 0 - 11 months

4.10%

Children 1 - 4 years

12.10%

Children 5 - 14 years

27.50%

Children < 15 years

43.70%

Population >= 15 years

56.30%

Children under 5 years

16.20%

Expected Pregnancies

4.10%

Women of reproductive age

23.60%

If your administrative units are very diverse this approach might not work, but it certainly simplifies analysis and people are less inclined to use smaller denominators to make their performance look better.

Randy

From: dhis2-users-bounces+rwilson=msh.org@lists.launchpad.net [mailto:dhis2-users-bounces+rwilson=msh.org@lists.launchpad.net] On Behalf Of Rodolfo Melia

Sent: Tuesday, March 26, 2013 6:11 PM

To: Paulo Grácio

Subject: Re: [Dhis2-users] Population Definition

So far (I’m only doing tests, no yet in production), I have imported population data using a dataset with annual data collection, populating 2012, 13 and 14 with the same data, so I can do indicator calculations on those years.

For your case, I will create 3 data elements, each one associated to a category combination for Age, Gender and Area.

Rodolfo

On Tue, Mar 26, 2013 at 3:53 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hello,

I’m trying to figure out the best way to define population in a way that it can be used to calculate indicators. We have population values, lowest level is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female) and area(rural, urban).

Based on you experience what do you consider to be the best approach for this?

Kind regards,

Paulo Grácio

Post to : dhis2-users@lists.launchpad.net

More help : https://help.launchpad.net/ListHelp

Rodolfo Meliá

Principal

rmelia@knowming.com

www.knowming.com

+1 708 872 7636

+44 777 576 4090

Skype: rod.melia

@RodolfoMelia

Note: Please note my new email address, which I will be using for PSI related work: rmelia@knowming.com

@Randy, your solutions seems to be easiest once it reduces the amount of data to upload, but at the moment our requirement is to have population data structured as defined by National Institute of Statistics - NIS.

@Rodolfo, I guess we are at the same step. We are trying to setup an initial version of dhis2 for some Workshops, and your approach is in the way of what we need. Now I just need to create a procedure to automatically load all the data from the source, NIS excel files.

Kind regards,

Paulo Grácio

···

From: Wilson,Randy [mailto:rwilson@msh.org]
Sent: terça-feira, 26 de Março de 2013 18:24
To: Rodolfo Melia; Paulo Grácio
Subject: RE: [Dhis2-users] Population Definition

In Rwanda, we have tried to keep things simple by entering only total population figures for province, district, sector and health facility levels for each year.

We have then created indicators for each of the major target population groups by using census breakdowns and multiplying the total population by the following factors (we’re still waiting for results of 2012 census to update some of these):

Children 0 - 11 months

4.10%

Children 1 - 4 years

12.10%

Children 5 - 14 years

27.50%

Children < 15 years

43.70%

Population >= 15 years

56.30%

Children under 5 years

16.20%

Expected Pregnancies

4.10%

Women of reproductive age

23.60%

If your administrative units are very diverse this approach might not work, but it certainly simplifies analysis and people are less inclined to use smaller denominators to make their performance look better.

Randy

From: dhis2-users-bounces+rwilson=msh.org@lists.launchpad.net [mailto:dhis2-users-bounces+rwilson=msh.org@lists.launchpad.net] On Behalf Of Rodolfo Melia
Sent: Tuesday, March 26, 2013 6:11 PM
To: Paulo Grácio
Subject: Re: [Dhis2-users] Population Definition

So far (I’m only doing tests, no yet in production), I have imported population data using a dataset with annual data collection, populating 2012, 13 and 14 with the same data, so I can do indicator calculations on those years.

For your case, I will create 3 data elements, each one associated to a category combination for Age, Gender and Area.

Rodolfo

On Tue, Mar 26, 2013 at 3:53 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

Hello,

I’m trying to figure out the best way to define population in a way that it can be used to calculate indicators. We have population values, lowest level is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female) and area(rural, urban).

Based on you experience what do you consider to be the best approach for this?

Kind regards,

Paulo Grácio

Post to : dhis2-users@lists.launchpad.net
More help : https://help.launchpad.net/ListHelp

Rodolfo Meliá

Principal

rmelia@knowming.com

www.knowming.com

+1 708 872 7636

+44 777 576 4090

Skype: rod.melia

Note: Please note my new email address, which I will be using for PSI related work: rmelia@knowming.com

Dear all,

Each country has specific population categories for different age groups that they are always looking for based on their strategic direction or age cohorts that of interest.

PEPELA WANJALA

MINISTRY OF HEALTH HEADQUARTERS

** HEALTH INFORMATION SYSTEM**

AFYA HOUSE, HIS LG 37

P.O BOX 30016, NAIROBI, KENYA

TEL: +254 (020) 2717077 EXT 45097

CELL: +254 (0) 722375633 or 0202033363

EMAIL: wanjala2p@yahoo.com

** hmis@health.go.ke**

* *"HealthInformation Management - Making a World of Difference”

···

From: Paulo Grácio pgracio@criticalsoftware.com
Sent: Tuesday, March 26, 2013 6:53 PM
Subject: [Dhis2-users] Population Definition

Hello,

I’m trying to figure out the best way to define population in a way that it can be used to calculate indicators. We have population values, lowest level is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female) and area(rural, urban).

Based on you experience what do you consider to be the best approach for this?

Kind regards,

Paulo Grácio