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.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 21st or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session as we learn how to revolutionize your assessment strategies. We will dive into the essentials of crafting high-quality rubrics that go beyond traditional scoring methods to offer rich, meaningful feedback. We’ll learn about the components of an effective rubric and how to mathematically ensure the accuracy of your assessments.

Exit this pop up by pressing escape or clicking anywhere off the pop up.