Google Training Materials
Staff Training Video Series
On this page you will find several playlists which guide you through the Google Workspace tools. Each playlist includes a series of short videos which directly address each skill identified in the Stirling Digital Learning Progress review. If you have not updated the review in the last 12 months, please use the appropriate form below to do so when you have time.
The data gathered in this review will help establishments ensure appropriate digital support is available.
How do I find the right tutorial?
Scroll to desired topic
Click playlist icon
Choose from playlist
Google Drive
Playlist Contents:
Finding & opening your Google drive
Uploading a file or folder from your computer to Drive
Opening & editing a document in Drive
Creating a new file e.g. Docs or Slides in Drive
Creating and managing folders
Add a collaborator to a file
Finding a file which was shared with me through Google Drive
Changing/removing the sharing permissions of a file you shared
Adding or moving files to a shared drive
Creating a "workspace" to organise groups of files
Creating shortcuts to access a file/folder from different locations
Creating & Sharing a Jamboard (online interactive whiteboard) with a class
Exploring the version history of docs, slides etc.
Google Classroom
Playlist Contents:
Finding & opening Google Classroom
Creating a new class
Adding a co-teacher
Adding pupils to the classroom
Posting reference materials in your classroom
Posting assignments in your classroom
Reusing assignments from another class
Posting an assignment to a specific pupil or group
Attaching files to assignments (view only, edit or copy for each pupil)
Finding assignments pupils have turned in
Grading and returning assignments
Leaving individual and whole class comments
Creating and using a comment bank for feedback
Creating & using Rubrics for grading
Archiving and retrieving old classrooms
Using the classroom originality report
Google Docs
Playlist Contents:
Formatting text
Adding & modifying table
Changing page size & orientation
Inserting a diagram using Drawings
Inserting a picture
Using headers and footers
Using the document outlines features
Adding suggestions/comments to documents
Using the voice typing tool
Downloading doc in a different format e.g. PDF
Google Slides
Playlist Contents:
Adding/duplicating slides and applying layout
Editing appearance & formatting of slides
Controlling transitions and animations
Downloading a slide(s) as a PDF or an image file
Changing the size of the slides to A4 size
Inserting items e.g. audio/video to slides
Google Sheets
Playlist Contents:
Selecting, adding & removing cells, columns & rows
Formatting cells: type, size, outlines, text, colours etc.
Basic formulas e.g. add, subtract, multiply
Basic functions e.g. SUM, AVERAGE, MAX, MIN
Creating charts and graphs to visualise data
Using pivot tables to analyse data
Google Forms
Playlist Contents:
Creating a form with appropriate question types
Finding and reviewing responses to a form
Turning a form into a quiz & controlling marks
Setting forms/quizzes as Classroom assignments
Marking a forms quiz
Adding feedback to a forms quiz
Importing marks from a form into Classroom
Linking the form data to Google Sheets
Google Meet
Playlist Contents:
Scheduling & inviting others to a Meet you created
Starting a Meet through Google Classroom
Sharing your computer screen in Meet
Recording a Meet
Finding & sharing Meet recordings with pupils
Tablet Academy Training 15/02/2021
Find recordings of all training sessions on YouTube.