Module 2 Lessons 1-4_compressed.pdf

Introduction to Google Applications (Google Calendar, Google Drive, and Gmail Prepared by: Analyn V. Casipe Introduction to Google Apps Google has come a long way since its inception in 1998 to become the world’s largest and most use...

Introduction to Google Applications (Google Calendar, Google Drive, and Gmail Prepared by: Analyn V. Casipe Introduction to Google Apps Google has come a long way since its inception in 1998 to become the world’s largest and most used search engine site. Google has transformed the way we used to study and played a major role in imparting education and knowledge accessible and comfortable for all. Google Applications First released their email app, Gmail, on April Fool’s Day 2004. 1 GB of storage and its label-based mail organization and fast search still set it apart from other email services. But it was primarily a competitor for Hotmail and other personal email services. Google Applications The following year, it acquired Writely, a simple online writing app which became Google Docs. Other apps bundled together into what was then called Google Apps for Your Domain, later simplified to Google Apps for Business before its recent rebranding as G Suite. Gmail Application Is one of the most widely-used web email clients in the world. One of the most powerful email clients available. Over 5 million organizations have adopted Google Apps as their corporate email system. Gmail Application Has a variety of the standard features that all email providers have Offers so many powerful ways to manage, automate, and clean up your inbox.  Gmail Features Priority Inbox - Gmail automatically sorts your mail by moving the important messages to the top Conversation View - Gmail automatically groups together multiple emails Chat - Lets you send and receive instant messages with others in Gmail. Search - You can enter keywords to search entire conversations to find the message you are looking for. Labels - You can apply multiple labels. Filters - Sort and manage all your incoming mail. Filters can automatically apply labels, forward messages Stars - get pushed to the top of your inbox and can be marked as priorities, Google Calendar Is a web-based calendar which you can use for keeping track of important events and coordinating meetings. Is great as a stand-alone service The basics of Google Calendar include creating an event, inviting others and booking a room. Calendar Features Suggested Times - Find times when all invited guests can attend your event. Gmail to Calendar Event Add - When you receive an email with event details (time and/or date) add it instantly to your Calendar. Appointment Slots - Allows users to set aside blocks of time on their calendar Working Hours - Warn others when they try to schedule an event when you’re not actually in the office.  Calendar Features Calendar Labs - Allows you to try new and experimental Google Calendar features. Receive a Daily Agenda - Get your Google Calendar to emailed to you every morning. Hide Morning and Night Hours - Choose hours you want to hide and they wwill collapsed into a single line. Event Attachments - Attach a google Doc, Spreadsheet or Presentation when creating your event by installing. Google Drive Released in early 2012 Has become one of the most widely adopted cloud storage services in the world. Allows users to easily create, edit, and store a number of file types and access them from any device with an internet connection. Drive Features Add a Google Doc to Multiple Folders - Adding a Google Doc or any other file to multiple folders within Google Drive makes it easy to find the file and stay organized. Advanced Search in Google Drive - These advanced search operators are especially useful when you’re navigating an extensive Drive library.  Lesson 2: Google Docs Introduction One important feature of the cloud computing trend involves office software, which till now has been dominated by PC based software, primarily Microsoft (MS) Office. Google Docs is Google’s web-based office suite. MS has recently launched SkyDrive, a web- based, stripped-down version of MS Office. Google Docs - similar to Microsoft Word Important features: All files automatically saved as you make changes Revision History by clicking Italicized Share Info When shared, you can see who made changes and when Share Options - Can Edit, Can Comment, Can View ONLY the Owner can delete file Google Docs Microsoft Word (MS Office) Google Docs a web-based office suite available to anyone with internet access whether through a PC, laptop, or mobile device free with a Google account allows you to share documents for viewing and editing, and allows multiple users to collaborate simultaneously on a project over the web 1 GB of free storage space; you can purchase extra storage space starting at.25/GB/year it has limited featuresl it is under revision and open to change it has very limited support and training opportunities Microsoft Word (MS) Office a PC-based office suite MS Office must be purchased, registered and loaded onto a computer provides more sophisticated features, and as a fixed and widely used program, more resources are available for guiding and training the user Office Web Apps/SkyDrive: - a web-based office-suite - free, but requires a Windows Live account - allows users to share documents but not collaborate - 25 GB of free storage space  Lesson 3: Google Slides Introduction Google slides is a free online presentation program that allows you to create animated slideshow presentations. Slides can have text, images, soound, animations, shapes, and even videos. A major advantage of Google Slides is the ability to share and collaborate on slides in real-time without sending attachments back and fourth. Google Slides - similar to Microsoft PowerPoint Integration with other Google products: add files from Google Drive add pictures from your Picasa account add videos from YouTube search (incl. Scholar and images) embedding in Blogger, Sites, Google+ What is Google Slides? Available via the web, Import PowerPoint files Images, video, and mobile app, or ChromeOS. and export files in various audio can be added ways. to Slides. There are different Slides can be created Slides are sharing options available collaboratively in real automatically saved time. as you work. Slides can be presented to 3rd party Slides add-ons Slides can be others in a variety of ways. can improve functionality. embedded into blogs and websites. Google Slides Microsoft PowerPoint (MS Office) Google Slides Easy to acces: Having your presentation stored in the cloud allows you to access it anytime. Compatible with other Google applications: Google Slides supports charts from Google Sheets, pictures from Google Photos and even multimedia content from YouTube. Instant auto-saving: Google slides automatically saves every time you change something. One main requirement: you must have a Gmail account. Microsoft PowerPoint Easy to use: PowerPoint is quite intuitive and its interface is similar to that of other Microsoft Office programs. Multiple customization options: Thanks to its image editing capabilities, you don’t need to resort to graphics editors. Compatible with different formats: PowerPoint allows you to import and export different file formats, such as.pdf documents,.mp4 videos, and many image formats, including.gif,.tif,.png, or.jpg, among others, Compatible with other Microsoft Office programs: You’ll be able to enrich your presentation with charts from Excel spreadsheets or tables from Word documents.  MS PowerPoint Google Slides Access Microsoft Office must be installed on your computer A Gmail account is required (free) File formats supported for.pdf,.mp4,.wmv,.odp,.gif,.jpg,.png,.gif,.bmp,.tif,.pptx,.pdf,.txt,.jpg,.png,.svg import.wmf,.emf, y.rft Allows multiple users, provided they have Gmail Collaboration Allows multiple users via OneDrive accounts Animations Yes Yes Audio Insertion Yes Yes Video Insertion Yes Yes (from YouTube or Google Drive) Offline access Yes Yes (the app must be installed) Available for PC Yes Yes Available for MAC Yes Yes Name a Presentation Editing and Formatting - No Placeholder Selected Toolbar: Editing and Formatting - No Placeholder Selected Toolbar: Editing and Formatting - Placeholder Selected Toolbar: Assignment: Create a video tutorial on how to use Google Docs and how to share it with others. Upload the video in Google Drive and submit the link of the uploaded video in the LMS. File Name: LastName_M2L2_Application Assignment: Create a video tutorial on how to use Google Slides and how to share it with others. Upload the video in Google Drive and submit the link of the uploaded video in the LMS. File Name: LastName_M2L3_Application  Lesson 4: Google Sheets Introduction Google Sheets is a spreadsheet app on steroids. It looks and functions much like any other spreadsheet tool, but because it’s an online app, it offerss much more than most spreadsheet tools. Sheets supports several different file types: XLS XLSX XLSM TXT ODS CSV  In Microsoft Excel... In Sheets... Collaborate in Excel for the web Collaborate in real-time from Sheets Share using Excel for the web or a shared workbook Share directly from Sheets Save automatically using SharePoint or OneDrive Save automatically to Drive Manage versions with History or Version History in OneDrive Manage version with version history Add formulas and use formula suggestions that appear as you enter Add formulas and use Formula AutoComplete for suggestions text Record macros or use VBE Record macros or use Google Apps Script  In Microsoft Excel... In Sheets... Create filters Create filters and filter views Insert recommended pivot tables or create one manually Create pivot tables manually or automatically with Explore Create charts manually Create charts manually or automatically with Explore Set notifications in OneDrive Set notifications in Sheets Common Spreadsheet Terms Cell: A single data point or Column: A vertical set of Row: A horizontal set element in a spreadsheet. cells. of cells. Range: A selection of cells Function: A built-in Formula: The extending across a row, operation from the combination of column, or both. spreadsheet app. functions, cells, rows, columns, and ranges Worksheet (Sheet): the Spreadsheet: The entire named sets of rows and document containing your columns making up your worksheets spreadsheet