Category: Google Sheets (page 2 of 4)

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

Google Sheets Pixel Art

Many people use Google Sheets to add numbers, create a budget, keep track of items, etc. However, there is a creative way to use Google Sheets that even preschools can take advantage of…Pixel Art!

This idea was found from the Google Apps for Littles book by Christine Pinto and Alice Keeler, and can be applied to any grade level.  The idea is that you use conditional formatting to change the colors of the cells. When a certain number is entered into a cell, that cell turns the color that you designate. For example, based on the picture below, if the number 4 is entered in any cell, once you hit your return key, that cell will turn green. read more

A (Dot) New Way to Google

There are several ways to create a new Google file. You can do it using the plus sign in Google Drive… or start a new document from a current one using the File menu… or go to docs.google.com/create.

Now there is a super easy way to start a new Google file… and it’s (dot) new!

Want to make a new Google Doc? Open a new tab and enter doc.newdocs.new or document.new in the address bar.


How about a Google Sheet? Try sheet.new, sheets.new, or spreadsheet.new.

Need a quick Google Form? That’s form.new and forms.new. read more

Split Text to Columns Easily

Sometimes the simplest features can be the lifesavers! Today’s tip is no different.

Have you ever had a list of names or other data that need split? In my example, I have a roster of students’ full names. This is not ideal, because I’d like to have them split by first and last so I can sort and perform other operations.

Previously, you would have to use something like the Power Tools add-on. I LOVED this add-on, but alas, it’s no longer free. But don’t fret… because this feature is now built-in to Google Sheets! read more

Summer PD Roundup

Summer is almost here! It’s a great time to relax, recharge and yes, even level up your technology proficiency. While Tech Tips Tuesday is going on our annual break, we wanted to leave you with some summer professional development opportunities.

Remember, all Northern Buckeye/NWOCA trainings are included with membership at no additional cost. You also have access to our archive of webinars, class materials, and other PD resources. Our training website at training.nwoca.org has all of these and more. If you’re unsure if your district is a member, check out the list on our website. read more

Older posts Newer posts

© 2020 Tech Tuesday Tips

Theme by Anders NorenUp ↑