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!

News Daily