One of the most time-saving techniques that I figured out over the past few years is how to integrate paired samples t-tests into my interactive dashboard. Think about it: By including t-tests, my dashboards are basically calculating scores and scores of paired samples t-tests behind the scenes!
For instance: Say you want to know if females, in particular, showed statistically significant gains? Boom!...Click on the slicers in my interactive dashboard, and you'll get your answer in seconds! What about females who are underrepresented minority students and who are majoring in Physics? Yep...my dashboard will calculate that for you in an instant!
Want to know the steps?
Okay...the following is an actual conversation (recreated from memory!) that I had with a client, and underscores the need to include a dynamic "n" count in your interactive dashboards...
Once you've created your interactive dashboards in Excel using my famous PARCS method, you will be tempted to share your Excel workbooks with clients and colleagues. You designed something amazing, and it only makes sense that you would want to share it with the world, right?
Aren't you forgetting something???
Tip #2: consider replacing your pre/post survey with a REtrospective survey...but only under certain conditions
Do you use traditional pre/post surveys to assess programmatic impact on participants? If so, you might have encountered the following known problems:
Hi y'all! I'm Shelly Engelman, Ph.D.