COMPUTER ASSISTED AUDIT TOOLS & TECHNIQUES I (2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Explain the role of information technology on the audit process and perform data analysis operation using features of ACL; Identify audit objectives and internal control issues related to the accounting cycles and perform test of controls and substantive test related to the accounting cycles using ACL; Analyze fraudulent behavior, fraud motivation, and fraud schemes and perform techniques using ACL to detect fraud both in manual systems and computer systems

Topics:

1. The Impact of Information Technology on The Audit;
2. Computer-Assisted Audit Tools & Techniques (CAATTs);
3. Overview Software Audit ACL version 8;
4. Access Data & Verify Data Integrity;
5. Summarizing Data;
6. Working with Multiple Table;
7. Examining Sequential Data & Extracting, Exporting Records;
8. ACL for Auditing the Revenue Cycle (ST, TOC, Test of Detail of Balances);
9. ACL for Auditing the Expenditure Cycle (ST, TOC, Test of Detail of Balances);
10. ACL for Auditing the Production Cycle & Inventory Systems (ST, TOC, Test of Detail of Balances);
11. ACL for Auditing the Personal Cycle & Payroll Systems (ST, TOC, Test of Detail of Balances);
12. Auditing with ACL for ERP Systems;
13. Systems Development and Program Change Activitiesfor Internal Control and Auditing.