By Lisa N. Arsenault, PhD and Stefanie Albert, MPH
Individual
school districts across the country have recognized the utility and power this
type of data provides and many choose to implement local-level versions of the
YRBS (or other similar type of student health survey). Most districts hire external contractors or
organizations to conduct the data cleaning and analyses of their local data. Many
districts also use external contractors to generate summary reports, tables,
and charts. But even with external help it
can be overwhelming to decide how best to examine the results.
Here is a simple table of results that shows the rate of one risk behavior among all students over three different years. In this format it is easy to see and report if the rate of the behavior is increasing or decreasing over time. In our example, the rate of marijuana use in the prior 30 days has declined from nearly 27% in 2012 to about 19% in 2016.
You can also visualize this data in a very simple bar chart, as shown below. You can opt to add some text boxes that highlight extra information that might be important for your audience to understand about the data such as the state rate, total number of students surveyed, etc.
In this
example, we added the approximate number of students the current year’s rate
represents. We find this is often
helpful when trend data show a decrease over time because it’s easy to forget
you are talking about actual students in your school. So highlighting how many students are still
at risk is a good way to balance the ‘big picture’ with the real personal value
of the data.
Here is a
second table of results that shows the rate of one risk behavior over three
different years and stratified by grade level. In this format it is easy to see
and report if the rate of the behavior is increasing or decreasing for each sub-group. In our example, the rate of marijuana use in
the prior 30 days has steadily declined between 2012 and 2016 for 9th
and 12th grade students. But
the rate has increased since 2012 among 11th graders and it has
increased since 2014 for 10th grade students. Had we stopped exploring our data after
looking at the overall trend, we would have missed this very important finding!
Visualizing the
trends by sub-group can really help you ‘see’ the differences, particularly when
many years of data make reading summary tables full of numbers more difficult.
In our example below, the dramatic drop in 30-Day marijuana use among 9th
graders is very clear. Likewise, you can
easily see the steady decline in use among 12th graders. And the less encouraging results for the 10th
and 11th grade students are shown in a more understandable way that
can foster discussion with stakeholders or audiences.
*********************