
Course dates and registration information
Course Date | Time (EST) | Location |
March 6-7, 2023 | 0800 x 1600 | Live via zoom |
April 3-4, 2023 | 0800 x 1600 | Live via zoom |
May 15-16, 2023 | 0800 x 1600 | Live via zoom |
Cost
Regular Registration | $449/participant |
5 or more registrations | $399/participant |
Register and pay online
To register and pay for the course online, simply click the button below and fill in your registration details.
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.
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
Topic | Start Time | End Time | Skills/Knowledge Acquired |
Introductions | 0800 | 0900 | Meet the Instructor and your peers |
Grant Sections Overview | 0900 | 1030 | Examine solicitation examples and identify where analysis can be applied |
Morning Break | 1030 | 1100 | — |
Police Data | 1100 | 1230 | Examine types of data, data collection, importing CAD data into Excel |
Lunch Break | 1230 | 1330 | — |
Excel Overview | 1330 | 1430 | Locate Excel’s ribbon, tabs, columns, rows, cells, sheets, and learn how to enter basic formulas |
Data Cleaning in Excel | 1430 | 1445 | Examine data structures and formulas for cleaning and transforming data |
Bar Charts, Line Graphs, and Scatterplots | 1445 | 1600 | Learn how to create bar charts, line graphs, and scatterplots to depict trends over time and correlations between two variables |
Day Two
Topic | Start Time | End Time | Skills/Knowledge Acquired |
Pivot Tables | 0800 | 0900 | Create pivot tables, manipulate pivot tables, and aggregate data with pivot tables. |
Pivot Charts | 0900 | 1000 | Use the pivot chart function to create charts and graphs directly from pivot tables |
Morning Break | 1000 | 1030 | — |
Temporal Heat Maps | 1030 | 1130 | Create a temporal heat map depicting the day/time clustering of crime |
Lunch Break | 1130 | 1230 | — |
Making Projections | 1230 | 1330 | Make yearly and quarterly comparison in data and calculate percentage change using formulas, |
Data Collection Tools | 1330 | 1430 | Use formulas to pre-format an automatically updating data collection tool |
Importing Product to Microsoft Word | 1430 | 1600 | How to anchor analytic products and tips on writing to describe analytic products |