PART A

Case Study Questions:

What are the benefits of intelligence-driven prosecution for crime fighters and the general public?

What problems does this approach to crime fighting pose?

What management, organization, and technology issues should be considered when setting up information systems for intelligence-driven prosecution?

PART B

EXCEL

Use OCE 4 data. Using the values in Column B, find the first names in Column D and the last names in Column E. Using Column D and E values, fill Column F with full name using the concatenate function. Using the data available including the ID, find names and phone numbers for IDs: 0015, 0008, and 0010 using VLOOKIP.

ID Name Phone First Last Name Full Name Searched Answers 0001 Axel Foley (786) 786-4598 ID Name Phone 0002 Bilbo Baggins (212) 345-3567 0015 0003 Darth Vader (412) 546-0990 0008 0004 Forrest Gump (234) 345-5678 0010 0005 Han Solo (612) 435-8970 0006 Hannibal Lecter (324) 567-4567 0007 Harry Callahan (345) 456-9090 0008 Harry Potter (234) 456-8976 0009 Indiana Jones (574) 123-4567 0010 Jack Sparrow (901) 231-2341 0011 James Bond (674) 321-4567 0012 John McClane (723) 433-0879 0013 John Shaft (303) 458-00232 0014 Jules Winnfield (312) 456-8756 0015 Luke Skywalker (786) 456-7893 0016 Michael Corleone (213) 456-9089 0017 Randle McMurphy (786) 785-9032 0018 Red Redding (347) 456-8965 0019 Rick Blaine (890) 567-7654 0020 Rocky Balboa (123) 435-6783 0021 Roger Martaugh (286) 675-0900 0022 Tony Montana (216) 4578-9023