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

 

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