Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Simple: Make a Pivot Table

Simple Summarize data in pivot tables in google sheets

Simple: Make a Pivot Table

Summarize Data with Pivot Tables

Pivot tables in Google Sheets summarize data. They are super useful for teachers and happily really simple! The first thing you need is data in a spreadsheet where information repeats. One of the easiest ways for this to happen is to use Google Forms with multiple choice options to ensure that the data is all spelled exactly the same way.

Sample Pivot Table

I used this Google Form to collect data that I want to summarize. Notice in the image below I used a pivot table to count how many responses there were for each option.

Pivot table summarizing google form data



New to Google Sheets ad banner

Updated Tables

The default option when you create a pivot table is to have it automatically update. You can turn this off, but notice in the image below that the same pivot table now summarizes 9 responses instead of 7.

Pivot table from a google form

Highlight Your Data

In the spreadsheet of data, highlight the columns that contain information that you want to summarize.

Use the Data menu to choose “Pivot table.” A new tab will automatically be created for the pivot table.

Pivot Table Editor

On the right hand side of the new tab is the Pivot Table Editor. Notice the AI (Artificial Intelligence) provides suggestions for ways to summarize your data. Simply click on one of the suggestions if it seems helpful. Using the AI suggestion is obviously the easiest way to create a pivot table.

Pivot Table editor

Rows

Click on the “Add” button next to the word “Rows” in the sidebar to choose the column that you want to summarize.

In the sidebar click on the “Add” button next to “Values” to choose what values you to summarize. Pay attention to “Summarize by.” The Google Sheets Pivot Table Editor will automatically guess how you want to summarize the values. Did you want to count or sum? Tip to double check.

Summarize the values

Format Your Pivot Table

This is totally optional, but you may want to format your pivot table to make it easier to read. I like to center the values in the cells and make the columns a little skinnier for improved reading.

Formatted Pivot Table

Try It

Use this spreadsheet to practice making a pivot table.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

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

%d