| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | ๐ 12 DAYS of CHRISTMAS โ๏ธ | |||||||||
2 | Directions and Activities | |||||||||
3 | https://bit.ly/curts-12days | |||||||||
4 | ||||||||||
5 | โ๏ธ Directions | โข | The '12 Days of Christmas' is a famous Christmas carol, but is also full of interesting math concepts to explore. | |||||||
6 | โข | Below you will find several '๐ ๏ธ Tasks' and '๐ค Questions' to complete, which will allow you to explore these concepts. | ||||||||
7 | โข | Sections marked with 'โ๏ธ Directions' will give you instructions to follow. | ||||||||
8 | โข | Sections marked with 'โ๏ธ Your answer' is where you can type in your response to the task or question. | ||||||||
9 | โข | Sections marked with 'โ Click for help' will give you some hints or guidance if needed when you click the checkmark box. | ||||||||
10 | โข | Sections marked with '๐ฏ Click for answer' will give you the solution to that question if needed when you click the checkmark box. | ||||||||
11 | โข | This activity was developed by Eric Curts - ericcurts@gmail.com - ControlAltAchieve.com | ||||||||
12 | ||||||||||
13 | ๐ ๏ธ Task #1 | Collect the starting data | ||||||||
14 | โ๏ธ Directions | โข | On the 'Data' tab you will find a grid that has 'Presents' for the vertical axis in Column A, and 'Days' for the horiontal axis in Row 3. | |||||||
15 | โข | Your first task is to fill in the grid to show how many of each type of present you would receive on each day. | ||||||||
16 | โข | Remember on 'Day 1' all you get is one partridge in a pear tree, and by 'Day 12' you get all twelve types of presents, with one new type getting added each day from 'Day 1' up to 'Day 12'. For all the details, feel free to look at the lyrics to the song here: 12 Days of Christmas lyrics | ||||||||
17 | โข | Be sure to enter a zero for the cells where you do not get a certain type of present on a day. | ||||||||
18 | ๐ฏ Click for answer | |||||||||
19 | ||||||||||
20 | ||||||||||
21 | ๐ ๏ธ Task #2 | Explore totals by present type | ||||||||
22 | โ๏ธ Directions | โข | Now that you have the starting data entered on the grid, next you will explore several questions about the data. | |||||||
23 | โข | This first thing you will explore is how many of each present type you would get over the 12 Days of Christmas. | ||||||||
24 | โข | You will use the 'Totals' column in Column N to calculate the totals for each type of present. | ||||||||
25 | โข | Work through each of the questions below to explore and complete this task. | ||||||||
26 | ||||||||||
27 | ๐ค Question #1 | How can you calculate the totals for each type of present? | ||||||||
28 | โ๏ธ Your answer | |||||||||
29 | โ Click for help | |||||||||
30 | ๐ฏ Click for answer | |||||||||
31 | ||||||||||
32 | ๐ค Question #2 | Which present or presents will you get the most of? How many? | ||||||||
33 | โ๏ธ Your answer | |||||||||
34 | โ Click for help | |||||||||
35 | ๐ฏ Click for answer | |||||||||
36 | ||||||||||
37 | ๐ค Question #3 | Which present or presents will you get the fewest of? How many? | ||||||||
38 | โ๏ธ Your answer | |||||||||
39 | โ Click for help | |||||||||
40 | ๐ฏ Click for answer | |||||||||
41 | ||||||||||
42 | ๐ค Question #4 | Can you create a chart that will visually represent the totals for each type of present? | ||||||||
43 | โ๏ธ Your answer | |||||||||
44 | โ Click for help | |||||||||
45 | ||||||||||
46 | ๐ฏ Click for answer | |||||||||
47 | ||||||||||
48 | ||||||||||
49 | ๐ค Question #5 | Do you find anything interesting about the shape of the chart? How might you summarize the information the graph is displaying? | ||||||||
50 | โ๏ธ Your answer | |||||||||
51 | โ Click for help | |||||||||
52 | ๐ฏ Click for answer | |||||||||
53 | ||||||||||
54 | ๐ ๏ธ Task #3 | Explore totals by days | ||||||||
55 | โ๏ธ Directions | โข | Now that you have found the totals for each type of presents, next you will explore how many presents you get on each day. | |||||||
56 | โข | You will use the 'Totals' row in Row 16 to calculate the totals for each day of the 12 days. | ||||||||
57 | โข | Work through each of the questions below to explore and complete this task. | ||||||||
58 | ||||||||||
59 | ๐ค Question #6 | How can you calculate the totals for each day? | ||||||||
60 | โ๏ธ Your answer | |||||||||
61 | โ Click for help | |||||||||
62 | ๐ฏ Click for answer | |||||||||
63 | ||||||||||
64 | ๐ค Question #7 | On which day will you get the fewest presents? How many? | ||||||||
65 | โ๏ธ Your answer | |||||||||
66 | โ Click for help | |||||||||
67 | ๐ฏ Click for answer | |||||||||
68 | ||||||||||
69 | ๐ค Question #8 | On which day will you get the most presents? How many? | ||||||||
70 | โ๏ธ Your answer | |||||||||
71 | โ Click for help | |||||||||
72 | ๐ฏ Click for answer | |||||||||
73 | ||||||||||
74 | ๐ค Question #9 | Can you create a chart that will visually represent the total number of presents you get on each day? | ||||||||
75 | โ๏ธ Your answer | |||||||||
76 | โ Click for help | |||||||||
77 | ||||||||||
78 | ๐ฏ Click for answer | |||||||||
79 | ||||||||||
80 | ||||||||||
81 | ๐ค Question #10 | Do you find anything interesting about the shape of the chart? How might you summarize the information the graph is displaying? | ||||||||
82 | โ๏ธ Your answer | |||||||||
83 | โ Click for help | |||||||||
84 | ๐ฏ Click for answer | |||||||||
85 | ||||||||||
86 | ๐ ๏ธ Task #4 | Explore grand total of presents | ||||||||
87 | โ๏ธ Directions | โข | Now that you have found the totals for each type of present, and the totals for each day, finally you will explore how many presents you would end up with total at the end of all 12 days of Christmas. | |||||||
88 | โข | You will use Cell N16, where the 'Totals' column and the 'Totals' row intersect, to calculate the grand total of presents for all 12 days. | ||||||||
89 | โข | Work through each of the questions below to explore and complete this task. | ||||||||
90 | ||||||||||
91 | ๐ค Question #11 | How can you calculate the grand total of how many presents you will receive for all 12 days? | ||||||||
92 | โ๏ธ Your answer | |||||||||
93 | โ Click for help | |||||||||
94 | ๐ฏ Click for answer | |||||||||
95 | ||||||||||
96 | ๐ค Question #12 | What is the grand total of presents you will receive for all 12 days of Christmas? Do you notice anything special or significant about this number? | ||||||||
97 | โ๏ธ Your answer | |||||||||
98 | โ Click for help | |||||||||
99 | ๐ฏ Click for answer | |||||||||
100 | ||||||||||