Data File and Data Dictionary
This assignment must be completed individually and should not be discussed with other students or on the Discussion Board.
For this assignment, you will be creating a Data File and Data Dictionary using Microsoft Excel.
Instructions and examples for how to create a Data File and Data Dictionary are located in the Module 2: Required Class Lecture Videos and in the Module 2: Key Concepts.
You must use Microsoft Excel to create the data file and data dictionary, and your file must be uploaded as a Microsoft Excel document.
You must use all of the variables and data in the completed data forms provided in these instructions to create your Data File and Data Dictionary.
The completed data forms to be used for this assignment are located at the following link. You can download this file by clicking on the arrow to the right of the file name:
When creating your Data Dictionary, you can decide how, when, and where the variables were measured by using online resources, textbooks, and other references. For example, if you want to describe how height should be measured, you could do an internet search on terms such as ‘how to measure height’ or ‘best way to measure height in adults.’
Rubric for grading
Document is uploaded in a viewable format as a Microsoft Excel spreadsheet and all of the data provided in the assignment instructions is included in this document.
File and Data Dictionary on separate pages in the same Excel document.
Variables are located in columns and cases are located in rows.
Only one numeric variable per cell. Numbers only. There should be no words, letters, or symbols except a decimal point when appropriate.
Variable names are clear, meaningful, and memorable.
Variable label must include detailed information describing the name and type of equipment/instrument used to obtain the measurement.
Variable label must include detailed information describing the procedures used to obtain the measurement, including manufacturer instructions and other guidelines for obtaining the measurement.
Variable label must include detailed information describing the specific time/date/event when the measurement was obtained.
Variable label must include detailed information describing the units of measurement when applicable.
Level of measurement is identified correctly.
Categorical variables are coded correctly and include a code for each category.
Document is centered and formatted appropriately including use of spacing, white space, gridlines, capitalization, spelling, and grammar.
Turn it in score must be low