Module Overview

Google Gemini can help users draft emails, improve documents, understand spreadsheet data, and plan presentations. When Gemini features are available within Google Workspace, they can support everyday tasks and reduce repetitive work.

In this module, you will learn how to use Gemini-related features with Gmail, Google Docs, Google Sheets, and Google Slides. You will also learn how to write effective prompts, review AI-generated content, and apply these tools to realistic workplace tasks.

Important: The availability, names, and capabilities of Gemini features depend on your Google account, Workspace plan, region, language, administrator settings, and Google's current product offerings. Some features may require an eligible subscription. If a feature is unavailable in your account, you can still use Gemini separately to prepare content and then transfer the reviewed result into the relevant Workspace application.

Learning Objectives

By the end of this module, you will be able to:

• Use Gemini to draft, rewrite, and improve professional emails.

• Summarize and improve documents using Gemini-related features.

• Generate spreadsheet formulas and analyze tabular data with AI assistance.

• Plan presentation outlines and improve slide content.

• Write clear prompts for common Google Workspace tasks.

• Review AI-generated results for accuracy, privacy, tone, and usability.

---

Topic 21: How to Use Gemini with Gmail for Email Drafting and Inbox Productivity

1. Introduction

Email is an essential communication tool for students, teachers, freelancers, business owners, and corporate professionals. However, writing emails, responding to messages, and summarizing long conversations can consume valuable time.

Gemini can assist with email-related tasks, such as drafting messages, improving tone, organizing ideas, and summarizing information. Depending on feature availability, some assistance may be available directly inside Gmail, while other tasks can be completed using the Gemini app and then transferred into Gmail.

2. What Can Gemini Help You Do in Gmail?

Common use cases include:

• Drafting professional emails from short instructions.

• Rewriting informal messages into professional communication.

• Creating polite follow-up emails.

• Preparing meeting requests and appointment confirmations.

• Summarizing lengthy email conversations when the relevant content is provided or accessible to an enabled feature.

• Improving grammar, clarity, and sentence structure.

• Preparing customer support replies.

• Creating email templates for repeated business tasks.

Example: Instead of spending several minutes writing a meeting request, you can provide the purpose, recipient, date, and preferred tone. Gemini can turn those details into a structured email draft.

3. How to Draft an Email with Gemini

Step 1: Identify the purpose

Before writing a prompt, determine what the email should accomplish.

For example:

• Request a meeting.

• Respond to a customer complaint.

• Send a project update.

• Follow up on a pending payment.

• Apply for an internship.

Step 2: Provide the necessary context

Tell Gemini who the recipient is, why you are writing, which details must be included, and what tone you prefer.

Step 3: Generate the draft

Use Gemini directly or an available Gmail writing feature. If you are using the separate Gemini app, ask it to create the email text and copy the result into Gmail.

Step 4: Review the email

Check the recipient, subject line, dates, names, attachments, and factual claims. Make sure the message does not include information you did not intend to share.

Step 5: Send the email yourself

Review the final message before sending. Do not assume that an AI-generated draft is accurate or ready to send without checking it.

4. Practical Example: Requesting a Meeting

Prompt:

"Write a professional email to my project manager requesting a 30-minute meeting to discuss the progress of our website development project. Mention that I am available on Tuesday or Wednesday afternoon. Keep the email polite, concise, and professional. Include a suitable subject line and a clear closing."

Example output:

Subject: Request for a Website Project Progress Meeting

Dear Project Manager,

I would like to schedule a 30-minute meeting to discuss the current progress of our website development project and review the next steps.

I am available on Tuesday or Wednesday afternoon. Please let me know which time works best for you.

Thank you for your time.

Best regards,
[Your Name]

The example demonstrates the expected structure. Replace placeholders with accurate information before using the message.

5. Improve Email Tone with Gemini

Sometimes, the information in an email is correct, but the wording sounds too direct, confusing, or informal.

You can ask Gemini to adjust the tone without changing the meaning.

Prompt:

"Rewrite the following email in a polite and professional tone. Keep the original meaning, preserve all factual details, and make the message concise.

Email: [Paste your email here]"

You can also request a specific style:

• Formal and respectful.

• Friendly and conversational.

• Short and direct.

• Empathetic and customer-focused.

• Persuasive but not aggressive.

