https://docs.google.com/spreadsheet/ccc?key=0AjBRjzE7iN16dGpSbS1sNGJCQkxDSGlHby1hbnpaMkE&hl=en_US
[Note to Tommy: I followed the link above to a sheet titled “Tommy’s ratings” but I did not see your individual ratings anywhere in that spreadsheet. If you stored them somewhere else, please contact me. -Jack D]
Here’s the link
The bold numbers are the ones that stood out. Any student that had a total score of six or above was better than the rest. These final numbers were based on overall total averages of ACT, SAT scores, GPA, Race, and Extra Curricular Activity. None of the data had any financial interference.
[Note to Lucy: in the future, select some text, click on the “link” button, and paste your code to make it a link, like this. Jack D.] https://docs.google.com/spreadsheet/ccc?key=0Ai60uPLKQ6b0dDNwSHVINTNBbG5tN0VxTlhNejVUV1E&hl=en_US
[Note to Osa: next time, please select some text, click the link button, and paste the code to make a link, as I have done here.] https://docs.google.com/spreadsheet/ccc?key=0AoCuXifx-3wOdHBtSkdfMGpfdHQ2NndhRXJjRHZsQXc&hl=en_US
Here is the link
https://docs.google.com/spreadsheet/ccc?key=0AjBgBJ4-49yQdFpBaGlicmlDc3R0WnNFNllFNndINmc&hl=en_US
Here is the link.
[Saida: next time, turn your web code into a link, by selecting text and the “link” button above. -Jack D] https://docs.google.com/spreadsheet/ccc?key=0AtkroIUE8KHOdHA3cjV2eDRYS3g1Y1hzYlVPUjF5QXc&hl=en_US
my spreadsheet
[Gueve: next time, please select the text above and click the “link” button and paste it there. I redid this one for you. – Jack D.]
here is my link
Here’s the link. I added a special qualities column in which I made notes whether and applicant had been recommended by someone or had a particular impressive thing on their application. I also wrote down notes if there was nothing impressive about the applicant of if he/she seemed average.
https://docs.google.com/spreadsheet/ccc?key=0AtkroIUE8KHOdFVUVkVtWDNUY3hNX09PMVZRMUhMbEE&hl=en_US
In the spreadsheet I created a column where I inserted what I believed each applicant could potentially contribute to the college. I believed what Trinity College wants is a student who would be able to expand and grow but also contribute to the vast community. I deleted the class rank column because many of the applicants were not able to give a class rank rendering the information useless. I also deleted the school column, because I do not believe that going to a private or public school should make a difference in if you are admitted. In the end the decision came down to making the most geographically, academically,and culturally diverse class.
Here’s the link
I have created a master list that I used to determine which applicants are the most deserving of the spots. Through evaluations of ethnicity ranking 1 to 5 (one being Caucasian and 5 being Native American), each applicant is then put through a series of tests ranging from how high they scored on the ACTs, SATs, GPA, and other such tests. Finally I add into the equation extra curricular activity; when it’s all finished I am left with percentages and numbers out of five that I use to each students advantage or disadvantage. After all the math is done I get numbers out of five that I use to rank the applicants with a one to five grade.
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. .