Homework
Due Class 4 MS Access Practice
IF you do not have a working knowledge of  MS Access download this file Access Practice File Ch01 and use the in-class handout to learn the basics.  If you already know MS Access you do not need to do this homework.
Notes on downloading this file:
To use the Access file you must download it to your computer.  To download it, RIGHT CLICK on the file and "Save Link As" in Firefox, or "Save Target As" in Explorer and save it to your computer.  If you LEFT CLICK on the link, you are attempting to open the file in your browser, which will result in a page of nonsense characters appearing on your screen.  RIGHT CLICK to download and then open the file in Access.  Of course you have to make sure that you have Access loaded on your computer.  One other thing: when you download use Explorer, the file may be renamed in the process of the download.  Explorer may save the file with the file extension .htm.  If this happens, rename the file extension .mdb before you try to open the file in Access.
Due Class 6

IDEA Homework #1 – Sections 1 & 2

Do IDEA Section 1 - Introduction & Section 2 - Accounts Receivable Audit. 
Print out:

1) p. 34 #5.ii. - Field Statistics
2) p. 38 #10 - Field Statistics
3) p. 48 #18 - Graph of Aging Results
4) At the end of Chapter 2 print out the History contents, which documents your work. 
Staple in order and put your name on it and submit in class.  Print these contents in their COLLAPSED form, otherwise your print out will run many pages.
Due Class 7

IDEA #2 – first half of Section 3

Do IDEA Section 3 – Accounts Payable Audit and Fraud Investigation, topics 3.1 – 3.11, pp. 79 – 127.  After you have finished with 3.11, PRINT OUT the History contents, which documents all of your work with the A/P file.  Put your name on the printout and submit in class.

Coin Flip Homework Put your name on a sheet of paper and record the results of a string of 200 coin flips, H for heads and T for tails, horizontally across the page.  To get this string of heads and tails do ONE of TWO things: EITHER actually flip a coin and record the results, OR fake it – write down a string of H’s & T’s that looks as if you had flipped a coin.  Don't use Excel and its random number generator.  Also, please do one or the other, don't mix fake and real results.  Bring this page to class and hand in, but don’t tell me whether you faked it or not.
Due Class 8

IDEA #3 – second half of Section 3

Finish the remainder of IDEA Section 3 – Accounts Payable Audit and Fraud Investigation, pp.127 – 157.  Hand in these printouts in class:
1) Gap Detection Report, p. 133
2) Gap Detection Report, p. 140
3) Database and History of Payment Days Outside Policy Range file, p. 145
4) Database and History of Payments to Unauthorized Suppliers file, p. 153
5) Database and History of Large Movements file, p. 157
Due Class 11 IDEA Homework #4 - Section 4 

Do all of IDEA Section 4 - Inventory Analysis.  Hand in these printouts in class:
1) Report of Stratification Results, p. 181, #13
2) Stratification Results Chart, p. 181, #14, #15
3) Pivot Table for Total Provision By Depot, p.185, #10
4) The contents of the History Tab of the Inventory file at the end of the Section.

Read the Sherron Watkins article and prepare the following questions:

What is meant by a “diffusion of responsibility”?
What is the purpose of the system of internal controls?
How should we handle ethically challenged employees?
What is Watkins’ opinion of SOX?       
Where should fraud examiners have started their examination at Enron?
Due Class 13 1)  Read throught this "jargon" handout that defines some financial terms you may not be familiar with.
2)Watch this video of Matt Taibbi discussing Wall Street.
3) Read this article by Taibbi in Rolling Stone magazine called Why Isn't Wall Street in Jail? 
4) Read this article in Fortune magazine called The Quiet Coup by Simon Johnson, former Chief Economist for the IMF