Grocery Shopping & Meal Planning Spreadsheet Activities Google Sheets Excel

Rated 5 out of 5, based on 2 reviews

5.0 (2 ratings)

;

Proven Computer Lessons

1.5k Followers

Grade Levels

8th - 12th, Higher Education

Subjects

Computer Science - Technology, Special Education, Life Skills

Standards

CCSSMP4

CCSSMP5

Formats Included

PDF
Google Apps™
Internet Activities
Excel Spreadsheets

Pages

16 pages

$3.00

Wish List

$3.00

Wish List

Share this resource

Report this resource to TPT

Proven Computer Lessons

1.5k Followers

Includes Google Apps™

The Teacher-Author indicated this resource includes assets from Google Workspace (e.g. docs, slides, etc.).

Description

Standards

Reviews

Q&A

More fromProven Computer Lessons

Description

100% DIGITAL AND EDITABLE Interactive Spreadsheet Activities – Two Google Sheets/Microsoft Excel Activities will teach your students how to online grocery shop. Students will learn to navigate an online grocery store website, determine current price of grocery items, determine brand and size/unit/count, etc., locate sale items, and compare prices. Students will learn just how much groceries cost! Downloads in Google Sheets and works perfectly in Microsoft Excel. Includes a link for students to online grocery shop.

Activity 1 – Students are given a spreadsheet of 50 items to purchase that an average family of 4 might shop for in a given week. Students will learn how to shop for name brands, store brands, locate correct sizes/units/count, etc. Students will enter the data into the spreadsheet (download includes calculations so students can focus on shopping).

Follow Up Collaboration Activity – Students that shopped at the same store share their spreadsheets to view the differences and make comments to discuss why the TOTAL amounts vary.

Activity 2 – Students are given a spreadsheet to plan their OWN MEALS for 1 week and then grocery shop for the items. The spreadsheet includes dropdown boxes for easy entry and suggestions for meals (students are able to EDIT to customize their food choices).

These activities are perfect for upper middle school, high school, and special education students to learn to grocery shop online and plan a weekly menu for themselves.

Grocery Shopping Spreadsheet Activities Includes:

Link to Google Sheets Weekly Grocery Shopping List Activity 1
Link to Google Sheets Daily Meal Planner & Grocery Shopping Activity 2
Sample Answer Key for Activity 2
Teacher Directions

Total Pages

16 pages

Answer Key

Included

Teaching Duration

N/A

Report this resource to TPT

Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.

Standards

to see state-specific standards (only available in the US).

CCSSMP4

Model with mathematics. Mathematically proficient students can apply the mathematics they know to solve problems arising in everyday life, society, and the workplace. In early grades, this might be as simple as writing an addition equation to describe a situation. In middle grades, a student might apply proportional reasoning to plan a school event or analyze a problem in the community. By high school, a student might use geometry to solve a design problem or use a function to describe how one quantity of interest depends on another. Mathematically proficient students who can apply what they know are comfortable making assumptions and approximations to simplify a complicated situation, realizing that these may need revision later. They are able to identify important quantities in a practical situation and map their relationships using such tools as diagrams, two-way tables, graphs, flowcharts and formulas. They can analyze those relationships mathematically to draw conclusions. They routinely interpret their mathematical results in the context of the situation and reflect on whether the results make sense, possibly improving the model if it has not served its purpose.

CCSSMP5

Use appropriate tools strategically. Mathematically proficient students consider the available tools when solving a mathematical problem. These tools might include pencil and paper, concrete models, a ruler, a protractor, a calculator, a spreadsheet, a computer algebra system, a statistical package, or dynamic geometry software. Proficient students are sufficiently familiar with tools appropriate for their grade or course to make sound decisions about when each of these tools might be helpful, recognizing both the insight to be gained and their limitations. For example, mathematically proficient high school students analyze graphs of functions and solutions generated using a graphing calculator. They detect possible errors by strategically using estimation and other mathematical knowledge. When making mathematical models, they know that technology can enable them to visualize the results of varying assumptions, explore consequences, and compare predictions with data. Mathematically proficient students at various grade levels are able to identify relevant external mathematical resources, such as digital content located on a website, and use them to pose or solve problems. They are able to use technological tools to explore and deepen their understanding of concepts.

Reviews

Questions & Answers

Proven Computer Lessons

See all 737 resources

1.5k Followers