Choose 4 Colleges



Choose 4 Colleges11341105715 UniversityOf California,San Diego1087120635Grossmont College144907043815University OfMichigan163957069850San Diego State UniversityGather College DataWe went on the colleges website to look up the informationUndergraduate Full Time Tuition and FreesEstimated Cost of Living Entering Freshman Weighted GPAEntering Freshman SAT ScoreAverage High Temperature in Fahrenheit (F)Average Low Temperature in Fahrenheit (F)University of California, San Diego $13,234$168114.036396244Grossmont College$13206$5502.75508540University of Michigan$39,109$72253.817009520San Diego State University$2,736$5533.7811487748Scale to Common UnitsUmm… well this part is kind of like 1-100. One being I hate it and hundred being I love it. We used this formula to see what rating the attributes would get (=(B$11-B4)/(B$11-B$12)) Undergraduate Full Time Tuition and FreesEstimated Cost of Living Entering Freshman Weighted GPAEntering Freshman SAT Scores Average High Temperature in Fahrenheit (F)Average Low Temperature in Fahrenheit (F)University of California, San Diego0.780.160.140.801.000.61Grossmont College0.780.970.700.840.230.51University of Michigan0.360.640.240.320.100.02San Diego State University0.960.970.250.570.500.71Assign Weights The top row is one to ten; the middle row is ten to one hundred and the last row is this formula =B17/$J$17AttributeUndergraduate Full Time Tuition and FeesEstimated Cost of LivingEntering Freshman Weighted GPAEntering Freshman SAT ScoresAverage High Temperature in Fahrenheit (F)Average Low Temperature in Fahrenheit (F)Rank of Attribute231476Points9080100704050Weight0.180.160.200.140.080.101257300215265360997521209064198506350Applying WeightsThis is just like step 3 except were using this formula (=B13*(B$17/$J$17))MeasureUndergraduate Full Time Tuition and FeesEstimated Cost of living Entering Freshman Weighted GPAEntering Freshman SAT ScoresAverage High Temperature in Fahrenheit (F)Average Low Temperature in Fahrenheit (F) Local Attractions (distance from school in miles)TOTAL POINTS ACCUMULATED FOR EACH SCHOOLUniversity of California, San Diego0.140.030.030.110.080.060.120.58Grossmont College0.140.160.140.120.020.050.120.76University of Michigan 0.070.100.050.050.010.000.120.40SDSU0.180.160.050.080.040.070.000.58My top choice is Grossmont College because it has all the things I’m looking for in a college.The Results Are In! -2000252336165-24765027457408953508121658953503454401609725318389015335252174240411480013836653695700345440 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download