$100 for EASL Members
$125 for General Public
Creating dynamic dashboards in Excel and Google is a fantastic and cost-effective way to view important data with minimal construction time. This workshop takes you through all you need to know to design interactive dashboards from start to finish in Excel and Google Sheets. Shelly and Tom will provide you with practical, hands-on, step-by-step instructions to turn your static data table into a dynamic dashboard that will “wow” your stakeholders. We will demonstrate how to use Pivot Tables, PivotCharts, and Slicers to create well-designed dashboards that allow your stakeholders to slice-and-dice the data in seconds. You will leave the workshop with clear steps that you can immediately implement to create stunning dashboards that are pliable, dynamic and easy to reproduce.
You will learn:
How to use PivotTables, PIvotCharts, and Slicers to create interactive dashboards
Quick visualization tips and tricks to customize your dashboards for stakeholders
How to secure your dashboard using built-in protection features
Different chart types to display data in the most meaningful way
Basic knowledge of Excel (e.g., charts, basic formulas)
PivotTable knowledge is helpful, but not necessary to take this workshop
(Note the time zone should be updated to your local time. The session is planned for 1 - 3 p.m. Central Standard Time.)
Tom Withee is a Senior Researcher at Goshen Education Consulting Inc and is their data visualization expert. His involvement with STEM Education for over 15 years and his passion to make STEM Education accessible for everyone is evident throughout his work. Tom is an active member of the American Evaluation Association, with a focus of STEM Education, K-12 Education, and Data Visualization. As a founding member of the Evaluation Association of St. Louis, he shares his insights on data visualization and clear, concise reporting. Tom lives in rural Edwardsville with his wife, two children, a dog, three cats and five chickens. When he is not crunching numbers, he enjoys training in Tae Kwan Do with his family.
Shelly Engelman, Ph.D., is the Director of Research and Evaluation at Custom EduEval LLC in Austin, TX. She earned her PhD in Social Psychology and has over 10 years of research and evaluation experience. Dr. Engelman has been a lead data analyst and behavior science methodologist on over 40 federal and state funded grants and programs. She has a strong knowledge of evaluation and research methodology and theory, as well as an expertise in survey design and advanced statistical modeling techniques (e.g., Structural Equation Modeling, Propensity Score Matching, etc.). Dr. Engelman has led over 20 workshops, seminars, and demonstrations for a variety of clients including, Centers for Disease Control and Prevention (CDC), Governor’s Office of Student Achievement (GOSA), and the University of Texas at Austin (UT Austin). Prior to working as an evaluation and research consultant, Dr. Engelman taught an array of undergraduate courses at the University of Delaware, such as Research Methods, Statistics, and Social Psychology.
Evaluation Association of St. Louis is a 501(c)6 business association.
P.O. Box 7901
Chesterfield, MO 63006