Most often, sophisticated data sharing systems are unavailable or not readily accessible for a prosecutor’s office to capture performance measures system-wide. If data-sharing is not automated, the office may need to create a manual data collection tool.
For example, the Office of the Cobb County District Attorney in Marietta, Georgia – one of seven SAJI pilot sites – created an online data entry system to compile, share, and analyze data related to sexual violence crimes across agencies.93 Prosecutors’ offices can utilize information technology (IT) personnel to create data entry systems similar to Cobb’s, which centralizes data from the prosecutor’s office, the county’s police department, and a community advocacy organization.94
Even without IT, prosecutor’s offices can easily collect and manually enter data from different sources. This example that follows uses an Excel workbook, with simple auto-populate formulas, to collect data from multiple agencies.
The workbook is comprised of multiple spreadsheets. Each participating agency can use a spreadsheet within the workbook to collect its particular data. Data from each individual stakeholder or agency is rolled up into one sheet (in this sample, Sheet A) that feeds into their outcome measures.