https://docs.google.com/spreadsheet/ccc?key=0AjBRjzE7iN16dEhEekt4Tndsc3RpN1NQQXVZaVVNMHc&hl=en_US
Our system focuses heavily on the Dean’s suggestions in the correspondence. As a result, Caitlin Quinn, who has four alumni connections and a strong transcript, was one of the first people we automatically recommended for admission. In an effort to progress in the selection process, applicants who were recommended to be put on the waitlist during class (seen in red) were not taken into consideration in our ranking process. We evaluated the remaining nine applicants based on their GPAs and their SAT I combined scores in comparison with national averages for their races and their states—which we found from online from 2010 (sources listed below). As expected, many of these students exceeded these averages, so we calculated which of these students had exceeded both of these averages the most. 30% of applicants who are admitted actually enroll, so the students who remain in green remain on a newly-created waitlist that is ordered by GPA, while the three strongest of the nine with which we began are shown in pink. In addition to ranking the highest in regards to these factors, both Angelica Parker and Paula Nunes satisfy the Dean’s request for accepting diverse students as well as the requests of the athletic department.
Sources:
Benefield, Nathan. “2010 SAT Scores by State.” Commonwealth Foundation. 16 Sept. 2010. Web. 11 Sept. 2011. .
Marklein, Mary Beth. “Average SAT Scores Fluctuate Slightly within Class of 2010 – USATODAY.com.” USA Today. 14 Sept. 2010. Web. 11 Sept. 2011. .