In Class Assignment 1 and 2

In Class Assignment 1 and 2 - In Class Assignment 1 and 2...

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: 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

Page1 / 3

In Class Assignment 1 and 2 - In Class Assignment 1 and 2...

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