6. Use Gemini to Prepare Follow-Up Emails

Follow-up emails are useful when a customer has not responded, a proposal is awaiting approval, or a payment is overdue.

Prompt:

"Write a polite follow-up email to a client who received our website development proposal five days ago. Ask whether they have reviewed it and whether they need any clarification. Avoid sounding pushy. Include a subject line and a professional closing."

Before sending the email, verify the actual date of the original communication and the status of the proposal.

7. Summarizing Long Email Conversations

Long email threads can contain multiple questions, decisions, and pending actions. A summary can help you understand the conversation more quickly.

If you use the separate Gemini app, provide the relevant email text. If an eligible Gmail feature can access and summarize your conversation, follow the instructions shown in your account.

Prompt:

"Summarize the following email conversation. Organize the result into four sections: main topic, decisions made, pending questions, and action items. Identify any deadlines explicitly mentioned. Do not invent missing information.

Email conversation:
[Paste the relevant conversation]"

Review the summary against the original messages before relying on it for important decisions.

8. Email Productivity Best Practices

1. Use specific prompts instead of vague instructions.

2. Provide only the context needed for the task.

3. Avoid including passwords, payment credentials, confidential client information, or unnecessary personal data.

4. Verify names, dates, figures, links, and attachments.

5. Keep the recipient and business relationship in mind when selecting the tone.

6. Never allow an AI-generated message to make an unapproved promise or commitment on your behalf.

7. Follow your organization's policies for handling business information.

9. Practical Exercise

Task: Create three emails using Gemini.

1. A meeting request to a manager.

2. A polite follow-up to a customer.

3. A professional response to a customer asking for more information about a service.

For each email, generate a subject line, review the tone, correct any inaccurate details, and prepare a final version suitable for sending.

10. Topic Summary

In this topic, you learned how Gemini can support email drafting, rewriting, follow-ups, and conversation summaries. The main principle is to provide clear instructions, review the generated content, and remain responsible for the final communication.

---

Topic 22: How to Use Gemini in Google Docs to Draft, Summarize and Improve Documents

1. Introduction

Google Docs is commonly used to create reports, proposals, assignments, meeting notes, business letters, project documentation, and other written materials.

Gemini can assist with document creation and improvement. Depending on your account and the features enabled, you may be able to use Gemini directly in Google Docs or prepare content separately and insert it into a document.

2. Common Document Tasks for Gemini

Gemini can help you:

• Create a first draft from a topic or outline.

• Turn notes into structured paragraphs.

• Rewrite unclear sentences.

• Correct grammar and improve readability.

• Summarize lengthy documents.

• Convert paragraphs into bullet points.

• Create headings and section outlines.

• Draft reports, proposals, and meeting summaries.

• Adjust the tone for different audiences.

• Generate questions or action items from supplied material.

AI assistance can speed up writing, but it does not replace the need to verify facts, cite sources, and check whether a document meets its intended requirements.

3. How to Draft a Document

Step 1: Define the document type

Specify whether you need a report, proposal, assignment, guide, business letter, or project plan.

Step 2: Identify the audience

A document for school students should use different language from a report for senior management.

Step 3: Provide the structure

Specify the headings, length, format, and essential points.

Step 4: Generate the draft

Use an available Gemini feature in Docs or generate the content separately and paste it into a new Google Doc.

Step 5: Review and format

Check headings, paragraphs, lists, tables, factual statements, and references. Apply the document styles and formatting required for your purpose.

4. Practical Example: Creating a Business Report

Prompt:

"Create a professional business report outline for a small company planning to launch a new website. Include the following sections: executive summary, project objectives, target audience, required features, estimated timeline, risks, budget considerations, and next steps. Under each heading, provide two or three guiding questions. Do not invent company-specific data."

This prompt produces a reusable outline without pretending that unknown project details are already available.

You can then provide verified information about the business and ask Gemini to help develop each section.

5. Turn Rough Notes into a Structured Document

Suppose you have these notes:

• Website redesign required.

• Mobile users are increasing.

• Product pages need improvement.

• Contact form is difficult to use.

• Performance needs testing.

• Launch date is not confirmed.

Prompt:

"Turn these notes into a clear project update for a business team. Use a short introduction, a section titled 'Key Issues,' and a section titled 'Next Steps.' Preserve the original facts. Do not invent a launch date, budget, or project status."

