1 of 46

edtechteam.com

​

2 of 46

3 of 46

John (Jay) Salerno

Director of Educational Technology | Newington (CT) Public Schools

\||EdTechTEam

@jaysal7

Presentations Landing Page:

www.bit.ly/jaysalerno

4 of 46

Googlify Your Digital Classroom-- Navigating the Features in Google Forms for Digital Learning

#edtechteam

5 of 46

Google Forms is a tremendously powerful and effective tool that when utilized correctly with Distance Learning can transform the learning experience for all. The focus of this session will be how to not only how to create forms to collect data and create formative assessment tools, but also how to analyze the data. In addition, many of the Forms add-ons in order to enhance the experience will also be demonstrated.

@jaysal7

Session Description

6 of 46

Ways to Use Google Forms

  • Creating assessments for students (Integrate with Google Classroom).
  • Building easy-to-use rubrics that can be shared with students.
  • Collecting web-based assignments.
  • Soliciting feedback from parents or students.
  • Choose your own adventure or differentiation.

*Article from EdTech Magazine

5 Time Saving Google Forms Tips

​

​

@jaysal7

7 of 46

Titles

@jaysal7

The two “untitled form” headings are not connected to each other.

This title will only be visible to you and is what the form will appear as in your list of documents. You can change the title by clicking on the words “untitled form”

This title will be visible to anyone filling out the form. You can change the title by clicking on the words “untitled form”

8 of 46

Layout and Settings

Change color and theme

Preview form

Email, hyperlink, or embed your form for others to complete

Form settings: these used to be headers and footers with options such as requiring log in and adding a custom message - now they’re all in one spot

Clicking on the three-dots will reveal menu at right

@jaysal7

9 of 46

Color and Theme

Clicking here will bring up the color palette so you can change the background color

Clicking here will bring up a window where you can select a theme or create your own

@jaysal7

10 of 46

Choose from a list of themes, or create your own by clicking on “Upload photos”

@jaysal7

11 of 46

Formatting Questions

Click to change question type (i.e. short answer, paragraph, checkboxes, etc.)

Duplicate Question

Click on the two lines to drag/ re-order question(s)

Delete Question

Options: hint text, go to page based on answer, shuffle question order

Add question

Add section title and description

Add image

Add video

Add section

@jaysal7

12 of 46

Adding Images

Click to add an image to either the question or answers

@jaysal7

13 of 46

Click here to view live responses with pie charts below

Click here to view responses in a Google Sheet (then you can run Flubaroo and other add-ons)

Click here when you no longer want to accept responses (it will turn red when you do)

Clicking on the three vertical dots will bring up response choices

14 of 46

Quizzes

@jaysal7

15 of 46

@jaysal7

16 of 46

@jaysal7

17 of 46

@jaysal7

18 of 46

@jaysal7

19 of 46

flubaroo

flubaroo website

flubaroo can:

  • easily grade online assessments (using Forms)
  • send emails to the submitters
  • help analyze data

@jaysal7

20 of 46

Quizzes vs. Flubaroo

Formatting Questions

*Courtesy of Eric Curts (http://www.controlaltachieve.com/)

@jaysal7

21 of 46

Let’s Explore and Create!

@jaysal7

22 of 46

Advanced Features & Add-ons

@jaysal7

23 of 46

*Horse Feathers (1932), Paramount Pictures

24 of 46

Restricting Access

Link

@jaysal7

25 of 46

Digital Breakouts

Utilizing Digital Breakouts to Promote Collaboration and Team Building | Resources

@jaysal7

26 of 46

Password Protection

@jaysal7

27 of 46

Designating Access

Example

ID is sal3045

Spreadsheet

@jaysal7

28 of 46

Creating the Expression

First Student =concatenate(Cell, “|”)

Second Student =concatenate(S1 Cell, S2 Cell, “|”)

Then Fill down

Copy and Paste into Forms

@jaysal7

29 of 46

Data Validation

  • Numbers
    • Greater/less than
  • Text
    • Contains
    • URL
    • Email Address

@jaysal7

30 of 46

What is an add-on?

Advanced Features & Add-ons

  • Add-ons add some extra oomph and make Google Apps more powerful

​

@jaysal7

31 of 46

Advanced Features & Add-ons

  • Choice Eliminator 2
  • Form Notifications
  • formLimiter
  • Form Values
  • g(Math) for Forms
  • EquatIO

@jaysal7

32 of 46

Advanced Features & Add-ons

Choice Eliminator website

It eliminates choices from a form with question types:

  • multiple choice
  • list
  • checkboxes

@jaysal7

33 of 46

Choice Eliminator

@jaysal7

34 of 46

Form Notifications

Form Notifications website

​

  • Form can be set up to email the submitter
  • Triggers on user hitting submit button
  • Can contain custom message in email
  • Can notify form owner, also

@jaysal7

35 of 46

Form Notifications

@jaysal7

36 of 46

formLimiter

formLimiter website

Forms can be shut down:

  • When a certain # of submissions occur
  • On a certain date (and/or time)
  • When a cell in the Sheet equals a set value

@jaysal7

37 of 46

formLimiter

@jaysal7

38 of 46

Form Values

Form Values website

Form Values creates a Sheet with Value Lists that can be added to Forms for multiple choice, list, and checkbox questions.

@jaysal7

39 of 46

Form Values

Form Values

@jaysal7

40 of 46

g(Math) for Forms

g(Math) for Forms website

Create graphs, statistical displays, multiple choice questions, and write complex math directly in your Form!

@jaysal7

41 of 46

Advanced Features & Add-ons

@jaysal7

EquatIO Easily create mathematical equations, formulas and quizzes. Intuitively type or handwrite, with no tricky math code to learn. (Introduction)

)

5 Ways to Use EquatIO

​

EquatIO Playlist

​

EquatIO Mathspace

​

LaTex Math

​

42 of 46

Sandbox Time!

Sandbox Time!

@jaysal7

43 of 46

Session Evaluation

44 of 46

@jaysal7

@edtechteam

#edtechteam

​

Learn More! Stay Connected!

edtechteam.com

45 of 46

Get

Certified!

​

Visit the Certification Website

@jaysal7

46 of 46