Google Apps are ushering in a whole new era of word processing, spreadsheets, and presentations. Business, colleges, and K-12 schools have begun using this suite of products instead of Microsoft Office. Don't get left behind.
We'll answer these questions and much more in this unique, detailed course offering dedicated to Google Apps for Business and Google Apps for Education. This is the only course on Udemy that takes an in depth look at the following Google Apps:
The lessons walk you through setting up your account, creating your first Google Doc, sharing your docs with colleagues to collaborate with you, designing forms to collect data, and much, much more. Students can expect to walk away with the ability to switch to Google Apps for their day to day computing needs.
From creating your first document and inviting collaborators to work with you to designing forms to gather and display data. Whether you are a beginner or an expert, you will learn something from this course!
In order to access all that Google has to offer, you'll need a Gmail account. If you do not already have one, use this guide to create one. If you do have one, you can skip to lesson three.
This lecture is all about getting to know Google Drive. We'll look at how to log in and navigate the Google Drive interface. Even if you have used Google Drive in the past, this lesson is worth a listen.
A tutorial on how to change the font, add additional fonts, change size, text color and highlights. While these all seems like pretty common tasks, its still helpful to review them. Adding additional fonts is one of those often overlooked features that can really enhance your document.
A quick tour of some basic design functions.
This lesson looks at the various ways to insert an image in your Google docs. We will look at
Google has some helpful functions that make inserting a link easier. Look at the image below. See how Google searches based on what you highlighted to add a link to? Lets take a look how to insert a link to a web page into your document.
Adding header, footers, and page numbers to your Google Doc.
This lesson looks at using tables both in the traditional sense (like a mini spreadsheet) as well as the non traditional use in formatting the look and feel of your doc.
Sharing a document is one of the key features in the Google App suite. Let's look at how to share a document with a colleague, friend, or anyone with an email account. In this lesson, we will explore the various sharing options within each Google Document.
We will also review how to give someone rights to view, comment, or edit a document.
Sometimes, you need a word processor with more features than what Google can offer. Here's how you can download a copy in a Microsoft Office format.
We'll look at how to upload and convert a Word document, Excel spreadsheet or Adobe PDF into a Google Doc. We will look at the settings associated with the conversion process as well as how to setup Google to ask you what you want to do with each file.
Google keeps a revision history of all the changes you or other make to a document. Lets look at how to view those revisions and restore them if you so desire.
This quiz will review the information we have learned about creating Google Documents.
In our opening spreadsheet lecture, we'll create our first spreadsheet and look at how to format your data as currency, date, time, etc.
In this lesson, we'll turn our data into an interactive, eye catching chart.
Conditional formatting is defined as formatting of data on reports or computer programs that changes based upon specific criteria. We'll look at Google Sheets can offer us in the area of conditional formatting.
We look at using data validation to prevent unwanted entries into your spreadsheet.
Data changed? Get an email. New person filled out your form? Get an Email.
This lesson focuses on sorting one or more columns of data using the data sorting features in Google Spreadsheets.
This lecture describes how to use data filtering to only show subsets of the main data. For example, only show me sales in the month of July.
Locking rows or columns so you can scroll through the data easily.
We'll explore the vast amount of predefined functions available to us in Google Sheets include sum, average, left, right and named ranges.
A review of your spreadsheet knowledge.
Google forms allow you to collect information from people through a variety of different question types. Google forms can be used to create simple questionnaires and quizzes, but more advanced forms can be used to gather data based on a person's responses. Once the data is collected, you'll have the ability to view and display the responses quickly and easily. Let's create our first Google Form.
In this lesson, we'll add a second question that allows the user to provide a longer answer than the last lecture. We'll also look at how to edit a question or delete a question.
This lecture covers adding a multiple choice question to your Google Form.
This lesson covers adding a fourth question type: Check Box questions.
How and where you would want to add a drop down question onto your form.
Quite often, you want to add an image into your form for various reasons. This lecture covers how to add a image onto your form and how to edit it to look the way you would like.
Similar to adding an image, you can also insert videos into your forms. Lets look at how to do that.
Dividing your forms with pages and section headers.
After a person completes your form, there are quite a few things that can be done. We'll look at progress bars, adjusting the message that is displayed, showing the survey results to those who took it, and allowing users to edit their responses.
The last two question types: scale and grid questions.
In this session, we'll look at how to control the data being entered into your form using data validation.
In this lesson, we'll create a new presentation. Once done, we'll give it a title and choose a theme. From there, we'll look at how to modify the theme design to meet our needs.
This lecture covers how to assign special effect transitions to a slide or slides. We will also look at adding animations to text or images on individual slides.
Google presentations allows you to import slides from existing presentations both in your Google Drive or on your computers hard drive.
Here's how you can export the presentation for use in Microsoft Powerpoint.
This lessons looks at the options available to you when its time to present your information.
Just a quick recap here of the features associated with Google Presentations and the Google Apps suite in general.
In this lecture we'll create a Google drawing. From there, we'll look at adding text via a text box and the options associated with it.
Lets add some simple word art to our drawing.
We continue on the insert menu with a look at how to insert lines, scribbles, curves, and polylines.
Google Drawings includes many predefined shapes. We'll add those into our drawing and adjust them accordingly.
Using the arrange menu to move things in front of or behind other objects.
Savings your document for use in a Google Document, Presentation, website, or any other application.
In this lesson, we'll upload a document that was originally created in Microsoft Word and convert it to a Google Doc. From there, we'll use the sharing feature to invite a few collegues to edit the newly created document.
Using Google Forms to create a instant feedback quiz or flash cards.
Using Google Forms, Spreadsheets, and conditional formatting to create self grading quizzes.
Another example of how to direct the questions a person sees based on previous answers.
Wrapping up. Please PLEASE PLEASE review this course. I am always looking to improve the course so any feedback is thoughtfully reviewed.
At age 35, Mr. Daugherty is a married father of two wonderful children. In his professional life, he has successfully formed and sold two technology companies. While he has a talent for Information Technology, his passion is education and helping schools succeed. He has spent much of his professional career mastering the art of personal productivity and how to make the most of the time you are given on this earth.
In his current role as Director of IT for a high performing school district in Ohio, he has successfully implemented a 1:1 computing initiative with Google Chromebooks. The staff and student collaborate using Google Apps for Education. As the program expands into additional grade levels, Mr. Daugherty is responsible for providing training to the staff on how to Google's suite of products to create, share, and collaborate with colleagues and students alike. He is currently working to complete his certified Google Apps Educator coursework.