Smore logo
remove_red_eye 380
page background

Google Sheets

The "digital" version of EXCEL ...only better!

Google SheetsThe "digital" version of EXCEL ...only better!

What is Google Sheets?

Google Sheets is the digital version of Excel Spreadsheet. As with Google Docs, you do NOT have to remember to save your sheet because it is in the "cloud." Meaning: You NEVER have to "SAVE" your spreadsheets again. It automatically saves AND as long as you have the internet...you can access the sheet! Today we will explore 'Google Sheets'!

How can I use Google Sheets in my Classroom?

1.) You have the ability to access the document ANYWHERE, ANYTIME.

2.) You can 'SHARE' documents with your colleagues or students.

3.) You can 'COLLABORATE' on documents AT THE SAME TIME.

4.) You can explore templates that have already been created.

How to create a new Google Sheet

zoom_out_map

Sign In

Sign into your email account.
zoom_out_map

App Launcher

Click on the App Launcher grid in the top right corner and select 'DRIVE'.
zoom_out_map

New Sheet

Click on the 'NEW' button and select 'Google Sheets'.

Google Sheets Introductory Task

1.) Once you have created a New Google Sheet, click on 'Untitled Spreadsheet'

2.) Change the name of the spreadsheet to: 'Google Spreadsheet Test'

3.) Find Column 'A' ---> Find the Number '1'

4.) In Column A, type the following numbers in the correct location (see picture below).

5.) Hover your mouse over the letter 'A' (column heading) and click on the arrow that appears on the right side.

6.) Select 'Sort Sheet A --> Z'

7.) Your numbers should be listed in the correct order, 1 - 10

zoom_out_map

zoom_out_map

zoom_out_map

Google Sheets Challenge- Make Your Own Flash Cards

1.) Click on this link and make a copy of the Flippity.net Flashcards Template

5.) Create your own set of 5 flashcards by editing the text in columns A and B. You can include links to YouTube videos as well.

6.) Click on 'File' and select 'Publish to the Web.'

7.) Click 'Publish' and then copy the link from the box.

8.) Back in the sheet, click on the 'Get the Link Here' tab at the bottom.

9.) Paste the link in the green box. The link to the Flashcards will appear in cell A6.

10.) Click on the blue 'Share' button to get the 'Shareable Link.'

11.) Copy the link and click on the 'Google Sheets Badge' button below.

12.) Complete the form and paste the link in the 'Submit Your Link HERE' box.

Google Sheets Badge

Lots of fun tools in Google Sheets! Lots of fun tools in Google Sheets!

Recording #8

Tweet About It! Tweet About It!

Tweet out about this badge and use the hashtag #fcsbragboard!

More Ways To Use Your Google Sheets
Home Page
Loading indicator

close

Created with

Communicate quickly and effectively with interactive newsletters.

Smore empowers educators to connect with their community, streamline school communications,
and increase engagement.

Create a newsletter