Grade 9 Geography GCG1D1-Lester B Pearson HS



Grade 9 Geography GCG1D1-Lester B Pearson HS

POPULATION PYRAMIDS

Building and Analyzing Pyramids using Microsoft Excel Spreadsheet

Steps.

1. Find the Excel data table supplied on Mrs. Howell or Mrs Peterson’s website, that provides the data for the City of Burlington and the other communities in the North.

2. For the City of Burlington, enter the Male data in Column B as NEGATIVE numbers. Put the title Male in Cell B1 and start by entering the YOUNGEST AGE GROUP (e.g., Age 0-4) in Cell B2 working down the column entering the next youngest group in Cell B3, and so on.

3. Repeat the action for the Female data but enter it as POSITIVE numbers in

Column C.

4. In Column A, enter the corresponding AGE GROUP labels or numbers. You

may have to format some of the cells due to Excel Date formatting. Right click

on a cell defaulted to have a date. Left-click Format Cells, select

Number and from the Category drop down menu select Text. You will have to

re-enter the Age Group for that cell

Your data should look somewhat like this. Note: numbers are fictitious.

|Age Groups |Male |Female |

|0-4 |-0.5 |0.5 |

|5-9 |-0.7 |0.7 |

|10-14 |-1.1 |1.2 |

|15-19 |-1.6 |1.5 |

5. Select all the data including the titles by holding down the LEFT CLICK on the

mouse starting in Cell b1 and dragging the mouse to the last cell in Column C

so that all the data are highlighted. DO NOT select the Age Group

information.

6. Under INSERT on the Menu Bar, select CHART

7. In the menu, STANDARD TYPE, select BAR

8. From the six pictures of bar charts on the right (listed as Chart sub-type),

select CLUSTERED BAR (It should be the first one, and it should be already

highlighted. If it is not highlighted, click on it). Click NEXT.

9. In the Data Range picture, it should show that the Age Groups will be put on

the y-axis. Likewise, in the Data Range box, it should show that you have

selected data from A1 to C_ written as $A$1:$C$_ Click NEXT.

10. Click NEXT and Click FINISH. You should have created a bar chart on the

same sheet as your data. You are not done because you have to tell Excel

how to build the pyramid.

11. Click on a Vertical Axis of the bar chart, and using the Right Click button on

the mouse, select CHART OPTIONS from the drop down menu

12. Under GRIDLINES, turn OFF the MAJOR and MINOR GRIDLINES by

clearing any checkmarks in the four boxes shown.

13. In the bar chart, left click on one of the bars in the male section of the chart.

Note: you must click on the bar. All the male bars should be highlighted.

14. RIGHT CLICK and select OPTIONS from the Menu Bar

15. In the OVERLAP BOX, set Overlap to 100 and inn the GAP WIDTH BOX, set

Gap Width to 0. This will eliminate the negative numbers for Males.

16. RIGHT CLICK to select the numbers along the bottom of your chart and

select FORMAT AXIS from the menu. Select Number from the Menu Chart

and select CUSTOM in the Category list. Select 0.00 and go OK

17. Congratulations, you have built a pyramid.

18. OPTION FOR THE MOMENT You can customize it by adding a TITLE by

selecting the vertical axis on the full chart, RIGHT CLICK and select CHART

OPTIONS. ******Make sure your title provides all the important details (ie province name, date of data)******

19. Print out your graph and write down your name on the bottom right corner. Now you are ready to choose 1 community in Northern Canada to compare it to the City of Burlington. Follow the same steps above as you did for the population pyramid graph for Burlington.

Task 2: Questions About the Population Pyramids

1. Which age grouping do you fall in to? Which sex grouping are you in?

|Questions |City of Burlington |Northern Community: |

|2. Which age and sex group represents the largest | | |

|portion of Burlington’s population and the | | |

|population of the northern community you have | | |

|chosen? | | |

|3.a) Which sex group is the largest for the two | | |

|communities? | | |

|b) Why do you think this is so? | | |

| | | |

| | | |

|4. a) What is the total number of citizens in the | | |

|two communities under the age of 18? | | |

|b) What might this suggest? | | |

| | | |

| | | |

|5. What is the total number of citizens in the | | |

|communities that are over the age of 65? | | |

|b) What might this suggest? | | |

| | | |

| | | |

| | | |

|6. Based on this shape of the graphs, how would you | | |

|categorize populations of these two communities? | | |

|7. What predictions can you make about the future | | |

|needs of this population in 10 years for health | | |

|care, education, and housing? | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

-----------------------

[pic]

Flag of Nunavut

[pic]

Flag of North West Territories

[pic]

Flag of the City of Burlington

Your Task One:

You will be building 2 population pyramids to compare our City of Burlington’s population with that of a population in Nunavut or the North West Territories.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download