creating personal tutoring environments with google apps script

50
Creating Personal Tutoring Environments with Google Apps Script Martin Hawksey @mhawksey OEB 2015 - SOL07 Berlin Dec 2-4, 2015 http://go.alt.ac.uk/SOL0 7-Slides This work is licensed under a Creative Commons Attri bution 4.0 Unported Li cense . CC-BY mhawksey

Upload: martin-hawksey

Post on 15-Apr-2017

1.539 views

Category:

Education


1 download

TRANSCRIPT

Page 1: Creating personal tutoring environments with Google Apps Script

Creating Personal Tutoring Environments with Google Apps Script

Martin Hawksey@mhawksey

OEB 2015 - SOL07Berlin Dec 2-4, 2015

http://go.alt.ac.uk/SOL07-Slides

This work is licensed under a

Creative Commons Attribution 4.0 Unported License

. CC-BY mhawksey

Page 2: Creating personal tutoring environments with Google Apps Script

go.alt.ac.uk/join-ALT

Page 3: Creating personal tutoring environments with Google Apps Script

+Martin Hawksey@mhawksey

Page 4: Creating personal tutoring environments with Google Apps Script

Image by © Bryan Mathers

people powered innovation…

…finding your inner hacker

… and creativity

Page 5: Creating personal tutoring environments with Google Apps Script

Image CC-BY-ND Bryan Mathers https://flic.kr/p/qY1xJG

Page 6: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Getting to know you...

http://go.alt.ac.uk/SOL07-Form

[This form is hosted on the alt.ac.uk Google Apps for Education domain]

Form Responses

Page 7: Creating personal tutoring environments with Google Apps Script

CC-BY Google Inc. https://developers.google.com/classroom/

Page 8: Creating personal tutoring environments with Google Apps Script

Everyone wins

LearnersAccess learning materials

and tools from any location, on any device,

at anytime.

No more “dog ate my homework”

TeachersManage all your classes, reuse your resources and

digital tasks.

Tackle workload, work smart.

School LeadersSupport your class

teachers in the digital space. See the work on

going in your faculty/school.

Parents/CarersView class calendar and be clear on the work set

for their child.

Slide © Charlie Love https://goo.gl/cHVZ8c

Page 9: Creating personal tutoring environments with Google Apps Script

CC-BY Vangaurd Visions https://flic.kr/p/hEQpD5Learning Design

Page 10: Creating personal tutoring environments with Google Apps Script
Page 11: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Ex1: Peer Instructionthe instructor engages students by

posing prepared conceptual questions or ConcepTests that are based on student

difficulties … students discuss their thinking and answers with their peers

Page 12: Creating personal tutoring environments with Google Apps Script

alt.ac.uk

Ex1: Peer Instruction1. Instructor poses question

based on students' responses to their pre-class reading

2. Students reflect on the question

3. Students commit to an individual answer

4. Instructor reviews student responses

5. Students discuss their thinking and answers with their peers

6. Students then commit again to an individual answer

7. The instructor again reviews responses and decides whether more explanation is needed before moving on to the next concept.

Mazur (1997)

Page 13: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Example questionWhich statement is the best analogy? A. An umbrella is to rain as the stratosphere is to solar

radiation. B. An umbrella is to rain as the stratosphere is to

ultraviolet radiation.C. An umbrella is to rain as the ozone layer is to solar

radiation. D. An umbrella is to rain as the ozone layer is to

ultraviolet radiation.http://go.alt.ac.uk/SOL07-Vote

Question ID: Q1 - case sensitive [Results]

Page 14: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Page 15: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Example questionWhich statement is the best analogy? A. An umbrella is to rain as the stratosphere is to solar

radiation. B. An umbrella is to rain as the stratosphere is to

ultraviolet radiation.C. An umbrella is to rain as the ozone layer is to solar

radiation. D. An umbrella is to rain as the ozone layer is to

ultraviolet radiation.http://go.alt.ac.uk/SOL07-Vote

Question ID: Q1b - case sensitive [Results]

