Three for the price of two!
Summary: Students use formulas, functions, and sorting to analyze and answer questions about given tables of data.
Effective Tech Lessons 5.7, 5.8, and 5.9
These lessons are in my Level 5 Curriculum Progression.
Recommended for Fifth through Twelfth Grade
Uses Microsoft Excel, but can be adapted for other spreadsheet programs.
Three sets of Teacher Instructions (pdf)
Three sets of Student Instructions (pdf)
Three Student Files (Excel)
Three Answer Keys (pdf)
For the first lesson, students work in-step from teacher-directed instructions or at their own pace from extremely detailed written instructions. For the following two lessons, students work at their own pace from written instructions.
Duration: six to eight 60-minute class sessions
Constructing a formula
Copying formulas to other columns/rows
Using the AutoFill command
Using functions in formulas