Skip to content

4. Put Tasks in Sequence, Set Deadlines, and Add Notes

Playback Speed:

In the previous video, you and your group added headers in your spreadsheet for the important aspects of your project.

Then, you applied formatting to make your headers stand out.

In this video, you will decide on the proper sequence for the tasks in your project.

A sequence describes the way tasks follow each other in a set order.

Then, you will add deadlines for each task and format them.

To begin, return to your spreadsheet and review the tasks in the Task column.

As a group, decide on the best sequence for the tasks in your project.

Consider which task needs to come first, which ones need another task to be done first, and which ones can be worked on by different group members at the same time.

For instance, if you were choosing the proper sequence for making yourself a bowl of cereal, you would need to complete the tasks of getting a bowl and adding cereal to it before you could complete the task of pouring the milk.

However, your sister could be getting you a spoon from the drawer at the same time you worked on the previous tasks in order to be more efficient.

Reorder your tasks in a similarly efficient sequence by moving the cells up or down the column based on which tasks come first, which must come after something else is done, and which can be worked on at the same time.

Or insert a new row above or below a cell, and use cut and paste to move a task to that row.

You may find that starting from the day your group project is due, and then working backwards, is helpful in deciding how to order your tasks.

To work backwards, start with the date your project is due.

Then, in the cell above, add the last task you must do right before the deadline.

Then, add the next-to-last task, the third-to-last task, and so on.

Continue until you finish putting all the tasks in reverse order.

You may need to move things around a bit until you finalize your plan.

Now, as a group, estimate the total amount of time you expect to spend on each task.

Keep in mind that different group members can work on different tasks at the same time.

Working from bottom to top again, assign a deadline to each task.

Make your deadlines consistent. Format them as Date.

As you continue thinking about task sequence and deadlines, you may want to add some notes about your project tasks.

Notes can help your group remember an important detail, communicate an idea with one another, and come up with new strategies to make your project successful.

Write at least five notes that correspond to the different tasks in the Notes column.

Good job!

Your group has put your tasks in sequence and set reasonable deadlines.

Then, you added notes to help your group collaborate even more effectively.

Using your spreadsheet in this way helps break down a complicated project into much more manageable steps.

Now it's your turn: Put tasks in sequence.

Set deadlines.

Format deadlines as date.

And add notes for at least five project tasks.

  1. Put tasks in sequence.
  2. Set deadlines.
  3. Format deadlines as date.
  4. Add notes for at least five project tasks.