30-minute webinar on Excel data cleaning project next Tuesday, June 28, 11 am Eastern

Greetings! Just a quick reminder that next week on Tuesday, June 28, we are hosting a 30-minute webinar on our KAT Concessions: ETL (data cleaning) for introductory accounting Excel beginner project – how to request the instructor materials, what the project covers, how you can use it in your own classes, and more! We will also answer any questions you have. The webinar is from 11 – 11:30 am Eastern – you can register for this webinar and others at this link.

Hope to see you there!

Wendy, Tracie, and Jennifer

30-minute webinar tomorrow on KAT Mfg projects!

Greetings! Just a quick reminder that tomorrow, Wednesday, June 8, we are hosting a 30-minute webinar on our KAT Manufacturing data analytics projects for introductory accounting – how to request the instructor materials, what the projects cover, how you can use them in your own classes, and more! We will also answer any questions you have. The webinar is from 1 – 1:30 pm Eastern – you can register for this webinar and others at this link.

Hope to see you there!

Wendy, Tracie, and Jennifer

Data analytics review games for the classroom

board game icon

Okay, so confession here – my guilty pleasure is TV game shows. I have created a set of data analytics games based on TV game shows that are suitable for reviewing data analytics – perhaps at the end of a unit or the end of the semester. You will find Jeopardy, Family Feud, and Who Wants to be a Millionaire games below. In addition, I also created a Kahoot! and a Connect 4 game. There is no cost for any of these games. All files are editable. Here is the list including links to resources:

Jeopardy

Here is a link to a data analytics Jeopardy! game using the online platform Jeopardy Labs. You can use the one I have created for free. Instructions are found on the same link as the game.

Kahoot!

Here is a link to a data analytics Kahoot! game. If you need information about how to play Kahoot!, the Kahoot website has a lot of resources.

Connect 4

Here are links to a Connect 4 PowerPoint data analytics game and resources:

  • PowerPoint containing game (link)
  • Instructor Guide (link)

The Instructor Guide contains information about how to play the game in the classroom. It also contains all the answers to the questions in the game. The PowerPoint can be

Family Feud

Here are links to a Family Feud PowerPoint data analytics game and resources:

  • PowerPoint containing game (link)
  • Instructor Guide (link)

Who Wants to be a Millionaire?

Here are links to a Who Wants to be a Millionaire PowerPoint data analytics game and resources:

  • PowerPoint containing game (link)
  • Instructor Guide (link)

Anyways, feel free to edit as you see fit. Have a great day!

Wendy

A financial statement analysis mini-dashboard for a quick data analytics exercise

dashboard image
Open mini-dashboard at this link

Looking for a quick data analytics exercise for financial statement analysis in an introductory accounting class? You can give your students the link for this financial statement 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 to the mini-dashboard. There is also a quick video about using mini-dashboards in Tableau Public – that mini-dashboard intro video is available at this link.

To get you started on the kinds of questions you can ask with this financial statement analysis mini-dashboard, here are some ideas:

  1. What is the current ratio for <insert company name here> for <insert year here>?
  2. What is the quick ratio for <insert company name here> for <insert year here>?
  3. What is the debt ratio for <insert company name here> for <insert year here>?
  4. What is the times-interest-earned ratio for <insert company name here> for <insert year here>?
  5. What is your overall assessment of the financial condition of <insert company name here> based on the ratios given here?

We have made several of these mini-dashboards and have found that they are a quick and easy way to insert some data analysis into an introductory accounting course. More of these mini-dashboards are coming soon. We hope you find them useful.

Wendy

New! Google Sheets Data Cleaning project: KAT Concession Supply

Scheenshot
Request project at this link

The introductory accounting ETL projects continue…today we are releasing the data cleaning project for Google Sheets. Google Sheets is a nice option to have available in case your student(s) only have access to a Chromebook; this project will run entirely on a Chromebook.

A key step in data analytics is getting the data ready for use – in fact, this step can take more time and effort than the analysis of the data. This brand-new Google Sheets project focuses on the data cleaning aspect of data analytics and is appropriate for introductory accounting – but could be adapted to any accounting class. This Google Sheets case is designed to guide students through data cleaning and data analysis with step-by-step tutorial videos.

KAT Concession Supply is a fictitious company that supplies food, paper products, and other items to fairs, amusement parks, and other organizations. Information in the KAT Concession Supply data sets includes information about its sales over a three-year period. The data from KAT Concession Supply has errors and irregularities in it and it must be cleaned so that an interactive dashboard about its operations can be prepared. This Google Sheets project is classified as beginner because it takes less than an hour to complete the entire project and the steps are pretty basic.

Complete step-by-step tutorial videos and an instructor guide are available to make project adoption easy and painless in accounting courses. The project is available at no cost for instructors to use in their classes.

Beginner project for Google Sheets

The ETL and other tasks in the beginner version of the Google Sheets data cleaning project are:

  1. Widen all columns to automatically fit the contents
  2. Find and remove duplicate records
  3. Remove unwanted characters such as numbers, spaces, and nonprintable characters from fields
  4. Find and replace text with replacement text
  5. Change the case of a text field to uppercase or lowercase
  6. Format numbers
  7. Create a two-visualization interactive dashboard

Tutorial videos/PDFs

Complete step-by-step instructions are provided for this project. Students have the choice of viewing the tutorial videos or downloading a pdf file of the annotated slides. The tutorials for this project have been split into two parts:

  1. Part 1: Data cleaning tutorial (video | pdf)
  2. Part 2: Dashboard tutorial (video | pdf)

***You can obtain the Instructor Guide for the KAT Concession Supply beginning data cleaning project for Google Sheets by requesting it at this link.*** The instructor guide contains the data set, solutions, and other information.

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. (You may want to add drwendytietz@gmail.com to your Safe Senders list. Please don’t email to that email address – that is an email address used solely for distributing the project resources we have developed. Thank you!)

News flash: This data cleaning project is the third project in a set of ten data cleaning and visualization projects developed by Tracie Miller-Nobles, Jennifer Cainas, and me. We will be releasing new projects approximately twice a month for the remainder of 2022. These projects will be available in three levels: Beginner (five data cleaning techniques plus two-visualization dashboard); Intermediate (beginner steps with seven additional data cleaning techniques plus three-visualization dashboard); and Advanced (intermediate steps with additional data cleaning techniques plus four-visualization dashboard.) In addition, the projects will be available in four software tool combinations: Excel, Google Sheets, Tableau Prep combined with Tableau, and Alteryx combined with Power BI.

A job cost mini-dashboard for a quick data analytics exercise

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 to the mini-dashboard. We also have a quick video about using mini-dashboards in Tableau Public – that mini-dashboard intro video is available at this link.

To get you started on the kinds of questions you can ask with this job cost mini-dashboard, here are some ideas:

  1. What is the gross profit generated by the <insert product type here> product group in all plants?
  2. What is the total sales revenue generated by <insert product ID here> in the <insert plant location here> plant?
  3. How many <insert product ID here> models were sold by the <insert plant location here> location?
  4. What is the gross profit of the <insert product type here> product group in the <insert plant location here> plant?

Anyways, we have made several of these mini-dashboards and have found that they are a quick and easy way to insert some data analysis into an introductory accounting course. We will be sharing some of these mini-dashboards from time to time. We hope you find them useful.

Wendy

New! Beginning Data Cleaning (ETL) & Analytics Project for Excel: KAT Concession Supply

We are super excited to share the first of ten projects in a set that focus on data cleaning and analytics! Read on for how to request this first beginning level project that uses Excel for data cleaning and analytics.

A key step in data analytics is getting the data ready for use – in fact, this step can take more time and effort than the analysis of the data. This brand-new Excel project focuses on the data cleaning aspect of data analytics and is appropriate for introductory accounting – but could be adapted to any accounting class.

KAT Concession Supply is a fictitious company that supplies food, paper products, and other items to fairs, amusement parks, and other organizations. Information in the KAT Concession Supply data sets includes information about its sales over a three-year period. The data from KAT Concession Supply has errors and irregularities in it and it must be cleaned so that an interactive dashboard about its operations can be prepared. This Excel project is classified as beginner because it takes less than an hour to complete the entire project and the Excel steps are pretty basic.

Complete step-by-step tutorial videos and an instructor guide are available to make project adoption easy and painless in accounting courses. The project is available at no cost for instructors to use in their classes.

Beginner project for Excel

The data cleaning and other tasks in the beginner version of the Excel data cleaning project are:

  1. Widen all columns to automatically fit the contents
  2. Find and remove duplicate records
  3. Remove unwanted characters such as numbers, spaces, and nonprintable characters from fields
  4. Find and replace text with replacement text
  5. Change the case of a text field to uppercase or lowercase
  6. Format numbers
  7. Create a two-visualization interactive dashboard

Tutorial videos/PDFs

Complete step-by-step instructions are provided for this project. Students have the choice of viewing the tutorial videos or downloading a pdf file of the annotated slides. The tutorials for this project have been split into two parts. You can view the tutorial videos here as a preview of this project:

  1. Part 1: Data cleaning tutorial (video | pdf)
  2. Part 2: Dashboard tutorial (video | pdf)

***You can obtain the Instructor Guide for the KAT Concession Supply beginning data cleaning project for Excel by requesting it at this link.*** The instructor guide contains the data set, solutions, and other information.

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. (You may want to add drwendytietz@gmail.com to your Safe Senders list. Please don’t email to that email address – that is an email address used solely for distributing the project resources we have developed. Thank you!)

News flash: This data cleaning project is the first project in a set of ten data cleaning and visualization projects developed by Tracie Miller-Nobles, Jennifer Cainas, and me. We will be releasing new projects approximately twice a month for the remainder of 2022. These projects will be available in three levels: Beginner (five data cleaning techniques plus two-visualization dashboard); Intermediate (beginner steps with seven additional data cleaning techniques plus three-visualization dashboard); and Advanced (intermediate steps with additional data cleaning techniques plus four-visualization dashboard.) In addition, the projects will be available in four software tool combinations: Excel, Google Sheets, Tableau Prep combined with Tableau, and Alteryx combined with Power BI.

RPA screenshot

Hello Bot RPA project for introductory accounting using Automation Anywhere

Robotic Process Automation (RPA) is a software system that can observe a person or user performing a task, recognizes patterns in that user activity, and creates a “bot” to replicate that person’s task processes. A bot can also be built using a series of commands that replicate what the person does to accomplish the task. A bot (or software robot) is an RPA program that performs repetitive tasks that are based on rules. Tasks are considered rule-based when a clear set of rules, when answered, determine how the task is performed.

Automation Anywhere is an RPA software vendor.  Automation Anywhere has a Community Edition that is mostly web-based that is free to use. Other top vendors of RPA software include UiPath and Blue Prism.

This RPA project will introduce your students to RPA and bots – and it will walk your students through the process to create their first bot using Automation Anywhere. With this project, the student builds a bot that asks the user for their name. The student-created bot will then display a message that says “Hello, <name>. The day and time is <today’s date.>” It is a simple bot but introduces the student to the concept of what RPA is and what a bot is.

You can find the Word document for this Hello Bot project at this link. The project document contains complete instructions for the project, from signing up for a free account at Automation Anywhere, to building the bot. The document contains links for resources, including a tutorial video on building the bot.

As always, you are free to use and adapt the Hello Bot project with your own classes. Please do not republish it without express written permission from the authors of Accounting Is Analytics. Thank you!

Upcoming online teaching webinars – NEW!

We have just scheduled another series of webinars for the next two weeks to help with converting to remote teaching. Most of these webinars are just 30 minutes. Go ahead and register even if you have a time conflict; we will be emailing out links to the recordings and handouts after the webinars.

Hang in there during these challenging times. We can do this, but only if we do it together.

How to use Poll Everywhere in your online class

  • Tuesday, March 24, 2020, 5 – 5:30 pm ET
  • Interested in creating student engagement in your online courses? Join us for a “how-to” session on using Poll Everywhere. We will provide you with information on how to sign up for an account, create polls, and embed polls into your PowerPoints. Also, we’ll feature the Poll Everywhere competition feature. This session will provide everything you need to be up to speed using Poll Everywhere.
  • Registration link

How to use PowerPoint Recording to create a video for class

  • Wednesday, March 25, 2020, 3 – 3:30 pm ET
  • Interested in learning how to use the new PowerPoint Recording feature to create lecture videos? Learn about recording right in PowerPoint, inserting videos and screenshots, and – most importantly – how to edit your recording without starting over.
  • Registration link

American Accounting Association: Tips and Tools for Organizing Your Online Course in a Hurry

  • Thursday, March 26, 2020, 4 – 5 pm ET
  • In this webinar hosted by the American Accounting Association, we will be sharing a variety of tips for moving your course online quickly.
  • Registration link

Institute of Management Accountants: Tips & Strategies for Effective Online Education

  • Friday, March 27, 2020, 11 am – 12 pm ET
  • This webinar is hosted by the Institute of Management Accountants and features Kimberly Church, Kelly Richmond Pope, and Wendy Tietz. Is your college or university one of the many now holding classes online? How can you effectively teach and engage your students virtually? In this webinar, learn tips and strategies for instruction from several faculty who have done this before! We will also be asking participants to share their questions in advance to maximize the value of the time together.
  • Registration link

How to use Collaborate Ultra for live class – and an update on features deactivated for now

  • Friday, March 27, 2020, 2 – 2:30 pm ET
  • Does your school use Collaborate Ultra. Join us for this webinar on how to use Collaborate Ultra – and for an update about the features that Blackboard has temporarily disabled to enable it to meet the large increase in bandwidth from the surge in users.
  • Registration link

Using a Microsoft Surface to write on your screen

  • Tuesday, March 31, 2020, 3 – 3:30 pm ET
  • Do you own a Microsoft Surface or are considering buying one? Interested in learning how to use the Surface to write on your screen? Join us for a webinar that discusses different types of Surface computers and software/hardware needed to write on your screen. We will also show you “how-to” get started writing using several different software options.
  • Registration link

Using Zoom for office hours/class

  • Wednesday, April 1, 2020, 3 – 3:30 pm ET
  • Do you want to hold online office hours and/or class using Zoom? Join us for a “how-to” session on how to use Zoom in your online courses. We’ll show you how to create a zoom account, how to schedule meetings, and the different features of Zoom. Best practices and tips will also be shared.
  • Registration link

Using Kahoot! In your online class

  • Thursday, April 2, 2020, 2 – 2:30 pm ET
  • Join us to learn how to use Kahoot! in your online course to increase engagement – and to have fun at the same time.
  • Registration link