$100 for EASL Members
$125 for General Public
Interactive Data Dashboards with Excel and Google: Advance Level
This advanced workshop will take your dashboards to the next level. In this hands-on, step-by-step workshop, Shelly and Tom will provide best practices in dashboard design to make your dashboards really pop. They will also teach you how to incorporate inferential statistics (e.g., t-tests) into your dashboards that update and as you slice- and- dice your data. Throughout the course, you will learn advanced features in Excel to maximize the impact of your dashboards. As part of your participation in this course, you will have access to 6 sample interactive dashboards in Excel that you can use in your own practice. Excel features to maximize the have the chance to learn some "smart" visualizations that your clients will be asking "how'd you do that?".
You will learn:
- Best practices in designing your dashboards to maximize impact
- Four effective dashboard layout techniques
- Advanced features in Excel to customize your dashboards for various stakeholders
- How to integrate inferential statistics (e.g., t-tests) into your dashboards
- Knowledge of both PivotTables and Slicers in Excel is required (Consider taking the beginner workshop on December 4th to get caught up!)
(Note that times listed should be automatically updated for your current time zone. The session will be from 1 - 3 pm, 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.