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 - Birthday Party Budget

Students Plan a Party and Stick to the Budget

Students have a budget of $100.00 to feed a total of 15 people (including themselves) for a birthday party.

Scenario: You are planning a birthday party for a good friend. You have exactly $100.00 dollars to spend. Your parents have given you a list of party supplies you need to shop for. You want to make sure that there are enough decorations, food, drinks, desserts, party favors, plates, cups, and napkins for everyone. There will 15 people at the party inluding yourself. Grades 4+



The Assignment:

Students create a birthday party budget using a spreadsheet to show how much they have to spend ($100.00), the total costs of the items they buy, and how much they are over or under the budget amount. Students create a chart of the costs ONLY. Hint: select only the items in column A and the costs in column D to create the chart.


Students use formulas to calculate each item's cost (quantity x price each), the total expense costs (use autosum), and the (over)/under budget amount (spending allowance - total cost).


Students may format their spreadsheet with a title, different fonts, colors, sizes for improved clarity and appearance. Students stick to the budget. Students research online stores (amazon, walmart, other) to find their party items and prices.


Birthday Party Budget Finished Example

Download: excel-birthday-party-budget-finished-example.xlsx

Birthday Party Budget


Using Formulas:

Discuss the need for formulas in this spreadsheet. We need to know the costs of all the items, we need to know how much we spent, and we need to know if we are over or under the budget and by how much. In this example, the formulas are:

1) =B5*C5

2) =SUM(D5:D15)

3) =B2-D16

Party Budget Formulas



Birthday Party for 15 Food Budget - Starter Template

Students can use this excel template to guide their budgeting. Students will need to apply necessary formatting, enter all the party item data, quantities, prices for each, costs, item descriptions, and all formulas.

Download: excel-birthday-party-budget-starter-template.xlsx

Budget Starter Template



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