Summary: Students use formulas, functions, and sorting to analyze and answer questions about a given table of data.
Effective Tech Lesson 5.8
This lesson is in my Level 5 Curriculum Progression.
Recommended for Fifth through Eighth 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 at their own pace from written instructions.
Opportunity for student choice: none
Duration: Two to three 60-minute class sessions
No new skills introduced; practice of skills previously learned in Excel Formulas Lesson A.