Register

/Register
Return to Training Schedule

Cell Phone Data and Mapping

Early (4 Months Left) $420.00 ENDS SEPTEMBER 17
Regular $450.00 ENDS NOVEMBER 17
Late $475.00 ENDS DECEMBER 17

Host: North Salt Lake City Police Department
Location: North Salt Lake City Police Department 10 E Center St North Salt Lake, UT 84054
Dates: December 17, 2018 - December 18, 2018
Times: 8:00am - 5:00pm
Fee: $420.00


Course Description
Instructor
Travel Information

Managing and Mapping Cell Phone Data for Case Management and Prosecution

Course Overview
The amount of data retrieved during a cell phone investigation can be staggering.  Call records and tower data generate hundreds of records in just a few days from a single phone, tens of thousands of records are not unusual.  Managing this data (and visually depicting it) showing criminality, and making it “make sense” to others is the purpose of this course.

The course covers methods to view, analyze and present cell phone (and related data sets) data generated from current investigations.  Through the use of specific case studies and prepared sample sets of data (generated from actual cases) students learn how to analyze and present data found in typical investigations.  Special data sets (non-cell phone) are also presented as potential sources for evidence.

By the end of the course, students will be confident in their ability to manage and present digital data sets (cell and others) as evidence in court and in special hearings.

This class is designed for law enforcement officers at any stage in their career.  Experience or training in cell phone investigations is not required.  Students will be receive samples of data for use in the classroom during hands-on sessions.  A laptop with Microsoft Excel, Word and PowerPoint (version 2003 or higher) is required.

Agenda

Day One

  1. Youv'e got the data now what?
  2. If/ Then Statements - Looking at the Data, Outside Call Lists, Who is calling who?, Distinct Call Lists For Use in V-Lookups
  3. V-Lookups - Getting the facts from the Data, Linking Numbers to People, Tower Locations, Human Readable, Intermediate Code
  4. Pivot Tables - Finding the important clues in the Data, Call Frequency, Tower Frequency, Sum of Calls, Sum of Minutes

 

 


Day Two

  1. Evidence Continuity - Making the Data Make Sense (to everybody)
  2. Color Coding - Adding SMS, Combining Data
  3. Mapping Call Data - Showing the relationship between the data, reality and location, Basic Google Earth KML Creation, KML Creator, Google Docs
  4. Gephi - Data Analysis, powerful, simple, and free, Importing Data, Manipulating Data, Combining Data
  5. PowerPoint - Presenting the results in a format everyone can see and believe, Presenting Cell Data in Court and Hearing, Screen Captures, Splash Screen, Linking to Outside Documents