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 link for the other Google Sheets data analytics case I have developed.) Read on for details….

Data set background

This dataset represents checkbook data for a fictitious city, the City of Magicville, covering a four-year period. In the project, students are asked to analyze checkbook transaction data, using a variety of pivot tables. Before the analysis, students have to find and correct an error in the data set (“data cleaning.”)

Teaching notes

This project has students watch a tutorial on how to do specific tasks using a small data set in Google Sheets and then apply those skills to a larger data set. Students are guided step by step in the tutorial video to create pivot tables and charts. The project takes, on average, about 30 – 45 minutes to complete.

Learning objectives

  1. Find and correct errors in a data set (clean the data)
  2. Create a pivot table in Google Sheets
  3. Apply filters to a pivot table
  4. Create sum, count, and average columns in a pivot table
  5. Sort a pivot table
  6. Create a pivot chart in Google Sheets
  7. Analyze transactions using a pivot table and a pivot chart

The case materials are designed to be completed independently by students. You do not need to cover the case during class time. You can download the student case at this link.

***You can request the Teaching Notes for this City of Magicville Financial Accounting Google Sheets case 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 to your Safe Senders list. Please don’t send an email to that email 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 Instructor Guide. I generally send the Instructor Guide within a week after the request; I will contact you if I need additional information to verify your instructor status.

The case and related teaching notes include the following:

  • Case (Word document)
  • Data sets containing 28,000+ records (2 versions: A and B)
  • Step-by-step tutorial video (close captioned)
  • Scripted tutorial video slides (pdf)
  • Selected checking figures for each data set
  • Optional video assignment instructions (for Screencastify and Screencast-O-Matic)

I hope you and your students find value in this Google Sheets 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,

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.

2 Responses to “New! Google Sheets data analytics case for introductory accounting available – City of Magicville”

  1. Hi,

    I thought I had saved the first one you sent however, I can’t locate it. Would you be able to send it again?


    Jenifer Zihlman, CPA
    972-487-4588 x 64049
    Gilbreath-Reed Career and Technology Center
    Finance Department

Leave a Reply

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

You are commenting using your 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: