(Computer Applications) Excel and Docs in Tandem (May 1, 2013)

Part 1. Find and upload your packers schedule file you made yesterday, upload it to your Google docs.
TURN FILE CONVERSION ON
We'll use this to learn some ways to use the programs in tandem.

Part 2. Make a Google form

Field 1: Day

Field 1: Actual High Temp

Field 2: Average High Temp

Field 3: Actual Low Temp

Field 4: Average Low Temp

Fill out the form 30 times for the 30 days of April using the data found here: Fond du Lac April Weather Data

Open the spreadsheet associated with this form, and create formulas to calcualate:
Average high temps, low temps through April
Difference between each day's high temp, and average high temp
A function that counts the number of days the temp went above 50

Download as an Excel spreadsheet, call it: LASTNAME April FDL Temps
Upload here