Arab Republic of Egypt Central Agency for Public
Arab Republic of Egypt Central Agency for Public Mobilization and Statistics information technology sector Dissemination of census data and Public housing
Dissemination of census data using Census. Info
First : Introduction q In the framework of cooperation between the Central Agency for Public Mobilization and Statistics and the Statistical Division of the United Nations We developed dissemination of census data using Census. Info, To take full advantage of census data have been collected, and the use of appropriate mechanisms for data analysis. q Often be the end destination for dissemination of census data in tabular form, whether in print or on the Internet The process of making it boring and unattractive to users. q Must be census data useful for public dialogue, it should be accessible to the international community via the Internet in multiple languages. q Users need to be able to access data quickly and easily in every detail of the custom: by sex and age, at different levels of geographic areas, according to the time period for comparison purposes of appropriate mechanisms for data analysis.
Second : What is Census. Info q The United Nations Statistics Division, in partnership with UNICEF and UNFPA, has developed a free software package, Census. Info to help countries disseminate census data on CD-ROM and on the web. q Census. Info was officially launched at the 40 th Statistical Commission in February 2009. q UNSD provides Census. Info software with a proposed list of census indicators and metadata in order to assist countries in setting up their own indicators and metadata according to national priorities and needs. q The primary objective of the session is to present experiences of countries using Census. Info to disseminate the results of their population /improve quality of dissemination of census results.
Third: Main features of Census. Info q. The possibility of changing the user interface according to the country. q. Possibility of changing the language (Arabic - English – French). q. Create and graphic features to the database by ci-video. q. Create a book simulates specific topics (educational status -employment. . . ) through the use of (ci Book). q Displays the final results in the form (tables - Maps - graph).
Continued : Main features of Census. Info q Can deal with the final results of absolute freedom, as well as can be saved on the personal computer until needed. q The possibility of printing or save the final output fully (Table - Map Chart). q The ability to make comparisons and analysis of the final results of the census. q. Development of census data dissemination.
changing the user interface according to the country
changing the language (Arabic-English–French)
Create a book simulates specific topics (educational status - employment. . . ) through the use of (ci Book). r u n o o i y at a e e k s n t i u g ea o a cr b o im o ip t fl
Data extraction using Census. Info
Development of census data dissemination Extracting the final results in three forms 37500000 Image of the final product 37000000 37, 219, 056 Population size Number - 2006 36500000 36000000 Female Male 35, 578, 975 35500000 35000000 34500000 Egypt Population size Number - 2006 Subgroup Female Male Egypt 35, 578, 975 37, 219, 056
Dealing with the statement Modify the format of the final product as desired by the user
Make adjustments from the point of view of the user
Make adjustments from the point of view of the user
Save the results on the Personal Computer 37500000 37000000 37, 219, 056 Population size Number - 2006 36500000 Female Male 36000000 35, 578, 975 35500000 35000000 34500000 Egypt Population size Number - 2006 Subgroup Female Male Egypt 35, 578, 975 37, 219, 056
Print results 37500000 37000000 37, 219, 056 Population size Number - 2006 36500000 36000000 Female Male 35, 578, 975 35500000 35000000 34500000 Egypt Population size Number - 2006 Subgroup Egypt Female 35, 578, 975 Male 37, 219, 056
Development dissemination of census data q. Classification to the (characteristics of geographic indicators - Demographic - Economic - Education – disability…. ). q. Added percentages to the database where the percentages reflect more than numbers. q. Availability of metadata. q. Availability Only specific information from the census (ex: female less than 5 years) at the level of geographical area. q. Can be chosen more than one statement in different tables (Total population - disability - educational status). q. Search in Database (ex: literacy) to show all data on the subject of research. q. Comparisons between the census periods from 1996 to 2006.
Classification to the (characteristics of geographic indicators Demographic - Economic - Education – disability…. ).
Added percentages to the database
Female less than 5 years governorates(cairo – 6 october – helwan) Specific information at the level of geographical area
Choose more than one statement in different tables (Total population - disability - educational status)
Choose more than one statement in different tables (Total population - disability - educational status) Total Population - Population without disability - educational status - with Special Needs Population - Population without disability educational status - with disability Census -2006 Data/Indicator Total Population Egypt 72, 798, 031 Population without Disability 72, 322, 455 Education by age. Total Educational Status 57, 434, 884 Population with Disability 475, 576 80000000 72, 798, 031 72, 322, 455 70000000 57, 434, 884 60000000 50000000 Total Population 40000000 Population without Disability 30000000 Education by age. Total Educational Status 20000000 10000000 475, 576 0 Total Population without Disability Education by Population with age. Total Disability Educational Status
Search in database ( ex : Illiteracy) Show all data on the subject of research)
Knowledge of geography and population distribution in accordance with the administrative units at all levels in different places. . Etc. . Population ratio according to Urban/Rural Population_ratio according to Urban/Rural Percent - 2006 Subgroup Egypt Rural 56. 91 Urban 43. 09 Rural 57% Urban 43%
Internal Migration Total Number - Total - 2006 Area Name Data Value Cairo Giza Kalyoubia Ismailia Alexandria 6 -OCT Sharkia Suez Port-Said Behera Helwan Dakahlia Red Sea Menoufia Kafr El-Sheikh 804, 403 642, 479 611, 287 298, 587 277, 909 270, 674 244, 503 193, 885 193, 742 193, 131 191, 497 92, 727 82, 935 69, 160 68, 694 Gharbia Domiat Beni-Suef North Sinai Matrouh Aswan Quena South Sinai Assyout New Valley Menia Suhag Fayoum Luxor 68, 104 59, 299 49, 761 48, 346 43, 705 42, 400 41, 629 41, 119 40, 311 31, 235 29, 618 22, 115 14, 242 5, 985 900000 Internal Migration Total Number - Total - 2006 800000 700000 600000 500000 Data Value 400000 300000 200000 100000 0 i t t f i r iro iza bia ilia ria CT kia uez aid era an lia ea fia ikh bia ia ue na uh an na na ou lley nia ag um xo Ca Gyousma and 6 -O har S rt-SBeh elwakahed Snou. She har. Domni-Sh Si atro. Asw. Queh Sissy Va Me Suhayo Lu l I ex H D R e l- G S t A ew t F M r E Po Be. Nor M Ka ou Al N S f a K
the causes of internal migration Egypt_Census_2006 Data/Indicator Companying Unstate 0% Divorced &Widower 1% Study 2% Other 9% Percent 35. 86 Marriage 28. 79 Work 23. 21 Other 9. 28 Study 2. 22 Divorced &Widower 0. 65 Unstate 0. 00 Companying 36% Percent - Total - 2006 Work 23% Marriage 29%
The proportion of the educational situation Egypt_Census_2006 Data/Indicator Illiterate Mid certificates percent 29. 64 25. 80 35 30 The proportion of the educational situation 29. 64 25. 8 25 19. 42 20 Pre Mid certificates University Qualified Literacy Up University Not Stated Educational Status 19. 42 9. 35 0. 97 0. 24 0. 08 15 9. 350000001 10 5 0 0. 970000001 0. 24 Illiterate Mid certificates Pre Mid certificates University Qualified Literacy 0. 08 Up Not Stated University Educational Status
The proportion of divorce according to educational status 50 Egypt 45 Illitrate 45. 96 40 Mid Certificate 21. 32 35 ac y tr Li U p M id C er 0. 59 ed 0. 06 at W tif ic at e e rit e ea d& ca t R tif i er C id er id C ve rs ity M M 0. 06 ni Ill itr Un stated U 0. 59 Pr e Up University at e 0 tif ic 1. 27 at e Litracy Qualified 1. 27 n st 2. 91 5 ty 10 U 2. 91 si Up Mid Certificate 9. 35000000 11. 47 000001 7. 08 15 ve r 7. 08 ni Read&Write 20 U 9. 35 Egypt 21. 32 lif ie d Pre Mid Certificate 25 p 11. 47 U University 30 Q ua Data/Indicator The proportion of divorce according to educational status 45. 96 Egypt -census- 2006
The proportion of divorce according to educational status At governorate level Egypt – census - 2006 Illitrate Litracy Qualified Read&Write Pre Mid Certificate Suhag 72. 99 1. 18 5. 69 4. 97 10. 72 1. 43 2. 93 0. 09 0 Quena 70. 52 2. 14 4. 64 7. 53 11. 64 1. 19 2. 30 0. 03 0 Fayoum 69. 24 2. 20 4. 46 2. 71 16. 61 1. 47 3. 16 0. 15 0 Menia 68. 57 1. 87 4. 99 3. 69 15. 40 1. 28 4. 03 0. 17 0 Assyout 66. 96 1. 38 4. 60 5. 06 15. 42 1. 81 4. 59 0. 19 0 Beni-Suef 66. 39 1. 32 5. 76 3. 50 15. 97 1. 76 5. 13 0. 17 0 Kafr El-Sheikh 60. 85 1. 11 6. 31 3. 03 20. 35 2. 28 5. 89 0. 18 0 Behera 60. 16 1. 17 6. 95 6. 23 18. 97 1. 93 4. 43 0. 16 0 Matrouh 57. 92 4. 36 6. 49 13. 09 12. 81 1. 90 3. 30 0. 11 0 Luxor 55. 69 2. 33 4. 96 11. 13 17. 33 4. 85 3. 51 0. 19 0 Sharkia 53. 87 0. 83 7. 24 6. 26 20. 23 2. 81 8. 46 0. 31 0 Area Name Mid Up Mid Certificate University Up Un stated University
The proportion of divorce according to educational status At governorate level
Census 2006 Census 1996 Egypt 2006 75+ yr 70 -74 yr 6, 000. 004, 000. 002, 000. 00 Male 65 -69 yr Female 60 -64 yr Male Female 70 -74 yr 65 -69 yr 60 -64 yr 55 -59 yr 50 -54 yr 45 -49 yr 40 -44 yr 35 -39 yr 30 -34 yr 25 -29 yr 20 -24 yr 15 -19 yr 10 -14 yr 05 -09 yr <5 yr 2, 000. 004, 000. 006, 000. 004, 000. 002, 000. 00 2, 000. 004, 000. 006, 000. 00
Population size Egypt_Census_2006 Gender Data Value Male 37, 219, 056 Female 35, 578, 975 female
Some analysis on the educational status
Comparison of educational level between the censuses from 1996 to 2006 Educational Status Arab Republic of Egypt Census 2006 35 30 45 29. 64 Egypt 25. 8 15 10 5 0 39. 37 Egypt 35 25 20 40 Educational Status Arab Republic of Egypt Census 1996 30 19. 42 25 9. 350000 11. 96 0000000 1 0. 970000000 2. 53 01 0. 24 0. 08 y s s s cy rsity tus ate ate rite rsit ate a r r a t e W e e t ic ic ic te Illi ertif d & niv ertif d Li Univ nal S U a c fie Up atio dc d c Re id ali c M Mi e Mi u du Q Up E Pr d ate t t. S No 20 18. 7417. 65 16. 53 15 10 5 0 5. 51 2. 02 0. 17 0 0 s tes rsity ates rsity tatus racy ate rite ate r a e W e t ific nive rtific nive al S ific Lit Illi d & cert e d U U n a c e o lifi id id Up cati Re Mid a M M u u e Q Up Ed Pr d e at St t No
Comparison of educational level between the censuses from 1996 to 2006 Percent - Educational Status - 2006 Educational Status Percent Illiterate Mid certificates 29. 64 25. 8 Pre Mid certificates 19. 42 Read & Write University Up Mid certificates 11. 96 9. 35 2. 53 Qualified Literacy 0. 97 Up University Not Stated Educational Status 0. 24 0. 08 Percent - Educational Status - 1996 Educational Status Percent Illiterate Read & Write 39. 37 18. 74 Pre Mid certificates 17. 65 Mid certificates 16. 53 University 5. 51 Up Mid certificates 2. 02 Up University 0. 17 Not Stated Educational Status 0 Qualified Literacy 0
Compared the proportion of illiteracy among the 1996 and 2006 censuses Comparison of proportion of Illiterate 45 40 39. 37 Data Value 35 29. 64 30 Year 1996 Percent 39. 37 25 20 15 10 5 2006 29. 64 0 Egypt_Census_1996 Egypt_Census_2006 1996 2006
Compare the proportion of Illiteracy among the censuses in 2006 and 1996 By Gender Comparison of 60 proportion of Illiterate By Gender 50 Comparison of proportion of Illiterate Female 50. 2 37. 26 40 year Female Male 1996 50. 2 Male 29. 01 30 22. 34 29. 01 20 10 2006 37. 26 22. 34 0 Egypt_Census_1996 Egypt_Census_2006 1996 2006
Illiteracy in top 10 governorates Percent - Total - 2006 Governorates Menia Fayoum Beni-Suef Assyout Suhag Behera Matrouh Quena Kafr El-Sheikh 6 -OCT percent 41. 29 40. 89 40. 54 39. 06 38. 5 36. 66 35. 08 34. 77 34. 31 34. 2 Illiteracy in top 10 governorates Percent - Total - 2006 45 41. 29 40. 89 40. 54 40 39. 06 38. 5 35 Data Value 36. 66 35. 08 34. 77 34. 31 34. 2 30 25 20 15 10 5 0 a M i en F ut f m ou y a n Be i- e Su As o sy a h na ag uh CT ik er e h o e h O r u h 6 Su Q at Be -S l M E fr a K
Illiteracy in top 10 governorates
The proportion of illiterate females in top 10 governorates Census 2006 Illiterate 60 52. 91 52. 16 50 50. 1 49. 95 49. 02 48. 91 45. 78 45. 44 43. 06 42. 66 40 30 Data. . . 20 10 h he ik T l-S C fr E 6 O Ka ue na Q he ra h ro u at M Be t ou sy As ha g Su Fa yo um ue f ni -S Be en i a 0 M Percent - Female - 2006 Data Governorates Value Menia 52. 91 Beni-Suef 52. 16 Fayoum 50. 1 Suhag 49. 95 Assyout 49. 02 Matrouh 48. 91 Behera 45. 78 Quena 45. 44 6 -OCT 43. 06 Kafr El-Sheikh 42. 66 Illiterate Percent - Female - 2006
The proportion of illiterate females in top 10 governorates Census 2006
The proportion of illiterate females in top 10 governorates Census 2006 The ratio of males are illiterate males in the top 10 governorates Illiterate Percent - Male - 2006 Data Value 32. 3 30. 07 29. 41 29. 24 30. 07 20 Assyout 29. 41 15 Beni-Suef 29. 24 Behera 27. 96 Suhag 27. 18 6 -OCT 26. 15 26. 08 Sharkia 25. 08 Quena 24. 07 27. 96 27. 18 26. 15 26. 08 25 Menia Kafr El-Sheikh 32. 3 30 Fayoum 35 25. 08 24. 07 10 5 0 Fa y m ou ut o y ia M en ss A B en i- e Su f a B e r he g S a uh T O 6 K h ik e h C r af -S El Sh a ki r a a n ue Q Data Value
People with special needs The census provides data on persons with disabilities or special needs, and this statement is important in terms of health and social services. Proportions of healthy and disability 120 Egypt_Census_2006 100 People with special needs Percent 99. 35 Population without Disability Population with Disability 80 60 Population without Disability Population with Disability 99. 35 40 20 0. 6500000008 0 0. 65 Population without Disability Population with Disability
By knowing the number of disabled persons, and the type of disability and the cause of disability for each of them? Can be therapeutic and rehabilitative programs to assign suitable work for them? Help them economically and significantly help in solving the problems which arise from mental disabilities. Title Percent - Total - 2006 Proportions of healthy and disability 25 Type of disability percent 20 Mentally Ous 22. 39 Other Infermutes 17. 73 15 Paralysis Poliomyelitics 14. 82 13. 13 10 Blind Deaf & Dumb 8. 94 6. 57 5 One Eyed Lost one or both Legs 4. 01 3. 68 Deaf Dumb Lost one or both Hands 3. 49 2. 57 2. 33 22. 39 Egypt 17. 73 14. 82 13. 13 8. 94 6. 57 4. 01 3. 68 3. 49 2. 57 2. 33 0 f us tes ysis itics lind mb yed egs ea mb nds O u l l D Du a L B Du E ly rm ara ye H h l e t a fe P & n o h m t t f O rb o a lio en r In b e o o r M he D P o t ne e O o on st t o s L Lo
The prevalence of widowhood and divorce. The proportion of the widows and divorced Title Percent - Total - 2006 Divorced 11% Census - 2006 widowhood and divorce percent Widowed 6. 32 Divorced 0. 78 Widowed 89%
Thank you
- Slides: 49