This workflow helps convert unstructured notes into readable business communication.

6. Summarize a Long Document

When working with a lengthy document, a summary can help you identify the main ideas before reading specific sections in detail.

Prompt:

"Summarize the following document in approximately 250 words. Include the main argument, key supporting points, important dates or figures, and the final conclusion. Clearly distinguish facts stated in the document from questions that remain unanswered.

Document:
[Paste the relevant text]"

For very long documents, work with manageable sections if necessary. Check that important exceptions, qualifications, and numerical details have not been omitted.

7. Improve Writing Quality

You can ask Gemini to improve a document for clarity without changing its meaning.

Prompt:

"Review the following document for grammar, clarity, sentence structure, repetition, and professional tone. Preserve all factual claims and technical terms. List the major suggested changes before providing a revised version.

Document:
[Paste your text]"

For a document that must retain the author's voice, add:

"Keep the original writing style wherever possible. Make only the changes needed to improve clarity and correctness."

8. Create Meeting Minutes from Notes

Meeting minutes should capture what was discussed, what was decided, and what needs to happen next.

Prompt:

"Organize the following meeting notes into professional meeting minutes. Use these sections: meeting purpose, key discussion points, decisions, action items, and unresolved questions. Include an owner or deadline only when explicitly provided. Mark missing details as 'Not specified.'

Notes:
[Paste your meeting notes]"

This format reduces the risk of confusing a suggestion with an approved decision.

9. Use Gemini to Improve a Proposal

A business proposal should be clear, relevant, and supported by accurate information.

Prompt:

"Review this proposal for a website development project. Identify unclear sections, missing information, repeated points, and statements that require evidence. Suggest improvements to the structure and tone. Do not invent prices, guarantees, client testimonials, or delivery commitments.

Proposal:
[Paste the proposal]"

Use the feedback as an editing guide. Confirm all pricing, timelines, deliverables, and contractual terms independently.

10. Document Quality Checklist

Before publishing or sharing a document, confirm the following:

• The title clearly describes the content.

• The introduction explains the purpose.

• Headings follow a logical order.

• Claims and statistics have been verified.

• Sources and citations are included where required.

• Tables, lists, and formatting are consistent.

• Confidential information is handled appropriately.

• The document satisfies its audience's needs.

11. Practical Exercise

Task: Create a one-page project report for a fictional website redesign.

Your report must include:

1. Project overview.

2. Three objectives.

3. Four planned website improvements.

4. Three potential risks.

5. Next steps.

6. A short conclusion.

Use Gemini to create the first draft, then review it for unsupported assumptions and improve the formatting in Google Docs.

12. Topic Summary

Gemini can help users draft, summarize, restructure, and refine documents. Effective results come from defining the document's audience and purpose, providing accurate source material, and reviewing the final version carefully.

---

Topic 23: How to Use Gemini with Google Sheets for Formulas, Tables and Data Insights

1. Introduction

Google Sheets is used to organize information, calculate totals, track performance, maintain records, and analyze data.

Gemini can assist with spreadsheet-related tasks by explaining formulas, suggesting calculations, identifying patterns in supplied data, and helping users understand tables. Some AI features may be available directly in Sheets for eligible accounts. Alternatively, you can ask Gemini separately for a formula or analysis and apply the result in your spreadsheet.

Important: AI-generated formulas and interpretations must be tested against the actual data. A formula that looks correct may still produce incorrect results if the cell ranges, column names, or assumptions are wrong.

2. What Can Gemini Help You Do in Sheets?

Typical tasks include:

• Suggesting formulas for totals, averages, counts, and conditions.

• Explaining existing spreadsheet formulas.

• Helping structure tables.

• Suggesting data-cleaning steps.

• Identifying possible trends in supplied data.

• Creating categories and labels.

• Suggesting chart types for a dataset.

• Helping troubleshoot formula errors.

• Explaining spreadsheet functions in beginner-friendly language.

• Preparing a summary of business or educational records.

The specific tasks supported directly inside Sheets depend on the features available in your account.

3. Understand Your Data Before Writing a Prompt

Imagine a spreadsheet containing the following columns:

