Skip to content

2. Why Structured Data?

Playback Speed:

In this activity, you will start your interactive guide to an area.

You will add information to a spreadsheet and format it using font styles, colors, borders, and text wrapping to make it easy to read and use.

You could create an area guide in a document or presentation.

But the user would have to manually search through long lists or many slides to find what interests them.

Putting your information, or data, into a spreadsheet allows you to do much more than list it.

It structures the data into columns and rows.

When you structure data, you can: Sort it, to group data in different ways; Filter it, so you see only what you need, and manipulate it, so you can identify patterns.

By the end of this activity, you will have created a spreadsheet with columns like name, address, and rating.

You will also add at least ten specific, mappable locations in the area to rows in your spreadsheet.

You’ll format the information in your sheet to make it easier to identify and read.

There are many ways to format information in a spreadsheet.

In this activity you’ll: Change font styles and sizes; Wrap and align text; Resize columns and rows; And use borders, fill, and alternating colors to make your guide useful and fun.

To start, go to Google Drive and create a new, blank spreadsheet.

Name it “Area Guide.”

In the next video, you will choose an area to explore and begin to organize your spreadsheet.

Now, it’s your turn: Create a blank spreadsheet in Google Sheets.

and name the spreadsheet “Area Guide.”

Then, move on to the next video.


Create "Area Guide" spreadsheet.
  • "Happy Alley by Kevin MacLeod" by ( -- Licensed under Creative Commons: By Attribution 3.0 License (