Google Forms – Jake Miller

Formatting Improvements in Google Forms!

Google Forms has looked pretty much the same for a long time. But, they won’t look quite the same now because Google has rolled out a handful of updates to Forms!

📺 Check this out in video form on TikTok, Instagram Reels, or YouTube Shorts. 📺

First, you can now adjust the fonts and font sizes of any part of your form. You can use any of your Google Docs fonts. They do limit your font sizes – Big Brother Google doesn’t want us making our fonts too big or too small – but at least we can change them. And, you can make them different in the header, sub-header, and body text. ⬇️

I imagine Google cringing about the possible graphic design laws that you’ll all be breaking with your Google Forms, so try to keep it looking nice, all right? I think that’s why Google held off on this and the next update for such a long time – they wanted to make sure the Forms looked pretty in terms of Graphic design principles . . . but now they’re giving us some freedom.

The other part of this freedom is letting us use some basic formatting within the text. We can now make our text bold, italicized, or underlined and we can even add clickable links! We used to have to add what are called naked links, which is not inappropriate, I promise, it means you’re including the full URL for a link. Now, you can make a hyperlink.

To recap, we now have fonts, font sizes, bold, italics, underline, and hyperlinks, plus we can also make lists—numbered or bulleted—in descriptions. Nice!

These features are for all Google accounts and should already be active for you!📺 Check this out in video form on TikTok, Instagram Reels, or YouTube Shorts. 📺