Date	Product	Units Sold	Unit Price
01 Oct	Notebook	20	50
02 Oct	Pen	35	10
03 Oct	Folder	12	40

The table contains sales information, but it does not yet calculate total revenue.

The formula for revenue in each row is:

=C2*D2

If column C contains Units Sold and column D contains Unit Price, this formula multiplies the quantity by the price for that row.

For example, the first row's revenue is (20 \times 50 = 1{,}000).

4. Ask Gemini to Generate a Formula

Prompt:

"I have a Google Sheets table with these columns: Date in column A, Product in column B, Units Sold in column C, and Unit Price in column D. Write a formula for cell E2 that calculates total revenue for the row. Explain the formula and tell me how to apply it to the remaining rows."

A suitable formula is:

=C2*D2

To calculate revenue for additional rows, fill the formula down column E or use an appropriate array formula after checking that the data layout supports it.

5. Common Spreadsheet Formulas

The following are standard Google Sheets formulas that Gemini can help explain or adapt.

Calculate a total

=SUM(E2:E100)

Adds the values in cells E2 through E100.

Calculate an average

=AVERAGE(C2:C100)

Calculates the average of the numeric values in that range.

Count non-empty cells

=COUNTA(B2:B100)

Counts non-empty cells in the specified range.

Count rows matching a condition

=COUNTIF(B2:B100,"Notebook")

Counts cells in the range that contain the specified product name.

Calculate revenue only for a particular product

=SUMIF(B2:B100,"Notebook",E2:E100)

Adds the values in column E for rows where column B contains "Notebook."

These examples assume that the spreadsheet uses the specified column layout. Adjust ranges and criteria to match your own data.

6. Ask Gemini to Explain a Formula

You do not need to memorize every formula. You can ask Gemini to explain a formula in plain language.

Prompt:

"Explain this Google Sheets formula to a beginner: =IF(C2>=50,"Target Achieved","Below Target"). Explain what each part does and provide two examples showing the possible results."

The formula checks whether the value in C2 is greater than or equal to 50. If the condition is true, it returns "Target Achieved"; otherwise, it returns "Below Target."

7. Analyze Data with Gemini

Suppose you have monthly sales data and want to understand which products perform best.

Prompt:

"Analyze the following sales table. Identify the highest-revenue product, the lowest-revenue product, and any noticeable patterns. Show the calculations behind your conclusions. If the data is insufficient to support a conclusion, state that clearly.

[Paste the relevant table or provide a suitable data extract]"

For reliable results:

1. Provide column names and relevant rows.

2. Explain what each column represents.

3. Specify whether the figures represent units, revenue, costs, or profit.

4. Ask for calculations or evidence supporting each conclusion.

5. Verify the calculations in Google Sheets.

Do not assume that the highest sales revenue automatically means the highest profit. Profit requires cost information as well.

8. Clean and Organize Spreadsheet Data

AI can help identify possible data-quality problems, such as:

• Inconsistent spelling in category names.

• Blank cells.

• Duplicate records.

• Dates stored in inconsistent formats.

• Numbers stored as text.

• Leading or trailing spaces.

• Inconsistent capitalization.

Prompt:

"Review the structure of this spreadsheet data and identify possible data-quality issues. Suggest safe ways to detect duplicates, inconsistent category names, blank values, and invalid dates. Do not delete or alter any records. Explain how I can review the suggested corrections before applying them.

[Provide a representative data sample]"

Always make a backup before applying bulk changes to important data.

9. Create a Summary Table

Suppose you have a list of products, sales dates, quantities, and prices.

You can ask Gemini:

"Suggest a summary table for this sales dataset. I want total units sold, total revenue, average revenue per transaction, and revenue by product. Identify the required formulas or pivot-table setup. Explain which columns should be used for each calculation."

Depending on the dataset, a pivot table may be more appropriate than a set of individual formulas.

10. Use Gemini to Troubleshoot Formula Errors

If a formula produces an error, provide the formula, a description of the relevant columns, and the expected result.

Prompt:

"My Google Sheets formula is returning an error. Here is the formula: [paste formula]. The relevant columns are [describe columns]. I expected the result to be [expected result], but I received [error or actual result]. Explain the likely causes and suggest a corrected formula. Do not assume any missing cell values."

