Complex group projects take effort and time to manage, especially when there are many
details, tasks, and people involved.
To make your group projects more manageable, it’s important to stay organized.
In this lesson, you will collaborate with your classmates to organize and plan a large-scale
project for your school or community.
Before the project begins, you may need to think of an idea for a project.
Most projects fill a need or fix a problem.
Maybe you’d like to create a community garden, or plan a mural for your school.
You will use a spreadsheet to organize tasks to plan your project.
People working on your project will be able to work on the spreadsheet from their own
computers and access it from any device with an internet connection.
This makes updating and organizing project tasks easier.
In this lesson, you will: Set up and format a project tracking spreadsheet,
Decide on tasks and deadlines, Add notes about tasks,
And assign roles and track the status of tasks.
This lesson uses Google Sheets, but you could use any spreadsheet application.
You will plan and organize your project in this lesson as a group.
When you create your organization spreadsheet, you will gather around one computer.
If you don’t know who you are working together with, ask your teacher.
As you plan your project, you will learn how to:
Label headings in a sheet,
Enter and format data,
And add data validation to create drop-down menus.
To begin, sign in to your Google account.
Open a new tab in your browser, and navigate to Google.com.
If you are not signed in, do so now.
If you do not have a Google account, pause the video and create one now.
To start, have one group member: Create a new spreadsheet,
and share it with the other group members.
Select the permission you want to use:
Edit means the person you share with can make
changes directly in your spreadsheet.
Comment allows them to make comments, but not change the spreadsheet.
And view lets them see your spreadsheet only.
For this lesson, select the edit permission so everyone in your group has access to the spreadsheet.
Then, move on to the next video to get started organizing your spreadsheet.
Now, it’s your turn: Sign in to your Google account,
Select one group member to create and name a new Google spreadsheet,
And share the spreadsheet with your group.