http://serc.carleton.edu/sp/ssac_home/general/examples/14323.html
Robert S. Cole, Spreadsheets Across the Curruculum; Washington Center; Science Education Resource Center (SERC)
Activity takes about a one-hour class period with subsequent homework or computer time.
Discuss this Resource»Learn more about Teaching Climate Literacy and Energy Awareness»
Topics
Grade Level
Regional Focus
Climate Literacy
About Teaching Climate Literacy
Other materials addressing GPd
Other materials addressing 2d
Other materials addressing Cli
Other materials addressing 3e
Other materials addressing Our
Excellence in Environmental Education Guidelines
Other materials addressing:
G) Drawing conclusions and developing explanations.
Other materials addressing:
B) Designing investigations.
Other materials addressing:
E) Organizing information.
Other materials addressing:
A) Processes that shape the Earth.
Other materials addressing:
B) Changes in matter.
Other materials addressing:
D) Flow of matter and energy.
Other materials addressing:
D) Technology.
Benchmarks for Science Literacy
Learn more about the Benchmarks
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
- If this activity is being done for the first time, it will serve as a baseline for future, follow-up projects by other students.
- This module is best used when data on a given set of trees are available from prior years, but establishing a solid baseline is important for all scientific measurements.
- Assuming that data from field measurements are available to students, this module could be used as a homework exercise, or as a lab exercise. The module is also useful in teaching about how ecologists and biologists use allometric relationships as well as teaching about the power function.
- An instructor version of the PowerPoint, with the cell equations for the embedded spreadsheets, is available upon request: http://www.evergreen.edu/washcenter/modules/request.asp?m=SSAC2006.QC879.8.RC1.1
About the Science
- The resource guides students through the process of estimating tree biomass from measurements of tree diameter at breast height and the use of the allometric relationship between growth and size of one portion of a tree and the growth and size of the whole tree.
- Instructor can assign this as is (using the example data set to teach the process) or can add enrichment, including a campus tree survey in collaboration with groundskeeping.
- Opportunity to stress the global seasonal flux of CO2 due to plants in the Northern Hemisphere absorbing CO2 from the atmosphere through photosynthesis in the spring and summer and releasing carbon through decay into the atmosphere in the fall and winter.
- Passed initial science review - expert science review pending.
About the Pedagogy
- This module consists of a PowerPoint presentation with background materials and instructions on how to recreate the embedded images of spreadsheets. The students develop the needed cell formulas and complete the spreadsheet to estimate the amount of carbon stored in the tree's biomass.
- Students build quantitative skills and skills working with Excel spreadsheets.
- Manipulating spreadsheet models may be engaging for some students.
- If the instructor chooses to do a tree inventory on campus, students may be more engaged in the activity, as it is more applicable to their lives.
- Little teacher support, other than guidance, is required for this exercise.
- This resource engages students in using scientific data.
See other data-rich activities
Have you used these materials with your students? Do you have insights to share with other educators about their use? Please share with the community by adding a comment below.
Please use this space only for discussion about teaching with these particular materials.
For more general discussion about teaching climate literacy please use our general discussion boards.
To report a problem or direct a comment to the CLEAN project team please use our feedback form (or the
feedback link at the bottom of every page).
Off-topic posts will be deleted.