Before replacing a formula, test the proposed correction on a small sample and confirm that it handles blank cells and unexpected values appropriately.

11. Spreadsheet Best Practices

• Keep column headers descriptive and consistent.

• Use the correct data type for dates, numbers, and currencies.

• Verify formulas using known sample values.

• Check whether formulas include all relevant rows.

• Avoid sharing sensitive customer or employee records unnecessarily.

• Use copies or backups before performing bulk changes.

• Distinguish correlation from causation when interpreting trends.

• Validate important business calculations independently.

12. Practical Exercise

Task: Create a sales tracker with these columns:

• Date

• Product

• Units Sold

• Unit Price

• Total Revenue

Enter at least five sample transactions. Then use Gemini to help you:

1. Create the revenue formula.

2. Calculate total revenue.

3. Calculate average units sold.

4. Find the product with the highest revenue.

5. Identify at least one possible data-quality issue.

Verify each formula and conclusion in Google Sheets.

13. Topic Summary

Gemini can make spreadsheet work easier by helping users write formulas, understand data structures, troubleshoot errors, and explore patterns. However, spreadsheet accuracy depends on correct source data, suitable formulas, and independent verification.

---

Topic 24: How to Use Gemini in Google Slides to Plan and Improve Presentations

1. Introduction

Google Slides helps users create presentations for education, business meetings, training sessions, project proposals, and marketing campaigns.

Gemini can assist with presentation planning by generating outlines, suggesting slide titles, simplifying complex information, creating speaker notes, and improving written content. Depending on the account and available features, some assistance may be integrated directly into Google Slides.

Even when direct integration is unavailable, you can use the Gemini app to prepare the presentation structure and then build or edit the slides in Google Slides.

2. What Can Gemini Help You Do in Google Slides?

Common use cases include:

• Creating a presentation outline from a topic.

• Organizing information into logical sections.

• Suggesting slide titles and key points.

• Simplifying lengthy paragraphs into concise bullets.

• Drafting speaker notes.

• Suggesting charts and diagrams.

• Improving slide wording and consistency.

• Adapting presentations for different audiences.

• Preparing training presentations and educational lessons.

• Reviewing whether a presentation has a clear beginning, middle, and conclusion.

Generated content should be checked for factual accuracy, relevance, and appropriate slide length.

3. Plan a Presentation with Gemini

Step 1: Define the presentation goal

Determine what your audience should understand, learn, or decide after viewing the presentation.

Step 2: Describe the audience

A presentation for school students should be different from a business presentation for potential investors.

Step 3: Set the slide count

Specify the number of slides and the expected presentation duration.

Step 4: Request an outline

Ask Gemini to provide a title, objective, and key points for every slide.

Step 5: Review the structure

Check whether the presentation flows logically and avoids unnecessary repetition.

Step 6: Build the slides

Use the available Slides features or transfer the outline into Google Slides manually.

4. Practical Example: Create a Presentation on Digital Marketing

Prompt:

"Create a 10-slide presentation outline titled 'Introduction to Digital Marketing' for beginners. The audience consists of small business owners who have limited marketing experience. For each slide, provide a title, three concise bullet points, and a suggested visual. Include an introduction, major digital marketing channels, a simple campaign example, common mistakes, and a conclusion. Avoid unsupported statistics and keep the language simple."

A useful outline might include:

1. Title and learning objectives.

2. What digital marketing means.

3. Understanding the target audience.

4. Search engine optimization.

5. Social media marketing.

6. Content marketing.

7. Email marketing.

8. Planning a simple campaign.

9. Common mistakes and measurement.

10. Key takeaways and next steps.

The outline is a starting point. You can change the slide order or add verified business examples to fit your audience.

5. Turn Long Text into Slide-Friendly Content

Presentations should communicate key ideas quickly. Long paragraphs are usually difficult to read on a slide.

Prompt:

"Rewrite the following content for a presentation slide. Create a clear title and no more than four concise bullet points. Keep each bullet short, preserve the essential meaning, and do not introduce new facts.

Content:
[Paste your text]"

If the source material is technical, ask Gemini to preserve important terms and provide a simpler explanation in the speaker notes.

6. Generate Speaker Notes

Speaker notes can help presenters explain the slide without filling the slide itself with excessive text.

Prompt:

