For WizardKim-W5-D.A

Week 5 Data Analysis:

Please play the IDEA videos and review the handout again from week 3 if needed on how to modify a field type

Please click on the link above to access the discussion question. 

IDEA Videos:

Gap Detection

http://www.youtube.com/watch?v=E_W2-l4AtjY

Joins:

http://www.youtube.com/watch?v=xv_PaGW9_9Y

Appending a Field:

http://www.youtube.com/watch?v=I-o9EzIz73U

Week 5 Data Analysis Discussion Question: 

· You have been asked to analyze the Cash Disbursements spreadsheet provided.

.   Week 5 Cash_Disbursemt.xlsx

. The company policy is that checks are only processed on the 15th and 30th of each month (Hint: Using IDEA modify/append the file and use @day formula for the 15th or 30th then set the criteria) and payments over $10,000 need to be authorized by the CFO, Albert Booth.

· Based on what you found during your analysis, discuss the controls you feel are needed for cash disbursements at this company. Design a spreadsheet (using advanced features of Excel) or a flowchart (using Lucidchart) demonstrating the implementation of the controls you feel are needed based on your analysis--upload a copy.  Be sure to identify specific ways to improve the cash disbursements process.