Are you interested in data cleaning and visualization? Do your students use Google Sheets? Want a ready-made project for your class that uses Google Sheets for data cleaning and visualization? I have developed a case that is suitable for introductory accounting that uses just Google Sheets – and I provide step-by-step tutorial videos, making it […]
Continue reading
Archive | Data analytics RSS feed for this section
A job cost mini-dashboard for a quick data analytics exercise
April 13, 2022 
5 Comments
Looking for a quick data analytics exercise for introductory managerial accounting? You can give your students the link for this job cost analysis dashboard and then ask a series of questions. There is no software for students to install; the dashboard is hosted on Tableau Public and can be accessed by anyone with the link […]
Continue readingNew! Beginning Data Cleaning (ETL) & Analytics Project for Excel: KAT Concession Supply
March 25, 2022 0 Comments
Just posted this project on the other blog I co-author, Accounting Is Analytics. I am really excited about this project – it introduces accounting students to basic data cleaning and analytics concepts using Excel. Read on for how to request this first beginning level project that uses Excel for data cleaning and analytics. A key […]
Continue readingUpcoming Webinar: Bring Data Analytics to Your Classroom with Google Sheets
February 24, 2021 7 Comments
On Thursday, March 18, 2021, from 3 to 4 pm Eastern, I will be presenting at an Ohio Society of CPAs webinar on how you can use Google Sheets to bring data analytics into your classroom. You can register for free at this link. This webinar will feature a Google Sheets data analytics project I […]
Continue readingNew! Constructing an Interactive Excel Dashboard project for introductory managerial accounting available
February 23, 2021 2 Comments
Note from Wendy: This case is the fourth of the four interactive Excel dashboard cases I created around the Jubilee Superstores data set – so if you have been following this blog, you have already seen the prebuilt dashboard in financial accounting project, the constructing a dashboard project for financial accounting, and the prebuilt dashboard […]
Continue readingNew! Prebuilt Interactive Excel Dashboard project for introductory managerial accounting available
February 8, 2021 5 Comments
This new case has students use a prebuilt interactive Excel dashboard to analyze a company’s product contribution margins and segment margins. 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, […]
Continue readingNew! Constructing an Interactive Excel Dashboard project for introductory financial accounting available
January 13, 2021 0 Comments
In this new case, students build an interactive Excel dashboard to analyze sales transactions. Students will view tutorial videos for each of the five sections in the project and will use their dashboard to answer the case questions. The case will take students, on average, 60 – 90 minutes to complete. The Teaching Notes for […]
Continue readingNew! Prebuilt Interactive Excel Dashboard project for introductory financial accounting available
January 12, 2021 5 Comments
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 […]
Continue readingNew! Google Sheets data analytics case for introductory accounting available – City of Magicville
January 11, 2021 2 Comments
This new case is designed to be completed using Google Sheets for an introductory financial accounting class. The case can be completed by students using Chromebooks. I am really excited to be able to share this case – it is the second one I have created that uses Google Sheets as the software (see this […]
Continue readingNew! Google Sheets data analytics case for introductory financial accounting available – Kent Cabinet Hardware
November 4, 2020 0 Comments
This new case is designed to be completed using Google Sheets. The case can be completed by students using Chromebooks. I am really excited to be able to share this case – it is the first one I have created that uses Google Sheets as the software. Read on for details…. Data set background This […]
Continue reading
Accounting in the Headlines 