Urbanization Sheet by t1LffM

VIEWS: 59 PAGES: 11

									Compare the Urbanization Experience of Your Two Countries
Instructions:
1. Go to the Country Profiles page of the UN's "World Urbanization Prospects: The 2007 Revision Population Database." Just click on thi
2. Choose your "Country A" (less developed) and download data from "1950" to "2050" as a "csv" file that you save on your Desktop or U
3. Open up this csv file in Excel and then highlight and "copy" all the data from cell "A3" to cell "W11"
4. Put your cursor on cell A16 of this worksheet, go to "Edit" on the menu above and choose "Paste."
5. Repeat the above steps 1 to 4 for your Country B (more developed). and "paste" that data into the A34 cell.
6. Go to the Urban Agglomorations page of the UN's "World Urbanization Prospects: The 2007 Revision Population Database." Just click
7. Choose your "Country A" (less developed) and download data from "1950" to "2025" as a "csv" file that you save on your Desktop or U
8. Find the three cities with the largest population in 2005 and copy from their name in column C to the last column of data. Paste the large
9. If your country does not have data for three cities then just copy the city data that is available. Go back and erase the Indian data that tha
14. Repeat the above steps 6 to 9 for your Country B (more developed). and replace the UK largest city data in rows B46, 47, and 48.
15. Examine the charts with data tables listed in the worksheet line below ("%Urban", etc.). Copy and paste these charts into a Word file c


Country                           Variable                                          1950         1955        1960        1965
India                             Rural population (thousands)                    308484       334228      366042      401094
India                             Urban population (thousands)                     63373        71301       79938       92773
India                             Percentage urban (%)                                17          17.6        17.9        18.8


Country                           Variable                                     1950-1955 1955-1960 1960-1965 1965-1970
India                             Rural annual growth rate (%)                       1.6      1.82      1.83      1.89
India                             Urban annual growth rate (%)                      2.36      2.29      2.98      3.14
                                  % rural                                             83      82.4      82.1      81.2

Country                           Three Largest Cities (in 2005)                     1950        1955        1960         1965
India                             Mumbai (Bombay)                                    2857        3432        4060         4854
India                             Delhi                                              1369        1782        2283         2845
India                             Kolkata (Calcutta)                                 4513        5055        5652         6261




Country                           Variable                                           1950        1955        1960        1965
United Kingdom                    Rural population (thousands)                      10639       10898       11289       12054
United Kingdom                    Urban population (thousands)                      39977       40301       41083       42296
United Kingdom                    Percentage urban (%)                                 79         78.7        78.4        77.8


Country                           Variable                                     1950-1955 1955-1960 1960-1965 1965-1970
United Kingdom                    Rural annual growth rate (%)                      0.48       0.7      1.31       1.1
United Kingdom                    Urban annual growth rate (%)                      0.16      0.38      0.58       0.3
                                  % rural                                             21      21.3      21.6      22.2

Country                           Three Largest Cities (in 2005)                     1950        1955        1960         1965
United Kingdom                    London                                             8361        8278        8196         7869
United Kingdom                    Birmingham                                         2229        2283        2338         2357
United Kingdom                    Manchester                                         2422        2425        2427         2413
 n Database." Just click on this link:                                      http://esa.un.org/unup/index.asp?panel=3
you save on your Desktop or USB drive.




 pulation Database." Just click on this link:                               http://esa.un.org/unup/index.asp?panel=2
