LESSON PLAN: LET'S GO SHOPPING!
Identification: Excel Spreadsheet
Sara Hough, January 28, 2001
- Student Objectives:
Students will demonstrate the ability to input data into an Excel spreadsheet. They will learn how to set up formulas using software features.
- Teaching Strategies:
- Essential Question: What is a spreadsheet and what's its usefulness?
- Define spreadsheet and then ask the students to brainstorm ways to use a spreadsheet.
- Launcher: Let's go shopping!
- Using guided practices and demonstrations with receipts, show students how to input data into a spreadsheet using the software features for Excel.
- About 3 weeks prior to this class day have your students bring receipts from the grocery store or discount store (Winn-Dixie, Wal-mart) where their parents made purchases. They need to bring a minimum of three receipts each and the longer the list of items the better. Tell them the receipts must show the name of the item purchased, quantities, total price, sales tax, and total amount due. Students will use a receipt to input data, calculate total price, sales tax, and amount due. Compare their totals with the total on the actual receipt. Further, using function formulas, have them calculate MAX, MIN, AVERAGE, and COUNT (number of items sold).
- Material Resources:
- Microsoft Excel
- Grocery store and/or or discount store receipt (at least 3)
- Evaluation Method and Assessment:
- Compare the total that they get with the total on the actual receipt.
- Use one of the tapes as a demonstration.
- Give students the opportunity to make corrections of their incorrect work.
- Final assessment will an "audit of their learning" (test).