Data analytics project: Fixed Asset Schedule, Hula Hut Burger

Overview of this project

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.

Project resources

Learning Objectives

  1. Create a pivot table in Excel
  2. Format a pivot table
  3. Apply filters to a pivot table
  4. Create sum columns in a pivot table
  5. Create a calculated field
  6. Use the slicer tool in a pivot table
  7. Analyze data for errors
  8. Use the timeline tool in a pivot table
  9. Create a pivot chart in Excel

Office 365 or Excel 2016 (newest version)

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.

Solution

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.

Other Projects

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!

Surrounding Yourself with Great Colleagues

pexels-photo-601170.jpeg

This journey into creating a blog with my teaching ideas and projects began because I have great colleagues! My colleague and friend, Wendy Tietz, suggested that I build a website to host my projects and teaching ideas on. She and I are working on a project to incorporate Big Data Analytics into the Intro Accounting courses. and I have just developed my first big data project (Hula Hut Burgers – watch for it to be published soon!).

I don’t know much about this blogging thing, though, and so I plan on relying on Wendy for lots of help. That’s the great thing about surrounding yourself with great colleagues – I am a better educator because of them! So, stay posted! I’ll be updating this site as I go along.