Overview
While Audit Command Language (ACL) and other data analytics are powerful tools, there are many functions that can be performed in Microsoft Excel. This assignment demonstrates how this common tool can be used to identify fraud.
Prompt
Using the data sets from Chapter 3 of ACL, perform commands in Microsoft Excel similar to those you will work with in the ACL textbook assignments. An Excel template is provided to assist in the completion of this assignment.
Specifically, the following critical elements must be addressed:
- Using the Empmast tab in the template, create a table in Excel that sorts salaries from lowest to highest.
- Using the Duplicates tab, explain how duplicates can be found in the Trans table.
- Provide the correct formula for total value of unit cost and sales price fields in the Inventory tab.
- Create an aging table using the AR Aging tab.
What to Submit
Your activity must be submitted as a Microsoft Excel spreadsheet. Different tabs should be used in the Excel workbook for each critical element. All comments can be inserted into Excel.
Module Two Activity Rubric
| Criteria | Proficient | Needs Improvement | Not Evident | Value |
|---|---|---|---|---|
| Salaries | Creates a table in Excel Empmast tab that sorts salaries from lowest to highest (100%) | N/A | Does not create a table in Excel that sorts salaries from lowest to highest (0%) | 22 |
| Duplicates | Explains how duplicates can be found in the Trans table on the Duplicates tab (100%) | Explains how duplicates can be found in the Trans table, but explanation is unclear or contains one or more errors (75%) | Does not explain how duplicates can be found in the Trans table (0%) | 20 |
| Formula | Provides correct formula for total value of unit cost and sales price fields in the Inventory tab (100%) | N/A | Does not provide correct formula for total value of unit cost and sales price fields in the Inventory table file (0%) | 25 |
| Aging Table | Creates an aging table using the AR Aging tab (100%) | N/A | Does not create an aging table using the AR Aging tab (0%) | 23 |
| Articulation of Response | Submission has no major errors related to citations, grammar, spelling, syntax, or organization (100%) | Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas (75%) | Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas (0%) | 10 |
| Total: | 100% |