Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.

1. Introduction to Sortable Data

Playback Speed:

In the last activity, you started an area guide that includes information, or data, about places to visit in an area.

You built your guide in a spreadsheet, which allows you to organize data about each place.

In this activity, you will add a rating scale to your guide using data validation.

Data validation allows you to limit the information that is allowed in a cell.

In your area guide, this might mean that cells in your category column only allow 3 ratings like "Must see", "If you have time," or "Avoid this site".

Other information appears as an error.

To start, open your area guide.

From a new tab or window, open Google Drive.

Find the spreadsheet, and open it.

Then, move on to the next video to create your rating scale.


  1. Open your area guide.
  • "Happy Alley by Kevin MacLeod" by ( -- Licensed under Creative Commons: By Attribution 3.0 License (
  • "Apartment Finder Homepage" by Apartment Finder (
  • "Style Seat Homepage" by Style Seat (