- Here is the guideline: ICE 5.1 Telling a Story through Visualization
- Here is the dataset: studentloans2013.xlsx
- Here is the Tableau workbook: Student Loan by State – 2013.twb
- Post your group’s response below. One per group will be sufficient. Include all the names and your section number in your response and be brief.
Section 5, Rachael, Jen, Frank, Wei Hsiang Hung, Armin
1. The most effective graphic would be the treetop total aid disbursement by school type because it shows the different in public, private, and other schools and how those students receive more or less aid.
2. I think the least effective would be the bubble map of total aid disbursement by school type because all the bubbles are remotely the same sizes, hard to tell which has a lot more and a lot less, looks more equal than other graphics
Jack Tallman
I like the final visualization as it cleanly and accurately depicts the information while maintaining the differences of location using the map and the types of school by the pie charts (which are also measured by size/density of pie chart.
Conversely, the heat maps provide very little information and the sheer volume of the data makes every data point more insignificant. The smallest points are impossible to see, and the largest points are still small and difficult to ascertain.
1. The map (last one) we like because it breaks it down by State and also by public, non-profit, and propriety.
2. Bubble one we do not like because its hard on the eye, we don’t understand what its trying to say. To fix it we got rid of school and put in state, so it tells us which type it is-i.e. public, non-profit, propriety
Katherine Griffin, Blend Suka, Jaylan Brown, Andrew Rice, and Kandis Romney
1. The most effective graph is the heat map that’s divided by type of school because it shows what school is in each category received the most total aid
2. The least effective is the bar graph because it doesn’t show any details. would be better if each was split by school.
Nicole, Stephen, Will
Total Aid by School Type By State – In our opinion this is the most effective because the visual is easy to understand and the charts are broken up by state and within the state there is more data for the viewer to see.
Total Aid by School Type by State- this one is the the least effective because there is just raw data and the viewer has no visuals to make seeing the data easy
-Shivani Naik, Maya Krishnamurthy, Amanda Mewbourn. Daniel Roh
Shivam Patel- 005
1. I think the bar graph with total aid (disbursement) by Loan is structured well by showing the different values for each school type and splitting them into 3 different categories.
2. I think the least effective one is the pie graph as its only a generalized and has the least of amount of information.
Connor McShane, Sean Gallagher, Tyler Edwards, Owen Murphy – 005
1. The graph that we think most effectively portrays the data is the treemap. The ability to distinguish between the rankings using the color of the square as well as the size of the square provides the reader with an easy to understand diagram.
2. The graph that we believe least effectively portrays the data is the packed bubbles visualization. This visualization is hard to read without hovering over each label to distinguish the different characteristics. It also is not that appealing visually, as it is hard to look at and a little bit harder to understand than it needs to be.
Justina Mercado, Bria Harrell, Arwa Alburaikan, Isaac Silver (Section 005)
Most Effective Graph – We agreed that the most effective would be Total Aid by School Type by state, we feel like it shows the most data in the most efficient way.
Least Effective Graph & Recommendation – We agreed that the least effective would be the Total Aid (Disbursement) by School/Type (Treemap), this one is too cluttered and confusing. We recommend either changing the graph to a type of bar graph or separating the three parts into separate graphs.
Group members:
Natalie Schrider
Brooke Milligan
Solangel Dominguez
Peri Bright
One graphic we think is effective for gaining data is the bar graph (dispersement by loan) because it has the most information. The least effective is the pie chart because it does not have any information. I would recommend the data visualizations to be as informative as possible.
Group: Jesse Chambers, Dominick Peake
Best insight into data?
Graph 7 (Total Aid Disbursement by Loan Type). Breaks each loan type into color bars to understand easier. Splits the funding types into different school types and shows totals of each funding type.
Least effective worksheet?
Graph 2 (Number of Schools by Type Pie Chart) All similar percentages, does not show differences well. No title or background information to show what they represent. Also says number of schools, but gives percentage.
David Demnicki, Jack Maynard, Austin Quinn, Marc Maling
The “Total Aid by School Type by State” graph is effective because it breaks the data down by state.
The “Number of Schools by Type (Pie)” is also effective because it accurately displays the data.
The “Total Aid Disbursement by School (heat-map)” is not effective doesn’t provide the loan type and doesn’t account for the population but it is effective because it categorizes the aid and the university.
The “Total Aid Disbursement by School/Type(Tree-map)” is effective because it separates the 3 types of loans by ineffective because propriety is not proportional.