Create, Collaborate & Work Dynamically Online in Google Apps

A complete hands-on guide to using; Google Drive, Classroom, Docs, Slides, & Forms to engage users and improve workflow.
4.8 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,105 students enrolled
Take This Course
  • Lectures 20
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2014 English

Course Description

With 850 students in the first five weeks after being published, this course in Google Apps has shown to be of tremendous value. It is a comprehensive course for all-levels of users, and is updated regularly as Google releases new features to the Google Apps Suite.

In this course I introduce the concept of Cloud Computing, Google Drive, and the Google Apps suite of tools for an educational environment. In this course, I will address how to get started using Google Drive as a storage for digital files of any kind like; pictures, audio, video, MS Word, Keynote, PDF, and so on. This course will cover the use of:

  • Google Docs
  • Google Sheets
  • Google Slides
  • Google Forms
  • Google Classroom (coming soon)

For the most part, the approach this course takes is for teachers in a classroom setting, but as you will see, all the tools can be used by anyone wanting to use cloud-based applications for writing, collaborating, collecting and analyzing data, and sharing resources.

The structure and design of this course is based on real-world classroom environments where students are asked to complete and work on projects in a digital world. The Google Apps for Education suite of tools provides an opportunity for teachers to connect with students outside of class, and to offer students the ability to collaborate with one another in the Cloud.

This course uses video, screencast lessons, links to external videos and websites, and also has some projects for you to complete. The project files are structured as step-by-step manuals with a variety of challenges for you to complete. They will test what you have learned in each of the lessons. There is one project per section in the course on each of the four major Google Apps.

This course is best completed in about a week. Assuming that you will work an hour or so a day, it should be easy to complete all of the lessons and projects within one week.

Teachers or faculty and staff looking to engage students in using digital tools for classroom activities will benefit tremendously from the lessons and projects in this course. Anyone looking to level-up their use of Google's suite of digital tools will find these activities of particular value.

This course is designed for all levels.

This course was last updated 10/16/2014

What are the requirements?

  • An accessible Google Account. Preferrably a Google Apps for Education account, or Google Apps for Business account with access to; Google Gmail, Drive, Docs, Sheets, Slides, and Forms.

What am I going to get from this course?

  • Students will learn how to create Google: Documents, Spreadsheets, Slides, and Forms.
  • Participants will learn to create, share, collaborate, and publish docs, spreadsheets, presentations and forms.
  • Create a form to collect data, analyze it and produce meaningful reports
  • By the end of this course, students will be able to understand what cloud computing is, and how Google Drive is stores your content for retrieval from anywhere in the world.
  • Students will be able to share digital files with other users, for the purpose of collaboration, peer review and commenting, or data analysis
  • In this course, students will learn to use Google Drive as a cloud-based storage and preview system for all their digital content.
  • Students will learn to use the Google Drive application to sync cloud content with their local computer.

Who is the target audience?

  • Anyone using Google Apps for business will be able to increase productivity and save time using the Google Apps suite.
  • This course is designed for classroom teachers new to working with the Google Apps for Education platform.
  • This course is comprehensive, and includes basic overviews and intermediate to advanced features.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Getting Started

"The Cloud", or "Cloud Computing" is a big term in technology these days. "The Cloud" is used by just about everyone in their favorite social media apps, to online storage, streaming media, and file backups. In this lecture, I explain what the cloud is, and how you access it with your favorite devices and apps. The lecture also covers what Google Drive is and how it relates to "The Cloud".

Is my data safe?

Adding some additional security is never a bad thing! If you are concerned about the information contained in your Google Drive, GMail, or other Google Apps, you should consider adding 2-Step Verification to all your Google accounts. 2-Step Verification is a way to secure access to your account on new, public, or unauthorized devices. With 2-Step Verification, you can add another layer of protection using your mobile phone.

If someone tries to log in as you from a computer or app, they will need to enter a one-time access code. The code will be sent to your mobile phone, and expires quickly. Without the code, unauthorized access is prevented. Get protected - secure your info!


Let's get going! In this overview, I show you how to establish an account, and access Google Drive and Google Apps. This tutorial is a basic walkthrough of the Apps architecture starting with Google Drive. Since Google has changed much of the orientation of Google Apps in the last few years, the idea now is to create and manage all of your Apps files from your Google Drive account.

You can think of your Google Drive account like your local computer's hard drive, but in the cloud. That is, when you store files from a program like Microsoft Word, or PowerPoint, you need to put those files on your computer somewhere. In MyDocuments, or the Desktop, or wherever, those files need to be saved and stored on the hard drive. Unfortunately, those files are 'stuck' on that computer. To access them remotely is complicated. To move them to another computer, you need some kind of device like a flash drive, or some kind of transfer mechanism, like email or cloud-storage to make this happen. It gets a little hard to manage some times.

