Summary: Students use formulas, functions, and sorting to analyze and answer questions about a given table of data.
Effective Tech Lesson 5.7
This lesson is in my Level 5 Curriculum Progression.
Recommended for Fifth through Twelfth Grade
Uses Microsoft Excel, but can be adapted for other spreadsheet programs.
Teacher Instructions (pdf)
Student Instructions (pdf)
Student File (Excel)
Answer Key (pdf)
Students work in-step from teacher-directed instructions or at their own pace from written instructions.
Opportunity for student choice: none
Duration: Two 60-minute class sessions
Constructing a formula
Copying formulas to other columns/rows
Using the AutoFill command
Using functions in formulas