Category: DataViz Assignments

Dataviz Final: Drive in Syracuse

Lack of underground public transportation system, buses came once an hour…it seems that driving is one of the main transportation methods in cities like Syracuse. While 95% percent of the American people owns at least one vehicle, a car crash is a major problem that stands in the way of driving safely to home.

In the city of snow, the most concern about driving is the harsh weather itself. But is there truly a correlation between weather conditions and car crashes in Syracuse? By analyzing the data within 2012-2014, total car crashes in Syracuse are 10,237. In this amount of car crashes, 1,024 incidents happened in Snowy weather. The most car crashes happen in clear and cloudy weathers which are 4543 and 2838. Considering road conditions as well, the snowy road conditions make 1210 of the total number of incidents. Snowy weather may have an impact on driving but driving on a sunny day doesn’t mean you don’t have to pay attention.

Also, there are more car crashes on Thursday and Friday than the rest of the whole week. Within the day, car crashes rise from 7 am. In the morning to 7 pm at night. Also, there is a significant peak after 12 pm at night as well.Taking care when you are on your way to work and drive while you are totally awake. Exhaust driving is one of the main reasons car crash happens. Stay alerted, stay alive.

Time-related car crashes
Create line charts

Unfortunately, there are 20 fatal car accidents reported in these three years. 3952 incidents of car crashes involve human injury. The most common car crash injuries involve soft tissue injuries, scrapes and cuts, head injuries, chest injuries, arm and leg injuries and burn injuries. Even though modern cars are focusing on passenger safety, it is quite inevitable to get seriously injured. Even though you do survive an accident, the follow ups would be a lot of pain.

word card
Create line charts

As conclusions, I would like to give some driving tips. Always be awake and conscious about the when and where you are driving. Take care of your car as well as yourself. Be prepared for all road and weather conditions. That’s how you drive in Syracuse as well as in everywhere in the world.

For parking tips of Syracuse. visit


Searchable Charts

I have posted it to my Alexoid blog. Here is the address.

Assignment 6 : Mahima Singh

With Rupert SandersGhost in the shell getting mixed reviews because fans kept comparing it to the original anime, I decided to do a comparison of anime with their live action counterparts.

I took the ratings from IMDB  and plotted it in this mixed bar chart.

The data entry into the JS code was easy enough, but formatting the original chart after that was a nice challenge.

I experimented with D3’s categorical colors and the charts’ axis formatting by writing a function of my own to make sure the ‘Rating” axis didn’t read negative values.


If you are familiar with pop culture and know a little bit about good cinema then you will know that James Wong’s white-washed adaptation of Dragon ball Z, Dragon ball Evolution was one of the worst live action remakes of any anime ever. So it is no surprise that Dragon Ball Evolution has the worst rating.

What is surprising to me is that Sailor Moon’s live adaptation (tv series) got the closest rating to its anime version. The Sailor Moon anime is a tough act to follow. But according to IMDB ratings, it looks like ‘Pretty Guardian Sailor Moon’ comes close enough.

Another obvious trend is the high ratings of the phenomenally successful anime, Death Note. While the anime did a little better, the film came pretty close and I say this from experience. Shûsuke Kaneko’s 2006 Death Note, had its pitfalls but it was a good movie. I doubt Netflix’s adaptation, set to release in August this year, will be able to live up to the hype. But we can only wait.

Here is a list of live action films (based on popular anime) in the making. Some names like Naruto, Bleach, Fullmetal Alchemist, Tokyo Ghoul and Attack on Titan have a lot riding on them because of their incredible fan base.


Assignment 5-Yuanjun Peng

I’m interested in child-welfare. Since health issue, especially drinking water is widely concerned, I went to website of UNICEF (United Nations Children Fund’s)and got data from the WHO/UNICEF Joint Monitoring Programme for Water Supply and Sanitation.

NA: data not applicable.
– Data not available at the time of publication.

Assignment 5: Sortable, searchable list

Use Tabletop to create a sortable, searchable list for a story using data you find on your own. Upload it to the class FTP and embed the list in your story.

In addition, summarize a subset of the data in a chart using one of the other tools we have covered so far in class such as, Google Maps, Highcharts.

Due: Tuesday, March 28 before class.

Assignment 2: Sorting and Filtering in Excel

In this exercise we will sort and filter data to understand it, then interviewing the data to gain insights and, hopefully, tell simple stories.

Data Viz – Sorting and Filtering Exercise
Using New York State Cardiac Arrests

New York State has an open-data policy. You can get a lot of data from New York State-funded programs at

In this exercise, we will be using data on salary information for New York State authorities:

Click the Export button and choose CSV for Excel, then save to your desktop.

