Skip to content

2. Why Structured Data?
Students can submit work

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.
Shared work attachment
URL not accepted. Please paste a link to a Scratch project. URL not accepted. Please paste a link from (such as a Google Doc). You don't appear to be signed in. Please refresh the page and try again. Something went wrong. Please refresh the page and try again.

This project will be shared with your teachers

Students can submit their work on this page. View their submitted work on the student progress page of My Classes.

Students can submit their work on this page.

Students: sign in to submit your work.
Teachers: sign in to view submitted work.

  • "Happy Alley by Kevin MacLeod" by ( -- Licensed under Creative Commons: By Attribution 3.0 License (