Skip to content

1. Introduction to Research and Organize Information about Colleges in Google Sheets

Playback Speed:
Transcript

Choosing a college requires sorting through lots of information.

You may want to know about campus location, tuition, and housing options before you apply.

When you look at schools, it’s easy to miss information or just go with your first choice.

Taking the time to organize information makes it easier to compare and contrast schools and see how each fits with your criteria.

Criteria are the data points or characteristics you use to gauge schools and help you make an informed decision.

These can be anything from “has work/study programs” to “offers sports scholarships”.

Using a spreadsheet organizes school information all in one place.

You can compare and contrast colleges, rate their campuses, link to their websites, and track majors.

In this activity, you will build a list of colleges and important criteria in Google Sheets.

You’ll research them and use what you find to compare schools.

To do that, you will: Create a new spreadsheet Freeze a header row Select cells Move a column And add information to a cell, including a hyperlink.

You’ll use rows, columns, and cells to record and organize information.

Rows are numbered lines that run horizontally across the spreadsheet.

Columns run vertically up and down the spreadsheet.

They are alphabetical.

Cells make up the rows and columns.

To complete this activity, you first must sign in to your Google account.

Open a new tab in your browser, and sign in now.

If you don’t have a Google account, create one before beginning this activity.

Then, open Google Drive.

Create a new, blank spreadsheet in Google Sheets.

Type in a title for your spreadsheet.

This is how it will appear in Drive.

Google Sheets automatically saves your progress in Drive, so you don’t have to worry about losing your work or saving it manually.

You can access Drive and your files from any computer or device with an internet connection.

Now, it’s your turn: Open a new tab in your browser, Navigate to Google Drive, Open a new, blank spreadsheet And give it a title.

Next
Instructions
  1. Open a new tab in your browser.
  2. Navigate to Google Drive.
  3. Open a new, blank spreadsheet.
  4. Give it a title.