Let’s make a list of the biggest fat cats in state government. Go to the Data menu and choose Sort.

  • Make sure the box labeled “My list has headers” is checked!
  • Click in “Sort By” and choose “Base Annual Salary” (column L).  Under “Order” choose “Largest to Smallest,” then click OK.
  • Who’s making the big money?
  • Change the sorting to smallest to largest. Who’s making the least?
  • Do you see any trends in the types of people who make the most and least amount of money?
  • Do you see any problems with missing data?

As you may notice, there are some records that have $0 for salaries, so we need to filter those out.

  • Go to the Data menu and choose Filter. You should see downward-facing arrows above each column header.
  • Click the arrow in the Base Annual Salary column.
  • Uncheck the box next to $0.

Now, let’s remove all salaries that are below the Federal poverty line of $20,000. Create a Sort, and sort on Base Annual Salary from smallest to largest. Select all of the rows under $20,000 and choose Edit > Delete Row.

Finally, let’s use a combination of filtering, sorting and formulas to find the average salary of people in the “Managerial” group (column H).

Now you should be familiar with sorting and filtering. What trends do you notice in the data? Do you see anything that may suggest a potential story? Or did you find a good story?

Now let’s shift to a topic that’s in the news a lot lately: how much money U.S. presidential candidates are getting. The Federal Election Commission makes this available in spreadsheet form here:

Download the data from the state where you’re from (or if not from the U.S. you can just choose New York). Use Sorting and Filtering to create a list of donations to two candidates you follow. When you create each list, use the Excel SUM feature to tally up how much money the candidate has received.

As a final step, create a simple bar graph in showing how much they’ve received. In class I will show you how to embed this in a blog post.

The assignment: Find some interesting data from the New York State open data site. Use sorting and filtering to hone in on some interesting and easily digestible data points that could be used in a story. Create a graph of the data you find in Create a blog post that includes a link to the raw data from the NYS site, explain how you filtered it, and embed the chart into the post. Due Monday morning.



Assignment 1: Class survey and blog registration

Assignment 1 is to complete the registration for the class blog and fill out this survey. Both are due by Monday morning.

Vision Paper

Olivia Johnson
New 300
Vision Paper

The traditional form of journalism, newspapers, will not exist in a few years. However, for the other forms such as the digital aspect, there are a number of possibilities and realms that the field can go in. This is where modern technology comes in and can really make online journalism a vibrant and interactive space. The amount of new ways to convey messages is uncanny and really has bridged the generational gap, being able to reach an array for people from all walks of life. Everything from push alerts to 360 cameras and augmented reality have really given the audience something to look forward to when viewing the news. Also, the numerous ways the news can be distributed, from cell phone applications to videos on a tablet to crawlers on TV screens there are endless opportunities for journalists and media outlets to captures the audience’s attention. If the industry was able to capitalize on the numerous mediums being used another way than advertising then it could revitalize the entire business. Most importantly the outlets would be able to report the news more accurately and timely than previously done.

One of the ways the media industry can rebrand itself and gain some more credibility is by getting access to places that it has traditionally not been able to see easily or cheaply. This can be done through photography and videography on drones. Drones can reach heights that reporters can’t without helicopter access or paying someone that knows how to use a drone to fly. If media outlets had easier access to drones they could cover breaking news such as traffic jams or natural disasters faster and easier than they currently can. It would also be tremendously cheaper and they would be the owner of their content instead of buying footage from a third party. In addition to the price, media outlets would be able to give the public a better understanding of situations because of the proximity and the aerial view that could be obtained from using a drone. With drones the risks are minimal; permission and training are the obstacles that are preventing the wide use of drones in the industry. Once this hurdle is crossed a new form of reporting will take place. Maybe drones will fly over a fire and a journalist will do a live or voice over of the scene for web and live packages. The possibilities are endless.

Augmented reality is another possibility for the industry when reporting on the news. With augmented reality a person can be in their home or office and dually be in another reality, as opposed to being completely immersed in a fake or recorded universe. In this augmented world, a person can be taught how to fix appliances live from a plumber somewhere else or experience their children being in the room with them that are in actuality far away. It would be very interesting how the media could use this new space to incorporate the news. What if a person woke up in the morning and saw a cloud hanging over their bed to inform them that there was going to be inclement weather? What if people could experience morning show interviews with politicians or a celebrity right in their living room? This could take interactivity with news to the next level. There would no longer be a middle man of sorts when it comes to the people and the news, both would be one in a sense. HoloLens is the product that allows for this kind of experience and although it is not currently available for the masses to use. Once it is, it can be a great platform for the media to use to have interactive informational experiences for their audience. Who wouldn’t want to have a live interview in their home or know the weather as soon as they woke up in the morning or have someone demonstrate how to make a new food recipe in their kitchen while still being in the present and the comfort of their own home or office? It truly is the best of both worlds and I think the industry should capitalize on this experience for the public.

