II Meeting G Suite Catalunya

This past Saturday took place the II Meeting G Suite Catalunya and I found it interesting to make an entry as a chronicle and assessment.

In the first place, we should start with the genesis. The meeting is not organised by any entity, any organisation, any company, any institution… There are simply 9 teachers (I am one of them) who believe it is important to share classroom practices where technology (based on Google tools, but not exclusively) plays an important role in improving student learning.

Continue reading “II Meeting G Suite Catalunya”

Allow copies of forms (documents and presentations)

Google Drive has a few hidden tricks. Some of them I use without knowing too much who told me or where I read it. And one of them is to allow copies of a form without anyone being able to edit our original form.

Continue reading “Allow copies of forms (documents and presentations)”

How to create a bank of resources?

Last September, the group of moderators of the GEG Spain community (I am lucky enough to be a part) created a resource bank to order all the material created at community meetings and to add other resources that could be useful to the community.

The idea was easy. To be able to easily access presentations, video and other resources. But we thought it necessary to add a social layer, so that the resources could be valued and comments left.

Continue reading “How to create a bank of resources?”

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.

Continue reading “ARRAYFORMULA function in Google spreadsheets”

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.

Continue reading “One file in several Drive folders”