you save on your Desktop or USB drive.
  olumn of data. Paste the largest city in B28, the second largest in B29 and the third largest in B30.
 d erase the Indian data that that might remain in rows 28, 29, and 30.
 in rows B46, 47, and 48.
 these charts into a Word file containing your analysis..


                    1970        1975        1980        1985        1990         1995       2000        2005       2010      2015
                  440766      482841      529529      583367      640437       700508     756797      808840     853324    886923
                  108546      130927      159046      187754      219758       253774     289438      325563     366858    415612
                    19.8         21.3        23.1        24.3        25.5        26.6        27.7        28.7       30.1      31.9


               1970-1975 1975-1980 1980-1985 1985-1990 1990-1995 1995-2000 2000-2005 2005-2010 2010-2015 2015-2020
                    1.82      1.85      1.94      1.87      1.79      1.55      1.33      1.07      0.77      0.44
                    3.75      3.89      3.32      3.15      2.88      2.63      2.35      2.39       2.5      2.57
                    80.2      78.7      76.9      75.7      74.5      73.4      72.3      71.3      69.9      68.1

                     1970        1975       1980        1985        1990         1995       2000        2005       2010      2015
                     5811        7082       8658       10341       12308        14111      16086       18202      18978     20072
                     3531        4426       5558        6769        8206        10092      12441       15053      15926     17015
                     6926        7888       9030        9946       10890        11924      13058       14282      14787     15577




                    1970        1975        1980        1985        1990         1995       2000        2005       2010      2015
                   12738        9743        6795        6423        6472         6374       6268        6193       6066      5900
                   42926       46483       49519       50131       50765        51586      52600       54052      55451     56886
                    77.1         82.7        87.9        88.6        88.7          89        89.4        89.7       90.1      90.6


               1970-1975 1975-1980 1980-1985 1985-1990 1990-1995 1995-2000 2000-2005 2005-2010 2010-2015 2015-2020
                    -5.36     -7.21     -1.13     0.15       -0.3     -0.34     -0.24     -0.41     -0.56      -0.7
                     1.59      1.27      0.25     0.25      0.32       0.39      0.54      0.51      0.51       0.5
                     22.9      17.3      12.1     11.4      11.3         11      10.6      10.3       9.9       9.4

                     1970        1975       1980        1985        1990         1995        2000       2005       2010      2015
                     7509        7546       7660        7667        7654         7908        8225       8505       8567      8607
                     2370        2365       2357        2330        2301         2291        2285       2283       2285      2291
                     2396        2370       2343        2313        2282         2262        2243       2230       2230      2235
    2020      2025       2030      2035      2040      2045      2050
  906638    909444     894341    867347    832814    791239    743382
  472561    538055     611407    686835    763905    840681    914888
    34.3       37.2       40.6      44.2      47.8     51.5       55.2


2020-2025 2025-2030 2030-2035 2035-2040 2040-2045 2045-2050
     0.06      -0.33     -0.61     -0.81     -1.02     -1.25
      2.6       2.56      2.33      2.13      1.92      1.69
     65.7       62.8      59.4      55.8      52.2      48.5     44.8

    2020       2025      2030
   21946      24051     26385
   18669      20484     22498
   17039      18707     20560




    2020       2025      2030      2035      2040      2045      2050
    5696       5453      5188      4918      4652      4395      4147
   58337      59738     60974     62013     62929     63777     64569
    91.1        91.6      92.2      92.7      93.1     93.6        94


2020-2025 2025-2030 2030-2035 2035-2040 2040-2045 2045-2050
     -0.87       -1      -1.07     -1.11     -1.14     -1.16
      0.47     0.41       0.34      0.29      0.27      0.25
       8.9      8.4        7.8       7.3       6.9       6.4        6

     2020      2025      2030
     8618      8618      8618
     2303      2315      2323
     2246      2258      2267
India            urban pop
India            rural pop

India            urban (%)
India            rural (%)


% urban




United Kingdom   urban pop
United Kingdom   rural pop
% rural

United Kingdom   rural (%)




United Kingdom   urban (%)
                                                                          % of Population Living in Urban Places, 1950 to 2005
                                                                                                 India                                       United Kingdom

                                                          Source: United Nations Population Division, "World Urbanization Prospects: The 2007 Revision, http://esa.un.org/unup/index.asp?panel=3
                                                  100

                                                   90
% of Population Living in Urban Places




                                                   80

                                                   70

                                                   60

                                                   50

                                                   40

                                                   30

                                                   20

                                                   10

                                                    0
                                                           1950        1955        1960        1965        1970       1975        1980        1985        1990        1995       2000        2005    2010
                                         India               17         17.6       17.9        18.8        19.8        21.3        23.1       24.3        25.5        26.6        27.7        28.7   30.1
                                         United Kingdom      79         78.7       78.4        77.8        77.1        82.7        87.9       88.6        88.7         89         89.4        89.7   90.1
                               Urban and Rural Populations and Percents, 1950 to 2005 and Projections to 2050
                                                  India urban pop                      India rural pop                     % urban                         % rural

                                   Source: United Nations Population Division, "World Urbanization Prospects: The 2007 Revision, http://esa.un.org/unup/index.asp?panel=3
                      1000000                                                                                                                                                             100

                        900000                                                                                                                                                            90

                        800000                                                                                                                                                            80

                        700000                                                                                                                                                            70
