Category: Ray Li

IPC Transition Plan

Posted on Author Raymond Li

The data I received came from a database of Pediatric Trauma Patients from 2007-2012 which is owned by Connecticut Children’s Medical Center. All the data that I have are either in Microsoft Excel format or Google Spreadsheet. Because a lot of information is confidential in the original data or easily identifiable, the original data set cannot be shown publicly. However, as long as it is de-identified , such as removing specific columns of data (ie. age, city/residency) data may be displayed.

All my graphs and visualization can be accessed through my github site here. As for the actual data, all my formatted data is on a Google Drive folder that is easily accessible with the visualizations as well.

Although these are simple charts, the formatting of the data may be useful for the future just in case a data visualization expert would want to create more sophisticated charts. Although I do not have the training in coding that is required for more complex visualizations, I feel like the ones I have now create potential ideas for future visualizations. However, complex visualization may not be necessary because there is still so much that can be visualized from the data set.  Just using Google Charts can be sufficient for creating more visualization that don’t require expertise in data visualization.

 

 

Data Viz Redesign

Posted on Author Raymond Li

Personally, I have found this class to be very helpful in furthering my understanding of data and visualizing data. Before this class, I had the notion that data was just numbers that was used to show certain statistics, but I never thought about using data as a way of telling a story, or at least how to effectively tell a story with data.

Our class structure, the 0.5 credit seminar had its pros and cons. One of the things I liked about this structure was the time. The class itself wasn’t a huge time commitment, but at the same time, I was able to learn and get feedback from my own work and other student’s works. This was very helpful in terms of allowing me to think about my visualization and how I could make them better. Also, because it was only one hour a week, I was able to put more of my time into my internship which also allowed me to learn the insides and outs about research. On Wednesdays I would give an update on my work at research meetings at the Injury Prevention Center, which allowed me to further explain my project. However, because we didn’t have as much classroom time, I felt like we didn’t have enough time actually learning how to make visualizations. Although we used Google Charts and Google Fusion, I was expecting a variety of different programs or applications to make visualization, but it difficult in an hour long class.

The 3 week course, I feel like would be a little too hectic especially when paired with a community organization or internship. During the middle of the semester when the 3 week course would usually happen, I feel like a lot of students would be turned off by it since the middle of the semester is usually a busy time of the year.

I liked the third option the best since it allows for more variety of different ways to visualize data, but also allows for students to implement their learned skills with community organizations, although they won’t be spending as much time with them like an internship.

One suggestion that I think may work is having a semester long class that is partnered with one organization and using data from that organization for visualizations. During this class, coding and other methods of visualizations can be taught. Then during the next semester, students could take a follow-up class much like the one structure now and be paired with an organization for an internship. This way, students will already have experience with coding, but also have the opportunity to have an internship. Although this requires a lot of time, I feel like this would be a great way for students to obtain a skill and use that skill in the real world.

 

IPC – Pediatric Injury Trends (2007-2012)

Posted on Author Raymond Li

Through popular notions of accidents and media interpretation of injuries, many people have a perception that mostly all injuries are deemed to be “accidents” and are therefore part of everyday life. However, what people don’t notice is that many of these injuries are preventable if certain regulations, laws, and practices are implemented. For instance, seat belt safety and the widening of roads have decreased the amount of motor vehicle crash and lessened the severity of motor vehicle related injuries.

Many people also don’t know the trends that occur or the statistics that relate to injury. A lot of this information had been mainly for academic or medical uses only, but not for the public. The public’s knowledge on injury is mainly grounded on the media and it’s representation of injuries. Using a Pediatric Trauma Database from 2007-2012 and a paper on Pediatric Trauma, I have compiled a plethora of graphs and charts that represent injuries, not as accidents, but as something that can be predictable and hopefully preventable.

INJURY DEMOGRAPHICS

The following graphs show a few demographics on how injuries affect different ethnicity, age, gender, and locations in Connecticut. In terms of ethnicity, people of white descent make up the majority of injury patients who are serviced at Connecticut’s Children Medical Center, followed by people who did not give a specific ethnicity. Followed by those groups are Hispanics, Blacks, and then Asians.

For age groups, interestingly, the majority of male patients are aged 5-9, but there is a decrease after the age of 9. For females however, there is an increase of injury patients during early and late adolescence. Overall however, males suffer from injuries more than females.

The next graph shows where the majority of injuries occur. There are more injuries that occur at home more than any other location. The next location where injuries occur the most are in recreational areas, such as parks. These injuries may include sport injuries, or anything involving physical activity.

