Skip to content

4. Sort and Filter Your Data

Playback Speed:
Transcript

In the last video, you added a rating scale to your area guide using data validation.

In this video, you will customize the look of your spreadsheet.

You will freeze the top row so you users can see it as they move around the sheet.

Then, you will sort and filter the data to make it easy for you and others to use.

Finally, you will digitally share your spreadsheet with your partner.

Every person processes, views, and uses information in different ways.

Sorting and filtering the data in your area guide allows your users to customize the information you’ve collected.

First, freeze the header row in your spreadsheet, so this row will stay at the top of the sheet even when you sort and filter your guide.

Highlight the row.

From the view menu, choose “freeze” and “one row.”

This locks the row in place.

If you scroll down the sheet, the header row stays visible.

Next, sort your sheet.

First, sort by category.

Select the category column.

Then, sort the sheet.

Now the locations are grouped by category.

That way, you can find places in a certain category quickly, like parks or restaurants.

Sort by another category, like “Rating.”

Select the Rating column, and choose sort.

Now the sheet is sorted first by rating.

But notice that it is also still sorted by category, too.

Sorting allows you to quickly see the best-rated places of each type.

Next, filter the spreadsheet.

To “filter” means to show some data and hide the rest.

Filtering lets the person using your guide remove the data they don’t want to see.

Turn the filters on.

Select “Data,” then “Filter.”

Filter buttons appear in the corner of each column header.

To filter your Guide by category, click the button in the “Category” header.

Remove the checkmarks from the categories you don’t want to see.

Now the selected categories appear, but the filtered categories are hidden.

Next, add an additional filter for rating.

In the box, check which ratings you’d like to see.

This allows you to customize your view of the data even more.

Now you only see the locations in the categories you like best, and the items that are rated the highest.

To view the entire area guide again, turn off the filters.

Now that you’ve completed your own area guide, share your guide with a partner.

If you do not know who your partner is, ask your teacher.

To share your guide with your partner, click “Share” and enter your partner’s email address.

Look in your Google Drive to find the shared file.

Open it and check out your partner’s area guide.

Sort it and filter it.

Then, let them know what you think!

Now, it’s your turn: Freeze the header row of your area guide.

Sort the spreadsheet by category, rating, or another column.

Filter the spreadsheet to limit the amount of information you see at one time.

Share your area guide with your partner.

Finally, move on to the next video to wrap up this activity.

Next arrow_forward
Instructions
  1. Freeze one row.
  2. Select all cells and choose "sort range" from the data menu.
  3. Choose a column heading from the dropdown and click "Sort."
  4. Add another sort column. Then, change the order of the sort to see different results.
  5. Filter the spreadsheet by clicking the arrow next to a column heading.
  6. Digitally share your Area Guide with your partner, then email your partner with one place from their guide you would like to visit.
Attributions
  • "Happy Alley by Kevin MacLeod" by incompetech.com (http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100482) -- Licensed under Creative Commons: By Attribution 3.0 License (http://creativecommons.org/licenses/by/3.0/)