Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

How to Create a Pivot Table to Summarize Student Information

How to Create a Pivot Table to Summarize Student Information

Link to the presentation

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.


YouTube video

Click Here for the sample pivot table

2 thoughts on “How to Create a Pivot Table to Summarize Student Information

  1. 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!

Leave a Reply

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

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

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

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

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