RPA screenshot

Hello Bot RPA project for introductory accounting using Automation Anywhere

Robotic Process Automation (RPA) is a software system that can observe a person or user performing a task, recognizes patterns in that user activity, and creates a “bot” to replicate that person’s task processes. A bot can also be built using a series of commands that replicate what the person does to accomplish the task. A bot (or software robot) is an RPA program that performs repetitive tasks that are based on rules. Tasks are considered rule-based when a clear set of rules, when answered, determine how the task is performed.

Automation Anywhere is an RPA software vendor.  Automation Anywhere has a Community Edition that is mostly web-based that is free to use. Other top vendors of RPA software include UiPath and Blue Prism.

This RPA project will introduce your students to RPA and bots – and it will walk your students through the process to create their first bot using Automation Anywhere. With this project, the student builds a bot that asks the user for their name. The student-created bot will then display a message that says “Hello, <name>. The day and time is <today’s date.>” It is a simple bot but introduces the student to the concept of what RPA is and what a bot is.

You can find the Word document for this Hello Bot project at this link. The project document contains complete instructions for the project, from signing up for a free account at Automation Anywhere, to building the bot. The document contains links for resources, including a tutorial video on building the bot.

As always, you are free to use and adapt the Hello Bot project with your own classes. Please do not republish it without express written permission from the authors of Accounting Is Analytics. Thank you!

Upcoming online teaching webinars – NEW!

We have just scheduled another series of webinars for the next two weeks to help with converting to remote teaching. Most of these webinars are just 30 minutes. Go ahead and register even if you have a time conflict; we will be emailing out links to the recordings and handouts after the webinars.

Hang in there during these challenging times. We can do this, but only if we do it together.

How to use Poll Everywhere in your online class

  • Tuesday, March 24, 2020, 5 – 5:30 pm ET
  • Interested in creating student engagement in your online courses? Join us for a “how-to” session on using Poll Everywhere. We will provide you with information on how to sign up for an account, create polls, and embed polls into your PowerPoints. Also, we’ll feature the Poll Everywhere competition feature. This session will provide everything you need to be up to speed using Poll Everywhere.
  • Registration link

How to use PowerPoint Recording to create a video for class

  • Wednesday, March 25, 2020, 3 – 3:30 pm ET
  • Interested in learning how to use the new PowerPoint Recording feature to create lecture videos? Learn about recording right in PowerPoint, inserting videos and screenshots, and – most importantly – how to edit your recording without starting over.
  • Registration link

American Accounting Association: Tips and Tools for Organizing Your Online Course in a Hurry

  • Thursday, March 26, 2020, 4 – 5 pm ET
  • In this webinar hosted by the American Accounting Association, we will be sharing a variety of tips for moving your course online quickly.
  • Registration link

Institute of Management Accountants: Tips & Strategies for Effective Online Education

  • Friday, March 27, 2020, 11 am – 12 pm ET
  • This webinar is hosted by the Institute of Management Accountants and features Kimberly Church, Kelly Richmond Pope, and Wendy Tietz. Is your college or university one of the many now holding classes online? How can you effectively teach and engage your students virtually? In this webinar, learn tips and strategies for instruction from several faculty who have done this before! We will also be asking participants to share their questions in advance to maximize the value of the time together.
  • Registration link

How to use Collaborate Ultra for live class – and an update on features deactivated for now

  • Friday, March 27, 2020, 2 – 2:30 pm ET
  • Does your school use Collaborate Ultra. Join us for this webinar on how to use Collaborate Ultra – and for an update about the features that Blackboard has temporarily disabled to enable it to meet the large increase in bandwidth from the surge in users.
  • Registration link

Using a Microsoft Surface to write on your screen

  • Tuesday, March 31, 2020, 3 – 3:30 pm ET
  • Do you own a Microsoft Surface or are considering buying one? Interested in learning how to use the Surface to write on your screen? Join us for a webinar that discusses different types of Surface computers and software/hardware needed to write on your screen. We will also show you “how-to” get started writing using several different software options.
  • Registration link

Using Zoom for office hours/class

  • Wednesday, April 1, 2020, 3 – 3:30 pm ET
  • Do you want to hold online office hours and/or class using Zoom? Join us for a “how-to” session on how to use Zoom in your online courses. We’ll show you how to create a zoom account, how to schedule meetings, and the different features of Zoom. Best practices and tips will also be shared.
  • Registration link

Using Kahoot! In your online class

  • Thursday, April 2, 2020, 2 – 2:30 pm ET
  • Join us to learn how to use Kahoot! in your online course to increase engagement – and to have fun at the same time.
  • Registration link

Two webinars this week: Options for online office hours and Building online student engagement

Has your school converted all courses to online? Still scrambling to figure out what this means for your course? Jennifer Cainas (University of South Florida), Tracie Miller-Noble (Austin Community College) and me (Kent State University) will be hosting two 30-minute webinars this coming week. One will address the options for online office hours and the other will cover ideas for building online student engagement.

Details and registration links for each of the webinars are below.

Title: Options for online office hours

Date/time: Monday, March 16, 4 – 4:40 pm (Eastern)

  • Registration link: https://zoom.us/webinar/register/WN_QnF311-8QXGEZx76jsi5-Q
  • Description: Wondering how you can host online office hours? Join us for a 30-minute webinar on Monday, March 16, at 4 pm (Eastern) about ways you can hold office hours online. Join Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles as we talk about how we have hosted office hours online for a variety of online classes.

