Assignments & Exams Course: White-Collar Crime: PLG-304-1610 Assignment: Assignment 3 (following classes 4-5) Please read the criminal complaint that was originally filed against Bernard Madoff: http://fm.cnbc.com/applications/cnbc.com/resources... It might also help to read the transcript of Madoff's sentencing hearing, though parts of it will not be as relevant. http://www.justice.gov/usao/nys/madoff/20090629sen... Based on your knowledge of White Collar Crime, these documents and any independent sources that you deem appropriate, please explain what white collar crimes Madoff committed (including citing the applicable federal statutes) and describe the actions that he undertook that constituted the commissions of those crimes. Your answer should be approximately 2-3 pages long. An IRAC style essay is NOT necessary for this assignment.

Final Project: Data Analysis ReportSpreadsheets are useful for many other things besides financial tasks, such as progress reports and for keeping track of descriptive data. For your final project and presentation in this course, you will create at least two tables and an accompanying graphic that will help you write functions and learn simple programming techniques using advanced Excel features. This assignment gives you the opportunity to demonstrate the knowledge you have gained by using real-world data and applying at least five features of Excel to your dataset.Similar to the work you completed for your intersession assignments, you will need to locate real-world data. For this assignment, you will need to locate and utilize large datasets Resources for large dataset can be downloaded from several web sites such as http://www.datasciencecentral.com/profiles/blogs/big-data-sets-available-for-free.In an 8-10 page report:Provide an introduction to your overall projectGive a rationale and explanation for the datasets you have chosenInclude at least two tables demonstrating your data and analysisCreate at least one graphic to visualize the data and your analysisExplain how you have analyzed the data uzing at least 5 Excel functionsGive a thorough analysis of the data and it's implications not only for the organization but also the industry in which the organization operates.Offer any closing thoughts about the data and the overall projectYour report should be 8-10 pages, not including cover and reference pages. Provide at least 5 outside references and use APA format.Final PresentationIn addition to your written report, you will also present your report to the class during Session E. In a 10-15 slide PowerPoint presentation:Provide an introduction to your overall projectGive a rationale and explanation for the datasets you have chosenInclude at least two tables demonstrating your data and analysisCreate at least one graphic to visualize the data and your analysisExplain how you have analyzed the data using at least 5 Excel functionsGive a thorough analysis of the data and it's implications not only for the organization but also the industry in which the organization operates.Offer any closing thoughts about the data and the overall projectYour report should be 10-15 slides, not including title and reference slides.