Pivot tables are an incredibly powerful tool for summarizing information. When looking at data oftentimes there are repeats in the information. Multiple times a students name is listed. Multiple times an assignment title is listed. Multiple times a disciplinary action was taken. To make sense of a spreadsheet with many rows of information a pivot table can make sense of the chaos.
Click Here for the sample pivot table
© 2026 All Rights Reserved.
Get effective EdTech strategies from Alice Keeler to build a more student centered classroom. Includes unique resources and templates.
Join Alice Keeler, Thursday April 28th or register to gain access to the recording.
Create a free OTIS account.
Join Alice Keeler for this session for teaching with AI
Imagine having a team of teaching assistants who already know your syllabus and exactly how you like to give feedback. Join Google Certified Innovator Alice Keeler to learn how to use Google Gems to build a powerful collection of custom AI tools. We will explore how to engineer specific instructions so you can create a Grading Assistant or a Classroom Policy Manager that works for you. You will also learn how to leverage Gems shared by other educators to instantly expand your toolkit. This session is about super-powering your teaching by automating the routine tasks so you can focus on the students.
2 thoughts on “How to Create a Pivot Table to Summarize Student Information”
Are you presenting at a conference anytime soon? I need one on one tutoring! I still don’t know what pivot tables are, but I have a feeling this could be helpful. I am struggling to grade all my students’ blogs. I have their links in a google spreadsheet and I would like a way to automate the feedback process. Thank you for providing the information!
I present at conferences frequently. I am also available for school districts to hire me for freelance professional development.