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).

Google Maps

Your Google map should be completed today!! Nine days - less than 550 miles apart!! (Sample Map)

Create a document that lists the 15 states and 8 state capitols you visited. (You can change your map if you didn't visit enough state capitols or states.)

15 states:

1. 
   
2. 
   
3. 
   
4. 
   
5. 
   
6. 
   
7. 
   
8. 
   
9. 
   
10. 
    
11. 
    
12. 
    
13. 
    
14. 
    
15. 
    

8 State Capitols:

1. 
   
2. 
   
3. 
   
4. 
   
5. 
   
6. 
   
7. 
   
8. 
   

Starting Point: (west coast city)
Day 1:
Day 2:
Day 3:
Day 4:
Day 5:
Day 6:
Day 7:
Day 8:
Day 9: Washington D.C.

Goodbye Brooke

A Virtual Road Rally

Students choose a specific starting point on the West coast of the United States and travel to Washington D.C. in 9 days.

Road Rally Parameters:

• 550 miles per day is the maximum number of miles you can go.
• Students are required to visit:
• 15 states
• 8 state capitols
• 4 national parks
• 2 major mountain ranges
• 5 museums
• 1 amusement park
• 9 days to get to Washington DC

Travel Details

• Mileage
• Total mileage
• Travel Time
• Population
• Elevation
• Temperature
• States Visited

Assignments:

1. Places to Visit and Map with route marked (MS Word)

2. Travel Details (Mileage, Travel Time, Population, Elevation, etc)

3. Outline of Places to Visit (States, Capitols, National Parks, etc.)

4. Itinerary for the Trip (Day 1 – Day 9)

5. Mileage (Excel)

6. Scrapbook of the Trip (PowerPoint)

7. Newsletter (MS Word)

Step 1

1. Decide what city and state you are going to stay in for the nine days.
2. Create a map, using google maps, mark the eight cities you will spend the night and draw a line connecting the cities. ( Create a route map.) (sample map)

Start Here: Google Maps - log in with your LAUSD/Blogger account

Road Rally Instructions

Vote for Brooke!!

Brooke will be singing two Niel Diamond songs, hopefully she does a good job.

Freshman P.E. Reqirements

Can you pass??

Boys:

• 24-45 sit-ups
• 14-30 push-ups
• 9 1/2 minute run or under

Girls:

• 18-32 sit-ups
• 7-15 push-ups
• 11 minute mile run or under

Use your P.E. class time wisely!! These maybe the requirements for you when enter High School. If you can't pass these your freshman year you may end up taking PE for four years instead of only two.

http://abclocal.go.com/kabc/story?section=news/state&id=6104460