Category: DataViz Assignments

Assignment 3 Tony Yao

I once worked for a TV reality show of this game. It would be interesting to look back in the development history of this game.

Assignment 2- Jakubowski

For my chart, i wanted to look at the data from the jail censuses taken from all the jails in NY.  The data , was separated by county and dates.  I left in all the counties, but filtered the data into the most recent census year, 2015.  The names of the county jails are on the x axis, with the total inmate populations in the jail and the amount of inmates that were sentenced are highlighted on the y axis.

I took interest in the findings from the Onondaga county jail.  There are two jails within the country limits, with nearly an inmate population of 1000, and only 377 being sentenced.

NY State County Jail Populations (2015)
Create bar charts



Assignment 2 Groh

I examined the population density of New York counties in regards to the number of liquor licenses each county has. I had to utilize two different data sources to obtain the population density. I put the number of liquor licenses in one column and the counties’ population in another. After that I inserted the formula =C:C/B:B. The significance of this formula is that I did not have to manually enter each formula. I was able to apply that formula to an entire column and excel was able to identify the proper numbers that corresponded to each row.

People per Liquor License in New York Countie
Create bar charts

Jewish People Were The Main Targets of Hate Crimes In New York State

Most hate crimes in New York State from 2010 to 2015 were against Jewish people, according to the dataset of hate crimes by county and bias type published by the New York State government.

Of the 3,671 hate crimes from 2010 to 2015 in New York State, 1442, about one quarter, were motivated by bias against Jews. Black people were also main victims of those hate crimes, with 670 against them during the six years. Hate crimes against the LGBT group also took a large percentage of the total incidents, with 548 targeting male-homosexuals.

In New York State, Kings is the county that had the largest number of hate crimes. About one fifth of the hate crimes happened there. New York had 522 hate crimes during those six years.


New York State Hate Crime from 2010 to 2015
Create pie charts

I found these dramatic numbers and trends mainly using Excel. I created a Pivot Table first and set county names as row labels. I also summed up the number of each type of crimes in the table. Then I arranged data in descending order and found out the most common types of hate crimes. To find out what counties had most hate crimes, I created another Pivot Table with county names as row labels and the total of crimes in each county as values. Besides this, I also did some calculations, filtering and sorting to ensure what I found above was correct.

Assignment 2 : Mahima Singh

All data is interesting. Choosing one dataset to visualize took a little longer than I thought it would. Ultimately I decided on the “Hate Crime” data because it has so many levels. The data dictionary is adequality explains the fields and I didn’t have to clean any of the data myself. Some other datasets that involved age groups required me to convert 0ct-10-2019 to 10-19 because the file had that column set to date type.

There are two kinds of crimes in the dataset: “Crimes Against Persons” and “Property Crimes”. While these two are choices under the “Crime Type” column, the type of bias isn’t classified into groups. This data was found in the “Hate Crime Overview” document in the “about” tab on the site.

To find the total number of crimes per type for each bias, I filtered on that particular crime type and summed all the columns. Then I just took these numbers and pasted them into different sheets of the chart making sure that the correct columns came under the correct bias type.

I have worked with before and my personal favorite theme for a chart has always been “Tokyo.” It fit well with the nature of the data. Even though the area charts are giving us an idea of the number of crimes across the different biases, having information on the total number of incidents and especially the number of offenders and the number of victims adds value to the visualization.

Hate Crimes by Bias Type: 2010 -2015
Create your own infographics

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.

Assignment 2: 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.

PRD and Pitch Deck

Doing this was not easy. There’s a lot more that goes into drafting a business than I initially thought. I came up with more and more ideas for my dating service but that only increased costs. I also learned that my revenue source isn’t as viable as I thought at first. I haven’t found a good way around that yet.

Overall, it was fun to do. It put my mind in business mode. So while detailing this idea, I came up with other business ideas too.

What2Do Pitch Deck


What2Do PRD

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