V22.0004 Computers in Principle and Practice
Spring 2007

Assignment # 5 (Excel #1 )

You will be creating a Microsoft Excel Spreadsheet that contains actual data from the NASA weather site reflecting average monthly temperatures recorded at the Central Park Weather station, here in New York City.

For your convenience, the data can be imported from this file. Create the Formulas that you will need to complete all of the information shown in the file below. Be sure to round the results of the calculations to zero places after the decimal.

2. Now publish your spreadsheet on the World Wide Web through your i5 account.

3. Finally, email the grading account for your section to tell us that assignment 5 is ready for grading. The subject of your message should be "Assignment 5" and the body should include both your name and the HTML address in the form: