Lesson | Loading...

Unit 3, Lesson 8

Spreadsheet Shortcuts (Optional)

$Course Icon$

Integrated Math 1

8.1

Warm-up

Standards Alignment

None

Building On

Addressing

Building Toward

Instructional Routines

None

Materials

None

Activity Narrative

The purpose of this activity is to prepare students to work with a table of equivalent ratios that appears in a later activity in this lesson.

Launch

Give students a few minutes to complete the table. Ensure that they found the correct values before they work on the second question.

Activity

None

Here is a table of equivalent ratios:


3	15
10	50
6	30
1
	80

Complete the table with the missing values.
Explain what it means to say that the pairs of numbers are equivalent ratios.

Student Response

to access Student Response.

Building on Student Thinking

Activity Synthesis

Invite students to share how they reasoned about the values needed to complete the table. Keep asking "Did anyone think about it a different way?" until a few ways of reasoning come to light. Some methods might include:

Multiplying any number in the first column by 5 to find the number in the second column
Dividing any number in the second column by 5 (or multiplying by to find the number in the first column)
Using a scale factor to move from row to row, for example, starting with 6 and 30, you can multiply each value by to find 1 and 5 in the next row.

8.2

Activity

Optional

Instructional Routines

None

Materials

To Gather

Internet-enabled device Spreadsheet technology

Activity Narrative

The purpose of this activity is to learn that you can click on a cell to use its contents in a new expression rather than typing the address of the cell.

In the digital version of the activity, students use an applet to calculate values from other values in a spreadsheet. The applet allows students to directly type into the spreadsheet cells without navigating somewhere or opening another application. Use the digital version if it is available so that students can practice using the spreadsheet tools available in this course.

8.3

Activity

Optional

Instructional Routines

None

Materials

To Gather

Internet-enabled device Spreadsheet technology

Activity Narrative

The mathematical purpose of this activity is for students to become more efficient at entering values into a spreadsheet. In later units, students may wish to use the techniques in this activity to quickly compute the values of sequences by continuing the pattern.

Monitor for students who use a recursive formula, for example, typing = B2 + 2 in cell B3. Also look for students who use an explicit formula, like typing = A3 / 3 in cell B3. After students complete the first question, ask students to share their various spreadsheet formulas that work. Assure them that either is okay.

In the digital version of the activity, students use an applet to fill in many spreadsheet cells with a pattern. The applet allows students to work directly in the spreadsheet without navigating away or using another application. Use the digital version if it is available so that students may have more practice using the spreadsheet tools available in this course.

to access Cool-down.

Student Lesson Summary

Sometimes you want to create a list of numbers based on a rule. For example, let's say that the cost of a gym membership is a \$25 sign-up fee followed by monthly dues of \$35. We may want to know how much the membership will cost over the course of 6 months. We could use a spreadsheet and set it up this way:

Which results in:

See the little square on the lower-right corner of cell B2? If we click and drag that down, it will keep adding 35 to the value above to find the value in the next row. Drag it down far enough, and we can see the total cost after 6 months.

Anytime you need to repeat a mathematical operation several times, continuing a pattern by dragging in a spreadsheet might be a good choice.

Launch

Ask students to write down the day and month of the birthday of one of their heroes, such as a local community member, famous person from history, favorite athlete, or favorite celebrity. Then, give them this sequence of instructions. Allow them to use a calculator if they wish. (Alternatively, you could have one student demonstrate the procedure on the birthday of a local community hero for the group, and then re-run the computations with each student using the birthday of a hero.)

Multiply the month by 5.
Add 6.
Multiply by 4.
Add 9.
Multiply by 5.
Add the day.
Subtract 165.

Distribute internet-enabled devices, and give students instructions to navigate to this lesson in the digital version of the materials.

Action and Expression: Internalize Executive Functions. To support organization, provide students with grid or graph paper to organize their work with the sequence of steps for the calculations.
Supports accessibility for: Language, Organization

Activity

None

Navigate to this activity in the digital version of the materials or to ggbm.at/djcz6fjf.

In cell B4, we want to enter = B1 * 5 to multiply the month by 5. Begin by entering the “=” sign, but when you are about to type B1, instead, click on cell B1. Then type in the “*5.” This shortcut can be used any time: Click on a cell instead of typing its address.
Practice this technique as you program each cell in B5 through B10 to perform the right computation.
When you are finished, does cell B10 show a number that contains the month and day of your birthday? If not, troubleshoot your computations.
Try changing the month and day in cells B1 and B2. The rest of the computations should automatically update. If not, troubleshoot your computations.

Student Response

to access Student Response.

Building on Student Thinking

Some students may misunderstand the instructions and continue to refer each cell back to the number of their month. Each row after the first instruction is meant to refer back to the previous value.

Lesson | Loading...

Settings

Audience

Assessment Access

Lesson 8

Spreadsheet Shortcuts (Optional)

Warm-up

Standards Alignment

Building On

Addressing

Building Toward

Instructional Routines

Materials

Activity Narrative

Launch

Activity

Student Response

Building on Student Thinking

Activity Synthesis

Activity

Instructional Routines

Materials

To Gather

Activity Narrative

Activity

Instructional Routines

Materials

To Gather

Activity Narrative

Student Lesson Summary

Launch

Activity

Student Response

Building on Student Thinking

Activity Synthesis

Launch

Activity

Student Response

Activity Synthesis

Standards Alignment

Building On

Addressing

Building Toward

Standards Alignment

Building On

Addressing

Building Toward

Building on Student Thinking