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”

A spreadsheet to save data in AppInventor (or other languages)

Today’s article is very technical and not very pedagogical. As always, the origin is educational, since the problem arose in the classroom, with 16 years old students. But it’s a question of information technology.

This students follow the program Mobilitzem la informàtica with some adaptations (only in Catalan). It is a program where students learn design thinking developing an application for mobile phones with appiventor.

Continue reading “A spreadsheet to save data in AppInventor (or other languages)”