G Suite

ARRAYFORMULA function in Google spreadsheets

I sincerely believe that spreadsheets are one of the most useful tools for teachers. I have said it more than once and, for me, should be one of the digital skills of a teacher. It’s true that I haven’t dedicated much time to them in this blog. A couple of years ago I dedicated one to the IMPORTRANGE formula. Today I will talk about another formula that can also be very useful, ARRAYFORMULA. It is especially useful when working with spreadsheets that collect responses from Google forms.

(more…)

One file in several Drive folders

Of all G Suite applications, Drive is one of the most widely used, but it’s also one of the most common headaches. To take advantage of it, you have to be tidy and have some clear concepts of how it works. Other times I’ve talked about how to keep it organized: Organizing Google Drive and Google Drive share folders or documents?

In this article I’m talking about the option of having the same file in two or more different folders and the precautions we should take if we use it.

(more…)

Find orphaned files on Google Drive

When you use Google Drive in an organization and share folders, we may have a problem: some files may seem to disappear. It’s what are called orphan files.

(more…)

New version of CoRubrics GSD: integration with Classroom

A new version of CoRubrics GSD is now available in the spreadsheet add-ons Chrome store, an add-on to evaluate with rubrics.

This new version has the main novelty of integrating with Classroom. This integration takes place in 3 aspects.

(more…)

Using drawings to insert images into Google documents

To insert images into Google documents, we usually use two options. Either we use the clipboard and copy and paste the image or we use the option Insert image from the Google docs menu.

(more…)