Modeling the Complexities of the Carbon Cycle Utilizing Excel
Topic: Modeling the Complexities of the Carbon Cycle Utilizing Excel
Course Type: Introductory level courses in climate science, ecology, environmental science
SummaryIn this set of activities, the instructor introduces the carbon cycle, starting with natural processes and then incorporating anthropogenic ones. Students work with a spreadsheet to see how changes in one part of the cycle affect others. They also estimate the amount of carbon sequestered in trees on their own campus and relate that to their driving habits.
Students should be able to do the following:
- Describe the primary reservoirs of carbon and fluxes between them.
- Compare the rates of fluxes between carbon reservoirs.
- Describe major human impacts on the carbon cycle.
- Develop Excel skills, including entering equations, filling cells, and interpreting the results of computations.
- Compare the magnitude of carbon storage in trees to carbon dioxide produced by human activities.
Pre- and post-test using a tool similar to this one (primarily just the concept-mapping exercise on the second page).
- IPCC diagrams of the carbon cycle (see figures below; click each figure to enlarge)
- Carbon cycle workbook-student activity (Excel 2007 (.xlsx) 32kB May16 12)
- Activity using ping pong balls to simulate the carbon cycle
- Carbon sequestration in campus trees, an activity from the CLEAN collection
- sequestration v driving (Microsoft Word 35kB May16 12)
Assemble the Components
The components of this lesson may be used individually, in the combination presented here, or in smaller sets, depending on the specific goals and time constraints of the instructor.
We anticipate that components 1-5 below could be performed in one or two class periods, with component 6 forming a lab and 7 being an additional part of that lab or a homework assignment. The post-test (component 8) could be given at the end of the lab or in a later class period.
Note that components 1-5 give a global picture of the carbon cycle, and components 6-7 bring the story down to a local (and even individual) level. Both perspectives are important for students.
- Use the concept-mapping exercise as a pre-test.
- Introduce the global carbon cycle using the modified Figure 7.3 from the IPCC report (2007; this figure does not include anthropogenic influences but do not allude to this yet). Emphasize the differences in timescales between the geological processes and the biologically driven processes and the balance between sources and sinks.
- Show IPCC Figure 7.3 for increases in atmospheric CO2 and CH4 concentrations including the human contribution. Go back to the first slide to again emphasize that we are taking carbon from the geological cycle and adding it to the biological cycle. Again emphasize the difference in rates and how long it will take for that biologically-available carbon to return to the geological reservoir.
- The instructor could assess student learning at this point to determine whether additional study of the carbon cycle is needed (in which case, continue here) or students are ready to move on (in which case, progress to component 5). If needed, students could use this activity in which they act out the carbon cycle with pingpong balls to further reinforce reservoirs and fluxes. *It is recommended that the instructor add reservoir cards to this activity to match the carbon cycle being used throughout the lesson.
Using different scenarios, have students use the Excel spreadsheet to explore how changes in flux rates between reservoirs affect the atmospheric reservoir. The scenarios that we chose link well with our other activities that allow students to explore the role of trees on their campus and how their own use of fossil fuels influence the carbon cycle. Other scenarios can be presented. While this spreadsheet currently only addresses direct effects, indirect effects can be introduced using algorithms. The cells in yellow are currently changeable, but the instructor can alter the cells that are presently locked using the password "CLEAN". Changeable cells can be left blank so that the students can learn how to fill in cells and formulate equations (possibly through a jigsaw activity with different groups working through different changes), or they can be filled in by the instructor.
Have students calculate carbon sequestration on their own campus. This website includes detailed directions in a PowerPoint, along with a practice data set (to be used initially or as the entire exercise if it is not possible for students to measure actual trees on campus).
- Students relate the amount of carbon sequestered on campus to the amount of carbon released by their own driving. See this handout sequestration v driving (Microsoft Word 35kB May16 12) for suggestions on how to calculate the latter (although the method for estimating the former is different).
- Use the same concept-mapping exercise again as a post-test.
Carbon Sequestration in Terrestrial Ecosystems (DOE). The FAQ page may be particularly helpful for background.
Blue Carbon (UNEP). An excellent source for incorporating coastal and oceanic processes into carbon cycling.
This handout shows seven different concept maps, each related to carbon but with a slightly different focus.
Another example of a carbon cycle concept map