Created by +NeilCharlet 12/2014
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 | |
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 |