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 performance evaluation for introductory managerial accounting using the City of Somerville, MA, online checkbook data set (link)
  • Project 3: Gross profit analysis for introductory financial accounting using the Cabinet Accessories Company data set (link)
  • Project 4: My colleague, Tracie Miller Nobles, has developed a fixed asset analysis project for introductory financial accounting using the Hula Hut Burgers data set and that data analytics project is on her blog (link).

Each of the above projects includes the following items:

  • Project requirements (Word doc)
  • Full data set (Excel file)
  • Annotated slides for tutorial video (PDF file)
  • Step-by-step tutorial video
  • Tutorial data set (Excel file)
  • Customizable grading rubric (Excel file)

The blog posts for each of the data analytics projects contain a link to a Google Form where you can fill in your instructor information to receive a copy of the Excel solutions file once your instructor status can be confirmed.

Have a great start to the fall semester!

Wendy

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.

No comments yet... Be the first to leave a reply!

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

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