CLEANING DATA

Every journey begins with a single step. Before you can become a master researcher providing thoughtful information analysis and meaningful conclusions, you must prepare your workspace and clean your tools. Without the crucial steps of organizing the data, preparing your software for analysis, and sharpening your quantitative skills, your research question will not be answered.

For this Discussion, you will learn how to prepare the information you have collected, removing corrupted or missing data in order to begin studying it. You will use the dataset provided to practice identifying challenges that arise during the cleaning process before presenting your findings to the class.

To Prepare:

Review and use the Cleaning and Management Example dataset and Cleaning and Management Example Dataset Codebook as you review the Cleaning Data Sets Job Aid found in the Learning Resources.

Access the Cleaning and Management Practice dataset in the Learning Resources to complete the Cleaning and Management Quiz (Note: Allow 30 minutes to complete).

Complete the Cleaning and Management Quiz by Day 3. Note: This quiz is not assessed, but it must be completed prior to your posting to this Discussion.

Reflect on the cleaning process when completing the Cleaning and Management Quiz. Post an explanation of the challenges you might encounter in your experience through the cleaning process and how you might remedy those challenges. Then, explain why it is important to clean and manage data, and why this would be important to generalizability, confidence in accuracy of the results, or psychometric properties.
Required Readings

Document: Cleaning and Management Example Dataset Download Cleaning and Management Example Dataset(Excel worksheet)
Note: Use this dataset when reviewing the Cleaning Datasets Job Aid.

Document: Cleaning and Management Example Dataset Codebook Download Cleaning and Management Example Dataset Codebook(Word document)
Document: Cleaning and Management Practice Dataset Download Cleaning and Management Practice Dataset(Excel worksheet)
Note: Use this dataset to answer Cleaning and Management Quiz (interactive quiz) questions used to practice identifying missing data or data errors in a dataset.

Document: Cleaning Datasets Job Aid Download Cleaning Datasets Job Aid(PDF)
Document: Final Project Overview Download Final Project Overview (PDF)

Document: Final Project Worksheet Download Final Project Worksheet(Word document)
Document: Quantitative Legitimation Model Download Quantitative Legitimation Model(Word document)
Note: The Quantitative Legitimation Model is a companion document to the Internal Validity and External Validity PowerPoint located in this week’s Learning Resources and should be referenced while viewing the PowerPoint.