Everything you want to know about Google Sheets

Eric Curts shared several resources (as well as a fifty-minute video) with everything you need to know about sheets.  If you are a novice or just trying to learn some new techniques, please check out this post here.

Shortcuts for sheets

 Are you a big Google Sheets user?  Then check out these top 20 shortcuts from Alice Keeler.

New to Google Sheets?

If you are looking to get started in Google sheets, Alice Keeler has the post for you. She will walk you through the steps as well as classroom suggestions.

Holiday Math in Google Sheets

Eric Curts has shared a 12 Days of Christmas Math activity in Google Sheets.  Please see his post here.

Spreadsheets for all (tips for ELA)

If you have ever seen one of Alice Keeler’s video tutorials- you will know her mantra- “Spreadsheets do everything!).  In this blog post, she shared 4 tips for ELA teachers (that will also work for the rest of us!).

Tilt the text

 

Ever want to tilt the text in a Google sheet?  Kasey Bell (ShakeUpLearning) shared this quick video that will get you started.

Merging cells (the easy way!)

Alice Keeler shares this short video on how to merge cells (and then copy into a Google Form).  As she demonstrates, this is great when you want to merge both first and last names. Please see the video here.

Using Google Sheets as a Checklist

 

I am all about trying to get better organized- here’s another suggestion from Alice Keeler to use the check-off and sorting feature in Google sheets- she has even provided a template for you to copy.  You can read the blog post here.

Editing in a Spreadsheet

Spreadsheets are great for collecting data and sorting- but you did need to be careful if you don’t want to erase information in a cell.  Please see Alice Keeler’s short video here and learn how Ctrl +z can become your best friend.

Using Check Marks with conditional formatting

Alice Keeler shares a template (as well as the directions) to enable checkboxes to change the color of your cells.  I just incorporated this into the Sayreville University sheets I use to track registration. For her template and blog post, please click here.

Checkboxes in Google Sheets

Alice Keeler shares her favorite method for using checkboxes in Google Sheets.  While she uses it to track resubmitted work, you can use them for a variety of issues.  Please click here to read her thoughts.

Answer the quiz and see..

The snowman!  This was an interesting spreadsheet project from Schooled inTech (written by Dave Carty).  Please click here to see the step by step directions (and to make a copy of the spreadsheet).

Conditional Formatting in Sheets

Those who have worked with me in the escape rooms have experienced conditional formatting.  Basically, you can set up rules in a spreadsheet cell to change color based on the response.  If a quick way to provide feedback to your students. Please see Alice Keeler’s blog post here for step by step directions.

Playing Math Games with Google Sheets

Want to play Connect 4 remotely?  Alice Keeler has just the solution in this blog post.

Yahtzee

My sister and I used to play this by the hour when we were kids.  Who knew it was a masquerading as a math game! Alice Keeler has shared some great ideas for using a Google Spreadsheet for Yahtzee!  Please click here for her post (which includes suggestions and ideas for implementation).

Everything you need to know about photos in sheets

Looking to insert an image in Google Sheets?  Alice Keeler’s post here shows you everything you need to know- from inserting to resizing.

Using Google Checkboxes and strikeout together

Let’s say you have a spreadsheet and you are keeping track of anything (library books, signed reports cards, permission slips).  In the first column, you have the checkboxes with the student name. Using these directions from Alice Keeler (please click here) you can put a strikeout through the name when you click the box.

Having all the students answer on one spreadsheet

You start with this spreadsheet:

Go ahead and enter the names in the first column (you don't need

email addresses since you can share this as edit in Google Classroom).

Then go ahead and create a template- what do you want the students to have?

It doesn't have to be an image (as in my example) you could provide questions

or prompts.

Once you run the Roster Template, this is is what you get:

You will get a tab for each student complete with the drawing you shared.  

While I used a fairly simple one, you could ask the students to expand their

thoughts. I think this would be great to use for younger learners.

For complete directions (as well as a copy of the first spreadsheet), please

see Alice Keeler’s blog post here.

Spreadsheet data to a map!

(Click here for see an interactive view)

On his site Free Technology for Teachers, Richard Bryne recently shared how

to import spreadsheet data to a map. I watched his video and then created my

own.  This one shows the locations where I’ve lived.

Think how you could use this in a novel or historical event.  And it is very easy to do.

Here’s Richard’s video:

Make those spreadsheets work for you!

Ever used a form to collect data?  Do You get frustrated when you need to

keep adding formatting (wider columns or text wrapping)?  In her blog post,

Alice Keeler has easy directions to create your own Macro and have the

lines adjusted automatically!  I just tried it and it worked flawlessly!