Miles Per Gallon

Excel

Skills: create a table, 2 graphs, 2 pictures, use formulas to multiply and divide

Objective:

1) How many gallons of gas does each car use every day of the trip?

2) How much does the gas cost for each car every day of the trip?

Step:

1) Choose an exotic and normal car.

2) Find the Miles Per Gallon (MPG) on the highway for each car.

3) Create a table with: days, miles, gallons for each car, price of gas, cost of gas for each car as columns. Write the days in the first column. (see sample below)

4) Complete the table. (see step 2 for miles; gallons = miles/mpg; cost of gas = price of gas * gallons) Use formulas to find the number of gallons and the cost of gas, don’t just write the answer.

5) Create a graph that compares how many gallons each car u ses, every day of the trip.

6) Create a graph that compares how much gas cost for each car, every day of the trip.

7) Include Pictures of both cars.

Days	Miles	Gallons Car 1	Gallons Car 2	Price of Gas	Cost of Gas Car 1	Cost of Gas Car 2
1	(see step 2)	gallons = miles/mpg			cost of gas = price of gas*gallons
2
3
4
5
6
7
8
9

Itinerary

You should be creating an itinerary of your daily activities. Be sure to include the places you'll visit in your writings. You can think of the project as a journal of your daily activities.

Places to Visit

National Parks

1. Name, City, State

2. Name, City, State

3. Name, City, State

4. Name, City, State

Major Mountain Ranges

1. Name, State

2. Name, State

Museums

1. Name, City, State

2. Name, City, State

3. Name, City, State

4. Name, City, State

5. Name, City, State

Amusement Park

1. Name, City, State

You can start your itinerary. What is an itinerary? (click here) Create an itinerary for each day of travel. Make sure you include all the places you are going to visit in your itinerary.

State Capitols

Do you know your state capitols? Take the quiz and find out. Post your score in the comments.

State Capitol Quiz

State Capitol Matching Game

Travel Details

You should have your google map completed (route marked), making sure that you pass through at least 15 states and 8 state capitols (they don't need to be one of your days to count).

We will be finding out more details about each city that you will be visiting and verifying that each location is less than 550 miles apart!!

You need to find the following details about each location in a document:

• Miles
• Travel Time
• Total Miles
• Population
• Elevation
• Temperature

Sample Outline

Starting Point: Los Angeles, CA (any West Coast City)

Day 1: Las Vegas, NV (each day will have a different city)

• Miles:
• Travel Time:
• Total Miles:
• Population:
• Elevation:
• Temperature:

Day 2-9 the same details as Day 1.

Day 9: Washington D.C. (everyone will have the same Day 9)

Hints:

1. Use google maps to find the miles (from the day before to the end point) & travel time.
   
2. Use google keyword search to find population, elevation and temperature.
   
3. Total miles refers to how many mile you have traveled the whole trip to that point (hint: add up all the miles you've traveled so far).