Category: Google Sheets (page 1 of 4)

Customize Your Charts in Google Sheets

Google Sheets is a great tool to use to help keep track of data, analyze numbers, make calculations, etc. One of the many features of Sheets is the fact that you can create charts to visualize your data. There are various charts you can use and you can also customize them to make certain parts stand out.  

One of my favorite charts to use (depending on what kind of data you are analyzing) is the pie chart. First, you highlight all your data and then click on the chart icon. Once your chart is created, you can begin to customize it using the customize tab in your chart editor.  read more

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

Older posts

© 2020 Tech Tuesday Tips

Theme by Anders NorenUp ↑