# Excel Charts - Excel

Shared by:
Categories
Tags
-
Stats
views:
1
posted:
8/8/2012
language:
pages:
1
Document Sample

```							Excel Charts                              Guest Teacher:                       Mr. Jones
Starting Activity:    So the guest teacher can see how quick you are with Excel
Your chance to earn a buck.
Using Excel find the sum of the integers from 1 to 20
First two students finished get the buck.

State of IL Learning Goal for Early High School 10.A.4a Represent and organize data by creating lists,
charts, tables, frequency distributions, graphs, scatterplots and box-plots.
Objective: Make bar and pie charts from Excel Tables

Matt's Music          You want to make a chart or graph of Matt's music by category:

Category           Count
Classical                5
Rap and Hip Hop         87
Oldies                  42
Jazz                    18
Country                 12

My Car Expenses       You want to examine your monthly expenses with your new car.

Expense                 January
Payment                     225
Gasoline                     45
Insurance                   100
Maintenance                  55

Exit Slip:                                                          Name

1. Make a quick chart of this data. Leave it on the screen so the teacher can see.

Salary
Starting          after 5
Education Level Salary            years
No HS Diploma        20,000          24,000
HS Diploma           23,000          27,600
College degree       32,000          38,400
Masters degree       46,000          55,200
Doctorate            62,000          74,400

2. Why is a pie chart better than a bar chart for showing the categories of car expenses?

3. Explain the type of chart you would use to show hour by hour temperature for 1 day.

.

```
Related docs
Other docs by HC12080905298
THE HEART OF THE MATTER (Don Henley)