Page 16: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Page 17: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Introducing Google Add-onsIntegrating

custom functionality for Google

Doc, Sheets and Forms

Page 18: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Ex2: Just in time teaching (JiTT)

Pre class activity designed designed to shape face-to-face teaching

Page 19: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Introducing Flubarooquickly grade

multiple-choice or fill-in-blank

assignments

Page 20: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Getting started with Flubaroo1.Create a new Google Sheet2.In drop down menu select Add-ons > Get Add-ons…

3.Search for ‘flubaroo’ and when you find it click on

4.Start using by selecting Add-ons > Fluabroo > Enable Flubaroo in this sheet

Page 21: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Getting started with Flubaroo5. Create a Google Form for the spreadsheet and add some multiple choice questions6. Complete the Form at least twice, once with all the correct responses7. Explore the Flubaroo menu options

Tip: For some test data copy/paste https://goo.gl/0e9ut6

Page 22: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Ex3: ePortfolioa purposeful collection of information and

digital artifacts that demonstrates development or evidences learning outcomes, skills or competencies.

Cotterill, S (2002)

Page 23: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Introducing siteMaestroCreate and

manage Google Sites ePortfolios

like a freakin' maestro!

Page 24: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Getting started with siteMaestro1.Create a new Google Sheet2.In drop down menu select Add-ons > Get Add-ons…

3.Search for ‘sitemaestro’ and when you find it click on

4.Start using by selecting Add-ons > siteMaestro > Launch

Page 25: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Getting started with siteMaestroThings to know:

◊ siteMaestro is one of many Add-ons by CloudLab at ‘New Visions for Public Schools’ http://cloudlab.newvisions.org/

◊ Rosters created using CloudLab add-ons can be used in there other add-ons

Page 26: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Quick look at DoctopusAn octopus for Docs! … Doctopus makes it easier for teachers to share, organize, and assess student

work in Google Drive.

Page 27: Creating personal tutoring environments with Google Apps Script

CC-BY-NC Xtream_i https://flic.kr/p/tYTwd

Page 28: Creating personal tutoring environments with Google Apps Script

alt.ac.uk

Say hello to Google Apps Script

CC-BY Google – Google Apps Script, 13-03-2012 @mhawksey/+MartinHawksey

Page 29: Creating personal tutoring environments with Google Apps Script

alt.ac.uk

11 Google apps, 1 platform in the cloud

Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, and Sheets.

Apps Script lets you do more with Google. All on a JavaScript platform in the cloud.

@mhawksey/+MartinHawksey

Page 30: Creating personal tutoring environments with Google Apps Script

alt.ac.uk

Code in the cloud◊ Standalone Scripts

script.google.comGoogle Drive > Create > Script

◊ Container-bound– Google Documents, Sheets,

FormsTools > Script editor

– Google SitesMore > Manage Site > Apps Script

@mhawksey/+MartinHawksey

Page 31: Creating personal tutoring environments with Google Apps Script

A brief history

2009Scripts in SheetsCustom functions

2010UiApp*Web Apps (run as developer)Script Gallery*

2011Scripts in SitesGUI Builder*More services

2012Standalone scriptsHTMLSerivceScriptDb*Web Apps (run as user)Libraries and versioningContent ServiceChrome Web Store

2013Scripts in DocScripts in FormsAuth flowMore services

2014Add-on for Documents, Sheets and FormsIFRAME for HTMLService

* Denotes deprecated services/features

Adapted from Wesley Chun’s Google Apps Script

2015Execution API

2016???

Page 32: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Your first Google Apps ScriptWhich would you like to do first:◊Write events from a Google Sheets to Google Calendar1

◊Write events from your Google Calendar to Google Sheets2

[1] Updating Google Calendars from a Google Spreadsheet[2] Grabbing Google Calendar Event Details into a Spreadsheet

Page 33: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Google Sheets to Google Calendar

Tools > Script editor...

Page 34: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Google Calendar to Google Sheets

Tools > Script editor...

