Google Sheets Tips for Teachers

Blog Posts, Distance Learning

Have you discovered the power of Google Sheets in your classroom? Google Sheets is one of my favorite yet often under-utilized products in Google Suite for Education. Check out some of these Google Sheets Tips for Teachers to get you started using Sheets!

Change the font

Click in the upper left hand corner to select all cells. Then you can select your favorite font, size, and even color that will apply to the whole spreadsheet.

Add your headers

In the top row, start typing your headers. For example, in my free Reading Fluency Tracker, I created the headers: date, accuracy, WPM (words per minute), expression, comprehension, and notes. If your header does not fit in the default width of the column, simply double click on the right border to match it. If you want to make it smaller to fit, double click on the left border. You can also select all the fields and drag to make them equal widths. 

Free headers

Go to view, freeze, and select 1 row. This will freeze your top row of headers. You can also view, freeze a column if you want to freeze a column like the date.

Customize headers

Create your own headers in Powerpoint and adjust the gradient and font. Screenshot and save the headers as images (PNG). When you click in your header cell, you can insert the words as images in your spreadsheet. 

Insert Student Name

For something like a Reading tracker, you may want to include a student name or title. 

To do so, click on row one and insert row above.

Drag across the cells, merge cells to put cells into one. Type student name or insert the image of their name. 

Format Cells

The next step is to format the cells depending on their purpose. 

Dates

Click the top of the column. Choose format/number/date to keep the date number the same.

Percentages

If you are keeping data like accuracy or grades, you can Choose format/number/percentage.

Drop down menu

Select the cells you want to have the drop down menu. Go to Data/Data Validation. A range of cells is already selected. Choose the “List of Items” then type what you want the items in the drop down menu to be (i.e. 1,2,3,4).

Checkbox

Go to insert checkbox. You can hover over the cell then drag to copy for the entire column until you stop your cursor.

If you want Google Sheets to calculate how many boxes you have checked, highlight them, then go to Data/Data Validation and choose use custom cell values. Then choose your values. For example, count the value as 1 if it’s checked, 0 if it is not.

Alternating Colors

Select the cells you want the alternating colors on. Go to Format/Alternating Colors. Uncheck the header then customize your colors. Light colors are easier on the eyes.

Borders

Select the cells and then click on the border icon on the tool bar. Choose the kind of border you want. The dotted border looks great! You may want to make your header with a darker border, for example. 

Conditional Formatting

To flag your cells with a certain color to alert to low grades or percentages, for example, you can use conditional formatting. 

Select the column. Go to Format/Conditional Formatting and make some rules. Go to format rules. For example, you can choose less than an equal to a certain percentage show up red. You can choose multiple rules and colors. You set the rules. Type in a number in the cell to test it.

To collect student data, nothing works better than Google Sheets! These Google Sheets Tips for Teachers will have you using Sheets to inform your instruction in no time. 

Do You Want To Receive Our Weekly Tech Tip Thursday emails?

Sign up below and I will email you a tech tip every Thursday!

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Welcome, I’m Angie!

Hello there! I’m Angie Olson- a teacher, curriculum developer, educational blogger and owner of Lucky Little Learners.

read more

Follow me on

Shop with us

Mark your calendar!

Mark your calendar!

 

Get notified when the party starts!  We are giving away prizes and having daily deals starting on December 7th!

You have Successfully Subscribed!