AACRAO's 102nd
Annual Meeting

Afternoon Half-Day Workshops
Sunday, March 20, 12:30 PM - 3:30 PM

Creating Interactive Dashboards in Excel
ID: 4646
Fee: $140

No budget for specialized dashboard programs? New features in Excel 2010 and 2013 allow even casual users to create interactive dashboards that enable end-users to explore your data in ways you have only imagined. You only need some familiarity with how to create Pivot Tables for this workshop, and then we will go from there to explore more advanced options including PowerPivot, Slicers and more. It is surprisingly easy to turn out dashboards to impress!

Jennifer Chadwick, University of North Georgia
Loralyn Taylor, Ohio University

Curriculum Management & Registrars: Strong Partnering with Academic Colleagues
ID: 4761
Fee: $135
Registrars can and should play central roles in the curricular change process at their institutions. Learn about proven practices from two large public universities, where the Registrar’s Offices work as critical partners in the degree, course, and requirement change process.  The presenters will discuss how to avoid pitfalls such as unnecessary course prefix changes, unworkable repeatability, equivalency issues, and other challenges.

Julia Pomerenk, Washington State University
Rebecca  Mathern, Oregon State University

Federal Financial Aid Regulations and the Academic Record
ID: 4762
Fee: $145
Federal legislation regarding higher education, and particularly financial aid, has had a significant effect on institutional business processes and student services. Mounting compliance requirements impact many departments including student records. Presenters will discuss what this means for institutions and underscore the importance of building strong collaborative relationships between registrar and the financial aid offices on campuses. An interactive discussion on current compliance topics will be the focus of this workshop. Come prepared to share your experiences and practices.

James Kennedy, Indiana University
Kristi Wold-McCormick, University of Colorado Boulder

Improve Analysis of Large Data Sets and Create Interactive, Flexible Reporting
ID: 4502
Fee: $140
Providing timely and flexible analysis of large data sets can be problematic.  This session sets the foundation on building an Excel database that is focused on addressing strategic business questions around retention, admissions, and enrollment.  A data set will be provided for use during hands-on practice sessions in this workshop.  You will learn to build interactive dashboards with trend lines as well as other in-depth analysis.  Requirement:  Bring laptop with Microsoft Office/Excel 2013.

Janet Ward, Seattle Pacific University

Say Yes: Improvisation Techniques to Build Teams and Improve Performance
ID: 4484
Fee: $135
Learn how improvisation techniques can help you build teams, improve performance, and turn difficult situations into positive interactions, and receive tips for a variety of public speaking formats. This is an interactive workshop, and participants will join in activities and exchanges with the goal of learning how to "say yes" and achieve better outcomes in our registrar and admissions offices.

Ingrid Nuttall, University of Minnesota