Crime Analysis Workshop for Students Using Microsoft Excel

The Crime and Security Data Analytics Lab will host a workshop on crime analysis at noon CT Wednesday, Sept. 29. It will be led by Grant Drawve, the associate director of CASDAL and associate professor in the Department Sociology & Criminology.

Established in 2020 and housed in the Terrorism Research Center, CASDAL is designed to meet the analytical needs of students, faculty and external partners by providing space for research projects relating to crime and security issues, facilitating research partnerships with public and private agencies, and offering trainings in the areas of spatial and statistical analysis of data.

The aim of this workshop is to explore the functionality of Microsoft Excel in crime and social data analysis. This workshop is designed to showcase different tips and tricks in Microsoft Excel that are common functions in data analysis. The workshop will use real-world data from Little Rock, Arkansas, to explore pattern identification and data visualization. The workshop will focus on broad applications and introductions to analytical skills that could be further developed through courses offered through the Department of Sociology and Criminology: Introduction to Secondary Data & Data Visualization and the Spatial Analysis of Social Data.

The workshop will be made available live-virtually as well as recorded and posted on the CASDAL YouTube Channel. More broadly, the CASDAL YouTube Channel houses several instructional videos related to crime analysis and statistics. Furthermore, much of the material covered in the workshops will be linked to course materials being developed for two open educational resource textbooks by Drawve and Katie Ratcliff, and supported by the University Libraries. 

Register for the workshop!

Headlines

PetSmart CEO J.K. Symancyk to Speak at Walton College Commencement

J.K. Symancyk is an alumnus of the Sam M. Walton College of Business and serves on the Dean’s Executive Advisory Board.

Faulkner Center, Arkansas PBS Partner to Screen Documentary 'Gospel'

The Faulkner Performing Arts Center will host a screening of Gospel, a documentary exploring the origin of Black spirituality through sermon and song, in partnership with Arkansas PBS at 7:30 p.m. Thursday, May 2.

UAPD Officers Mills and Edwards Honored With New Roles

Veterans of the U of A Police Department, Matt Mills has been promoted to assistant chief, and Crandall Edwards has been promoted to administrative captain.

Community Design Center's Greenway Urbanism Project Wins LIV Hospitality Design Award

"Greenway Urbanism" is one of six urban strategies proposed under the Framework Plan for Cherokee Village, a project that received funding through an Our Town grant from the National Endowment for the Arts.

Spring Bike Drive Refurbishes Old Bikes for New Students

All donated bikes will be given to Pedal It Forward, a local nonprofit that will refurbish your bike and return it to the U of A campus to be gifted to a student in need. Hundreds of students have already benefited.

News Daily