Category: Google Sheets (page 1 of 4)

Must Count All The Things

Whenever I think of counting, I think of The Count from Sesame Street. He loves to count. And, he counts everything. When storing data in a Sheet, you may want to count how many students answered “True” to a question or how many parents indicated they are available to chaperone a field trip. Rather than counting each row manually, use the CountIf function:

For example:

=CountIf(J2:J100,”True”)

Click here to view a brief video on this cool Sheets feature!

Formatting Comments in Google Docs

Have you ever wanted to format your comments in Google Docs to get your point across and make it clearer?  

If so, I have great news!  You can bold, italicize and strikethrough text in a Google Doc comment with a couple easy keystrokes.

For bold text:

Add an asterisk on both sides of the word or sentence you wish to bold  

*BOLD*

After clicking comment, the text will appear like this:
For italicized text:

Add an underscore on both sides of the text or sentence you wish to italicize

 _italicize_

After clicking comment, the text will appear like this:
For Strikethrough text:

Add a hyphen on both sides of the text or sentence you wish to strikethrough  

-strikethrough-

After clicking comment, the text will appear like this:
For All Three

Place an asterisk, hyphen and underscore on both sides of the text or sentence, making sure each side mirrors the other.

After clicking comment, the text will appear like this:

In addition, these tricks also work in Sheets and Slides (and anywhere else that you can use Google’s commenting system).

Create QR Codes Right in Google Sheets

You know what QR codes are, right? They are those funky square images that you can scan and be instantly transported to a website. But QR codes are so much more than that.

You can create QR codes that provide directions, prompt the user to make a phone call, share contact information and more. QR codes are very useful, especially to educators. But how can we easily create them? Sites such as QRStuff.com are helpful, and the Goo.gl URL shortener had them built in (but Goo.gl is going away in a few weeks). read more

Adding Images to Sheets Using a Function

In this article, we will explore how to insert an image found on the Internet into a Google Sheet by using a predefined calculation known as a function. One of my favorite functions to use with students is IMAGE.

Google Sheets lends itself to collaboration because of the rows and columns. It keeps information organized. As a teacher, you could share a Google Sheet with edit privileges and ask each student to enter their name and add an image. For example, students could add an image to describe their mood, research project idea… the options are endless. read more

Math + Pixel Art = Engaging Activity

This week’s tip builds on a previous one that Kristie Hughes did on Pixel Art. I highly recommend that you read Kristie’s tip when you get a chance, but the TL:DR version is this: You can use conditional formatting in Google Sheets to color cells to make pictures. This is called pixel art, and it used to be done manually using graph paper. Here’s an example of a Mario character that is done as pixel art:

I have been helping the second grade classes at Montpelier Elementary School to learn more about using Google. Since the holidays are coming up, I wanted my last class before Christmas break to be a fun and engaging one (teachers, you know all too well how the kiddos can be right before a break!). So I decided to combine pixel art with math facts and it was an awesome activity! read more

Older posts

© 2019 Tech Tuesday Tips

Theme by Anders NorenUp ↑