Syllabus

Advanced Cases in Advisory Services

Archived Course Offering. Some links or materials may no longer be current.

Course Overview

Course details
Course NumberACCTG 528
Course NameAdvanced Cases in Advisory Services
QuarterSpring 2026
MeetingMonday, Wednesday · 10:30AM–12:20PM · PACCAR 292

Course Objective

Advisory services increasingly focus on delivering measurable business value through innovative, technology-enabled solutions. As regulatory requirements grow more complex and data volumes expand, firms must identify ways to improve decision-making, reduce costs, and scale processes without compromising quality or integrity. This course examines how emerging technologies particularly automation, generative AI, and data analytics can be deployed to meet these challenges. These tools are reshaping professional practice, offering new ways to design, test, and deliver solutions that would have been unthinkable a decade ago. Students will adopt an innovation mindset, grounded in the realities of business constraints, and develop practical skills by designing, analyzing, and deploying intelligent automation tools. Whether building bots, evaluating AI-assisted workflows, or analyzing the feasibility of new technologies, students will gain experience with the kinds of problems and possibilities that define the next generation of advisory work. I look forward to exploring these ideas with you, and to seeing what kinds of solutions you'll create. Asher

Course introduction

Advisory services help organizations solve complex problems with smart, scalable solutions. In this course, we will explore how automation, generative AI, and emerging technologies are transforming the way professional service firms deliver value. You'll gain hands-on experience with advanced tools and learn how to use them not just to innovate, but to improve performance, reduce costs, and think strategically. I look forward to working through this cutting-edge material with you!

Curriculum

Advanced Cases in Accounting Advisory (ACCTG 528) is a required course in the MPAcc concentrating on the study of the innovation mindset by studying the skills and tools to advise clients on potential business solutions enabled by emerging technology. Students will engage their questioning mindset to critically examine the role of emerging technology for various business problems and enhance their adaptability and resilience capabilities by engaging with challenging advanced software packages to build business solutions. Students will work in teams and communicate their findings to a professional audience. This course builds heavily from the analytic mindset and data and analytic skills in Data Analytics for Professional Accountants (ACCTG 522) and works with the material focusing on business and control developed in Accounting, Audit and Assurance Regulation (ACCTG 520), Advanced Cases in Assurance Services (ACCTG 521) and Advanced Financial Statement Analysis (ACCTG 523).

Assessment

Assessment in this course is focused on providing you with feedback on how well you can undertake and communicate automation and scale-driven projects in accounting-centric advisory settings. You will be assessed on both written and verbal communication as well as the ability to effectively work in your teams and as an individual. A summary of the components of the deliverables used to determine your grade for ACCTG 528 are below, detail for each assessment follows:

Learning Objectives

Faculty Info

Instructor

Office hours: PACCAR 414, by appointment

Grading Policies and Assignments

Assignment weights and formats
AssignmentFormat(s)Weight
Professionalism30%
RPA Individual Submission30%
Intelligent Automation Team Challenge40%
Course Introduction and Set-up participation
Processing Data and Data Objects using Loops and Variables participation
Mini-Cases in Automation: Part 2 participation
Individual RPA Workshop participation
Remote Class for submitting your RPA Individual Submission participation
Advanced Topics in Automation and RPA, 1 participation
Advanced Topics in Automation and RPA, 2 participation
Intelligent Automation Workshop participation
Intelligent Automation Workshop participation

Professionalism

An individual assessment of student professionalism throughout the quarter. Students are expected to maintain a professional approach to work and approach all classes as professional engagements. Part of this grade is determined via deliverables relating to pollEverywhere engagement, written responses and other deliverables to cases and verbal communication in class.

  • Legacy due date: All Quarter

RPA Individual Submission

An individual project that includes building an RPA software solution that is explained, motivated and demonstrated in a recorded video presentation. Each individual will be asked to develop a desktop-level automation robot of a common repetitive business task. The bot is to be built using either UIPath or the Microsoft Power Apps. The RPA solution is expected to work on a single desktop, and any issues related to the transfer of the bot need to be identified and discussed. The automation solution needs to be motivated in terms of how many human work hours it can save (efficiency) and the value associated with reductions in human errors (effectiveness). Details and further guidance will be provided on Canvas.

  • Legacy due date: Class 14

Intelligent Automation Team Challenge

A team project that focuses on designing and demonstrating an enterprise-oriented automation solution aimed at improving a reporting workflow, operational process, compliance activity, or business decision-support task. The automation may be demonstrated in a proof-of-concept state, including operation on a single desktop, the use of simulated or static data inputs, partial enterprise integration, and simplified dashboards or outputs. Teams should consider how the solution can be classified as "Intelligent Automation" through the application of Generative Artificial Intelligence, retrieval-augmented workflows, and/or Agentic AI systems involving coordinated AI agents. The presentation of the automation solution should focus on the technical goals, workflow design, process architecture (including clearly articulating the process using a process diagram), and practical limitations of the proposed solution. Teams are strongly encouraged to discuss project ideas with the instructor as early as possible to receive feedback regarding feasibility, scope, and technical expectations. Additional details and guidance will be provided on Canvas.

  • Legacy due date: Class 20

