Mon. - Nov 30, 2020 - Applied Math (C2)
12 Days of Christmas Cost
Goal (SWBAT):
Use spreadsheet to organize and calculate recursive costs
In-Class Agenda:
The holidays are upon us and we are inundated with Christmas music. One traditional song, The Twelve Days of Christmas, speaks of one celebrant of Christmas bestowing his true love with an onslaught of gifts and entertainment. Your task is to determine how much money is spent on the true love.
1. Enter the data from Info Sheet 2 into a spreadsheet
2. Create another table that collects data about each gift. This tables needs to use TREND (from data from first table), PRODUCT (to calculate how much each gift will cost) and SUM (to calculate the daily and summative costs). Remember that most gifts are given on multiple days.
3. For advanced, decorate your spreadsheet with appropriate images of the gifts given.
4. Write four observations of the data
Assignment
12 Days of Christmas Cost
Handouts:
(null): AM Twelve Days of Christmas Costs
AM Twelve Days of Christmas Costs