Science: Ms.Mihalek Owl Pellet Biomass Analysis
Name
Period # Date
Formula Facts

% of Diet

This number is the frequency of the animal remains found divided by the total remains found.

Example: Vole: 28 remains found of a total of 49 remains. (28/49 = 57%)

Formula: =C8/C15

*******************************

Biomass Units

This number is the frequency of the animal remains found multiplied by the conversion factor.

Example: Vole: 28 remains found times conversion factor of 2.0. (28*2.0=56)

Formula: =B8*D8


*******************************

% of Biomass

This number is the biomass units for the remains of one prey divided by the total biomass units.

Example: Vole: 56 biomass units divided by a total of 109 biomass units. (56/109=51%)

Formula: =E8/E15
Prey Frequency % of Diet Conversion Factor Biomass Units % of Biomass
           
Vole 28 57% 2.00 56 51%
Mouse 6 12% 1.00 6 6%
Mole 1 2% 2.75 3 3%
Shrew 8 16% 0.25 2 2%
Norway Rat 3 6% 12.00 36 33%
Small Bird 3 6% 2.00 6 6%
           
Totals 49 100% n/a 109 100%
Making Charts

Prey Frequency

Highlight the prey and frequency numbers (A8:B13)
Select Insert-Chart : choose 3D pie
Enter a title, delete legend, show data labels & %


*******************************

Biomass Percentages

Highlight the prey, hold down the apple key and then select and frequency numbers (A8:A13, F8:F13)
Select Insert-Chart : choose 3D pie
Enter a title, delete legend, show data labels & %


What did you like most about the owl pellet dissection? Why?



What did you like most aobut the owl research project? Why?



Why is the information we learned about the owl's prey important?



Why should people value and protect owls?



What was the most important thing you learned from our unit on ecosystems?