Lesson for Spreadsheets
THANKSGIVING BUDGET ASSIGNMENT
For today’s’ activity you will be creating a budget for your family Thanksgiving dinner. You will do the activity in spreadsheet format. Following are the instructions for the assignment.
1. Start by placing your name and the title of the spreadsheet “Thanksgiving Dinner” at the top of your worksheet.
2. In column “A” make a list of all the items you would need to purchase for a Thanksgiving dinner to feed your family. You must have at least 20 items. Make sure you give the column an appropriate title.
3. Next in column “B” make a list of what you estimate the price will be for each item. In column “C” you will list the Quantity of each item needed. For column “D” you will need to do a formula, which multiplies the estimated price and the quantity needed, therefore producing a total estimate for the meal at the bottom of the Column. (=estprice*quantity OR =b3*c3)
4. You will need to find the actual price for each item from newspaper ads and place these prices in column “E.” Then take the quantity of each item in column “C” and place it in column “F” (use the copy command). Then in column “G” you will need formulas to come up with the actual cost of the dinner. Make sure at the bottom of the column you give a meal total. (=actprice*quantity OR =e3*f3) **Note that the actual price may be different because of the newspaper ads.
5. For the final step create a formula, which shows the difference from; your estimated meal price and the actual meal price. (=Estimated –actual OR actual – estimated)
6. Make it look nice with lines and text (change font and size of title, etc.)
7. Save as T-budget
8. Print preview and then print make it fit on one page.
9. Print the formulas. CTRL and ~
Example Sample Answer key
Items needed for dinner / Price Estimate / Quantity Needed / Total price estimate / Actual Prices / Quantity Needed / Actual Price / Difference in estimated and actual
Milk / $2.00 / 2 / $4.00 / $2.79 / 2 / $5.58 / $1.58
Cranberries / $0.99 / 2 / $1.98 / $0.50 / 2 / $1.00 / -$0.98
Croutons / $1.50 / 2 / $3.00 / $0.99 / 2 / $1.98 / -$1.02
Rolls / $1.89 / 2 / $3.78 / $2.99 / 2 / $5.98 / $2.20
Gravy / $1.09 / 3 / $3.27 / $0.79 / 3 / $2.37 / -$0.90
Ham / $3.75 / 1 / $3.75 / $1.29 / 1 / $1.29 / -$2.46
IceCream / $2.99 / 4 / $11.96 / $3.79 / 4 / $15.16 / $3.20
Jell - o / $0.89 / 3 / $2.67 / $0.79 / 3 / $2.37 / -$0.30
Soda / $2.50 / 4 / $10.00 / $1.49 / 4 / $5.96 / -$4.04
Olives / $1.09 / 2 / $2.18 / $0.59 / 2 / $1.18 / -$1.00
Potatoes / $1.99 / 23 / $45.77 / $1.69 / 23 / $38.87 / -$6.90
Pie Filing / $1.89 / 6 / $11.34 / $0.69 / 6 / $4.14 / -$7.20
Pie Crusts / $2.00 / 6 / $12.00 / $1.99 / 6 / $11.94 / -$0.06
Salad / $1.50 / 2 / $3.00 / $2.00 / 2 / $4.00 / $1.00
Salad dressing / $1.50 / 4 / $6.00 / $1.67 / 4 / $6.68 / $0.68
bread for stuffing / $1.16 / 2 / $2.32 / $0.69 / 2 / $1.38 / -$0.94
Turkey / $0.85 / 23 / $19.55 / $0.89 / 23 / $20.47 / $0.92
Vegetables / $0.89 / 6 / $5.34 / $1.49 / 6 / $8.94 / $3.60
Yams / $1.75 / 5 / $8.75 / $0.89 / 5 / $4.45 / -$4.30
Ice cream syrup / $1.75 / 4 / $7.00 / $1.50 / 4 / $6.00 / -$1.00
Total / $167.66 / $149.74 / -$17.92
Sample Answer key with the formula’s
Thanksgiving DinnerItems needed for dinner / Price Estimate / Quantity Needed / Total price estimate / Actual Prices / Quantity Needed / Actual Price / Difference in estimated and actual
Milk / 2 / 2 / =B3*C3 / 2.79 / 2 / =E3*F3 / =G3-D3
Cranberries / 0.99 / 2 / =B4*C4 / 0.5 / 2 / =E4*F4 / =G4-D4
Croutons / 1.5 / 2 / =B5*C5 / 0.99 / 2 / =E5*F5 / =G5-D5
Rolls / 1.89 / 2 / =B6*C6 / 2.99 / 2 / =E6*F6 / =G6-D6
Gravy / 1.09 / 3 / =B7*C7 / 0.79 / 3 / =E7*F7 / =G7-D7
Ham / 3.75 / 1 / =B8*C8 / 1.29 / 1 / =E8*F8 / =G8-D8
IceCream / 2.99 / 4 / =B9*C9 / 3.79 / 4 / =E9*F9 / =G9-D9
Jell - o / 0.89 / 3 / =B10*C10 / 0.79 / 3 / =E10*F10 / =G10-D10
Soda / 2.5 / 4 / =B11*C11 / 1.49 / 4 / =E11*F11 / =G11-D11
Olives / 1.09 / 2 / =B12*C12 / 0.59 / 2 / =E12*F12 / =G12-D12
Potatoes / 1.99 / 23 / =B13*C13 / 1.69 / 23 / =E13*F13 / =G13-D13
Pie Filing / 1.89 / 6 / =B14*C14 / 0.69 / 6 / =E14*F14 / =G14-D14
Pie Crusts / 2 / 6 / =B15*C15 / 1.99 / 6 / =E15*F15 / =G15-D15
Salad / 1.5 / 2 / =B16*C16 / 2 / 2 / =E16*F16 / =G16-D16
Salad dressing / 1.5 / 4 / =B17*C17 / 1.67 / 4 / =E17*F17 / =G17-D17
bread for stuffing / 1.16 / 2 / =B18*C18 / 0.69 / 2 / =E18*F18 / =G18-D18
Turkey / 0.85 / 23 / =B19*C19 / 0.89 / 23 / =E19*F19 / =G19-D19
Vegetables / 0.89 / 6 / =B20*C20 / 1.49 / 6 / =E20*F20 / =G20-D20
Yams / 1.75 / 5 / =B21*C21 / 0.89 / 5 / =E21*F21 / =G21-D21
Ice cream syrup / 1.75 / 4 / =B22*C22 / 1.5 / 4 / =E22*F22 / =G22-D22
Total / =SUM(D3:D23) / =SUM(G3:G23) / =SUM(H3:H23)