creating personal tutoring environments with google apps script
TRANSCRIPT
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
go.alt.ac.uk/join-ALT
+Martin Hawksey@mhawksey
Image by © Bryan Mathers
people powered innovation…
…finding your inner hacker
… and creativity
Image CC-BY-ND Bryan Mathers https://flic.kr/p/qY1xJG
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
CC-BY Google Inc. https://developers.google.com/classroom/
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
CC-BY Vangaurd Visions https://flic.kr/p/hEQpD5Learning Design
“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
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)
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]
alt.ac.uk@mhawksey/+MartinHawksey
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]
alt.ac.uk@mhawksey/+MartinHawksey
“alt.ac.uk@mhawksey/+MartinHawksey
Introducing Google Add-onsIntegrating
custom functionality for Google
Doc, Sheets and Forms
“alt.ac.uk@mhawksey/+MartinHawksey
Ex2: Just in time teaching (JiTT)
Pre class activity designed designed to shape face-to-face teaching
“alt.ac.uk@mhawksey/+MartinHawksey
Introducing Flubarooquickly grade
multiple-choice or fill-in-blank
assignments
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
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
“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)
“alt.ac.uk@mhawksey/+MartinHawksey
Introducing siteMaestroCreate and
manage Google Sites ePortfolios
like a freakin' maestro!
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
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
“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.
CC-BY-NC Xtream_i https://flic.kr/p/tYTwd
alt.ac.uk
Say hello to Google Apps Script
CC-BY Google – Google Apps Script, 13-03-2012 @mhawksey/+MartinHawksey
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
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
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???
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
alt.ac.uk@mhawksey/+MartinHawksey
Google Sheets to Google Calendar
Tools > Script editor...
alt.ac.uk@mhawksey/+MartinHawksey
Google Calendar to Google Sheets
Tools > Script editor...
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”
“alt.ac.uk@mhawksey/+MartinHawksey
Custom formula to dashboard project/course blog feedsCustom function
to fetchUrlfromRSS(
)
Related postRelated spreadsheet
“alt.ac.uk@mhawksey/+MartinHawksey
Twitter in Education
How could Twitter be used to support learning and teaching?In small groups discuss – 5mins
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
https://tags.hawksey.info/
alt.ac.uk@mhawksey/+MartinHawksey
TAGS Summary
alt.ac.uk@mhawksey/+MartinHawksey
TAGSExplorer
alt.ac.uk@mhawksey/+MartinHawksey
Setting up TAGS
http://www.kristenmapes.com/tags-tutorial/
alt.ac.uk@mhawksey/+MartinHawksey
Related Post
Google Apps Script Twitter Bot
“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
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
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/
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)]
ALT Online Winter Conference 2015
w/c 7th Dec online sessions scheduled for the 9th/10th Decgo.alt.ac.uk/ALT-Online-2015-Reg
Association for Learning Technology
Registered charity number: 1063519
www.alt.ac.uk @A_L_T