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: