Lesson 4

Follow your teacher’s instructions to open a blank spreadsheet.

Type the following in each cell:

1. Look at the numbers that appear in B1, B2, B3, and B4 after you press enter. Where did these numbers come from?
2. Experiment with typing some different values in A1, A2, A3, and A4. Describe what happens.
3. Experiment with typing some new formulas in some new cells.
   1. Can you figure out how to raise a number to a power?
   2. What happens if you forget to start a formula with the = symbol?

1. Open a blank spreadsheet. In A1, type 10 and enter.

   1. In A2, type =A1+3 and enter.

   2. Click once on cell A2 to highlight it. See the little + in the lower-right corner? Click and drag it down to highlight several rows in that column and then let go. (This is known as “fill down.”) Describe what happens.

   3. What simple thing can you edit so that column A shows the sequence 12, 15, 18, . . .?

   4. What simple things can you edit so that column A shows the sequence 12, 11, 10, . . .?

2. In B1, type 16 and enter.

   1. In B2, type =B1*0.5 and enter.

   2. Click on cell B2 and fill down. Describe what happens.

   3. What simple thing can you edit so that column B shows the sequence 10, 5, 2.5, . . .?

   4. What simple things can you edit so that column B shows the sequence 10, 30, 90, . . .?

3. In column C, starting at C1 and going down, type these terms of a geometric sequence: 700, 70, 7, 0.7, 0.07

   1. In cell D2, type =C2/C1. What is the result?

   2. What is the meaning of the result?

   3. Click on cell D2 and fill down. What happens?

4. In column E, starting at E1 and going down, type these terms of an arithmetic sequence: 7, 10.5, 14, 17.5

   1. In cell F2, type =E2-E1. What is the result?

   2. What is the meaning of the result?

   3. Click on cell F2 and fill down. What happens?

5. Use the spreadsheet to decide whether the sequence 8, 12, 18, 27, 40.5 is arithmetic or geometric, and find its rate of change or growth factor.

6. Use the spreadsheet to decide whether the sequence 50, 42.1, 34.2, 26.3 is arithmetic or geometric, and find its rate of change or growth factor.

1. Open a graphing utility and follow your teacher’s instructions to create a new table with 2 columns. Learn how the 2 numbers in each row can be plotted as points in the coordinate plane.

   1. Change the numbers in the table so that all of the plotted points lie along a diagonal line with a positive slope.

   2. Change the numbers in the table so that all of the plotted points lie along a horizontal line.

   3. Change the numbers in the table so that the graph created does not represent a function.

2. Follow your teacher’s instructions to make one column a function of the other.

   1. Change the expression in the second column so that the plotted points lie on a line with a different steepness.

   2. Change the expression in the second column so that the plotted points do not lie on a line.

   3. Change the table so that some of the points are plotted in the second quadrant of the graph (the upper-left quadrant).

If you navigate to cell B2 and type =A2-A1, it will say 2. If you fill down from cell B2, all the cells will say 2. This is a way we can tell the sequence is arithmetic, and its rate of change is 2. If, instead in B2 you type =A2/A1, it will say 1.4. If you fill down from cell B2, all of the cells will contain different values. Since the sequence does not have a growth factor, we can tell the sequence is not geometric.

Technology can also be used to plot the terms of a sequence as a function of the term number. The term numbers and term values can be entered in a table and these pairs of numbers are plotted as points in the plane.

You can also enter a rule for the function in the table header and automatically generate new terms. For example, here is a table and graph representing an arithmetic sequence that starts at -2 for \(x=1\) and has a rate of change of 2: