Scenario: You have recently rolled out a new approach to employee onboarding and the initial training for cashiers at a retail grocery chain. The new program is an e-learning program in which new hires spend the first week going through automated materials. Your brand has an excellent reputation, and you are tracking a number of outcomes from the training. Overall your goal is to see if the new training is at least as effective as the old methods. The new e-learning has a larger up front cost, but would be more cost effective on a per-trainee basis. Despite the potential for cost savings, the organizational stakeholders are also cautious about implementing new systems if they lead to worse customer outcomes (e.g., scan times), or worse employee outcomes (e.g., job attitudes). Follow the steps below to evaluate the efficacy of the training program. For additional information about each variable, see the variable labels sheet.
Section 1: Prior to formally analyzing your data, you need to get all of the data onto a single shee. Then you will want to visualize various aspects of the training data so you can get some initial insight into what is happening with the two training programs.
Instructions Responses/Completion Status

1. Using Vlookup or Xlookup, take the training outcomes data from the “training outcomes” sheet, and move it over to the “activity data sheet”.
2. Which training evaluation outcome category would each of the 4 training outcomes fit into?
3. Once completed, create a pivot table for the entire dataset.
4. Using the pivot table, create a data visualization for Pre and Post training inclusiveness separated by the training condition. Be sure to label the data visualization appropriately, and paste the graph on a new sheet labeled “graphs”.
5. Using the pivot table, create a data visualization comparing the two training groups on the other 3 training outcomes (usefulness rating, process knowledge, & scans/minute). Note, you can make 3 separate visualizations or fewer visualizations, with multiple outcomes on each graph.
6. Based on these data visualizations, you just created, provide a brief (e.g. 4-6 sentence) overview of what you see happening with the two training programs.