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.
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.
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.
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.
- 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.
- Adding new categories: We added new columns to the dataset to categorize the crimes as felonies, felony-misdemeanors and misdemeanors.
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.
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.
We wrote a news story that was about 15 short paragraphs.
Who completed which part of the data story
- 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”
- Story idea and data source
- One table (blue and green)
- Lead (before revision)
- Story body
- Scraping data
- Analysis and transformations on data
- Data biography
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.
KU Libraries to host an open access event, discuss journal deals
As a communication intern for KU Libraries, I wrote this news release about our open access event.
I researched Exelon Corporation using NAICS, IBIS World and Mintel. I also used ProPublica and GuideStar to locate Form 990 and examine Wires Group, a trade association related to Exelon.
Continue reading “Industry and Consumer Trends”
I used the 10-K form, Social Mention, EDGAR (U.S. Securities and Exchange Commission) and Google Finance to write a research paper about a public company. Here’s the summary:
Continue reading “Public Company 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”
Link to the project.
I designed an Adobe Express webpage for my Media & Society class final project.
I explored how “Albasheer Show” utilizes the concepts of mass communication. My research showcases “Albasheer Show” as a revolution in Iraqi media.