Customising Google Apps for Education with Google Apps Script GEUG14

Download Customising Google Apps for Education with Google Apps Script GEUG14

Post on 06-May-2015

7.486 views

Category:

Education

7 download

Embed Size (px)

DESCRIPTION

Video of this presentation https://www.youtube.com/watch?v=VWRlb3TIqwI Presentation given at University of York Google Apps for Education European User Group meeting (GEUG14) exploring the how Google Apps for Education can be customised with Google Apps Script. This presentation introduces the basic concepts of Google Apps Script, highlighting existing examples being used in learning and teaching. It goes on to look at how Google Apps Script's latest feature 'Add-ons' can improve the end user experience.

TRANSCRIPT

  • 1.Customising Google Apps with Google Apps Script Presented at Martin Hawksey This work is licensed under a Creative Commons Attribution 3.0 Unported License. CC-BY mhawksey

2. alt.ac.uk All links bundled in http://bit.ly/GEUG14-Apps-Script @mhawksey+MartinHawksey http://bit.ly/GEUG14-Apps-Script 3. alt.ac.uk About http://bit.ly/GEUG14-Apps-Script 4. alt.ac.uk Dr. Tony Hirst The Open University @psychemedia ouseful.info http://bit.ly/GEUG14-Apps-Script 5. alt.ac.uk Dr. Tony Hirst The Open University @psychemedia ouseful.info http://bit.ly/GEUG14-Apps-Script 6. alt.ac.uk Dr. Tony Hirst The Open University @psychemedia ouseful.info http://bit.ly/GEUG14-Apps-Script 7. alt.ac.uk Say hello to Google Apps Script CC-BY Google Google Apps Script, 13-03-2012 http://bit.ly/GEUG14-Apps-Script 8. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 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. 9. alt.ac.uk Code in the cloud Standalone Scripts script.google.com Google Drive > Create > Script Container-bound Google Documents, Sheets, Forms Tools > Script editor Google Sites More > Manage Site > Apps Script http://bit.ly/GEUG14-Apps-Script 10. alt.ac.uk A brief history http://bit.ly/GEUG14-Apps-Script 2009 Scripts in Sheets Custom functions 2010 UiApp Web Apps (run as developer) Script Gallery* 2011 Scripts in Sites GUI Builder* More services 2012 Standalone scripts HTMLSerivce ScriptDb* Web Apps (run as user) Libraries and versioning Content Service Chrome Web Store 2013 Scripts in Doc Scripts in Forms Auth flow More services 2014 Add-on for Documents and Sheets * Denotes deprecated services/features Adapted from Wesley Chuns Google Apps Script 11. Some Examples 12. alt.ac.uk Google Form Created for Assessment As part of an effort to re-design an observational assessment, tutors had identified that the quality and speed of feedback needed to be improved. After consultation, it was suggested that an existing paper form could be replaced by a Google Form and completed live using tablet devices. See the form here. Apps Script Written for Feedback Delivery Following the creation of the Google Form, Apps Script was written that generates an HTML formatted feedback report and emails it to the student, School administrator and themselves as soon as the tutor submits. As a result, students would receive individual, legible and immediate feedback directly to their email account as opposed to waiting days to collect it from the administrative office. See the script here. Apps Script Shared with Colleagues As this idea is highly adaptable, sharing the script with colleagues has led to suggestions of how other processes could be modified. As it is now used for 4 other purposes within this School alone, a responsive webpage (hosted using Google Drive) has been created to allow staff to move between forms from a single point of access, regardless of device. See the form selector webpage here. During the 2013/4 academic year, staff from across the Faculty of Humanities and Social Sciences, Keele University, called for assistance in relation to existing procedures involving assessment, feedback and the general dissemination of electronic materials. Following consultation, several solutions were trialed, mainly focusing upon technologies familiar to staff and at Keele (i.e. Blackboard, IntraLibrary, PebblePad and Google Apps for Education). As more demands were made, it became clear that Google Apps for Education provided the most flexible and intuitive solution, giving rise to the idea that Google has the potential to provide the most complete learning platform; the GLE. Below is one example of the types of intervention Google Apps for Education afforded. For information about other Google projects, please see http://goo.gl/9vMgHj. 13. alt.ac.uk Google Form Created for Assessment As part of an effort to re-design an observational assessment, tutors had identified that the quality and speed of feedback needed to be improved. After consultation, it was suggested that an existing paper form could be replaced by a Google Form and completed live using tablet devices. See the form here. Apps Script Written for Feedback Delivery Following the creation of the Google Form, Apps Script was written that generates an HTML formatted feedback report and emails it to the student, School administrator and themselves as soon as the tutor submits. As a result, students would receive individual, legible and immediate feedback directly to their email account as opposed to waiting days to collect it from the administrative office. See the script here. Apps Script Shared with Colleagues As this idea is highly adaptable, sharing the script with colleagues has led to suggestions of how other processes could be modified. As it is now used for 4 other purposes within this School alone, a responsive webpage (hosted using Google Drive) has been created to allow staff to move between forms from a single point of access, regardless of device. See the form selector webpage here. During the 2013/4 academic year, staff from across the Faculty of Humanities and Social Sciences, Keele University, called for assistance in relation to existing procedures involving assessment, feedback and the general dissemination of electronic materials. Following consultation, several solutions were trialed, mainly focusing upon technologies familiar to staff and at Keele (i.e. Blackboard, IntraLibrary, PebblePad and Google Apps for Education). As more demands were made, it became clear that Google Apps for Education provided the most flexible and intuitive solution, giving rise to the idea that Google has the potential to provide the most complete learning platform; the GLE. Below is one example of the types of intervention Google Apps for Education afforded. For information about other Google projects, please see http://goo.gl/9vMgHj. 14. alt.ac.uk Google Form Created for Assessment As part of an effort to re-design an observational assessment, tutors had identified that the quality and speed of feedback needed to be improved. After consultation, it was suggested that an existing paper form could be replaced by a Google Form and completed live using tablet devices. See the form here. Apps Script Written for Feedback Delivery Following the creation of the Google Form, Apps Script was written that generates an HTML formatted feedback report and emails it to the student, School administrator and themselves as soon as the tutor submits. As a result, students would receive individual, legible and immediate feedback directly to their email account as opposed to waiting days to collect it from the administrative office. See the script here. Apps Script Shared with Colleagues As this idea is highly adaptable, sharing the script with colleagues has led to suggestions of how other processes could be modified. As it is now used for 4 other purposes within this School alone, a responsive webpage (hosted using Google Drive) has been created to allow staff to move between forms from a single point of access, regardless of device. See the form selector webpage here. During the 2013/4 academic year, staff from across the Faculty of Humanities and Social Sciences, Keele University, called for assistance in relation to existing procedures involving assessment, feedback and the general dissemination of electronic materials. Following consultation, several solutions were trialed, mainly focusing upon technologies familiar to staff and at Keele (i.e. Blackboard, IntraLibrary, PebblePad and Google Apps for Education). As more demands were made, it became clear that Google Apps for Education provided the most flexible and intuitive solution, giving rise to the idea that Google has the potential to provide the most complete learning platform; the GLE. Below is one example of the types of intervention Google Apps for Education afforded. For information about other Google projects, please see http://goo.gl/9vMgHj. 15. alt.ac.uk Google Form Created for Assessment As part of an effort to re-design an observational assessment, tutors had identified that the quality and speed of feedback needed to be improved. After consultation, it was suggested that an existing paper form could be replaced by a Google Form and completed live using tablet devices. See the form here. Apps Script Written for Feedback Delivery Following the creation of the Google Form, Apps Script was written that generates an HTML formatted feedback report and emails it to the student, School administrator and themselves as soon as the tutor submits. As a result, students would receive individual, legible and immediate feedback directly to their email account as opposed to waiting days to collect it from the administrative office. See the script here. Apps Script Shared with Colleagues As this idea is highly adaptable, sharing the script with colleagues has led to suggestions of how other processes could be modified. As it is now used for 4 other purposes within this School alone, a responsive webpage (hosted using Google Drive) has been created to allow staff to move between forms from a single point of access, regardless of device. See the form selector webpage here. During the 2013/4 academic year, staff from across the Faculty of Humanities and Social Sciences, Keele University, called for assistance in relation to existing procedures involving assessment, feedback and the general dissemination of electronic materials. Following consultation, several solutions were trialed, mainly focusing upon technologies familiar to staff and at Keele (i.e. Blackboard, IntraLibrary, PebblePad and Google Apps for Education). As more demands were made, it became clear that Google Apps for Education provided the most flexible and intuitive solution, giving rise to the idea that Google has the potential to provide the most complete learning platform; the GLE. Below is one example of the types of intervention Google Apps for Education afforded. For information about other Google projects, please see http://goo.gl/9vMgHj. 16. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 17. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 18. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 19. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 20. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 21. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 22. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 23. Add-ons 24. alt.ac.uk Add-ons overview http://youtu.be/lZqX6ocwHWU http://bit.ly/GEUG14-Apps-Script 25. alt.ac.uk Dont hate, automate What parts of learning and teaching would you like to automate? http://bit.ly/GEUG14-Apps-Script 26. Google Classroom 27. alt.ac.uk Google Classroom http://youtu.be/K26iyyQMp_g http://bit.ly/GEUG14-Apps-Script 28. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 29. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 30. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 31. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 32. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 33. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 34. alt.ac.ukhttp://bit.ly/GEUG14-Apps-Script 35. alt.ac.uk Support Communities http://bit.ly/GEUG14-Apps-Script 36. Summary 37. alt.ac.uk On? Add-ons not on DriveApp not on not on http://bit.ly/GEUG14-Apps-Script 38. alt.ac.uk Opportunity Code wonderful to create machines with your mind Dave Winer Consume http://bit.ly/GEUG14-Apps-Script 39. alt.ac.uk Useful resources Google Apps Script docs Issue tickets Release notes Communities Google+ Communities Stackoverflow Google Enterprise Connect http://bit.ly/GEUG14-Apps-Script 40. alt.ac.uk All links bundled in http://bit.ly/GEUG14-Apps-Script @mhawksey+MartinHawksey http://bit.ly/GEUG14-Apps-Script 41. Association for Learning Technology Registered charity number: 1063519 www.alt.ac.uk @A_L_T