Population of Selected US Cities

and

World Population in Billions

SOLS - C/T 8.1, C/T 8.2, C/T 8.4
SWBAT: Create a spreadsheet, perform a function and create a chart from the data in the charts.
Before Review - Parts of a spreadsheet, who uses a spreadsheet and what is a spreadsheet is used for.
During

  1. Have students open Excel

  2. Have students use the given data to create their own spreadsheet for each of the charts.

  3. Have students create a function that gives the average population on the cities and create a 3d Column Chart.

  4. Have students create a function that gives the average population for the world and create a line chart
 
World Population in Billions
After
  1. What Problems did you have?
  2. How could you use this program in another class?