Baldwin High School - Lesson Plan Template AWS
Lesson Plan Template Teacher Course/Subject
Carene Talley Business and Technology/Excel Trip Cost Estimator Tutorial
Standard
BMA-BT-4: Manage data in spreadsheet software for effective use in a business environment.
Essential Question
How do I create a single use spreadsheet, format it and make a useful final product?
Learning Goal(s) I-Can
Anything that needs to be decided mathematically can be made into a single use spreadsheet by planning the information needed, how the calculation is figured, creating a spreadsheet, writing the equation and designing the final product.
Textbook Connection/ Materials Warm-Up
Opening
http://www.internet4classrooms.com/single_use_ss.htm Go to freerice.com and feed the hungry for five minutes. Phase 1 - Planning the information needed and how the calculation would be done The following information is needed for this calculation: The number of miles to be traveled The number of miles that the vehicle will travel on one gallon of gas (mpg) The average cost of a gallon of gas (rounded to the nearest penny) The calculation also involves multiple steps Determine the number of gallons of gas to be used Number of miles divided by miles per gallon gives the number of gallons of gas needed Determine the cost of the gasoline needed for the trip Number of gallons of gas needed times the cost per gallon gives the cost of the trip.
Work Session
Phase 2 - Creating the spreadsheet and writing the equation Step 1 - Open an Excel spreadsheet. Step 2 - Type basic information onto the sheet Step 3 - Determine what the equation should be. Step 4 - Enter equation. Step 5 - Save work as tripestimator (yourname) Step 6 - Enter data for another trip, use a different number of miles and miles per gallon.
Activity/Mini-Lesson
n/a
Phase 3 - Designing the look of the final product
Closing
Step 1- Use the Merge & Center button on the cells in column B that contained text. Step 2 - Remove the grid lines and cover up the lines. Then make the sheet a solid color and insert a picture. Save work. Step 3 - Color the sheet, draw a border and highlight cells with data entered. Step 4 – Find appropriate clip art for sheet and save work. Share with teacher.
Exit Ticket
Student will write down three things that they learned how to do today and write down three things they need help on.
Literacy Standard (reading and writing across curriculum) Assessment
Tutorial Checklist
Assignment
n/a
Differentiation
Provide choices on paper, Promethean board, and audio. Give students individual instruction; peer tutoring
Accommodations
Review instructions. Have students restate instructions. Offer extra help in creating spreadsheet.
Anything that needs to be decided mathematically can be made into a single use spreadsheet. There were three phases in creating the spreadsheet you see above: 1. Planning the information needed and how the calculation would be done 2. Creating the spreadsheet and writing the equation 3. Designing the look of the final product Phase 1 - Planning the information needed and how the calculation would be done The following information is needed for this calculation
The number of miles to be traveled
The number of miles that the vehicle will travel on one gallon of gas (mpg)
The average cost of a gallon of gas (rounded to the nearest penny) o The calculation also involves multiple steps
Determine the number of gallons of gas to be used o
Number of miles divided by miles per gallon gives the number of gallons of gas needed Determine the cost of the gasoline needed for the trip
o
Number of gallons of gas needed times the cost per gallon gives the cost of the trip.
Susan Brooks and Bill Byles. Single Use Spreadsheets.Internets4Classrooms..http://www.internet4classrooms.com/single_use_ss.htm.
Phase 2 - Creating the spreadsheet and writing the equation Step 1 - Open an Excel workbook Step 2 - Type basic information onto the sheet
In cell B2 type Trip Cost Estimator
In cell B4 type Type the number of miles (round trip) you will travel
In cell D6 type a number of miles
In cell E6 type the word miles
In cell B8 type How many miles per gallon does your vehicle usually get?
In cell D10 type a number of miles per gallon
In cell B12 type How much does a gallon of gasoline cost?
In cell D14 type the typical cost of a gallon of gas
In cell B16 type The cost of your trip will be:
In cell D18 you will enter an equation
Step 3 - Determine what the equation should be. First, the number of miles (in cell D6) should be divided by the number of miles per gallon (in cell D10). Then that number of gallons is to be multiplied by the cost of a gallon of gas (in cell D14). The above statement is typed into cell D18 as: =(D6/D10)*D14 Step 4 - As soon as the equation is entered into D18, the cost of the trip is calculated. Step 5 - Save your work as Trip Estimator (your name), example: tripestimatorjjsmith. Step 6 - Enter data for another trip, use a different number of miles and miles per gallon. Phase 3 - Designing the look of the final product Step 1 - While you can still see the gridlines, use the Merge & Center button on the cells in column B which contained text. Step 2 - Next, Remove the grid lines. Cover up the lines.
Select All on the worksheet you are using - PC depress Ctrl key and tap the A key, Mac depress Command key (Apple) and tap the A key
Susan Brooks and Bill Byles. Single Use Spreadsheets.Internets4Classrooms..http://www.internet4classrooms.com/single_use_ss.htm.
Use the Fill Color button to make the sheet a solid color. White is used here.
Step 3 - Use the Fill Color button to draw the red border, and to highlight the cells where data will be entered. Step 4 - Use the Borders button to place a dark black line around the cells where data will be entered. Step 5 - Find a clip art image to match the topic of your single use spreadsheet. Don’t forget to complete your checklist.
Susan Brooks and Bill Byles. Single Use Spreadsheets.Internets4Classrooms..http://www.internet4classrooms.com/single_use_ss.htm.
Name:_______________________________________________________
TRIP COST ESTIMATOR CHECKLIST
STEPS Planning
Creating the Spreadsheet
Writing the Equation
Designing the Look of the Final Product
INSTRUCTIONS COMPLETED Number of miles to be travelled Number of miles that the vehicle will travel on one gallon of gas (mpg) Average cost of a gallon of gas (rounded to the nearest penny) Number of gallons of gas needed (total miles/mpg) Cost of gas needed for trip (number of gallons needed*cost per gallon) Do you understand the planning needed? yes/no. If no, why not? Ask peers and/or teacher. Do you understand the calculations? yes/no. If no, why not? Ask peers and/or teacher. Open an MS Excel spreadsheet (workbook). In cell B2 type Trip Cost Estimator In cell B4 type Type the number of miles (round trip) you will travel In cell D6 type a number of miles In cell E6 type the word miles In cell B8 type How many miles per gallon does your vehicle usually get? In cell D10 type a number of miles per gallon In cell B12 type How much does a gallon of gasoline cost? In cell D14 type the typical cost of a gallon of gas In cell B16 type The cost of your trip will be: In cell D18 you will enter this equation: =(D6/D10)*D14 Enter your data and check your calculations to make sure you have entered everything correctly. Save your work as tripestimatoryourname Do you understand why you entered this equation? yes/no. If no, why not? Ask peers and/or teacher. Use Merge & Center button on the cells in column B that contained text. Remove the grid lines/cover up the lines. Select All on the worksheet. If you are using a PC, depress Ctrl key and tap the A key; if you are you using a Mac, depress Command key and tap the A key. Use the Fill Color button to make the sheet a solid color. White is used in the example. Use the Fill Color button to draw the red border and to highlight the cells where the data will be entered.
Use the Borders button to place a dark, black, around the cells where data will be entered. Find a clip art image to match the topic of your spreadsheet and size it to fit on the lower right hand corner of the sheet. Save your work. Do you understand about the formatting of this spreadsheet? yes/no. If no, ask your peers and/or teacher. GOOD JOB!
Carene Talley Business and Technology/Excel Trip Cost Estimator Tutorial
Standard
BMA-BT-4: Manage data in spreadsheet software for effective use in a business environment.
Essential Question
How do I create a single use spreadsheet, format it and make a useful final product?
Learning Goal(s) I-Can
Anything that needs to be decided mathematically can be made into a single use spreadsheet by planning the information needed, how the calculation is figured, creating a spreadsheet, writing the equation and designing the final product.
Textbook Connection/ Materials Warm-Up
Opening
http://www.internet4classrooms.com/single_use_ss.htm Go to freerice.com and feed the hungry for five minutes. Phase 1 - Planning the information needed and how the calculation would be done The following information is needed for this calculation: The number of miles to be traveled The number of miles that the vehicle will travel on one gallon of gas (mpg) The average cost of a gallon of gas (rounded to the nearest penny) The calculation also involves multiple steps Determine the number of gallons of gas to be used Number of miles divided by miles per gallon gives the number of gallons of gas needed Determine the cost of the gasoline needed for the trip Number of gallons of gas needed times the cost per gallon gives the cost of the trip.
Work Session
Phase 2 - Creating the spreadsheet and writing the equation Step 1 - Open an Excel spreadsheet. Step 2 - Type basic information onto the sheet Step 3 - Determine what the equation should be. Step 4 - Enter equation. Step 5 - Save work as tripestimator (yourname) Step 6 - Enter data for another trip, use a different number of miles and miles per gallon.
Activity/Mini-Lesson
n/a
Phase 3 - Designing the look of the final product
Closing
Step 1- Use the Merge & Center button on the cells in column B that contained text. Step 2 - Remove the grid lines and cover up the lines. Then make the sheet a solid color and insert a picture. Save work. Step 3 - Color the sheet, draw a border and highlight cells with data entered. Step 4 – Find appropriate clip art for sheet and save work. Share with teacher.
Exit Ticket
Student will write down three things that they learned how to do today and write down three things they need help on.
Literacy Standard (reading and writing across curriculum) Assessment
Tutorial Checklist
Assignment
n/a
Differentiation
Provide choices on paper, Promethean board, and audio. Give students individual instruction; peer tutoring
Accommodations
Review instructions. Have students restate instructions. Offer extra help in creating spreadsheet.
Anything that needs to be decided mathematically can be made into a single use spreadsheet. There were three phases in creating the spreadsheet you see above: 1. Planning the information needed and how the calculation would be done 2. Creating the spreadsheet and writing the equation 3. Designing the look of the final product Phase 1 - Planning the information needed and how the calculation would be done The following information is needed for this calculation
The number of miles to be traveled
The number of miles that the vehicle will travel on one gallon of gas (mpg)
The average cost of a gallon of gas (rounded to the nearest penny) o The calculation also involves multiple steps
Determine the number of gallons of gas to be used o
Number of miles divided by miles per gallon gives the number of gallons of gas needed Determine the cost of the gasoline needed for the trip
o
Number of gallons of gas needed times the cost per gallon gives the cost of the trip.
Susan Brooks and Bill Byles. Single Use Spreadsheets.Internets4Classrooms..http://www.internet4classrooms.com/single_use_ss.htm.
Phase 2 - Creating the spreadsheet and writing the equation Step 1 - Open an Excel workbook Step 2 - Type basic information onto the sheet
In cell B2 type Trip Cost Estimator
In cell B4 type Type the number of miles (round trip) you will travel
In cell D6 type a number of miles
In cell E6 type the word miles
In cell B8 type How many miles per gallon does your vehicle usually get?
In cell D10 type a number of miles per gallon
In cell B12 type How much does a gallon of gasoline cost?
In cell D14 type the typical cost of a gallon of gas
In cell B16 type The cost of your trip will be:
In cell D18 you will enter an equation
Step 3 - Determine what the equation should be. First, the number of miles (in cell D6) should be divided by the number of miles per gallon (in cell D10). Then that number of gallons is to be multiplied by the cost of a gallon of gas (in cell D14). The above statement is typed into cell D18 as: =(D6/D10)*D14 Step 4 - As soon as the equation is entered into D18, the cost of the trip is calculated. Step 5 - Save your work as Trip Estimator (your name), example: tripestimatorjjsmith. Step 6 - Enter data for another trip, use a different number of miles and miles per gallon. Phase 3 - Designing the look of the final product Step 1 - While you can still see the gridlines, use the Merge & Center button on the cells in column B which contained text. Step 2 - Next, Remove the grid lines. Cover up the lines.
Select All on the worksheet you are using - PC depress Ctrl key and tap the A key, Mac depress Command key (Apple) and tap the A key
Susan Brooks and Bill Byles. Single Use Spreadsheets.Internets4Classrooms..http://www.internet4classrooms.com/single_use_ss.htm.
Use the Fill Color button to make the sheet a solid color. White is used here.
Step 3 - Use the Fill Color button to draw the red border, and to highlight the cells where data will be entered. Step 4 - Use the Borders button to place a dark black line around the cells where data will be entered. Step 5 - Find a clip art image to match the topic of your single use spreadsheet. Don’t forget to complete your checklist.
Susan Brooks and Bill Byles. Single Use Spreadsheets.Internets4Classrooms..http://www.internet4classrooms.com/single_use_ss.htm.
Name:_______________________________________________________
TRIP COST ESTIMATOR CHECKLIST
STEPS Planning
Creating the Spreadsheet
Writing the Equation
Designing the Look of the Final Product
INSTRUCTIONS COMPLETED Number of miles to be travelled Number of miles that the vehicle will travel on one gallon of gas (mpg) Average cost of a gallon of gas (rounded to the nearest penny) Number of gallons of gas needed (total miles/mpg) Cost of gas needed for trip (number of gallons needed*cost per gallon) Do you understand the planning needed? yes/no. If no, why not? Ask peers and/or teacher. Do you understand the calculations? yes/no. If no, why not? Ask peers and/or teacher. Open an MS Excel spreadsheet (workbook). In cell B2 type Trip Cost Estimator In cell B4 type Type the number of miles (round trip) you will travel In cell D6 type a number of miles In cell E6 type the word miles In cell B8 type How many miles per gallon does your vehicle usually get? In cell D10 type a number of miles per gallon In cell B12 type How much does a gallon of gasoline cost? In cell D14 type the typical cost of a gallon of gas In cell B16 type The cost of your trip will be: In cell D18 you will enter this equation: =(D6/D10)*D14 Enter your data and check your calculations to make sure you have entered everything correctly. Save your work as tripestimatoryourname Do you understand why you entered this equation? yes/no. If no, why not? Ask peers and/or teacher. Use Merge & Center button on the cells in column B that contained text. Remove the grid lines/cover up the lines. Select All on the worksheet. If you are using a PC, depress Ctrl key and tap the A key; if you are you using a Mac, depress Command key and tap the A key. Use the Fill Color button to make the sheet a solid color. White is used in the example. Use the Fill Color button to draw the red border and to highlight the cells where the data will be entered.
Use the Borders button to place a dark, black, around the cells where data will be entered. Find a clip art image to match the topic of your spreadsheet and size it to fit on the lower right hand corner of the sheet. Save your work. Do you understand about the formatting of this spreadsheet? yes/no. If no, ask your peers and/or teacher. GOOD JOB!
