Task

Achieved

Explain the core features in Google Drive

What is My Drive?

What is Incoming?

What is Recent?

What is Starred?

What is Trash?

What is the Activity Feed and View Details?

What are the different sorting and view options of Drive?

Create a new Folder

Rename a Folder

Share a Folder

Move a Folder

Add a Folder to multiple locations

Delete a Folder

Upload a folder??

Search for a file by user

Search for a file by type

Search for a file by keyword

Search for a file by ownership

Upload a Word document

Upload a Word document and convert it to a google document

Upload a PowerPoint presentation and convert it to a google presentation

Upload a Excel file

Upload a Excel file and convert it to a google spreadsheet

What are the maximum users that can edit a document at the same time?

What are the maximum users that a document can be shared with?

Google Documents

Create a new document

Add a title to the document

Rename the title of a document

Change text font, color, formatting

Adjust Margins

Create a bulleted list and numbered list

Format text using different Heading styles

Align text

Adjust paragraph line spacing

Insert a table

Insert a special character

Insert a Bookmark

Insert page numbers

Identify the different view modes(Editing, Suggestion, or Viewing)

Create a table of contents

Edit Preferences to autocorrect commonly spelled words

Add words to the Spelling Dictionary

Use the Research tool to find an image to insert into a document

Make a Hyperlink

Comment on a Document

View comment history on a document

Chat within a Document

Make a copy of a document

Locate the revision history of a document

Email the document as an attachment

Print the document

Publish the document to the web

Download the document as a different file type

Share the document with specific collaborators

Share the document so that only people in the organization can access/find

Adjust the sharing visibility settings to be viewable by the World

Email the collaborators from the document

Explain and demonstrate “Add-Ons”

Enable/View keyboard shortcuts

Delete a document

Google Forms

Create a new form

Add a title to the form

Rename the title of a form

Describe the differences between the “Form Settings” options

Add a form description

Add a question for each of the 9 question types, make all the questions require an answer

Insert Help Text within one of the questions

Insert an image

Insert a video

Insert a question and have it go to a page based on an answer(branched questions)

Insert a text response question with data validation

Duplicate a question

Shuffle the question order

Add a section header

Add a page break

Change the theme of the form

Add a custom confirmation message

View the live form

View the responses spreadsheet

Explore the different response destination options

View the summary of responses

Send the form via email with a shortened URL, add a Custom Message

Share the form with edit rights to specific collaborators

Share the form so that only people in the organization can access/find

Adjust the sharing visibility settings to be viewable by the World

Email the collaborators from the form

Locate the embed code of the form

Create a pre-filled URL of the form

Enable “Show link to submit another response”

Enable “Publish and show a public link to form results”

Enable “Allow responders to edit responses after submitting”

Enable/View keyboard shortcuts

Sort data from within the responses spreadsheet

Google Presentation

Create a new presentation

Add a title to the presentation

Rename the title of presentation

Create new slide

Explore the different slide formatting options

Change background of a slide

Change the theme of the slides

Insert pictures, videos, and word art

Add transitions to the slides

Change the slide order

Show/Launch a presentation

Comment on a slide

Chat within the presentation

Share the presentation with specific collaborators

Share the document so that only people in the organization can access/find

Adjust the sharing visibility setting to be viewable by the world

Email the collaborators from the presentation

Locate the revision history of the presentation

Email the presentation as an attachment

Download the presentation as a different file type

          Insert Presenter Notes

Print the presentation as handouts

Publish the presentation to the web

Enable/View keyboard shortcuts

Google Spreadsheets

Create a new spreadsheet

Add a title to the spreadsheet

Rename the title of the spreadsheet

Explore the spreadsheets interface

Select a range of cells

Cut, Copy, and Paste cell content

Drag and drop cell contents

Use the fill handle to auto populate cells

Modify the column and row width manually and auto-size

Insert and delete and row and column

Move a row and column

Enable text wrapping

Merge the cell contents

Freeze and row and column

Change the font size, color, and type

Change the text alignment within a cell

Change the cell borders

Change the cell background

Explain the different text and number formatting options

Add a new Sheet

Rename a Sheet

Protect a Sheet

Change the tab color of a Sheet

Move a Sheet

Duplicate a Sheet

Delete a Sheet

Copy a Sheet to a different Workbook

Use the find a replace feature

Insert a comment into one of the cells

Insert an image

Insert a google drawing

Insert a Hyperlink to text

Use the Filter feature

Create a Filter view

Sort the Sheet from A to Z and vice versa

Sort a specific range of data

Create a Conditional formatting rule

Insert a simple formula that Demonstrate knowledge of the SUM, AVERAGE, COUNT, MIN, MAX functions

Create a simple chart from some sample data

Download the spreadsheet as a different file type

Email the collaborators from the spreadsheet

Email the spreadsheet as an attachment

Print the spreadsheet

Locate the revision history of the spreadsheet

Publish the spreadsheet to the web

Share the spreadsheet with specific collaborators

Share the document so that only people in the organization can access/find

Adjust the sharing visibility settings to be viewable by the World

Explain and demonstrate “Add-Ons”

Enable/View keyboard shortcuts

Google Drawing

Create a new drawing

Add a title to the drawing

Rename the title of a drawing

Insert image, shape, and word art

Insert text box

Change shape to a different shape

Change color of shape

Change the line thickness of the shape

Change  the size of the shape

Rotate shape

Resize the canvas

Comment on a drawing

Chat within a drawing

Make a copy of a drawing

Email the drawing as an attachment

Print the drawing

Publish the drawing to the web

Download the drawing as a different file type

Share the drawing with specific collaborators

Share the document so that only people in the organization can access/find

Adjust the sharing visibility settings to be viewable by the world

Email the collaborators from the drawing

Enable/View keyboard shortcuts