Answer all questions with 500 words 3 hrs
Vincent666
MicrosoftWordDocument2.docxG Suite Assignment
In this exercise you will be introduced to the different Google applications (Drive, Docs, and Sheets). You will watch a few short videos and answer questions about them, as well as complete a short exercise in Google Sheets. (A word version of these instructions are at the bottom if you prefer to print them out)
Please watch the two videos below and answer the posed questions. Then, complete the sheets exercise and answer the additional questions posed.
Video 1: G Suite Tutorials 2017
https://www.youtube.com/watch?v=LW9gh2myDhA&list=PLb5VsNTAwRZnoXWqiTkJ-evSGDVgg_C_9 (Links to an external site.)
Where will all the documents you upload and create on Google Drive be stored?
If someone shares a document with you where does it go?
True or False: If you click and drag a file from my drive to shared with me and make changes to one document it changes to both.
True or False: You can only upload files to Google Drive.
True or False: Google Drive has their own Apps that you can program in Google Drive.
How do you share documents? Can you choose specific permissions? If so how?
How can you tell if a file is in a Google format?
Video 2: Google Docs and Google Sheets Tutorial
https://www.youtube.com/watch?v=W7wOQaGbf-A&list=PLb5VsNTAwRZnoXWqiTkJ-evSGDVgg_C_9&index=2 (Links to an external site.)
True or False: Google Docs has the same primary features as Word.
Can you add comments in Google Docs like you can in Word?
What are the 3 different modes in Google Doc?
When commenting, can you at mention others in the document?
Features:
Can you see all of the comments, even the ones marked as resolved?
True or False: Google Docs is not in Real Time.
Is there a way for you to review who made revisions and if so how?
If higher ups come in, what does this mean? In your opinion, why is this important especially in groups?
Google Sheets is similar to what?
Can you create functions in Google Sheets like Excel?
True or False: If you create a filter in Sheets it will bold them and allow you to sort them.
Sheets Exercise:
Open the spreadsheet provided at the bottom of this page(upload, open with, google sheets) in Google Sheets (you will have to use the knowledge you learned from the videos to do this).
Right click in the Progress Section
Choose Conditional Formatting
Apply to range A:A
Format Cells If
Text is exactly
) On Track
Click the paint bucket
Choose a shade of green
Click Done
) Delayed
Click the paint bucket
Choose a shade of yellow
Click Done
) Overdue
Click the paint bucket
Choose a shade of red
Click Done
6.) Click Add-ons
7.) Click Get Add-ons (If you can not get the add-ons, explain how you would color code in Excel)
8.) Search and Download Sort By Color (It will make you sign in with gmail and accept permissions)
9.) Click the Progress Column
10.) Click Add-ons
11.) Select Sort By Color
Sort By Color will now sort your conditionally formatted cells.
This is just one of many different Add-ons that can be utilized in Google Sheets.
Sheets Exercise Questions:
How do you think the Sort By Color tool can be used in data analysis?
Find an Add-on that you find interesting and briefly explain what it does.
When you are finished with this assignment submit the Google Sheet and this document with answered questions into the dropbox on Canvas.
