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:
Rap and Hip Hop 87
My Car Expenses You want to examine your monthly expenses with your new car.
Exit Slip: Name
1. Make a quick chart of this data. Leave it on the screen so the teacher can see.
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.