Prof 2 Instructions

Prof 2 Instructions - CJE 3663 Proficiency # 2 You are a...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 3

Prof 2 Instructions - CJE 3663 Proficiency # 2 You are a...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online