Twelve Days of Christmas
- Computer
- Middle

- Activity Time
- Materials
- Concepts / Topics
Learners enter the song's gifts and quantities in a spreadsheet, assign costs, and use addition and multiplication to calculate item counts and total costs.
Create a Spreadsheet for the Twelve Days of Christmas
- Open a new Excel workbook.
- In cells A2 through A13, type the twelve gifts from “The Twelve Days of Christmas” (Partridge in a Pear Tree, Turtle Doves, French Hens, etc.).
- In cell B1, type “Day 1.” Using the fill handle, drag through to M1.
- In cell B2, type 1. Using the fill handle, drag through to M2.
- In cell C3, type 2. Using the fill handle, drag through to M3.
- Repeat for each item for each day (D4 = 3, E5 = 4, etc.).
- Format columns O and P as currency ($).
- In cell N1, type “Total Items”; in cell O1, type “Item Costs”; and in cell P1, type “Total Costs.”
- In cells O2 through O13, assign a dollar value to each item (for example, a Partridge in a Pear Tree = $200, each Turtle Dove = $6, each French Hen = $7.50, etc.).
- In cells N2 through N13, use AutoSum to calculate the total number of each item for the 12 days.
- In cells P2 through P13, use multiplication to calculate the total dollars spent on each item.
- In cell P14, use AutoSum to calculate the total dollars spent over the 12 days.
Teachers.Net · https://teachers.net/lessons/4492.html