Learning Area Computer MBA

Unit Name ● Mastering Collaboration and Productivity with Google

Workspace Tools

Overview  Google Doc

 Google PPT
 Google Excel

Essential NA
Question

Time allotted 19/12/24

10:00-12:00

Educator Toolkit
Toolkit

W H E 1 R E 2

How will you help How will you How will you EQUIP How will you provide How will you help your
your students to HOOK and students, help them opportunities for students students EXPRESS
know WHERE they engage student EXPERIENCE the to REFLECT, RETHINK their understandings
are headed, WHY interest through a key ideas and and REVISE their and ENGAGE in
they are going there, thought-provoking EXPLORE the understandings and meaningful self-
and WHAT WAYS experience at the issue? work? (Refer to your EVALUATION?
they will be beginning? performances)
evaluated along the (Refer to your
way? performances)

Duration 2 hours

Standards Students will be able to:

Addressed ● Understand the core features of Google Docs, Slides, and
Sheets.
● Learn tips and tricks to enhance productivity and
collaboration.
● Create and manage documents, presentations, and
spreadsheets efficiently.
Resources ● Google docs,
● Google PPT
● Google excel

Pre Work For Teacher:

 Read content
● Keep Highlights ready
● Prepare PPTs
● Prepare the worksheet

W-Post the plan  Icebreaker (10 minutes)

● Google Docs (40 minutes)
● Google Slides (40 minutes)
● Google Sheets (40 minutes)
● Q&A and Wrap-Up (20 minutes)

H-
 Icebreaker (10 minutes)

E1-SMART Part 1: Google Docs (40 minutes)

Learning Goals:
 Understand document formatting and collaboration features.
 Explore advanced tools like voice typing and version history.
Activities:
1. Quick Demo (10 minutes):
o Basic formatting (headings, bullet points, tables).
o Collaboration: sharing, comments, and suggesting edits.
o Explore tools: Voice typing and "Explore" for research.
2. Hands-On Activity (15 minutes):
o Scenario: "Team Proposal Document"
 Create a shared document.
 Add headings and a table.
 Share with a partner to leave comments and
suggestions.
3. Pro Tip Sharing (5 minutes):
o How to use templates for quick document creation.
o Shortcut keys for faster editing.
4. Challenge (5 minutes):
o "Find and replace" a word in the document and track changes
made.

Part 2: Google Slides (40 minutes)

Learning Goals:
 Design visually appealing presentations.
 Use multimedia and animations effectively.
Activities:
1. Quick Demo (10 minutes):
 o Add text, images, and shapes.
o Apply slide layouts and themes.
o Add transitions and animations.
2. Hands-On Activity (15 minutes):
o Scenario: "Pitch Presentation"
 Create 3 slides:
 Title Slide
 Data Visualization Slide (use charts/images)
 Conclusion Slide with a call-to-action.
 Add transitions between slides and animate
text/images.
3. Group Activity (10 minutes):
o Collaborate on a shared Google Slides deck. Each participant
adds one slide about themselves (text, image, or fun fact).
4. Pro Tip Sharing (5 minutes):
o Using "Present Mode" effectively (Presenter Notes and Q&A).
o Embedding YouTube videos directly into slides.

Part 3: Google Sheets (40 minutes)

Learning Goals:
 Understand basic functions and formulas.
 Use tools for data analysis and visualization.
Activities:
1. Quick Demo (10 minutes):
o Basic formulas: SUM, AVERAGE, COUNT.
o Data sorting and filtering.
o Conditional formatting.
2. Hands-On Activity (15 minutes):
o Scenario: "Budget Tracker"
 Create a sheet with columns for expenses, categories,
and amounts.
 Use SUM to calculate totals.
 Apply conditional formatting to highlight expenses over
$100.
3. Group Activity (10 minutes):
o Share a sheet with a partner and collaborate to fill in data.
o Create a chart (bar or pie) to visualize the data.
4. Pro Tip Sharing (5 minutes):
o Use the "Explore" feature to analyze data quickly.
o Lock rows/columns using Freeze Pane.

R -Exit ticket Part 4: Q&A and Wrap-Up (20 minutes)

Recap:
 Discuss key takeaways for each tool.
 Highlight how these tools integrate seamlessly for better productivity.
Interactive Quiz (10 minutes):
 Use Google Forms to create a quick quiz about features discussed.
  Include multiple-choice and short-answer questions.
Feedback and Next Steps:
 Ask participants to share their feedback via a Google Form.
 Provide additional resources (help articles, video tutorials).
 Encourage participants to practice and explore advanced features on
their own.