Using Excel's Pivot Table to Analyze Learning-Assessment Data WorkshopFebruary 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)
Register at the Assessment Office website.
Assessment Office, Mānoa Campus
Assessment Office (Yao Hill), 956-4283, email@example.com, http://www.manoa.hawaii.edu/assessment/workshops/index.htm