This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: CJE 3663 Proficiency # 2 You are a crime analyst for the Orange County Sheriffs office. You are requested to perform the following tasks. Access the final data set (OC Raw Data) and perform the tasks below. When done email your proficiency to me and title it Last Name Prof3. ** Write your (1) name, (2) and computer number on this answer sheet. _______________________________________________ ** Save the original data file in your newly opened workbook and then create a working file and be sure to save your work over the course of the proficiency (we all know the reason for this). Section I: File Recognition (1 pt) 1. What is the file type? _____________________________________________________ Section II: File Conversion & Data Acquisition (4 pt) 1. Import the raw data file into Excel. Save it as OCSO_Data in an excel format. 2. Describe the native file format. What data format did Orange County Sheriff's Office provide you with? _____________________________________________________________________________________________ Section III: Data Reconciliation and Analysis (70 pt) 1. Once you have the data imported and the excel table designed properly, the data must be cleaned to conform to the following...
View Full Document
- Spring '11