accessing and using data donor needs

Download Accessing and using data Donor needs

If you can't read please download the document

Upload: zareh

Post on 06-Jan-2016

18 views

Category:

Documents


1 download

DESCRIPTION

Accessing and using data Donor needs. Siobhan Carey Chief Statistician DFID . 1 Palace Street, London SW1E 5HE Abercrombie House, Eaglesham Road, East Kilbride, Glasgow G75 8EA. Context. DFID budget is increasing 12% pa Consensus around the Managing for Development Results Agenda - PowerPoint PPT Presentation

TRANSCRIPT

  • Accessing and using data

    Donor needsSiobhan CareyChief StatisticianDFID 1 Palace Street, London SW1E 5HEAbercrombie House, Eaglesham Road, East Kilbride, Glasgow G75 8EA

    Page *

    Page *

    Page *

    Page *

    ContextDFID budget is increasing 12% pa Consensus around the Managing for Development Results Agenda Creates expectations So how can we help policy colleagues be more evidenced based?The stupid things that test us - Updates - not adequately referencedLack of metadataShort lead in times country dialogue with centre - whos data to use

    What would make us more effective ?

    Page *

    ContextProgrammes in almost 70 countriesOver 500 advisory staff 10 disciplinesPosting 2 to 4 yearsManaging knowledge is difficult in generalManaging knowledge about data

    Got to be a better way

    better use of better statistics

    Page *

    Page *

    Looking for at expense of looking atAccessAll the data in a single space(WDI, UN, Country, DAC)Metadata means to hold/captureIdeally up to the minute - available on day producedOther stuff - capturing the knowledge - referencing

    CommunicationTools to make the messages easy and quick to absorb Automating routine reports properly cited

    Page *

    Portal for Development IndicatorsPrototypeHow feasible is it to have different data in the same space?Is it useful?Approached from two frontscontent - tested using indicators from different sources - not comprehensivefunction - capturing the knowledge, additional graph and map featuresUsed DevInfo for convenience

    Page *

    If this was easy it would have been done already

    Issues around standards, definitions, classifications Content managementgetting stuff inhandling revisionsownership / stewardshipIdeally not just indicators - distributions, microdata, project data, expenditure data, outputs

    Page *

    Questions

    Are these problems recognisable? shared?Have you found clever ways around it?Would something like this be useful?What else would be on the wish list?Should we go ahead and build?

    Page *

    Expected benefitsBetter and more timely data analysis for policy and country officesMore comprehensive analyses, using international data in conjunction with e.g. DFID expenditure;Time saving in data extraction and presentation;Easy and appropriate use by less-informed users including an enhanced awareness of the quality of the data for the end-user.Help resolve discrepancies between data sources;Coherence of the data used across DFIDInformation about the data known to selected individuals is not lost. Autotmation of routine processes and reports

    Page *

    An example of why it might be useful - education

    Page *

    Chart22

    22.6

    42.9

    48.6

    53.7

    54.2

    57.8

    62.3

    71.5

    90.3

    Tanzania

    Rwanda

    Zambia

    Zimbabwe

    Kenya

    Sierra Leone

    Sudan

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    Sheet1

    CountryReduce Hunger by HalfCountryNet EnrolmentCountryEqual Girls' Enrolment in Primary SchoolCountryReduce Mortality of Under 5's by Two ThirdsCountryHalve the Proportion without Improved Drinking WaterCountryHalve the Proportion without Improved Sanitation

    DRC5.0DRC5.0DRCDRC-DRC4DRC3.0

    Ethiopia2.0Ethiopia2.0Ethiopia2.0EthiopiaEthiopia4Ethiopia4

    Ghana5.0Ghana3.0Ghana1.0GhanaGhana2.0Ghana4

    Kenya3.0Kenya2.0Kenya2.0KenyaKenya2.0Kenya4

    LesothoLesotho3.0Lesotho1.0LesothoLesotho5.0Lesotho4

    Malawi2.0MalawiMalawi1.0Malawi2.0Malawi1.0Malawi3.0

    Mozambique5.0Mozambique2.0Mozambique2.0Mozambique3.0Mozambique4Mozambique3.0

    Nigeria3.0Nigeria3.0Nigeria2.0NigeriaNigeria4Nigeria4

    Rwanda2.0Rwanda2.0Rwanda1.0Rwanda3.0Rwanda2.0Rwanda4

    Sierra LeoneSierra Leone2.0Sierra Leone2.0Sierra LeoneSierra Leone5.0Sierra Leone5.0

    South Africa5.0South AfricaSouth AfricaSouth AfricaSouth Africa2.0South Africa4

    SudanSudan5.0Sudan5.0Sudan5.0Sudan5.0Sudan5.0

    Tanzania5.0Tanzania2.0Tanzania2.0Tanzania3.0Tanzania2.0Tanzania4

    Uganda3.0UgandaUganda1.0UgandaUganda2.0Uganda4

    Zambia3.0Zambia2.0Zambia2.0Zambia-Zambia3.0Zambia3.0

    Zimbabwe5.0ZimbabweZimbabwe1.0ZimbabweZimbabwe4Zimbabwe4

    Sub-Saharan AfricaDemocratic Republic of the Congo5........

    Sub-Saharan AfricaEthiopia2481992372004

    Sub-Saharan AfricaGhana5....222003

    Sub-Saharan AfricaKenya3221993202003

    Sub-Saharan AfricaLesotho161992202004

    Sub-Saharan AfricaMalawi2271992222004

    Sub-Saharan AfricaMozambique5....242003

    Sub-Saharan AfricaNigeria3361990292003

    Sub-Saharan AfricaRwanda2291992232005

    Sub-Saharan AfricaSierra Leone291990312005

    Sub-Saharan AfricaSouth Africa5........

    Sub-Saharan AfricaSudan5....342006

    Sub-Saharan AfricaUganda3231989202006

    Sub-Saharan AfricaUnited Republic of Tanzania5........

    Sub-Saharan AfricaZambia3251992202004

    Sub-Saharan AfricaZimbabwe5....172003

    Eastern AsiaChina119199082002

    South-Eastern AsiaCambodia401994452000

    South-Eastern AsiaIndonesia5....282003

    South-Eastern AsiaViet Nam5........

    Southern AsiaAfghanistan5....392004

    Southern AsiaBangladesh661990482004

    Southern AsiaIndia531993462005

    Southern AsiaNepal5....482001

    Southern AsiaPakistan401991382002

    Hunger

    UNSD 2007 database

    Africa PSA country1990 (est)~2005Target

    Ethiopia493724.72.0

    Nigeria362917.93.0

    Rwanda302315.12.0

    Sierra Leone293114.4

    Malawi282214.02.0

    Zambia262013.03.0

    Kenya232011.53.0

    Uganda232011.43.0

    Lesotho15207.6

    Sudan345.0

    Mozambique245.0

    Ghana225.0

    Zimbabwe175.0

    DRC5.0

    South Africa5.0

    Tanzania5.0

    Selected data values 2 years either side

    Notes

    Ethiopia: challenging target yet on track

    Several countries on track

    Several other countries off track for 2015 but still progressing

    SL, SUD and LES regressing

    DRC5........DRC5.0

    Ethiopia2481992372004Ethiopia493724.72.0

    Ghana5....222003Ghana225.0

    Kenya3221993202003Kenya232011.53.0

    Lesotho161992202004Lesotho15207.6

    Malawi2271992222004Malawi282214.02.0

    Mozambique5....242003Mozambique245.0

    Nigeria3361990292003Nigeria362917.93.0

    Rwanda2291992232005Rwanda302315.12.0

    Sierra Leone291990312005Sierra Leone293114.4

    South Africa5........South Africa5.0

    Sudan5....342006Sudan313415.5

    Tanzania5........Tanzania225.0

    Uganda3231989202006Uganda232011.43.0

    Zambia3251992202004Zambia262013.03.0

    Zimbabwe5....172003Zimbabwe175.0

    1990 starting point

    target for 2015

    Hunger

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    NER

    Ethiopia faces a challenging target but is on track

    4 countries have one data point but not enough data to assess progress; 3 more do not have current data

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    Target

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    ~2005

    Target

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    Sheet2

    UNSD 2007 database

    Africa PSA country~1991~2005TargetNER

    Ethiopia23701002.0

    Mozambique43771002.0

    Malawi4995100

    Ghana54701003.0

    DRC541005.0

    Nigeria58701003.0

    Uganda6284100

    Lesotho72871003.0

    South Africa9092100

    Tanzania911002.0

    Rwanda951002.0

    Zambia901002.0

    Zimbabwe83100

    Kenya791002.0

    Sierra Leone691002.0

    Sudan291005.0

    notes

    RW etc: assessement exists even though no early 90's data because based on short term trend

    RW,TZ, ZA: recent progress faster than South Africa and Malawi

    MLW: enormous progress since 1990, but slowed down and possible reversal since 2000, hence the 'sligthly off track' result

    1Ethiopia2.0Ethiopia

    2Mozambique2.0Mozambique

    3MalawiMalawi

    4Ghana3.0Ghana

    5DRC5.0DRC

    6Nigeria3.0Nigeria

    7UgandaUganda

    8Lesotho3.0Lesotho

    Note: traffic light results take intermediate data into account9South AfricaSouth Africa

    (hence the odd rwanda result)10Tanzania2.0Tanzania

    11Rwanda2.0Rwanda

    12Zambia2.0Zambia

    13ZimbabweZimbabwe

    14Kenya2.0Kenya

    15Sierra Leone2.0Sierra Leone

    16Sudan5.0Sudan

    1990 starting point

    target for 2015

    Sheet2

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    Gender

    ETH & MOZ had some of the lowest rates in 1990 yet are on track to reach 100% by 2015

    Although their 1990 position is unknown, recent progress in TAN, RWA, ZAM yields an 'on track' assessment

    Malawi data show huge progress, but with a reversal since 2000. Hence the 'off track' results: on current trends, the target would be missed

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    ETH & MOZ had some of the lowest rates in 1990 yet are on track to reach 100% by 2015

    Although their 1990 position is unknown, recent progress in TAN, RWA, ZAM yields an 'on track' assessment

    Malawi data show huge progress, but with a reversal since 2000. Hence the 'off track' results: on current trends, the target would be missed

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    U5M

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    Water

    UNSD 2007 database

    Africa PSA country1991~2005TargetGender

    Ethiopia0.70.92.0

    Sierra Leone0.70.82.0

    DRC0.8

    Mozambique0.80.92.0

    Nigeria0.80.92.0

    Malawi0.81.01.0

    Ghana0.91.01.0

    Uganda0.91.01.0

    Kenya1.01.02.0

    Rwanda1.01.01.0

    Zimbabwe1.01.0

    Tanzania1.01.02.0

    South Africa1.01.0

    Lesotho1.21.01.0

    Sudan0.95.0

    Zambia1.02.0

    notes

    several countries so close to the target that it is 'met'

    SA data showing a slight regress hence off track, but still close to parity

    Gender Primary

    1EthiopiaEthiopia

    2Sierra LeoneSierra Leone

    3DRCDRC

    4MozambiqueMozambique

    5NigeriaNigeria2.0

    Note: traffic light results take intermediate data into account6MalawiMalawi1.0

    (hence the odd rwanda result)7GhanaGhana1.0

    8UgandaUganda1.0

    9KenyaKenya

    10RwandaRwanda1.0

    11ZimbabweZimbabwe1.0

    12TanzaniaTanzania

    13South AfricaSouth Africa2.0

    14LesothoLesotho1.0

    15SudanSudan

    16ZambiaZambia

    1Ethiopia2.0Ethiopia

    2Sierra Leone2.0Sierra Leone

    3DRCDRC

    4Mozambique2.0Mozambique

    5Nigeria2.0Nigeria

    6Malawi1.0Malawi

    7Ghana1.0Ghana

    8Uganda1.0Uganda

    9Kenya2.0Kenya

    10Rwanda1.0Rwanda

    11Zimbabwe1.0Zimbabwe

    12Tanzania2.0Tanzania

    13South AfricaSouth Africa

    14Lesotho1.0Lesotho

    15Sudan5.0Sudan

    16Zambia2.0Zambia

    Water

    10.880.66

    10.810.7

    1DRC0.75

    10.850.75

    10.860.81

    11.020.84

    10.980.85

    110.85

    10.960.96

    11.020.97

    1Zimbabwe0.97

    10.970.98

    10.960.99

    111.22

    10.93Sudan

    10.95Zambia

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    UNSD 2007 database

    Africa PSA country1991~2005TargetGender

    Ethiopia0.70.912.0

    Sierra Leone0.70.812.0

    DRC0.81

    Mozambique0.80.912.0

    Nigeria0.80.912.0

    Malawi0.81.011.0

    Ghana0.91.011.0

    Uganda0.91.011.0

    Kenya1.01.012.0

    Rwanda1.01.011.0

    Zimbabwe1.011.0

    Tanzania1.01.012.0

    South Africa1.01.01

    Lesotho1.21.011.0

    Sudan0.915.0

    Zambia1.012.0

    notes

    several countries so close to the target that it is 'met'

    SA data showing a slight regress hence off track, but still close to parity

    Gender Primary

    1EthiopiaEthiopia

    2Sierra LeoneSierra Leone

    3DRCDRC

    4MozambiqueMozambique

    5NigeriaNigeria2.0

    Note: traffic light results take intermediate data into account6MalawiMalawi1.0

    (hence the odd rwanda result)7GhanaGhana1.0

    8UgandaUganda1.0

    9KenyaKenya

    10RwandaRwanda1.0

    11ZimbabweZimbabwe1.0

    12TanzaniaTanzania

    13South AfricaSouth Africa2.0

    14LesothoLesotho1.0

    15SudanSudan

    16ZambiaZambia

    1Ethiopia2.0Ethiopia

    2Sierra Leone2.0Sierra Leone

    3DRCDRC

    4Mozambique2.0Mozambique

    5Nigeria2.0Nigeria

    6Malawi1.0Malawi

    7Ghana1.0Ghana

    8Uganda1.0Uganda

    9Kenya2.0Kenya

    10Rwanda1.0Rwanda

    11Zimbabwe1.0Zimbabwe

    12Tanzania2.0Tanzania

    13South AfricaSouth Africa

    14Lesotho1.0Lesotho

    15Sudan5.0Sudan

    16Zambia2.0Zambia

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    Ethiopia

    Ethiopia

    Ethiopia

    Sierra Leone

    Sierra Leone

    Sierra Leone

    DRC

    DRC

    DRC

    Mozambique

    Mozambique

    Mozambique

    Nigeria

    Nigeria

    Nigeria

    Malawi

    Malawi

    Malawi

    Ghana

    Ghana

    Ghana

    Uganda

    Uganda

    Uganda

    Kenya

    Kenya

    Kenya

    Rwanda

    Rwanda

    Rwanda

    Zimbabwe

    Zimbabwe

    Zimbabwe

    Tanzania

    Tanzania

    Tanzania

    South Africa

    South Africa

    South Africa

    Lesotho

    Lesotho

    Lesotho

    Sudan

    Sudan

    Sudan

    Zambia

    Zambia

    Zambia

    1

    0.88

    0.66

    1

    0.81

    0.7

    1

    0.75

    1

    0.85

    0.75

    1

    0.86

    0.81

    1

    1.02

    0.84

    1

    0.98

    0.85

    1

    1

    0.85

    1

    0.96

    0.96

    1

    1.02

    0.97

    1

    0.97

    1

    0.97

    0.98

    1

    0.96

    0.99

    1

    1

    1.22

    1

    0.93

    1

    0.95

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    UNSD 2007 database

    African PSA country1990 starting pointcurrent position (~2005)target for 20152007asst

    Sierra Leone302282100.7

    Mozambique23514578.33.0

    Nigeria23019476.7

    Malawi22112573.72.0

    DRC20520568.3-

    Ethiopia20416468.0

    Zambia18018260.0-

    Tanzania16112253.73.0

    Uganda16013653.3

    Ghana15611152.0

    Rwanda15115250.33.0

    Lesotho10113233.7

    Kenya9712032.3

    Zimbabwe8013226.7

    South Africa6068.0020.0

    Sudan5.0

    Rwanda

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    Note: traffic light results take intermediate data into account

    these countries have lower child mortality but have regressed

    MOZ & MLW making good progress

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    these countries have lower child mortality but have regressed

    MOZ & MLW making good progress

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    UNSD 2007 database

    Africa PSA country19902004TargetWater

    Ethiopia777838.54

    Mozambique6457324

    Malawi6027301.0

    DRC575428.54

    Uganda5640282.0

    Kenya553927.52.0

    Tanzania5438272.0

    Nigeria515225.54

    Zambia5042253.0

    Ghana452522.52.0

    Rwanda412620.52.0

    Zimbabwe2219114

    South Africa17128.52.0

    Lesotho215.0

    Sierra Leone435.0

    Sudan415.0

    notes

    many countries on track

    malawi actually met the target (but beware, modelled data!) - need to sustain efforts

    Note: traffic light results take intermediate data into account

    (hence the odd rwanda result)

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    2004

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    2004

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    Page *

    Chart20

    22.6100

    42.9100

    48.6100

    53.7100

    54.2100

    57.8100

    62.3100

    71.5100

    90.3100

    Tanzania100

    Rwanda100

    Zambia100

    Zimbabwe100

    Kenya100

    Sierra Leone100

    Sudan100

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    Sheet1

    CountryReduce Hunger by HalfCountryNet EnrolmentCountryEqual Girls' Enrolment in Primary SchoolCountryReduce Mortality of Under 5's by Two ThirdsCountryHalve the Proportion without Improved Drinking WaterCountryHalve the Proportion without Improved Sanitation

    DRC5.0DRC5.0DRCDRC-DRC4DRC3.0

    Ethiopia2.0Ethiopia2.0Ethiopia2.0EthiopiaEthiopia4Ethiopia4

    Ghana5.0Ghana3.0Ghana1.0GhanaGhana2.0Ghana4

    Kenya3.0Kenya2.0Kenya2.0KenyaKenya2.0Kenya4

    LesothoLesotho3.0Lesotho1.0LesothoLesotho5.0Lesotho4

    Malawi2.0MalawiMalawi1.0Malawi2.0Malawi1.0Malawi3.0

    Mozambique5.0Mozambique2.0Mozambique2.0Mozambique3.0Mozambique4Mozambique3.0

    Nigeria3.0Nigeria3.0Nigeria2.0NigeriaNigeria4Nigeria4

    Rwanda2.0Rwanda2.0Rwanda1.0Rwanda3.0Rwanda2.0Rwanda4

    Sierra LeoneSierra Leone2.0Sierra Leone2.0Sierra LeoneSierra Leone5.0Sierra Leone5.0

    South Africa5.0South AfricaSouth AfricaSouth AfricaSouth Africa2.0South Africa4

    SudanSudan5.0Sudan5.0Sudan5.0Sudan5.0Sudan5.0

    Tanzania5.0Tanzania2.0Tanzania2.0Tanzania3.0Tanzania2.0Tanzania4

    Uganda3.0UgandaUganda1.0UgandaUganda2.0Uganda4

    Zambia3.0Zambia2.0Zambia2.0Zambia-Zambia3.0Zambia3.0

    Zimbabwe5.0ZimbabweZimbabwe1.0ZimbabweZimbabwe4Zimbabwe4

    Sub-Saharan AfricaDemocratic Republic of the Congo5........

    Sub-Saharan AfricaEthiopia2481992372004

    Sub-Saharan AfricaGhana5....222003

    Sub-Saharan AfricaKenya3221993202003

    Sub-Saharan AfricaLesotho161992202004

    Sub-Saharan AfricaMalawi2271992222004

    Sub-Saharan AfricaMozambique5....242003

    Sub-Saharan AfricaNigeria3361990292003

    Sub-Saharan AfricaRwanda2291992232005

    Sub-Saharan AfricaSierra Leone291990312005

    Sub-Saharan AfricaSouth Africa5........

    Sub-Saharan AfricaSudan5....342006

    Sub-Saharan AfricaUganda3231989202006

    Sub-Saharan AfricaUnited Republic of Tanzania5........

    Sub-Saharan AfricaZambia3251992202004

    Sub-Saharan AfricaZimbabwe5....172003

    Eastern AsiaChina119199082002

    South-Eastern AsiaCambodia401994452000

    South-Eastern AsiaIndonesia5....282003

    South-Eastern AsiaViet Nam5........

    Southern AsiaAfghanistan5....392004

    Southern AsiaBangladesh661990482004

    Southern AsiaIndia531993462005

    Southern AsiaNepal5....482001

    Southern AsiaPakistan401991382002

    Hunger

    UNSD 2007 database

    Africa PSA country1990 (est)~2005Target

    Ethiopia493724.72.0

    Nigeria362917.93.0

    Rwanda302315.12.0

    Sierra Leone293114.4

    Malawi282214.02.0

    Zambia262013.03.0

    Kenya232011.53.0

    Uganda232011.43.0

    Lesotho15207.6

    Sudan345.0

    Mozambique245.0

    Ghana225.0

    Zimbabwe175.0

    DRC5.0

    South Africa5.0

    Tanzania5.0

    Selected data values 2 years either side

    Notes

    Ethiopia: challenging target yet on track

    Several countries on track

    Several other countries off track for 2015 but still progressing

    SL, SUD and LES regressing

    DRC5........DRC5.0

    Ethiopia2481992372004Ethiopia493724.72.0

    Ghana5....222003Ghana225.0

    Kenya3221993202003Kenya232011.53.0

    Lesotho161992202004Lesotho15207.6

    Malawi2271992222004Malawi282214.02.0

    Mozambique5....242003Mozambique245.0

    Nigeria3361990292003Nigeria362917.93.0

    Rwanda2291992232005Rwanda302315.12.0

    Sierra Leone291990312005Sierra Leone293114.4

    South Africa5........South Africa5.0

    Sudan5....342006Sudan313415.5

    Tanzania5........Tanzania225.0

    Uganda3231989202006Uganda232011.43.0

    Zambia3251992202004Zambia262013.03.0

    Zimbabwe5....172003Zimbabwe175.0

    1990 starting point

    target for 2015

    Hunger

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    NER

    Ethiopia faces a challenging target but is on track

    4 countries have one data point but not enough data to assess progress; 3 more do not have current data

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    Target

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    ~2005

    Target

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    Sheet2

    UNSD 2007 database

    Africa PSA country~1991~2005TargetNER

    Ethiopia23701002.0

    Mozambique43771002.0

    Malawi4995100

    Ghana54701003.0

    DRC541005.0

    Nigeria58701003.0

    Uganda6284100

    Lesotho72871003.0

    South Africa9092100

    Tanzania911002.0

    Rwanda951002.0

    Zambia901002.0

    Zimbabwe83100

    Kenya791002.0

    Sierra Leone691002.0

    Sudan291005.0

    notes

    RW etc: assessement exists even though no early 90's data because based on short term trend

    RW,TZ, ZA: recent progress faster than South Africa and Malawi

    MLW: enormous progress since 1990, but slowed down and possible reversal since 2000, hence the 'sligthly off track' result

    1Ethiopia2.0Ethiopia

    2Mozambique2.0Mozambique

    3MalawiMalawi

    4Ghana3.0Ghana

    5DRC5.0DRC

    6Nigeria3.0Nigeria

    7UgandaUganda

    8Lesotho3.0Lesotho

    Note: traffic light results take intermediate data into account9South AfricaSouth Africa

    (hence the odd rwanda result)10Tanzania2.0Tanzania

    11Rwanda2.0Rwanda

    12Zambia2.0Zambia

    13ZimbabweZimbabwe

    14Kenya2.0Kenya

    15Sierra Leone2.0Sierra Leone

    16Sudan5.0Sudan

    1990 starting point

    target for 2015

    Sheet2

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    Gender

    ETH & MOZ had some of the lowest rates in 1990 yet are on track to reach 100% by 2015

    Although their 1990 position is unknown, recent progress in TAN, RWA, ZAM yields an 'on track' assessment

    Malawi data show huge progress, but with a reversal since 2000. Hence the 'off track' results: on current trends, the target would be missed

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    ETH & MOZ had some of the lowest rates in 1990 yet are on track to reach 100% by 2015

    Although their 1990 position is unknown, recent progress in TAN, RWA, ZAM yields an 'on track' assessment

    Malawi data show huge progress, but with a reversal since 2000. Hence the 'off track' results: on current trends, the target would be missed

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    U5M

    UNSD 2007 database

    Africa PSA country1991~2005TargetGender

    Ethiopia0.70.92.0

    Sierra Leone0.70.82.0

    DRC0.8

    Mozambique0.80.92.0

    Nigeria0.80.92.0

    Malawi0.81.01.0

    Ghana0.91.01.0

    Uganda0.91.01.0

    Kenya1.01.02.0

    Rwanda1.01.01.0

    Zimbabwe1.01.0

    Tanzania1.01.02.0

    South Africa1.01.0

    Lesotho1.21.01.0

    Sudan0.95.0

    Zambia1.02.0

    notes

    several countries so close to the target that it is 'met'

    SA data showing a slight regress hence off track, but still close to parity

    Gender Primary

    1EthiopiaEthiopia

    2Sierra LeoneSierra Leone

    3DRCDRC

    4MozambiqueMozambique

    5NigeriaNigeria2.0

    Note: traffic light results take intermediate data into account6MalawiMalawi1.0

    (hence the odd rwanda result)7GhanaGhana1.0

    8UgandaUganda1.0

    9KenyaKenya

    10RwandaRwanda1.0

    11ZimbabweZimbabwe1.0

    12TanzaniaTanzania

    13South AfricaSouth Africa2.0

    14LesothoLesotho1.0

    15SudanSudan

    16ZambiaZambia

    1Ethiopia2.0Ethiopia

    2Sierra Leone2.0Sierra Leone

    3DRCDRC

    4Mozambique2.0Mozambique

    5Nigeria2.0Nigeria

    6Malawi1.0Malawi

    7Ghana1.0Ghana

    8Uganda1.0Uganda

    9Kenya2.0Kenya

    10Rwanda1.0Rwanda

    11Zimbabwe1.0Zimbabwe

    12Tanzania2.0Tanzania

    13South AfricaSouth Africa

    14Lesotho1.0Lesotho

    15Sudan5.0Sudan

    16Zambia2.0Zambia

    U5M

    10.880.66

    10.810.7

    1DRC0.75

    10.850.75

    10.860.81

    11.020.84

    10.980.85

    110.85

    10.960.96

    11.020.97

    1Zimbabwe0.97

    10.970.98

    10.960.99

    111.22

    10.93Sudan

    10.95Zambia

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    Water

    UNSD 2007 database

    Africa PSA country1991~2005TargetGender

    Ethiopia0.70.912.0

    Sierra Leone0.70.812.0

    DRC0.81

    Mozambique0.80.912.0

    Nigeria0.80.912.0

    Malawi0.81.011.0

    Ghana0.91.011.0

    Uganda0.91.011.0

    Kenya1.01.012.0

    Rwanda1.01.011.0

    Zimbabwe1.011.0

    Tanzania1.01.012.0

    South Africa1.01.01

    Lesotho1.21.011.0

    Sudan0.915.0

    Zambia1.012.0

    notes

    several countries so close to the target that it is 'met'

    SA data showing a slight regress hence off track, but still close to parity

    Gender Primary

    1EthiopiaEthiopia

    2Sierra LeoneSierra Leone

    3DRCDRC

    4MozambiqueMozambique

    5NigeriaNigeria2.0

    Note: traffic light results take intermediate data into account6MalawiMalawi1.0

    (hence the odd rwanda result)7GhanaGhana1.0

    8UgandaUganda1.0

    9KenyaKenya

    10RwandaRwanda1.0

    11ZimbabweZimbabwe1.0

    12TanzaniaTanzania

    13South AfricaSouth Africa2.0

    14LesothoLesotho1.0

    15SudanSudan

    16ZambiaZambia

    1Ethiopia2.0Ethiopia

    2Sierra Leone2.0Sierra Leone

    3DRCDRC

    4Mozambique2.0Mozambique

    5Nigeria2.0Nigeria

    6Malawi1.0Malawi

    7Ghana1.0Ghana

    8Uganda1.0Uganda

    9Kenya2.0Kenya

    10Rwanda1.0Rwanda

    11Zimbabwe1.0Zimbabwe

    12Tanzania2.0Tanzania

    13South AfricaSouth Africa

    14Lesotho1.0Lesotho

    15Sudan5.0Sudan

    16Zambia2.0Zambia

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    Ethiopia

    Ethiopia

    Ethiopia

    Sierra Leone

    Sierra Leone

    Sierra Leone

    DRC

    DRC

    DRC

    Mozambique

    Mozambique

    Mozambique

    Nigeria

    Nigeria

    Nigeria

    Malawi

    Malawi

    Malawi

    Ghana

    Ghana

    Ghana

    Uganda

    Uganda

    Uganda

    Kenya

    Kenya

    Kenya

    Rwanda

    Rwanda

    Rwanda

    Zimbabwe

    Zimbabwe

    Zimbabwe

    Tanzania

    Tanzania

    Tanzania

    South Africa

    South Africa

    South Africa

    Lesotho

    Lesotho

    Lesotho

    Sudan

    Sudan

    Sudan

    Zambia

    Zambia

    Zambia

    1

    0.88

    0.66

    1

    0.81

    0.7

    1

    0.75

    1

    0.85

    0.75

    1

    0.86

    0.81

    1

    1.02

    0.84

    1

    0.98

    0.85

    1

    1

    0.85

    1

    0.96

    0.96

    1

    1.02

    0.97

    1

    0.97

    1

    0.97

    0.98

    1

    0.96

    0.99

    1

    1

    1.22

    1

    0.93

    1

    0.95

    Note: traffic light results take intermediate data into account

    Water

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    UNSD 2007 database

    African PSA country1990 starting pointcurrent position (~2005)target for 20152007asst

    Sierra Leone302282100.7

    Mozambique23514578.33.0

    Nigeria23019476.7

    Malawi22112573.72.0

    DRC20520568.3-

    Ethiopia20416468.0

    Zambia18018260.0-

    Tanzania16112253.73.0

    Uganda16013653.3

    Ghana15611152.0

    Rwanda15115250.33.0

    Lesotho10113233.7

    Kenya9712032.3

    Zimbabwe8013226.7

    South Africa6068.0020.0

    Sudan5.0

    Rwanda

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    Note: traffic light results take intermediate data into account

    these countries have lower child mortality but have regressed

    MOZ & MLW making good progress

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    these countries have lower child mortality but have regressed

    MOZ & MLW making good progress

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    UNSD 2007 database

    Africa PSA country19902004TargetWater

    Ethiopia777838.54

    Mozambique6457324

    Malawi6027301.0

    DRC575428.54

    Uganda5640282.0

    Kenya553927.52.0

    Tanzania5438272.0

    Nigeria515225.54

    Zambia5042253.0

    Ghana452522.52.0

    Rwanda412620.52.0

    Zimbabwe2219114

    South Africa17128.52.0

    Lesotho215.0

    Sierra Leone435.0

    Sudan415.0

    notes

    many countries on track

    malawi actually met the target (but beware, modelled data!) - need to sustain efforts

    Note: traffic light results take intermediate data into account

    (hence the odd rwanda result)

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    2004

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    2004

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    Page *

    Chart16

    22.669.5100

    42.977.2100

    48.695.2100

    53.770.4100

    54.2DRC100

    57.869.6100

    62.384100

    71.587.1100

    90.392100

    Tanzania91100

    Rwanda95100

    Zambia90.1100

    Zimbabwe82.5100

    Kenya79.3100

    Sierra Leone69100

    Sudan29.2100

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    Sheet1

    CountryReduce Hunger by HalfCountryNet EnrolmentCountryEqual Girls' Enrolment in Primary SchoolCountryReduce Mortality of Under 5's by Two ThirdsCountryHalve the Proportion without Improved Drinking WaterCountryHalve the Proportion without Improved Sanitation

    DRC5.0DRC5.0DRCDRC-DRC4DRC3.0

    Ethiopia2.0Ethiopia2.0Ethiopia2.0EthiopiaEthiopia4Ethiopia4

    Ghana5.0Ghana3.0Ghana1.0GhanaGhana2.0Ghana4

    Kenya3.0Kenya2.0Kenya2.0KenyaKenya2.0Kenya4

    LesothoLesotho3.0Lesotho1.0LesothoLesotho5.0Lesotho4

    Malawi2.0MalawiMalawi1.0Malawi2.0Malawi1.0Malawi3.0

    Mozambique5.0Mozambique2.0Mozambique2.0Mozambique3.0Mozambique4Mozambique3.0

    Nigeria3.0Nigeria3.0Nigeria2.0NigeriaNigeria4Nigeria4

    Rwanda2.0Rwanda2.0Rwanda1.0Rwanda3.0Rwanda2.0Rwanda4

    Sierra LeoneSierra Leone2.0Sierra Leone2.0Sierra LeoneSierra Leone5.0Sierra Leone5.0

    South Africa5.0South AfricaSouth AfricaSouth AfricaSouth Africa2.0South Africa4

    SudanSudan5.0Sudan5.0Sudan5.0Sudan5.0Sudan5.0

    Tanzania5.0Tanzania2.0Tanzania2.0Tanzania3.0Tanzania2.0Tanzania4

    Uganda3.0UgandaUganda1.0UgandaUganda2.0Uganda4

    Zambia3.0Zambia2.0Zambia2.0Zambia-Zambia3.0Zambia3.0

    Zimbabwe5.0ZimbabweZimbabwe1.0ZimbabweZimbabwe4Zimbabwe4

    Sub-Saharan AfricaDemocratic Republic of the Congo5........

    Sub-Saharan AfricaEthiopia2481992372004

    Sub-Saharan AfricaGhana5....222003

    Sub-Saharan AfricaKenya3221993202003

    Sub-Saharan AfricaLesotho161992202004

    Sub-Saharan AfricaMalawi2271992222004

    Sub-Saharan AfricaMozambique5....242003

    Sub-Saharan AfricaNigeria3361990292003

    Sub-Saharan AfricaRwanda2291992232005

    Sub-Saharan AfricaSierra Leone291990312005

    Sub-Saharan AfricaSouth Africa5........

    Sub-Saharan AfricaSudan5....342006

    Sub-Saharan AfricaUganda3231989202006

    Sub-Saharan AfricaUnited Republic of Tanzania5........

    Sub-Saharan AfricaZambia3251992202004

    Sub-Saharan AfricaZimbabwe5....172003

    Eastern AsiaChina119199082002

    South-Eastern AsiaCambodia401994452000

    South-Eastern AsiaIndonesia5....282003

    South-Eastern AsiaViet Nam5........

    Southern AsiaAfghanistan5....392004

    Southern AsiaBangladesh661990482004

    Southern AsiaIndia531993462005

    Southern AsiaNepal5....482001

    Southern AsiaPakistan401991382002

    Hunger

    UNSD 2007 database

    Africa PSA country1990 (est)~2005Target

    Ethiopia493724.72.0

    Nigeria362917.93.0

    Rwanda302315.12.0

    Sierra Leone293114.4

    Malawi282214.02.0

    Zambia262013.03.0

    Kenya232011.53.0

    Uganda232011.43.0

    Lesotho15207.6

    Sudan345.0

    Mozambique245.0

    Ghana225.0

    Zimbabwe175.0

    DRC5.0

    South Africa5.0

    Tanzania5.0

    Selected data values 2 years either side

    Notes

    Ethiopia: challenging target yet on track

    Several countries on track

    Several other countries off track for 2015 but still progressing

    SL, SUD and LES regressing

    DRC5........DRC5.0

    Ethiopia2481992372004Ethiopia493724.72.0

    Ghana5....222003Ghana225.0

    Kenya3221993202003Kenya232011.53.0

    Lesotho161992202004Lesotho15207.6

    Malawi2271992222004Malawi282214.02.0

    Mozambique5....242003Mozambique245.0

    Nigeria3361990292003Nigeria362917.93.0

    Rwanda2291992232005Rwanda302315.12.0

    Sierra Leone291990312005Sierra Leone293114.4

    South Africa5........South Africa5.0

    Sudan5....342006Sudan313415.5

    Tanzania5........Tanzania225.0

    Uganda3231989202006Uganda232011.43.0

    Zambia3251992202004Zambia262013.03.0

    Zimbabwe5....172003Zimbabwe175.0

    1990 starting point

    target for 2015

    Hunger

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    NER

    Ethiopia faces a challenging target but is on track

    4 countries have one data point but not enough data to assess progress; 3 more do not have current data

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    Target

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    1990 (est)

    ~2005

    Target

    Population undernourished, per cent

    MDG 1 - Progress towards reducing hunger by half, Africa PSA countries

    Sheet2

    UNSD 2007 database

    Africa PSA country~1991~2005TargetNER

    Ethiopia23701002.0

    Mozambique43771002.0

    Malawi4995100

    Ghana54701003.0

    DRC541005.0

    Nigeria58701003.0

    Uganda6284100

    Lesotho72871003.0

    South Africa9092100

    Tanzania911002.0

    Rwanda951002.0

    Zambia901002.0

    Zimbabwe83100

    Kenya791002.0

    Sierra Leone691002.0

    Sudan291005.0

    notes

    RW etc: assessement exists even though no early 90's data because based on short term trend

    RW,TZ, ZA: recent progress faster than South Africa and Malawi

    MLW: enormous progress since 1990, but slowed down and possible reversal since 2000, hence the 'sligthly off track' result

    1Ethiopia2.0Ethiopia

    2Mozambique2.0Mozambique

    3MalawiMalawi

    4Ghana3.0Ghana

    5DRC5.0DRC

    6Nigeria3.0Nigeria

    7UgandaUganda

    8Lesotho3.0Lesotho

    Note: traffic light results take intermediate data into account9South AfricaSouth Africa

    (hence the odd rwanda result)10Tanzania2.0Tanzania

    11Rwanda2.0Rwanda

    12Zambia2.0Zambia

    13ZimbabweZimbabwe

    14Kenya2.0Kenya

    15Sierra Leone2.0Sierra Leone

    16Sudan5.0Sudan

    1990 starting point

    target for 2015

    Sheet2

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    Gender

    UNSD 2007 database

    Africa PSA country1991~2005TargetGender

    Ethiopia0.70.92.0

    Sierra Leone0.70.82.0

    DRC0.8

    Mozambique0.80.92.0

    Nigeria0.80.92.0

    Malawi0.81.01.0

    Ghana0.91.01.0

    Uganda0.91.01.0

    Kenya1.01.02.0

    Rwanda1.01.01.0

    Zimbabwe1.01.0

    Tanzania1.01.02.0

    South Africa1.01.0

    Lesotho1.21.01.0

    Sudan0.95.0

    Zambia1.02.0

    notes

    several countries so close to the target that it is 'met'

    SA data showing a slight regress hence off track, but still close to parity

    Gender Primary

    1EthiopiaEthiopia

    2Sierra LeoneSierra Leone

    3DRCDRC

    4MozambiqueMozambique

    5NigeriaNigeria2.0

    Note: traffic light results take intermediate data into account6MalawiMalawi1.0

    (hence the odd rwanda result)7GhanaGhana1.0

    8UgandaUganda1.0

    9KenyaKenya

    10RwandaRwanda1.0

    11ZimbabweZimbabwe1.0

    12TanzaniaTanzania

    13South AfricaSouth Africa2.0

    14LesothoLesotho1.0

    15SudanSudan

    16ZambiaZambia

    1Ethiopia2.0Ethiopia

    2Sierra Leone2.0Sierra Leone

    3DRCDRC

    4Mozambique2.0Mozambique

    5Nigeria2.0Nigeria

    6Malawi1.0Malawi

    7Ghana1.0Ghana

    8Uganda1.0Uganda

    9Kenya2.0Kenya

    10Rwanda1.0Rwanda

    11Zimbabwe1.0Zimbabwe

    12Tanzania2.0Tanzania

    13South AfricaSouth Africa

    14Lesotho1.0Lesotho

    15Sudan5.0Sudan

    16Zambia2.0Zambia

    ETH & MOZ had some of the lowest rates in 1990 yet are on track to reach 100% by 2015

    Although their 1990 position is unknown, recent progress in TAN, RWA, ZAM yields an 'on track' assessment

    Malawi data show huge progress, but with a reversal since 2000. Hence the 'off track' results: on current trends, the target would be missed

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    ETH & MOZ had some of the lowest rates in 1990 yet are on track to reach 100% by 2015

    Although their 1990 position is unknown, recent progress in TAN, RWA, ZAM yields an 'on track' assessment

    Malawi data show huge progress, but with a reversal since 2000. Hence the 'off track' results: on current trends, the target would be missed

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    Note: traffic light results take intermediate data into account

    ~1991

    ~2005

    Target

    Net enrolment rate, per cent

    MDG 2 - Progress towards universal primary education, Africa PSA countries

    Gender

    10.880.66

    10.810.7

    1DRC0.75

    10.850.75

    10.860.81

    11.020.84

    10.980.85

    110.85

    10.960.96

    11.020.97

    1Zimbabwe0.97

    10.970.98

    10.960.99

    111.22

    10.93Sudan

    10.95Zambia

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    U5M

    UNSD 2007 database

    Africa PSA country1991~2005TargetGender

    Ethiopia0.70.912.0

    Sierra Leone0.70.812.0

    DRC0.81

    Mozambique0.80.912.0

    Nigeria0.80.912.0

    Malawi0.81.011.0

    Ghana0.91.011.0

    Uganda0.91.011.0

    Kenya1.01.012.0

    Rwanda1.01.011.0

    Zimbabwe1.011.0

    Tanzania1.01.012.0

    South Africa1.01.01

    Lesotho1.21.011.0

    Sudan0.915.0

    Zambia1.012.0

    notes

    several countries so close to the target that it is 'met'

    SA data showing a slight regress hence off track, but still close to parity

    Gender Primary

    1EthiopiaEthiopia

    2Sierra LeoneSierra Leone

    3DRCDRC

    4MozambiqueMozambique

    5NigeriaNigeria2.0

    Note: traffic light results take intermediate data into account6MalawiMalawi1.0

    (hence the odd rwanda result)7GhanaGhana1.0

    8UgandaUganda1.0

    9KenyaKenya

    10RwandaRwanda1.0

    11ZimbabweZimbabwe1.0

    12TanzaniaTanzania

    13South AfricaSouth Africa2.0

    14LesothoLesotho1.0

    15SudanSudan

    16ZambiaZambia

    1Ethiopia2.0Ethiopia

    2Sierra Leone2.0Sierra Leone

    3DRCDRC

    4Mozambique2.0Mozambique

    5Nigeria2.0Nigeria

    6Malawi1.0Malawi

    7Ghana1.0Ghana

    8Uganda1.0Uganda

    9Kenya2.0Kenya

    10Rwanda1.0Rwanda

    11Zimbabwe1.0Zimbabwe

    12Tanzania2.0Tanzania

    13South AfricaSouth Africa

    14Lesotho1.0Lesotho

    15Sudan5.0Sudan

    16Zambia2.0Zambia

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    Ethiopia

    Ethiopia

    Ethiopia

    Sierra Leone

    Sierra Leone

    Sierra Leone

    DRC

    DRC

    DRC

    Mozambique

    Mozambique

    Mozambique

    Nigeria

    Nigeria

    Nigeria

    Malawi

    Malawi

    Malawi

    Ghana

    Ghana

    Ghana

    Uganda

    Uganda

    Uganda

    Kenya

    Kenya

    Kenya

    Rwanda

    Rwanda

    Rwanda

    Zimbabwe

    Zimbabwe

    Zimbabwe

    Tanzania

    Tanzania

    Tanzania

    South Africa

    South Africa

    South Africa

    Lesotho

    Lesotho

    Lesotho

    Sudan

    Sudan

    Sudan

    Zambia

    Zambia

    Zambia

    1

    0.88

    0.66

    1

    0.81

    0.7

    1

    0.75

    1

    0.85

    0.75

    1

    0.86

    0.81

    1

    1.02

    0.84

    1

    0.98

    0.85

    1

    1

    0.85

    1

    0.96

    0.96

    1

    1.02

    0.97

    1

    0.97

    1

    0.97

    0.98

    1

    0.96

    0.99

    1

    1

    1.22

    1

    0.93

    1

    0.95

    Note: traffic light results take intermediate data into account

    U5M

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    Water

    UNSD 2007 database

    African PSA country1990 starting pointcurrent position (~2005)target for 20152007asst

    Sierra Leone302282100.7

    Mozambique23514578.33.0

    Nigeria23019476.7

    Malawi22112573.72.0

    DRC20520568.3-

    Ethiopia20416468.0

    Zambia18018260.0-

    Tanzania16112253.73.0

    Uganda16013653.3

    Ghana15611152.0

    Rwanda15115250.33.0

    Lesotho10113233.7

    Kenya9712032.3

    Zimbabwe8013226.7

    South Africa6068.0020.0

    Sudan5.0

    Rwanda

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Target

    ~2005

    1991

    Ratio of girls to boys in primary

    MDG 3 - Progress towards equal girls enrolment in primary education, Africa PSA countries

    Note: traffic light results take intermediate data into account

    Water

    these countries have lower child mortality but have regressed

    MOZ & MLW making good progress

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    these countries have lower child mortality but have regressed

    MOZ & MLW making good progress

    Note: traffic light results take intermediate data into account

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track not enough data

    Note: traffic light results take intermediate data into account

    1990 starting point

    current position (~2005)

    target for 2015

    Under-5 mortality rate, per thousand

    MDG 4 - Reducing child mortality by two thirds, Africa PSA countries

    UNSD 2007 database

    Africa PSA country19902004TargetWater

    Ethiopia777838.54

    Mozambique6457324

    Malawi6027301.0

    DRC575428.54

    Uganda5640282.0

    Kenya553927.52.0

    Tanzania5438272.0

    Nigeria515225.54

    Zambia5042253.0

    Ghana452522.52.0

    Rwanda412620.52.0

    Zimbabwe2219114

    South Africa17128.52.0

    Lesotho215.0

    Sierra Leone435.0

    Sudan415.0

    notes

    many countries on track

    malawi actually met the target (but beware, modelled data!) - need to sustain efforts

    Note: traffic light results take intermediate data into account

    (hence the odd rwanda result)

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    2004

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    2004

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    Target

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    1990 starting point 2015 targetcurrent position: on track slightly off track seriously off track no enough data

    Note: traffic light results take intermediate data into account

    1990

    Percentage of people without improved water sources

    MDG 7 - Access to improved water sources, Africa PSA countries

    Page *

    Page *

    Still looking at NER

  • Page *

    Thats the why

    The what

    Page *

    DevInfo v 4.0Standard indicator selectionGoal/sectorTimeGeography

    Page *

    DevInfo v 4.0Presentations in tables

    Page *

    DevInfo v 4.0Presentations in Graphs

    Page *

    DevInfo v 4.0Presentations in Maps

  • Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    Page *

    The annoying paper clip

    Page *

    Page *

    Page *

    Page *

    Page *

    Next stepsInternal feedback is very positiveAdding more contentDeploying with a small group of users

    But our needs arent unique

    Have you a solution? Can you help find a solution?

    Page *

    Background question and answer material on DFID, which can be drawn on when staff make presentations to external audiences about the department can be found at http://insight/info/default.asp?presentation/default.htm

    Additionally there is a Photo Library that has been designed to enable staff to search a database of over 1000 images. These images can either be downloaded or ordered as photographs or slide transparencies. Visit http://insight/elibrary/default.asp?edatabases/photolib/plhome.htm

    African PSA countriesNote traffic lights are based on intermediate data

    Ethiopia and Mozambique have some of the lowest rates in 1990 yet are on track to reach 100% by 2015

    Tanzania, Rwanda and Zambia have no 1990 baseline data but recent progress puts them on track

    Malawi has shown huge progress in the data, BUT with a reversal of progress since 2000 produces an OFF TRACK on CURRENT trends suggesting the target will be missed . EXPAND .In a map this looks like this note sash across Africa of where we dont know what is happening

    Talk about what we dont know (greys below) and why (lack of data, not supported) and need to do something about this to help achieve the MDGs . To access the DevInfo database, first click on the Indicator button to select indicators. This screen shows indicators organized by the MDGs.

    Here is an example of a table generated by the systemand a graph.and a map.5. - Example of a comment7. - Table showing selected data, Footnotes and Notes.8. - Using Table Wizard Table with the data shown in 4 for seven countries. (Selecting variables for rows and columns).9. - Table showing International and Local data.13. - Map using the data shown in 9. Colours show internation data and # indicates local data.14. - Map showing lack of data for Africa on the percentage of population below 1$ a day. Data selection is between 1990 and 2006. The label shows the date of latest data for each country.16. - Creating a CAP report17. - Creating a CAP report18. - Creating a CAP report19. - Creating a CAP report20. - Creating a CAP report21. - Creating a CAP report23. - CAP report Mozambique: footnotes.22. - CAP report - Mozambique36. - Example of Database Assistant help.37. - Example of Database Assistant help.38. - Example of Database Assistant help.40. - Example of Database Assistant help.41. - Example of Sub-national data for India. The background colours represent the under 5 mortality rate and the coloured dots represent deaths per 1,000 live births.