week five

LECTURE

Intro to Excel. Worksheets and spreadsheets. Importing web data. Sorting. Formatting.
Creating a budget in Excel. Basic calculations. Basic functions.
Creating charts.

LAB

cities

• quality of life


• richest by earnings


• most expensive




• delete everything besides 2009 rank and cities.


• Format table.


• create charts.





• swine flu data




• delete columns: ID. Deaths by million.Infection rate.


• Format table


• sort countries by number of deaths.


• create separate charts (for first ten).






• budget(advanced)






• time management. introduction to pie charts.

----------------

nutritional

[goalseek]

• Use a calculator to determine protein needs.
  
  


• Use calculator one or calculator two to determine calorie needs.
  
  


• Use a calculator to determine fat needs.
  


• Use nutritional data to calculate protein and calories for sample meals.
  


• Divide your meals in a week.
  


• Calculate daily protein and calories.





project

(dinner party. re-modelling.decorating.)