Systems Biology – Lesson 8

Our exploration of the Tyee Campus ecosystem concluded with a return to modeling energy flow using Microsoft Excel 2013.  Students worked individually to construct an energy flow model using a worksheet which provided the calorie requirements of a variety of organisms found on our campus.  The worksheet also included the Excel formulas to connect the various pieces of data into a model.  The lesson provided students with an opportunity to practice using the formula functions in Excel, taught them how to create a linked graph of the data, and asked them to derive explanations about why organisms are found in numbers approximating what might be anticipated by their understanding of the trophic pyramid.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s