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:
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
"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".
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.
Let's see what you remember!
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.
What do you remember about Google Docs Training? Take a short review quiz.
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.
Google sheets is very much like Excel, but how are they different? Let's review...
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.
What do you remember? Take a quiz!
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.
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.
I hope you remember everything you learned here - let's test your Forms knowledge!
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.
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.