K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

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


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

More Ideas
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
  • Computer Lab Rules Essentials
  • California Regions
  • California Regions Brochure
  • Amazing Animals
  • Amazing Animals
  • I Am
    Poem Generator
  • I Am Poem Generator
  • "Floater"
  • I Can Float Animation
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
  • Copy and Paste Practice
  • M & M
    Excel Chart
  • Excel Pie Chart
  • Newspaper
  • Newspaper Template