Global Indicators: Population & Grain Production

This spreadsheet activity focuses on graphing data appropriately and on drawing conclusions from two related datasets. Students will learn to graph related datasets using two vertical axes. Students will draw conclusions based on the individual datasets and on the relationships between the datasets.

The global population data below was adapted from "https://www.infoplease.com/world/population-statistics/total-population-world-decade-1950-2050."

The grain production data below was adapted from "https://www.earth-policy.org/index.php?/indicators/C54" (World Grain Production Per Person, 1950-2012).

Step 1: Watch the video below for assistance with creating your own "Student Worksheet" for this activity (Step 2). Your student worksheet will be submitted in Step 8.

Step 2: Make your own copy of the student worksheet by using this link and by following the process described in Step 1's video.

Step 4: Use this link to download the dataset below as an Excel file. You can use the slideshow in "Step 3" as a reference. If you are having a problem with the download and conversion, you can create a new Google Sheet and enter the data below.

Step 5: Use this instructional video for graphing the datasets.

Step 6: Complete your student worksheet. Don't forget to insert your graph in the appropriate spot on the worksheet.

Step 8: Student Worksheet Submission - Submit your completed student worksheet using the "Submission Link" beneath the information for the correct instructor/class/school (below). Be sure to share the Google Document with your instructor!