The administration and faculty at New Ivy University have thought long and h admission criteria. They have decided to forget about activities, athletic alumni, interviews, recommendations, etc. in deciding which high school stul admitted. NIU is going to decide admission strictly on measured acad standardized test scores and grades will count. are four numbers: two thematics SAT score) T test scores always Applicants will not have to write essays. All they will have to submit are fourn test scores (Evidence-Based Reading and Writing SAT score and Mathematice rank in graduating class, and number of students in graduating class. SAT test score should range from 200 to 800. The following criteria are used in deciding admissions: a. If an impossible number is submitted, the applicant is refused admission. b. If any test score is 800, the applicant is accepted. c. If any of the test scores is below 300, the applicant is refused admission. d. If the test scores average above 650 and the applicant is in the top quarter of the graduating class, the applicant is accepted. e. If both of the test scores are below 400 or the applicant is in the bottom quarter of the graduating class, the applicant is refused admission. f. Otherwise the applicant is put on the waiting list. These criteria are applied in order. Thus, any impossible number disqualifies an applican the four numbers are valid, then any test score of 800 means acceptance, regardless of an numbers. If the first two criteria do not hold, then check the third criterion. And so on cant is admitted. Your For this exercise you are to create a worksheet to decide whether an applicant is admin worksheet should be designed to accept the information for a single applicant. high school senior could enter the information into your worksheet and find out decision. In your worksheet you should have a different cell for each criterion. should combine all six criteria into a final decision of either "Accepted", "Denied or "Waiting List". find out the admission cell for each criterion. Then you d", "Denied Admission, to your worksheet on each of the following 11 applicants: Student Rank 103 3 492 Reading and Writing SAT 520 640 260 590 590 660 580 Math SAT 480 160 300 600 800 680 700 520 290 Class Size 298 137 506 440 160 800 410 352 193 53 120 77 320 920 460 520 -15 240 137 982 600 720 210