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