ACL Galvanized Diligent Scripting

Skills Course

Length: 7h 36m modules icon

Modules: 4 episodes icon

Episodes: 25On DemandIntermediateSkills Course

Course Overview

"descriptionMD": "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. \n\nThis 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. \n\n### Why you should take this course.\nFor users with an introductory knowledge of this topic, and are searching for additional information and its application.\n\n### Here are the learning objectives we'll cover.\n - Plan the Data Mining Script Environment — File Location, File Naming Conventions, File Structure — for best utility.\n - 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.\n - Make the scripts interactive with dialog boxes so that filters may be imposed at an early stage of the process.\n\n### Here are the topics we'll cover.\n1. **Planning Your Data Mining Script**\n - Basics of Data Mining\n - Questions About Data Mining\n - Available File Formats\n - File Naming Conventions\n - Single File Import\n - Multi-File Import\n - Appending Multiple Files\n - Clean Up, Distribution, and Security Issues\n \n2. **Developing Your Data Mining Script**\n - Scripting the Import: One Instance of the Data\n - Excel and Access Files\n - CSV and Delimited Files\n - Database Files\n - Flat Files\n - Scripting a Mutli-File Import: Directory Command\n - Scripting a Multi-File Import: Looping\n - To Append or Not to Append\n \n3. **Making Your Scripts Interactive**\n\n - Planning the Interactivity\n - Considering the Variables\n - Establishing Variables\n - Variable Substitution\n - Using Start and End Dates\n - The Intricacies of Date Variable Formats\n - Setting Up Other Fields as Filters\n - Naming Results Using Variables"

Prerequisites

None

Advanced Preparation

None

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/

Attendance policy for on-demand, self-paced training

Students enrolled in on-demand, self-paced courses are expected to take an active role in their learning by progressing through the course materials in a timely and consistent manner. Because these courses are self-directed, full completion of all modules, videos, labs, and assessments with a passing score of 70 are required to receive credit and any applicable CPEs. Learners are encouraged to set a regular study schedule to stay on track and maximize comprehension. CPE credits will be awarded based on the total course hours and verified completion of all required activities.