Welcome to Mr. Porfido's Blog!

Welcome to Mr. Porfido's Blog!

Please bookmark this page and check for updates!



Wood-Ridge Online Store

Tuesday, September 23, 2014

Tech Lit Sept 23: Spreadsheet Charts

DO NOW:


  1. Open up your SAMPLE spreadsheet from yesterday's class.
  2. rename it: Cell Phone Providers
  3. Enter the following starting at A2 working down the column and the #'s go in column b:

Sprint
Verizon
AT&T
T-Mobile
Other

   4.  Take a class vote on which providers students use and enter the total #'s in the next column. If you do not have a cell phone, just choose a company you like!
   5. Use a function to add up the # of votes
   6.  Then create a pie chart on the same sheet.
   7. Next create a bar graph on a new sheet.

Make sure you use the same spreadsheet so I can check it.

Project:

2013/2014 Snow Storm Totals

CREATE A NEW SHEET FROM YOUR EXISTING SPREADSHEET. RENAME IT: SNOW

  1. Visit this site for you data
  2. Find the nearest location to Wood-Ridge for each snow event (20 total events)
  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: