Data Analysis for Law Enforcement Grant Writing Using Microsoft Excel

Course Dates and Registration Information

Data Analysis for Law Enforcement Grant Writing Using Microsoft Excel Registration and Payment

Billing Address (optional)

We have two upcoming courses scheduled. The last course in 2022 will be held on December 19-20 from 8am – 4pm via zoom. The first course of 2023 will be held on January 16-17 from 8am – 4pm via zoom. Click the button above to register. If your agency requires an invoice in order to remit payment, please email registration@policegrantwriting.com and we will be happy to provide you with one.

Early RegistrationBefore November 15, 2022$450
Regular Registration After November 15, 2022$499
Group rates for five or more participants is available. Email evan@policegrantwriting.com for more information

Course Overview

Many grant announcements require that the applicant provide a justification for funding as part of a grant narrative. This is especially true today given the precipitous increases in crime that many agencies have faced in recent years. Grantors want you to describe the problems that you are facing so that they can ascertain whether funding is warranted. The strongest applications will demonstrate a command of the data, depict temporal trends with text and figures, make projections given current and past patterns, and demonstrate that data collection processes required for a grant are feasible and have been thought through. This course teaches participants how they can analyze their crime, traffic accident, staffing, and other data, in order to make a compelling case for why grant funds are deserved. Special emphasis is given to creating analytic products to include in your application that convey the results of your analysis in a clear, concise, and professional way. Participants also learn how to create data collection instruments in Excel for applications that require data collection, performance measures, and/or evaluation as part of the solicitation. This course provides the tools needed to make your needs assessment/problem statement section of your grant application stand out among the crowd of applications. This course assumes no or very little experience with Microsoft Excel.

Instructor

Evan Sorg, Ph.D.

Evan is a former New York City Police Officer and Grant Reviewer for the Department of Homeland Security, the owner of Police Grant Writing, and an Associate Professor of Law and Justice Studies at Rowan University where he teaches courses on policing, crime analysis, and crime mapping. Read his full bio here.

Course Schedule and Topics Overview

Day One

TopicStart TimeEnd TimeSkills/Knowledge Acquired
Introductions08000900Meet the Instructor and your peers
Grant Sections Overview09001030Examine solicitation examples and identify where analysis can be applied
Morning Break10301100
Police Data11001230Examine types of data, data collection, importing CAD data into Excel
Lunch Break12301330
Excel Overview13301430Locate Excel’s ribbon, tabs, columns, rows, cells, sheets, and learn how to enter basic formulas
Data Cleaning in Excel14301445Examine data structures and formulas for cleaning and transforming data
Bar Charts, Line Graphs, and Scatterplots 14451600Learn how to create bar charts, line graphs, and scatterplots to depict trends over time and correlations between two variables

Day Two

TopicStart TimeEnd TimeSkills/Knowledge Acquired
Pivot Tables08000900Create pivot tables, manipulate pivot tables, and aggregate data with pivot tables.
Pivot Charts09001000Use the pivot chart function to create charts and graphs directly from pivot tables
Morning Break10001030
Temporal Heat Maps10301130Create a temporal heat map depicting the day/time clustering of crime
Lunch Break11301230
Making Projections12301330Make yearly and quarterly comparison in data and calculate percentage change using formulas,
Data Collection Tools13301430Use formulas to pre-format an automatically updating data collection tool
Importing Product to Microsoft Word14301600How to anchor analytic products and tips on writing to describe analytic products
Note: This schedule is subject to change at the discretion of the instructor.