The Before and After - Analyzing Pre and Post Surveys in Excel

Pre and Post

This interactive training session explores the power of Excel to analyze meaningful prevention program outcomes with pre- and post-test surveys.  

Excel is a practical and accessible tool for prevention professionals who may be analyzing survey data to demonstrate program outcomes, especially for prevention professionals who may not have access to expensive software packages. Participants will be guided through real-life examples of applying a step-by-step process using Excel to examine pre- and post-test results and interpret significant outcomes. 

Select the View Resource button above to watch the recording. Below is the PowerPoint and handout for this webinar.



Nicole Schoenborn brings 20 years of award-winning public health experience to the South Southwest Prevention Technology and Transfer Center (SSW PTTC). She currently oversees all evaluation reporting and analysis and manages the evaluation database for the SSW PTTC. She plays a vital role in providing high-impact training and technical assistance (T/TA) services to the prevention workforce, emerging prevention professionals, organizations, and community prevention stakeholders.

Ms. Schoenborn develops innovative program evaluation so that state and community-level prevention practitioners can achieve successful outcomesWith a specific focus on addressing health disparities, she works with states and tribes to develop processes and programs that achieve long-term public health impact. Specifically, she collaborates with subject matter experts to guide states and tribes in the design of effective logic models, methods, and evaluation plans. Nicole works to create supportive and responsive research environments that interconnect services for historically underserved populations and reduce adverse public health outcomes.

Ms. Schoenborn holds multiple certifications, namely, she is an Internationally Certified Prevention Specialist and an Adverse Childhood Experiences (ACE) Interface Certified Instructor. She received her master’s degree in experimental psychology and bachelor’s degree in psychology from the University of Central Oklahoma.

Copyright © 2024 Prevention Technology Transfer Center (PTTC) Network