Tutorial 1
COMMANDS:
ANALYZE -> TOTAL
ANALYZE -> PROFILE
ANALYZE -> STATISTICS
SAMPLING -> SAMPLE
ANALYZE -> SEQUENCE
DATA -> SORT
ANALYZE -> DUPLICATES
ANALYZE -> GAPS
The tutorials in this folder are supplemental exercises that relate to ACL 9 topics covered in chapters 8, 9, 10, and 12 in the Hall, IT Auditing, 3rd edition textbook. The tutorials presume that the student has installed ACL from the CD accompanying the text and has worked through the ACLStart.pdf document in the ACL Manual folded. The tutorials are not a substitute for this basic ACL knowledge.
These tutorials use data tables stored in the Sample Project.acl that is automatically installed with ACL. Open the sample project and click on the appropriate table to perform the tutorial. The name of the table is indicated in bold type prior to each section in the tutorial (e.g. AP TRANS).
AP_TRANS
1. Using the TOTAL command, develop a hash control total and an amount control total for AP-TRANS.
Invoice_Amount
278,641.33
Quantity
37,107
Unit_Cost
1,522.29
What recommendation would you make to develop a field for hash control total?
2. Run PROFILE on the file, Invoice Amount.
Field Name
Total Value
Absolute Value
Minimum
Maximum
Invoice Amount
278,641.33
278,641.33
14.88
56,767.20
Can you determine if there are any negative transactions? Explain.
There aren’t, the smallest transaction was for $14.88
3. Run STATISTICS on each of the four available fields with the Std Dev box checked.
4. Invoice Amount
5.
Number
Total
Average
Range
-
56,752.32
-
Positive
102
278,641.33
2,731.78
Negative
0
0.00
0.00
Zeros
0
-
-
Totals
102
278,641.33
2,731.78
Abs Value
-
278,641.33
-
Std. Dev.
-
6,609.23
-
Highest
Lowest
56,767.20
14.88
20,386.19
21.12
18,883.34
31.68
16,642.56
46.08
15,444.80
49.68
Invoice Date
Number
Total
Average
Range
-
334
«Empty Date»
Positive
102
3,748,395
08/12/2000