Google Apps

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

'Google Keep' iOS Notes Now Integrate With Google Docs on the Web

Google has integrated Google Keep notes into Google Docs, allowing users of the Google Keep iOS app to drag-and-drop their notes directly into online documents.<p>With Google Keep for iOS, users can input notes, lists, photos, and voice memos, set reminders about notes, and organize their note …

Google

Link to cell ranges in Google Sheets

Because it can be difficult to navigate large and complex spreadsheets, we’re introducing the ability to link to specific cell ranges in Go...

OpenClipArt Google Drive Add-on Guide

<i>Discovering inspiration to teach and use technology in the classroom.</i><p>I offer a variety of lessons and activities for technology and business …

Education Technology

Fab Find Friday: Voice-Navigated Google Presentations

<b>So, I hope everyone that reads our daily blog is ready to have their minds blown!</b><p>I would like to thank two incredibly smart, Google-tastic friends: …

Support for rotated text, accounting number formats, and more in Google Sheets

We’re working hard to ensure that Google Sheets meets your business needs. As part of that effort, today we’re introducing several …

Spreadsheet Activities for all Subjects

Spreadsheets are often thought of as a tool for math or statistics. Something just for crunching numbers and making graphs. Although those are …

Education Technology

An Easy Way to Color Code and Organize Ideas in a Google Doc

If you want to color code ideas or themes in Google Docs, the highlighter tool is useful. But at the end of the day, you’re either left with a messy …

How to Link to a Specific Paragraph in Google Docs

• Put your cursor at the start of the paragraph that you want to link to.<br>• Head to the <b>Insert</b> menu at the top of the page, and choose <b>Bookmark.</b><br>• You will see …

Making Lessons With New Google Sites

Students don't enjoy visiting so many sites to complete a lesson. To help them out a bit, I'm using New Google Sites to organize content, skills, …

Creating files from templates now easier in Google Drive

Since 2015, we’ve been making it easier to focus on your content—not your formatting—with templates in Google Docs, Sheets, Slides, and For...

Request form – Sending automatic emails

One of the most useful things I’ve learnt to do with Google Apps Script, is to email people automatically when a form is submitted. It has countless …

PHP

Google Sheets Functions – QUERY

The QUERY function is in a category all on its own. It’s an extremely powerful function that will let you filter, sort, group, pivot, basically …

Google Sites Classic Comparison - Google Sites Experts Designs Development Intranets Websites

General<p>Feature<p>Classic<p>New<p>Site name<p><b>✔</b><p><b>✔</b><p>Site categories<p><b>✔</b><p><b>✘</b><p>Site notice<p><b>✔</b><p><b>✘</b><p>Site description<p><b>✔</b><p><b>✘</b><p>Landing/Home page (select which page is the landing page)<p><b>✔</b><p><b>✔</b><p>Copy …

Web Design

15 Google Classroom Features You Will Love

Google Classroom can help you do hundreds of things. I want to show you a short list of what has made my job a little easier after using it for two …

Google Sheets : ISEMAIL ISNUMBER ISURL

Dans la famille infos des 345 fonctions Google Sheets, intéressons nous aux 3 fonctions ISEMAIL, ISNUMBER, ISURL.<p>LA FONCTION =ESTNUM …

Google Sheets Functions – INDEX and MATCH (VLOOKUP alternative)

In a previous post, we looked at how we can quickly look up tables for certain information, using the VLOOKUP function. This function is great but it …

100+ GAFE Tips and Tricks for Every Teacher

100+ GAFE Tips and Tricks for Every Teacher<p>By Whooo’s Reading Blog Team<p>Despite a recent name change, from Google Apps for Education to G Suite for …

Google Sheets Functions – HYPERLINK

Here let’s take a quick look at the HYPERLINK function, which allows you to add hyperlinks with ease and to also rename them.<p>Here I’ve just copied …

[Tip] Send an automatic email response message to Google Forms

One of the most needed features of the Google Forms was that the respondent completed the form and did not know whether the form was received well. …

Making Websites With Google Docs

When the preview for the new Google Sites came out last summer, I got excited and frustrated all at once. The new Sites looked great and was easy to …

Digital student workbooks with Google Slides

There are lots of different ways to use Google Drive apps in the classroom. Google Slides offers many possibilities. One way of using Google Slides …

The All New Google Sites for Schools - Video Tutorial

Back in June, Google announced that Sites, its web design program, would be getting a long overdue update (see my post from then). Rather than just …

21 {Awesome} Google Tips & Tricks Series

<b>Get notified when I share new posts like this</b> by joining the Insiders Edition. Insert your email below:

Google

5 tips to build a fully automated dashboard using Google Sheet.

Are you tired of spending your time collecting, organising and presenting data while someone else is doing the interesting job ? Will you rather be a …

Getting Started with Google Drive Folders

Google Drive is one of the most valuable tools in Google’s G Suite for Education, and one of the features that makes it so useful is the way that it …

Four Add-ons that Make Google Sheets and Forms Super Awesome

If you haven’t heard of New Visions Cloud Lab, this fantastic project associated with New Visions for Public Schools offers a range of add-ons that …

Wintertime Magnetic Poetry with Google Drawings

<b>Magnetic poetry</b> kits have been around since the early 90’s, providing children and adults with inspiration to create poems on refrigerators …

Google Sheets Functions – ROUND, ROUNDUP, ROUNDDOWN

In this post we’re going to have a quick look at rounding numbers up and down, by using the ROUND, ROUNDUP, and ROUNDDOWN functions.<p>The syntax is …

5 Great Google Drive Templates for Creating Professionally Looking Presentations

December 1, 2016<br>When it comes to creating visually attractive presentations, design work can take up a tremendous amount of your time especially if …