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?
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.
Rubrics and formative evaluation
Many people still believe that evaluating with rubrics is formative evaluation and, in many cases, it is not. A rubric, in fact, provides clear criteria when evaluating a task. Now, this can be done so that the student detects his mistakes and his strong points and reflects on his learning (formative evaluation) or it can be done simply mechanically to grade tasks (summative or certifying evaluation).
I do not renounce either of the two, whether for formative evaluation or for summative evaluation, using rubrics is always positive. The student knows the criteria that will be used to evaluate a task. And that is always positive.
Now, since we use the rubrics, let’s use them making formative evaluation, that there are a thousand studies that show that it is one of the measures that most improves the learning of the students. And what exactly does it mean to make formative evaluation with rubrics?
Organise a center by projects
Organize by Nick Youngson CC BY-SA 3.0 Alpha Stock Images
I find more and more consultations from centers that want to start working on projects but don’t know how to start. On a methodological level they start to get smart. More and more teachers have taken some courses and there are already many centres with more or less trained and sometimes even experienced people. But from there to introducing project work at school level there is an other step. Often the difficulties encountered are organisational. How do we organise the center so that project work is constantly present and involves the whole faculty?
In this article I explain some forms of organisation that I have known (practically all of them I have put into practice) and the advantages and disadvantages that I find in each one.
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”
