Welcome to Mr. Porfido's Blog!

Welcome to Mr. Porfido's Blog!

Please bookmark this page and check for updates!



Wood-Ridge Online Store

Monday, March 3, 2014

Web 2.0: Period 7 Only

2013/2014 Snow Storm Totals
CREATE A NEW GOOGLE SPREADSHEET AND NAME IT: SNOW. DRAG THE SPREADSHEET IN YOUR SHARED FOLDER.



  1. Visit this site for you data
  2. Find the nearest location to Wood-Ridge for each snow event (17 completed this year so far)
  3. Beginning in A2, enter the date (s) for the storm 
  4. Beginning in the next column enter the town you received you data from
  5. In the next column, enter the snow total (in inches) for the storm
  6.  Create a function below the last inch amount that totals up the # of inches for all storms
  7.  Below that, create a formula that displays the average snow amount for each storm
  8.  Create 2 different charts that represent each storm and the snow amount.

No comments: