Archive | Ch 02 Transaction analysis RSS feed for this section

New! Crossword puzzle to review the accounting cycle

Recently, I surveyed my students and found that most enjoy crossword puzzles. While not every activity will suit every student, I thought it would be a good idea to create some crossword puzzles for review activities. I am going to share those crossword puzzles here on my blog occasionally. The first crossword puzzle I am […]

Continue reading

What information can be calculated from Wendy’s 2021 trial balance?

The Wendy’s Company (NASDAQ: WEN) is a fast-food chain and is a publicly held corporation. Wendy’s fiscal reporting periods consist of 52 or 53 weeks ending on the Sunday closest to December 31. Wendy’s 2021 fiscal year ended January 2, 2022, and its 2020 fiscal year ended January 3, 2020. To follow is a condensed […]

Continue reading

New! Constructing an Interactive Excel Dashboard project for introductory financial accounting available

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 reading

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 […]

Continue reading

New! Google Sheets data analytics case for introductory accounting available – City of Magicville

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 reading

New data analytics case for introductory financial accounting available – KAT Insurance!

The demand for business graduates with data analytics skills has exploded, while the tools and techniques are continuing to evolve and change at a rapid pace. Three of us who teach introductory accounting (Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles) have joined forces to develop a case to introduce data analytics in the introductory financial […]

Continue reading

Accounting Case Template tool available to build an introductory financial accounting case assignment

Again, as we start a new semester, I wanted to point out the availability of a tool that may be of use in teaching introductory financial accounting. The Accounting Case Template (ACT) is a web tool I designed that allows instructors to quickly build an introductory financial accounting case assignment. A variety of options are provided from […]

Continue reading

Create Customized Financial Accounting Case Assignments with the Accounting Case Template

Again, as we start the fall semester, I wanted to point out the availability of a tool that may be of use in teaching introductory financial accounting. The Accounting Case Template (ACT) is a web tool I designed that allows instructors to quickly build an introductory financial accounting case assignment. A variety of options are provided from […]

Continue reading

A recap of the Excel data analytics project blog posts

Hello! I have posted a few data analytics projects here on my blog and thought it might be useful as the semester starts to post the links in one post. Here goes: Project 1: Transaction analysis for Introductory financial accounting using the City of Somerville, MA, online checkbook data set (link) Project 2: Budgeting and […]

Continue reading

Data analytics project: Transaction analysis for introductory financial accounting using the City of Somerville, MA, online checkbook data set

Data analytics is here! I have been working on some projects for the past few months to be able to incorporate data analytics into the introductory accounting classes. After thinking about the best tool to use for data analytics in the introductory classes, I decided to use Excel as the analytics tool since introductory accounting […]

Continue reading