Skip to content

5. Add One Place to Visit

Playback Speed:
Transcript

In this video, you will search for specific locations in the area you chose, and add one to your spreadsheet.

In the next activity, you will add more so your spreadsheet will include at least ten places.

You will wrap and align the text and resize the columns to make your data easy to read.

By including different places to visit, eat, or stay, you will create a personalized guide that shows your users what is special, unique, and fun about the area you picked.

If you’re working with a new area, or if you need some ideas, search the internet.

Include terms like “tourism,” “travel,” or “fun places to visit,” along with the name of the area.

Find several attractions, points of interest, or activities you can include in your guide.

Once you have found several locations, type the name of the first location in the first column in your spreadsheet.

Next, look up the location’s address in Google Maps.

Open a new tab or window.

Then, type the name of the location in the search box.

The map provides the address for this place.

Highlight the address, then copy it by pressing Command or Control C.

Then, return to your area guide.

Click on the first “address” cell.

Paste the address using Control or Command V.

If the text you paste looks different from the other text in your spreadsheet, remove the formatting.

Next, add a category for the location to help group the locations in your guide.

The category should be general, so you can use it for several locations.

Check out this list of possible categories, or come up with your own!

For example, if your guide focuses on one type of location, such as “stores,” the categories might include “shoes,” “hardware,” “sporting goods,” and “clothing.”

For a guide to restaurants, the categories might be types of food.

Choose a category that works best for the first place in your area guide.

Next, give your users a little more information about this place.

Type a brief description.

To make it easier to read the text in each cell, resize the columns.

Place your cursor in the row above the column headings.

Then, click and drag to make the column wider or narrower.

You can also “wrap” text, so that it fits within the cell.

Select “wrap” to make the text flow onto multiple lines within the cell.

You can also “align” the text to move it around in the cell.

Select the cell, column, or row to align.

Then, select horizontal alignment, and choose left, right, or center.

You can also align the text vertically.

Select top, bottom, or middle.

Once you have formatted your headings, move on to the next video where you will add additional locations and formatting to your area guide.

Now, it’s your turn: Add the first location to your guide.

Look up the place in Google Maps, and paste the address in your spreadsheet.

Add a description and a category for the place, and make the information easier to read by wrapping and aligning the text.

Then, move on to the next video.

Next arrow_forward
Instructions
  1. Add a familiar place to your guide.
  2. Look up the place in Google Maps, and paste the address into your sheet.
  3. Add a category for the place.
  4. Add personal opinions and observations.
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/)