Collect data from different spreadsheets without using scripts

Lately I have been asked several times how to perform this operation. Several teachers have classes with the same students (although not exactly the same) and all evaluate the same aspects. Each one has their own sheet with their students and they want to be able to gather all the information and make averages. In addition, you can also create one sheet per student so that they can only see their results.

In this article I will detail a possible way to do it.

Continue reading “Collect data from different spreadsheets without using scripts”

G Suite Administration Console (2): Audits

Continuing with the series of articles on the Google apps for education admin console, today I review a very useful option that, because of the questions I receive, is not very well known. It’s about audits. The console lets you know what’s going on in many ways, always keeping your data private. Where’s a drive file? How many users have opened it? Who deleted an event from the shared calendar? And a lot of other things.
Continue reading “G Suite Administration Console (2): Audits”

G Suite Administration Console (1): Application presentation and installation

Following some queries I’ve received in the last few weeks, I start a series of articles by talking about the administration console of a Google apps for education. The truth is that it has a lot of possibilities and is worth investigating. I won’t do a complete tutorial because it would be endless and Google documentation is already quite good. I will only highlight a few aspects that I find particularly interesting and which, in some cases, are a little hidden.

Continue reading “G Suite Administration Console (1): Application presentation and installation”