Spreadsheets‎ > ‎

Gasoline

  • When will you be learning to drive?
  • How much will it cost to be a driver?
  • For gasoline, how much will it cost?
Use a spreadsheet to learn more.

Part I -- Set Up Spreadsheet
  1. How could you calculate a car's fuel economy?  Click and learn.
  2. Next, create a spreadsheet to analyze gasoline consumption.
  3. Watch and follow along.
  4. Please raise your hand to show your teacher. 

Part II -- Enter Data for FIRST Six Receipts
  1. Enter data until you have six rows filled (six records).
  2. Enter the first 6 receipts
  3. Tip: Leave "Gas Total" and "Mileage" blank. (Delete anything in there.)
  4. Please raise your hand to show your teacher. 

Part III -- Format and Use Formulas
  1. Format and Use Formulas
  2. Please raise your hand to show your teacher. 

 Part IV -- Enter Data for Last 6 Receipts
  1. Enter the data from the rest of the receipts.
  2. Tip: Leave "Gas Total" and "Mileage" blank.  Use formulas to complete those.
  3. Enter the NEXT six receipts (for a total of 12)
  4. Please raise your hand to show your teacher. 

Part V -- Totals and Averages
  1. Totals and Averages
  2. Please raise your hand to show your teacher. 


Part VI -- Analyze the Results

  1. Skip to 2:45 mark:  Video Tutorial: Sorting in a Spreadsheet*
  2. Open the Campus Portal assignment and Upload / Submit your file.
  3. Answer the following questions in Campus Portal.
    1. What was the average gas mileage?
    2. Were there any trends in gas mileage?  If so, what was the trend?
    3. How did unit price change?  Was it a continuous change?
    4. What would improve gas mileage?
      1. https://www.youtube.com/watch?v=4zWXwqqqHm0
    5. Estimate the amount of gasoline used in one full year.
    6. About how many gallons of gasoline was the typical fill up?
    7. How often was the car filled with gasoline?
    8. Does it look like there were receipts missing?  If so, what would be the approximate dates of those receipts?
    9. Estimate the number of miles the car travels in a year.
Please raise your hand to show your teacher. 




Part VII -- Do It Yourself - Data Entry and Computation

  1. Create a new SHEET in your spreadsheet.
  2. Include ALL the same columns from your first sheet (ex. Receipt, Date, Store, etc.)
  3. Enter the following receipts onto this new sheet:  Gasoline Receipts 2013.
  4. Calculate the MPG and the COST of the fill up for each receipt.
  5. Averages:  Calculate the averages for all the columns.
  6. Totals:  Find the totals for all the columns that make sense.
Please raise your hand to show your teacher.

Part VIII -- Do It Yourself - Analysis of Data
  1. On the spreadsheet, under the averages and totals, answer the following:
  2. What was the average gas mileage?
  3. Were there any trends in gas mileage?  If so, what was the trend?
  4. How did unit price change?  Was it a continuous change?
  5. Estimate the amount of gasoline used in one full year.
  6. About how many gallons of gasoline was the typical fill up?
  7. How often was the car filled with gasoline?
  8. Estimate the number of miles the car travels in a year.
Please raise your hand to show your teacher.



Part IX -- Your Car and Your Dream Car
  1. Create a new sheet.  Hint: Press the + sign at the lower left.Rename the new sheet "Cars"
  2. On your spreadsheet, make columns for the following:  Year, Make, Model, City MPG, Highway MPG, Tank Size.
  3. Search the Internet to find out the fuel economy of the car you travel in most at FuelEconomy.gov.
  4. Enter the information from your car onto your spreadsheet.
  5. Search for any other car you like.  Add the same information to your sheet.
  6. Using Google Maps, determine how many miles from your home to school.  Enter than on your spreadsheet.
  7. Calculate how many miles to drive to and from school for an entire school year (180 days).
  8. Determine how much this would cost in gasoline for each car.  Use the US average gas price from GasBuddy.com.
  9. Submit the spreadsheet.
  10. File -> Download As -> Microsoft Excel.Save into your Computers folder.
  11. In the Campus Portal assignment, attach the file.
  12. Please raise your hand to show your teacher. 


Note:  Original here and in HandOut folder:

Google Sheets Video -- Watch this video and follow along.

  1. Tutorial - Totals and Averages: DropBox or gDrive (switch to HD) or Network Drive -- Watch this tutorial as you do the rest! :-)
  2. Highlight -- Two of the totals do NOT make sense.  Highlight those two totals in yellow.
  3. Additional videos to learn about fuel economy and gas mileage.  (Note: Also saved in Handout.)


ORIGINAL Part III -- Use Formulas
  1. Tutorial - DropBox or gDrive (switch to HD) or Network Drive -- Watch this tutorial as you do the rest! :-)
    1. Use formulas to calculate the following:
    2. Gas Totals (Price) -- How much did it cost for each fill up?  (Hint Video)
    3. Calculate the Gas Mileage -- What was the gas mileage (fuel economy) between each fill up?  (Hint1Hint2)
    4. Totals -- Total all the columns. (Hint Video)
    5. Averages -- Average all the columns. (Hint Video)

    6. Sort by Date:  Sort the 12 rows by date.  Hint below:
      1. Select the 12 rows from the left.
      2. Data -> Sort range... (dot-dot-dot) -> (choose the correct column to sort on) -> SORT
      3. Click UNDO if it comes out wrong.
    7. Format:
      1. Gas Total column: dollars and cents  -- Format -> Number ->
      2. Mileage column: tenth of a mile
      3. Averages row: hundreths
  2. Highlight -- Two of the totals do NOT make sense.  Highlight those two totals in yellow.
  3. Additional videos to learn about fuel economy and gas mileage.  (Note: Also saved in Handout.)
  4. Please raise your hand to show your teacher. 
Comments