Course Introduction and Set-up participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Processing Data and Data Objects using Loops and Variables participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Mini-Cases in Automation: Part 2 participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Individual RPA Workshop participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Remote Class for submitting your RPA Individual Submission participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Advanced Topics in Automation and RPA, 1 participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Advanced Topics in Automation and RPA, 2 participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Intelligent Automation Workshop participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Intelligent Automation Workshop participation

Class submissions recorded in the legacy source; no additional grading weight inferred.

Course Calendar

Sessions and events
SessionDateTopic
1Course Introduction and Set-up
2Introduction to Automation Essentials
3Data Tables and Spreadsheet Automation
4Processing Data and Data Objects using Loops and Variables
5Individual RPA Workshop
6Automation Design Concepts
7Mini-Cases in Automation: Part 1
8Mini-Cases in Automation: Part 2
9Individual RPA Workshop
10The Data Validator Challenge
11Introduction to Agentic Workflows
12Cases in Agentic Automation
13Individual RPA Workshop
14Remote Class for submitting your RPA Individual Submission
15Advanced Topics in Automation and RPA, 1
16Advanced Topics in Automation and RPA, 2
—No Class - Memorial DayNo class
17Intelligent Automation Workshop
18Intelligent Automation Workshop
19Intelligent Automation Tournament

Course Policies

Foster Integrity Principles

I will uphold the fundamental standards of honesty, respect, and integrity and I accept the responsibility to encourage others to adhere to these standards.

HONESTY: I will be truthful with myself and others.

RESPECT: I will show consideration for others and their ideas and work.

INTEGRITY: I will be a leader of character. I will be fair in all relations with others.

Access and Accommodations

Your experience in this class is important to me. If you have already established accommodations with Disability Resources for Students (DRS), please communicate your approved accommodations to me at your earliest convenience so we can discuss your needs in this course. If you have not yet established services through DRS, but have a temporary health condition or permanent disability that requires accommodations (conditions include but not limited to; mental health, attention-related, learning, vision, hearing, physical or health impacts), you are welcome to contact DRS at 206-543-8924 or uwdrs@uw.edu or disability.uw.edu. DRS offers resources and coordinates reasonable accommodations for students with disabilities and/or temporary health conditions. Reasonable accommodations are established through an interactive process between you, your instructor(s) and DRS. It is the policy and practice of the University of Washington to create inclusive and accessible learning environments consistent with federal and state law.

Religious Accommodations

Washington state law requires that UW develop a policy for accommodation of student absences or significant hardship due to reasons of faith or conscience, or for organized religious activities. The UW's policy, including more information about how to request an accommodation, is available at The UW's policy, including more information about how to request an accommodation, is available at Religious Accommodations Policy. Accommodations must be requested within the first two weeks of this course using the Religious Accommodations Request form.

AI

In all Foster courses, use of generative AI tools is permitted without disclosure as a learning and productivity tool, except on specific assignments or assessments where it may be prohibited, restricted, or required to ensure you build the foundational knowledge and skills your career will depend on. You are responsible for the accuracy, integrity, and originality of all individual and team submitted work. AI-generated content should be augmented with your substantial human judgment to meet the desired standards or learning objectives, and you should be able to explain and defend anything you submit to your instructor or teammates. See the Foster AI Syllabus Statement for full details and responsibilities. Use of AI in violation of assignment-specific guidelines constitutes academic misconduct under the UW Student Conduct Code (Academic Misconduct Policy).

Archived instructional materials

Course Introduction and Set-up

Materials

Introduction to Automation Essentials

Materials

Data Tables and Spreadsheet Automation

Materials

Processing Data and Data Objects using Loops and Variables

Materials

Individual RPA Workshop

Materials

Automation Design Concepts

Materials

Mini-Cases in Automation: Part 1

Materials

Mini-Cases in Automation: Part 2

Materials

Individual RPA Workshop

Materials

The Data Validator Challenge

Materials

Introduction to Agentic Workflows

Materials

Cases in Agentic Automation

Materials

  • Class 12 slides (PDF)

    Historical slide file unavailable.

  • Class 12 slides (PPTX)

    Historical slide file unavailable.

Individual RPA Workshop

Remote Class for submitting your RPA Individual Submission

Advanced Topics in Automation and RPA, 1

Materials

Advanced Topics in Automation and RPA, 2

Intelligent Automation Workshop

Copy Files Loop Template

The bots in this section introduce and provide templates for looping through various activities. This bot copies files from one location to another. This example introduces a loop structure for copying files across directories, adding a suffix with the letters bk and timestamp in yyyyMMdd format. Repository snapshot; original classroom version unverified.

Open Copy Files Loop Template

Process Excel Rows Loop Template

The bots in this section introduce and provide templates for looping through various activities. This bot processes rows in an Excel file. This example demonstrates a starter process for how to loop through rows in an Excel file and perform conditional statements this example prints to the console log. Repository snapshot; original classroom version unverified.