"Write speaker notes for the following presentation slide. The audience is new to the topic. Use a natural speaking style and provide an explanation that takes approximately 45–60 seconds to deliver. Include one practical example. Do not repeat the slide bullets word for word.

Slide title: [Title]
Slide bullets:
[Paste the bullets]"

Read the notes aloud and adjust them to match your speaking style and the time available.

7. Improve Presentation Design

Gemini can help you plan the content and suggest design improvements, but you should still evaluate the actual slides visually.

Prompt:

"Review this presentation outline for clarity and visual consistency. Recommend an appropriate layout for each slide, including where to use a diagram, comparison table, timeline, or chart. Suggest a consistent typography and color approach. Prioritize readability and avoid decorative elements that distract from the message."

When applying the suggestions in Google Slides:

• Use a consistent theme.

• Keep text large enough to read.

• Use clear slide titles.

• Limit each slide to a manageable number of key points.

• Use charts only when the data supports them.

• Maintain sufficient contrast between text and background.

• Use images and icons that support the message.

• Avoid overcrowding slides with decorative elements.

8. Use Gemini to Suggest Visuals and Diagrams

Visuals can make complex topics easier to understand.

For example, a presentation about website development may benefit from:

• A process diagram showing the development stages.

• A timeline showing major milestones.

• A comparison table of website features.

• A flowchart explaining how a contact form works.

• A chart based on verified project data.

Prompt:

"For a presentation explaining the website development process, suggest one suitable visual for each of these stages: planning, design, development, testing, launch, and maintenance. Describe the purpose of each visual and provide a simple layout that can be recreated in Google Slides."

Use accurate data and properly licensed assets where needed.

9. Create a Training Presentation

Training presentations require a clear learning sequence and practical examples.

Prompt:

"Create a 12-slide training presentation for beginners learning Google Sheets. Include learning objectives, the spreadsheet interface, entering data, basic formulas, common functions, formatting, sorting and filtering, charts, practical exercises, common mistakes, a recap, and a short knowledge check. For each slide, provide a title, concise bullets, and speaker notes. Use beginner-friendly language."

Review the result to ensure that the presentation teaches the topic in a logical order and includes accurate instructions.

10. Improve an Existing Presentation

If you already have a presentation, Gemini can help you review its outline or the slide content you provide.

Prompt:

"Review the following presentation content. Identify slides that are repetitive, confusing, overly detailed, or missing essential information. Recommend a revised slide order and suggest concise wording for the most important slides. Preserve verified facts and clearly identify any information that needs confirmation.

Presentation content:
[Paste slide titles and text]"

For visual feedback, use a feature that can actually access the presentation or provide relevant screenshots or slide content when appropriate. Do not assume that a separate Gemini chat can automatically see every file in your Google Drive.

11. Presentation Quality Checklist

Before presenting, verify that:

• The presentation has a clear purpose.

• The opening explains what the audience will learn.

• The slide order is logical.

• Each slide communicates one main idea.

• All figures, quotations, and claims are accurate.

• Charts have clear labels and appropriate units.

• Text and visuals are readable.

• Speaker notes support rather than duplicate the slide content.

• The conclusion reinforces the main message.

• No confidential information is accidentally exposed.

12. Practical Exercise

Task: Create a presentation titled "How Small Businesses Can Use AI Tools."

Your presentation should include:

1. Title and objectives.

2. An introduction to AI tools.

3. Three practical business use cases.

4. An example of AI-assisted email writing.

5. An example of AI-assisted content creation.

6. An example of spreadsheet assistance.

7. Limitations and responsible use.

8. A conclusion and next steps.

Use Gemini to develop the outline and speaker notes. Build the slides in Google Slides, then review the final presentation for accuracy, readability, and consistency.

13. Topic Summary

Gemini can support presentation planning, content refinement, speaker notes, and visual organization. The most effective presentations combine AI-assisted preparation with human judgment, accurate information, and clear visual communication.

---

Module 6: Final Revision

This module covered four important Google Workspace applications and how Gemini can support work within them.

Application	Main tasks	Expected benefit
Gmail	Drafting, rewriting, follow-ups, summaries	Clearer and more efficient communication
Google Docs	Drafting, summarizing, editing, structuring	Better-organized documents
Google Sheets	Formula assistance, troubleshooting, data exploration	More efficient spreadsheet work
Google Slides	Outlines, slide content, speaker notes, design planning	Clearer and better-structured presentations

