Using Excel’s Pivot Table to Analyze Learning-Assessment Data

This workshop looks at how Excel’s Pivot Table can help.

PowerPoint and Handout
Excel data file
Workshop Evaluation Report

Are there quick and easy ways to check data accuracy, summarize data, and present data? Yes!¬† Pivot table reports and charts can help organize large sets of data, observe patterns and trends in seconds, and graphically communicate findings to your colleagues and students. In this workshop, the presenter will demonstrate how to create and modify pivot tables and pivot charts to organize, summarize, and present data in meaningful ways. The presenter’s examples and hands-on practice will involve program learning-assessment data. The participants are expected to learn how to

  • set up pivot tables;
  • alter pivot table data;
  • sort tables and create filters;
  • format pivot tables for effective presentations; and
  • create pivot charts.

Level: Beginner (basic Excel skills needed for optimal learning)
Format: Demonstration + hand-on practice
Requirement: Please bring a laptop with Microsoft Excel installed (Version 2007 and 2010 are preferred)
Date/time/location: Wednesday, February 13, 2013, 1:30 PM – 2:45 PM, KUY106