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.
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
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
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
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
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
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
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
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
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.
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.