Materials:

Population Data

Resources.

There are many YouTube videos on how to create and interpret charts, including scatter and population pyramids, for you to choose from.

The following links, however, are simple webpages that show the steps using screen shots.

Present your data in a scatter chart or a line chart

How to Build a Population Pyramid in Excel: Step-by-Step Guide

In this section, you will produce a chart of the past and projected populations of three school districts (SD) in British Columbia (Table 1). You will then derive additional data, describe, and compare and contrast the three populations.

1.     Complete Table 1(5) [Calculate the Annual Growth Rate in percentages to one decimal place]

2.     Create an appropriate chart using the data of the total populations against census years of the three school districts from Table 1. Include an appropriate title, legend, and axes (10) [Make the chart half a page in size. You will be graded on the final chart]

3.     Describe, compare and contrast the data series on your chart. Start with the earliest date, and describe the general trends using dates and population data. Also consider the reasons for these trends (10)

Table 1: Burnaby, Coquitlam and Richmond School Districts’ Populations (Census Years 1986 – 2041)

[BC Stats. (2020). British Columbia - Population Projections. https://bcstats.shinyapps.io/popProjApp/ ]

Access BCStats’ British Columbia - Population Projections web page for the data for the following College Regions to complete the following table. (Choose College Region for region type, 2021 for the year, both genders, and 5-year age groups)

Table 2: 2021 male and female populations by 10-year age groups for Kwantlen and Vancouver college regions as percentages of their respective total populations

4.     Complete Table 2 above (5) [Use the percentage of the total population for each age group by gender. Calculate to 1 decimal place]

5.     Create population pyramid(s) using the data from Table 2. Include appropriate title(s), legend(s), and axes (10) [Make the chart(s) half a page in size. You will be graded on the final chart(s)]

6.     Describe, compare and contrast the data in your population pyramid(s) (10)