4 of 40

But, What are Those Programs?

Google Forms is a tool that is part of Google Drive for creating surveys, tests, or web input forms. Google forms allows anyone to create an easy to use web form, tie it to a spreadsheet

where you can track

results and post it on

the web without

having to know

programming.1

Super Quiz:

Super quiz is a DYNAMITE add-on that grades student work in real time while analyzing patterns of learning from individuals, groups of students, topics and also allows

for remedial

questions to

be assigned

and sent

to students.2

Clemson Computing & Information Technology. Google Forms; 2016.
Johnston, Gary. Super Quiz- The Ultimate Add-On for Functionality; 2015

5 of 40

Part 1:

Create a

Google Form

6 of 40

Creating a New Form

Log into your Google Drive
Under New, click more and then select Google Form

7 of 40

How do I use Google Forms?

Feel free to check out another tutorial I created for Google Forms.

Or check out the videos below. It also depends upon if you are using the Original or the New Google Forms. Here are intro videos for both...

Original

New

8 of 40

What you MUST include in your Form

Your first question should be “Student First & Last Name” and use a Short Answer.
Second question should be for your class/period/teacher (and I would recommend using a Multiple Choice or Dropdown question)
Types of questions you use: short answers, multiple choice, drop down, and/or time/date questions.
In the settings for your form, be sure to check “Automatically collect user’s email account”

9 of 40

Suggestions for using Forms for a Quiz/Test...

Keep it short at first- make it a simple 1 section test with 10 to 20 questions.
If you DO NOT want students to skip a question or leave it blank, fill in the “required” check.
Only create sections if you have different types of questions (section 1: multiple choice; section 2- True/False)
Are students able to take it over again or is it one-and-done? (Settings- Can only submit 1 response)
Create your test, take the test (for master), update your evaluation rubric and setup your feedback tab BEFORE you have students take the quiz.

10 of 40

Part 2:

Complete your

Own Form

(Create the key)

11 of 40

Take your Test

Two ways to access your live form to complete your test:

Click the Preview button to view the live form that will receive your answers.

In the Send section, copy the form’s URL and paste it in the address bar of your web browser.

12 of 40

Tips While Completing...

The Test you are taking is the same test your students will take

- Great time to ProofRead Everything!

When entering your name:

- Use your name or use “Test Answers”
- USE Caps to have it stand out

Don’t forget to click Submit at the end of your quiz/test or it will not record your answers.

13 of 40

Part 3:

View Answers

on your

Spreadsheet

14 of 40

How Do you See your Responses?

Original Forms

Look for the View Responses Tab on the top of your page.

New Forms

In the Responses section, click the View Responses in Sheets.

If it is your first time viewing, I would reccomend you will be prompted to Make a New Spreadsheet for responses.

- This will automatically create a sheet in your Google Drive.

15 of 40

Spreadsheet Response Screen

Columns

(letters) will hold all responses for that one question.

Row 1

is your test labels/ questions asked.

Rows 2+ (numbers) will hold all the responses from an individual student.

16 of 40

Tips for Viewing your Responses

You can rearrange columns by clicking & dragging the Letter Label (and this will not affect the online form).

Select entire columns, and then choose Text wrapping & resize column widths

If you need to delete a response, be sure to right click on row label and select Delete Row #

17 of 40

Part 4:

Using Super Quiz for Grading & Feedback

18 of 40

Installing Super Quiz

In your Spreadsheet Response Form, click the Add-Ons tab and click Get add-ons.
In the Google Web Store search “Super Quiz”
Click the “Free” button to install and then Accept/Allow installation.

Or click the image for a shortcut!

19 of 40

Running Super Quiz

Super Quiz will then run you through steps to begin the programming process

Once installed, Under Add-Ons, choose Get Started.

20 of 40

Setup Checklist

Form Name
Row 2 is your answer key
Columns must be in this order

A- Timestamp
B- Username
C- Student Name
D-Teacher/ Class

Remember you can move and rearrange order of columns…
When ready, click...

21 of 40

Now We’re Cooking

Now you will have a bunch of tabs/sheets now on the bottom of your spreadsheet

