🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Agriculture, Environment & Public Service › Law Enforcement / Security › Universal Core: Safety, Math, Communication & Career for Law Enforcement and Security › Lesson 6
AGR-LAW52-01 · Lesson 6 · 20 clock hours · lab

Digital Tools for Security and Law Enforcement Work

Objective. Students will use standard workplace digital tools — word processing, spreadsheet logging, basic database search, and a computer-aided dispatch (CAD) simulation — accurately and efficiently for security documentation and records tasks.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a licensed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why Digital Tools Matter in Security and Law Enforcement

Modern security and law enforcement work depends on accurate, timely digital records. Incident reports, patrol logs, and dispatch records are legal documents. Courts, supervisors, insurance carriers, and licensing boards may all review them. A sloppy or incomplete record can undermine a prosecution, expose your employer to liability, or cost you your state security guard license. Learning these tools now — before you enter a workplace — gives you a professional foundation that transfers to every employer.

Word Processing for Incident Reports

Most security employers require electronic report submission. You will use word processing software such as Microsoft Word or Google Docs to complete incident report templates. The goal is a clear, factual, error-free document.

Formatting discipline: Use the template your employer provides. Do not change fonts, margins, or field labels. Fill in every required field — date, time, location, names of involved parties, nature of the incident, and your name and badge number. Leave no field blank; write "N/A" if a field does not apply.

Spell-check and grammar tools are helpers, not proofreaders. These tools miss correctly spelled words used in the wrong context. For example, the sentence "The suspect fled too the north exit" will pass spell-check because "too" is a real word. Read every report aloud slowly before submitting. If you are unsure of a word, look it up.

File naming convention: A standard naming convention lets supervisors find files quickly. A common format is: `YYYYMMDD_LastName_IncidentType_SiteCode` — for example, `20250614_Rivera_Trespass_BLD4`. Your employer will give you their specific format; follow it exactly.

Exporting to PDF: Most employers require PDF submission because PDF preserves your formatting and cannot be accidentally edited. In Microsoft Word, choose File → Save As → PDF. In Google Docs, choose File → Download → PDF Document. Confirm the exported file opens correctly before submitting.

Spreadsheet Logging and Basic Analysis

Patrol logs track officer activity over time — who went where, when, and what happened. Entering data into a pre-formatted spreadsheet is a routine task at mid-size security operations. Accuracy is essential: a missing entry or wrong date can create legal gaps in the record.

Data entry basics: Type into the correct cell. Do not merge or delete cells in a pre-formatted file. Use consistent date and time formats (MM/DD/YYYY and 24-hour time are common in security). Double-check every entry against your source data.

Auto-sum for totals: The SUM function adds a column or row of numbers automatically. Click an empty cell below your data column, type `=SUM(` and then select the range of cells, then close with `)` and press Enter. For example, `=SUM(B2:B8)` adds all values in cells B2 through B8. This is how you calculate total patrol hours or incident counts for the week.

Sort and filter: The filter function lets you display only rows that match a condition — for example, showing only rows where the Status column says "Incident." In Excel or Google Sheets, select your header row, turn on Filter, then click the dropdown arrow on the column you want to filter and choose the value you need. Sort arranges rows alphabetically or numerically so supervisors can scan records quickly.

Computer-Aided Dispatch (CAD) Familiarization

CAD systems are software platforms used by law enforcement dispatch centers and large security control rooms to receive calls, assign units, and track responses. As a security officer or law enforcement trainee, you will not operate a full CAD system, but you must understand the workflow so you can communicate clearly with dispatchers.

The basic workflow:

1. Dispatcher receives a call and creates an event record with location, time, and nature of the incident.

2. The dispatcher broadcasts or assigns the event to an available unit.

3. The officer or guard acknowledges the dispatch, proceeds to the location, and updates their status (en route, on scene, available).

4. The dispatcher logs the response and closes the event.

In a simulation or role-play exercise: When you receive a dispatch card or simulated call, read it carefully — location, incident type, and any hazard notes. Find the location on your map before you acknowledge. Enter your update in the correct format: unit ID, status, and time. Example: `Unit 7 — En Route — 14:32`.

Safety note: In a real dispatch scenario, never approach a scene without confirming the address and understanding any known hazards. CAD records also serve as your safety net — if you stop updating your status, a supervisor or dispatcher will check on you. Keep your status current.

General Digital Safety Practices

Security records contain personally identifiable information (PII) — names, addresses, and descriptions of victims, witnesses, and suspects. Treat every record as confidential. Lock your workstation when you step away. Never email incident reports to personal addresses. Follow your employer's data retention and destruction policy. Violating data security rules can result in termination, civil liability, and in some cases criminal charges.

Key terms8

Incident ReportA formal written record documenting the facts of a security or law enforcement event, including date, time, location, parties involved, and actions taken. It is a legal document.
File Naming ConventionA standardized format for naming digital files so that records can be consistently identified, sorted, and retrieved — typically including date, author, incident type, and site code.
PDF (Portable Document Format)A file format that preserves document formatting and prevents accidental editing, commonly required for electronic report submission in security and law enforcement settings.
Auto-Sum (SUM function)A spreadsheet function written as =SUM(range) that automatically adds the values in a selected group of cells, used to calculate totals such as patrol hours or incident counts.
Filter (spreadsheet)A spreadsheet tool that temporarily hides rows not matching a selected condition, allowing a user to view only specific entries — for example, rows flagged as 'Incident.'
Computer-Aided Dispatch (CAD)Software used by law enforcement and security control rooms to receive, record, assign, and track responses to incidents in real time.
Personally Identifiable Information (PII)Any data that can identify a specific individual, such as name, address, or date of birth. Security records containing PII must be handled confidentially under applicable law and employer policy.
Status Update (dispatch)A brief radio or CAD entry from a field unit informing dispatch of the unit's current activity — such as en route, on scene, or available — used to track officer safety and resource deployment.

