You are auditing Pell grants provided to students at six state uni- versities. The Pell grant program is a federal financial aid pro- gram for college students. The maximum grant a student can receive during a school year is $3,125, with a maximum of $1,041.67 per semester and summer session. The amount of a grant depends on financial need (need) and the number of credits taken (status). Students cannot receive a grant at two different schools during the same school term. You have obtained a file of grants for the current school year (downloaded from the Internet, labeled pellA.XLS) that contains the following information:

SSN Social Security number Last Student's last name First Student's first name Middle Student's middle name School School-coded 1 to 6 - 1 - Fall Semester - 2 - Spring Semester - 3 - Summer Semester Need* Financial need - coded 1 to 5: 1 - 100% of allowable grant 2 - 75% 3 - 50% 4 - 25% 5 - 0%