develop surveys and collect data with google forms · 4/29/2020 · culturally and age...
TRANSCRIPT
Develop Surveys and Collect Data with Google Forms
Webinar Presenter: Russell A. Sabella, Ph.D.Florida Gulf Coast UniversityWebinar Date: April 29, 2020
Russell A. Sabella, PhDSchoolCounselor.comGuardingKids.com@rsabella#SchoolCounseling
Learning outcomes:
• Identify four ways to collect data.
• Develop a survey using Google Forms.
• Collect and aggregate data collected in the survey.
Four Parts
•Designing
•Access
•Tracking
•Announcing
https://www.schoolcounselor.org/school-counselors/asca-national-model/purchase-the-books
Existing Data
• Demographics
• Attendance
• Enrollment Patterns
• Discipline
• Test Scores
• Tardies
• Grades
• GPA
NON-Existing Data
• Needs Assessment
• Some Mindsets & Behaviors
Four Sources of Data
• Export existing data from your SIS
• Type it in yourself
• Copy and Paste
• Google Forms
Basic Calculations
• Raw Data
• Percent (proportion)
• Percent Change
• Pre to Post Change
Basic Calculations - ExamplesCalculation Example
Raw Data • Number of parents attending orientation.• Discipline referrals• Course enrollment
Percent • Graduation rates• Test Scores• Attendance
Percent Change • Students applying to college• Students graduating
Averages Take any of the above and calculate averages.
Pre to Post Change Take any of the above and calculate difference between now and before ☺
Basics for Designing Forms
• Length: The shorter, the better.
• Readability: On average, around 6th grade level. Avoid acronyms and slang.
• Culturally and Age Appropriate: Avoid inappropriate wording and insufficient attention to cultural nuances.
• Face Validity: Your form has a clear purpose of what is needed to know and understand.
Designing Forms• Unidirectional Items
– The response for every item (e.g., a higher number or True versus False answer) is equally desirable.
NON-Example
– True or False
• I am confident about making friends.
• Making friends scares me.
Designing Forms
• Concrete questions are best.
– “Are you happy with the school counseling program so far?”
–Better: “The school counseling program has
positively impacted my students’ attendance.”
Designing FormsMutual Exclusivity
A given respondent or item should not fit into more than one category
• Example: Are you a) Single; b) Married; c) Divorced; d) Widowed; e) Separated, or f) Living in a couple relationship but not married– In this example, with enough
time, someone could answer “All of the above”
Designing Forms
Avoid Double Negatives
Do you agree that cyberbullying is not uncommon?
Designing Forms
• Equally Distributed Categories:
– Never
– Somewhat
– Often
– Always
• Non-equallyDistributed Categories:
– Never
– Rarely
– Always
Designing Forms• Avoid double-
barreled questions– Would you say that the
decision to increase Sabella’s salary by 67% will be a boon to FGCU or don’t you care?
• You could think it would be a boon but not care.
B-LS 5. Apply media and technology skills
Applymediaskills.
Apply technology
skills.
B-LS 7. Identify long- and short-term academic, career and
social/emotional goals.
Short Term Long Term
Academic
Career
Social/Emotional
Survey items …
Identify the M/B most relevant to the goal.
Write a sentence based on the goal.
Convert the statement to a survey
item
Basic Item Stems …
Attitude/Belief I believe …
Knowledge I know … I understand …
Skill I can …
Likert Scales
• Agreement
• Frequency
• Importance
• Quality
• Likelihood
Source: https://www.simplypsychology.org/likert-scale.html
Source: https://www.questionpro.com/blog/likert-scale-examples/
Likert scale level of agreement emoji
http://dissertationrecipes.com/wp-content/uploads/2011/04/Expert-Validation-v3.pdf
Resources
https://schoolcounselor.com/autoctg/
Resources
http://www.ezanalyze.com/
Beta version:http://bit.ly/ezabeta
Resources
https://www.schoolcounselor.org/school-counselors/asca-national-model/purchase-the-books
