Learning Outcomes
- Explain the core feature in plain language.
- Complete the main task safely and confidently.
- Use sharing and collaboration appropriately.
- Apply the feature in a practical workflow.
Module 14 · Lesson 3
Build a Tracking Spreadsheet
Create formulas, filters and a chart for a simple project.
Why It Matters
Create formulas, filters and a chart for a simple project.
Google Workspace is most useful when the apps are treated as one connected system rather than separate tools.
Practical Method
- Choose the right app. Start with the job you need to complete.
- Organise before creating. Use a clear file name and save work in the correct Drive location.
- Check sharing. Give only the access people need.
- Collaborate clearly. Use comments, suggestions, mentions and version history.
- Review and hand over. Confirm ownership, access, final status and next actions.
Ian's practical tip: Before sending a link, open the Share panel and check exactly who can access the file and what they can do.
Practice Task
Complete a small real-world task using this feature. Record where the file is stored, who has access and what the next action is.