Professional Development

Presentations

Consultations

Web Development

Using Conditional Formatting in Google Sheets to Bring Your Google Forms Data to Life!

by Randy Fairfield, 10/27/17

The summary view in Google Forms is helpful in getting a view of how your whole class did on a forms assessment, and the individual view is nice to check on the specific results for individual results—but it really takes a spreadsheet view to see both whole class and individual results all at once. Getting a spreadsheet from your Google Forms results is quite simple!

Once you’re in the spreadsheet, using conditional formatting in Google Sheets can be a really helpful way to have that data jump out at you and can be useful in helping you guide instruction and differentiate for struggling students! Here’s a visual of some pre-assessment data that Caitlin Smith (@IcedTearex) collected from one of her classes as we went through a coaching cycle together. Pretty cool, huh?

So how does one go about applying conditional formats in Google Sheets? If you click on the area circled in the red below and select conditional formatting, the rest is pretty intuitive! You can set all kinds of formatting rules based on the content of the cells in the column. In the case pictured below, I chose to have the column fill with green when the content of cells in the column were equal to “3”. I could apply additional rules to have the cells fill with yellow when the content of cells was equal to “2” and red when equal to “1”.

With simple tips and tricks like these, you can begin using formative assessments in ways that truly drive your instruction and meet the needs of your students!

Facebooktwittergoogle_plusredditpinterestlinkedin

Selectively Sharing Google Forms Data

by Randy Fairfield, 10/3/17

Google Forms beautifully displays the results of a form that has been responded to! How do you selectively share the results with your intended audience?

One of the best uses of Forms is to pull up the summary of the responses and display them to the whole class once a formative assessment is completed. This can help the teacher make in-the-moment instructional decisions about where to take a lesson. Here’s where you click to pull that data up:

Another great use of Forms is to pull up the individual view and bring students back to discuss their results.

Getting the Google Form data on a Google Sheets spreadsheet can be incredibly useful as well! The image below shows how to make that happen. What’s nice about this spreadsheet is that you can take it and selectively share the data with your colleagues.

Finally, another nice view is the “view analytics” page, which can be be seen by performing the following URL switch:

Replace: https://docs.google.com/forms/d/1A4V4BJVrjKWHa5Y1LrvhIYEXDrJvrXoQ4udbhkC0LM4/
edit?usp=forms_home&ths=true

With: https://docs.google.com/forms/d/1A4V4BJVrjKWHa5Y1LrvhIYEXDrJvrXoQ4udbhkC0LM4/
viewanalytics

What’s is fantastic about this view is that you can then copy the chart that shows the results from each individual question and paste the chart into a Google Doc or a Google Slides presentation, which you can then selectively share with your students and/or colleagues.

Facebooktwittergoogle_plusredditpinterestlinkedin

Using Google Forms for Course Evaluations

by Randy Fairfield, 3/22/17

While your administrative evaluator might only be in your classroom a few times in a school year, your students are in your class every day and they know you are doing a great job! Rather than relying on a snapshot your evaluator saw of your classroom, why not let your students evaluate you? You can use the results of their feedback as a part of your ongoing evaluation conversation with your administrator, and—perhaps more importantly—the feedback you get from your students might also open your eyes about the way you are perceived in your classroom.

The student survey below is aligned with the majority of the criteria outlined with the CEL 5D+ Teacher Evaluation Rubric for the 2016-17 school year. Scroll to the bottom of this page if you are interested in having a copy of this form!

Click this link and you will be prompted to make a copy of the Google Form above: goo.gl/6rN6Vd

Even better, check out the “Share That Form” section of my website and you’ll have access to a number of different Google Forms that you are free to take a copy of for yourself.

Facebooktwittergoogle_plusredditpinterestlinkedin

How to Send out a Google Form with a Link, Edmodo, or Google Classroom

Share That Google Form

by Randy Fairfield, 9/19/16

One of the most common questions I get from teachers getting started with Google Forms is, “Okay, I made a great form… now how do I send it out again?” Here’s a brief tutorial on how to send that form out there in three different ways:


Facebooktwittergoogle_plusredditpinterestlinkedin

Make Copies of a Google Form for Everyone!

by Randy Fairfield, 9/8/16

As collaborators on a Google Form work together on something, there will often come a time where they need their own copy of the form. It’s easy enough to, at that point, have an individual collaborator right click on the file in Google Drive and select “make a copy.” However, what if I want to use a Google Form as a template and have each student have their own copy of form? Or what if I wanted to share the awesome form I made with the rest of the world without them having to request permission to access the file and gain editing access over my template?

At that point, the best practice would be to share a link that, when clicked, invites users to make their own copy. It’s better felt than tellt, so here’s a brief tutorial that explains how to go about creating such a link. An important thing to note: make sure that the form you are sharing is a template and does not have any sensitive data as the copy of the form that people get will include copies of the responses as well!

I’m big on having teachers collaborate and not work too hard on “recreating the wheel,” so if you have a Google Form you’d like to share or you want to take one that someone else has made, check out the “Share That Form” section of my website.

Facebooktwittergoogle_plusredditpinterestlinkedin

Compare and Contrast of Edmodo Quiz and Google Forms Quiz Features

by Randy Fairfield, 7/11/16

There are a lot of different options out there for quizzes, so which one is the best? Particularly if you’re using Edmodo and Google Apps, you will have to make decisions about whether or not to use an Edmodo Quiz or a Google Form. There’s actually some good reasons for doing both, and the video below explores the topic. Hope you find it helpful!

Link to Student Course Evaluation Aligned With TPEP Evaluation: https://goo.gl/COSpRF

Facebooktwittergoogle_plusredditpinterestlinkedin