Skip to content
Playback Speed:
Transcript

As you continue your college search, the most important question to consider maybe, “When is the application deadline?”

After all, a late application can hurt your admission chances to many schools.

Others won’t even look at it.

The spreadsheet you created in Google Sheets can help you manage important dates and deadlines, such as: Campus tour dates, Early admission application deadlines, Regular admission application deadlines, Scholarship application deadlines, and financial aid procedures.

In this extension, you will add information to your spreadsheet about regular admission deadlines.

Every college has its own application deadlines.

Early applications generally are submitted in the fall.

Some early application plans are binding.

This means that a student who is accepted early must attend the college.

Other types are non-binding.

This means that students receive an early response to their application but do not have to commit to the college until the regular reply date.

Regular application deadlines normally are in January or February.

These applications follow the normal process by which students apply by each school’s published deadline.

Admissions decisions are received in the spring.

In this extension, you will sort deadlines in your spreadsheet to easily see which ones come first.

This will help you plan ahead to get your applications in on time.

To begin, go to Google Drive And open your college information spreadsheet.

There might only be three schools listed in your spreadsheet.

However, it’s possible that your spreadsheet -- or one you work on in the future -- could include many more colleges.

Long spreadsheets with lots of data can be difficult to view and understand.

To keep key details easily visible, condense the column widths in your spreadsheet.

These steps let you see all of the columns at once, even after you add new ones.

Now, label a column for regular admission deadlines.

Bold your new header.

You can also add columns and column headings for dates of college tours, early admission applications, and more as you work through the research process for each college on your list.

Next, search for information to fill out the application deadlines for each of your colleges.

You can find many answers on the school websites.

For application deadlines, look in the “Admissions” section.

Or, search for “college name” and “application deadline.”

Once you find a college’s deadline, add it to your spreadsheet.

Then, repeat this process for all of the schools in your spreadsheet.

Now, format the column as “date.”

This formats every date you entered consistently, even if you typed them in different formats.

Sort from A to Z to see the regular application deadlines in order of first to last.

Good work!

Clearly sorting these important deadlines in your spreadsheet will help you manage your time during the application process.

In addition to using the skills you learned in this extension to sort college information, you also can track event information for a club you're a part of, alphabetize a spreadsheet of your contacts, or organize your class assignments by their deadlines.

Now, it’s your turn: Open your spreadsheet in Google Drive.

Condense column widths and wrap the text.

Add a column for regular admission deadlines.

Add and label additional columns for any other information you want to add to your spreadsheet.

Research and fill in the deadline of each college.

Format deadlines as dates.

And sort from A to Z.

Choose an Extension
Research and Sort Important College Deadlines
Add information to your spreadsheet about regular admission deadlines.
Add a New Sheet for Application Requirements
Add a new sheet to your spreadsheet to organize required application materials for each school.
Filter Colleges by Degree Type
Narrow down your degree choices to focus on the colleges that offer the degree you want.
Clarify Information by Splitting Text to Columns
Split text from one column into two columns to clarify and better organize details in your spreadsheet.
Keep Track of College Applications with Data
Learn how to use data validation to keep track of deadlines for your college applications.
Share Your College Spreadsheet with Others
Change permissions settings and share your spreadsheet to get feedback from others.
See more extensions