Clil tecnologia: hojas de calculo

Ok... One of the things I have been experimenting with has been to do CLIL for ESO students near Madrid, Spain, two days a week.
(CLIL- Content Language Integrating Learning.)

As someone very sympathetic to the dogme principles of getting content from students, not filling their empty little heads with my unending rays of wisdom, it is often very anti-intuitive for me. It has been really hard, after the very fun and useful experiments with teaching through improv theatre last year. Also, full disclosure: I have more training in theatre than spreadsheets.

The content is important to get across, so it is like driving the car with the parking brake on. The rule of "what is taught is not necessarily what is learned" is especially true here. Students have their own level of English, and understanding of technology. I tried to adapt by giving them video tutorials that they could follow along with at their own speed.

It also creates the "Anti-Pareto principle" with 80% of my work going for 20% of my income. There aren't any materials available for my particular levels and guidelines from the school, (Spanish curriculum, using LibreOffice software) so I have to/get to make it. The cheating that goes hand in hand with an economy of marks and the digital tools that make copying effortless means that I spend a good chunk of time "watching the prisoners." (a task facilitated by open source software monitor Italc 2.)

Doing something that is totally anti-me, I had to set up a zero tolerance cheating rule and enforce it ruthlessly (going to the draconian extreme of a public execution, I mean, demo of open source forensic software "autopsy" on a copy of an anonomous (ok, made up) student file).

What does all this mean? It means I spent a lot of time like the monkey in toy story 3. That, of course, is not good for the affective side of things. 

On the other hand:

I had an opportunity to really empower kids with tech.

I made an exercise allowing them to model a Spanish mortgage, allowing them to see how the bank works while "buying" their dream home, and what they really sign when they sign a mortgage.

If more people were aware of what they were really signing, I think the Spanish economy would be much better off right now. (if it is useful to anyone else, you can download it here, and here is part b showing how to use the solver function.)

I got the school to get them google app accounts, and we can now use collaborative software that is being taken up by companies like the BBVA bank, as well as learn skills that will serve them in the rapidly changing world, and try to give them tasks that will make them question things and look at data carefully like here (downloadable), checking if hollywood salaries for actors are sexist. (short answer: yes, they are.)

I don't know if they appreciate my work.  One student looked at the "hipoteca" (mortgage) example and said, "When are we ever going to need to know anything about that! We should do something useful."