Using Excel's Pivot Table to Analyze Learning-Assessment Data Workshop

February 13, 1:30pm - 2:45pm
Mānoa Campus, KUY 106

Making Program Assessment Happen Workshop Series by the Assessment Office

Are there quick and easy ways to check data accuracy, summarize data, and present data? Yes! Excel's Pivot Table can help. 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)

Click to register


Ticket Information
Register at the Assessment Office website.

Event Sponsor
Assessment Office, Mānoa Campus

More Information
Assessment Office (Yao Hill), 956-4283, airo@hawaii.edu, http://www.manoa.hawaii.edu/assessment/workshops/index.htm

Share by email