Add Application Information to Your Spreadsheet

Now that you have created and formatted your spreadsheet, you can begin adding details for each college application.

If you’re planning on applying to multiple colleges, you will need to keep track of what each one requests in its application package.

Using a spreadsheet application like Google Sheets keeps all the details in one place and allows you to set up tracking features like data validation.

You can also add or delete schools and make changes as needed.

To begin, choose or fill in the information you already know.

Use the drop-down menus you created in the previous video to track details about your applications.

Next, for each school, make a note when you have completed each part of the application.

For better tracking, include specific information wherever you can.

For example, note the name of the person you plan to ask for a letter of recommendation.

Make sure to ask that person far in advance to give them enough time to write the letter.

Not all colleges require certain kinds of documents.

If you don’t need to send a document to a particular college, put N-slash-A in the cell.

This stands for not applicable.

If you know when the application package is due, fill in the due date column.

A school may also let you know when you can expect to hear a decision from them.

After you have submitted your application, be sure to record it on your spreadsheet.

As you find out more information or get things done, mark it on your spreadsheet to keep it up to date.

Now, it’s your turn: Add application information to your spreadsheet, And continue adding to your spreadsheet as you find out more information or complete application steps.