Skip to content

1. Use Code For Decision-Making

Playback Speed:
Transcript

You can use spreadsheets to organize data for any decision, including where to live.

Think about living on your own.

Do you want to live close to your workplace, college, friends, or family?

Do you need to live near a grocery store, pharmacy, or restaurants?

Do you need to walk to all of these places?

Or, if you have a car, do you want these locations to be within a five or ten mile radius?

Some data isn’t readily available on the internet -- especially personalized data.

For example, you can find the address of an apartment on a website.

But the website may not tell you how far that location is from your workplace or your school.

This information is specific to you.

There isn’t a spreadsheet formula to calculate the distance between two places.

But when a function or formula doesn’t exist, you can write your own!

In this activity, you will use a spreadsheet to collect, organize, and sort data about housing options.

Then, you will write a new spreadsheet function that calculates the distance between each housing option and another location, such as a college, workplace, or favorite hangout.

Knowing the distance between your home and a place you frequent helps you approximate the amount of time and money you will spend on travel.

To start, decide on a place you might like to live.

It could be in the same town that you live in now, where you’d like to go to school, or a place you’d really like to work after you graduate.

Then, create a new spreadsheet.

From a new tab or window, open Google Drive.

Create a new, blank spreadsheet, and name it “Housing Options” in the city you choose.

Then, move on to the next video to set up your spreadsheet.

Now, it’s your turn: Choose a city where you’d like to live.

Create a new spreadsheet And name it “Housing Options in” the city you choose.

Then, move on to the next video.

Next arrow_forward
Instructions
  1. Decide on a city where you'd like to look for houseing.
  2. Go to sheets.google.com.
  3. Open a blank spreadsheet.
  4. Name the sheet "Housing Options in [insert city]"
Attributions
  • "Apartments Search for Mobile, AL" by Apartments.com (http://www.apartments.com/apartments/?bb=-r_0hk14hIixin5iE)