Students link human behavior in various climate change scenarios to predicted temperature outcomes at both local (their assigned Latitude) and global (Latitudinal trends) scales. This adaptation is intended to be more accessible to non-majors.
Adapted from: Global Temperature Change in the 21st Century (Abstract) | TIEE v 1.0
During this three-hour lab activity, students are introduced to Global Climate Models and how they can be used to predict future climatic changes given various “What if” scenarios of human behavior. Students become familiar with using Excel to create graphs and use simple linear regression as a tool for examining relationships between two variables.
Students use their analyses to address two questions: 1) How will human behavior impact future carbon emissions? and 2) Will temperature changes be similar across Latitudes? The first question is answered by comparing Global Climate Model (GCM)-predicted temperatures for the 21st century from three different Emissions Scenarios that vary with regards to human population growth and other human activities that influence carbon emissions. The second question is answered by comparing temperature changes for 12 different latitudes across North America.
Students work in pairs to analyze temperature changes at a single latitude using simple linear regression in Excel. Students then pool their results as a class into a collaborative Excel file in order to compare predicted temperature change from the Polar Regions to the Equator.
In this adaptation of the original module, students use a reduced dataset that has temperatures converted to Fahrenheit in order to make the exercise more accessible to non-majors and non-traditional students with varying backgrounds in Excel and Science. Student understanding of the material and skills acquisition can be assessed using in-class discussion, writing a lab report, and/or a post-lab quiz.
- FMNTeachingNotes_TBasham_Climate Change 21st Cen.pdf(PDF | 171 KB)
- Instructor_redux_DegF_03182020_ANSWERS.xlsx(XLSX | 52 KB)
- January Regression Results_Collaborative.xlsx(XLSX | 17 KB)
- student_assignment_Adapted.docx(DOCX | 22 KB)
- Student_redux_DegF_03182020.xlsx(XLSX | 43 KB)
- Temperature Change in 21st Cen_Background.pdf(PDF | 569 KB)
- Temperature Change in 21st Cen_Student Instructions.docx(DOCX | 20 KB)
- Temperature Change Quiz.xlsx(XLSX | 10 KB)
- Temperature Changes Quiz_ANSWERS.xlsx(XLSX | 19 KB)
- Temperature Changes Quiz_SP2020.docx(DOCX | 20 KB)
- Temperature Changes Quiz_SP2020_ANSWERS.docx(DOCX | 20 KB)
- Global Temperature Change in the 21st Century (Abstract) | TIEE
This is an FMN participant modification of the TIEE module "Global Temperature Change in the 21st Century," authored by Daniel R. Taub and Gillian S. Graham in 2011.
- License terms
Cite this work
Researchers should cite this work as follows:
- Basham, T. (2020). Global Temperature Change in the 21st Century: An Introduction to Global Climate Models and Graphing in Excel (Adapted for Non-Majors). ESA Data Access - Inclusive Pedagogy, QUBES Educational Resources. doi:10.25334/N3Z3-X514