As for virtual reality, this can be used for online digital reporting and has been used by non-journalists, but could be extremely beneficial to the industry. With virtual reality, people are able to explore difference places and truly get immersed in what they are doing and where they are. This can be used for reporting because a person can be engulfed in a natural disaster such a Katrina and really get an understanding of what is happening on the ground. It is one thing for someone in New York to see the flooding that took place on the news in Dallas, but it is another thing for people to be able to wade in the water with the survivors and be able to walk into an abandoned home and empty store. This would really bring the news to life and make it more realistic for millions of people around the world. Recently, something like this was done for 9/11 by people in France and it was beneficial to new generations of people who were too young to really understand the gratitude of the event and for people that were not born yet. However, the experience had a negative effect on some people that participated in it. Some people felt that it was too real, especially people that lived through 9/11 and had first-hand experience of the devastation that it caused. They couldn’t handle an interactive virtual reenactment of what went on in the Pentagon and the Twin Towers. It to an extent traumatized them, but creators of the game did not understand prior to how such a detailed and graphic game could impact victims and their families. This is partly because they were from another country and weren’t directly impacted from the experience themselves. To them, it was probably a cool and a unique way to portray the event, but to the people that have lived through the experience they did not feel that way. If journalists could use this model not for a game, but for online use when covering anniversaries of Pearl Harbor or the killing of Osama Bin Laden they could really give people a different perspective on the event. This would also drive traffic to news sites that do not traditionally get a lot of attention from the public. In addition to that it would give the people a versatile experience and if it is too much for them they have the option to not participate or stop after a few minutes.

360 cameras are another new technology is the field. These cameras allow the user to capture images in a panorama kind of way, inclusive of a number of different angles and views. The camera gives photographers and videographers an array of different images that they would not be able to get otherwise. Journalists can use this to capture some of the world’s greatest wonders like reporting on the Grand Canyon or Niagara Falls. More specifically journalists that cover travel and want to give their audience a different view than what is currently on google images can use this camera as a way to do it. With the camera, the sky, the mainland, the water and the people filming can be captured. In addition to that, all the pictures can be synced to create a cohesive set of images for different perspective viewing. This camera can truly change the way people see images and if reporters can use this during their nightly reports or online or even as snippets on social media they can enhance the viewers experience and even encourage people to take a trip. The downside to these cameras is the cost. They can range from hundreds of dollars to thousands and for media outlets to spend this amount of money on a device would be a lot. In addition to the cost, having people learn how to operate the device can also be a burden. 360 cameras are not easy to use and rendering for some of the cameras can be a nightmare, however once the cost is paid and people learn how to use them it can be a wonderful asset to reporting.

Sensors can enhance the way investigative journalists report on the news. By using sensors they have more control over props they use to get information such as robots and toy cars. These devices have cameras on them and can be controlled by the person operating it using sensors. The investigative reporting industry is in a decline and if getting information for the people could be collected in a better, easier, cheaper fashion than these sensors could revitalize the industry. Other kinds of sensors like those on digital monitors can collect data that major companies can use. However, journalists could use these monitors to collect data as well. They can collect information about the people in the region that surround the monitor. Journalists can also use the data to cater to the needs of the people such as tracking what they use the monitor for and what kind of information they are interested in when it comes to news etc. The only problem with these types of sensors is that some unsuspecting users may feel that their privacy is being invaded. Especially since they are using the monitors for one reason, but the information is being collected, distributed and used is for another purpose. The legality of this is also still in question. Despite this, sensors of all kind can benefit the media industry and the people that depend on it for their news.

In recent years, there have been a number of science fiction ideas that have come true like tablets, mixed reality and sensors. These new technologies can not only be to the benefit of the people, but also to journalists. Journalists could use these technologies to make their reporting better and like the new mediums of the past like radio and television it can enhance and increase viewership. In a time where people no longer look to journalists to get their news this could bring back some of those people that have been lost along the way. It could also bring back the credibility that has been lost in the industry over the years due to a lack of accurate reporting and notable biases. It is the job of the industry to be malleable and encompass new mediums to report the news, to inform and to an extent entertain the people. The future of the media is endless if anticipated and used wisely.

Drones + Me =? (Assignment 4)

As a Geography and Television dual major, I feel the options for drones in conjunction with my career are endless. Right now I’m interested in either working in the urban planning field, the television industry, or somehow combining both career paths for an awesome hybrid job.

In geography, I can see drones being a great asset in creating accurate maps of the world. I’m sure in the next few years there will be drones with long lasting batteries that can be used to study climate change, crops, and other physical changes over time in the world.

