Advanced Topics in Law Enforcement Grant Writing

Course dates and registration information

Course DateTime (EST)Location
March 6-7, 20230800 x 1600Live via zoom
April 3-4, 20230800 x 1600Live via zoom
May 15-16, 20230800 x 1600Live via zoom


Regular Registration$449/participant
5 or more registrations$399/participant
Email to register for group rate

Register and pay online

To register and pay for the course online, simply click the button below and fill in your registration details.

Advanced Topics in Law Enforcement Grant Writing

Billing Address

Register and pay via invoice

If you would like to register for the course, simply fill out your information below and we will reserve your seat. We will send an invoice to the email address provided with options to remit payment.

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.


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.