Teachers

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

Working with Google documents offline

All of us who work mainly in the cloud (in my case, almost exclusively) have heard comments like: “It’s great to have all the information in the cloud, but the day you don’t have the internet you won’t be able to do anything”. This statement has not been true for a long time now, but it’s okay to remember it and see how to set it all up so that we can really work when we don’t have access to the network. In this article we will see how to access documents, presentations and spreadsheets in Google format that we have on Drive and how we can work. It is necessary to specify that, for the moment, we can only work with these 3 types of files. Therefore, without connection we will not be able to work with sites, forms, drawings, mymaps, etc.

(more…)

Inserting private images into a Google Sheet

A couple of days ago, Alice Keeler (@alicekeeler) published a post (Google Sheets: Embed an Image) about the =IMAGE() function to insert images into a spreadsheet. It is a function that allows you to embed an image that is public on the Internet inside a cell. I encourage you to read her post.

With this function you can only embed images that are on the internet in a public way. But what if we want to insert photographs that we don’t want to publish? For example, what if we have created a pupil tracking sheet and we want that their pictures appear? In this article I show an option that can complement Alice’s article.

(more…)

Share and encourage sharing!

Today is the end of the year and I have a simple wish for the next one. In fact I have it today and the rest of the year, but these days it is more typical to communicate them.

A very simple desire: share and encourage the sharing of the materials you create as teachers.

(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…)