Sort, Count, and Click: Google Sheets for Beginners

Contributor: Elephango Editors. Lesson ID: 10896

Make lists, count stuff, and color your clicks in Google Sheets!

30To1Hour
categories

Technology

subject
Technology
learning style
Visual
personality style
Otter
Grade Level
Primary (K-2)
Lesson Type
Quick Query

Lesson Plan - Get It!

Audio: Image - Button Play
Image - Lession Started Image - Button Start

What’s in the Toy Box?

Imagine you have a big toy box full of building bricks, action figures, and stuffed animals.

  • If you wanted to know how many of each toy you have, what could you do?

You could count them—and then write them down.

  • But what if the toys could sort themselves and make a chart for you?

That’s kind of what Google Sheets can do!

Google Sheets logo

What Is Google Sheets?

Google Sheets is like a big table made of tiny boxes. These boxes are called cells.

You can click in a cell and type anything you want—like words or numbers!

Here’s how you can use Google Sheets.

  1. Start a New Sheet

Go to Google Sheets and click the big plus sign to make a new sheet. It will look like a blank grid.

  1. Type in Your Data

Pick a box (any box!) and type in a word—like “apples.” Click the box next to it and type how many you ate, like “5.”

Try it again with other fruits, toys, or anything you want to count!

  1. Add a Title

Click in the first box at the top and type what your chart is about. You can write something like “Snacks I Ate This Week.”

  1. Make It Colorful

Click on a box. Then, find the paint bucket at the top and change the color. You can make each row or column a different color to keep things neat and fun!

  1. Make a Chart

Highlight the words and numbers you typed. Then click “Insert” and choose “Chart.” Boom! Google Sheets will turn your list into a picture—like a bar graph or a pie chart.

  1. Try Sorting

Click a column. Then click “Data” and choose “Sort.” Now your list can go from smallest to biggest or A to Z. It’s like magic sorting powers!

fruit and yogurt on a table

With just a few clicks, you can turn your numbers into a colorful picture and show what you’ve learned.

Google Sheets helps you stay organized and makes your work look super smart!

Head to the Got It? section to give it a try!

Image - Button Next