Automation A-Z Series

Session One Library Lessons

Lesson 1:  Data Analysis Using Microsoft Excel Basic:  Charts, Pivot Tables and Other Displays

1. Threshold Spreadsheet
2. Incidents Spreadsheet
3. Excel Cheat Sheet
4. Video: Basic Structure and Tools (54 min)
5. Video: Functions and Formulas (56 min)
6. Video: Charts Pivot Tables and Other Displays (52 min)
7. Video: Macros (21 min)

Lesson 2:  Z-Score and Statistical Significance Made Easy in Excel

1. Online course (1 Hour)

Lesson 3:  Intermediate Microsoft Access:  Threshold Analysis, Critical Thinking with Analysis & Slicers

1.  New Threshold Spreadsheet
2. Excel Intermediate Cheat Sheet
3. Video:  Threshold, Critical Thinking & Slicers (57 min)
4.  Student Handout PDF: Threshold, Critical Thinking & Slicers
5. Video: Application with Complex Formulas  (60 min)
6. Student Handout PDF: Application with Complex Formulas
7. Video:  3D Mapping in Excel Part 1 (38 min)
8. Video:  3D Mapping in Excel Part 2  (30 min)
9. Student Handout PDF: 3D Mapping in Excel

Lesson 4:  Tactical Analysis: Part 1 - Identification of Patterns and Crash-Prone Locations

1. Article PDF: Identifying Crime Patterns
2. Article PDF: Pattern Analysis Factors
3. Article PDF: Targeting Fatal Traffic Collision Risk
4. Article PDF:  Crime Pattern Definitions for Tactical Analysis (IACA)
5. Template PDF format:  Actionable Bulletin Template
6. Spreadsheet Template:  Pattern Identification
7. Video: Identification of Patterns and Crash-Prone Locations  (60 min)
8. Student Handout PDF: Identification of Patterns and Crash-Prone Locations
9. Video: Analysis of Patterns and Crash-Prone Locations  (60 min)
10. Student Handout PDF: Analysis of Patterns and Crash-Prone Locations
11. Video: Actionable Distribution of Findings & Recommendations  (53 min)
12. Student Handout PDF: Actionable Distribution of Findings & Recommendations

Session Two Library Lessons

Lesson 1:  Creating Master Tables

1. Online Course ( 1 Hour)

Lesson 2:  Making Analytics Easier with Expressions

1. Online Course (1 Hour)

Lesson 3:  Customizing Master Crime/Crash Databases & Forms

1. Sample MS-Access Database
2. Video: Customizing Your Master Databases & Forms (60 min)
3. Student Handout PDF: Customizing Your Master Databases & Forms

Lesson 4:  Mastering Complex Queries

1. Video:  Mastering Complex Queries  (47 min)
2. Student Handout PDF: Mastering Complex Queries

Session Three Library Lessons

Lesson 1: Designing Complex Reporting & Macros

1. Video: Complex Reporting & Macros (60 min)
2. Student Handout PDF: Complex Reporting & Macros

Lesson 2: Excel Macros

1. Video: Excel Macros (6 min)