Counselor Up!
  • Blog
  • About
  • Speaker
  • Author
    • Book Summary
    • Book Discussion Guide
  • Things I Love
  • TPT Store

Google Form School Climate Survey

11/29/2017

4 Comments

 
Picture
Have you ever administered a school-wide climate survey? This is beyond the counseling needs assessment and asks about the general climate of the school. In my first district, the county administered a survey to 4th graders biannually. It was a good way to see patterns of student attitudes towards school and was a useful tool for our leadership team. In my last district, we didn't have a tool administered by the district and the leadership team asked me to work on creating a school climate survey. I've included all the steps here so warning- this post is long!

Creating Survey Questions

To create the survey questions, I found several resources online and pulled questions that were relevant to my school. Some resources: WINSS, Colorado Safe Communities,  and Austin School Climate Survey (via Casel). I presented a list of questions to my leadership team and we made edits as needed. We planned to give the survey to all students 2nd-5th grade during their computer lab specials time. I would go into the computer lab for 2nd and 3rd grades to help the teacher administer the survey. The survey took about 15 minutes to administer to the whole class.

To make the survey kid-friendly we chose to go with multiple choice responses (after demographics). Our choices were: Yes!!!, Yes, No, No!!!! When introducing the survey, I explained the choices using the example of broccoli- some people love broccoli (yes!!!), some people think it's fine (yes), some people don't like it (no), and some hate it (no!!!). The kids really seemed to get the example and didn't have any trouble with the multiple choice options.

We did find that many kids did not know their demographic data, especially race. If they didn't know, I told them to choose "I don't know" and explained that you can't tell by looking at someone what their race or ethnicity is. 

Using Google Forms

Picture
Google forms is a fast and easy way to create a survey. Many free programs available have a limit to the number of responses you collect. With 400 2nd-5th graders, this wasn't an option for us. To create a form, go to google drive and click New and choose Google Forms under the More section. 
Picture
In the next screen, you'll be able to write a title and add your questions. It's very easy and user-friendly. You also have the option to change the theme. They  have many fun themes to make the survey inviting and friendly. To check how your survey looks, you can click "view live form."
Picture
When completed, you can click "Send Form" in the right hand corner and you will be given a link to use. I like to shorten the URL to make it easier to share. At my school, we put the link on the homepage of our school website. My computer teacher actually made a non-related picture a hyperlink so that students wouldn't randomly take the survey outside of our class. I wanted to make sure that kids were taking the survey multiple times. This worked really well for us. 

Collecting Data



One great thing about Google Forms is that it collects and calculates all the data for you! To find the data click "view responses," and you will be taken to a spreadsheet. This is great for sorting and looking for specific subgroups (gender, race, grade). What makes google forms awesome is the ability to summarize responses with one click. 
Picture
To see a beautiful summary that's easy to share with your staff, click Form then "Show summary of responses." This is what you'll see:
Picture
If you're interested in seeing a PDF of my school climate survey, I have included that below. (If you are on mobile, click here.)
How do you survey students in your building? What data do you use to make sure that students feel like school is a positive place to be?
Picture
Have you ever administered a school-wide climate survey? This is beyond the counseling needs assessment and asks about the general climate of the school. In my first district, the county administered a survey to 4th graders biannually.
This post was originally shared in April 2015 and updated November 2017.
4 Comments
Madeline
10/20/2015 06:15:53 am

Hi there! Your blog helped tremendously in creating a school climate survey for the Elementary school I am interning at. I am having difficulty discovering how to have the summary of responses page filtered. I would like to filter out specifics such as grade levels, gender, race, ect. I am able to view the filtered option on excel, however that does not translate over to the graphs. If this feature is not available on google drive, do you have any suggests for other programs to easily create graphs based on excel?

Thank you!

Reply
Rebecca Atkins link
10/20/2015 06:24:59 am

Hi Madeline, Excel makes graphs based on what data you select. Google some tutorials on youtube about creating graphs. Basically, you would sort for the criteria (ie grade level) and then highlight that one grade level to be included in the graph. Excel can do amazing things, but it does take practice! Good luck :)

Reply
Lauren
11/28/2017 04:08:08 pm

Can you please email me the pdf of the survey? The link is not working for me. Thanks!!

Reply
Rebecca Atkins
11/29/2017 09:34:45 am

Hi Lauren, I am not able to see your email address. I have updated the post so that you should be able to see the PDF.

Reply



Leave a Reply.

    Picture
    Picture
    Picture
    Picture
    Picture
    Picture

    Rebecca Atkins

    Welcome to my blog where I talk about all things school counselor and encourage others to Counselor Up!

     Subscribe in a reader

    This website uses marketing and tracking technologies. Opting out of this will opt you out of all cookies, except for those needed to run the website. Note that some products may not work as well without tracking cookies.

    Opt Out of Cookies
    Picture

    Interrupting Racism: Equity and Social Justice in School Counseling

    Links may be affiliate links. If you link and purchase, I may receive compensation at no additional cost to you. Thanks for your support of Counselor Up.

    Categories

    All
    ASCA National Model
    Behavior
    Counseling Career
    Equity
    Freebies
    Groups
    IMO
    Individual Counseling
    Just A Little Thing
    Lessons
    Office
    Organization
    Parent Book Club
    Parent Communication
    Professional Development
    #tbt
    Technology

    Archives

    July 2021
    June 2021
    August 2020
    June 2020
    May 2020
    November 2019
    October 2019
    September 2019
    August 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    June 2018
    April 2018
    March 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014