Category: Google Sheets (page 1 of 3)

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

It’s Here! Checkboxes for Google Sheets!

Google recently launched this new feature in April 2018 which makes it very easy to insert checkboxes in Google Sheets, and allow us to use Google sheets as tasks lists. Use checkboxes for many purposes like to take attendance, track a project, and check off your to-do list.

Let’s take a look:

Open a spreadsheet in Google Sheets.  If you are using a spreadsheet from a Google Form you will need to insert a column for your checkboxes.  Click Insert > Column left

Highlight the range of cells or the column for where you want the checkboxes. In the top menu, click Insert > Checkbox read more

Older posts

© 2018 Tech Tuesday Tips

Theme by Anders NorenUp ↑