The purpose is for you to find a secondary data set, create variables, and enter the data in excel. Upon completion of this assignment, you should be able to find and download free, public, secondary

Data Discovery & Collection

Assignment

Due 09/26/2021

100 Points

In chapter 1, we discussed the different types of secondary data available for download. This assignment is part 1 of a series of assignments you will build on throughout the semester. The purpose is for you to find a secondary data set, create variables, and enter the data in excel. Upon completion of this assignment, you should be able to find and download free, public, secondary data sets from readily available government agencies, as well as successfully create an excel file, which includes a data dictionary.

Instructions

1. Choose a health topic, disease, or trend that you want to find more information about. Note that this data and topic will be used throughout the semester for other assignments

2. Use one of the websites covered in chapter 1 to find your data or any website you would like. Data is everywhere so if you find it, use it.

   1. CDC

   2. FDA/USDA

   3. Census

   4. Baltimore City Health Department

   5. Maryland Department of Health

   6. Any website you find interesting

3. Enter your data in excel

   1. You need a minimum of sample of 50 to complete this assignment

   2. Example: if you choose cancer, you will need at least 50 cases of cancer

4. Create a data dictionary on the second sheet of your excel file

   1. A data dictionary defines the variables in your data set

5. You must include these variables in your data set. Feel free to add any other variables you want to add to your data set. This information may be useful to you

   1. Gender

      1. Female

      2. Male

      3. other

   2. Ethnicity

   3. Age

   4. Employment

   5. Education

   6. State

   7. County

6. For each variable, have the following

   1. Number (count)

   2. Percent

   3. Rate (if applicable)