Designing Interactive Dashboards Using Microsoft Excel and Google Sheets

CES Ontariois a provincial chapter of the Canadian Evaluation Society, a professional association of evaluators. Our vision is the recognition of evaluation as a valued and respected profession necessary for the well-being of all Canadians.CES Ontario supports evaluation and its practitioners in the public, private and not-for-profit sectors in Ontario through professional development, standards, member support, education and the promotion of evaluation.We welcome new members andnew graduates. To become a member, please visitCES National.

CES, Ontario Chapter (Canadian Evaluation Society)

A workshop for learners to develop their technical skills using Excel and Google Sheets to create interactive dashboards

CES-ON is pleased to offer a workshop for learners to develop their technical skills using Excel and Google Sheets to create interactive dashboards. Creating dynamic dashboards in Microsoft Excel and Google Sheets 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. This skill-building workshop will demonstrate how to generate an interactive dashboard in 5 easy-to-learn steps: Pivot, Analyze, Rename, Chart, and Slice. Using sample survey data, you will learn how to a) use a Pivot table to analyze data, b) create a chart using PivotCharts, c) incorporate Slicers and d) create a professional looking dashboard that allows stakeholders to slice-and-dice the data in seconds. Additionally, we will share best practices in dashboard design to make your dashboards really pop! Finally, we will demonstrate how to incorporate inferential statistics (e.g., paired samples t-test) into your dashboards that will update as you slice-and-dice your data. After attending the workshop, you will be equipped with clear steps that you can immediately implement to create stunning dashboards that are dynamic and easy to reproduce. This skill-building workshop is aligned to the following CES competencies: <ul><li>1.1- This workshop explores new thinking and practices related to interactive dashboards; </li><li>2.8- This workshop will give participants accessible tools and process to help them interpret and present their data;</li><li>2.10- By allowing evaluators and stakeholders the ability to interact with data, interactive dashboards promote complete and balanced evaluation reporting to support decision-making; and,</li><li>3.4- Interactive dashboards are an efficient way for evaluators and stakeholders to understand results in real-time.</li></ul>Evaluation learners and those interested in evaluation digital tools can benefit from this learning experience. Learners will need access to their own Microsoft Excel and Google Sheet to fully engage with the content of this workshop as well as a passion for learning new ways of mobilizing data for knowledge sharing. Workshop ScheduleSession Dates:		Monday, October 4 and Wednesday, October 6, 2021 Session Times:		12-1:30 pm for both datesAbout the FacilitatorsShelly 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 served as an external evaluator on over 40 federal and state funded grants and programs related to STEM Education. She has led over 20 workshops, seminars, and webinars for a variety of clients including, Centers for Disease Control and Prevention (CDC), Governor’s Office of Student Achievement (GOSA) in Georgia, and the University of Texas at Austin (UT Austin). Tom Withee is a Senior Researcher at Goshen Education Consulting Inc in Edwardsville, IL 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.

Designing Interactive Dashboards Using Microsoft Excel and Google Sheets

More events from CES, Ontario Chapter (Canadian Evaluation Society)

Discover more events from CES, Ontario Chapter (Canadian Evaluation Society), from Business to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Designing Interactive Dashboards Using Microsoft Excel and Google Sheets

More events from CES, Ontario Chapter (Canadian Evaluation Society)

Discover more events from CES, Ontario Chapter (Canadian Evaluation Society), from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.