Google Apps

By Barrie Roberts | Stuff related to Google Drive, Docs, Sheets, Forms, Slides & Sites

Quick Access in Google Drive now available on the web

In September 2016, we launched Quick Access for Google Drive, which uses machine learning to intelligently predict the files you need, bef...

Google Sheets Query function: Learn the most powerful function in Google Sheets

Have you heard of the Google Sheets query formula?<p>It allows you to use SQL (Structured Query Language, the code used to communicate with databases) …

How to create an annotated line graph in Google Sheets

This post looks at how to create a more advanced line graph in Google Sheets, with comparison lines and annotations, so that the viewer can absorb …

7 Hidden Tips for Google Sites - Teacher Tech

I have been loving using Google Sites to create tutorials. The autosizing of pictures, the easy insertion of items from Google Drive, mixing text …

Google

Become a Google Drive power user with these 20 tips and tricks

Boost your productivity<p>When Google Docs first appeared more than a decade ago, the idea of software running in a browser was still a strange and unusual one. Since then, the rebranded Google Drive has gone from strength to strength, with millions now relying on the free word processing, …

Google

Design Emails in Google Docs, Convert Them to Gmail Drafts with 1 Click

Head to the Chrome Web store and search for <b>Convert Google Docs to Gmail drafts.</b> Click on the button to install the extension, and then give the …

Make & Send Kids Reports

In this post, we’re going to look how we can create kids reports from a Google Sheet and convert them into individual PDFs made from Google Docs, …

Google Apps

Create Cloze Reading Activities with Google Sheets and Other Tools

A "<b>Cloze Test</b>" is a <b>reading activity</b> where a student is given a <b>reading passage with certain words removed</b>. Sometimes the student is also provided with …

Forms & Sheets – Attendance System

In this post we’re going to make an attendance system using Google Forms and Sheets. The user will fill in the attendance on the form (possibly on …

Apps Script Basics – Variables and getting & setting values

In this post, we’re going look at how variables are set up and how they can store various pieces of information. We’re also going to look at reading …

Questionnaires – Automatically send feedback to individuals

It’s common to use questionnaires at the end of a course to get feedback on the course and teacher. When you have a lot of teachers, it can be hard …

The Easier Way to Freeze Rows/Columns in Google Sheets

Do you ever find yourself scrolling through a column in Google Sheets only to forget what the column’s title was? By freezing the top row, the column …

10 Google Apps Tricks to Learn for 2017 - Teacher Tech

10 Google Apps Tricks to Learn for 2017<p>1. Force a Copy<p>When I create templates I like to share the templates in a way that prompts the user to create …

Google Classroom: Pull Student Paragraphs and Give Feedback - Teacher Tech

Google Classroom: Pull Student Paragraphs and Give Feedback<p>I like to joke that the “Make a copy for each student” option is really the “Make a giant …

Google Drive

Awesome Shortcuts for Sharing Google Docs (Copy or Preview)

Google Classroom is a great resource to share Google files with students or other teachers. Google Classroom allows you to quickly share viewable or …

Resources Google Forms

Google Forms Resources<p>All of my resources are licensed under a Creative Commons Attribution Non-Commercial 3.0 United States license …

Shut the Front Door (Again)! Updated Differentiation With Google Forms

Pinterest<p>Shut the Front Door (Again)! Updated Differentiation with Google Forms!<p>UPDATED March 2017! There are so many amazing things we can do with …

New Google Sites - Calendars and Team Drive - Google Sites Experts Designs Development Intranets Websites

The newest features:<p>Insert multiple calendars in one display<br>• Saved changes notification<br>• Insert from Team Drive<br>• Team Drive sharing<p>Insert multiple …

5 Helpful Tips for Teaching with G Suite

It looks like it’s already that time again! Schools are already well into their second semester of the year, which means it’s time to start planning …

20 Things You Can Do With Google Classroom - Teacher Tech

Google Classroom<p>Google Classroom (http://classroom.google.com) is available to schools with a Google Apps for Education (GAfE) domain. Classroom is a …

Google Classroom now available for personal Google accounts

Google Classroom is a fantastic tool for collaboration in schools, but the requirement to use G Suite for Education was a barrier of entry for some …

Google Sheets Features and Formulas for Teachers: More You Didn’t Know Existed

New tips, tricks, features, and functions ideal for the Google Sheet-using …

Google

Apps Script Basics – First Script

Here I want to show you how easy it is to write some code using Apps Script. This is the code that sits in the background of some of the Google Apps. …

10 ways Google Keep can help streamline life at school

Makers Gonna Make Anywhere, Anyhow

My motto for making is Makers Gonna Make. But what happens if you have no space available to let students (and teachers) make? The good news is, …

Placement Test

Students who want to study a language at a language academy, have to do a placement test, which confirms their current level in that language and …

Fast Quiz

FastQuiz is Google Sheets Add-On. Students or teachers can create a Quiz with Google Form and give live feedback to other students with Gmail.<p>To …

Drive Migrator

<b>Share the folder with your new Google Account</b> (reader or editor access, doesn't matter)<p><b>Copy the URL</b> of the folder<p><b>Log into your new Google</b> …

A New Way Forward for Collaborative Editing

We are happy to announce WordPress.com for Google Docs, a new add-on that lets you write, edit, and collaborate in Google Docs, then save it as a …