Schedule (Planned)
| Date | Topic | Readings | Quiz | Lab Deliverables |
| 9/20/2020
|
Course Introduction
Analytics LAB |
Gartner – Data Analytics Is a Must-Have Technology for Internal Auditors | None | In-Class Lab – Highbond (ACL) Registration and Installation |
| 9/20/2020 | Analytics LAB | Basics of Analytics – Overview | None | |
| 9/20/2020 | Analytics in Auditing | Protiviti – Analytics in Auditing Is a Game Changer | None | |
| 9/21/2020 | Introduction to Fraud | Fraud Examinations, Ch 1 – The Nature of Fraud | None | |
| 9/21/2020 | Introduction to Fraud | Fraud Examinations, Ch 2 – Why People Commit Fraud.
ACFE. (2018). REPORT TO THE NATIONS ON OCCUPATIONAL FRAUD AND ABUSE 2016 GLOBAL FRAUD STUDY. Retrieved from https://www.acfe.com/report-to-the-nations/2018/default.aspx |
1,2 | Due – Basics of Analytics (CPE) (ACL 100 V1 CPE) |
| 9/21/2020 | Analytics LAB | Applying filters & creating computed fields in Analytics | ||
| 9/22/2020 | Fighting Fraud | Albrecht, Zimbelman Ch 3 – Fighting Fraud
Ramos – Auditors’ Responsibility for Fraud Detection |
3 | Analyze Frauds of Note (Discussion) |
| 9/22/2020 | Prevent Fraud | Fraud Examinations, Ch 4 – Prevent Fraud
;Appendix: Red Hat Code of Business Conduct and Ethics |
4 | Due – Filters, computed fields, & functions in ACL Analytics (ACL 102) |
| 9/23/2020 | Recognizing the Symptoms of Fraud | Fraud Examinations, Ch 5 – Recognizing the symptoms of Fraud | 5 | |
| 9/23/2020 | Analytics LAB | Importing & preparing data in Analytics | ||
| Due 09/23/2020 | Exam 1 – Canvas (Fraud CH1-CH3) | |||
| 09/23/2020 | Data Driven Fraud Detection | Fraud Examinations, Ch 6 – Data Driven Fraud Prevention | 6 | Due – Importing & preparing data in ACL Analytics (CPE) (ACL 103 V1 CPE) |
| 09/23/2020 | Analytics LAB | Analyzing data in Analytics | ||
| 09/24/2020 | Data Visualization | Storytelling with data Ch 1 – Understand the Context | Due – Analyzing data in ACL Analytics (CPE) (ACL 104 V1 CPE) | |
| 09/24/2020 | Data Visualization | Storytelling with data Ch 2 – Choose an Effective Visual | ||
| 09/25/2020 | Data Visualization | Storytelling with data Ch 3 – Identify & Eliminate Clutter | ||
| 09/25/2020 | Data Visualization | Storytelling with data Ch 4 – Focus Attention | ||
| 09/25/2020 | Data Visualization | Storytelling with data Ch 5 – Think like a designer | ||
| 09/26/2020 | Data Visualization | Storytelling with data Ch 6 – Tell a story | ||
| 09/26/2020 | Team Presentation: Frauds of Note |
|
|
|
| 09/27/2020 | Team Assignment: Analytics Case Study Presentation & Wrap Up |
|
|
|
| Due 09/27/2020 | Exam 2 – Canvas (Fraud CH4-CH6) | |||