Arxius de Teachers - Page 4 of 7

Single-point rubric: Automate sharing with students

Posted on 12 de January de 201912 de January de 2019 by Jaume Feliu

This course we have begun to use in a habitual way and more or less systematic the single-point rubrics. I speak in the plural because it is not only my own thing, but also that of the teachers of my school who work on projects in the 4th year of ESO.

For those of you who do not know single-point rubrics (here the link from where I knew them), they are nothing more than usual analytical rubrics, where only the expert level is indicated and, instead of evaluating by selecting a level, it is necessary to write down which points of each aspect must be improved to become an expert and which points are already correct. In the link you can see different models.

Next, one of the ones we use to evaluate the students’ portfolio.

Continue reading “Single-point rubric: Automate sharing with students”

Allow copies of forms (documents and presentations)

Posted on 5 de January de 20195 de January de 2019 by Jaume Feliu

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.

How to create a bank of resources?

Posted on 25 de November de 201825 de November de 2018 by Jaume Feliu

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

Posted on 15 de August de 201815 de August de 2018 by Jaume Feliu

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”

Working with Google documents offline

Posted on 31 de May de 201831 de May de 2018 by Jaume Feliu

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.

Continue reading “Working with Google documents offline”