Open Process Excel Rows Loop Template

For Each Email Loop Template

The bots in this section introduce and provide templates for looping through various activities. This bot processes each email in an inbox by displaying the from and subject in the console log. This example shows how to loop through emails in an inbox as a starter template to perform actions such as reading or categorizing email. Repository snapshot; original classroom version unverified.

Open For Each Email Loop Template

Conditional Loops Template

The bots in this section introduce and provide templates for looping through various activities. This bot demonstrates conditional looping logic. This example shows how to implement conditional loops using if statements in UiPath. Historical download unavailable.

Example Join Template

The bots in this section introduce and provide templates for joining data from various sources. This bot demonstrates how to join data from two spreadsheet sources. This example shows how to join data from two spreadsheet sources in UiPath. Historical download unavailable.

Merge PDFs Template

The bots in this section introduce and provide templates for joining data from various sources. This bot demonstrates how to merge multiple PDF files into a single document. This example shows how to merge multiple PDF files into a single document in UiPath. Historical download unavailable.

Example Web Table scraping Template

The bots in this section introduce and provide templates for scraping data from websites. This bot demonstrates how to scrape data from a web table. This example shows how to scrape data from a web table in UiPath targeting the S&P 500 constituents. Historical download unavailable.

Scrape Population data with Conditional Loops Template

The bots in this section introduce and provide templates for scraping data from websites. This bot demonstrates webscraping a table with conditional looping logic. This example shows how to implement conditional loops using if statements in UiPath. Historical download unavailable.

Email LLM Integration Template

The bots in this section introduce and provide templates for adding LLMs to your UiPath workflows. This bot demonstrates integrating an LLM for email processing. This example shows how to integrate an LLM for processing emails in UiPath. Repository snapshot; original classroom version unverified.

Open Email LLM Integration Template

Extract PDF Text Template

The bots in this section provide templates for various other UiPath automation tasks. This bot demonstrates how to extract text from PDF files. This example shows how to extract text from PDF files in UiPath. Historical download unavailable.

Log using assign to a text variable that outputs one line of log per entry.

The bots in this section provide templates for logging in UiPath and routing those logs to a saved location. This bot demonstrates how to save a log to a google document. This bot demonstrates how to save a log to a google document.. Historical download unavailable.

UiPath Robot Library

Downloadable templates and examples for UiPath-based automation projects. Below is a browsable list of UiPath bot templates and examples. Click on the folders below to access them. Each bot includes a description of its functionality and a download link for the .uip file that can be opened in UiPath Web Studio. For Desktop Studio files, you can either browse the GitHub repository directly or download the complete repository using git clone (if you have Git installed) or by using curl in the command prompt. To download the full repository using Git: git clone https://github.com/ashercurtis/robots.io.git To download the repository as a ZIP file using curl: curl -L -o robots_io.zip https://github.com/ashercurtis/robots.io/archive/refs/heads/main.zip After downloading, unzip the file and open the desired folder in UiPath Studio.

Open UiPath Robot Library

Key terms

FAQs

I am having trouble connecting to the remote labs.

If you cannot connect to the labs please change your UW id password on myUW and try logging into the remote labs. This step will solve most problems.

The software is asking for a license.

Log out of the remote labs, close the browser. Then log back into the remote labs and wait 2 minutes to allow the software license script to run. This step will solve most problems.

The remote labs are running slowly.

Log out of the remote labs, close the browser. Then log back into the remote labs. This step will solve most problems.

My U drive isn't showing up when I log onto the remote labs.

Log out of the remote labs, close the browser. Then log back into the remote labs. If this doesn't work please change your UW id password on myUW and try logging into the remote labs. This step will solve most problems.

How do I access all of the files by cloning the repository?

To clone the repository navigate to your U-drive and click the filepath, type cmd and a command window will open. To clone the repository type: git clone https://github.com/ashercurtis/datasets.io and press enter. This will start the download process from GitHub to the U-drive on the remote labs.

How do I update files in my datasets.io folder?.

To update the files used in the labs, navigate to the datasets.io folder, click on the filepath and type cmd> command window will open. To check for and download any updates, type git pull and press enter.

My git pull request is giving me errors.

Make sure you are running the command in the correct folder which is U:\datasets.io. If a specific file is logged in the error message, rename that file e.g., dataset1.csv to dataset1-mine.csv, and retry the git pull command. If this still isn't working check in with me, we can re-clone the repository. To reclone, rename the folder you are having trouble with and in the U: use cmd and type: git clone https://github.com/ashercurtis/datasets.io and press enter.

I am having difficulty accessing the remote labs from off-campus.

To access the remote labs from off-campus you typically need to install the Husky OnNet Virtual Private Network (VPN) see here for the installation instructions: UW IT Husky OnNet.

I am having difficulty with the Husky OnNet Virtual Private Network (VPN)

UW IT maintains the OnNet VPN, their troubleshooting page can be found here: UW IT Husky OnNet Troubleshooting.