Idea data analysis workbook

documented by inserting screen shots of your results into a Word document IDEA Assignments Overview The IDEA software download that accompanies the textbook comes with a tutorial, which is a PDF file entitled, “IDEA Tutorial.” The tutorial contains 4 chapters and utilizes the sample data files that are included when IDEA is installed on your computer. In addition to the hands-on practice imbedded within the IDEA Tutorial, the Messier/Glover/Prawitt author team has created IDEA problems for each chapter. The problems associated with Chapters 1-5 relate to the IDEA tutorial data files. A new data set entitled Roger Company, created for Messier/Glover/Prawitt, is introduced in Chapter 5. The Roger Company data set is used to solve the IDEA end-of-chapter problems for Chapters 5-21 in the textbook. The IDEA Tutorial is matched with the Messier/Glover/Prawitt textbook Chapters 1-5. However, with a good understanding of the IDEA Tutorial, the PDF tutorial bundled with the software, students can successfully complete the IDEA end-of-Chapter problems for Chapters 1–10 of the Messier/Glover/Prawitt textbook. The IDEA Tutorial Chapters 1-4 can be assigned independent of Messier/Glover/Prawitt textbook Chapters 1-5 problems below. For example, if an instructor would like to assign IDEA end-of-Chapter problems for Chapter 6 of the Messier/Glover/Prawitt textbook, he or she would need to assign the IDEA Tutorial any time prior to assigning the IDEA end-of-Chapter problems associated with Chapter 6 of the textbook. Students generally require between 1½ to 2 hours to complete Chapters 1-4 of the IDEA Tutorial. Certain IDEA problems at the end of Chapters 11-21 require an understanding of the concepts taught in the textbook chapters. Jump to specific Chapter (Hold down the CTRL key and click on a link below) Chapter 1 Chapter 8 Chapter 15 Chapter 2 Chapter 9 Chapter 16 Chapter 3 Chapter 10 Chapter 17 Chapter 4 Chapter 11 Chapter 18 Chapter 5 Chapter 12 Chapter 19 Chapter 6 Chapter 13 Chapter 20 Chapter 7 Chapter 14 Chapter 21 The McGraw-Hill Companies, Inc., 2016 IDEA Assignments IDEA-1 IDEA Installation and Tutorial There is technical assistance available for the educational version of IDEA, please contact technical support: 1888-641-2800 Option#4 or email the help desk at HelpDesk@audimation.com Please download the IDEA software (IDEA 9 Educational Edition) and data files. Visit Connect’s additional student resources section to access the IDEA software (which will install the tutorial), the IDEA problems, and the Roger Company files. You can obtain instructions to access Connect from your instructor. Note: IDEA software is available for download with each copy of the Messier/Glover/Prawitt textbook (hard copy or eBook). To Install IDEA: Once you have downloaded the file from Connect navigate to the location on your computer where the file is saved then double click on the file and follow the installation instructions. The installation will also download the IDEA Tutorial File and some data files. To access the IDEA tutorial file, look in the IDEA folder and the pdf file “IDEA Tutorial” can be found inside the “Documentation” folder. Alternatively, you can download the IDEA Tutorial file from Connect. *Note, you may also open the IDEA software here by double clicking on the “IDEA” program icon, within the “IDEA” folder. The McGraw-Hill Companies, Inc., 2016 IDEA-2 Auditing & Assurance Services, 10/e Chapter 1 IDEA Problems Return to Menu There is technical assistance available for the educational version of IDEA, please contact technical support: 1888-641-2800 Option#4 or email the help desk at HelpDesk@audimation.com Tutorial Assignment (Estimated time to complete the Chapter 1 tutorial and the related end-of chapter-problem below is 10 minutes.) Read IDEA Tutorial Chapter 1. NOTE: please become familiar with, but do not focus on the sections related to the IDEA Server as you will not use the server during the tutorial or when completing chapter problems. Hint: Staying actively involved while completing the tutorial assignment will help you to complete the end of chapter IDEA problems more efficiently. You may find it helpful to review the assigned problems before completing the IDEA tutorial exercises. For instructions on accessing the IDEA tutorial please see Installation Instructions above (you can also download the IDEA Tutorial file from Connect). (Note: Unless otherwise instructed, please submit your answers to the following exercises and problems to your instructor in a word processing document.) Messier/Glover/Prawitt End-of-Chapter 1, IDEA Problems Problem 1 Let’s have you practice finding and opening an IDEA project, which is how IDEA organizes its data files. After launching the IDEA software please click on File and Open Database (in older versions of Windows, you may need to navigate to a folder labeled “CaseWare IDEA” to locate the IDEA software). You should be directed to a folder titled “My IDEA Documents.” Select “IDEA Projects” and open the “Samples” folder. Within the folder you will see 12 different sample data files (e.g., Sample-Customers, Sample-Advanced Statistical Methods, etc.). Please open the “Sample-Customers” data file by double clicking on the file. How many records are in the “Sample-Customers” project? Hint: Look to the bottom of the IDEA window. Close the file by clicking the “X” in the upper corner of the IDEA Database window. The McGraw-Hill Companies, Inc., 2016 IDEA Assignments IDEA-3 Chapter 2 IDEA Problems Return to Menu There is technical assistance available for the educational version of IDEA, please contact technical support: 1888-641-2800 Option#4 or email the help desk at HelpDesk@audimation.com Tutorial Assignment (Estimated time to complete the Chapter 2 tutorial and related end-ofchapter problems is 25-35 minutes.) Read and work through IDEA Tutorial Chapter 2. Hint: Staying actively involved while completing the tutorial assignment will help you to complete the IDEA problems more efficiently. You may find it helpful to review the assigned problems before completing the IDEA tutorial exercises. For instructions on accessing the IDEA tutorial please see Installation Instructions above (you can also download the IDEA Tutorial file from Connect). (Note: Unless otherwise instructed, please submit your answers to the following exercises and problems to your instructor in a word processing document.) Messier/Glover/Prawitt End-of-Chapter 2, IDEA Problems Problem 1 Go to the IDEA website (http://www.casewareanalytics.com) and click on the “Resources” tab, and then select “Whitepapers” from the drop down menu. Review any two of these articles. Now go to the “Customers” tab and read at least two success stories. Based on your review of the website, what are some ways IDEA can be used to help external auditors? Problem 2 On the IDEA website, click on the “Resources” tab and select “Tutorials.” Watch the video on how to import an Excel Spreadsheet. List four key formatting considerations of the Excel Spreadsheet before it is prepared to import into IDEA. The McGraw-Hill Companies, Inc., 2016 IDEA-4 Auditing & Assurance Services, 10/e Chapter 3 IDEA Problems Return to Menu There is technical assistance available for the educational version of IDEA, please contact technical support: 1888-641-2800 Option#4 or email the help desk at HelpDesk@audimation.com Tutorial Assignment (Estimated time to complete Chapter 3 pages 17-22 tutorial and related end-of-chapter problems is 35-45 minutes.) Read and work through IDEA Tutorial pages 17-22 of Chapter 3. Read through the middle of page 22.