Population in 000s




                                                                                                                                                                                                % of Population
                        600000                                                                                                                                                            60

                        500000                                                                                                                                                            50

                        400000                                                                                                                                                            40

                        300000                                                                                                                                                            30

                        200000                                                                                                                                                            20

                        100000                                                                                                                                                            10

                               0                                                                                                                                                          0
                                    1950   1955   1960   1965   1970   1975   1980   1985   1990   1995   2000   2005   2010   2015   2020   2025   2030   2035      2040   2045   2050
                     India urban pop 63373 71301 79938 92773 108546130927159046187754219758253774289438325563366858415612472561538055611407686835763905840681914888
                     India rural pop 308484334228366042401094440766482841529529583367640437700508756797808840853324886923906638909444894341867347832814791239743382
                     % urban         17    17.6   17.9   18.8   19.8   21.3   23.1   24.3   25.5   26.6   27.7   28.7   30.1   31.9   34.3   37.2   40.6   44.2      47.8   51.5   55.2
                     % rural         83    82.4   82.1   81.2   80.2   78.7   76.9   75.7   74.5   73.4   72.3   71.3   69.9   68.1   65.7   62.8   59.4   55.8      52.2   48.5   44.8
                                          Annual Rate of Growth in Urban and Rural Populations, 1950 to 2005, Projection to 2050
                                                                              India urban (%)                                       India rural (%)

                                         Source: United Nations Population Division, "World Urbanization Prospects: The 2007 Revision, http://esa.un.org/unup/index.asp?panel=3
                                    5



                                    4



                                    3
Annual Growth Rate (%)




                                    2



                                    1



                                    0



                                    -1



                                    -2
                                         1950- 1955- 1960- 1965- 1970- 1975- 1980- 1985- 1990- 1995- 2000- 2005- 2010- 2015- 2020- 2025- 2030- 2035- 2040- 2045-
                                         1955 1960 1965 1970 1975 1980 1985 1990 1995 2000 2005 2010 2015 2020 2025 2030 2035 2040 2045 2050
                         India urban (%) 2.36   2.29    2.98    3.14   3.75    3.89    3.32   3.15    2.88    2.63   2.35    2.39     2.5   2.57      2.6    2.56    2.33    2.13    1.92    1.69
                         India rural (%)  1.6   1.82    1.83    1.89   1.82    1.85    1.94   1.87    1.79    1.55   1.33    1.07    0.77   0.44      0.06   -0.33   -0.61   -0.81   -1.02   -1.25
                                             Population Living in the 3 Largest Cities, 1950 to 2005, Projections to 2030
                                                                 India Mumbai (Bombay)                         India Delhi                      India Kolkata (Calcutta)

                                               Source: United Nations Population Division, "World Urbanization Prospects: The 2007 Revision, http://esa.un.org/unup/index.asp?panel=3

                                   30000



                                   25000



                                   20000
Population (000s)




                                   15000



                                   10000



                                    5000



                                         0
                                                 1950     1955    1960     1965    1970     1975     1980    1985     1990    1995     2000     2005    2010      2015     2020   2025   2030
                    India Mumbai (Bombay)        2857     3432    4060     4854    5811     7082     8658    10341 12308 14111 16086 18202 18978 20072 21946 24051 26385
                    India Delhi                  1369     1782    2283     2845    3531     4426     5558    6769     8206    10092 12441 15053 15926 17015 18669 20484 22498
                    India Kolkata (Calcutta)     4513     5055    5652     6261    6926     7888     9030    9946    10890 11924 13058 14282 14787 15577 17039 18707 20560
                                          Annual Rate of Growth in Urban and Rural Populations, 1950 to 2005, Projection to 2050

                                                                     United Kingdom urban (%)                                    United Kingdom rural (%)

                                           Source: United Nations Population Division, "World Urbanization Prospects: The 2007 Revision, http://esa.un.org/unup/index.asp?panel=3
                                              3

                                              2

                                              1

                                              0
