- 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.
2. The graphic that gives the most effective insight on the data is number of schools by type (pie) because the graphic is very clear and easy to read. The graphic is also labeled and and has good colors.
3. A graphic that is ineffective is total aid (disbursement) by school /type (bubble) because there are no labels and the graphic is hard to read because there are so many bubbles and different schools. I would recomend a different graphic for the data being used or adding labels.
The 7th graph is the most effective because it gives us as much information as we need in a clear and visually appealing way, without overwhelming us with too much information.
The 8th graph is not very effective because it is just a dump of numbers with no context given to the relationship between the numbers in other states, so we don’t know the significant of the numbers
Edward Jerez
Matia Daskalos
Emily Pancoast
Rebecca Wendover
Best Graph- Total Aid Treatment by school/type-Tree map
Worst Graph – Bubble- Treatment Aid by school/type
Our group Shane Clarke, Thomas Smith, Justin Cautilli
We think number 9 is the best, because it displays the data per state, and allows for the amount of aid, and what type, per state.
We think that number 6 is the worst, as it is really hard to tell what the data is about, some recommendations would be to use another type of graph.
Kevin Publicover, Christine Boligitz, Ivy Zhong, Allen Huang.
2. We liked the Data aid disbursement by loan type, bar chart. Easy to comprehend and compare based on loan type. The other charts are not as straightforeward in comparison.
3. Total aid disbursement by school, packed bubbles. We dont think this is the most effective type of graph to use because hard to compare. It would be easier to comprehend if we added labels.
Ethan & Alyssa Piselli & Ian Hauser
2. Total Aid by School Type by State
—-Effective because it’s very organized and easy to read and understand. Breaks each individual territory up so you can get a gauge on how different areas of the country distribute aid
3. Total Aid (Disbursement) By School
—-Setup has nothing to do with the data. Splits it between type of data and the total aid of each school but you have to go through every single dot to assess it. Doesn’t give aggregate data, no overall viewpoint.
—-Changes? Spread the data out more; some of the bigger circles mask the smaller ones (very difficult to pull data up from each circle present. Color changes to shade each area based on dollar amount of aid.
Sam Cohn –
Ava Doskicz –
Meghan McKee –
Anthony Gulemmo –
The chart for Number of Schools by type in a pie chart is the most clear and easy to read chart. I think it’s effective because it shows how close the percentages are for the sum of the number of records based on different school types. The different colors for each school type helps separate the data. The graph titled Total Aid disbursements by school is the least effective because when one is looking for information about individual schools, it makes it more difficult to read. It would work for a more encompassing view on the data but if you look at it more specifically it’s difficult to read.
Autumn Edwards, Danielle Burgella, Laurinda Lin
1) The Total Aid (Disbursement) by Loan Type bar chart is the most effective. This visual shows types of federal aid, which school type they are distributed to, and how much is distributed with an easy to follow color code.
2) The Total Aid by School Type By State map is the least effective because the pie charts are all different in size to compensate for the size of total aid as well as the state. The small pie charts blend the blue and green color codes making it nearly impossible to understand the statistics without zooming in completely.
Improve: Change the map to a heat map and get rid of the pie charts so that there’s a plot for each school type and the visual is much more appealing as well as easier to read.
1.) The most effective graphic given through Tableau is the text graphic. Reason being, all of the data is shown regarding the type of the school and what state it is located in.
2.) The graph that is the least effective is the packed bubbles graph. Reason being, it is difficult to comprehend in comparison to the other charts where viewing it already gives a lot of information. To fix the chart, I would recommend adjusting labels to help their audience.
Section 1
Justin Lazarus, Adam Nguyen, Kayla Clifton, Yuan Cao, Zach Boughter
Group: Daniel Blaszkiewicz, Jonathan Goetting, Alex Cohen, Curtis McCourt
Section 1
2) We found the final representation, the “Total Aid by School Type by State” map to be the most effective. This graph was easy to understand visually, and it provided more information than most of the other options. It allowed us to view the distribution by geographic region, total aid amounts, and the sources of the aid. Overall, we felt it was the most comprehensive and the most clear.
3) We found the table containing the total aid by school type by state to be the least effective. It is hard to make any conclusions when you have such a large quantity of data only represented numerically. To improve it, we would suggest adding some visual aspect to more clearly convey the information. Possible options would be stacked bar graphs, or the map option which we selected as our most effective option. Ultimately, adding any data visualization component would improve it to some degree.
Gia Thai Pham, Ryan Brandstetter – 005
The best: Total Aid (Disbursement) by School/Type (Treemap) – explantion: it shows the aid that each school gives and type of the school.
The worst: Number of Schools by Type (Bar) – explanation: we can’t know how specific it is for each school. We just know the number of school
Group members: Zayna Mcneil, Chitra Nanavaty, Jocelynn Mitchell
1. Total Aid (Disbursement) by loan type
Why? It is simple, organized by school type, colored by load type, visually appealing, and shows the amount of loan.
2. Total Aid (Disbursement) by School
Why? The graph has no labels, no legend, no title, is hard to see, and data unclear. We reccommend adding a title, a legend, and labels.
2.) I thought the best graph was the first graph. It was very simple, and it clearly display ed the message and information.
3.) I thought the worst graph was the fourth graph. There are too many schools to fit on that type of map, and it is hard to find a specific school. To improve it I would make it a scatter plot and and labels to each point on the scatter plot.
The best graph is Total Aid Treatment by school type, and it’s a tree map.
The worst graph is the bubble graph titled Treatment Aid by school type.
2. Our group thinks the best graph is the Total Aid Disbursement by Loan Type. The graph does a good job of breaking down each school type and providing distribution of aid given by the specific school type
3. Our group think the worst graph is the Total Aid by School Type by State. The graph does not give any visualizations, making it difficult to conceptualize. The graph could be improved by transforming the data into bar charts and sorting them in a particular order to see the scale.
Group Members: Laura Komara, Hannah Andersen, Quynh Nhi Nguyen
1. The best graph was the total aid disbursement because it is very detailed and focuses on every point.
2. The worst graph was the total average loan amount because it does not say how much each person owns.
1) I believe the Total Aid (Disbursement) by School was the most effective graphic due to the division of color, labels, and types of school. It was very clear what was being communicated in this graphic.
2) The least effective graphic represents the Average Loan amount by type due to the confusion it causes. The data is represented in a vague way which clear how to interpret. I would improve the graph by breaking down the data to an individual level so that the data be more easily understood.
Aung Zaw
Ishika Kedia Chaw Su
Jeongmin Shin
1)The most effective at giving insight into the data is Aid (Disbursement) by Loan type as it is clear and detailed and also has an informative overview.
2) The Least effective graph is Total Aid (Disbursement) by School/Type (Bubble) because it looks complicated and there are no texts or labels on the graph to give a general overview of the graph.