ITEM #: TB-GDS-iA

The Google Docs Specialist

Real-world, client-based Google Apps projects

In The Google Docs Specialist, students act as the in-house Google Apps Specialist and are given three clients who have come to The Google Docs Specialist, Inc. for their services. The projects are introduced just as they would be in a real business environment. Students receive “work order forms” that include a set of instructions from their clients. Students are challenged to use five of the most popular Google productivity apps (Docs, Sheets, Slides, Drawings, and Forms) to complete each project.

Benefits & Features

Includes over 35 easy-to-follow lessons
Format simulates real business work orders for students to complete
Challenges students to use critical thinking and decision-making skills
All Assignments Submitted Online (from Student Portal to Instructor Portal)
No textbooks or paper required

Sample Lessons

View Table of Contents

Project 1

Customer Satisfaction and Return Policy

View

Project 2

Business Letterhead

View

Project 3

Business Memo

View

View Print/eBook Version »

Included with Your Purchase

24/7 access from anywhere, any device
Project Solutions
Client Logos

Specifications

Grade: 6-8, 9-12

Item #: TB-GDS-iA

ISBN: 978-1-626891-39-5

Author: Courtney Snyder

Introduction

Part 1 Welcome to The Google Docs Specialist

Preview

Part 2 Getting to Know Your Clients

Preview

Unit 1: Docs

Project 1 Customer Satisfaction and Return Policy View Skills

Preview

Skills

Create and rename a document
Insert a horizontal line
Format text
Use print preview
Share a document
Assign permissions

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Project 2 Business Letterhead View Skills

Preview

Skills

Set margins
Use headers and footers
Insert and resize a logo
Insert a horizontal line
Align text

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Project 3 Business Memo View Skills

Preview

Skills

Insert and resize a logo
Align text
Insert a horizontal line
Format text
Format a memo

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Project 4 Price List View Skills

Skills

Insert and resize a logo
Align text
Create a table
Change border style
Resize column width
Format text
Change column background color

Project 5 Block Style Letter View Skills

Skills

Copy an existing Google document
Edit text
Format a block style letter
Use spell check

Project 6 Menu Items List View Skills

Skills

Set margins
Change page color
Insert a table
Resize column width
Merge cells
Insert and resize an image
Align an image
Insert word art
Indent text in a table
Remove table borders

Project 7 Fax Cover Page View Skills

Skills

Insert a drawing
Insert word art
Insert a horizontal line
Insert and resize an image
Insert a table
Resize column width
Use bullets
Change shape fill color
Change shape line weight
Download as a PDF

Project 8 MLA Style Report View Skills

Skills

Format an MLA style report
Insert page numbers
Align text
Change line spacing
Insert page break
Insert a header

Project 9 News Release View Skills

Skills

Insert an image
Wrap text
Format and align text
Format a news release
Change line spacing
Use tab indent
Use find and replace
Use word count

Project 10 Waiver and Release of Liability Form View Skills

Skills

Change margins
Insert a header
Insert and resize an image
Align text
Set tabs
Use automatic numbering
Insert page numbers
Insert page break

Project 11 College Visit Schedule View Skills

Skills

Insert a table
Resize column width
Change fill color
Insert hyperlinks

Project 12 Employee Application View Skills

Skills

Format and align text
Insert and resize an image
Insert a table
Merge cells
Change fill color

Project 13 Newsletter Article View Skills

Skills

Insert page numbers
Insert a page break
Insert bookmarks
Add hyperlink text to bookmarks

Project 14 Cyberbullying Posts View Skills

Skills

Insert a table
Collaborate using Google Docs
Use comments
See revision history
Show more detailed revisions

Project 15 Sporting Goods Equipment List View Skills

Skills

Collaborate using Google Docs
Insert and resize an image
Insert a table
Use bullets
Use comments

Unit 2: Sheets

Project 16 Employee Contact Information View Skills

Skills

Create a new spreadsheet
Rename a spreadsheet
Resize column width
Enter data into a spreadsheet
Format text
Change fill color
Set print area
Print preview
Share a spreadsheet
Assign permissions

Project 17 Quarterly Donor Data View Skills

Skills

Merge cells
Insert an image
Format text
Align text
Format as currency
Decrease decimal places
Use the SUM function
Use Autofill
Add fill color
Add a cell border

