worksheet dataset

Author: Peace Ossom-Williamson Last Updated: August 17, 2018

How to Complete the Data Worksheet This guide provides two examples for filling in the Data Worksheet. The examples provided here will

be about diabetes rates. It is highly recommended to read through both examples before you begin.

Example 1: This example will be adding data for a chart comparing the rate of adults diagnosed with diabetes over

recent years and a chart comparing the rate of male and female adults diagnosed with diabetes over the

years.

1. Open the Data Worksheet file using the link in Blackboard.

2. Go to the Data Table (1) - Required tab at the bottom of the worksheet.

3. Replace the column headings (variable and number) with your variable names and numbers.

In this case, the CDC provides rate per 1,000 adults with diabetes by sex for years 1997-2016.

Therefore, we will use that to replace our data headings.

Author: Peace Ossom-Williamson Last Updated: August 17, 2018

4. Add in the data from your data source. (See data source example below)

In this case, we are only going to add the names of the groups under Sex and the estimated

rates of adults newly diagnosed with diabetes for 2011-2016 (circled in red above). We will use

“Total” to represent the total for that year not broken down by sex. Please ignore the standard

error and lower and upper confidence intervals (CI) provided beside each rate. We just want the

estimate.

Author: Peace Ossom-Williamson Last Updated: August 17, 2018

5. Now that the data table is complete, go to the Description – Required tab at the bottom of the

spreadsheet.

6. Fill in the empty cell next to Source 1: (required) with the reference for the data source.

7. Then add in a statement on the charts you plan to make with that data.

Example 2: This example will be adding data for a chart comparing the percentage of Texas adults with diabetes in

2013 by race/ethnicity.

1. Open the Data Worksheet file using the link in Blackboard.

Author: Peace Ossom-Williamson Last Updated: August 17, 2018

2. Go to the Data Table (2) tab at the bottom of the worksheet.

3. Replace the column headings (variable and number) with your variable names and numbers.

In this case, the TX DSHS provides percentages of adults with diabetes by race for the year 2013.

Therefore, we will use that to replace our data headings.

Author: Peace Ossom-Williamson Last Updated: August 17, 2018

4. Add in the data from your data source. (See data source example below)

In this case, we are only going to add the names of the groups under Race/Ethnicity and the

percentage of adults who reported they have diabetes (circled in red above). Please ignore the

95% confidence intervals (CI) ranges provided beside each percent.

Author: Peace Ossom-Williamson Last Updated: August 17, 2018

5. Now that the data table is complete, go to the Description – Required tab at the bottom of the

spreadsheet.

6. Fill in the empty cell next to Source 2: (optional) with the reference for the data source.

7. Then add in a statement on the chart you plan to make with that data.