Using Spreadsheets for Data Management
Grade Unknown Grade ยท Technology ยท 45 min
What's Included
Learning Objective
I can create a spreadsheet to organize and analyze data using basic functions like sum and average.
Warm-Up Video
Unknown Channel ยท 5:00
Access or Excel: Which is the Best for Your Data Needs?
Practice Questions
5 questions ยท Short answer
Exit Ticket
Quick comprehension check
โ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.โ
Complete Lesson Package
Get all 3 ready-to-use resources:
