K5 Computer Lab Lesson Plans

Excel - Party for 5 Food Budget

Students Create a Budget Showing Allowance, Costs and Money Left Over

Students have a budget of $25.00 to feed a total of 5 people (including themselves) for a party.

Each of the people want to eat and drink different things.

In order to make sure everyone has something they like to eat and drink, Students must choose at least 2 items from each of the 6 food categories on the Party Food Menu.

To make sure there is enough food, students must try to buy as much as they can with the $25.00 budget, without going over the budget.

 

 

The Assignment:

Students create a budget using a spreadsheet to show how much they have to spend (allowance) , and how much each item costs (expenses).

Students use autosum to calculate the total costs.

Students create a simple formula to subract total food expenses from the $25.00 allowance to show how much money is left over (money left over).

Grades 4+

 

 

 

 

Excel Party Food Menu

Requirements:

1) Students must choose at least 2 items from each food category to satisfy their finicky party friends. For example students will choose 2 items from "Hot Foods," 2 items from "Salads," and so on.

2) Students must also choose any 5 drinks from the drink menu.

3) Students should spend more than $24.00, but less than $25.00.

Download: excel-party-food-menu.pdf

 

Make this menu available for students to view.

Excel Party Food Menu

 

Excel - Party for 5 Food Budget Finished Example:

Students enter their food choices and their prices in the spreadsheet. Students format the prices with dollar signs and use formulas to calculate the total costs and money left over. Students create a chart illustrating the food costs.

Students should use print preview to ensure that everything will fit on a single page before printing.

Excel Party for 5 Budget Finished Example

 

 

 

Party for 5 Food Budget - Starter Template

Students can use this excel template to guide their budgeting. Students will need to apply necessary formatting, enter all the food choice data, food prices, and formulas.

Download: excel-party-for-5-party-food-budget-template.xlsx

 

Excel Party for 5 Food Budget Starter Template

 

 

 

Party for 5 Food Budget Instructions

Download: party-for-5-food-budget-spreadsheet-instructions.pdf

 

Party for 5 Food Budget Spreadsheet Instructions

 

 

 

Excel Spreadsheet Rubric for Grading Assignments:

Download: rubric-for-spreadsheet-with-chart.pdf

 

Spreadsheet Rubric

Popular:
For PC's and Microsoft Office

  • Excel
    Bar Chart

    Excel Bar Chart
  • Thanksgiving
    Copy and Paste

    Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing

    Green Screen Photo Editing
  • Computer Lab
    Rules

    Computer Lab Rules Essentials
  • California Regions
    Brochure

    California Regions Brochure
  • Amazing Animals
    PowerPoint

    Amazing Animals
  • I Am
    Poem Generator

    I Am Poem Generator
  • "Floater"
    Animation

    I Can Float Animation
  • Copy and Paste
    Practice

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper
    Template

    Newspaper Template