Google Sheets

 Google Sheets

Learn how to use Google Sheets to enter, organize, and analyze data, including student assessment data.

ISTE Standard: Analyst

To meet this standard, educators understand and use data to drive their instruction and support students in achieving their learning goals. Educators:

(More details here)

Teachers who effectively use Google Sheets are Analysts because they are more able to work with data sets in ways that allow them to "provide timely feedback to students and inform instruction." They are able to collaborate with teaching teams as they "use assessment data to guide progress and communicate with students, parents and education stakeholders to build student self-direction."

Learning Intentions

• I can create a Google Sheet or upload and convert a Microsoft Excel file to Google Sheets format.
• I can edit and format text and numerical data in Google Sheets.
• I can share and collaborate in Google Sheets.
• I can use basic and advanced formulas to calculate new data and text in Google Sheets.
• I can sort, filter, and freeze columns and rows and format a Google Sheet for printing.

Success Criteria

• View all pages and content

 Google Sheets Introduction

Google Sheets is the spreadsheet program that is part of Google's G Suite. Sheets is an online, collaborative spreadsheet service stored in Google Drive. As you edit a Google sheet, your changes are automatically saved and revisions can be tracked and even restored. Google Sheets is a simplified, web-based version of Microsoft Excel or Apple's Numbers. Many of the same features from Excel and Numbers are also available in Google Sheets, but not all of them. Learn more about what Sheets does by clicking on the following image:

Logging On to CSDDocs

As a quick reminder, be sure to log in to your CSDDocs account before beginning your work with Sheets. Visit http://drive.google.com Links to an external site. and log in to your CSDDocs account using the following login credentials:

Meet Google Sheets

In 2013, Google made some updates in Sheets that made it a faster, more comprehensive spreadsheet tool. Watch the following video to see an overview of the improvements they made:

 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:

• Go to http://drive.google.com and enter first.last@csddocs.org and your District email password.
• You can learn about your CSDDocs account in 💭 Module 2.2 | LEADER | Chromebooks & CSDDocs.

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

Creating and Formatting Google Sheets

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

Inserting Objects in Google Sheets

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

Google Sheets Templates

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

Template Gallery and Table Styles (2:59)

Google 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:

Google 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. 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. 1. AVERAGE
   2. MEDIAN
   3. MODE
   4. MINIMUM
   5. MAXIMUM