Annual Growth Rate (%)




                                             -1

                                             -2

                                             -3

                                             -4

                                             -5

                                             -6

                                             -7

                                             -8
                                                    1950- 1955- 1960- 1965- 1970- 1975- 1980- 1985- 1990- 1995- 2000- 2005- 2010- 2015- 2020- 2025- 2030- 2035- 2040- 2045-
                                                    1955 1960 1965 1970 1975 1980 1985 1990 1995 2000 2005 2010 2015 2020 2025 2030 2035 2040 2045 2050
                         United Kingdom urban (%)   0.16   0.38   0.58   0.3    1.59   1.27    0.25    0.25   0.32   0.39    0.54    0.51    0.51    0.5    0.47    0.41   0.34    0.29    0.27    0.25
                         United Kingdom rural (%)   0.48   0.7    1.31   1.1   -5.36   -7.21   -1.13   0.15   -0.3   -0.34   -0.24   -0.41   -0.56   -0.7   -0.87    -1    -1.07   -1.11   -1.14   -1.16
                               Urban and Rural Populations and Percents, 1950 to 2005 and Projections to 2050
                                                    United Kingdom urban pop                      United Kingdom rural pop                      % urban                     % rural

                                       Source: United Nations Population Division, "World Urbanization Prospects: The 2007 Revision, http://esa.un.org/unup/index.asp?panel=3

                                   70000                                                                                                                                                     100

                                                                                                                                                                                             90
                                   60000
                                                                                                                                                                                             80

                                   50000                                                                                                                                                     70
Population in 000s




                                                                                                                                                                                                   % of Population
                                                                                                                                                                                             60
                                   40000
                                                                                                                                                                                             50
                                   30000
                                                                                                                                                                                             40


                                   20000                                                                                                                                                     30

                                                                                                                                                                                             20
                                   10000
                                                                                                                                                                                             10

                                         0                                                                                                                                                   0
                                              1950 1955 1960 1965 1970 1975 1980 1985 1990 1995 2000 2005 2010 2015 2020 2025 2030 2035 2040 2045 2050
                     United Kingdom urban pop 39977 40301 41083 42296 42926 46483 49519 50131 50765 51586 52600 54052 55451 56886 58337 59738 60974 62013 62929 63777 64569
                     United Kingdom rural pop 10639 10898 11289 12054 12738 9743 6795 6423 6472 6374 6268 6193 6066 5900 5696 5453 5188 4918 4652 4395 4147
                     % urban                   79    78.7   78.4   77.8   77.1   82.7   87.9   88.6   88.7   89   89.4   89.7   90.1   90.6   91.1   91.6   92.2   92.7   93.1   93.6   94
                     % rural                   21    21.3   21.6   22.2   22.9   17.3   12.1   11.4   11.3   11   10.6   10.3   9.9    9.4    8.9    8.4    7.8    7.3    6.9    6.4    6
                                       Population Living in the 3 Largest Cities, 1950 to 2005, Projections to 2030
                                                       United Kingdom London                    United Kingdom Birmingham                  United Kingdom Manchester

                                        Source: United Nations Population Division, "World Urbanization Prospects: The 2007 Revision, http://esa.un.org/unup/index.asp?panel=3

                                     10000

                                      9000

                                      8000

                                      7000
Population (000s)




                                      6000

                                      5000

                                      4000

                                      3000

                                      2000

                                      1000

                                            0
                                                1950     1955   1960    1965    1970     1975     1980    1985    1990      1995   2000   2005    2010     2015    2020    2025   2030
                    United Kingdom London       8361     8278   8196    7869    7509     7546     7660    7667    7654      7908   8225   8505    8567     8607    8618    8618   8618
                    United Kingdom Birmingham 2229       2283   2338    2357    2370     2365     2357    2330    2301      2291   2285   2283    2285     2291    2303    2315   2323
                    United Kingdom Manchester 2422       2425   2427    2413    2396     2370     2343    2313    2282      2262   2243   2230    2230     2235    2246    2258   2267

								
To top