This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: In Class Assignment 1 and 2 Name _________________________ Import the data from the class website Pegasus.cc.ucf.edu/~rwatkins. Select the data for Assignment 1 and 2. The following spreadsheet is one month worth of burglary data from the Osceola County Sheriff's Office. Please carefully examine the spreadsheet, namely the nature of the data and perform the following steps. Importing, Cleaning, and Previewing the Data 1) Title your original data sheet ORIGINAL and color the tab orange. 2) Copy your original data to a new worksheet and use this as your working data. Title this sheet BURGCLEAN and color the tab light orange. Bold all column headings on your BURGCLEAN worksheet. 3) Insert a new worksheet and title it DOCMT (for documentation). Color this tab blue. a. Clean all data. b. Look for improper dates, times, columns with improper data possibly from your importing procedure. c. Make sure each respective field/column has the proper information located in the proper cells. d. Make sure there are no spelling errors. e. Check for duplicate records. Document what you find and how you choose to handle them. f. Be sure note all problems and how you corrected these problems (formulas, functions, manual manipulation techniques……). This should be the last sheet in your workbook and build it as you go. 4) What kind of data is represented in this workbook? ____________________________________ 5) How many worksheets are in the workbook? ____________________________________ 6) How many columns are in the workbook?6) How many columns are in the workbook?...
View Full Document
- Spring '08
- Burglary, Osceola County