Tech Lit: 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:

2014/2015 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 (18 total events). SKIP THE NOVEMBER EVENT.
3. Beginning in A2, enter the date for the storm. If the storm is multiple days, just use the day the storm ended.
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.