Work This Week – Week 1

Since I’ve been falling off on my weekly photo posts, I figure I’ll start a weekly work series. While that doesn’t seem to make sense . . . it does. I am really bad about keeping track of the good things, the progress, the little bits that add up. I am very good at looking at large, looming disasters. I’m hoping that documenting progress will help convince me that I am making progress, that I am doing small things to help people do a bit more. VCU Qatar – Online Art History/Museology Courses This is part of three online courses being created to help teach art history and two other arts/museology related courses for VCU Qatar. My role in this is more of a consultant (web design is being done externally by CHIPS NYC1) but I’ve built a few things to help get us past (or into) some sticking points. I used one of the HTML5up templates to make this super quick example. I’m not thrilled to have a white guy doing the video but it was the highest production value I found after a quick search (that might be shaped by having to use English). The text is from one of the professors although I chopped it up a bit. There’s the ugly start to a Timeline JS project […]

13

Weekly Web Harvest for 2016-11-06

Episodes – Do Not Track Young Adolescents as Likely to Die From Suicide as From Traffic Accidents – The New York Times It is now just as likely for middle school students to die from suicide as from traffic accidents. That grim fact was published on Thursday by the Centers for Disease Control and Prevention. They found that in 2014, the most recent year for which data is available, the suicide rate for children ages 10 to 14 had caught up to their death rate for traffic accidents. ————— The immediate lunge into blaming social media seems like it needs more factual/research support. Spanish parents urged to put children on weekend homework strike | World news | The Guardian Parents in Spain are being urged to go on a weekend homework strike this month in protest against the “unacceptable” amount of after-school tasks their children are given. The homework load of Spanish children has long been a sore point with some parents, who argue that the burden is too great, places too much pressure on pupils and eats into family time. According to a 2012 study by the Organisation for Economic Co-operation and Development, Spanish 15-year-olds have 6.5 hours of homework a week compared with an average of 4.9 across the 38 OECD countries. Nothing To Do With Arbroath: Mystery […]

06

Weekly Web Harvest for 2016-10-30

Wiki Education Foundation – Wiki Education Foundation » BC Open Educational Technology Collaborative Of Course Westworld’s Costumes Are 3D-Printed, Too – Racked With the exception of some places in Italy or maybe England, you honestly can’t find beautiful, intricate fabrics anymore. It’s really sad! So we had to hire 3D printers in Los Angeles to reprint all our vintage fabrics so we could have more — and then beg them to work around our crazy TV schedules.

30

Weekly Web Harvest for 2016-10-23

Of Course Westworld’s Costumes Are 3D-Printed, Too – Racked With the exception of some places in Italy or maybe England, you honestly can’t find beautiful, intricate fabrics anymore. It’s really sad! So we had to hire 3D printers in Los Angeles to reprint all our vintage fabrics so we could have more — and then beg them to work around our crazy TV schedules. Vine star Logan Paul profile – Business Insider A source close to the stars went so far as to say it’s a combination of living on Vine Street and the re-Vine tool — not necessarily talent — that keeps these stars on top. “You literally have the top 30 Viners creating what is nearly all of the content that is being viewed on Vine,” he said. “And all they do is just help each other get bigger and bigger. It’s not a democracy,” he adds. “Probably for a lot of people who want to do cool things on Vine, it’s discouraging.” Found Objects & Focus on the Details: A Look at Sculpture Artist Nemo Gould’s Upcoming Solo Show | SF Station – San Francisco’s City Guide Each piece is a feat of engineering with many moving parts, lights and little secret components—rewarding tidbits for observant viewers who are also willing to take their time and go in for a careful look. […]

Making Google Scripts & Google Sidebars Talk

