Is Geography Destiny

  • Go to THE ANNEX@

  • Find your teacher\'s spreadsheet

  • File-> Make a copy -> Rename it

  • Clean up cells so that they only have numbers

  • Delete sheets for other class periods (right-click on tab "carrot")

  • Duplicate you class period\'s sheet 4 times (right-click on tab "carrot")

  • Rename each sheet one of the following: GDP, Infant Mortality, HDI, % Below Poverty Line, Population Density

  • In each sheet, delete all rows that are not the 1st row + the data set in the sheet name (hold control, command, or shift button while clicking to save time)

  • In each sheet, highlight the remaining rows, and click insert -> chart

  • Click on 3 dots at the top right of your chart and select "Move Chart to Own Sheet"

  • Rename the chart sheet "Data Set" Chart (e.g., GDP Chart)

  • Repeat chart creation process for each data set sheet. There will be five altogether.

  • Click on 3 dots in top right of charts to customize each one

This checklist was created by nchslibrary

copy saved

copies saved