Thank you for your interest in the data analytics cases developed by Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles. Here is a summary of our current data analytics projects and also the links to request more details (including instructor guide/solutions).
Remember, please maintain the academic integrity of these projects and do not post the instructor guide/solutions or share with students. Give us about 5 – 8 days to respond – but check your Spam folder for the email if you do not see our email within that approximate time frame.
This project uses fixed asset information from anonymized and modified data for a tax client from a public accounting firm. The data set includes 1,500 fixed asset records. In this project, the student will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, create calculated fields, use the slicer and timeline tool. In addition, students will be asked to analyze the data for errors. The students will prepare several different fixed asset schedules and also a pivot chart (column type) that depicts book value by asset category and region.
Anyone doing this project will need to have either Office 365 or Excel 2016. It is important that students update their version of Office 365 and/or Excel 2016.
If you would like to have a copy of the Excel solution file, please fill out the request form. (There is a separate request form for each project.) Once I verify your status as an instructor, I will email the file to you within a week. Please do not post the solution file on the internet and please do not share the solutions files with your students. The Excel solutions file is for you own use only.
I am working on this project in conjunction with my colleague, Dr. Wendy Tietz. You can find additional data analytics projects for introductory financial and introductory managerial accounting on her website, accountingintheheadlines.com. I will be developing additional projects in the coming months. Stay posted to the blog!