West Side Story

  • Boys Soccer plays Cedar Rapids Kennedy High School at home Apr. 25

  • Boys and Girls Tennis meet at Cedar Rapids Washington High School Apr. 25

  • Best Buddies hosts their Talent Show and Family Night in the North Band Room Apr. 25

  • Boys Tennis meet at Waterloo West High School Apr. 27

  • Girls Tennis meets Waterloo West High School at home Apr. 27

Streamlining the college search

Caleb Kwok ’20 created a spreadsheet that lays out college information with the hopes of helping students who are unsure of where they want to attend.

Caleb+Kwok+%2720+displays+the+college+spreadsheet+he+made+to+help+compare+colleges+from+across+the+country.
Back to Article
Back to Article

Streamlining the college search

Caleb Kwok '20 displays the college spreadsheet he made to help compare colleges from across the country.

Caleb Kwok '20 displays the college spreadsheet he made to help compare colleges from across the country.

Maddi Shinall

Caleb Kwok '20 displays the college spreadsheet he made to help compare colleges from across the country.

Maddi Shinall

Maddi Shinall

Caleb Kwok '20 displays the college spreadsheet he made to help compare colleges from across the country.

ACT, SAT, tuition, housing, acceptance rate, size… All of these are factors that college-bound students must take into account when deciding which schools they want to apply to or attend.

This information can be a challenge to compile, but Caleb Kwok ’20 took up a project to address the plethora of information students must compare between colleges by organizing it into a spreadsheet.

He wanted to help fellow students who know what field they are interested in but don’t know what kind of college they want to attend. His spreadsheet is separated into tabs based off of majors and also includes one tab of Iowa colleges.

“I talked to some college students, because our family has friends over sometimes and even those college students didn’t really know what they wanted to do with their life,” Kwok said.

Kwok then thought, if high schoolers could be more informed, students would be better off.

“He put in a lot of work,” said Kaushik Raghavan ’20. “It’s a really comprehensive spreadsheet … I’m really thankful he did something like this because it’s going to help a lot of people.”

Raghavan found it especially helpful because he is a second generation immigrant, so his parents didn’t obtain their undergraduate degrees in the United States. Raghavan has been able to look at what schools have his potential major, theatre.

What I think he did that was so unique and so personal [is] he really thought: ‘what do we really need to know? And how can we organize it in a way that would be exactly what a kid would want to know?’”

— Kerri Barnhouse

Rankings, public or private classification, ACT/SAT scores, acceptance rate and financial aid can be found on the spreadsheet. Kwok gathered the information of 150 colleges from U.S. News, Niche and Princeton Review.

“A lot of it had to do with interests. Like, think about what you’re interested in and how well you can succeed in school. You don’t have to go to the top school, that’s why I put in so many different types of schools,” Kwok said.

Kwok shared his information with his British Literature class, and many students were impressed by the mass amount of information. His English teacher Kerri Barnhouse suggested that he add a column about the application process.

“What I think he did that was so unique and so personal [is] he really thought: ‘What do we really need to know? And how can we organize it in a way that would be exactly what a kid would want to know?’” said Barnhouse.

She has seen students become overwhelmed by the application process, but Barnhouse believes it will help students look at colleges in a more realistic way and make grounded decisions.

View Kwok’s spreadsheet below, or with this link.

Print Friendly, PDF & Email

Hang on for a minute...we're trying to find some more stories you might like.


Email This Story






About the Writer
Natalie Dunlap, Online Feature Editor

Natalie Dunlap is a junior and the Online Feature Editor. This is her second year on staff. Outside of the newsroom Natalie enjoys trips to the Java House,...

Leave a Comment

If you want a picture to show with your comment, go get a gravatar.




Navigate Left
  • Streamlining the college search

    Feature

    Amplifying the voices of a nation

  • Streamlining the college search

    Feature

    Green hope

  • Streamlining the college search

    Feature

    A household in harmony

  • Streamlining the college search

    Feature

    Not seeing double

  • Streamlining the college search

    Feature

    The wonder twins

  • Streamlining the college search

    Feature

    High school student goes to American Idol Hollywood Week and releases EP album

  • Streamlining the college search

    Feature

    Testing new tech

  • Streamlining the college search

    Feature

    High stakes

  • Streamlining the college search

    Feature

    Caffeine: a miracle or menace?

  • Streamlining the college search

    Award winners

    Head in the SoundCloud

Navigate Right

Hang on for a minute...we're trying to find some more stories you might like.


Email This Story






The student news site of West High School
Streamlining the college search