Sign in to view assessments and invite other educators
Sign in using your existing Kendall Hunt account. If you don’t have one, create an educator account.
Distribute internet-enabled devices, and give students instructions to navigate to this lesson in the digital version of the materials.
Ensure that students have access to the spreadsheet applet and that they understand how to type entries into cells. Call their attention to the Task Statement, which instructs them to try different numbers in column A and conjecture about how the numbers in column B are calculated.
Monitor for students who try interesting things, are able to predict what will be in a cell in column B, or can explain how a cell in column B is calculated.
After students have had a chance to experiment with the applet and make conjectures about how the cells in column B are calculated, invite them to compare their conjectures with a partner.
Before selecting students to share their conclusions, select students to share their predicted value for various cells in column B based on combinations of values in column A. For example, “What would be the value in cell B4 if column A has the values 2, 4, 5, and 9?” (20)
Select students who tried or noticed interesting things to share with the whole class.
The words “sum" and “product” appear in the formulas. Briefly ask students to recall the meaning of these words. Invite them to guess what using the : symbol in the cell formula does. For example, =Sum(A2:A5) calculates A2 + A3 + A4 + A5.
Navigate to this activity in the digital version of the materials or to ggbm.at/wu9t7kkd.
Students may have difficulty inputing a new formula in a cell. For example, students may forget to begin the formula with =. Ensure that students know how to input the symbols that represent each operation.
Ask students to report on the work they did with their partner.
Navigate to this activity in the digital version of the materials, or to ggbm.at/fjcybyqf.
Input different numbers in column A, and try to predict what will happen in column B. (Do not change anything in column B.)
Students may be confused about how the term “related” is being used in the task statement. Explain that students should be trying to figure out what calculations take place with the numbers in column A in order to get the numbers in column B. Students may have difficulty figuring out the relationships between the numbers in column A and the numbers in column B. Suggest they try different kinds of numbers in column A, like small whole numbers, 0, multiples of 10, or decimal values.