LibGuides: Digital Literacy: Google

Using Google

In this free tutorial, learn everything you need to set up and maintain a Google account to use services like Gmail.

5 Lessons - Written instruction - Videos - Interactive Activities - Beginner

Google provides a number of web-based solutions for individuals, schools, and businesses, from file storage and backup to spreadsheets and presentations.

Written instruction - Beginner-Advanced

Google Tips

In this free tutorial, learn how to search, create surveys, book flights, translate text, and do more with Google.

8 Lessons - Written instruction - Videos - Interactive Activities - Intermediate

Google Workspace: Drive

Learn to organize, manage, and share files in Drive.

By the end of this lesson, students should be able to:

Copy, delete, download, and upload files in Drive
Create and manage folders in Drive
Change the display and settings for Drive
Share files and folders with others and change sharing permissions
Locate files and folders using keyword searches and other advanced search tools

1 Lessons - 45-90 minutes - Videos - Activities - Beginner

Google Drive

In this free tutorial, learn how to use this cloud-based program to create and share documents, spreadsheets, presentations, and more.

10 Lessons - Written instruction - Videos - Interactive Activities - Beginner

Google Drive Guides

Tech Life Unity is a free-to-use educational website that teaches technology users of all ages and skill levels how to use technology, especially the most popular websites, apps, and online tools. We provide clear, easy-to-understand instructions in online tutorials on our website, and in videos on our YouTube channel.

Written Guides - Beginner

Google Workspace: Gmail

Learn the basic components of Gmail to help you send and receive emails.

By the end of this lesson, students should be able to:

Practice using features and settings in Gmail
Use Gmail to communicate in different ways

1 Lessons - 45-90 minutes - Videos - Activities - Beginner

Gmail

In this free tutorial, get an introduction to Gmail and learn how to manage, send, and respond to messages.

9 Lessons - Written instruction - Videos - Interactive Activities - Beginner

Google Workspace: Docs Part 1

Learn to edit and format a document.

By the end of this lesson, students should be able to:

Practice using tools, settings, and other features in Google Docs
Edit and adjust the content and settings of a document to prepare it for sharing and collaboration

1 Lessons - 45-90 minutes - Videos - Activities - Beginner

Google Workspace: Docs Part 2

Learn tools and settings for working in a document.

By the end of this lesson, students should be able to:

Practice using tools, settings, and other features in Google Docs
Edit and adjust the content and settings of a document to share, collaborate on, and download the document

1 Lessons - 45-90 minutes - Videos - Activities - Beginner

Google Docs

In this free tutorial, learn how to use this free cloud-based program for creating professional documents.

37 Lessons - Written instruction - Videos - Interactive Activities - Intermediate

Docs

Users will need a Northstar learning account, and the ability to navigate a mock computer screen within a webpage. Direct learners to take the assessment for the course they want, and that at the end of he assessment personalized lessons will appear on the course dashboard.

Skills Assessment - Interactive video lessons and practice - Beginner Content - Intermediate Format - Certificate available

Google Workspace: Sheets Part 1

Build, organize, and format a spreadsheet using Google Sheets.

By the end of this lesson, students should be able to:

Edit and organize a spreadsheet to track sales data for a community fundraiser
Edit raw data so it's more meaningful and useful
Organize raw data with sorting, formatting, and data validation

1 Lessons - 45-90 minutes - Videos - Activities - Intermediate

Google Workspace: Sheets Part 2

Evaluate and interpret data with different spreadsheet functions, filters, and charts using Google Sheets.

By the end of this lesson, students should be able to:

Use advanced functions and filters to analyze and calculate data
Insert charts to isolate and display data
Share and collaborate in a spreadsheet

1 Lessons - 45-90 minutes - Videos - Activities - Advanced

Google Workspace: Sheets Part 3

Use advanced functions and conditional formatting in Google Sheets.

By the end of this lesson, students should be able to:

Use advanced functions to calculate cost, revenue, and profit
Combine other file formats with spreadsheets in Google Sheets
Use conditional formatting to emphasize specific data

1 Lessons - 45-90 minutes - Videos - Activities - Advanced

Google Sheets

In this free tutorial, learn how to use the powerful tools in Google Sheets for organizing, visualizing, and calculating data in a spreadsheet.

19 Lessons - Written instruction - Videos - Interactive Activities - Intermediate

Google Workspace: Slides Part 1

Learn presentation themes, text, and transitions using Google Slides.

By the end of this lesson, students should be able to:

Create a presentation, including slide layouts, themes, text, transitions and animations, speaker notes, and slide numbers
Learn the basic functions of Google Slides in order to improve workplace presentation and communication skills

1 Lessons - 45-90 minutes - Videos - Activities - Beginner

Google Workspace: Slides Part 2

Learn how to add photos, images, videos, and shapes to a presentation.

By the end of this lesson, students should be able to:

Add images from the web and from Google Drive to a presentation
Format images to create visually interesting slides
Link and embed videos in a presentation
Create and format lines and shapes on a slide

1 Lessons - 45-90 minutes - Videos - Activities - Intermediate

Google Workspace: Slides Part 3

Learn how to add tables, diagrams, and charts, and share your presentation.

By the end of this lesson, students should be able to:

Organize data in Google Slides using visual tools like charts, diagrams, and tables
Communicate their ideas in digital form and hard copy by sharing their presentation

1 Lessons - 45-90 minutes - Videos - Activities - Intermediate

Google Slides

In this free tutorial, learn how to use this free cloud-based program for creating professional presentations.

26 Lessons - Written instruction - Videos - Interactive Activities - Intermediate

Google Maps

In this free tutorial, get answers to common questions about using the popular Google Maps program.

4 Lessons - Written instruction - Videos - Interactive Activities - Intermediate

Introduction to Google Maps

Learners will be introduced to the many different functions of Google Maps as a way to find locations and directions to destinations, and using different methods of transportation. Learners will:

Practice searching and getting directions
Explore locations using different map views
Manipulate the map using the mouse
Review various functions and information displayed in the knowledge pane.

5 Videos - 15 minutes - Intermediate - Download of lesson slides

Google Maps Guides

Written Guides - Beginner

Google Voice Guides

Written Guides - Beginner