Event Details
Computer Assisted Auditing Tools & Techniques (CAATs) for Public Sector Auditors
By: Prof. Lemuel Rodolfo Braña, PhD, MTM, SMAC™, ISTQB®, CSSBB™, APRM™
ICT, Business Process, & Change Management Consultant, Senior Project & Program Manager
Scholar - UP Diliman, Korea SBC, Japan AOTS & JICA, Indian School of Business
Course Description: The Internal Auditing Standards for the Philippine Public Sector Standard 1210 Proficiency states that "Internal auditors must possess the knowledge, skills and other competencies needed to perform their individual responsibilities. The government auditors must possess or obtain the knowledge, skills, and other competencies needed to perform its responsibilities."
To enhance the competencies and technology-based audit techniques such as data analysis, this seminar-workshop on CAATs will ensure familiarity on selected computer softwares. To effectively and efficiently audit government programs and projects using systems, audit personnel needs to continually be refreshed on Computer Assisted Audit Tools for mastery.
Course Learning Objectives:
At the end of this course, the Public Sector Internal Auditors are able to:
- Apply with mastery the necessary knowledge, skills along data management to effectively and efficiently audit programs and projects requiring or utilizing data management software, including but not limited to remote data audits.
- Formulate value-adding recommendations that are based on data and information which were understood and analyzed through the use of computer assisted audit techniques.
Learning Methodologies: Lecture, Discussions, Case study Analysis, Hands on Lab work and Workshop, Quiz
Training Facilitator's Profile:Prof. Lemuel Rodolfo Brana, Ph.D.
Materials Needed:
For the Facilitator:
✔ Windows 7 or better computer with a stable internet connection capable of recording the entire session
✔ Syllabus & Facilitation Guide
✔ Presentation Deck
For the Participants:
✔ Windows 7 or better computer with stable internet connection (for those connecting online)
✔ Computer with Pre-installed Microsoft Excel 2007 or higher
✔ Computer Specifications (for following through with the instructions/synchronous hands-on exercises)
o Windows 7 OS or higher
o At least 8GB RAM
o At least 2-core CPU
✔ Download and install PowerBI from https://powerbi.microsoft.com/en-us/
Download and install Talend Data Preparation Desktop from https://sourceforge.net/projects/talend-data-preparation/files/Talend%20Data%20Preparation/2.1.1/Talend-DataPreparation-Free-Desktop-windows-2.1.1.zip/download
