Student Survey on ATOD: Attitudes
DATA ENTRY Spreadsheet
Use these rows to enter survey data for respondents who have pretest data (light
blue section) and posttest data (dark blue section). Each row equals one survey
respondent.
Input your results by overtyping the sample information on row 15, then continue
entering data on each row from that point forward. Please note:
1. There is room in this spreadhseet for 500 respondents. If you have more than 500
respondents, add the needed rows into this spreadhsheet using the directions below.
2. Make sure the survey item data from your file are in the same order as the survey
items in this spreadhseet (e.g., Pretest Q1 is in Column "M"). A. Data Entry Spreadsh
3. To view auto-generated results/charts, click on the "Results" tab (below).
PRETEST DATA
If copying/pasting data from another Excel file (e.g., Zoomerang results), Student Code
make sure there are enough rows in the blue section prior to the copy/past 12367
procedure.
To add rows:
1. Move the cursor to the grey number column (at left).
2. Click the mouse on the number corresponding to row 16 (the second row) of the
blue-shaded data entry section.
Warning: Do not insert rows at the very top (row 15) of this data entry section - the
results will not tabulate properly.
3. Right-click the mouse to select "Insert."
4. Repeat steps 1 - 3 for each additional row needed.
NOTE: Once all survey data are entered in this DATA
ENTRY Sheet, click on the tab labeled "Results" (below)
to view the pre/post results generated automatically for
each item and across items.
Developed by Jim O'Neill, Ph.D., M
Education. For questions and com
A. Data Entry Spreadsheet
RETEST DATA
Date School Name Q1. or Try one day
Q3. Smoke Q4. twice Q5. Take Q6. Have five or more alcoholi
Q2. Try marijuana of cigarettes peror two drinks of an drinks of an alcoholic
Teacher NameSmoke one or more packs oncemarijuana regularly one or twoalcoholic beverage (b
Schultz
25-Apr-04 ABC Middle School 4 2 1 4 1 2
eveloped by Jim O'Neill, Ph.D., Madonna University (Livonia, MI), with funds allocated by the Michigan Office of Drug Control Policy, and the
ducation. For questions and comments, contact Dr. O'Neill (e-mail: joneill@madonna.edu).
POSTTEST DATA
Q8. Use inhalants (such as aerosol spray cans, glue, gases) occasionallySmoke Q2. get more
Q9. crack) Q10. occasionally heroin Gender
occasionally
Q11. Use Q12. occasionally
Q13. GradeQ1. in order to Try high
one or marijuana once or twice
Q7. Take cocaine (powder,Use steroids Use club drugs (such as Ecstasy, GHB, Rohypnol) occasionally packs of cigarettes pe
3 2 2 4 4 1 7 3 1
of Drug Control Policy, and the U.S. Department of
ST DATA
marijuana regularly one of an drinksTake cocaine (powder,Use steroids Use club drugs (such as gases) occasion
or Take Q6. Have five orof an alcoholic inhalants nearly as aerosol weekend heroin occasionally
Q7. more alcoholic drinks once oroccasionally spray
Q8. (beer, Q9. crack) Q10. eachQ11. Use
wine, (such every day
Q3. Smoke Q4. Try oneQ5.two drinks or twoalcoholic beverageUse beverageliquor) twiceoccasionally cans, glue, Ecstasy, GHB, R
1 3 1 4 4 4 4 2 2
were to grade this program, what grade would you kids your in this
Q16. What is the this useful thing you’ve learned
Q14. If you Q15. Would you recommend mostprogram to other give it? age? program?
3 1 It's fun!
SDFS Coordinator: Please complete the following: Page 51 of 52
Year:
District:
School(s):
Grade(s):
Table of Results
Once all survey data are entered in "Data Entry" sheet, use this section to review a table of pre/post results generated automatically
for each item and across items. To print the table(s) and chart(s), select "Print" from the "File" pull-down menu.
Pre/Post Results: % of Students with ATTITUDES Favoring ATOD Use (i.e, did not answer "great risk") Pre/Post
Perceive no/low risk (physically or in other ways) to others if they: Pretest Posttest change
Q1. Smoke one or more packs of cigarettes per day 0.0% 100.0% 100.0%
Q2. Try marijuana once or twice 100.0% 100.0% 0.0%
Q3. Smoke marijuana regularly 100.0% 100.0% 0.0%
Q4. Try one/two drinks of an alcoholic beverage (beer, wine, liquor) 0.0% 100.0% 100.0%
Q5. Take one or two drinks of an alcoholic beverage nearly every day 100.0% 100.0% 0.0%
Q6. Have five or more alcoholic drinks once or twice each weekend 100.0% 0.0% -100.0%
Q7. Take cocaine (powder, crack) occasionally 100.0% 0.0% -100.0%
Q8. Use inhalants occasionally in order to get high 100.0% 0.0% -100.0%
Q9. Use steroids occasionally 100.0% 0.0% -100.0%
Q10. Use club drugs (such as Ecstasy, GHB, Rohypnol) occasionally 0.0% 100.0% 100.0%
Q11. Use heroin occasionally 0.0% 100.0% 100.0%
AVERAGE (across items 1-11) 63.6% 63.6% 0.0%
* Items scored to reflect attitudes favoring ATOD use. Pre/Post sample size (n) = 1
Interpreting the Pre/Post Results. The "Pre-Post change" statistics (right column) represent the change in percentage points between the pretest and posttest results. Ideally, the
pre/post change should be negative because that reflects a decrease in pro-ATOD attitudes over the pre-post period; a postive value represents an increase in pro-ATOD attitudes. Compare the
Pre/Post Change labeled “AVERAGE” to your outcome performance goal/measure in your grant proposal to determine whether the performance goal was met. For example, if your goal was to
decrease pro-ATOD attitudes by 5 percentage points, your outcome performance goal/measure was met if the AVERAGE Pre/Post change value is at least (-)5 points. For guidance in addressing
results that did not meet a performance goal, refer to the ODCP Evaluation Toolkit section, "What if my evaluation results are negative?" (pp. 16-17) and/or consult your ODCP grant advisor.
Automated analysis and report developed by Jim O'Neill, Ph.D., Madonna University (Livonia, MI), with funds allocated by the Michigan Office of Drug Control Policy, and the U.S.
Department of Education. For questions and comments, contact Dr. O'Neill (e-mail: joneill@madonna.edu).
SDFS Coordinator: Please complete the following: Page 52 of 52
Year:
District:
School(s):
Grade(s):
Chart of Results
Once all survey data are entered in "Data Entry" sheet, use this section to review a chart of the pre/post results generated automatically for each item and across items. To print the
table(s) and chart(s), select "Print" from the "File" pull-down menu.
Pre/Post Student Survey Results: Pretest
ATTITUDES TOWARD ATOD
Posttest
% who reported no/low risk*
0.0% 25.0% 50.0% 75.0% 100.0%
Q1. Smoke one or more packs of cigarettes per day 0.0%
100.0%
Q2. Try marijuana once or twice 100.0%
100.0%
Q3. Smoke marijuana regularly 100.0%
100.0%
Q4. Try one/two drinks of an alcoholic beverage (beer, 0.0%
wine, liquor) 100.0%
Q5. Take one or two drinks of an alcoholic beverage 100.0%
nearly every day 100.0%
Q6. Have five or more alcoholic drinks once or twice 100.0%
each weekend 0.0%
Q7. Take cocaine (powder, crack) occasionally 100.0%
0.0%
Q8. Use inhalants occasionally in order to get high 100.0%
0.0%
Q9. Use steroids occasionally 100.0%
0.0%
Q10. Use club drugs (such as Ecstasy, GHB, Rohypnol) 0.0%
occasionally 100.0%
Q11. Use heroin occasionally 0.0%
100.0%
AVERAGE (across items 1-11) 63.6%
63.6%
Items scored to reflect attitudes favoring ATOD use (i.e., did not answer "great risk").
Pre/Post
Pretest Posttest change
AVERAGE (across items 1-11) 63.6% 63.6% 0.0%
Pre/Post sample size (n) = 1
Interpreting the Pre/Post Results. Ideally, the posttest values (dark bars) should be smaller than the pretest values (light bars) for each item, because that reflects a
decrease in pro-ATOD attitudes over the pre-post period. Compare the AVERAGE Pre/Post change (below chart) to your outcome performance goal/measure in your grant proposal
to determine whether the performance goal was met. For example, if your goal was to decrease pro-ATOD attitudes by 5 percentage points, your outcome performance goal/measure
was met if the AVERAGE Pre/Post change value is at least (-)5 points. For guidance in addressing results that did not meet a performance goal, refer to the ODCP Evaluation Toolkit
section, "What if my evaluation results are negative?" (pp. 16-17) and/or consult your ODCP grant advisor.
Automated analysis and report developed by Jim O'Neill, Ph.D., Madonna University (Livonia, MI), with funds allocated by the Michigan Office of Drug Control Policy, and the U.S. Department of Education. For questions and comments, contact Dr.
O'Neill (e-mail: joneill@madonna.edu).