Skip to main content

Organize Group Projects in Google Drive


Getting started is easy. Go to the Applied Digital Skills website and sign up to set up your first class. Check out this guide with step-by-step instructions or go directly to the lesson through this link.

This lesson uses videos to teach critical life and technology skills:


  1. Introduction to Use Google Sheets to Organize a Group Project
  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 Set Status and Task Owners
  6. Use Google Sheets to Organize a Group Project: Wrap-Up
  7. Extension: Add Links to Resources
  8. Extension:  Use Conditional Formatting to Show Task Status
  9. Extension: Check Off Completed Tasks
  10. Extension: Invite Group Members to a Meeting
  11. Extension: Ask for Feedback and Implement
  12. Extension:  Filter Tasks by Owner

Life Skills

  • Organize and track deadlines.
  • Delegate and manage tasks for a group.
  • Prioritize tasks and determine sequence of events.

Technology Skills

  • Freezing rows
  • Data validation
  • Conditional formatting
  • Wrapping text
  • Sorting
  • Link to websites


Write A Review!

Be the first to submit a review!