In the end your smartphone use is helping to build up a picture of who you are and the kind of advertising you're interested in for companies like Google, Facebook, and others -- even if an app isn't part of a massive advertising network, it may well sell its data to one. Apple stands apart in this regard, keeping the data it tracks for its own use and largely on a single device, though of course the apps that run on iOS have more freedom to do what they want. Even if you're reasonably content to put up with some monitoring on Android and iOS, it's important to know what kind of data you're giving up every time you switch your smartphone on. Whether it means you uninstall a few social media tools, or disable location tracking for a few apps, it gives you some semblance of control over your privacy.
I have been getting on the GAS and am thinking that QUERY might be a part of my solution. I am therefore trying to get everything working in Sheets first. I have followed your guide to QUERY, even adding in two dynamic selectors (is that what they are called?) that I got from your work on VLOOKUPS. My question is filtering by dates. I have followed your instructions for filtering between two dates:
=QUERY(Data!$A$1:$H$136,”select C, B where B > date ‘”&TEXT(A1,”yyyy-mm-dd”)&”‘ and B <= date ‘”&TEXT(B1,”yyyy-mm-dd”)&”‘”,1)
But fear that I maybe limited as I have recorded my dates using DD-MM-YYYY. Sheets recognises this as a date as a formatted the cells as ‘DATES’. My spreadsheet settings have also been changed to ‘Australia’. I am wondering if you have any thoughts or suggestions on this? Here is a link to my sheet.
I was a Google Educator before they changed the program, but my credentials have since lapsed. I could justify completing the credentials as it is a core part of my current work. However, I have concerns about ticking a box. I prefer to use my time to develop my own capacity myself, documented in my monthly newsletter. I think that Rafranz Davis captures some of the issues too.
In regards to the influence of Google, I am more concerned about the influence of GAFA, FANGS or whatever acronym you choose to use. I am happy to support teachers where they are at. I have written about Apple, Adobe and Microsoft. I have also written about open software and managing my own domain. In regards to disclosure, I would like to think that I am transparent, but I guess I could always do better.
What I think is worth writing about are things in your day that nibble at your attention. That make you pause, ever so briefly.
I think sometimes I forget this. Interestingly, Kin Lane shared something similar lately to:
It would KILL ME to not be able to tell stories. I need storytelling to do what I do. To work through ideas. It is how I learn from others.
You have both reinvigorated me to stop worrying and just get back to sharing and storytelling.