 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
Part II  Enter Data for FIRST Six Receipts  Enter data until you have six rows filled (six records).
 Enter the first 6 receipts
 Tip: Leave "Gas Total" and "Mileage" blank. (Delete anything in there.)
 Please raise your hand to show your teacher.
Part III  Format and Use Formulas
Part IV  Enter Data for Last 6 Receipts Part V  Totals and Averages
Part VI  Analyze the Results
 What was the average gas mileage?
 Were there any trends in gas mileage? If so, what was the trend?
 How did unit price change? Was it a continuous change?
 What would improve gas mileage?
 https://www.youtube.com/watch?v=4zWXwqqqHm0
 Estimate the amount of gasoline used in one full year.
 About how many gallons of gasoline was the typical fill up?
 How often was the car filled with gasoline?
 Does it look like there were receipts missing? If so, what would be the approximate dates of those receipts?
 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
 Create a new SHEET in your spreadsheet.
 Include ALL the same columns from your first sheet (ex. Receipt, Date, Store, etc.)
 Enter the following receipts onto this new sheet: Gasoline Receipts 2013.
 Calculate the MPG and the COST of the fill up for each receipt.
 Averages: Calculate the averages for all the columns.
 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  On the spreadsheet, under the averages and totals, answer the following:
 What was the average gas mileage?
 Were there any trends in gas mileage? If so, what was the trend?
 How did unit price change? Was it a continuous change?
 Estimate the amount of gasoline used in one full year.
 About how many gallons of gasoline was the typical fill up?
 How often was the car filled with gasoline?
 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  Create a new sheet. Hint: Press the + sign at the lower left.Rename the new sheet "Cars"
 On your spreadsheet, make columns for the following: Year, Make, Model, City MPG, Highway MPG, Tank Size.
 Search the Internet to find out the fuel economy of the car you travel in most at FuelEconomy.gov.
 Enter the information from your car onto your spreadsheet.
 Search for any other car you like. Add the same information to your sheet.
 Using Google Maps, determine how many miles from your home to school. Enter than on your spreadsheet.
 Calculate how many miles to drive to and from school for an entire school year (180 days).
 Determine how much this would cost in gasoline for each car. Use the US average gas price from GasBuddy.com.
 Submit the spreadsheet.
 File > Download As > Microsoft Excel.Save into your Computers folder.
 In the Campus Portal assignment, attach the file.
 Please raise your hand to show your teacher.
Note: Original here and in HandOut folder:
ORIGINAL Part III  Use Formulas  Tutorial  DropBox or gDrive (switch to HD) or Network Drive  Watch this tutorial as you do the rest! :)
 Use formulas to calculate the following:
 Gas Totals (Price)  How much did it cost for each fill up? (Hint Video)
 Calculate the Gas Mileage  What was the gas mileage (fuel economy) between each fill up? (Hint1, Hint2)
 Totals  Total all the columns. (Hint Video)
 Averages  Average all the columns. (Hint Video)
 Sort by Date: Sort the 12 rows by date. Hint below:
 Select the 12 rows from the left.
 Data > Sort range... (dotdotdot) > (choose the correct column to sort on) > SORT
 Click UNDO if it comes out wrong.
 Format:
 Gas Total column: dollars and cents  Format > Number >
 Mileage column: tenth of a mile
 Averages row: hundreths
 Highlight  Two of the totals do NOT make sense. Highlight those two totals in yellow.
 Additional videos to learn about fuel economy and gas mileage. (Note: Also saved in Handout.)
 Please raise your hand to show your teacher.
