ACCTG 5150 — Accounting Analytics

Summer 2026 · University of Utah, David Eccles School of Business

Course materials, organized by week. Everything posted here is also available inside Canvas; this page is a direct way to browse it.

Weekly material

• Week 1 — LLM Context Mastery
  Context engineering: giving an LLM the context it needs to work as your analyst.
• Week 2 — Prompt Writing & Spec Documents
  Excel is deterministic; an LLM is not. A careful specification is what makes a non-deterministic tool reliable.
• Week 3 — Data Sources: AR, Aging, and Cash Application
  Build the AR aging report in Excel, then recreate the same headline numbers in SQL on the in-browser SQL Workbench.
• Week 4 — Excel Fundamentals & FSA Setup
  Drill the Excel formula toolkit until it is automatic, then ingest the real Compustat data with Power Query and winsorize it. The workbook you build is your Project 1 starting point.