In this video, you will write a list of project tasks in your spreadsheet.
A task is an activity that needs to be accomplished by a deadlinein order to complete a project successfully.
Keeping track of tasks in a spreadsheet is helpful because you can easily sort the items,add notes or other relevant information, and use your spreadsheet as a checklistto make sure you don’t forget any important steps.
A spreadsheet is made up of columns and rows.
Columns are vertical, like the columns on a building.
Rows are horizontal, like rows of seats in a movie theater.
To begin adding tasks, return to your spreadsheet.
Get together with your group and select another person to create a column header for tasks.
Headers help you quickly and easily identify what information is listedand sorted in the column below.
Now, take a few minutes to talk as a group about what your project will involve.
For instance, in the example project of teaching a topic to your class, you would need toresearch your topic, write a lesson plan,create slides or handouts for the class, write speaker notes,and create a quiz to see what students learned.
Those are just a few of the tasks involved in teaching a topic to a class.
Your group may brainstorm many more.
As you come up with tasks, type them in the cells of the Tasks column.
A cell is a box where you enter a single piece of information.
Each individual cell is identified by a column letter and a row number.
Enter your project tasks in the cells beneath the Tasks header.
Everyone in the group can add tasks.
As a group, come up with at least ten tasks,or use the tasks shown on screen.
You have your project tasks listed and are on your wayto making a complex project much simpler.
By breaking down a large task into smaller components, your group is more likelyto have a successful result.
Now it's your turn: Create a column header for tasks.
And add at least ten project tasks in the cells beneath the tasks header.
1. Introduction to Organize Group Projects in Google Sheets
2. Build Your Task List
3. Create and Format Column Headers
4. Put Tasks in Sequence, Set Deadlines, and Add Notes
5. Use Data Validation to Track and Assign Tasks
6. Organize Group Projects in Google Sheets Wrap-Up
7. Activity Reflection
8. Organize Group Projects in Google Sheets: Extensions