google sheets basic t.i.m.e.

1. Objective

After completing this module, the professional learner will be able to:

  1. Use Google Sheets for spreadsheet creation
  2. Use Google Sheets for collaboration on documents with students and peers
  3. Use Google Sheets to organize data and create graphical representations
2. Support

We would like you to accomplish the tasks listed below.  If you need support, please consider the following resources:

  1. Watching the video tutorial
  2. Walking through the user guide: click here
  3. Asking a colleague around you for assistance
  4. Asking one of the CBD trainers for assistance
3. Tasks
    1. Create a new folder and open it up
      • Add a new document to the folder
      • Add a new spreadsheet to the folder
      • Move an existing document into your new folder
    2. Upload a file to your Drive
      • Add it to an existing folder or create a new folder
    3. Share a folder with a colleague
    4. Delete an existing file or create a new document to practice deleting
    5. Star at least 2 important items
      • Search for those items by clicking on “Starred”
    6. Move an item from “Shared with Me” to “My Drive”
    7. Search for a file
      • Type the title of a document in the search bar at the top of the screen

If you finish early, here are extension tasks to try:

      1. Add color to your folders by right clicking on a folder
      2. Create folders within folders
        • Open an existing folder or create a new one
        • Create a folder within this folder. (example: Main Folder “Math” secondary folders might be called “Lessons,” “Assessments,” “Resources,” etc…)
      3. Sort your files
        • Practice sorting by choosing “Sort Files” at the top of the screen
      4. Rename a document or folder to practice standardizing your naming conventions