Announcing my textbook -- Google Drive Essentials.  It is aimed at the grades 4-8 but appropriate for beginners of all ages. I use these lessons in my own teaching so they are classroom tested. Each lesson includes instruction, a tutorial and an activity. 

An update is scheduled for Summer 2017 which will include interface updates rolled about by Google since the book launched. 

 

Here's a sample lesson and assessment:

FOR EVALUATION PURPOSES ONLY. DO NOT COPY.

Known Errata (short list of small errors)


Google Drive Essentials Textbook

WHAT'S INSIDE

Getting Started With Google Drive

Word Processing - Google Docs

  • Lesson 1: Let’s Get Word Processing

  • Lesson 2: Print Options

  • Lesson 3: Find/Replace and Spell Check

  • Lesson 4: Selecting Text, Cut/Copy/Paste, Drag/Drop Editing

  • Lesson 5: Working with Fonts

  • Lesson 6: Paragraph Indents

  • Lesson 7: Paragraph Line Spacing

  • Lesson 8: Paragraph Justification

  • Lesson 9: Tabs

  • Lesson 10: Adding a Graphic Object

  • Lesson 11: Page Settings

  • Lesson 12: Tables

Spreadsheets - Google Sheets

  • Lesson 1: Exploring a Spreadsheet

  • Lesson 2: Simple Formulas and Functions

  • Lesson 3: Copy Formulas, Insert Columns and Rows

  • Lesson 4: Max, Min, and Average Functions

  • Lesson 5: Absolute References

  • Lesson 6: Format Text and Cells

  • Lesson 7: Borders and Conditional Formatting, Hide Gridlines

  • Lesson 8: Formulas Using Dates

  • Lesson 9: Data Sort

  • Lesson 10: Create a Chart (Same Worksheet)

  • Lesson 11: Create a Chart (On Its Own Worksheet)

  • Lesson 12: Using a Form to Populate a Spreadsheet

 

 

Presentations - Google Slides

  • Lesson 1: Getting Started With Presentations

  • Lesson 2: Spell Check, Duplicate, Reorder, and Delete Slides

  • Lesson 3: Images, WordArt, Change Background

  • Lesson 4: Transitions, Animations, and Viewing Slideshows

  • Lesson 5: Working with Tables on Slides

  • Lesson 6: Speaker Notes

  • Lesson 7: Buttons and Hyperlinks

Graphics - Google Drawings

  • Lesson 1: Basic Shapes, Lines and Line Styles

  • Lesson 2: Draw, Duplicate, Rotate and Manipulate Complex Graphic Objects

  • Lesson 3: Alignment

  • Lesson 4: Stacking Order