Skip to content
Playback Speed:
Transcript

In the previous video, you and your group brainstormed at least ten tasks you will need to do in order to complete your project successfully.

You created a column header for tasks and added your project tasks in the cells below.

In this video, you will continue by adding headers to the columns in your spreadsheet for other important project details.

Then, you will format the headers.

Formatting a spreadsheet by bolding text, freezing rows, and wrapping text helps organize your information, making it easier to read and use.

To begin, get together with your group, and think about all of the important aspects of your project.

Consider deadlines for each task, who will be responsible for each task -- this person is called the task owner, and notes your group might want to add to your spreadsheet.

Then, select one person to add each of these items to your spreadsheet as headers.

You will fill in the information below later, just as you did for your tasks.

Bold your headers to make them stand out more.

Next, freeze the header row.

Freezing the header row allows you to see your headers even when you scroll down through a very long list of information.

Another way to see all of the important information in your spreadsheet is by wrapping text.

When you wrap text, it stays visible within its cell, rather than being clipped or cut off.

Good job creating clear and useful headers!

To continue creating your group project-planning spreadsheet, move on to the next video.

Now it's your turn: Brainstorm important aspects of your project.

Add them as headers in your spreadsheet.

Bold the headers.

Freeze the header row.

And apply text wrapping.

Next
Instructions
  1. Brainstorm all of the important aspects of your project.
  2. Add them as headers in your spreadsheet.
  3. Bold the headers.
  4. Freeze the header row.
  5. Apply text wrapping.