Create, Collaborate & Work Dynamically Online in Google Apps
4.8 (8 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,157 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Create, Collaborate & Work Dynamically Online in Google Apps to your Wishlist.

Add to Wishlist

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 (8 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,157 students enrolled
Last updated 11/2014
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 4 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
  • 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.

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

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
20 Lectures
Getting Started
4 Lectures 14:27

"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".

Preview 00:40

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!

Preview 03:36

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.

Preview 10:00

Let's see what you remember!

Google Drive Review
3 questions
Using "The Big 3": Docs, Sheets, and Slides
11 Lectures 01:06:32

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.

Preview 10:10

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.

Preview 11:53

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

Google Docs Review
3 questions

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.

Google Docs Project 1
1 page

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.

Preview 04:06

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.

Creating, Importing/Exporting, and Merging in Google Sheets

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.

Formulas, Functions and Features in Google Sheets

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

Google Sheets Review
3 questions

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!

Google Sheets Project 1
2 pages

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

Creating, Collaborating and Commenting in Google Presentations

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.

Importing, Presenting, and Downloading in Google Slides

What do you remember? Take a quiz!

Google Slides Review
3 questions

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

Google Slides Project 1
1 page

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.

Preview 07:24
Using Google Forms
5 Lectures 21:54

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.

Preview 10:03

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.

Creating Conditional Surveys and Publishing

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.

The NEW Google Forms Custom Theme Editor

Bonus Lecture: Creating Auto-Graded Assessments with Google Forms

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

Google Forms and Sheets Review
3 questions

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.

Google Forms Project 1
1 page
About the Instructor
Jonathan Jarc, M.Ed
4.2 Average rating
48 Reviews
3,922 Students
4 Courses
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.