Worked examples4

1. You have patrol log entries for 7 days in cells B2 through B8, showing hours worked each day: 8, 8, 6, 8, 7, 8, 8. Write the SUM formula and calculate the weekly total.
  1. Click the empty cell directly below the last entry — cell B9.
  2. Type: =SUM(B2:B8) and press Enter.
  3. The spreadsheet adds: 8 + 8 + 6 + 8 + 7 + 8 + 8.
Answer: =SUM(B2:B8) returns 53 total hours for the week.
2. Your patrol log has 35 rows of data. The Status column (column D) contains either 'Routine' or 'Incident.' Describe the exact steps to filter the spreadsheet so only 'Incident' rows are visible.
  1. Click on the header row cell for column D (the 'Status' header).
  2. In Excel: go to the Data tab and click Filter. In Google Sheets: go to Data and click Create a Filter.
  3. A dropdown arrow appears on the Status header cell. Click that arrow.
  4. Uncheck 'Routine' (or check only 'Incident') and click OK or press Enter.
  5. Only rows where Status equals 'Incident' will remain visible; all other rows are hidden, not deleted.
Answer: The spreadsheet displays only the rows flagged 'Incident.' The total row count visible will be less than 35, reflecting only incident entries. No data is lost; remove the filter to restore all rows.
3. You need to name an incident report file using the convention YYYYMMDD_LastName_IncidentType_SiteCode. The incident was a theft, it occurred on March 3, 2026, your last name is Okafor, and your site code is WH2. Write the correct file name.
  1. Convert the date to YYYYMMDD format: March 3, 2026 = 20260303.
  2. Use your last name as given: Okafor.
  3. Use the incident type: Theft.
  4. Add the site code: WH2.
  5. Join all parts with underscores, no spaces.
Answer: 20260303_Okafor_Theft_WH2
4. A dispatch card reads: 'Unit 12 — Respond to suspicious person at Gate B — 09:47.' You arrive on scene at 09:54. Write a correctly formatted status update for both 'en route' and 'on scene' entries.
  1. For en route: record your unit ID, status, and the time you began responding. Assume you acknowledged at 09:48.
  2. En route entry: Unit 12 — En Route — 09:48.
  3. For on scene: record your unit ID, status, and the time you arrived.
  4. On scene entry: Unit 12 — On Scene — 09:54.
Answer: En Route entry: 'Unit 12 — En Route — 09:48.' On Scene entry: 'Unit 12 — On Scene — 09:54.' Both entries are in Unit ID — Status — Time format, matching standard CAD update practice.
In class: Complete a hands-on word processing module: type and format an incident report template, use spell-check and grammar tools critically (identifying errors the tools miss), save and name files using a standard naming convention, and print or export to PDF — skills required for electronic report submission at most security employers. · Enter a week of simulated patrol log data into a pre-formatted spreadsheet, use auto-sum to calculate total hours and incident counts by day, and apply basic sort and filter functions to find all entries flagged as 'incidents' — mirroring the log management tasks at mid-size security operations. · Using a CAD simulation tool or a role-play exercise with printed dispatch cards, students practice receiving a dispatch, locating the incident on a digital or printed map, and entering a simulated response update — building familiarity with the workflow used in both security control rooms and law enforcement dispatch environments.
Materials: Computers or tablets with word processing and spreadsheet software (Microsoft Office or Google Workspace), pre-formatted spreadsheet log file, CAD simulation software or printed dispatch card set, incident report template, file naming convention guide, printer or PDF export function.
Check: Word processing: formatted report contains all required fields, no spelling errors, correct file name, and is successfully exported to PDF. Spreadsheet: all 35 data entries are accurate, totals are correct, and the student can demonstrate the sort/filter function on request. CAD: student accurately locates two of two dispatch scenarios on the map and enters a correctly formatted response update.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Communication and Documentation
1. An officer types: 'The witness stated she seen the suspect leave threw the side door.' Spell-check shows no errors. Why?
Communication and Documentation
2. Using the naming convention YYYYMMDD_LastName_IncidentType_SiteCode, which file name is correctly formatted for a vandalism incident on July 4, 2025, by Officer Dinh at site MN9?
Mathematics and Records Management
3. A security officer's patrol log spreadsheet has daily hours in cells C2:C8. Which formula correctly totals those hours?
Mathematics and Records Management
4. An officer needs to view only the rows in a 35-row patrol log where the Status column reads 'Incident.' What is the correct tool to use without deleting any data?
Public Safety Operations
5. In a CAD-based dispatch workflow, why is it important for a field unit to update its status regularly?
Legal and Ethical Responsibilities
6. An incident report contains a victim's home address and date of birth. Which practice best protects that information?
Communication and Documentation
7. Before exporting a completed incident report to PDF, an officer should:
Public Safety Operations
8. A dispatch card reads: 'Unit 5 — Respond to alarm activation at Warehouse C.' The officer checks the map, identifies the location, and begins driving. Which response update is correctly formatted?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →