INTD 216/SOC
Fattahi/Howard
Fall 2003

Take-home Exercise 1, Due: 9/16/03

Team Number ________

Names ________________ ________________ ________________

 

The purpose of this exercise is to make graphical observations of the changes in the world population between 1950 and 2050, and get some sense of how and perhaps why the world population has changed in this particular manner. The reading assignment from chapter 1 should be helpful here.

If you have not already copied the file "Midyear-World (1950-2050)" to your floppy disk (as demonstrated in the class), use the following procedure to do so:

    1. Insert your personal floppy disk in the disk drive.
    2. Select "Chooser" from the Apple Menu. When the dialog box appears, select "Apple Share" from the upper left box, then select "Computer Center Zone" from the lower left box, and then double-click on "Mathematics" on the right box. When a new dialog box appears, click on "Guest", and then on "Connect". Finally click on "OK". You should now note that a new volume icon named "Classes" has appeared on your desktop. You may close the "Chooser" at this time.
    3. Double-click on "Classes", then on "Abi", and finally on "SMC".
    4. Now copy the file "Midyear-World (1950-2050) to your own floppy disk by dragging that file onto the icon of your floppy disk.
    5. When the copying process is completed, drag the "classes" icon into the "Trash".

Open the data file "Midyear-World (1950-2050)" on your floppy by double-clicking on it, and do the following:

    1. Have Excel show the population in units of one million (so the population for 1950 would show as 2,555 instead of 2,555,360,972; same for other years.) These numbers should appear in the third column with an appropriate header.
    2. Using the data from the 3rd column, have Excel draw an Area Chart of the world population between 1950 and 2050. Include a descriptive title and mark the axes and units of measurement clearly.
    3. Have Excel determine the annual changes in the population between 1951 and 2050 and put the results in the fourth column labeled "Change". Note that the change for each year is obtained by subtracting the population of the previous year from the population of that year.
    4. Have Excel draw a Column Chart of the changes in world population between 1951 and 2050 with a descriptive title and the axes clearly marked.
    5. Have Excel determine the annual Percent Changes in the world population between 1951 and 2050 and put the results in the fifth column labeled
      "% Change".
    6. Have Excel draw a Line Chart of the Percent Change in the world population between 1951 and 2050 with a descriptive title and the axes clearly marked.

 

Now write a one-page essay about what you have learned about the world population from this activity in conjunction with what you learned in reading chapter one of the main Text. Remember that the population figures for 1999 – 2050 are projections made by the US Census Bureau, and are estimates. Your analysis should include explanations as to what the three graphs would have looked like if the world population were growing in strictly linear or exponential fashion. You should also try to explain some of the reasons for the changes in world population as it relates to the known world events.