Title: Ideas for online student engagement

  • Date/time: Tuesday, March 17, 2 – 2:30 pm (Eastern)
  • Registration link: https://zoom.us/webinar/register/WN_bXGwEJ6YTPmEAoUJGqEBWw
  • Description: Engaging students in an online environment is different than in an in-person class. Join us for a 30-minute webinar on Tuesday, March 17, 2 – 2:30 pm (Eastern) about ways you can build student engagement in an online environment. Join Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles as we share how we have built student engagement in our own online classes.

We hope to see you online Monday and Tuesday!

Have a great day – and keep calm, it will all be okay.

Wendy, Jennifer, and Tracie

Strategies for giving exams online webinar recording available

Over the past few days, I have gotten a lot of requests for the recording of the webinar that Jennifer Cainas and I hosted on Friday, March 15, about various strategies for giving exams online. You can find that recording at this link. You can also download the slides for the webinar at this link. 

I hope you find the ideas for online exams to be helpful. Remember….be flexible, be kind, be consistent, and be calm. We are in this together.

Wendy

Webinar: Strategies for giving exams and quizzes online

Has your university or college suddenly converted all in-person classes to be online? Wondering how you can give exams online and maintain some sort of integrity?

We (Wendy Tietz and Jennifer Cainas) are hosting a webinar on Friday, March 13, 2020, from 3:30 – 4:30 pm Eastern. Register at this link.

In this webinar, we will share some strategies for giving exams and quizzes online in this new environment we find ourselves in. We will also be asking participants to share their own strategies.

If time permits, we will discuss other strategies to engage students in an online environment.

Case FA-4300 Excel: Job cost analysis for Ivy Corporation

In this case, students use a variety of pivot tables in Excel to summarize, sort, and aggregate more than 4,800 job cost records. All work is performed in Excel. This case is suitable for assignment after job costing been covered in managerial accounting. You can view this case at this link (this is the same link that you will use to assign to your students.)

Screenshot of Excel

To assign the case to your students, give them this link. All student instructions are included at that link – as are links for tutorial videos for Excel skills needed and accounting concept skills needed.

How to obtain case materials

***You can obtain the teaching notes and solution for the Ivy Corporation Job Cost Analysis Excel case by requesting it at this link.***

You will need to fill out a brief form and then we will verify your instructor status prior to sending you the instructor materials. We generally send the Instructor Guide within a week after the request; we will contact you if we need additional information to verify your instructor status.

Be sure to add drwendytietz@gmail.com to your contacts. Check your spam folder if you have not received the materials from us within a week.

 

Case FA-3801 Excel: Financial statement analysis for Jubilee Company

In this case, students use data found in a company’s financial statements in an Excel file to various ratios, including the current ratio, debt ratio, and gross margin percentage. All work is performed in Excel. This case is suitable for assignment after the basic ratios have been covered. You can view this case at this link (this is the same link that you will use to assign to your students.)

screenshot

To assign the case to your students, give them this link. All student instructions are included at that link – as are links for tutorial videos for Excel skills needed and accounting concept skills needed.

Tip: To make sure your students have put in the correct formulas as you are grading, change a few numbers in the data in students’ completed worksheets and then check to make sure that the revised ratios are correct.

How to obtain case materials

***You can obtain the teaching notes and solution for the Jubilee Company Financial Statement Analysis Excel case by requesting it at this link.***

You will need to fill out a brief form and then we will verify your instructor status prior to sending you the instructor materials. We generally send the Instructor Guide within a week after the request; we will contact you if we need additional information to verify your instructor status.

Be sure to add drwendytietz@gmail.com to your contacts. Check your spam folder if you have not received the materials from us within a week.

 

Introducing emerging tech in introductory accounting

We have a lot to cover in introductory financial accounting and in introductory managerial accounting. However, to only show students the manual way of doing things (i.e., pencil, paper, calculator) is doing them a disservice – they don’t get to see how accounting is much more than rote calculations.

I think certain emerging technology topics are appropriate for introductory accounting. I have developed a few Robotic Process Automation (RPA) that are suitable for intro accounting – one is a simple Hello World bot and another one is a bot that takes a selfie of itself while it runs. I have also developed a few Python projects for absolute beginners that will work in introductory accounting.

There will also be some other emerging tech projects posted here on blockchain, ETL, and others.

I am going to be using the RPA projects and the Python projects in my own classes in Spring 2020. Once I work through any bumps, I will be sharing those projects here. Stay tuned….

Wendy

Case FA-3001: Transaction analysis and the accounting equation for Pepper Food Delivery – Excel

In this case, students use transaction data in an Excel file to calculate assets, liabilities, equity, net income, the accounting equation, and other basic data. All work is performed in Excel. This case is suitable for early in the introductory financial accounting course – right after the accounting equation, transaction analysis, and the basic statements are covered. You can view this case at this link (this is the same link that you will use to assign to your students.)

Sample screen shot of tutorial for project

To assign the case to your students, give them this link. All student instructions are included at that link – as are links for tutorial videos for Excel skills needed and accounting concept skills needed.

How to obtain case materials

***You can obtain the solution for the Pepper Food Delivery Excel case by requesting it at this link.***

You will need to fill out a brief form and then we will verify your instructor status prior to sending you the instructor materials. We generally send the solution within a week after the request; we will contact you if we need additional information to verify your instructor status.

Be sure to add drwendytietz@gmail.com to your contacts. Check your spam folder if you have not received the materials from us within a week.