Excel - Thanksgiving Dinner Shopping
Create a Thanksgiving Dinner Shopping Expense Sheet
Instructions: Students create a spreadsheet and chart comparing Thanksgiving dinner prices for two stores. Students choose the same 6 or 7 items from each store to compare. Students create their spreadsheet using prices from the Thanksgiving price list. Students may also use local newspaper store ads if available. Students format the numbers with dollar signs and use a formula (SUM) to calculate total costs. Students create a chart illustrating their expenses. Grades 4+
Excel - Thanksgiving Dinner Comparison Shopping
Simpler Version - Only One Store - Finished Example
This chart uses a single column of prices. Students format the numbers with $ signs. Students use Auto Sum to calculate the total shopping bill. Students may use local newspaper store ads to find Thanksgiving food choices and prices.
Thanksgiving Grocery Store Price List
Students can use this list to compare the prices of similar items from two different stores. Student choose 6 or more products from each store to compare.
Excel Spreadsheet Rubric for Grading Assignments:
Common Core Standards
CCSS.Math.Content.2.MD.D.10 Draw a picture graph and a bar graph (with single-unit scale) to represent a data set with up to four categories. Solve simple put-together, take-apart, and compare problems1 using information presented in a bar graph.
CCSS.Math.Content.3.MD.B.3 Draw a scaled picture graph and a scaled bar graph to represent a data set with several categories.
CCSS.Math.Content.4.MD.A.2 Represent measurement quantities using diagrams such as number line diagrams that feature a measurement scale.
For PC's and Microsoft Office