Using Spreadsheets for Data Management
Unknown Grade45 min
Learning Objective
I can create a spreadsheet to organize and analyze data using basic functions like sum and average.
Lesson Flow
Watch Video
Access or Excel: Which is the Best for Your Data Needs?
Unknown Channel
Practice
5 questions • Short answer
Exit Ticket
“You have a spreadsheet that lists your weekly expenses: $50 for groceries, $30 for transportation, and $20 for entertainment. Use the SUM function to calculate your total expenses for the week. Show how you would set up the data in the spreadsheet. In a spreadsheet, you recorded the scores of five tests: 85, 90, 78, 92, and 88. Use the AVERAGE function to find the average score. Describe how you would organize the data in the spreadsheet and the formula you would use.”
Teacher Guide
Get the complete package:
- Answer keys for all questions
- Differentiation strategies
- Extension activities
- Printable student handouts
