Week 3 ยท 45-60 min

Sorting and Filtering Data

Week Summary

A quick preview of the main ideas in this week before you begin the slides.

  • Why Sort and Filter?
  • Multi-Level Sorting
  • AutoFilter Basics
  • Filtering by Number Ranges

Glossary

Review these key terms before starting this week. They are kept simple so students can learn the new vocabulary before moving into the slides.

Why Sort and Filter?
Why Sort and Filter?
Multi-Level Sorting
Multi-Level Sorting
AutoFilter Basics
AutoFilter Basics
Slide 1๐Ÿ’ก

Why Sort and Filter?

Learning goal

Use sorting and filtering to explore datasets more deeply.

Read one card at a time. Focus on the main idea first, then look at the visual on the right to help it stick.

Sorting and filtering reveal patterns in raw data.

They help answer specific questions about a dataset.

They make large tables easier to interpret.

They are often the first step in exploration.

This builds intuition before using formulas.

Remember

Sorting and filtering are simple tools that make complex datasets easier to understand.

Why Sort and Filter?

Why Sort and Filter?

Slide 1 of 8

Use arrows or dots to move through the lesson

Practice

  1. Write 2-3 sentences about what you learned this week.

Coming Next Week: Next: Basic Formulas (SUM, AVERAGE, COUNT)