Don’t forget to use the arrows to see all tabs!

Next, we will customize your quiz/test results by setting up your feedback rubric & auto response test feedback.

- Click the Auto Feedback Configurator

22 of 40

Auto Feedback Configurator

Take the time to complete all these sections because it will appear on the email results your students receive.

Simply follow along with the instruction table that is color coded to help complete your feedback.

23 of 40

Topics & Number of Questions

Add your Quiz Title
If you have only 1 section on your quiz, add the description in Topic 1

(ex: Multiple Choice, True False). the other topics can be listed as blank

You may need to adjust the amount of questions in your quiz/test

The grey sections should auto configure for you

24 of 40

Specific Feedback & Example Questions

If students do not receive 100% in a section, you can prompt them where they can find the correct answers. Examples:

Review your notes on the Area of a Circle.
Re-read Chapter 2 in The Giver.
Refer to my website on Internet Safety and re-watch the posted YouTube videos.

You can also give example questions that will help them study and better prepare:

A=_?_ r2
The Plot are events of a story is make up the main idea.
What does https stand for?

25 of 40

Grade Percentages & Adjectives

Customize the ranges for letter grades related to this specific quiz/test.

You can also add whatever adjectives you would like to describe the ranges of performance.

26 of 40

Additional Options

You can even customize:

How your feedback form begins
Display their name or email
And the sentences that begin the the topic feed

27 of 40

”WOAH,

Now we're going to set up our document an email configuration!”

Click the Document & Email Configuration tab on the bottom.

28 of 40

Setting up Your Parameters

Let’s start by clicking

The program will work it’s magic and let you know when it is complete. Now when your students complete a quiz/test, they will automatically receive an

email with their results AND detailed feedback!

Then you will have the choice to include answers or exclude answers in your students’ feedback documents (that’s a nice option, don’t ya think?)

29 of 40

Here’s What it Looks Like:

The Google doc will appear in the student's’ email inboxes. (Remember- automatically collected)

Page 1

Page 2

30 of 40

Super Quiz Setup Tips

To access the menu for anything, simply click on Add-ons -> Super Quiz
If one of your tabs is not working at all, you could always re-run the program to add news ones

(delete original, rename new)

Also, Super Quiz will create a folder in your Google Drive for each form you create; you can then move to organize.

31 of 40

Part 5:

Sending Form for Students

to Take

32 of 40

Sending your Quiz/Test

Now that you have created your quiz/test, you will need to share it with your students.

Open your Google Form in your Drive
In your Form, Click the Send button

33 of 40

You Have Options: Email

You can send the test via email to your students.

Pro- convenient if you need to send to a few because they were absent.
Con- time consuming for large groups, especially if you don’t have an email group for your classes.

In the Send section, choose email and complete the necessary info

You can also include the test in the email itself

34 of 40

You Have Options: Hyperlink

2. You can copy the hyperlink and

post it on your class website or

Google Classroom. Be sure to

copy the form hyperlink.

Google Sites How-To Video

Google Classroom How-To Video

35 of 40

You Have Options: Embedding & Social Media

3. You can also embed your form

in your website if you would like the actual active form displayed within your website.

(Here’s a How-To Video)

4. Or if you wanted to send your

form through your school social media account, you can.

(You're so hip & with-it )

36 of 40

Part 6:

Final Thoughts

37 of 40

Other Resources

As you explore the program, you find there are tons of other options you can work with. Just- take your time and try stuff out incrementally, and find works best for YOU!

Other Resources:

Google Doc Cheat Sheet to get your quiz up and running
The Super Quiz Official Help Website
Another Point of View: How to Use Super Quiz 1 video

38 of 40

Thanks for Your Time!

I hope this tutorial helped and you are able to apply any of it to your classroom. If you need any help or assistance with ANYTHING, please feel free to contact me.

jshuler@eastamwell.org | @Shulology

Thank You

Jason

39 of 40

Works Cited

"80S GIF - Find & Share on GIPHY." GIPHY. N.p., n.d. Web. 20 Feb. 2016.

"Are You Done Yet?" Memecrunch. N.p., n.d. Web. 21 Feb. 2016.

Baker, Lindsay. "How to Use Super Quiz 1." YouTube. YouTube, 12 Nov. 2014. Web. 21 Feb. 2016.

Eames, Justin. "Creating a Basic Google Form." YouTube. YouTube, 17 Feb. 2016. Web. 17 Feb. 2016.

<https://www.youtube.com/watch?v=iQGm_6ULwVc>.

"#FallonTonight- Thank You." GIPHY. N.p., n.d. Web. 21 Feb. 2016.

"File:"WE'RE LOOKING FOR SUGGESTIONS. WRITE ONE TODAY" - NARA - 516108.jpg." Wikimedia Commons.

N.p., n.d. Web. 17 Feb. 2016.

<https://commons.wikimedia.org/wiki/File:%22WE%27RE_LOOKING_FOR_SUGGESTIONS._WRITE_ONE_TODAY%22_-_NARA_-_516108.jpg>.

"Google Forms." Clemson University: Computing & Information Technology. N.p., n.d. Web. 18 Feb. 2016.

<http://www.clemson.edu/ccit/learning_tech/ccit_training/google_apps/google_forms/>.

Guildway. "The New Google Forms [Nov 2015]." YouTube. YouTube, 20 Nov. 2015. Web. 17 Feb. 2016.

<https://www.youtube.com/watch?v=GZ7EJ8Kp0Po>.

"Hey Girl, You Can Rock Those Standardized Tests |..." Memegenerator.net. N.p., n.d. Web. 17 Feb. 2016.

<http://memegenerator.net/instance/45727360>.

Johnston, Gary. "Super Quiz- The Ultimate Add-On for Functionality." YouTube. YouTube, 15 Sept. 2014. Web. 18 Feb.

2016. <https://www.youtube.com/watch?v=x7wQp7Yq_8c>.

"Jon Bon Jovi." Starcrush. N.p., n.d. Web. 20 Feb. 2016.

"Make a Google Form? I'm on It! | Success Kid." Memegenerator.net. N.p., n.d. Web. 17 Feb. 2016.

<http://memegenerator.net/instance/63229183>.

cont, next slide →

40 of 40

Works Cited, cont.

"Make Me Social." Make Me Social. N.p., 9 Feb. 2012. Web. 18 Feb. 2016.

<http://makemesocial.net/2012/02/09/goooaaal-why-your-social-media-marketing-strategy-should-be-more-like-soc

cer/>.

"Meme Generator - Create Your Own Meme." Meme-generator.com. N.p., n.d. Web. 21 Feb. 2016.

"Meme Maker - The Internet's Meme Maker! Make Memes Today and Share Them with Friends!" Meme Maker. N.p.,

n.d. Web. 18 Feb. 2016. <http://www.mememaker.net/meme/good-answer-good-answer07/>.

"Mr Trussell Auto Feedback." Mr Trussell Auto Feedback. N.p., n.d. Web. 21 Feb. 2016.

Nicholson, Tonya. "Everything Awesome Sauce." Pinterest. N.p., 2012. Web. 20 Feb. 2016.

"Resources Resources Everywhere | Buzz Lightyear M..." Memegenerator.net. N.p., n.d. Web. 21 Feb. 2016.

"Such a Drag... (WonderWoman, Batman & Superman)." N.p., n.d. Web. 18 Feb. 2016.

<https://s-media-cache-ak0.pinimg.com/originals/7e/bf/ab/7ebfab7b55581b541449cef8fa0a21fa.jpg>.

Supahmommy. "Today's Menu: I Am Just Awesome." Supahmommy. N.p., 19 Apr. 2010. Web. 21 Feb. 2016.

"Test GIF - Find & Share on GIPHY." GIPHY. N.p., n.d. Web. 17 Feb. 2016.

<http://giphy.com/gifs/test-notes-80PaMTF5Gv8JO>.

The Gooru. "Embed a Google Form on a Google Site." YouTube. YouTube, 7 Feb. 2014. Web. 21 Feb. 2016.