An Easily Accessible, Semi-Automated Approach to Creating Personalized Normative Feedback and Risk Feedback Graphics

Jack T Waddell; Scott E King; William R Corbin; Teresa A Treat; Katie Witkiewitz; Richard J Viken

doi:10.15288/jsad.24-00003

Back

Journal article

Peer reviewed

An Easily Accessible, Semi-Automated Approach to Creating Personalized Normative Feedback and Risk Feedback Graphics

Jack T Waddell, Scott E King, William R Corbin, Teresa A Treat, Katie Witkiewitz and Richard J Viken

Journal of studies on alcohol and drugs, Vol.86(2), pp.177-185

03/2025

DOI: 10.15288/jsad.24-00003

PMCID: PMC11980400

PMID: 39589790

Files and links (1)

url

https://pmc.ncbi.nlm.nih.gov/articles/PMC11980400/View

Open Access

Abstract

Personalized normative feedback interventions show efficacy in reducing health risk behaviors (e.g., alcohol use, sexual aggression). However, complex personalized normative feedback interventions may require manual methods of inputting participant data into graphics, which introduces error, and automated approaches require substantial technical costs and funding and may limit the types of feedback that can be provided. To make personalized normative feedback more accessible, we outline a method of using easily accessible software programs including IBM Statistical Package for the Social Sciences (SPSS), Microsoft Excel, and Microsoft PowerPoint, to create and display complex personalized normative feedback graphics. We also describe methods through which personalized normative feedback graphics can be created within a larger preventive intervention for alcohol and sexual assault in college men. We first provide step-by-step instructions for collecting data and then creating semi-automated syntax files within SPSS and Excel to merge participant data into complex personalized normative feedback graphics in Excel. To do so, we append annotated syntax in text and in supplemental material. Next, we outline the process of creating risk feedback graphics, whereby individual items or exact wording of items are displayed back to the participant. Finally, we provide guidance regarding the process of translating graphics from Excel for viewing via PowerPoint without having to manually update PowerPoint slides for each presentation. Via the described syntax and graphic generation, researchers are then able to create semi-automated personalized normative feedback and risk feedback graphics. This tutorial may help in increasing the dissemination of complex personalized normative feedback interventions.

Alcohol

Risky Sex

Personalized Normative Feedback

Sexual Assault

Brief Interventions

Details

Title: Subtitle: An Easily Accessible, Semi-Automated Approach to Creating Personalized Normative Feedback and Risk Feedback Graphics
Creators: Jack T Waddell - Arizona State University
Scott E King - Arizona State University
William R Corbin - Arizona State University
Teresa A Treat - University of Iowa
Katie Witkiewitz - University of New Mexico
Richard J Viken - Indiana University Bloomington
Resource Type: Journal article
Publication Details: Journal of studies on alcohol and drugs, Vol.86(2), pp.177-185
DOI: 10.15288/jsad.24-00003
PMID: 39589790
PMCID: PMC11980400
NLM abbreviation: J Stud Alcohol Drugs
ISSN: 1937-1888
eISSN: 1938-4114
Publisher: ALCOHOL RES DOCUMENTATION INC CENT ALCOHOL STUD RUTGERS UNIV
Grant note: National Institute on Alcohol Abuse Alcoholism Grant: AA027714
This study was supported by National Institute on Alcohol Abuse Alcoholism Grant AA027714 to William R. Corbin and Teresa A. Treat. authors report no conflicts of interest.
Language: English
Electronic publication date: 11/26/2024
Date published: 03/2025
Academic Unit: Psychological and Brain Sciences
Record Identifier: 9984752655902771

Metrics

18 Record Views

2 Times Cited - Web of Science