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.
Join Alice Keeler, Thursday April 15th or register to gain access to the recording.
Create a free OTIS account.
Join Alice Keeler for this session for teaching with AI
Unlock a smarter way to manage your curriculum by turning your own teaching materials into a personalized AI assistant with NotebookLM. This session explores how to transform static documents into interactive study guides and audio overviews that are tailored strictly to your specific content. You will discover how this versatile note-taking tool can streamline your prep time and help you organize complex resources with ease. Join us to see how NotebookLM can act as a powerful, free partner in your K-12 classroom.
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.