Excel Charts - Excel

							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.




                                                                                              .