Teachers.Net
JoinLog in
Teachers.Net

Twelve Days of Christmas

By JIM DAWSON

  • Computer
  • Middle
Activity Time
45 minutes
Materials
Computer with Excel or other spreadsheet
Concepts / Topics
Multiplication and addition on spreadsheet, value of fictional literary items

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

  1. Open a new Excel workbook.
  2. 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.).
  3. In cell B1, type “Day 1.” Using the fill handle, drag through to M1.
  4. In cell B2, type 1. Using the fill handle, drag through to M2.
  5. In cell C3, type 2. Using the fill handle, drag through to M3.
  6. Repeat for each item for each day (D4 = 3, E5 = 4, etc.).
  7. Format columns O and P as currency ($).
  8. In cell N1, type “Total Items”; in cell O1, type “Item Costs”; and in cell P1, type “Total Costs.”
  9. 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.).
  10. In cells N2 through N13, use AutoSum to calculate the total number of each item for the 12 days.
  11. In cells P2 through P13, use multiplication to calculate the total dollars spent on each item.
  12. In cell P14, use AutoSum to calculate the total dollars spent over the 12 days.

Teachers.Net · https://teachers.net/lessons/4492.html