Review summary
Previous lessonNext lesson

1.4 · Using Technology to Work with Sequences

Jump to a finding Standards connectionConceptual understandingProcedural skill and practiceCoherence: horizontal alignmentDepth of reasoningTeacher supportsMathematical practicesFormative assessment

Standards connection

Students interpret repeated differences and classify sequences with a spreadsheet. The tool and method are prescribed, so the task shows useful technology use rather than independent tool selection. HSF.BF.A.2 contribution: interpret recursive additive/multiplicative processes; technology routine does not automatically establish MP5 choice.

SE 1.4 task · PDF p. 3, Activity4.2 #4–6; earlier spreadsheet setup PDFp2

Content demands

Read this finding in the PDF

Conceptual understanding

Spreadsheet formulas connect repeated addition or multiplication with sequence generation. Students change starting values and rules, then interpret what the differences or ratios reveal about the sequence.

SE 1.4 task · PDF p. 3, Activity4.2 #4–6; earlier spreadsheet setup PDFp2

Conceptual understanding

Read this finding in the PDF

Procedural skill and practice

Practice #1 asks students to write spreadsheet formulas for doubling and constant-increment sequences. The task requires a cell reference that continues correctly when filled down, not just typing the desired terms.

SE 1.4 practice · PDF p. 1, Practice #1

Procedural development

Read this finding in the PDF

Coherence: horizontal alignment

Lesson 3 distinguishes arithmetic and geometric lists; this lesson tests those structures in spreadsheet columns. Computing differences and ratios gives a systematic check on a classification previously made by inspection.

SE 1.4 task · PDF p. 3, Activity4.2 #4–6; earlier spreadsheet setup PDFp2; 1.3 task · PDF p. 1, Activity 3.2

Within-course connections

Read this finding in the PDF

Depth of reasoning

Students must explain the meaning of spreadsheet ratios and differences and use them to classify new lists. A constant output column is useful only when students connect it with the common difference or growth factor.

SE 1.4 task · PDF p. 3, Activity4.2 #4–6; earlier spreadsheet setup PDFp2; TE Student task, anticipated reasoning and Activity Synthesis

Argument and critique — MP3

Read this finding in the PDF

Teacher supports

The teacher explicitly teaches cell addresses, formula entry, fill-down and plotting a table. A physical demonstration is suggested to connect the new interface with familiar function representations.

TE 4.1 Launch; 4.3 Launch; SE 1.4 task · PDF p. 3, Activity4.2 #4–6; earlier spreadsheet setup PDFp2

Teaching guidance

Read this finding in the PDF

Mathematical practices

MP8 is supported when repeated calculations expose a stable additive or multiplicative rule. The spreadsheet and graphing tools are prescribed here, so their use does not establish MP5 choice.

SE 1.4 task · PDF p. 3, Activity4.2 #4–6; earlier spreadsheet setup PDFp2; TE Activity monitoring, Anticipated Misconceptions, Activity Synthesis and Lesson Synthesis

Repeated reasoning — MP8

Read this finding in the PDF

Formative assessment

The synthesis compares students’ edited tables and graphs, including a relation that is not a function. This lets the teacher check whether students understand what their changes do, rather than infer understanding from successful clicks.

SE 1.4 task · PDF p. 3, Activity4.2 #4–6; earlier spreadsheet setup PDFp2; TE Activity monitoring, Anticipated Misconceptions, Activity Synthesis and Lesson Synthesis

Misconceptions, Review and feedback

Read this finding in the PDF

Unassessed in this lesson

Summative assessment: Protected assessment items and scoring guidance were not reviewed.

Coherence: vertical alignment: An explicit prior-grade connection was not verified for this lesson.

Contextual application: The selected evidence does not establish contextual application in this lesson.

Additional source references

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Preparation Required Materials/Preparation;4.3 Launch and Synthesis

Teach spreadsheet cells/fill-down and graphing table changes; demonstrate if needed; compare graph that is not a function. Manipulate values/formulas and explain graphical effect with partner. Technology serves functional structure; prescribed tool is not independent tool choice.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Preparation Required Materials/Preparation;4.3 Launch and Synthesis

Teach spreadsheet cells/fill-down and graphing table changes; demonstrate if needed; compare graph that is not a function. Manipulate values/formulas and explain graphical effect with partner. Technology serves functional structure; prescribed tool is not independent tool choice.

TE Preparation Required Materials/Preparation;4.3 Launch and Synthesis

Teach spreadsheet cells/fill-down and graphing table changes; demonstrate if needed; compare graph that is not a function. Manipulate values/formulas and explain graphical effect with partner. Technology serves functional structure; prescribed tool is not independent tool choice.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Preparation Required Materials/Preparation;4.3 Launch and Synthesis

Teach spreadsheet cells/fill-down and graphing table changes; demonstrate if needed; compare graph that is not a function. Manipulate values/formulas and explain graphical effect with partner. Technology serves functional structure; prescribed tool is not independent tool choice.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Preparation Required Materials/Preparation;4.3 Launch and Synthesis

Teach spreadsheet cells/fill-down and graphing table changes; demonstrate if needed; compare graph that is not a function. Manipulate values/formulas and explain graphical effect with partner. Technology serves functional structure; prescribed tool is not independent tool choice.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Preparation Required Materials/Preparation;4.3 Launch and Synthesis

Teach spreadsheet cells/fill-down and graphing table changes; demonstrate if needed; compare graph that is not a function. Manipulate values/formulas and explain graphical effect with partner. Technology serves functional structure; prescribed tool is not independent tool choice.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

TE Preparation Required Materials/Preparation;4.3 Launch and Synthesis

Teach spreadsheet cells/fill-down and graphing table changes; demonstrate if needed; compare graph that is not a function. Manipulate values/formulas and explain graphical effect with partner. Technology serves functional structure; prescribed tool is not independent tool choice.

TE Lesson Narrative; Required Materials; Required Preparation

Optional technology lesson develops spreadsheet cell/formula/fill-down and plotting skills; teacher preparation identifies graphing/spreadsheet devices and recommended tools.

SE 1.4 task · PDF p. 3, Activity4.2 #4–6; earlier spreadsheet setup PDFp2

Students interpret repeated differences and classify sequences with a spreadsheet. The tool and method are prescribed, so the task shows useful technology use rather than independent tool selection.

SE 1.4 practice · PDF p. 1, Practice #1, #2, #3, #4 including subparts/continuations

Practice#1–4 requires spreadsheets but asks students to author formulas and compute with negative/fractional factors;#5–6 explains arithmetic graph and uniqueness of geometric ratio.

SE 1.4 practice · PDF p. 2, Practice #5, #6 including subparts/continuations

Practice#1–4 requires spreadsheets but asks students to author formulas and compute with negative/fractional factors;#5–6 explains arithmetic graph and uniqueness of geometric ratio.