In this case, the students help automate the creation of sales reports for Pure Guitar Inc. The case requirements include the completion of the overview case first. We strongly suggest this, although the case can be completed without this requirement. This case does not require the completion of the billing and tax form preparation cases, although the skills learned in those cases will be beneficial to complete this case. Students are required to generate this report in Microsoft Word with the information segregated by employee and by quarter and displayed using an Excel bar chart. Students will use the data from two .csv files and an Access database. Students will also be encouraged to utilize two additional UiPath packages to make the automation tasks easier (interaction with Microsoft Word (UiPath.Word.Activities) and the creation of a bar chart in Excel (BalaReva.Excel.Activities)).
Suitable courses: AIS, Data Analytics
Link to download files (requires login)
Join EYARC for Full Access
EYARC Experience
Turn case studies into powerful teaching moments for your students. Active EYARC users can explore our experiential learning platform to access cutting-edge curricula and innovative teaching resources.
Try It NowAcademic Case Materials
Access free resources to prepare students for the global marketplace. Resources include case studies, data sets, analytics workbooks, videos and many other tools focused on business and accounting topics.
To search by multiple tags, enter the search word followed by a comma and the next word, etc.
For example, entering "Audit, Excel, Intermediate" will list cases related to audit AND Excel AND intermediate difficulty.
To search by a single tag, enter it in the search box or click on the tag below in the Popular Tags area.
