Filtering Data: Finding What You Need

Learning Objectives Define 'data', 'filter', and 'condition' in their own words. Identify columns and rows in a simple spreadsheet. Apply a filter to a column to show only rows that match a specific word (e.g., 'cat'). Apply a filter to a column to show only rows with numbers greater than a specific value (e.g., > 5). Clear a filter to see all the original data again. Explain how a filter is like an 'if...then' rule. Imagine you have a giant toy box filled with cars, dolls, and blocks. How would you find ONLY the red cars? 🧐 That's what filtering does for computer data! Today, we're going to learn how to use a computer superpower called 'filtering'. It helps us find the exact information we need in a...

TermDefinitionExample DataData is just information. It can be words, numbers, or pictures. A list of your friends' names is data!In a list of pets, the names ('Fluffy', 'Spot'), the animal types ('Cat', 'Dog'), and their ages (2, 5) are all data. SpreadsheetA spreadsheet is a computer page with a grid of boxes, called cells, that help us organize data in lists.A class list with columns for 'Name', 'Favorite Color', and 'Birthday Month'. ColumnA column goes up and down in a spreadsheet. It holds the same type of data for everyone.The 'Favorite Animal' column lists the favorite animal for each student in the class. RowA row goes from left to right in a spreadsheet. It tells you all the information about one...

The 'Is Equal To' Rule Show rows IF [Column] IS [Value] Use this rule when you want to find an exact match. It's perfect for finding specific names, colors, or types of things. The 'Is Greater Than' Rule Show rows IF [Column] > [Number] Use this rule with numbers when you want to find things that are more than a certain amount. The '>' symbol looks like an alligator mouth eating the bigger number! The 'Clear Filter' Rule Clear Filter on [Column] After you find what you need, use this to make all your hidden data reappear so you can see the whole list again.