Google Sheets can do most of what can be done in traditional worksheets like Excel. It an be very useful for teachers and students to graph math problems like polynomials. Graphing equations like polynomials in a spreadsheet provides real world practical experience and use of technology in the classroom. We will be graphing the polynomial shown in the image below.

polynomial equation

Google Sheets can be used to create Sine waves. A sine wave is a mathematical curve that describes a smooth repetitive oscillation.

In this lesson we will learn how to...

  • fill values in cells
  • enter a function in a cell
  • use the Radian funciton
  • duplicate a function for multiple cells
  • use the Sine function
  • select multiple cells
  • create a line chart for the sine wave function

Create a new sheet by clicking the New button and selecting Google Sheets.

new google sheet

Google Sheets can be used to solve and graph quadratic functions.

In this lesson we will learn how to...

  1. Generate numbered lists
  2. Enter a formula into a cell
  3. Reference values in a cell
  4. Use exponents in an equation
  5. Multiply values in an equation
  6. Create a scatter chart to graph the quadratic function

Create a new Google Sheet by clicking the New button in Google Drive and selecting Google Sheets.

new google sheet

A Google sheet is a document that can contain several spreadsheets. Each spreadsheet is represented by a tab at the bottom of the workbook. More than one spreadsheet in a Sheet document is referred to as a workbook. We can add up to two hundred spreadsheets to a workbook. We can create new spreadsheets in this workbook and we can duplicate existing spreadsheets.

Duplicating spreadsheets can be a useful way to work with data and not worry about changing the original.

Google Forms collects responses and saves them to spreadsheets. We can make a copy of a set or responses then reuse the same worksheet to collect more responses.

In this example, we have a response spreadsheet that has been graded. We will reuse the spreadsheet with the associated form to retest students. We will clear out the responses after making a copy of the original responses.

Click on the triangle to the right of the sheet name and select the duplicate option.

01_duplicate_option_from_sheet_menu

The spreadsheet will be duplicated and placed to the right of the original. We can now clear out the original responses.

02_copy_of_sheet

 

A Google Sheet is a document that may contain several spreadsheets. The document is called a workbook. We can create several spreadsheets in a workbook. We can also remove unwanted spreadsheets from the workbook.

To remove a spreadsheet, click on the triangle to the right of the sheet name. In this example, we want to remove a duplicate version of student responses we created in an earlier lesson. Click the delete option at the top of the menu.

sheet_tab_menu_option

A Google Sheet is a document that can contain several spreadsheets. This document is called a workbook. One spreadsheet is automatically created when we create a new Google Sheet document. We can add additional spreadsheets to a workbook.

To add a new sheet, click Insert in the menu and select “New Sheet”.

insert menu option

Sharing and collaborating on worksheets is one of the benefits of using Google Sheets. At the most basic level we can grant permission for someone to edit a spreadsheet. This permission allows access to the complete workbook and all the spreadsheets. There may be times when we don't want to grant access to edit some part of a spreadsheet. In this case, we can grant permission to edit specific sheets or ranges of information.

In this example, we want to provide edit access to specific cells in the sheet. We want to provide access to one range of cells for one account and permission to another range of cells for another account.

spreadsheet_information

When working with Google Sheets we might often work with others or share the spreadsheet. When collaborating on spreadsheets we might need to make sure that some information isn’t editable by others. We can set restrictions on spreadsheets or on a range of cells. Restrictions are set using familiar tools similar to sharing documents.

In this example, we want to restrict any editing of the sheet labeled “District Level”.

spreadsheet_tab_selected

A spreadsheet in Google Sheets like most spreadsheet applications. It’s actually a document that can contain several spreadsheets. This document is called a workbook. Each spreadsheet in this document can be accessed from a tab at the bottom. We can have several spreadsheets in a document. According to Google, we can have up to 200 sheets in a workbook.

With so many sheets in a workbook, we might have the need to hide one or more of these sheets. Hiding a sheet removes it from the tab selector at the bottom and brings the other tabs in to take its place. The spreadsheet isn’t deleted, it’s just hidden from view. This makes can make it easier to select tabs when we have several in our document. We might also hide sheets when sharing information with others.

In this example, we have a workbook with several sheets.

several spreadsheet tabs

We can add images to a Google Sheet using the Insert menu option. This will insert an image above the cells where it will float above the text and we can position it as needed. We can also insert an image into a cell from a web-site. An image inserted into the cell will be part of the cell.

To Insert, a floating image, click on Insert in the menu and select “Image”.

insert image option

When we create a new Google Sheet, we are actually creating a document that can hold several sheets. We automatically have one created, and this spreadsheet has the generic name called, sheet1. As we work with spreadsheets, it might be necessary to create more that one in a document.

To learn more about creating additional sheets, read my post on adding sheets in Google Sheets.

sheet1 tab name

We can hide columns or rows in a spreadsheet to help focus on some of the specific information. Hiding columns or rows collapses the information so we can shorten the distance between values and information. In this example, we have columns we don’t currently need to see. To hide these columns we will click once on the column heading to select the entire column.

column C selected

Spreadsheets can get a little complicated and cumbersome. To get a better view of information across a spreadsheet we often need to scroll through lots of information. The headings for information may not always be at the top of the sheet in the first or second row. That happens to be the case in this example.

We have some data collected in a survey. The information I would like to keep visible is in the first column and in one of the rows. In this example, that would be the information headings starting on row 23.

spreadsheet with data.

There are times when we collect data in a spreadsheet that isn’t relevant or necessary for our needs. This can happen when we receive data from another source. In this example, we have some data received from an online database which includes extra information and columns with headings and no data.

spreadsheet with data

Spreadsheets have a standard column width and row height. This width and height don’t always show all the information in a column or in a row. In this example, we have a column that is too small to show the complete student names. There are several ways we can resize this column.

We’ll move our mouse pointer between columns A and B. An arrow pointing to the right will appear between the columns. Click and drag to the right.

spreadsheet with highlight between columns A and B

When we create a spreadsheet in Google Sheets, we are creating a document that can have multiple spreadsheets. We have one spreadsheet automatically added for us. We can add more spreadsheets as needed. To add a spreadsheet, we need to click on the Plus button to the left of the first spreadsheet.

add sheet plus button