Skip to content
menu
See all lessons

Manage a Project with Digital Tools

Plan a team project, track its progress and costs, and prepare a summary report.
Start Add to class
Time to complete

timer 4 - 9 hours

Suitable for
  • Adult Learners
Skills covered
  • File organization
  • Project management
  • Spreadsheet design
Using
  • Docs
  • Search
  • Sheets
  • Slides
Lesson plans
Lessons
Lesson 1: Manage a Project with Digital Tools - Unit Introduction
  1. assessment Manage a Project with Digital Tools - Unit Introduction
Lesson 2: Create a Project Charter
  1. play_circle_filled Beginning Your Project
  2. play_circle_filled Define Purpose and Set Goals
  3. play_circle_filled Identify People Important to Your Project
  4. play_circle_filled Add More Project Details
  5. play_circle_filled Clean Up Your Charter
  6. play_circle_filled Sharing Your Charter and Getting Feedback
  7. play_circle_filled Getting Organized Before a Project Starts
  8. assessment Activity Reflection (Charter)
Lesson 3: Track a Project Using a Spreadsheet
  1. play_circle_filled Using a Spreadsheet to Organize Tasks and Priorities
  2. play_circle_filled Set Up a Spreadsheet
  3. play_circle_filled Update Tasks with a Drop-Down Menu
  4. play_circle_filled Visualize Project Status with Conditional Formatting
  5. play_circle_filled Clean Up and Share Your Project Tracker
  6. play_circle_filled Keep a Project Moving Forward
  7. assessment Activity Reflection (Tracker)
Lesson 4: Create a Budget in a Spreadsheet
  1. play_circle_filled Keeping Track of Project Finances
  2. play_circle_filled Set Up a Budget and Estimate Costs
  3. play_circle_filled Create a Category Menu
  4. play_circle_filled Compare Expenses to Cost Estimates
  5. play_circle_filled Use Functions to Calculate Total Costs and Contingency
  6. play_circle_filled Turn Negative Numbers Red with Conditional Formatting
  7. play_circle_filled Use Functions to Determine Total Budget by Category
  8. play_circle_filled Analyze Data to Adjust Project Goals and Purpose
  9. play_circle_filled Budgeting for Work and Personal Projects
  10. assessment Activity Reflection (Budget)
Lesson 5: Present a Progress Report
  1. play_circle_filled Sharing Project Details with Others
  2. play_circle_filled Add Text to Your Slides
  3. play_circle_filled Include Project Details
  4. play_circle_filled Change the Look of Your Slides
  5. play_circle_filled Add Visual Interest and Publish to Web
  6. play_circle_filled Use a Clear Presentation to Get Project Support
  7. assessment Activity Reflection (Presentation)
Lesson 6: Manage a Project with Digital Tools - Unit Wrap Up
  1. assessment Manage a Project with Digital Tools - Unit Wrap Up