Google Drive takes the mystery out of all of this by creating a 'hard drive', or a storage drive online that is accessible from anywhere, and from any device with an internet connection. Google Drive can be used to store Google Apps files, as well as any other file type you need to store for easy retrieval.

This orientation will show you how to access your Google Drive, some ideas for staying organized, and getting the most our of your Google Drive account.

3 questions

Let's see what you remember!

Section 2: Using "The Big 3": Docs, Sheets, and Slides

Let's take a look around the Google Docs screen, look at an overview of the tools, menus, and options. In this lecture we will address setting up a document and folders on Google Drive as well.


Now let's make something. In this lesson, we will create a Document, add a title, some text, an image, and get the text to wrap. We will explore the Research Pane, and also look at Sharing Options and Making Comments. This lecture covers some of the basics of creating, modifying, sharing, commenting and collaborating on a live Google Doc.

3 questions

What do you remember about Google Docs Training? Take a short review quiz.

1 page

Test what you have learned in the first few lectures of this course by completing this simple and thorough project. Create a document you can manipulate, share and maybe even publish to the web.


Learn to make Google Docs even more flexible and useful - especially in the classroom environment. Use EasyBib as an Add-On to Google Docs for creating bibliography pages, works cited, and use common formats like APA, MLA, or Chicago.


Introduction to the workings of Google Sheets as a cloud-based alternative to Excel. In this lesson we look at some of the basic tools to create, format, import and export data using Excel and Google Sheets. Basic menu bars and options are addressed.


In this lesson, we will look at how to use the formula bar, the auto-sum, and average formulas with existing data. We will also look at how to extend the use of the Google Sheets syntax to write your own formulas. Uploading and importing Excel-based functions is also addressed.

3 questions

Google sheets is very much like Excel, but how are they different? Let's review...

2 pages

After you have studied the basics of using Google Sheets, it's time to put your knowledge to the test. Use this simple project to build your first spreadsheet, perform some basic calculations, and format your table. Use the same sharing, collaborating, and publishing options to include others in your process!


This video describes the basics of creating a presentation within Google Slides, modifying that presentation and then sharing for collaboration and presenting to others.


In this video, we will take a look at how teachers can import files previously created in PowerPoint and add them to a Google Slides presentation. The video also looks at some presenting options and also how to move a Google Slides presentation offline for backup and long-term storage.

3 questions

What do you remember? Take a quiz!

1 page

For this exercise, use Google Slides to create a multi-slide presentation with some visual elements, timing and text. In this project, try to create a presentation that you would actually want to deliver. In the end, you should build some timings, and look at how it is delivered via the web. You can start with a blank theme and add the following elements to make your project more interesting


This video is a good way to summarize what has been taught so far in this course. The 10 items in this video show the best of the best features for a classroom. Teachers can also use the content video as a barometer for what they should know to really get started using Google Apps for Education.

Section 3: Using Google Forms

This lecture addresses the setup, configuration and delivery of a basic Google Form. This lecture shows how to create a basic form, add several types of questions, and prepare the form for delivery to students or teachers.


In this lecture, we will look at how to build a customized surveys to truly benefit your classroom. These surveys can be conditional in nature or linear. In either case, we will look at how to organize and structure them, then publish and share them for data collection.


In September of 2014, Google started releasing an update to the form theme editor. Previous versions of the form themes limited users to creating forms based on Google's designs. This update now enables users of Forms to make their own themes using their own imagery, color schemes and font choices. Also in this update, I show users how to take a custom theme and use it as a template that can be applied to other new Google Forms. This is handy when building forms on a school theme or using custom logos and letterheads as dictated by school or company branding guidelines.

Bonus Lecture: Creating Auto-Graded Assessments with Google Forms
3 questions

I hope you remember everything you learned here - let's test your Forms knowledge!

1 page

For this exercise, try to create one of two kinds of forms. You can either create a ‘traditional’ form that collects simple data from a series of basic questions. Or, if you are familiar with designing forms and surveys, try a multi-page form with conditional questions.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jonathan Jarc, M.Ed, Teacher, Technology Coach and Free-Lance Graphic Designer

Jon is a teacher and technologist at St. Ignatius High School, the Jesuit preparatory school in Cleveland, Ohio. Jon works with teachers integrating technology to their classrooms.

He supports student learning and faculty professional development across the curriculum. He works with both IT staff and school administration to offer sound technology advice on planning and integration projects throughout our camps as well as conducting ongoing professional development.

With a wide range of IT experiences, and a Masters Degree in Educational Technology, finding solutions to specific teachers' needs is his specialty.

Ready to start learning?
Take This Course