Mastering Advanced Excel Techniques for Enhanced Program and Course Assessment

Thursday, October 10, 2024

11:00 AM – 12:20 PM East Coast USA Time

Location: Capitol/Congress (M4 Level)

CMEs: 1.25

Primary Speaker(s)

Shaun Grammer, DMSc, PA-C

PA Program Director
UNMC
Gretna, Nebraska

Slides Handouts

Co-Speaker(s)

SH

Shaun Horak, DMSc, PA-C, DFAAPA

DMSc Director / Associate Program Director
University of Nebraska Medical Center
Kate West, DMSc, PA-C (she/her/hers)

Assistant Professor, Academic Director
University of Nebraska Medical Center
Omaha, Nebraska
Melissa D. Soester, PhD, PA-C, CAQ-EM, DFAAPA

Assistant Professor, Research Director
University of Nebrska Medical Center
Louisville, Nebraska
Jannelle Reynolds, MPAS, PA-C, DFAAPA (she/her/hers)

Associate Professor
University of Nebraska Medical Center
Kearney, Nebraska

Disclosure(s):

Shaun Grammer, DMSc, PA-C: No financial relationships to disclose

Shaun Horak, DMSc, PA-C, DFAAPA: No financial relationships to disclose

Kate West, DMSc, PA-C: No financial relationships to disclose

Melissa D. Soester, PhD, PA-C, CAQ-EM, DFAAPA: No relevant disclosure to display

Jannelle Reynolds, MPAS, PA-C, DFAAPA: No financial relationships to disclose

Description: Enhance your proficiency in advanced Excel techniques for program assessment and course evaluation in Physician Assistant (PA) education. Join an immersive workshop featuring practical demonstrations and hands-on exercises. Learn to navigate complex data sets effectively, empowering evidence-based decision-making and streamlining accreditation processes.

Learning Objectives:

Acquire Excel proficiency in utilizing pivot tables for analyzing and interpreting PA program assessment data, including understanding how to summarize, organize, and filter large datasets efficiently
Explore advanced Excel graphing techniques to visually represent PA education metrics and outcomes effectively, including creating trend lines, histograms, and scatter plots to identify patterns and trends
Develop skills in creating dynamic dashboards in Excel for comprehensive PA program assessment, including integrating multiple data sources and interactive elements for enhanced data visualization
Learn to implement Action Plan templates in Excel to facilitate data-driven decision-making in PA education, including tracking progress, setting goals, and assigning responsibilities
Understand the application of Excel conditional formatting to highlight key insights and trends in PA program assessment data, including identifying outliers, highlighting significant changes, and visually emphasizing important information