Google Maps Street View
Another pretty amazing option in Google Maps. You now have the “street view” option in addition to map, satellite and hybrid views.
This view appears to be a real street level view of the city’s streets that you can advance incrementally (using the arrows you see). Talk about a great way to give your students a view of a particular novel or historical location. It appears to be just major cities right now but it’s pretty impressive.
So the folks over at Google Blogoscoped had a great idea. Use Google trends as a writing prompt. For instance, if the top queries are … 1. subaru impreza 2. priyanka chopra 3. build a bear … and so on … … then your narrative may go like this, to quote from Simon’s try: I went out and bought a brand new Subaru Impreza last week, which was very scary as I have only just passed my test. I took Priyanka Chopra, the Indian film star, with me to keep an eye on me and exert a calming influence as I was pretty nervous because the Impreza is wild beast of car. “Let’s go build a bear”, I shrieked as we weaved through traffic, “an actual live bear that will do our bidding”. “Good idea,” agreed Priyanka, “This bear could drive us around too, anything would (and so on) … Morphs pretty well into a fun writing prompt that uses subjects that are, by definition, things people are interested in. Ways to take it to the next level- write the zeitgeist as a character or historical figure use the words to take the pass the sentence game to the next level see who can make the longest sensible sentence with the fewest additional words (not listed in the trends list) […]
Image from page 93 of “Elementary and dental radiography” (1813) flickr photo by Internet Archive Book Images shared with no copyright restriction (Flickr Commons) This is the blow-by-blow documentation of a failure of sorts. Nothing makes me angrier than failing to deliver on something I said I could/would do. I ended up delivering what was needed but the way I had to do it was ugly and time-intensive. All of this happened because of two things- insufficient initial testing and not enough knowledge on my end at a couple of key steps. I’ve got lots of ideas I need to test out now that I’ve learned a few things the hard way but I thought it’d be beneficial to see how I tried to think through this thing when various paths failed . . . and with that welcome to my postmortem. I thought we had the Social Work Google Docs Digital Portfolio thing figured out. I even wrote a blog post. Events coalesced to remind me that I do not know enough stuff. However, I do intend to learn from painful mistakes like this and give you my tears and frustration for you free of charge.Edification or amusement are optional. Initial tests felt a bit slow but nothing too bad. Google Scripts will timeout after 6 minutes but I […]
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 […]