[Image Source: https://workspaceupdates.googleblog.com/2022/06/new-font-options-google-forms.html] Continue reading Formatting Improvements in Google Forms!

16+ Formative Assessment Tools for #RemoteLearning!

Wow. March 2020 has been quite a month. And buckle up, folks, because it looks like April is going to be more of the same.

For many educators, that means screencasts of lessons, assignments in learning management systems, and lots of time on Zoom or Google Meet.

But what about Formative Assessment? If we’re going to teach new content during these extended school closures caused by the coronavirus and COVID-19 (I’m not sure if we should, but that’s another post) then we need to know if students are comprehending that new content!

So, I put that question out to the Duct Tapers (listeners to my podcast, the Educational Duct Tape Podcast). I got a handful of answers, which I featured in Episode 39b of the podcast.

A week later, I reached out for even more ideas! On Wednesday 3.25.2020, I hosted a #EduDuctTape Twitter chat focused on this and 2 other #RemoteLearning concepts. So, based on the thoughts shared in the episode and the ideas shared in the Twitter chat, I’ve got a BUNCH to share with you! So let’s dig into it! Continue reading 16+ Formative Assessment Tools for #RemoteLearning!

#EduDuctTape Episode 38!

In the 16th episode of Season 2, I am joined by Joe & Kristin Merrill, 1st & 4th grade educators & authors of The InterACTIVE Class, to talk about making our classrooms and our students’ learning experiences InterACTIVE. We discuss Apple Clips, Buncee, Seesaw, BookCreator & Flipgrid. Also, a game of edtech BFF!

See the Show Notes Here

“Interactive Learning is learning that is responsive and relevant, that engages students.” — Graphic created by Matt Meyer @54Mr_Meyer

Video by David Allan (@_david_allan)

#EduDuctTape Episode 37!

In the 15th episode of Season 2, I am joined by Andreas Johansson to talk about things that we can do to support less tech-savvy staff members, especially non-teaching staff. Tools discussed include Google Forms, Sheets & Sites; the FormMule, AutoCrat & FormRanger Add-Ons; the VLookUp, Concatenate & Substitute Google Formulas; Lean Thinking and more!

See the Show Notes Here

BONUS CONTENT: This audio was not included in the regular podcast episode, but is available here for listening:

Andreas Johansson: "I have the fortunate now to work with a lot of what's called classified staff, or as I think of it, the other 50% of a school district. — GIF created by David Allan.

Video created by David Allan.

15+ Tools for Student Voice

In episode 28 of the Educational Duct Tape Podcast, Mike Mohammad joined me for a chit-chat. One of the topics that we discussed was student voice. I posed the question, “How can educators provide opportunities for student voice?”

Mike promptly made the distinction between student voice and student choice. While both are powerful things to leverage in the classroom, they are very different (though we often lump them together, as Mike pointed out).

I think that educators’ definitions for the term student voice are inconsistent – some seem to believe that it simply means
– hearing each student’s answer or thinking
– while others believe that it means empowering the students to have a voice in some (or all!) aspects of their education.

Mike made it clear in his response that he subscribes to the 2nd “definition” of student voice. His response fits with the description that Edutopia uses: student voice involves letting “students’ input and expertise … help shape their classroom, their school, and ultimately their own learning and growth.”

I definitely believe that that is the type of student voice that we want to strive for. In a recent #EduDuctTape chat, educators shared their favorite tool for empowering student voice. It’s important to note that simply using the tool doesn’t provide opportunity for or empowerment of student voice. It’s all about how you use it.

Here are some of their responses:

Continue reading 15+ Tools for Student Voice

Embedding Google Forms in Schoology

Schoology offers a quality platform for classroom assessments, but no platform for collecting information that isn’t intended to be an assessment. In that situation, Google Forms is a great option. However, using a link and forcing students to go “out” of Schoology can be inconvenient and lead to some internet-wandering. So, let’s embed the Google From right into Schoology! Forms can be embedded in pages as well as assignments.

This is beneficial in a number of other situations:

Schoology assessments can’t differentiate based on answers (i.e., seeing remedial content after getting a question wrong), but Forms can.
If the data coming from the questions is actually going to someone else (i.e., your school guidance counselor), you’d be able to share the Google Forms results easily with them.
If you’re looking to trigger some action (i.e., mail merge) with the responses, the Add-Ons offered in Google Sheets would work.
If you’re looking to use the functionality offered by Google Forms Add-Ons like FormRanger and FormLimiter.
If you need to use formulas or create data representations, Google Sheets are ideal.

Option 1: Add as an External Tool

This option requires the least steps, but has one major drawback – you can’t include any other text or images on the Schoology “page” – just the content from the form. (If you need to include other stuff, check out Option 2, below).

Check out the GIF below, followed by step-by-step instructions, to see how to do this:

Option 2: Embed the Form into a Page, Assignment or Discussion

This option is preferable if you’d like to add some text or other content on the same “screen” as the form.

Check out the GIF below, followed by step-by-step instructions, to see how to do this:

Create your Google Form.
Click the Send (paper airplane) button.
Select the <> Embed option.
Modify the dimensions, if you’d like. You can do that in Schoology later as well.
Click on the embed code.
Click Copy.
Go to your class Materials page in Schoology.
Click Add Materials.
Click Add Page (or whatever option you’re choosing).
Click the button on the right, above the text box, with the two dots. It’s the Switch to HTML View button. (If you’re in an Assignment, you may have to click a > button to get to the expanded view)
Paste the embed code.
Click Create and you’re done!
If you switch back to the Standard View, you can also enter other content (text, pictures, etc.) above or below the Google Form.

Pre-Filled Google Forms

Have a form that you fill out regularly? Create a pre-filled form link that is partially filled in for you.

Sending a form out to a certain group who will all have the same response to a certain question (i.e., grade level)? Create a pre-filled form link to save them a few moments.

Directions are underneath the GIF

Here’s how:

Click the 3 dots in the top right corner.
Select “Get Pre-Filled Link.”
Enter the answers you’d like to pre fill.
Click Submit.
Copy the link. All done!

Differentiation in Google Forms

Google Forms are great for collecting information and delivering assessments, but did you know Forms had some differentiation swag?

Yup, it’s true. Use “Go to Section Based on Answer” with a Multiple Choice question to have right answers and wrong answers lead to different sections. A general mockup of what this could look like, and steps for creating it, are below the GIF.

Steps:

Add a question with a correct answer and (at least one) wrong answer.
Add a section after that question.
Put your remedial content in that section. YouTube videos work well. You could even make your own video to put in there. You could also include a follow-up question to give your students a chance to re-assess.
Add a section after the remedial content.
Put your next content here. This is the section where students who got the correct answer will land. It will probably also be where you have students who completed the remedial step will land.
Go back to your initial question.
Select “Go to Section Based on Answer.”
Have the incorrect choice(s) go to the remedial section.
Have the correct choice(s) skip to the section after the remedial one.
Sit back and enjoy the differentiated learning experience!

General Layout:

Section 1: includes the question the differentiation is based on
Section 2: the remedial section – whatever content you want the students who got the previous question incorrect to see (video, explanation, follow-up question)
Section 3: the “next step” – the slide that the students with the correct answer jump to, also where the students with the incorrect answers land after completing the remedial section.

Note: you can add multiple levels of this in one Form, but it can get hard to manage. I once created a Form that went: Question 1, Remedial Video & Question 1a, Remedial Video & Question 1b, Question 2, Remedial Video & Question 2a, Remedial Video & Question 2b, etc. As you may guess, I had to create a complex flowchart to make sure I had everything jumping to the correct places.

FormRanger Add-On

I love me some Add-Ons. One of my favorites is FormRanger from New Visions Cloud Lab. It can be used to pull in a column of information from a Google Sheet as multiple choice or dropdown options.

This is nice for quickly creating a lot of options for a multiple choice or dropdown question, but what takes it from nice to awesome is . . . you can set it to automatically update based on changes made to the spreadsheet. Whaaaaat!? I know, right?

There are two main cases for use: Continue reading FormRanger Add-On

Password Protected Google Forms

First off – I can’t take credit for this idea – just the GIF below. I’ve heard it mentioned most recently on the Google Teacher Tribe podcast where the idea was credited to Jeremy Badiner.

Second – In a Twitter discussion with Molly MacKinlay from Google (I love Twitter!), she pointed out that there’s an easier way to do this. I still think that there are valid uses of the password-protecting strategy, but when appropriate, her way is certainly easier. I’ll get to this later in the post, right under the GIF…

There are a lot of uses to password-protecting Forms, but here are the 4 main ones that I can see:

Post a Google Form (i.e., an assessment) to your LMS early, but students won’t be able to access the questions until you give them the password or until they complete a preliminary activity that releases the password to them.
Set this form as part of a BreakOutEDU style activity – participants can only access the form once they’ve found the password in the previous stage.
Make it so only your intended audience can fill out a form. (i.e., 1st period class, but not 2nd period class)
Keep sensitive information within the form, just like a password-protected website.

One important note: setting “error text” is essential – otherwise it will tell the user the password.

The other way of doing this:

In my aforementioned conversation with Molly, a product manager with Google For Education, she reminded me of the ability to turn off “Accepting Responses.” If you want all of your students to have access to this Form at the same time, this is definitely the preferred way to go about it. Leave it off until the quiz starts, then turn it on, then turn it off when the quiz ends. Easy-Peasy. The exceptions start with anytime that you want differentiated access: i.e., students can’t start a quiz until completing a certain activity, only students from a certain class should be able to access a form, etc. And they continue with specialized applications of Google Forms: Digital BreakOuts and more. So, choose based on your need. If you’re just keeping a form closed until test time, use the “accepting responses button.” If you’re differentiating access in some way, use password-protecting.

More Notes

Ah, the power of the Twitter PLN. Both of the following notes came to me through discussions with people on Twitter.

@HaleEdTech pointed out that the user (i.e., student) can discover the password using Inspect Element or View Page Source (both are in the right-click menu). If you intend to use this regularly, you may want to 1) turn off Inspect element in the Google Admin Console and 2) block “view-source” in the URL blacklist in your Admin Console. These will only prevent this in Chrome – there are likely other steps you’d need to take with Safari or Firefox.
@EfrenR shared with me that people should refrain from using the word “password” in this situation, as Google Forms directly states that they’ll “never ask for your password.” He reported that they may even flag your Form for requesting user’s passwords. So, it may be wise to use something like “keyphrase” or “Form Code” instead.