JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

1 of 7

Google Forms, Sheets, and Autocrat:

Giving you the power to collect and share information

Herb Coleman, Ph.D.

Adj. Professor of Psychology and Student Development

https://bit.ly/autocratws

SLIDESMANIA.COM

2 of 7

Workshop

Google Forms

The connected Sheet

Autocrat for creating documents to share the information.

First, a poll https://bit.ly/autocratws2

SLIDESMANIA.COM

3 of 7

Google Forms - My Uses

Class Introduction

Exit Ticket, Post Quiz Analysis

Individual Decisions,

Vocab, Quizzes, Mini App Exercise,

Peer Ratings,

Clubhouse (extra credit write up),

Polls and surveys

SLIDESMANIA.COM

4 of 7

Google Sheets

Generated by Form

Spreadsheet just like MS Excel

Contains responses, email, and time stamp

Quizzes can auto grade

Manipulate data

Can add additional sheets

Where you install the add-on

SLIDESMANIA.COM

5 of 7

Autocrat

Sheets Add-on

Works with Docs or Slides

Use tags for place markers <<placeholder>>

Can make single document or separate documents

Documents can be presented, shared through a link, or emailed

SLIDESMANIA.COM

6 of 7

Autocrat

Install Add-on

Decide what data you want to present or share

Decide kind of document you want to share

Decide how you want to share (document or email)

Create template using <<placeholder>>

Run autocrat set up

Run Autocrat

Demo

SLIDESMANIA.COM

7 of 7

Google Forms, Sheets, and Autocrat

https://bit.ly/autocratws2

hcoleman@austincc.edu

SLIDESMANIA.COM