Innovators Spark Shop

 Sparkcamp Saturday!

Introduction to Apps Script: Automate Everything!

Free online course for app script -  Ben Collins

Java script course on Code Academy

Google Classroom app script

/**
 * Lists 10 course names and IDs.
 */
function listCourses() {
  var optionalArgs = {
    pageSize: 10
  };
  var response = Classroom.Courses.list(optionalArgs);
  var courses = response.courses;
  if (courses && courses.length > 0) {
    for (i = 0; i < courses.length; i++) {
      var course = courses[i];
      Logger.log('%s (%s)', course.name, course.id);
    }
  } else {
    Logger.log('No courses found.');
  }
}

Sheets and Data: Functions to play with

Use of a spreadsheet by someone else. Set up formula's and functions to get relevant data but then hide all the workings so the user sees only what they need. Some use sort function and query functions then named cells to display data.

20 tips in 20 minutes

1) Create event in Gmail (3 dots menu)

Tab + enter sends email straight away

2) Moving images between apps with Keep: save image to keep, open next app, use Keep in sidebar to find and copy. 

3) Chapters in Youtube (loop a chapter by right clicking and choosing loop)

4) Calendar short cut keys (D, M, W, Y, A). Add event with Focus time (automatically declines requests for meetings)

5) Meet bot in chat: "@meet type persons name" (see help article)

6) Tabs (Group, Pin, Send to (click Omni box to send to another device, Mute)

7) Smart chips (people, docs, youtube vid)

8) use google arts and culture

Power of gif

SUTTON TRUST     research

Created in Google Slides - make slide, duplicate slide then add.  Install Tall Tweets - Add on to Google Slides. Upload the presentation.

Autograph - for maths teachers - like Desmos calculator

Insert Gig's into Forms and Jamboards

Gamification through Classroom Leaderboard

Self determination theory for intrinsic motivation

💡Use Google Classroom Markbook as a leaderboard.

Free rice.com and Games for Change

Bite-Sized PD

For staff pd - put the choice board up on the screen and have teachers vote on a form for which resource they want to go over

Bite Size PD slide deck - check out Break up an Essay!

Taming Data with Data Studio

Link to slide deck.

Turn on 'Cross filtering' to enable filtering between different elements on your report.

Designing Bite-Sized Technology Trainings using Microlearning

Link to Slidedeck

Break up training into single objectives with mini lesson for each.

"Why Bother?" for the objective/rationale

Build a pre-assessment (maybe a self marking quiz with answers that have links to modules)

Allow for self reflection

Add certificates/badges

Beyond Hyperdocs - Engaging Google Docs for Students

Link to Slidedeck

Multi modal (text, audio, video, images)

Font types - Lexend fonts e.g. Deca (open dyslexic is still good)

Use hyperlinked checkbox lists with hyperlinked headings.

Add link to a Slides doc, and Ss can preview within Docs!

Hyperlink audio with Mote.

Add link to Youtube in Docs and open preview!

Make link 'Smartchips' to make it an obvious link to youtube/slides etc