>>  STEP 1 - Find a Course                       >>  STEP 2 - Select a Class                       >>  STEP 3 - Register & Pay
Registration | About Us | Contact Us | Policies | Online Forms | Find a Course | Home PageAdvanced Search | Site Map | FAQ
IDEA Data Analysis Software for Government: Introduction

October 27 - 28, 2008
8:30 AM - 4:30 PM
Instructor: Paul HoshallWashington, DC$825

April 30 - May 1, 2009
8:30 AM - 4:30 PM
Instructor: Paul HoshallWashington, DC$825

Overview:
Do you need to know how to plan for, manage and use the basic capabilities of IDEA in a government environment? This course, taught by a certified IDEA instructor, provides basic instruction in the use of IDEA software specifically tailored for the government environment.

Learn what IDEA can do and how it can add value by empowering you to do more with less. This is a hands-on course where you perform numerous exercises and a case study. Structure data analysis in accordance with the types of audits and/or reviews normally performed by the government auditor and analyst. Subject matter includes, but is not limited to: data importing and analysis; gaps and duplicates detection; Benford's Law analysis; multiple file operations (join, append, compare); file extractions (basic, key value and indexed); and sampling.

Who Should Attend?
Auditors and analysts desiring to learn what IDEA can do and how to use it. Level: Intermediate.
Prerequisites:
Knowledge of personal computers, Windows and spreadsheet applications.
Objectives:
  • Plan for and manage the use of IDEA for appropriate objectives
  • Discuss and carry out the stages of using IDEA
  • Import data into IDEA from both data files and automated report files
  • Use the main features of the IDEA software
  • Syllabus:
    Syllabus -- IDEA 2002 Software for Government Auditors - Introduction, AUDT7920G, Grad. School, USDA

    1: Introduction

    2: Database Management

    3: Reconciling the Data

    4: Importing the Data

    5: Examining the Data

    6: Isolating Specific Items

    7: Manipulating and Adding Fields

    8: Profiling the Data

    9: Identifying Irregularities

    10: Using Multiple Files

    11: Sampling

    12: Output

    13: Documentation Standards

    14: Auditing Travel Expenditures



    Course Details
    CODE:  AUDT7920G
    TYPE:  Classroom-Day
    LENGTH:  2 Day(s)
    CREDITS:  16 CPE
    Related Information
    Print This Page



    Copyright © 2008 Graduate School, USDA Need Assistance? Call Customer Support at 888-744-4723