https://cleanet.org/clean/community/activities/carboncycle_excel.html
Andrea Bixler, Lindsay Dubbs, Dave Finster, Harold Geller, Jeanne Troy, CLEAN Community Collection
The two activities take about 3-4 class periods.
Learn more about Teaching Climate Literacy and Energy Awareness»Grade Level
Topics
Climate Literacy
This Activity builds on the following concepts of Climate Literacy.
Click a topic below for supporting information, teaching ideas, and sample activities.
Energy Literacy
This Activity builds on the following concepts of Energy Literacy.
Click a topic below for supporting information, teaching ideas, and sample activities.
Notes From Our Reviewers
The CLEAN collection is hand-picked and rigorously reviewed for scientific accuracy and classroom effectiveness.
Read what our review team had to say about this resource below or learn more about
how CLEAN reviews teaching materials
Teaching Tips | Science | Pedagogy |
Technical Details
Teaching Tips
- Consider beginning the series of activities with the hands-on ping pong ball activity, which illustrates the carbon cycle reservoirs and fluxes, instead of the lecture-discussion of IPCC diagrams.
- Students may have difficulty interpreting data displayed on the Excel spreadsheets. Additional directions on the Excel worksheets would assist student success.
- The first of the two activities uses the assumption that the tree and major limbs are cylinders and therefore uses the cylinder formula to estimate tree volume. The second activity uses power functions, Excel, and a log-log graph; this second activity is more appropriate for advanced learners.
About the Content
- Science underlying these activities is about carbon sources, sinks, and fluxes among them. The activity transitions nicely from abstract data interpretation of the carbon cycle to personal interactions with the cycle.
- Comments from expert scientist:
Scientific Strengths: The C cycle is an important aspect of climate change and this Excel activity will teach students to think about reservoir sizes, fluxes in and out of said reservoirs, and the impact of anthropogenic actions after they have learned about the natural cycle.
Suggestions: This is older data from 2012, with the investigations reviewed in 2017. The numbers may be inaccurate by now. Also, in worksheet one, it would be beneficial for students to learn where teh values for each reservoir of C is coming from, and what the uncertainty in the value of each reservoir is. Same with fluxes.
About the Pedagogy
- Students work with a spreadsheet to see how changes in one part of the carbon cycle affect others. A link is provided to a pre- and post-test concept map type exercise.
- Excercise steps 1-5 in the directions give a global picture of the carbon cycle, while steps 6-7 bring the story down to a local and/or individual level.
- Progression of activities provides a nice mix of abstract and concrete.
- This resource engages students in using scientific data.
See other data-rich activities