Category: Uncategorized

here is the link:

[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

https://docs.google.com/a/thayer.org/spreadsheet/ccc?key=0AjQSeWJk5pdOdHI4cW1mOWFuc21nNEFPM0VuM0M3OHc&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

Ratings

https://docs.google.com/spreadsheet/ccc?key=0AjBgBJ4-49yQdFpBaGlicmlDc3R0WnNFNllFNndINmc&hl=en_US

Here is the link.

link to spreadsheet

[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. .

Here the link

As members of the admissions committee we have devised a process to cut down the list to seven students left with one of those seven (Paula Nunez) being strongly admitted.  We did a point system in which we gave a point to each category we felt was required.  For every applicant with two points or higher we decided to allow them to be accepted (with the exception of two). The Dean of Diversity called for more minority students so we gave each minority a point.  Then the Athletic Director felt that it was important to mention that the basketball and soccer coaches recommended two students. Although we gave the swimmers a point, the swimming coach did not ask for names to be forwarded; therefore, we kept Christopher Clarke on the waitlist. Daniel Juberi was another student who, although he plays basketball, was a member with two points who didn’t meet the criteria’s in the sense of his academics.  Although Caitlin Quinn has not met the academic standards the Vice President of Developments letter weighs heavily on the decision, so therefore we decided to give a point to the students who have been recommended, due to alumni, by higher order officers. We gave a point to those students who the board felt should be admitted during our class discussion. Finally we took the top six SAT scores and gave a point to those students who we felt achieved above average with their scores. Although we didn’t cut down the list to only three students, we have managed to cut the list down to seven. This will hopefully allow us to cut down to our final three soon enough.

To begin we moved the columns that we found least relevant, public/private school and class rank, to the right of the spreadsheet.  We found class ranking irrelevant because it varies extremely from school to school and many of the application didn’t even have a ranking.  While we still took the private and public schooling column into consideration we found other criteria that was more beneficial to our decision making process.  Next, we added two columns titled decision and ranking (out of 15).  From there, we closely reviewed each application while also comparing them to the entire applicant pool.  Once this was completed we were able to make our decisions and give the students a ranking out of 15 in the most beneficial way possible for the college.

Here’s the link:

In our admissions process we took everything on the students transcript into account. We compared each student’s cumulative GPA, standardized test scores, and extracurriculars. On top of that we looked at all of the students’ ethnicities, alumni or staff connections, and if applicable sports recommendations. We also looked at whether or not the applicant interviewed here at Trinity to see how interested in our school the students were as well as to see how well their interview went. Though, if the student did not have an interview we didn’t hold that against them. After taking all of these things into consideration we ranked the students on a 1-15 scale to see how they matched up in comparison to the other applicants fighting for a admission spot.

https://docs.google.com/spreadsheet/ccc?key=0AnRdYuns_NbpdEVJVFdtS0xZUUkzYm5ucFJTVm5DUXc&hl=en_US#gid=0 [Your team pasted in the URL above, and Jack made it a “link” for you.]