Michigan college comparison data story

Using Google’s Advanced Search Engine I was able to find different collections of data regarding Michigan Colleges including one I used to make a data story out of. This was an Excel sheet that covered the demographics, admission basics, and costs of Michigan colleges from 2-year, 4-year, and private schools.

Using Google’s Advanced Search to find Excel formatted data of Michigan colleges.

The section that was of most interest to me was the costs of the colleges. I was able to manipulate the data and sort it from most to least expensive universities in Michigan using the Sort and Filter tool on Excel. This allowed me to see exactly how much each university costs to attend and was helpful in organizing information in the way I needed in order to make my data story.

In fact, in terms of total expenses including tuition and fees, books and supplies, room and board, transportation, and expenses for in-state freshmen of 4-year Michigan Universities, University of Michigan-Dearborn was the least expensive. It makes me proud to know that I can get a great education at a school that is rather affordable!

Sample of the data in the college comparison excel sheet.

Author: Aya Nasrallah

Aya is a freshman at the University of Michigan-Dearborn majoring in Behavioral and Biological Sciences on a pre-med track. She is a pediatrician in the making and has a long way to go to accomplish her goal. She enjoys spending time with family, watching movies, and learning about anything and everything. Stick with her on the journey!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s