Maximizing Training ROI- Evaluating and Demonstrating Value with Excel
This program will overview the concepts of program evaluation and ways to quantitatively demonstrate both learner satisfaction and improvement. Using Excel functions, graphing tools, and data analysis toolpak, we'll build statistical reports and graphs that will demonstrate the real results of your course.
comments
My sample data file isn't up on the session files page yet. I've attached a copy here, just to play it safe.
All you'll need is Excel and the Analysis Toolpak (free from Microsoft). This data file should just save some time and typing in class.
I'm using Excel 2003. Can I use the Analysis Toolpak?
No problem!
Here are the instructions:
http://office.microsoft.com/en-us/excel-help/load-the-analysis-toolpak-HP001127724.aspx
I hope you all enjoyed the session. We had a great turnout and some very good questions. We covered a lot of sometimes fuzzy topics pretty quickly, so let me know if you have any follow-up questions.
The biggest ideas to take away (and, thus, the ideal topics to ask follow-up questions about) are:
- The concept of confounding variables; what statistics can legitimately tell us and what it can't
- descriptive statistics, so we know where the center and spread of the data is. Is the data oddly distributed? Skewed high or low? Tightly grouped or spread out?
- inferential analysis of:
-- two tests given to the same group
-- one test given to two groups
-- two variables taken from the same test, same group (correlation)
'Looking forward to seeing everyone in the session!
The great thing about the BYOL concept is that on one hand, you don't have to be an Excel guru to get this. Follow along, and you'll be fine.
On the other hand, those experienced with Excel will get to explore the Analysis Toolpak and learn the underlying statistical concepts. We'll be getting into *both* the how and the why.