flickr photo shared by Internet Archive Book Images with no copyright restriction (Flickr Commons) Sometimes you want a Google Sidebar element to be able to pull variables from a Google Script. The key element is google.script.run.withSuccessHandler. I’m still not entirely sure I have this in my head deeply/correctly but this is functional and might help someone else (even if that someone is just me at a later point in time when I’ve forgotten this). This one sets some default times based on spreadsheet variables stashed elsewhere and then automates some date/time entries using the form sidebar. Sidebar Code Google Script Code The entire sidebar/script setup is below in case anyone cares for some reason. Pick Your Date Start/End Times Start: End: Hide Previous Dates Submit

Interactive Google Sheets Dashboards

It’s pretty easy to put a bunch of data and charts in a spreadsheet and call it a dashboard. It became a more interesting challenge to make those charts change to reflect variables chosen via dropdown cell menus. The key it turns out is using =query. I can do some really powerful things with query and as long at the data bounds (columns/rows) are the same, I can change the content and it’ll replicate in the chart assigned to those columns/rows. For instance, I can have raw data on a sheet called data. I can use query on that data on another sheet with something like =query(data!A1:N,”select B,C,D,E,F,G,H,I,J,K,L,M,N where A=”&”‘”&A2&”‘”) That formula is going to the sheet named data and querying cells A1 through N(whatever the last row is) and selecting columns B through N where the content of cell A matches the text of cell A2 on the local page. As a result we can manipulate the contents of cell A2 and change the data being returned. In this case I did a little data validation drop down to restrict it to the three items for which we have data. Do take note that for numbers I could have just appended the cell reference (&A2 in this case) but because it was a text match I had to staple […]

23

Weekly Web Harvest for 2016-10-16

Infinite Jukebox for Make It Funky by John Lee Hooker fun tool h/t John Freyer WordPress Without Shame Ultimately, as a director, I am obligated to consider all the technologies that can help our client achieve our goals—including the old, boring ones. Enter WordPress. Monday Night Raw To Host Presidential Tables, Ladders, and Chairs Match —ouch. The school also plans to host various social media workshops focused on teaching people how to effectively communicate via social media. These seminars will cover subjects like, do’s and don’ts of Facebook (with an emphasis on posting “like a mom”), what all the five primary social media outlets are and how to tell the difference between them, and why no one likes rampages.

Spreadsheet Karma

=QUERY({C:C,C:C},”select Col1, count(Col2) where Col1 ” group by Col1″,1) This is just so handy for getting all the unique values from a column and spitting them out with the counts of their occurrences.1 I can’t tell you how many times I’ve done this a much harder way. I saw the function above as an answer after I’d responded to a Stack Overflow question about getting unique word counts. Just another little example of how doing things in the open and being involved in communities ends up benefitting you in unexpected ways. flickr photo shared by New York Public Library with no copyright restriction (Flickr Commons) 1 If you data isn’t in column C, just change it to the right letter.

16

Weekly Web Harvest for 2016-10-09

Monday Night Raw To Host Presidential Tables, Ladders, and Chairs Match —ouch. The school also plans to host various social media workshops focused on teaching people how to effectively communicate via social media. These seminars will cover subjects like, do’s and don’ts of Facebook (with an emphasis on posting “like a mom”), what all the five primary social media outlets are and how to tell the difference between them, and why no one likes rampages. Chrome Music Lab Some fun stuff Avoid “Culture Fit” If You Want Innovation – The Creativity Guru “that human-resources staff, when considering recent college hires, ranked cultural fit above a candidate’s referrals, coursework and grades.” (If you’re not white and male, this probably isn’t a surprise. And you’re probably not excited by the idea of playing a spin the wheel game, with three white guys, in a pit full of balls.) _____________________ Your work is meaningless. Your grades don’t matter. Just agree with us on stuff. Also I would not enjoy playing spin the wheel in a ball pit with three white guys. Officials confirm 4-year-old Rebecca Lewis found safe in Memphis; West Hogs in custody Polk County Sheriff Grady Judd of Florida has a message for the suspected kidnapper, who legally changed his name to West Wild Hogs from Matthew Clark Pybus: “Don’t you hurt that […]