ACNT-1373 Accounting Data Analytics
Tracie Miller
Credit Fall 2022
Section(s)
ACNT-1373-001 (46499)
LEC W 6:30pm - 9:00pm DIL DLS DIL
LAB W 9:00pm - 10:00pm DIL DLS DIL
ACNT-1373-002 (46500)
LEC DIL ONL DIL
LAB DIL ONL DIL
Course Requirements
GRADING SYSTEM
|
Activity |
Points |
|
Exams (Timed, Proctored) |
300 |
|
Quizzes (Timed, Unproctored) |
80 |
|
Projects |
160 |
|
Homework/Lab Activities |
460 |
|
TOTAL |
1,000 |
Basis for Grading:
|
A |
90% or higher |
|
B |
80 – 89% |
|
C |
70 – 79% |
|
D |
60 – 69% |
|
F |
Below 59% |
|
Session |
Topic |
Assignment |
Due Date (all times are CDT) |
|
Unit 1 – Deadline for all Unit 1 Assignments 9/18 |
|||
|
Week 1 8/22 – 8/28
|
Chapter 1: Data Analytics for Accounting and Identifying the Questions
Technology Focus: Excel |
BB: Course Introduction (4 pts) BB: Lab 1-0 How to Complete Labs in This Text (4 pts) BB: Lab 1-2 Data Analytics in Managerial Accounting (9 pts) BB: Excel Problems 5, 6, and 7 (9 pts) BB: Excel Skill Builder: Formatting, Sorting, Filtering, and PivotTables—App C (9 pts) |
8/28, 11:59 pm |
|
Week 2 8/29 – 9/4 |
Chapter 2: Mastering the Data
Technology Focus: Excel |
BB: PR 1-8 (6 pts) BB: Lab 2-2 Use PivotTables to Denormalize and Analyze the Data (9 pts) BB: Lab 2-3 Resolve Common Data Problems in Excel and Access (9 pts) BB: Excel Formulas and Functions (9 pts) BB: Excel Skill Builder: The VLOOKUP Function—App C (9 pts) |
9/4, 11:59 pm |
|
Week 3 9/5 – 9/11
|
Chapter 2: Mastering the Data
Technology Focus: SQL |
BB: SQL Part 1—App D (9 pts) BB: SQL Part 2—App H (9 pts) BB: Lab 2-6 How to Create an Entity-Relationship Diagram (9 pts) BB: Lab 2-7 How to Preview Data from Tables in a Query (9 pts) BB: Lab 2-8 Connecting Excel to a SQL Database (9 pts) BB: Lab 2-9 Joining Tables (9 pts) C: Quiz: Chapter 1 & 2 (Timed: 30 minutes, 20 pts) |
9/11, 11:59 pm |
|
Week 4 9/12 – 9/18 |
Exam |
Exam – Skills Test: Excel (75 pts) Exam – Skills Test: SQL (75 pts) C: C1 and C2 Smart Book due (Extra Credit) |
9/18, 11:59 pm |
|
Unit 2 – Deadline for all Unit 2 Assignments 10/16 |
|||
|
Week 5 9/19 – 9/25
|
Chapter 3: Performing the Test Plan and Analyzing the Results Statistics Primer
Technology Focus: Excel |
BB: Lab 2-4 Summary Statistics (9 pts) BB: Lab 3-2 Regression in Excel (9 pts) BB: Lab 3-4 Data Abstract and Regression (9 pts) BB: Excel Data Analysis ToolPak (9 pts) |
9/25, 11:59 pm |
|
Week 6 9/26 – 10/2 |
Chapter 4: Communicating Results and Visualizations
Technology Focus: Tableau
|
BB: Visualization Activity (6 pts) BB: Tableau—App G (9 pts) BB: Lab 4-2 Use Tableau to Perform Explanatory Analysis and Create Dashboards (9 pts) BB: Lab 4-3 Create Geographic Data Visualizations in Tableau (9 pts) BB: Tableau Dashboard (9 pts) |
10/2, 11:59 pm |
|
Week 7 10/3 – 10/9
|
Chapter 4: Communicating Results and Visualizations
Technology Focus: Power BI |
BB: Power BI—App I (9 pts) BB: Lab 4-3 Create Geographic Data Visualizations in Power BI (9 pts) BB: Power BI KAT Insurance (9 pts) BB: Power BI Dashboard (9 pts) C: Quiz: Chapter 3 & 4 (Timed: 30 minutes, 20 pts) |
10/9, 11:59 pm |
|
Week 8 10/10 – 10/16 |
Exam |
Exam – Skills Test: Tableau/Power BI (150 pts) C: C3 and 4 Smart Book due (Extra Credit) |
10/16, 11:59 pm |
|
Unit 3 – Deadline for all Unit 3 Assignments 11/20 |
|||
|
Week 9 10/19 – 10/23
|
Chapter 5: The Modern Accounting Environment
Technology Focus: Blockchain, Drones, and RPA |
BB: Blockchain (8 pts) BB: Bryan’s Amazing Animals (9 pts) BB: Woods Amazing Woods (Part 1) (18 pts) |
10/23, 11:59 pm |
|
Week 10 10/24 – 10/30 |
Chapter 6: Audit Data Analytics
Technology Focus: Excel |
BB: Audit Innovation Video (9 pts) BB: Benford’s Law Analysis (9 pts) BB: Lab 6-2 Perform Substantive Tests of Account Balances (9 pts) BB: Lab 6-4 Hypothesis Testing (Part 1) (9 pts) |
10/30, 11:59 pm |
|
Week 11 10/31 – 11/6 |
Chapter 7: Managerial Analytics
Technology Focus: Excel & Tableau
|
BB: Lab 7-1 Identifying Useful KPIs (6 pts) BB: Lab 7-2 Create a Balanced Scorecard Dashboard in Tableau (9 pts) BB: Lab 7-3 Creating KPIs in Excel (Part 1) (9 pts) BB: Lab 7-7 Advanced Models in Tableau (9 pts) C: Quiz: Chapters 5, 6, and 7 (Timed: 30 minutes, 20 pts) |
11/6, 11:59 pm |
|
Week 12 11/7 – 11/13
|
Chapter 8: Financial Statement Analytics
Technology Focus: GoogleSheets and Excel |
BB: Lab 8-1 Create a Horizontal and Vertical Analysis Using XBRL Data (9 pts) BB: Lab 8-2 Create Dynamic Common Size Financial Statements (9 pts) BB: Lab 8-3 Analyze Financial Statement Ratios (9 pts) BB: Lab 8-4 Use PivotTables to Analyze Data from an XBRL Database (9 pts) |
11/13, 11:59 pm |
|
Week 13 11/14 – 11/20
|
Chapter 9: Tax Analytics
Technology Focus: Excel, Tableau, Alteryx |
BB: Article Review (6 pts) BB: Lab 9-1 State Sales Taxes and Data Visualization (9 pts) BB: Lab 9-2 Calculate Sales Tax (9 pts) BB: Lab 9-3 Compare Sales Tax Year over Year (9 pts) BB: Alteryx Fixed Asset (12 pts) C: Quiz: Chapters 8 and 9 (Timed: 30 minutes, 20 pts) C: C5, 6, 7, 8 and 9 Smart Book due (Extra Credit) |
11/20, 11:59 pm |
|
Unit 4 – Deadline for all Unit 4 Assignments 12/11 |
|||
|
Week 14 11/21 – 11/27 |
Cybersecurity, Governance, and Ethics Technology Focus: Python |
BB: Cybersecurity, Governance, and Ethics (8 pts) BB: Blue Yarrow Unicorns (22 pts)
|
11/27, 11:59 pm |
|
Week 15 11/28 – 12/4 Week 16 12/5 – 12/11 |
Project 1 and Project 2 |
Pick TWO of the following cases (80 pts each): BB: Audit Analytics Project (Alteryx) BB: Tax Analytics Project (UiPath/RPA) BB: Financial Analytics Project (Tableau) BB: Managerial Analytics Project (Access/SQL) |
12/11, 11:59 pm |
Readings
Data Analytics for Accounting, 2nd Edition, By Vernon Richardson and Katie Terrell and Ryan Teeter (McGraw-Hill), ISBN: 9781264954605
Your textbook and Connect access have been included in your tuition payment for the course. There is no code necessary to register for Connect with the First Day Access Program. If you are asked for payment or a code when registering for Connect through Blackboard, please notify your instructor immediately and select the “Courtesy Access” option. If you would like a loose-leaf, print version of the textbook (Connect comes with the full e-book), they are available at the ACC Bookstore.
Student Registration Instructions: https://vimeo.com/281883800
Course Subjects
Data has proliferated in business and managers and accountants need to understand the implications for decision-making and tap into the data to provide better insights into a firm/client/customer/supplier, etc. This course is intended to provide students with an understanding of data analytic thinking and terminology as well as hands-on experience with data analytics tools and techniques. Students should leave this course with the skills necessary to translate accounting and business problems into actionable proposals that they can competently present to managers and data scientists. While there will be some use of tools in this course, the focus of this class is on concepts, not software, algorithms, or statistical math.
Student Learning Outcomes/Learning Objectives
After successful completion of this course, students will be able to:
- Recognize when and how data analytics can address business questions
- Comprehend the process needed to clean and prepare the data before analysis
- Recognize what is meant by data quality, be it completeness, reliability, or validity
- Perform basic analysis to understand the quality of the underlying data and their ability to address the business question
- Demonstrate ability to sort, rearrange, merge, and reconfigure data in a manner that allows enhanced analysis
- Identify and implement an approach that will use statistical data analysis to draw conclusions and make recommendations on a timely basis
- Report results of analysis in an accessible way to each varied decision maker and their needs
Office Hours
W 5:30 PM - 6:30 PM Online
NOTE I will be available online via Zoom link in Blackboard.Published: 08/18/2022 18:08:40