Sheets

Google Apps Tutorials

Additional EdTech Tutorials

Sheets Templates and examples

Create a New Google Sheets - both blank and template.webm

To Use a Google Sheets Template

Go to Google Drive.
Click on New.
Hover over Google Sheets.
Select Template.

Template options include:

Attendance
Gradebook
Budget

TK-2 Sheets

Upper Grades Sheets

Tutorials

Google for Education Sheets Lesson

In this 8 minute lesson, you will learn:

What Google Sheets is
How to access Google Sheets
How to create a Google Sheet
How to sort, filter, and edit data
How to create charts and graphs
How to share a Google Sheet

Locate a Spreadsheet in Google Drive.webm

Locate a Google Sheets in Drive

Go to drive.google.com.
In the Search Drive bar, select the down arrow.
For type, select Spreadsheet.
If you know more information, add filters such as who owns the file. If not, just select Search.

Column, Row and Cell.webm

Insert Data

Columns go up and down (vertical).

Rows go across (horizontal).

Cells are individual rectangles.

Type labels in cells A1 and B1.
Type numbers in the rows below them.

Edit a Chart.webm

Edit Chart

Artificial intelligence is nice, but not better than your brilliant mind.

To Edit a chart:

Hover over the chart.
In the upper right corner, click on the three dots.
Select Edit.

Play with the options to see what happens. If you make a mistake, just use the shortcut CTRL Z to undo it.

Understand Formulas in a Google Sheets.webm

Use Formulas

To complete a mathematical equation:

Click on a cell.
Type =2+4.
Hint the Enter key.
The number 6 will appear.

+ add

-minus

* multiple

/divide

Example formulas

Use Functions (Formulas) such as Average.webm

Select from a list of Functions (Formulas)

Why do the math manually when the computer will compute it for you?

Type the labels and data for a gradebook.
- 4 names
- 4 assignments
- 4 scores
Select cell F2.
Go to Insert -> Functions.
In this case, select Average.

Why do more work? Once you have the formula in Cell F2, grab the blue square at the bottom of F2 and drag it down.

Example Gradebook

Insert Sheets Chart into Google Docs Report.webm

Insert a Chart in Sheets into a Google Docs

Open Google Docs.
Go to Insert -> Chart -> Google Sheets.
Select the spreadsheet from the list.
Select the chart you want to insert.
Click Import.

If keep the default for linking the chart, if a change is made on the spreadsheet, you can update the chart on the Google Docs.

Example Google Sheets Chart in Google Docs

Insert Google Sheets Chart into Google Slides.webm

Insert a Chart in Sheets into a Google Slides

Open Google Slides.
Go to Insert -> Chart -> Google Sheets.
Select the spreadsheet from the list.
Select the chart you want to insert.
Click Insert.

If keep the default for linking the chart, if a change is made on the spreadsheet, you can update the chart on the Google Slides.

Example Chart in Google Slides

Google Sheets

Google Sheets in Screenshots

The following presentation was created during the Thursday, April 23rd Office Hours.

Sheets - Make a Copy.webm

Make a Copy of a Sheets Template

Move your cursor over the folders below. Select the box with a diagonal arrow to open the folder.
- You can also click directly on the Sheets example.
Open the Sheets. Notice you only have View access.
Go to File -> Make a copy.
- Make sure to move the file to a folder of your choice.
Click Okay.