In the entertainment industry, there is already projected ideas about the use of drones in future. I found an article about the use of drones in the hit Netflix series Narcos, in which there is technology used to program drones to track and record an actor’s movements.

“Four actors jump between rooftops and sprint through sheets drying on clotheslines while a camera tracks them from above, hovering close enough to see their faces. The sequence, filmed in Bogotá for the coming Netflix drug-war series, “Narcos,” was too intimate to capture by helicopter and too intricate to choreograph easily from the ground. Cue the drone.”

There is also a video attached to the article that discusses different projects where drones have been used, from Music videos and movies to personal low budget projects with amazing outcomes.

Here is OK GO’s ‘I Won’t Let You Down’, a cool music video where drones were a key in the making of the project.

Though there are still health concerns about the dangers of these flying cameras around the general public, the possibilities for this new technology is endless. If the price range were a little lower, I’d be in line to buy one at this very moment, but until then I’ll enjoy the projects that come from drones, and see how other students are using them at school.

Maxine Williams

Field Test – Journalism with Drones

For my field test, I wanted to see how effectively journalists could use drones to cover news, more specifically covering large vicinities and or large regions. I explored this by using a drone to fly over west campus, specifically the dome. Using drones to get an aerial view would be most beneficial to local and national news outlets and give the audience a better understanding of what is happening. If media outlets had easier access to drones to conduct such visual reporting the quality of news coverage would increase tremendously.

To get the footage I used a camera that took video and pictures that was attached to an eleven-pound drone and flew it from a parking lot near west campus. Setting up the drone took about ten minutes and two people were needed to control it. One person was needed to control the direction of the drone and the other person was needed to control the images that were being taken. The drone took flight vertically for about eight minutes with a loud propeller sound.




The drone flew near the dome, dorms and some academic buildings it also flew near the highway and captured great images of all those locations and the grave yard. The drone reached 439 feet in the air at one point and was able to reach the heights necessary to have a great vantage point over the surrounding area and the dome. As of right now with a little photo editing the images could be used for an array of publications and coverage regarding west campus. Henceforth the project was a complete success.


Currently, some media outlets pay professional drone users to flyer over certain places to capture the images or have multi-media specialist flyer in planes to get the images they need. This can be a safety hazard and not cost efficient for an industry that doesn’t have a lot of money. Although, profitable for the professional it at times may be an enormous inconvenience for the industry. If, media outlets had easier access to drones and could fly drones at their disposal they would be able to get in-depth coverage of fires and airports (during inclement weather when planes are not flying), protest (at a high view) and large stadiums such as the dome. Especially since a videographer or photographer on the ground cannot take a full picture of the dome from any vantage point. These pictures must be taken from the air and a drone is the safest way to do so.

Thus, the pictures and video I was able to capture from flying a drone were remarkable and tremendously beneficial. If I were actually covering an event in the dome or reconstruction on the dome or anything dome related the pictures would enhance any on air, recorded, in print, digital or other multimedia piece I was doing. This would give more credibility to the outlet I work for, myself and help the people visual the situation at hand.

It is the hope that in the future drones can be widely used in said way to advance journalism coverage. In order for this to happen the regulation of drones needs to be easier for the media to have access to. Also, the cost of drones (although cheaper than getting a plane) needs to come down. In addition to this, training for people using the drones needs to increase. However, if all these things are done then consumers of news will have a new way to view the world and the messages that journalists are conveying.

A special thank you to Kyle for taking the drone out with his team and flyer it with me.


DSC_5904 DSC_5907 DSC_5913

Assignment #5


The SparkFun RedBot Sensor – Wheel Encoder could potentially help investigative journalists significantly when they are out in the field reporting. At times,investigative reporting may take some maneuvering mentally and physically, with the Wheel Encoder sensor at least the physical aspect could get easier.

The Sensor works by detecting the movement of the wheels so that the operator can know where the robot is. This is done through the movement of small teeth that is connected to a motor, which is reflected off of infrared light, according to By measuring the light, the operator can tell how far away the robot is and how fast the wheels on the robot are turning. Wires on the robot connected back to the robot chassis is how this information is shared to the user.

These robots can have cameras or video recorders on them and can be sent inside a building, office, parking lot or facility to get information that journalists would not be able to get otherwise, a sort of candid camera approach. An easier operation of the robots and being able to track them more efficiently will help shed light on people, organizations, and companies that may not always be doing the right thing. Thus, when on these investigative searches it is imperative to know where the robot is at all times as to not alert someone or get caught. By using this it can make investigative reporting more efficient and really give the journalist and the people a more in-depth truth about the issue at hand.