Skip to main content

Transcript

In this video, you will practice sorting and filtering your spreadsheet.

You will also share your spreadsheet with a classmate.

Everyone processes, views and uses information differently.

Sorting and filtering the data in your area guide allows your users to customize how they view the information you've collected.

Before you start sorting, freeze the header row in your spreadsheet.

"Freezing" means that a row or column is pinned so that it is always visible as you scroll through your spreadsheet.

Now as you scroll down the sheet, the header row stays visible.

Next, sort your sheet.

Sorting organizes the information in a spreadsheet in a particular order based on a chosen column.

Choose the column you want to sort your spreadsheet by, such as 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 museums.

Sort by another column, like Rating.

Sorting by rating allows you to quickly see the best-rated places.

Next, filter the spreadsheet.

"Filtering" allows you to show data that meets selected requirements and hide any data that does not.

This allows people using your guide to focus on locations that meet their needs.

Select the header row and turn on filters.

Filter buttons appear in the corner of each column header.

Then, apply a filter to a specific column and remove the checkmarks from the values you don't want to see at this time.

For example, if you are sorting by category you might uncheck certain types of locations.

Rows with the selected categories appear, while rows with the filtered categories are hidden.

You can narrow down the results further by adding another filter.

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

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

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

To view all the information in the area guide again, turn off the filters.

Now that you've completed your area guide, share it with a partner.

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

To share your guide, enter your partner's email address.

Then, select the permission you want to use: Editor means the person you share it with can make changes directly in your spreadsheet, Commenter allows them to make comments, but not change the spreadsheet, And viewer lets them see your spreadsheet only.

For this project, select editor so that your partner can sort and filter your guide.

Next, look in your Google Drive to find the guide your partner shared with you.

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

Sort and filter your partner's area guide to find the locations that most interest you..

Now, it's your turn: Freeze the header row, sort the spreadsheet, filter the spreadsheet by at least one column to focus on specific locations, share your area guide with your partner, and explore your partner's area guide.


Instructions

  1. Freeze the header row.
  2. Sort the spreadsheet.
  3. Filter the spreadsheet by at least one column to focus on specific locations.
  4. Share your area guide with your partner.
  5. Explore your partner’s area guide.