Playback Speed:
Language:
Transcript

In this video, you will set up your spreadsheet by first listing the schools you plan to apply to.

You will then create a header row to track application details.

Finally, you will format the header row and adjust the column widths to make your spreadsheet easier to read.

College applications have a variety of requirements, and in a spreadsheet, you can organize those requirements into a grid.

Organizing them in this way allows you to easily find the information you need, Track similar items, And determine what you have already completed, And what you still need to work on.

To begin, return to your spreadsheet.

A spreadsheet consists of boxes called cells.

These cells are grouped into vertical series called columns and horizontal series called rows Columns, rows, and cells allow you to organize, sort, and visualize your data in different ways.

In the first column, list the schools you plan to apply to.

This list can include any schools you’re interested in, such as traditional four- and two-year schools, trade schools, or specialty schools, like those geared toward the arts.

Next, create a header for each of the items you may need to submit for each application.

You might include the application itself, An essay, And other materials.

Feel free to add whatever columns you need if the schools you are applying to require additional items.

Include the deadline for submitting the materials and when you expect to hear back from the school.

This is “your” spreadsheet, so add the columns that work best for you.

This example includes a column to note the likelihood that the student will apply.

This can be based on the school’s academic program, distance from home, tuition, and other factors.

Fill the header row with a color of your choice to make it stand out.

You can also make the text bold, And adjust the column widths for easier reading.

Now, it’s your turn: List the schools you plan to apply to, Set up a header row for application details, Fill the header row with a color of your choice, Make the text bold, And adjust column widths.

Instructions

  1. List the schools you plan to apply to.
  2. Set up a header row for application details.
  3. Fill the header row with a color of your choice.
  4. Make the text bold.
  5. Adjust column widths.