| Production
Student Worksheet 2: Nutrient Cycling Model |
Preparation
Before you begin this activity, make sure you have read the Background
Information of Unit 2, especially the Food Web section, and
Supporting Material 2 provided by your instructor on nutrient flows
in an ecosystem, the simplified ecosystem nutrient cycle model, and the
three biomes we will use as examples in this simulation. Your instructor
may have also assigned you additional readings on nutrient cycling. All
these will deepen your understanding of this activity.
Purpose of the Activity
In this activity, we will test what happens to three different biomes
when we interfere with nutrient cycling, the mass and energy flows in these
systems. By "we" we mean us, running this computer simulation model, but
if we take a step back from the modeling for a minute, "we" can also stand
for humans more generally who interact with, and thereby affect, nutrient
flows in ecosystems. It is even possible to think of the changes we evoke
in this computer model as examples of what could happen through large environmental
changes whether they are brought about by purely natural processes or through
anthropogenic causes.
Instructions
Download the file NUTCY4.WB1
to your own diskette or the hard drive of your computer by pressing the shift key and clicking the hotlinked file with your left mouse button.
‚ Open the file in Quattro Pro for Windows 5.0® or import it into EXCEL®. The following descriptions are specific to handling a spreadsheet in Quattro Pro for Windows, but spreadsheet software is quite similar across many different brands, and even the differences between PCS and Macs are insubstantial. Your instructor will help you out if you are not using Quattro Pro for Windows.
ƒ Familiarize yourself first with this spreadsheet and the terminology that is commonly used to orient oneself in it: A spreadsheet is simply a computerized table made up of rows (going across) and columns (going down). Both columns (enumerated with the letters of the alphabet from left to right) and rows (enumerated with numbers from the top to the bottom) have headings, names, so one knows what the numbers in the cells mean. When a column and a row intersect, they form a cell. Each cell has a so-called cell address, for example "A3" which means that the cell is located at the intersection of column A and row 3. Most cells (or at least the ones of interest for any calculation) have cell entries, i.e., something written into them. Cell entries can be words, letters, or numbers. Let's relate all these terms to our example here: In the NUTCY4 spreadsheet (sample screen capture), columns represent nutrient storage volumes in each compartment (litter, soil, and biomass), followed by nutrient flow rates between compartments, respectively. The rows contain the numbers (one row for each year) that result from the simulation (see point „ below). Cell A3 in this case has the cell entry "Selva" -- the name of the first biome for which we run the simulation.
„ Before we "run a simulation," let's
understand what that means. With your mouse cursor click on cell C4. This
cell currently has the cell entry "6." If you paid close attention, you
saw another part of the spreadsheet change just as you clicked on that
cell: a grey-shaded area between the tool
bar (the row of little icons) and the column letters. This grey-shaded
area is very helpful because it gives you, on the left, the cell address
(in this case, it says A:C4 because we are on page A of this spreadsheet
in cell C4), and it gives you an in-depth look at the cell entry. You thought
all that was in cell C4 was the entry "6" -- and now look at all that's
in the cell: a whole string of cell addresses, mathematical symbols, and
numbers! In short: a cell
formula. The number 6 is simply the end result of the calculations
prescribed by this cell formula.
The reason why we take the time to look at this cell formula is not
that you should learn how to translate your ideas of what happens in an
ecosystem into mathematical symbols and formulas -- that has already been
done for you. Instead, the purpose is to understand that each number from
row 4 onward is the result of such calculations and that the results from
the calculations for any year enter in a more or less complicated fashion
into the calculations for each following year. If you click on other cells
in row 4 (which contain the results for year 1 of the simulation), you
will find that some cell formulas are rather simple whereas others are
more complicated. Some simply rely on the cell entry above (the beginning
conditions of the nutrient cycle) and thus are readily calculated, while
others rely on cell entries from the row above and from neighboring
cells, i.e., other values for the first simulated year, which can thus
only be calculated after the simple calculations have been completed. The
degree of complication of these cell formulas simply reflects the fact
that ecological relationships are more or less complex. Or in other words,
it demonstrates that the simple measures you can take in the field are
the result of many complex interactions among ecosystem compartments.
We can now see that all calculations ultimately go back to the entries in row 3. Therefore, we say that row 3 controls the rate of transfer between compartments at each annual step in the simulation. A "simulation," then, is just another word for computations of future states of something based on past and present data for that thing (e.g., storage and flows within an ecosystem). "Running a simulation" in a general sense means that you use a model to test what happens to it when you alter the inputs. A simulation allows you to understand the importance of such input change, and it allows you to see how whole systems change over time. In practice, running a simulation for a certain biome in a spreadsheet that comes with all the cell formulas, like NUTCY4, simply means changing the numbers in the row that controls all further calculations -- and that's it! You can page down to the last row and you will see that the simulation is set as a 270-year run (i.e., all calculations are repeated 270 times to get results of storage and flows for 270 years). The outcomes of all years are reported. The embedded graphs (a bar chart and a curve of cumulative changes) show how the nutrient storage changes in the litter, the biomass, and in the soil over the time for which we simulate nutrient flows.
5. So now, let's run a simulation for one of the other biomes. To the right of the simulation columns are examples of flow rates that model nutrient flows in three extreme environments, the selva, steppe, and tundra (followed by various alternative biome models, respectively). Copying these cells into the fields starting with column A, row 3 resets the starting storage for all compartments and the transfer rates between linked compartments.
Again, any change to the values in row 3 will automatically run the model for the newly inserted value(s).
To copy, click with your mouse cursor on one of the cells that contains
the biome name of your choice and hold down the left mouse button as you
move the cursor across the end of that row. This will block out this portion
of the row. Now click on the copy button (or use the Edit menu or a key
combination), click with your cursor on cell A3 and, finally, click on
the Paste button (or use the Edit menu or a key combination). Within a
few seconds, the computer will have recalculated the simulation for 270
years given these new entry values. You will also observe that the embedded
graphs change, since the graphs automatically display whatever values have
been calculated in the simulation.
Here are the steps involved in copying: block -- copy -- move to destination -- paste
† In sequence, copy the fields for selva, steppe, and tundra into the cells starting in A3. You will perform a simulation experiment on each of these biomes in a "natural" state (e.g., selva) and for an alternate scenario of each of these entries (e.g., selva2) with the environmental change described below. As you go along, answer questions about the natural biome as well as the effects of changes on the system. Notice that only in one case will you be asked to actually alter cell entries (selva3). For all others, compartmental storage values and average flow rates for the altered biome are provided. To make better sense of the numbers, inputs of nutrients from rain, weathering rock, fertilizer, and removal of nutrients and biomass (through harvest) can be integers ranging from 0 to 9. The flows between compartments and losses from the system are decimal fractions ranging from 0.00 to 1.00.
Here are the descriptions and questions for each of the biomes and their altered states:
Selva
|
|
Litter |
Soil |
Biomass |
Runoff |
Leach |
Removal |
|
Selva |
|
|
|
|
|
|
|
Selva2 |
|
|
|
|
|
|
|
Selva3 |
|
|
|
|
|
|
|
Steppe |
|
|
|
|
|
|
|
Steppe2 |
|
|
|
|
|
|
|
Steppe3 |
|
|
|
|
|
|
|
Tundra |
|
|
|
|
|
|
|
Tundra2 |
|
|
|
|
|
|
Write a 1-2 page critical summary of the impacts of the human-induced environmental changes you have modeled. Use your notes from the above 8 simulations to write this overall assessment of these impacts.
When you come back to class for the next session, be prepared to present to your class what you found in your simulations, how you would explain them, and what you concluded from these observations about the types of human-induced environmental changes you simulated in this model.