1 of 67

Google Education Trainer

bit.ly/1to1Course

bit.ly/1to1web

2 of 67

Google Education Trainer

C

The conversation should pertain to the learning topics that we are covering. Please be mindful about others who are trying to learn.

H

If you need help, please raise your hand. There will be time when we are working in pairs/groups and I will be able to come around to assist. Please avoid any side conversations.

A

We will have both instructor and learner driven activities. During instructor-driven activities, it is imperative that we are mindful about others who may not be at the same level as everyone else.

M

Please excuse yourself at your leisure for bathroom, phone calls and other important matter.

P

Participation is greatly appreciated. Whether it’s an idea or concern, please shared as many others may have the same thoughts.

3 of 67

Google Education Trainer

Daily Routines

Goals

​

Morning Session: 8:30 - 11:00

  • I demo, you play
  • Some partner/group discussions

​

Lunch: 11:00 - 11:50

​

Afternoon Session: 12:00 - 2:30

  • I demo, you play
  • Some partner/group discussions
  • Daily Reflection***

​

​

​

​

***Required

​

  • Be able to apply the GAFE ecosystem in your classroom while maintaining sound pedagogy

​

  • Understand how the course and the tools being taught play a role in the classroom processes for both teachers and students

​

  • Give things a shot and don’t be afraid to fail

4 of 67

SUBSTITUTION

Technology acts as a direct tool substitute, with no functional change.

AUGMENTATION

Technology acts as a direct tool substitute, with functional improvement.

MODIFICATION

Tech allows for significant redesign.

REDEFINITION

Technology allows for the creation of new tasks, previously inconceivable.

5 of 67

Google Education Trainer

Access emails offline

