Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to find the sum, mean, and median of a set of values.

Concepts

averages, functions, mean, median, technology resources

Show More Show Less

Instructional Ideas

• Collaborate with a computer teacher for the lesson
• Use the tutorial with learners who are not familiar with spreadsheets
  

Classroom Considerations

• Pupils should have understanding of sum, mean, and median
  

Pros

• Includes a video with tips for instructors
• Tutorial is available as both an Excel spreadsheet and a Google Sheet
  

Cons

• None