Essential Principles

1. Write specific prompts. Include the purpose, context, audience, constraints, and expected output.

2. Verify the results. Check facts, calculations, dates, formulas, and business commitments.

3. Protect sensitive information. Follow applicable privacy policies and account settings.

4. Use the right tool. Select the Workspace application that matches your task.

5. Understand feature availability. Direct Gemini integration is not guaranteed for every account or subscription.

6. Keep human oversight. You remain responsible for final emails, documents, calculations, and presentations.

---

Module 6: Final Assessment

Answer the following questions to check your understanding.

Question 1

What information should you provide when asking Gemini to draft a professional email?

A. Only the recipient's name
B. The purpose, relevant context, key details, and preferred tone
C. Only the word "Email"
D. No instructions

Question 2

What should you do before sending an AI-generated email?

A. Send it immediately
B. Assume all facts are correct
C. Review the message, verify its details, and check the recipient
D. Remove the subject line

Question 3

Which task is suitable for Gemini in Google Docs?

A. Summarizing a document
B. Improving sentence clarity
C. Turning notes into structured content
D. All of the above

Question 4

What does the formula =C2*D2 calculate when C2 contains units sold and D2 contains unit price?

A. Total revenue for the row
B. Average revenue
C. Number of products
D. Total number of rows

Question 5

Why should you verify AI-generated spreadsheet formulas?

A. All AI formulas are guaranteed to be correct
B. Incorrect ranges or assumptions can produce wrong results
C. Formulas never depend on cell references
D. Verification is unnecessary for business data

Question 6

What is the best way to use Gemini when planning a presentation?

A. Ask it to create unrelated facts
B. Specify the topic, audience, objective, and slide count
C. Put every paragraph on one slide
D. Avoid reviewing the outline

Question 7

Why should presentation slides avoid excessive text?

A. It makes the content harder to read and understand
B. It guarantees better accuracy
C. It improves every chart automatically
D. It removes the need for speaker notes

Question 8

Are Gemini features inside Gmail, Docs, Sheets, and Slides available to every Google account?

A. Yes, without restrictions
B. No, availability depends on factors such as account eligibility, plan, region, and settings
C. Only to users who never use Google Workspace
D. Yes, even if an administrator disables them

Question 9

What should you do before applying AI-suggested bulk changes to important spreadsheet data?

A. Delete the original records
B. Apply every change without checking
C. Make a backup and review the proposed changes
D. Remove the column headers

Question 10

Who is ultimately responsible for reviewing and approving AI-generated work?

A. The AI tool alone
B. The recipient of the document
C. The person using and sharing the content
D. Nobody

Answer Key

1. B

2. C

3. D

4. A

5. B

6. B

7. A

8. B

9. C

10. C

---

Module 6: Final Practical Project

Project Title: Complete a Small Business Workflow with Gemini and Google Workspace

Project Objective

Demonstrate how Gemini can assist with everyday business communication, documentation, spreadsheet calculations, and presentation planning.

Task 1: Gmail

Prepare a professional email inviting a client to a project discussion. Include a subject line, proposed meeting dates, and a polite closing.

Task 2: Google Docs

Create a one-page project brief with the project objective, scope, key tasks, potential risks, and next steps.

Task 3: Google Sheets

Create a simple five-row sales tracker. Use formulas to calculate revenue per transaction and total revenue. Verify the results manually.

Task 4: Google Slides

Create a five-slide presentation summarizing the project brief and sales results. Include a title slide, objectives, key findings, recommendations, and next steps.

Task 5: Quality Review

Before completing the project, verify:

• All factual claims and figures.

• Email tone and recipient details.

• Document structure and clarity.

• Spreadsheet formulas and totals.

• Presentation readability and visual consistency.

• Appropriate handling of sensitive information.

Completion Criteria

You have completed this module when you can use Gemini to assist with all four applications, explain how the prompts work, and independently review the resulting content.

Conclusion

Google Gemini can be a useful productivity assistant across Google Workspace. It can help you draft emails, improve documents, understand spreadsheet formulas, and prepare presentations. However, useful results depend on clear instructions, accurate source information, appropriate feature access, and careful human review.