Question
Please help on this assignment !!! Case 1 - Fraud (9-64) ACL icons, commands, and equations in bold, data files in italics. In this project,
Please help on this assignment !!!
Case 1 - Fraud (9-64)
ACL icons, commands, and equations in bold, data files in italics.
In this project, ACL can be used to identify potential fraud in the Pell grant program. It can be used to identify:
Any student receiving more than the annual maximum grant ($3,125 is used in this case).
More than one student using the same social security number.
Any student using different social security numbers.
Any students receiving grants that should not be receiving grants.
It could also be used to recalculate the correct amount of grants for each term, but this is a lot of work and the results indicate that, except for rounding, nothing new is detected.
Condition Number | Approach |
To Begin | Create a new project by clicking on the New Project icon or choose File, New, Project from the menu and give it the name Pella. Be sure to save the project on the medium that contains the data files.
Import the Pella file. Name it grants.
|
1 | Objective: To check for a student getting more than $3,125 during one year.
Using the grants file (table):
1. The SSN field must be changed from Numeric to ASCII format. Choose Edit, Table Layout. Double click on SSN, click the down arrow next to Numeric, find and click on ASCII (above Numeric in the drop-down window), click the green arrow in the left margin and close this window by clicking the X in the upper right-hand corner of this window.
2. Choose Analyze, Summarize from the menu. Then choose the following: Summarize on - SSN, Subtotal fields Amount Other Fields LAST, FIRST
Click on the output tab and file. Give the new file the name Student Totals.
Using the Student Totals file,create a filter with the expression Amount > 3125. Click OK.
(You will find 3 students here)
3. Double click on the grants file in the left window to make it active. Create a filter with the expression Last = Student 1 Last name (insert students last name you found) OR Last = Student 2 Last name OR Last =Student 3 Lastg name. (Note: the name must be in quotations.) Click OK.
Results: Student findings and analysis
|
2 | Objective: See if more than one person uses the same SSN.
Remove the filter to get the complete grant file: Choose Data, Extract Data, If using the equation Term = 1. Name the file Term 1 in the window next to the To button. Click OK. Using the Term 1 file, choose Analyze, Look for Duplicates on SSN. Hold down the Ctrl key and click all fields to list them in the output. Click the Output tab at the top of the screen and select either Screen or Print. If you sent the output to the screen, the results can then be printed. Repeat for Terms 2 & 3
Results: Student finding and analysis |
3 | Objective: See if the same person is using different SSNs.
Using the Extracted Files for Terms 1, 2, & 3 from Condition Number 2 above For each term check for duplicate last names, Analyze, Look for duplicates. Sequence on Last and include all fields in the output to screen. Scan each list of duplicate last names for duplicate first names.
Results: Student finding and analysis |
4 | Objective: See if anyone with a need code 5 got a grant.
Using the grants file: Create a filter with the expression NEED = 5 AND AMOUNT > 0 (Put all of this in one equation).
Results: Student finding and analysis |
The items of potential fraud are:
Condition Number | Condition | Social Security Number | Name |
1 |
|
|
|
2 |
|
|
|
3 |
|
|
|
4 |
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started