New! Prebuilt Interactive Excel Dashboard project for introductory financial accounting available

This new case has students use a prebuilt interactive Excel dashboard to analyze sales transactions. This dashboard is ready for students to use; students will view a tutorial video about the case, read the instructions, and use the Excel dashboard to answer the case questions. The case will take, on average, 15 – 20 minutes to complete.

Overview

This interactive Excel dashboard project shows students how to drill-down into a company’s sales data, gaining a deeper understanding of the company’s sales and how this information can be used for financial accounting and decision-making.  Students will use an Excel interactive dashboard to analyze sales transactions. A tutorial video and student case handout will guide students through the information needed to complete the case. Several resources have been developed for this case to make it easy to integrate into courses; more information follows about how to access the Teaching Notes for this project.

Background

This Jubilee Superstores data set is based on retail sales transactions. The data set contains more than 1,000 sales transaction records for two years. Each sales record contains information on product, region, division, and more. All data and names are fictitious. For this prebuilt Excel interactive dashboard project for financial accounting, students will not be working directly with the data, but will be interacting with a dashboard that is built using the data.

Case learning objectives

After completing this case, students will be able to:

  1. Describe a dashboard
  2. Define a slicer
  3. Analyze sales data using the dashboard

Case resources

The following resources are available for this case:

  1. Student case handout
  2. Interactive Excel dashboard files for Windows
  3. Interactive Excel dashboard files for Mac
  4. Step-by-step tutorial videos (captioned)
  5. Scripted tutorial video slides (pdf)
  6. Multiple-choice questions with answers for each of the two data sets
  7. Video assignment instructions

Student case handout

The student case handout provides background on the case and data set. It also contains the requirements for the case and frequently asked questions. The student case handout also provides the instructions for the case, including the links for the tutorial video and the scripted tutorial slides in pdf format. The learning objectives are listed in the student case handout. It also contains the data dictionaries for the data set. You can download the student case at this link.

Requests for the Teaching Notes

***You can request the Teaching Notes for this Prebuilt Interactive Excel Dashboard project for introductory financial accounting by filling out the form at this link.***

Give me about 5 – 8 days to respond – but check your Spam folder for the email if you do not see my email within that approximate time frame. (You may want to add drwendytietz@gmail.com to your Safe Senders list. Please don’t send an email to that address – that is an email address used solely for distributing instructor resources. Thank you!) You will need to fill out a brief form and then we will verify your instructor status prior to sending you the Teaching Notes. We generally send the Teaching Notes within a week after the request; we will contact you if we need additional information to verify your instructor status.

A related interactive dashboard case is being posted tomorrow

Tomorrow I will be posting a related, longer interactive Excel dashboard project – tomorrow’s dashboard project has the student construct the dashboard in Excel. Students can complete this initial project that has them use a prebuilt interactive Excel dashboard to learn how to use a dashboard, and then can work on a project where they learn how to build the dashboard (using tomorrow’s project.)

I hope you and your students find value in this interactive Excel dashboard data analytics case for introductory financial accounting. Please share any feedback with me about your experiences in using the case. Enjoy and happy learning!

Wendy Tietz, wtietz@kent.edu

About Dr. Wendy Tietz, CPA, CMA, CSCA, CGMA

Dr. Wendy Tietz is a professor of accounting at Kent State University in Kent, Ohio, USA. She is also a textbook author with Pearson Education.

5 Responses to “New! Prebuilt Interactive Excel Dashboard project for introductory financial accounting available”

  1. I am so excited for this! How do I get it?

  2. Are the students suppose to see the completed dashboard when they open the file? I am only seeing the data set and can’t locate any instructions on how to create the dashboard. Am I missing something? Thanks!

    • Dr. Wendy Tietz, CPA, CMA, CSCA, CGMA Reply January 13, 2021 at 9:36 am

      AUGH, as much proofreading as I do…sigh. Okay, I edited the links to point to the dashboard files rather than the data files now. I apologize! Now if you go back to the email where I sent you a link to the teaching notes and re-download the teaching notes, the links should be fixed (if the teaching notes document says “updated 1/13/2021” at the bottom, you have the current version.) Thanks for the heads up.

  3. Awesome! Thanks so much. Both my students and I really enjoy these cases and it allows me to put some “real life” practice into the course.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: