Skip to content

1. Introduction to Organize Group Projects in Google Sheets

Playback Speed:

Complex group projects take determination and time.

They can be challenging -- especially when there are many details, tasks, and people involved.

To make your group projects more manageable, it’s important to stay organized.

Good organizational skills help you stay on schedule, keep track of all aspects of your project, and produce a successful result.

In this video you will learn how to use digital tools to organize a group project.

You will collaborate with other students in your class in order to: define project goals, plan your approach, decide on tasks and deadlines, assign roles, manage your time, and stay on schedule.

The example in this video demonstrates how to use Google Sheets to prepare a group of students to successfully teach a lesson to their class.

However, the organizational skills you learn can be applied to all sorts of group projects, such as starting a classroom recycling program, planning a bake sale, a car wash, or other fundraiser, creating a class cookbook, or organizing an end-of-school-year classroom cleanup.

This lesson uses the free app Google Sheets, but you could use any spreadsheet application or even paper and pencil.

As you organize your project in a spreadsheet, you will learn how to: format text, freeze rows, wrap text, move cells up or down, format dates, and use data validation.

Before continuing with this lesson, check with your teacher to find out which topic your group will present.

Then, open a new tab in your browser and sign in to your Google account.

Everyone in your group will need a Google account to complete the lesson, so if you don’t have one, create it now.

Select one person in your group to complete the next task.

Pause the video until you have selected that person.

Once you have selected a group member and resumed the video, have the selected group member go to Google Drive, open a new blank spreadsheet, and title it with your group topic.

Then, share the spreadsheet with the rest of the group.

To do this, collect your group members’ email addresses, and enter them one by one.

Give every group member permission to edit the spreadsheet.

This means they can make changes and add their own ideas as you work together on your group project.

Then, move on to the next lesson to begin organizing your group project.


  1. Go to Google Drive, and open a new blank spreadsheet.
  2. Title it with your group topic.
  3. Share the spreadsheet with the rest of the group.
  4. Give every group member permission to edit the spreadsheet.