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.
Open a blank spreadsheet. In A1, type “10” and hit the Enter key.
In A2, type “=A1+3” and hit Enter.
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.
What simple thing can you edit so that column A shows the sequence 12, 15, 18, . . . ?
What simple things can you edit so that column A shows the sequence 12, 11, 10, . . . ?
In B1, type “16” and hit Enter.
In B2, type “=B1*0.5” and hit Enter.
Click on cell B2 and fill down. Describe what happens.
What simple thing can you edit so that column B shows the sequence 10, 5, 2.5, . . . ?
What simple things can you edit so that column B shows the sequence 10, 30, 90, . . . ?
In column C, starting at C1 and going down, type these terms of a geometric sequence: 700, 70, 7, 0.7, 0.07
Type “=C2/C1” in cell D2. What is the result?
What is the meaning of the result?
Click on cell D2 and fill down. What happens?
In column E, starting at E1 and going down, type these terms of an arithmetic sequence: 7, 10.5, 14, 17.5
Type “=E2-E1” in cell F2. What is the result?
What is the meaning of the result?
Click on cell F2 and fill down. What happens?
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.
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.
Focus the discussion on the final two questions to highlight how spreadsheets facilitate efficient and accurate repeated calculations. Select students to share how they used the spreadsheet to identify the type of sequence and the rate of change or growth factor of the sequences.
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.
Change the numbers in the table so that all of the plotted points lie along a diagonal line with a positive slope.
Change the numbers in the table so that all of the plotted points lie along a horizontal line.
Change the numbers in the table so that the graph created does not represent a function.
Follow your teacher’s instructions to make one column a function of the other.
Change the expression in the second column so that the plotted points lie on a line with a different steepness.
Change the expression in the second column so that the plotted points do not lie on a line.
Change the table so that some of the points are plotted in Quadrant II of the graph (the upper-left quadrant).
The purpose of this discussion is for students to see a variety of graphs created using a table. Select students to share their graphs, and highlight how students plotted a graph that is not a function and how students changed the table to have points in two quadrants, and any changing of the graphing window that resulted.