Party Planning Project

ADVERTISEMENT

Name_______________________
Name ______________________
Create a new spreadsheet that stores the cost for a class party you are planning. You must purchase the
following items for 70 people: paper products/ decorations (plates, silverware, napkins), food/drinks,
and entertainment. Your spreadsheet (SS) should be able to serve as a shopping list also.
The spreadsheet should include four formulas (cell references required). Format the spreadsheet
appropriately and include informative headers and footers. The project must contain a pie chart (as a new
sheet with percent and labels) that displays the Cost per Category and a column chart (as a new sheet)
that compares the different Total Price cost of food items. Right click on the chart area and format the plot
area to be white. Save the spreadsheet naming it Party Planning Project and print a copy with gridlines
and row and column headings. Print and staple to this sheet a copy of the spreadsheet with the formulas
displayed and a copy with the values displayed.
Getting started:
o Choose a theme (i.e. Mexican, western, the 50’s). _________________________
o You have a budget of $700. Do not go over budget. Under budget is OK.
o Choose food, drinks, decorations, and entertainment that support your theme.
o Choose a form of entertainment. Entertainment Cost $200 (i.e. DJ, horse rides, limo)
o Your spreadsheet should display the Item, Quantity, Price per Item, and the Total Price. Include
a Grand Total as well.
o Create a formula with cell references to show the Cost per Student.
o Create a formula with cell references to show the Cost per Category for each of the three following
categories: Food/drinks, Paper products/decorations, and Entertainment.
****Hint: Place the three Costs per Category labels and formulas in adjacent cells at the bottom of the spreadsheet. This
will make it easier to create your pie chart.****
Print and staple in the following order:
Gold sheet, spreadsheet values, spreadsheet formulas, pie chart, column chart
Grading
Points
Item graded
Points
Earned
Budget and Theme
5
Column headings and labels
5
Followed directions
10
i.e. gridlines, order, correct categories, etc.
Detailed Shopping List
10
Formula for Total Price
10
(use cell references)
Formula for Grand Total
10
(use cell references)
Formula for Cost per Category
10
(use cell references)
Formula for Cost per Student
10
(use cell references)
Pie Chart (title, percents)
15
Column Chart (titles, labels)
15
Total: 100
Revised 11/14

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Life
Go