Google Apps

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

New 'responsive' Google Font can shapeshift to match any design

Google Fonts is getting more customizable and interactive. The company has updated its collection with its very first ‘parametric’ font – a new typographic technology that makes it easy for designers to tweak and modify the format of virtually any typeface.<p>Developed in collaboration between …

Web Design

The Definitive Guide to Google Sheets

Imagine the world without data, take a minute to grasp that idea. Data has played an important role in the evolution of homo sapiens from the stone …

Video Mash-Ups with Google Slides

<b>Mash-Ups</b> are a fun and popular way to express creativity whether you are combining different styles of music, or art, or memes, or such. <b>Mash-ups can</b> …

Google Drive

How to create an automatically updating Google spreadsheet

Let your spreadsheet do the workImage by Screenshot of Google SheetsTracking basic data in a spreadsheet is pretty simple -- it's remembering to …

Automation

Google Drive will soon back up your entire computer

Google is turning Drive into a much more robust backup tool. Soon, instead of files having to live inside of the Drive folder, Google will be able to monitor and backup files inside of any folder you point it to. That can include your desktop, your entire documents folder, or other more specific …

Google

Google Drive’s Mac uploader will soon be replaced by new ‘Backup and Sync’ app

Google currently has separate desktop clients to back up to Google Drive and Photos. With the upcoming Backup and Sync for Mac, the company is replacing the Drive client with a new app that features better integration.<p>Backup and Sync from Google is a tool “intended to help everyday users back up …

Google Drive

Google App Maker

MSRP <br>$10.00<p><b>Pros</b><p>User-friendly. No coding required for basic app creation. Intuitive UI builder with drag-and-drop widgets. Google Drive Tables for …

Google Apps

English county council saves millions switching to G Suite and Chromebooks

A day in the life of an employee at Northumberland County Council in northern England involves everything from running schools, repairing roads or …

5 Neat Things You Can Do With Google Sheets

Once you get the hang of working with Google Sheets there are a lot of great ways to use spreadsheets as a teacher or as a student. Here's a run-down …

24 important Google Docs Tips and Add-ons for Teachers

• Talk to type<br>• Keyboard shortcuts<br>• Notify team members of comments<br>• Use bookmarks to navigate long documents<br>• Automatically convert Word docs to Google …

Google Docs

A Must Have Google Sheets Add-on for Teachers

June 6, 2017 Sheetgo is an excellent add-on you should definitely install on your Google Sheets. It allows you to easily transform data between …

M-learning

Visualize data instantly with machine learning in Google Sheets

Sorting through rows and rows of data in a spreadsheet can be overwhelming. That’s why today, we’re rolling out new features in Sheets that make it …

Machine Learning

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 …

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, …

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, …

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 …

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 …