I am not a spreadsheet type of person, but maybe my categories might help someone focus their data.
What I did was print out the degree maps for each program he was interested and made several copies of each. Then I went through and compared each one and made notes - how many credits overall in the program, how many gen eds required, how many courses specific to S17’s area of interest within the major. I used a different color marker with the top 3 choices to compare and contrast what each program offered.
I also looked at the class registration page on each school to check on things like when certain classes are offered - for instance, most schools have pretty much the same schedules year after year, so you can look and see when a particular course is offered compared to a different course. I looked at the course catalog for gen eds to see what S17 might be interested in. I also looked at transfer policies. My son has an LD in math and FL so I needed a school that would accept credits taken elsewhere. He intends to take those gen eds at the local CC - as long as he gets a C, the credits will transfer and the grade won’t go in his GPA. He couldn’t attend a school where he had to take those classes on campus because it would stress him out and destroy his GPA, the way it did in HS. For him, I also looked into the schools’ disabilities services program to compare them, though not everyone would need to do that.
I also compared costs, including things like extras for certain classes and transportation, as well as lodging in the area for when we visit. Another thing I checked was acceptance of AP credits. S17 only had 9 but I wanted them all to count. SUNY accepts 3 and better, the private schools wanted 4’s, which was a problem for me.
Ultimately, the choice came down to money, fit and AP and transfer policy. We found them all in his current school.