Biome Climatograms
In this lesson, students will develop a climate diagram (climatogram) from precipitation and temperature datasets. The resulting diagram will be analyzed and compared to a biome map of North America. This activity builds upon skills developed in the "Global Indicators" activity by introducing students to the use of spreadsheet formulas.
In this lesson, students will develop a climate diagram (climatogram) from precipitation and temperature datasets. The resulting diagram will be analyzed and compared to a biome map of North America. This activity builds upon skills developed in the "Global Indicators" activity by introducing students to the use of spreadsheet formulas.
Step 1: Spreadsheet Download
Step 1: Spreadsheet Download
2) Be sure to record where you filed/saved your copy.
2) Be sure to record where you filed/saved your copy.
Step 2: Location Selection - Choose a city in the United States that you would like to make a climatogram for. Go to https://www.usclimatedata.com/ to find average monthly precipitation and temperature data for your city.
Step 2: Location Selection - Choose a city in the United States that you would like to make a climatogram for. Go to https://www.usclimatedata.com/ to find average monthly precipitation and temperature data for your city.
The usclimatedata.com datasets include the average “high” and “low” temperature for each month which will have to be combined using the spreadsheet to determine the average monthly temperature.
The usclimatedata.com datasets may also include snowfall for your city, so a spreadsheet formula will be used to convert snowfall amounts to “rainfall."
Step 3: Making a Climatogram
Step 3: Making a Climatogram
1) Transfer data from the climate site to your Google Sheet.
1) Transfer data from the climate site to your Google Sheet.
2) Use spreadsheet functions to modify your data.
2) Use spreadsheet functions to modify your data.
3) Develop your location's climatogram. Include "TULSA, oK."
3) Develop your location's climatogram. Include "TULSA, oK."
The demonstration video to the right can help with this step.
The demonstration video to the right can help with this step.
The map below from the Environmental Protection Agency will be needed to complete the submission form in "Step 4" The map can be enlarged by clicking on the "Pop-Out" button in the upper, right-hand corner of the map. If you prefer, here is the map's link: original EPA Level I Ecoregions map (select "Level I Ecoregions" then either download the pdf or use the map on the page).
The map below from the Environmental Protection Agency will be needed to complete the submission form in "Step 4" The map can be enlarged by clicking on the "Pop-Out" button in the upper, right-hand corner of the map. If you prefer, here is the map's link: original EPA Level I Ecoregions map (select "Level I Ecoregions" then either download the pdf or use the map on the page).
NA_LEVEL_I.pdfStep 4: Spreadsheet/Climatogram Submission - Use the "Submission Link" beneath the information for your instructor/class/school (below) to open the submission form for this activity. Appropriately respond to all prompts before using the form to submit your completed spreadsheet/climatogram. Be sure to "share" the spreadsheet/climatogram with your instructor!
Step 4: Spreadsheet/Climatogram Submission - Use the "Submission Link" beneath the information for your instructor/class/school (below) to open the submission form for this activity. Appropriately respond to all prompts before using the form to submit your completed spreadsheet/climatogram. Be sure to "share" the spreadsheet/climatogram with your instructor!
Tanner Culbreath
Jenks High School
Environmental Science
Submission Link
Submission Link