Excel Spreadsheet Rupric  
   Your group must have the following:
        1.  An x y scatter plot showing the temperature graph for each of the four conditions.
        2.  The chart must have the axes labeled and a unique symbology for each condition.  ( Example - Line, dotted line, diamonds, circles)
        3.  A linear trend line of one of the lines showing the equation, r-squared value, slope.
        4.  All of this is copied and pasted onto a word document, printed, and turned in with your lab write up.  This is half of the grade.  



Conversion Instructions For Snow Water Equivalent Lab

To convert cm of SWE to gallons on the football field we need to convert the depth we calculated in cm to feet, then convert the area of the football field from yards into feet, multiply those together to get cubic feet of water, and finally convert cubic feet to gallons.  Here are the steps:

1)  Convert SWE average from cm to feet - divide average depth from all groups by 30 it is now in feet; 

2) Convert football field from yards to feet by multiplying each dimension 120 yards long and 50 yards wide by 3 (3 feet in a yard);

3)  Calculate area of football filed multiplying length of field (in feet) by width (in feet); 

4) Convert everything to cubic feet by multiplying depth in feet (calculation from step 1) x  football field area 

5) Convert cubic feet to gallons - Multiply cubic feet by 7.5 gallons/cubic foot to get gallons.  (For example if you had 10 cubic feet it would be 75 gallons)




Will you look just look at it!!