Student Math SAT Verbal SAT SAT II Subject Rank Class size
A 520 480 450 103 298
B 640 120 800 3 137
c 250 300 800 492 506
d 590 600 720 352 440
e 590 800 740 193 160
f 650 680 240 53 800
g 590 700 550 120 410
h 310 520 390 42 77
i 430 290 450 10 240
j 470 510 420 -15 137
k 600 720 930 210 982
On Worksheet should include Math SAT, Verbal sAT, SatII, Rank, and Class Size
Criteria used in deciding admissions:
SAT test scores always range from 200 to 800.
1. If an impossible number is submitted, the applicant is refused admission.
2. If any test score is 800, the applicant is accepted.
3. If any of the test scores is below 300, the applicant is refused admission.
4. If the Math and Verbal SAT scores average above 600 and the applicant is in the top quarter of the top quarter of the graduating class, the applicant is accepted.
5. If any two of the test scores are below 400 or the applicant is in the bottom quarter of the graduating class, the applicant is refused admission.
6. Otherwise the applicant is put on the waiting list.
Criteria applied in order.
These criteria are applied in order. Thus any impossible number disqualified an applicant. If the five numbers are valid, then any test score of 800 means acceptance, regardless of the other numbers. if the first two criteria do not hold, then check the third criterion. And so on.
Worksheet should have a different cell for each criterion. Then you should combine all six criteria into a final decision of either "Accepted", "Denied Admission", or "Waiting List".
The solution should be in excel and formulas for logical functions should be behind the answers.