Page 35: Creating personal tutoring environments with Google Apps Script

Explanation of Javascript 2D Array getValues()Dog Cat Cow

22 31 15

6 5 5

data = [[“Dog”,”Cat”,”Cow”],[22, 31, 15],[6, 5, 5]]

data[0] = [“Dog”,”Cat”,”Cow”]

data[0][1] = “Cat”

Page 36: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Custom formula to dashboard project/course blog feedsCustom function

to fetchUrlfromRSS(

)

Related postRelated spreadsheet

Page 37: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

Twitter in Education

How could Twitter be used to support learning and teaching?In small groups discuss – 5mins

Page 38: Creating personal tutoring environments with Google Apps Script

In-class Backchannel

Uses: ad hoc class discussion, real-time commenting, recording divergent viewpoints

Benefits: engages less vocal students, archives otherwise ephemeral comments

Outside of Class Discussions

Uses: extend class discussions, exchange comments about readings or questions about assignments

Benefits: community building, continuity between class sessions

In-class Directed Discussion

Uses: Open or guided questions with student responses collected for later analysis

Benefits: engages all students in discussions in large lecture classes

Tracking Activities

Uses: find and follow instructor experts in the field, or key topics

Benefits: exposure to the lager cultural conversation about the class material

Lightly Structured Activities

Uses: solicit course feedback, offer ambient office hours, poll class, language or writing practice

Benefits: flexibility, availability, scalability

Metacognitive/Reflective ActivitiesUses: students report on self learning, articulate their difficulties, recap the most valuable lesson of the day

Benefits: fosters critical thinking

Institutional communication

Uses: community outreach, alerts, announcements

Instructor Communication

Uses: announcements, syllabus changes, reminders

Pedagogical Communication

Uses: sharing timely links and resources

Student Activity

Dial

ogic

Tran

smiss

ion

Passive ActiveMark Sample’s Twitter Adoption Matrix

Page 39: Creating personal tutoring environments with Google Apps Script

https://tags.hawksey.info/

Page 40: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

TAGS Summary

Page 41: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

TAGSExplorer

Page 42: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Setting up TAGS

http://www.kristenmapes.com/tags-tutorial/

Page 43: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Related Post

Google Apps Script Twitter Bot

Page 44: Creating personal tutoring environments with Google Apps Script

“alt.ac.uk@mhawksey/+MartinHawksey

SummaryMoonshots begin with schools that tinker…

New Visions CloudLab

Image credit © New Visions CloudLab

A real opportunity to create your personal tutoring

environment

Page 45: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Resources◊ CloudLab at ‘New Visions for Public Schools’

http://cloudlab.newvisions.org/◊ Google Apps Script - Developer Resources

https://developers.google.com/apps-script/ ◊ Google+ Communities

– Apps Script for Education - Builders and Users https://plus.google.com/communities/112780694700423616523

– Google Apps Script https://plus.google.com/communities/102471985047225101769

– Developing Add-ons https://plus.google.com/communities/117193953428311185494

Page 46: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Resources (2)◊ Alice Keeler

http://www.alicekeeler.com/teachertech/2015/08/05/start-here-a-quick-google-apps-script-project/

◊ Me :) https://mashe.hawksey.info/category/google-apps-script/

Page 47: Creating personal tutoring environments with Google Apps Script

alt.ac.uk@mhawksey/+MartinHawksey

Open BadgesClaim your workshop participant

badge:

http://go.alt.ac.uk/SOL07-Badge

[Awarded using Google Apps Script][Read more (good luck)]

Page 48: Creating personal tutoring environments with Google Apps Script

ALT Online Winter Conference 2015

w/c 7th Dec online sessions scheduled for the 9th/10th Decgo.alt.ac.uk/ALT-Online-2015-Reg

Page 49: Creating personal tutoring environments with Google Apps Script
Page 50: Creating personal tutoring environments with Google Apps Script

Association for Learning Technology

Registered charity number: 1063519

www.alt.ac.uk @A_L_T