Project 18 Menu Items Annual Sales View Skills

Skills

Format text
Align text
Format as currency
Decrease decimal places
Use the SUM function
Use the MIN and MAX functions
Use Autofill
Create and customize a pie chart

Project 19 New Product Sales View Skills

Skills

Format text
Align text
Sort data
Use the Count function
Freeze rows

Project 20 Monthly Blog Traffic View Skills

Skills

Format text
Align text
Use Autofill
Create and customize a line chart
Use the MIN and MAX functions
Use the AVERAGE function
Decrease decimal places
Add a new sheet
Rename a sheet

Project 21 Annual Sales Forecast View Skills

Skills

Format text
Align text
Merge cells
Resize column width
Format as a number
Format as a percentage
Decrease decimal places
Use the SUM function
Use Autofill
Use absolute cell reference
Use cell borders

Project 22 Grand Opening Budget View Skills

Skills

Format text
Align text
Format as currency
Use formulas
Use the SUM function

Project 23 Social Media User Survey View Skills

Skills

Format text
Align text
Merge cells
Add fill color
Create and customize a column chart

Project 24 Customer Traffic Pattern Analysis View Skills

Skills

Collaborate using Google Sheets
Align text
Format text
Create and customize a bar chart
Use Autofill
Add a new sheet
Rename a sheet
Use comments

Unit 3: Slides

Project 25 Customer Service Training View Skills

Skills

Choose a theme
Insert and resize an image
Create a bulleted list
Create a numbered list
Change line spacing
Present a slideshow
Print preview a presentation
Share a presentation

Project 26 Classroom Device Guide View Skills

Skills

Insert and resize an image
Insert a table
Apply transitions
Present a slideshow

Project 27 Digital Menu Sign View Skills

Skills

Insert word art
Insert shapes
Insert and resize an image
Change fill and line color
Change line weight
Apply transitions
Add animation
Present a slideshow

Project 28 Camping Tent Clearance Display View Skills

Skills

Use color as background
Use an image as background
Insert word art
Insert and resize an image
Mask an image
Add an image border
Apply transitions
Present a slideshow

Project 29 Website Credibility Presentation View Skills

Skills

Insert and resize an image
Order objects on a slide
Use image options
Copy and paste an image
Duplicate a slide (optional)
Insert hyperlinks
Apply transitions
Present a slideshow

Project 30 Food Preparation Safety Presentation View Skills

Skills

Collaborate using Google Slides
Insert a video
Use comments
Present a slideshow

Unit 4: Forms

Project 31 Customer Satisfaction Survey View Skills

Skills

Add a form description
Add multiple question types
Add hint text
Choose a theme
View a live form
Accept responses
View responses
Format responses spreadsheet
Share responses
Send a form

Project 32 Cyber Safety Quiz View Skills

Skills

Use form settings
Add a form description
Add multiple question types
Require a response
Add help text
Insert a page break
Edit confirmation page
Choose a theme
View a live form
Send a form

Project 33 Smoothie Contest Voting Ballot View Skills

Skills

Add a form description
Add hint text
Edit confirmation page
Change color palette
View a live form
Accept responses
Submit responses to a form
View a summary of responses
Share responses
Send a form

Unit 5: Drawings

Project 34 Store Map View Skills

Skills

Change background color
Insert and format word art
Insert and resize an image
Insert and resize shapes
Insert and format text
Download as a PDF document

Project 35 Safe Surfing Pledge Poster View Skills

Skills

Use custom page size
Change background color
Insert and format word art
Insert and resize an image
Insert and format text
Download as a JPEG image

Project 36 Promotional Reward Card View Skills

Skills

Insert and format word art
Insert and resize an image
Insert and format text
Insert and resize a shape
Group objects
Use custom page size
Download as a SVG image

Project 37 Logo Redesign View Skills

Skills

Insert and format text
Insert and format word art
Use line tools
Use shapes
Group objects
Download as a PNG image

Web-based Career & Technical Education

The Google Docs Specialist

Real-world, client-based Google Apps projects

Benefits & Features

Sample Lessons

Included with Your Purchase

Specifications

Introduction

Unit 1: Docs

Unit 2: Sheets

Unit 3: Slides

Unit 4: Forms

Unit 5: Drawings