This next graph focuses on the Injuries based on Mean age. This graph represents the most common injuries per mean age group. For instance as the title suggests, falls are the most common injury that patients come to the hospital for. Also, falls are more likely to happen to young children.

The next map shows the distribution of patients serviced at CCMC based on the patient’s home town. The majority of patients come from the immediate Hartford area, which is not surprising because CCMC is located in Hartford.

The following graphs represent injuries over time. In the first line graph, we can see that during the day, patients come in the hospital more frequently at night than the day. This does not mean that the patients had their injuries occur during the night, but it is possible that the majority of injuries do.

INJURY BASED ON TIME

During the day of the week Saturdays have the most injuries.

There are spikes in injuries during the spring and summer time

The next chart shows the trends of injury that occur over the years of 2007-2012. One trend to look out for is that sports injuries seem to happen early on in the year, whereas Falls increase during the months of May – August. This trend seems to be consistent for all years from 2007-2012. The last graph sums up all the patients from 2007-2012 into on graph to show the trend from five years.

Instructions for Motion Graph

In order to use this graph, you must change the X Axis to “Time” and the Y Axis to “Number”. Also on the right hand side, the user may change the size of the bubbles based on “Total number of Patients” to distinguish each bubble as it moves. The user can then press play to see patterns. Also the user may see changes through a bar graph or a line graph using the options on the top right.

Falls Increase During the Spring/Summer

2007

2008

2009

2010

2011

2012

2007-2012

***Disregard the year, as it is only there for technical purposes only.

Assignment 9

Posted on Author Raymond Li

Through popular notions of accidents and media interpretation of injuries, many people have a perception that mostly all injuries are deemed to be “accidents” and are therefore part of everyday life. However, what people don’t notice is that many of these injuries are preventable if certain regulations, laws, and practices are implemented. For instance, seat belt safety and the widening of roads have decreased the amount of motor vehicle crash and lessened the severity of motor vehicle related injuries.

Many people also don’t know the trends that occur or the statistics that relate to injury. A lot of this information had been mainly for academic or medical uses only, but not for the public. The public’s knowledge on injury is mainly grounded on the media and it’s representation of injuries. Using a Pediatric Trauma Database from 2007-2012 and a paper on Pediatric Trauma, I have compiled a plethora of graphs and charts that represent injuries, not as accidents, but as something that can be predictable and hopefully preventable.

In these 5 graphs, they represent the number of injuries that occur during a whole year span, starting from 2007 to 2012 respectively. I would like to use a program or site like jsfiddle.net to group these graphs together. According to these charts, injuries are very frequent, but in many cases, injuries are more common in the summer time than any other time of the year.

The pie chart below show the percentage and number of injuries that occur to different ethnicities. The first represents males, while the second represents females. The last pie chart shows injuries based on location.

In terms of the time of day injuries occur, this line graph shows that there is a clear trend of when injuries are most likely to happen. The data shows, when patients were brought to the hospitals. Around the hours of 9PM, 10PM, and 12AM are when there is a huge spike of accidents that occur. Nighttime injuries are the most frequent.

This bar graph shows the number of injuries that occur during the days of the week from 2007-2012. From this chart, during the weekdays, the injuries are fairly consistent, but as soon as the weekend rolls around, there are far more injuries, especially on Saturdays.

This map shows the number of injures that occur in each town/city in CT based on Injuries per capita. The map also shows the number of injuries that occur in each city.

Assignment 8

Posted on Author Raymond Li

This sample map shows the percentage of minorities in the school districts. Using many gradients, I was able to create ranges that are very similar in color. Therefore, I was able to show that in the small area of CT, the percentage of minorities was similar throughout the towns/cities. If I wanted to show extreme differences, I would have used less gradients and ranges and had colors that contracted each other. In this map, There was a big range, but the colors representing each gradient was a similar color.
In the second map, I used data from IPC. I calculated the total number of injuries in CT and also added in population statistics. Using those stats, I was able to calculate the injuries per capita. Most cities/towns had a relatively low level of injuries. However, to make the map show an extreme difference, I used many gradients, but also chose different colors to represent each. For instance I used blue, orange, and red to show a greater contract between colors.
The third map shows the same data, but using the same color. Because the ratios are so low and similar, it looks like as if there is no difference in ratio of injuries in each town/city. However, this is not the case since the Hartford area as well as Cromwell, have the highest ratio, but it is not shown in the third map