Module 7.3 - Google Sheets Tutorials

 Google Sheets Tutorials

Below is a collection of video tutorials that will teach you all about how to use Sheets. Watch each video to learn about the variety of things you can do with Sheets. Try the things you are learning in your own CSDDocs account.

*Note: To log in to your CSDDocs account:

Additional Sheets resources can be found at: https://edu.gcfglobal.org/en/googlespreadsheets/ Links to an external site. 

 

LaptopCreating and Formatting Google Sheets

Watch the following video to learn how to create and format Google Sheets:

Creating and Basic Formatting (3:49)
Conditional Formatting (2:15)

 

LaptopInserting Objects in Google Sheets

Watch the following video to learn how to insert objects in Google Sheets:

Insert a Chart or Image (4:05)
Advanced Image Insert and Formatting (3:33)

 

LaptopGoogle Sheets Templates

Watch the following video to learn how to use Google Sheets templates:

Template Gallery and Table Styles (2:59)

 

LaptopGoogle Sheets Formulas and Functions

It can be difficult to keep track of all the functions and formulas you can use in Google Sheets. Click on the following image to access a list of functions and formulas:

Sheets Formulas

 

LaptopGoogle Sheets Practice

We conducted a survey Links to an external site. to collect sample data that you can use in a practice Google Sheet. Click here Links to an external site. to open the sample sheet we created. Make a copy of the sheet. Rename the sheet by removing "Copy of" in the file name, and add your name to the title instead. Try the following on the practice sheet:

  1. Apply text wrapping to Row 1 so you can read the entire question.
  2. Freeze Row 1.
  3. Hide Column A (time stamps).
  4. Sort Column D to be alphabetized Z to A.
  5. Use conditional formatting to color the cells in column B "What grade do you teach?":
    1. Elementary (K-5): yellow
    2. Middle (6-8): pink
    3. High (9-12): purple
    4. Adults: orange
  6. Create a chart for the question "What is your favorite time of year?" and add it to a new worksheet. Change the color of the chart worksheet tab to green. Insert an image of the most popular season to the response worksheet.
  7. Filter column B to show who else teaches the same grade level as you. After you view the list, remove the filter.
  8. Insert a column between Columns E and F. Create a formula to add the first name and favorite number together. For example, if my name is Maria and my favorite number is 6, the new cell should say "Maria 6". Function~ =CONCATENATE(B2, " ",C2).
    1. When would you use this feature? Place your answer below spreadsheet.

9. At the end of the data in Column D, add the label "AVERAGE". Calculate the average of the last three numbers in column E using this formula: Average = add up all the numbers, then divide by how many numbers there are. (Yes, there is a Function that does this. We are learning about Formulas right now, so be patient!)

    1. Don't forget about PEMDAS!
    2. Use / instead of ÷ when writing a formula
    3. Use * instead of x when writing a formula
    4. Write exponents with the ^ symbol, for example: 52 = 5^2

10. At the end of the data in Column F, add the following labels to individual cells so you can calculate data for Column G "What year did you graduate high school?". Use functions to calculate the year for each section.

    1. AVERAGE
    2. MEDIAN
    3. MODE
    4. MINIMUM
    5. MAXIMUM

11. Share this spreadsheet (set permission to "comment") with the instructor of this module.