K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
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

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 iPads - iWork

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
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
    Practice
  • Copy and Paste Practice
  • M&M
    Chart
  • Excel Pie Chart
  • NewsPaper
    Template
  • Newspaper Template