ACL Galvanized Diligent Scripting

Internal Audit

Overview

This course is intended to help scripters support internal audit departments and improve their testing processes, and reviews the scripting process from planning to development to interactivity and export. Participants will review the basics of data mining, including how data mining can be used to support audit initiatives. Participants will also work to hone their decision-making skills with respect to data mining and assess how audit objectives align with the data mining process.

This course covers topics associated with script planning, including file formats, file import naming conventions, import types, and associated file clean-up. Once planning is complete, this course reviews files and commands that can improve script development and efficiency. Finally, participants will review different methods and best practices for improving script interactivity, including variables, date ranges, filters, and operators. The course includes several live demonstrations that directly correlate to real-world scenarios that scripters and Internal Auditors will face in the field.

Why you should take this course.

For users with an introductory knowledge of this topic, and are searching for additional information and its application.

Here are the topics we'll cover.

  1. Planning Your Data Mining Script

    • Basics of Data Mining
    • Questions About Data Mining
    • Available File Formats
    • File Naming Conventions
    • Single File Import
    • Multi-File Import
    • Appending Multiple Files
    • Clean Up, Distribution, and Security Issues

  2. Developing Your Data Mining Script

    • Scripting the Import: One Instance of the Data
    • Excel and Access Files
    • CSV and Delimited Files
    • Database Files
    • Flat Files
    • Scripting a Mutli-File Import: Directory Command
    • Scripting a Multi-File Import: Looping
    • To Append or Not to Append

  3. Making Your Scripts Interactive

    • Planning the Interactivity
    • Considering the Variables
    • Establishing Variables
    • Variable Substitution
    • Using Start and End Dates
    • The Intricacies of Date Variable Formats
    • Setting Up Other Fields as Filters
    • Naming Results Using Variables

Learning Style

Instructor Led

Level

Intermediate

Who this course is for

Internal and external auditors, compliance professionals and elementary scripters attempting to develop their starting scripts to support an audit department.

NASBA Certified CPE

8 credits

Field of Study

Auditing

Length of course

8h

Prerequisites

None

Advanced Preparation

None
Start Learning Today
Stay ahead of the curve and future-proof your business with training programs designed for you.
Contact Sales

Here are the learning objectives we'll cover

  • Plan the Data Mining Script Environment — File Location, File Naming Conventions, File Structure — for best utility.
  • Develop the main script and import script with a structure that enables users to filter for the data they need, which is especially important for large data repositories.
  • Make the scripts interactive with dialog boxes so that filters may be imposed at an early stage of the process.

Attendance policy for on-site and online instructor-led training

Students are expected to arrive on time for classes with the proper materials and attitude. An overall attendance rate of 100% is expected to fully absorb the materials and to complete labs. If you have an expected absence, please email support@acilearning.com or your instructor ahead of time. The number of CPEs awarded will be equivalent to the number of hours attended.

ACI Learning is registered with NASBA

ACI Learning is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: https://www.nasbaregistry.org/