Create, Collaborate & Work Dynamically Online in Google Apps

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.

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.

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.

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.

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.