Design a site like this with WordPress.com
Get started

News release: KU joins PeerJ’s Three-Year Membership Program

KU joins PeerJ’s Three-Year Membership Program

This news release is a part of an initiative I took to recycle old interviews of new faculty members done by my former supervisor. Using those interviews, we started a series of stories called “BiblioBio,” where we interview new KU Libraries staff and tell the stories of those who work behind the bookshelves.

Data Biography: KU Public Safety statistics report analysis

In this biography, Rylie Oswald and I outline our roles in our J309 (Data Storytelling) final project. We also explain the sources of our data, the tools that we used and our data analysis methods.

Data lifecycle 

Origins 

Our data comes from the University of Kansas Public Safety Office’s annual report of crime that occurred on and off campus. The data ranges from 2012 to 2021.

We are confident that our data is credible because it comes from KU’s Public Safety Office, which is responsible for responding to crime and emergencies on campus, along with providing a lost and found service to students.

We also interviewed Jack Campbell Jr., a  KU Public Safety investigator, who explained the data report to us.

Spreadsheet 

The rows represent the crimes, the categories the crimes fall into and the number of crimes that occurred in each year. There are 51 rows in the spreadsheet.

The columns represent the crimes, crime categories and years – 2012 to 2021.  There are 12 columns in the spreadsheet. Here’s a link to our spreadsheet.

Data transformations

  1. Removing old categories: The initial dataset had its own crime categories with total numbers that were miscalculated by small margins. These categories were difficult to enter in a data spreadsheet. Therefore, we removed these miscalculated total numbers and kept the individual numbers.
  1. Adding new categories: We added new columns to the dataset to categorize the crimes as felonies, felony-misdemeanors and misdemeanors.

Data analysis 

We sorted crimes from highest to lowest. We also created some pivot tables that inspired the creation of our graphs and tables. We also analyzed the correlation between overall crime rates on and off campus. 

Visuals 

We used four line charts and one bar chart to tell our story. One of the bar charts – “A comparison of the crime categories from before, during and after the pandemic” – was created with Tableau. The other charts were created using Flourish. We also used a few tables to make the data easier to read, which were created in Google Docs.

Words 

We wrote a news story that was about 15 short paragraphs.

Who completed which part of the data story 

Rylie:

  • Bar chart 
  • Two tables (yellow) & (blue) 
  • Implemented most revisions after meeting with instructor on Dec. 2
  • Interview with Public Safety 
  • Two line chart “how crime has changed on campus over the years” & “how car part thefts have changed over the years”

Abdullah: 

  • Story idea and data source 
  • Picture 
  • Headline 
  • One table (blue and green)
  • Lead (before revision)  

Both:

  • Story body 
  • Scraping data
  • Analysis and transformations on data 
  • Data biography

News release: Common book event

Nominations for the 2023-24 ku common book now open

This a news release that I wrote for KU Libraries to encourage faculty, staff and students to submit common book nominations.

I interviewed staff members, researched how the common book selection process has changed over the years and linked to previous news releases relating to the common book.

Public Records Research Summary

I accessed public records through the state of Missouri, including the Missouri business entity records and the Jackson County Recorder of Deeds, to research a local store. I also conducted a background check that included arrest, imprisonment, voter registration records for the owners.

This is a summary of my public records research on Coki Bijoux, a jewelry store in Kansas City, Missouri, which I wrote for my Information Exploration class.

Continue reading “Public Records Research Summary”

Local Business Research Summary

  • I thoroughly researched a local Kansas City store and wrote an analysis detailing why the business would be a good marketing target for the University of Kansas Endowment.
  • Assignment scenario: KU Endowment (KUE) is looking to cultivate local business owners as new donors. As a KUE communications intern, you have been asked to write a memo about a local business and its owners. In addition to background information, the memo needs to articulate three arguments that KUE fundraising staff can use to convince these owners to become KUE donors. The arguments need to be based on the research you conduct.
Continue reading “Local Business Research Summary”