Home » Google » 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.



Click Here for the sample pivot table

5 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!

  2. Pingback: What I’m Learning: Creating Pivot Tables in Google Sheets | Learning is Change

  3. Pingback: 07: 2015-03-03 CI100 | CSUF CI 100 Keeler

  4. Pingback: 07: 2014-03-03 CI225 | CSUF CI225

Leave a Reply

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