Tag Archives: teaching accounting

Use Mail Merge in Word with an Excel file to personalize communications

Rather than sending out one generic email to students, why not personalize the email for each student? It is easy to insert the student’s name and other information into the email through Word’s Mail Merge feature with an Excel file containing the student name, email, and other information. I have recorded a quick tutorial video […]

Continue reading

Summary of seven data analytics projects for introductory accounting

There has been a lot of interest in the data analytics cases for introductory accounting that have been posted on this blog. I am providing a summary of the seven data analytics cases and related links in the table below to make it more convenient to see, at a glance, what projects are available and […]

Continue reading

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

In addition to the data analytics case we posted last week for introductory financial accounting, we have also developed a case, using the same KAT Insurance Company data set, for introductory managerial accounting. The three of us who teach introductory accounting (Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles) developed a KAT Insurance case to introduce […]

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

7 Excel projects for managerial accounting

Welcome to the spring semester! I thought I would repost this information as you are getting ready to kick off the new semester. If you teach managerial accounting, you may want to look at Dr. Karen Braun’s Excel projects for managerial accounting. She has created seven Excel projects on various topics in managerial accounting, complete […]

Continue reading

NEW! Data analytics project: Contribution margin analysis and segment margins for introductory managerial accounting

This blog post contains a data analytics project that is suitable for introductory managerial accounting. The student uses Excel to analyze a data set that contains more than 48,000 records. The data analytics project can be assigned in the course once the concepts of contribution margin, contribution margin ratio, and segment margins reviewed. Overview of […]

Continue reading

Recap of all data analytics projects available

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. (Heads up: I will be posting a new managerial accounting data analytics case within the next week too!) Here goes: Project 1: Transaction analysis for […]

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

Will the cost of the new Forbidden Frontier attraction at Cedar Point reduce income in 2018?

Management of Cedar Point, the amusement park in Sandusky, Ohio, recently announced that it would be closing the Dinosaurs Alive and Witches’ Wheel to make room for a new attraction called “Forbidden Frontier on Adventure Island.” This paragraph is what Cedar Point management released about this upcoming new attraction: “Grab your map and prepare for […]

Continue reading

How should Canada Dry account for the lawsuit filed against it because its ginger ale allegedly does not contain ginger root?

A woman has filed a lawsuit against Canada Dry and its parent company Keurig Dr Pepper[1] (NYSE: KDP), claiming that its ginger ale does not contain enough ginger to be a healthier alternative to sodas. The plaintiff purchased Canada Dry ginger ale when her children were sick, because she thought it would soothe their stomachaches […]

Continue reading