topic- obesity in racial disparity 

Input the data using the resource available down. The purpose of this activity is for you to practice creating your own dataset in preparation for the Community Health Data Profile assignment. 

https://www.cdc.gov/nchs/data/databriefs/db360_tables-508.pdf?fbclid=IwAR1BPkChmSj6SfGLaD8vfvr1zypaASSaCtCqKGzBMJqQi6UaasNw3x41_Sc#page=1

Data Table (1) – Required

Variable1 Variable2 Number

Description – Required

Data Source(s):
Next to Source 1, fill in the reference to the data you used to create your data tables. If there is more than one source, use the blank(s) next to Sources 1 and 2 for the next references.
Source 1: (required)
Source 2: (optional)
Source 3: (optional)
Charts Planned:
Provide a description of the charts planned. Be sure to include which variables. There must be at least three charts. If you do not have enough data for three charts, find additional data sources and add to the Data Table 2 and Data Table 3 tabs.
Chart 1: (required)
Chart 2: (required)
Chart 3: (required)

Data Table (2)

Variable1 Variable2 Number

Data Table (3)

Variable1 Variable2 Number

Information adapted from CDCynergy “Lite” by the Centers for Disease Control and Prevention.

Message Outline Guidelines

Overall Directions

This outline serves as the plan for your website. Make sure your responses are about your website and within your
control right now. Your website will be an intervention for a particular health topic. Here is an example description
that encompasses the goal of a website, along with the target audience, and objective:

The website will provide healthy ingredients for pregnant women and mothers of young children who
want to make good choices and establish well-balanced diets for their children. These ingredients will be
provided along with information on childhood obesity, what puts people at risk of becoming obese, and its
negative consequences along with how to affordably feed the whole family nutrient-rich foods. The site
will also provide common replacements for foods that are nutrient-poor or high in sugar or calories (e.g.,
Greek yogurt as replacement for sour cream).

Keep this description in mind when completing the sections below. More information, with coordinated examples,
will be provided in the sections below. Be sure to add references to the section along with citations within the text,
according to APA style.

You will use this plan when you develop the website. So, try to make plans that you can accomplish and use
references that you can paraphrase on your website. Avoid directly quoting, and write in your own words, using a
citation at the end of the sentence.

Problem Description

What is the problem? The health problem is the gap between an acceptable or desirable health status and the
current status. The problem description will help you keep the main goal of your social marketing effort in mind.
The problem description clarifies what the public health problem is, who is affected, and what you propose to do
to address it. To write your problem description, briefly answer these questions: (1) What should be occurring
compared with what is occurring? (2) What are the causes? (3) Who is affected and to what degree? and (4) What
could happen if the problem isn’t addressed? Use health status indicators to answer these questions. Health status
indicators are data on outcomes or their causes (e.g., smoking rates). Health status indicator data is made available
by numerous organizations. See this list of organizations or refer to other sources.

Consider the causes (genetic or biological factors, psychological factors, behaviors, factors in the physical
environment (e.g., a lack of transportation), and factors in the social environment (e.g., social support, or policy).
Are these direct or indirect causes and which are the primary factors? Also, tease out which of these can change as
a result of programmatic action? (e.g., a social marketing program can’t eliminate genetic risk

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)

PAGE

Message Outline

Problem Description

Market Strategy

Target Audience:

Objectives:

Potential Obstacles:

Key promise:

Support Statements:

Other Considerations

Tone:

Creative Considerations: