Toolkits and Trainings:
Epidemiological Tools and Topics:
Best Practices Resources:
How to Use This Site:
Data by Topic allows users to run a customized search. After choosing a topic, you may refine your search by selecting one or more counties or regions. After selecting location(s), you can further refine your search using the tool bar at the top. Depending on the topic, you may choose one or more years and choose demographic options (grade, gender, age, race/ethnicity, and sexual orientation). You also have the option of displaying the data by either Number or Percent (or Rate).
To get started, simply click on a topic: alcohol, tobacco, or other drugs, shared risk and protective factors, or mental health.
Use Data by Topic to access maps, charts and trends!
Once you’ve chosen a topic, use the upper left corner of the toolbar to display the data by Map, Bar or Trend:
- Map will provide a color-coded map of Minnesota counties, sorted by quartile for the chosen indicator. Twenty-five percent (one-fourth) of counties will be colored dark blue—these counties have the highest reported consumption or consequence rates for the chosen indicator. The lightest blue counties have the lowest rates.
- Bar will display data for the chosen indicator as a bar graph, as compared to the state average. The Minnesota state average serves as the axis. Counties with higher rates will show a bar to the right; counties with lower rates will show a bar to the left. If you customize your search to look at data for 11th grade males, for example, the axis will adjust to reflect the state average for 11th grade males only.
- Trend will display data as a line graph, over the chosen time period. Users may select up to 7 counties or 7 regions to display on one trend graph. The trend feature will be disabled if there are not more than two data points.
Data by Location allows users to view multiple indicators (or topics) for one specific county or region. Once you choose a location, you will be presented with population statistics from the U.S. Census. Use the tool bar at the top of the page to select one or more topics. Once you choose a topic, Alcohol Consequences for example, you will be presented with all indicators related to that topic. To avoid having to scroll through all indicators, use the Data by Topic feature to search for a specific indicator.
Regions are defined by the Minnesota Department of Human Services' seven Alcohol, Tobacco, and Other Drug Prevention Regions. By clicking on State, you will automatically be transferred to Minnesota’s population statistics.
Data by Demographic allows users to view multiple indicators (or topics) for one specific demographic (Grade, Gender, Race/Ethnicity, Age, Sexual Orientation). Once you choose a demographic you will be presented with state and regional population and indicator data for that specific demographic. All of the available data is displayed at first, but you have the option to select however many indicators you would like to view.
Not all demographics have data for all indicators. Further, race/ethnicity is often only available by region, and sexual orientation is only available at the state-level.
**For all three types of searches, when data are displayed by percent, the denominator used is dependent on the demographic chosen. If for a chosen indicator, the value displayed for 9th grade males is 5%, that represents 5% of all 9th grade males for the given location and year. It does not represent 5% of all students for the given location and year. For example, if the indicator is Youth Alcohol Use, then 5% of all 9th grade males who answered that particular Minnesota Student Survey question (for that location and year) reported that they had consumed alcohol in the past 30 days.
Data Sources: A link to the respective data source will appear below each table unless you use the tool bar to “hide” this information. A fuller description of the data source can be found by scrolling down to the bottom of the page. Detailed data source descriptions are also available in the Toolbox.
Population Statistics: To find statistics on population size by race and by age, population density, household income and individuals living below the poverty line, use the Data by Location feature. Once you choose a location, population statistics from the most recent U.S. Census and American Community Survey will be presented.
Tools and Resources: Use the navigation bar at the very top of each page to view Community Resources, Publications, the Toolbox, or the Gallery.
- Lists of Community Resources are provided at the state-, region-, and county-level. You may scroll down, or click on a region link at the top of the page to jump to the resources for that region. Under each region, counties are listed alphabetically.
- Publications are arranged by topic, location, and demographic. Use the tabs at the top to jump directly to a specific section. Some suggested sites for further reading can be found in multiple sections. For example, a report on tobacco use among youth would be listed under Topic: Tobacco and under Demographic: Youth. The page includes links to reports, fact sheets, websites, and more.
- The Toolbox contains materials on navigating and using the SUMN site, interpreting data, reading tables and graphs, calculating rates, understanding time trends, differentiating between cause and correlation, and between percent difference and percent change. Training and technical assistance materials are available related to identifying and prioritizing intervening variables.
- The Gallery includes examples of data products created using substance use and mental health data. Examples of reports, fact sheets, issue briefs, posters, PSAs, presentations, videos and more can be viewed. Visit the Gallery to see how you can submit your own community's data products created using SUMN data!
[back to top]
Toolkits and Trainings
SUMN Toolkit: Warming Up to SUMN Data
These documents are a combined toolkit for getting the most out of www.sumn.org -- Minnesota's one-stop-shop for local ATOD data. You can either click here [24mb] for the entire SUMN toolkit or click on the following for each of the individual components of the SUMN toolkit. Within the SUMN Toolkit there are three main components that are the framework of the toolkit; Find Data, Analyze and Interpret Data, and Share Data. Within these are the components that can be downloaded individually listed below.
Find Data: Finding and Using Existing Data
[back to top]
Analyze and Interpret Data: What do the Data Say?
[back to top]
Share Data: Presenting Data
[back to top]
Epidemiological Tools and Topics
Intervening variables are factors that have been identified as being strongly related to, and influential in, the occurrence and magnitude of substance use problems and consequences. Risk and protective factors are types of intervening variables. Risk factors are individual characteristics and environmental influences associated with an increased vulnerability to the initiation, continuation, or escalation of substance use. Protective factors include individual resilience and other circumstances that are associated with a reduction in the likelihood of substance use (Hawkins & Catalano, 1992).
For each intervening variable listed below, there are a set of local conditions. Local conditions describe why something is or is not a problem--this is how the intervening variable manifests itself at the local level. For example, social access/availability is an intervening variable while a related local condition might be alcohol availability at community celebrations. Local conditions can be monitored and measured using specific indicators. For the example provided, one specific indicator might be lack of wrist bands for persons under age 21 at community events where alcohol is sold.
Click on an intervening variable to open a PDF chart listed local conditions for that variable, indicators for each local condition, and potential data sources.
Retail Access/Availability: Extent to which alcohol is available for purchase in your community, and how easy it is to purchase
Social Access/Availability: Extent to which alcohol can be obtained from friends, associates, family members, or other adults
Enforcement: Existence, enforcement, and perception of community, school, worksite, and household policies and laws
Promotion/Pricing: Monetary costs of alcohol, extent to which alcohol is promoted, and exposure to promotion
Community Norms: Extent to which alcohol use is accepted, or perceived to be accepted
Individual Factors: Individuals' behaviors, perceptions, beliefs and knowledge
For more information, view the Program Sharing 2011 session presentation Identifying and Selecting Intervening Variables for Prevention Planning.
This document outlines three tools: Plan, Do, Check, Act; the Substance Abuse and Mental Health Services Administration's Strategic Prevention Framework (SPF); and the Centers for Disease Control and Prevention's Evaluation Framework.
Download the PDF [110kb]
This glossary of epidemiological terms was distributed to participants of the 2007 Epi Profile Fall Forums.
Download the PDF [64kb]
Creating Graphs Using Excel
This brief tutorial walks you through the steps of creating a graph using Microsoft Excel, using examples from Substance Use in MN (SUMN).
Download the PDF [890 kb]
Data Use Tip Sheet
Download the PDF
Download the PDF
Causation vs. Correlation
Download the PDF
Download the PDF
[back to top]
Wilder Research's evaluATOD website offers a number of self-paced online courses. E-learning module topics include: data collection, data translation, data presentation, evaluation 101, evidence-based practices, and shared risk and protective factors.
SAMHSA's Collaborative for the Application of Prevention Technologies offers several on-line courses addressing substance abuse prevention.
The University of Minnesota School of Public Health offers online training through the Midwest Center for Life-Long Learning. Their training consists of modules related to core public health concepts.
[back to top]
Best Practices Resources
This toolkit was developed with the latest research, for Minnesota college and university campuses, to prevent marijuana use among students. The toolkit is available in PDF format, as individual topic sheets and as one combined document.
- Child Trends' LINKS database of programs evaluated for "outcomes related to education, life skills, and social/emotional, mental, physical, behavioral, or reproductive health."
assess child or youth outcomes related to education, life skills, and
social/emotional, mental, physical, behavioral, or reproductive health -
See more at:
- SAMHSA's National Registry of Evidence-Based Programs and Practices (NREPP) http://www.nrepp.samhsa.gov/
- CDC's The Community Guide http://www.thecommunityguide.org/
- Office of Juvenile Justice and Delinquency Prevention (OJJDP) Model Programs Guide http://www.ojjdp.gov/mpg/
- Robert Wood Johnson Foundations and University of Wisconsin Population Health Institute's What Works for Health http://www.countyhealthrankings.org/roadmaps/what-works-for-health
- University of Colorado Boulder's Center for the Study and Prevention of Violence Blueprints for Healthy Youth Development http://www.colorado.edu/cspv/blueprints
- University of Minnesota Alcohol Epidemiology Program tools and publications http://www.aep.umn.edu/#
Tutorials can help you utilize the various data visualization tools available to communities, which can be used to develop products to present data in compelling and easily-understandable formats.
If you've found data relevant to your community, and you'd like to share this information with stakeholders, there are a number of free and fee-based data visualization tools that can help take your message to the people. The following tools have been used by other substance abuse prevention specialists, and many share examples of past prevention and health promotion projects on their sites.
- CommunityCommons.org is a free site that will help communities create maps, using either publicly-available data, or (for a fee), the communities' own data. The site also provides guidance and templates for developing community health needs assessments. Their gallery provides glimpses of a wide variety of existing projects.
- InstantAtlas.com can help create dashboards with interactive mapping software that uses GIS (geographical information system) data. InstantAtlas also provides YouTube instructional videos at https://www.youtube.com/user/instantatlas
- Create data visualization products with these web-based platforms:
- Canva.com Platform with free fonts and images to build infographics
- Emaze.com Provides templates for presentations
- Highcharts.com Creates charts and maps for use in presentations, websites, or on social media
- Piktochart.com Provides templates and themes for infographics
- Venngage.com Provides templates for infographics
- Visme.co Create presentations, infographics, and animations