​

  • Set-up:
    • settings>>offline>>install gmail offline
  • How to access:
    • open a new browser tab
    • click on the app icon (i[
    • select the BLUE gmail icon

Day 1

6 of 67

Google Education Trainer

Special Features

​

  • turn on shortcuts
    • settings>>General>>Keyboard shortcuts on
  • set up a forwarding address
    • settings>>Forwarding and POP/IMAP>>add a forwarding address
    • create a filter for certain email based on subject/from/etc to go to that address
  • add a sending account
    • settings>>Accounts>>add another email address you own

Day 1

7 of 67

Google Education Trainer

Special Features

​

  • create a calendar event from an email
    • open the email>>More>>create event

​

  • add attached documents to Google Drive
    • look for this icon

  • Set up Gmail Chat/Hangout

Day 1

8 of 67

Google Education Trainer

Labs

​

  • settings>>Labs>>turn on lab you want

​

    • Calendar Lab

​

    • Undo Send Lab

​

    • Canned Responses Lab

Day 1

9 of 67

Google Education Trainer

Creating Filters

​

  • settings>>Filters>>create a new filter

​

  • OR

​

  • open email>>dropdown arrow >>filter messages like this

Day 1

10 of 67

Google Education Trainer

Contacts & Tasks

​

  • Manage Contacts
    • creating groups
    • import/export contacts

​

  • Utilizing Tasks
    • create task
    • create a task list
    • adding an email to task
    • assign date to tasks

Day 1

11 of 67

Google Education Trainer

Activity

​

  • create a custom email filter and test it with a colleague
  • create a task list and assign deadlines
  • create a custom email group (from the class) and send an email to that group

Day 1

12 of 67

Google Education Trainer

Access your Tasks list

​

  • Go to calendar list>>select Tasks

Day 1

13 of 67

Google Education Trainer

Setting up a Custom View

​

  • settings>>General>>select a custom view

Day 1

14 of 67

Google Education Trainer

Create Event & add Invitees

​

  • click on Create OR click on the day itself
  • Name event, set time and date, add location, invite guests
  • quickAdd Feature

Name event

set date/time

Location of event

add guest(s)

Day 1

15 of 67

Google Education Trainer

Creating, sharing and adding calendars

​

  • Create a calendar
    • setttings>>Calendars>>Create new calendars
  • Sharing calendar
    • settings>>Calendars>>Shared:Edit Settings for specific calendar
  • Adding calendars
    • type email of coworker

​

Day 1

16 of 67

Google Education Trainer

Appointment Slots

​

  • create
    • must be in day or week view (preferably week view)
    • click on the time slot>>select ‘Appointment Slots’ at the top

​

  • embed link
    • must select an appointment slot and go to Edit Events to see the link

​

Day 1

17 of 67

Google Education Trainer

Activity

​

  • create a new calendar event and invite colleague
  • create a new calendar and share it with a colleague
  • create one appointment slot and share the link with a colleague

Day 1

18 of 67

Google Education Trainer

Creating a Google Group

​

  • Create
    • go to groups.google.com
    • click on create
    • Group Name
    • Select Group Type
    • Set up Permissions

Day 1

19 of 67

Google Education Trainer

Important Settings

​

  • Go to Group Settings (see picture)

​

    • Under Settings
      • Moderation
      • Enabling Categories

​

    • Under Permissions
      • Basic Permission

​

    • Under Information
      • General Information

Day 1

20 of 67

Google Education Trainer

Activity

​

  • create a group you can utilize for a class

​

  • go through settings that you find fitting for the group you are creating

Day 1

21 of 67

Google Education Trainer

Setting up your account

​

  • go to plus.google.com

​

  • fill out necessary information

Day 1

22 of 67

Google Education Trainer

Home

​

  • Wall
  • Posting
    • type of post
    • Circle-based posting

Day 1

23 of 67

Google Education Trainer

Profile

​

  • About
  • Posts
  • Photos
  • YouTube
  • +1s
  • Reviews

Day 1

24 of 67

Google Education Trainer

Other Important Features

​

  • Communities
    • Joining
    • Receiving Updates
  • Events

Day 1

25 of 67

Google Education Trainer

Activity

​

  • Add colleagues to custom circles
  • Find a community you are interested in and join. Also, set up the community so that you receive notifications.
  • Add me to one of your circle (plus.google.com/+michaelberago), then create a post that shares only with me

Day 1

26 of 67

Google Education Trainer

Google Hangout

  • Start a video Hangout
    • From Google+ or Gmail
  • Doc sharing feature
  • thematic conversation
  • Screen sharing
  • Connected Classrooms

​

​

Hangouts on Air

  • go to Youtube.com and sign in
  • click on “upload”
  • select “Broadcast”

Day 1

27 of 67

Google Education Trainer

Activity

​

  • break up into groups of 4 or 5
  • split the group: one group goes to the Media Center Classroom, the other stays in the Lab
  • Start a hangout and explore all of the features.

Day 1

28 of 67

Google Education Trainer

Review Challenges:

​

  • Without using your MOUSE, compose and send an email.
    • Hints:
      • What is the shortcut key for starting an email?
      • use the TAB button to move from one input box to the other
      • What are the shortcut keys to send the emai?
  • Create a filter for an email that has a subject “testing filter” I will send everyone an email at the end of the activity.
  • Create a calendar invite for a colleague or two.
  • Create a task with a due date

Day 2

29 of 67

Google Education Trainer

Enable offlline access

  • Go to your drive → drive.google.com

Step 1

Step 2

Day 2

30 of 67

Google Education Trainer

Uploading and Converting Files

Day 2

31 of 67

Google Education Trainer

Sharing 101

  • Document Visibility vs. Document Collaboration
  • Deleting Shared items

vs.

Day 2

32 of 67

Google Education Trainer

File

  • Make a copy

​

  • Move to Folder

​

  • See revision history

​

  • Download as

Insert

  • Images

​

  • Drawing

​

  • Equation

Day 2

33 of 67

Google Education Trainer

Comment feature

  • Suggest Edit Feature

​

Format

  • Clear Formatting (Ctrl+\)

Tools

  • Research

​

  • Translate

​

  • Preferences

Day 2

34 of 67

Google Education Trainer

Let’s write a book and publish it on the web

​

  • create headings for the Table of Contents
  • create a bookmark for the Table of Contents and use its link to return back to the top
  • publish it!

Day 2

35 of 67

Google Education Trainer

Activity

  • create a new document and title it “Philippines”
  • using the Research tool in the document, provide the following
    • image map of the Philippines
    • when the country was founded
    • absolute location(latitude,longitude)
    • its size in square miles (sq)

Day 2

36 of 67

Google Education Trainer

Add-ons (examples)

​

  • gMath

​

  • Kaizena

​

  • EasyBib

​

  • TextHelp Study Skills

Day 2

37 of 67

Google Education Trainer

Things to know

​

  • You can embed YouTube videos
  • You cannot insert audio, but you can link to it

​

​

Similarities to apps

  • share settings
  • research tool

Day 2

38 of 67

Google Education Trainer

Basics of creating a presentation

  • master template
  • add transitions
  • presenting

​

Other options

  • embed it on a website
  • provide it as an HTML view
  • publish it

​

Day 2

39 of 67

Google Education Trainer

Create an image with clickable links….

​

  • Add or create an image
  • use Polyline tool to surround images with shape
    • set the background and line to transparent
  • select shape and insert link (Ctrl+k)
  • embed it to a website and test the link

Day 2

40 of 67

Google Education Trainer

Edit

  • Paste Special
  • Find and Replace

​

View

  • Freeze Rows & Columns

​

Formatting

  • Numbers
  • Conditional Formatting
  • Clear Formatting

Tools

  • Notification Rules
  • Protect Sheet

Day 2

41 of 67

Google Education Trainer

Data

  • Named Ranges
  • Protect Sheets and Ranges
  • Filter
    • create filter views
      • share specific filter views
  • Pivot Tables
  • Validation

Day 2

42 of 67

Google Education Trainer

Activity

​

  • open this spreadsheet and make a COPY
  • with your copy
    • create a Pivot Table and explore its functionalities based on what was demonstrated
    • create a filter view for 2014
    • freeze the first row so that when you scroll, the headers are visible

Day 2

43 of 67

Google Education Trainer

Review Challenges:

  • Create a new Google Document and name it “Test Doc-Your Last Name”
    • Share the document to three people
      • one person should have edit rights
      • one person should have view only rights
      • one person should have comment only rights
  • Create a new Spreadsheet and name it “Test Sheet-Your Last Name”
    • Set the document visibility setting so that People at Fenton HS with the link can access it
      • set the access setting to edit
    • Create a second sheet in the spreadsheet and name it “Protected”
      • Protect the “Protected” sheet so that no one can edit any part of the sheet but you
      • They should be able to edit the first sheet
    • Now share your sheet with another person using the sheet URL--have them test that they can edit one sheet and not the other

Day 2

44 of 67

Google Education Trainer

Creating Forms

​

1

2

Live Form & Share

3

Summary of Responses

4

Day 3

45 of 67

Google Education Trainer

Example Forms

​

  • Practice Quiz
    • automatic grading with Flubaroo

  • Interactive Form
    • page-based forms

​

  • Renewing forms

Day 3

46 of 67

Google Education Trainer

​

​

  • Add a validated question

​

  • Create a multimedia form quiz using the new Google Sheet

​

  • Use multiple pages

​

  • Add a short answer question

​

  • automate grading with the new Flubaroo

Day 3

47 of 67

Google Education Trainer

Challenge!

​

  • Create a quiz with multiple pages that is set up for automatic grading.

Day 3

48 of 67

Google Education Trainer

  • go to https://teacherdashboard.appspot.com/fenton100.org
  • use your Google Account if it doesn’t automatically sign you in
  • select one of your classes

Day 3

49 of 67

Google Education Trainer

  • Viewing student files

​

  • Sorting students

​

  • Grouping

​

  • Items display

​

  • Smart Copy

Day 3

50 of 67

Google Education Trainer

  • Browser Tab vs. Current Screen

​

  • Messaging

​

  • Opening Browser Tab

Day 3

51 of 67

Google Education Trainer

Class Info

​

    • Class Resources

​

    • Class Actions

Day 3

52 of 67

Google Education Trainer

Chrome Menu

Day 3

53 of 67

Google Education Trainer

Tab Options

​

Right click a tab

Day 3

54 of 67

Google Education Trainer

Managing multiple accounts

Day 3

55 of 67

Google Education Trainer

Chrome Store

​

  • Example of Educational Apps & Extensions
    • ATBar
    • SnagIt & Awesome Screenshot
    • Tab Scissors & Glue
    • One Tab
    • Diigo

Day 3

56 of 67

Google Education Trainer

Types of pages

Day 4

57 of 67

Google Education Trainer

Creating a site

​

  • sites.google.com
  • Click on “create”
    • name your site
    • select a theme
    • More Options
      • provide category
      • describe site
  • to use templates
    • click “create”
    • browse gallery for more
    • select template

Day 4

58 of 67

Google Education Trainer

Editing Pages

  • Inserting
    • Common Items
    • Gadgets
    • Google Items
  • Format
  • Table
  • Layout

Day 4

59 of 67

Google Education Trainer

Day 4

60 of 67

Google Education Trainer

Day 4

61 of 67

Google Education Trainer

Day 4

62 of 67

Google Education Trainer

Review:

​

  • Sign in to Hapara
    • create a template assignment and send it to one of your classes via Smart Copy. Let it send all the way.
    • HINT: Check your pop-up blocker if you get stuck
  • Visit a Google+ Community you previously joined
  • GMail
    • find an email in your inbox and create it into a calendar event
    • find an email in your inbox and add it to your task list -- attach a date to the task
  • Turn your wifi off
    • access your Gmail and Drive offline

Day 5

63 of 67

Google Education Trainer

Doctopus

​

  • It’s Hapara on steroids
  • In a new spreadsheet, make sure to download Doctopus as an add-on

Day 5

64 of 67

Google Education Trainer

Formmule

  • Mail merge
  • Calendar merge
  • NOT AVAILABLE as an add-on

​

​

Autocrat

  • Document merge
  • Available as an Add-on but does not execute on form submit

​

To use the old sheet go to g.co/oldsheets

Day 5

65 of 67

Google Education Trainer

bit.ly/courseReflection

66 of 67

Day 4

Challenge

​

Google Forms

  • Create a 10 question quiz that goes to multiple pages that are automatically graded using Flubaroo.
    • extra credit
      • include videos and images in the quiz
  • Create a form that collects name, birth date, birth place, favorite food and favorite activity.
    • create a document template for you to use Autocrat so that the information collected is converted into a document and sent to the person that filled it out and a copy is saved for you.

67 of 67

Day 4

Connect Apps

​

  • VideoNot.es
  • LucidPress
  • WeVideo
  • Real Time Board
  • Pixlr
  • Floor Planner