A Little More Wordle and Poetry

Well, you know how I love Exhibit and I’m also a poetry fan. So after messing around with it some the other day and seeing some interest from a few people who put in their own poems- I decided to see what other poems might be on there and see if I couldn’t display them in an interesting way. Go mess with it. Add your own wordle poem if you’d like (the css in the embed code will likely mess things up temporarily but I’ll fix it). Now, if I had a class1 I’d get a bunch of these done for a number of poems from the same author and probably the same genre. Then you could sort them by author or genre and do a surface analysis. Do the big words matter? Are the “big words” shared between poems, across authors? Does it matter? Where things could get interesting is creating fake Wordles that do represent the words you think matter most2. Students would falsely elevate the number of words to make them larger regardless of occurrence. Then the explanation of why becomes an interesting conversation- especially when comparing the two. 1 or more free time 2 Oddly, most of my favorite lessons involve faking data, rap, animal attacks or, hopefully, all three

Stepping Up: Non-Programistan/Non-HTML Exhibit Page

Ben called me on the fact that Exhibit really was too much for most teachers/humans. It seems no one wants to know HTML these days has ever wanted to know html. So my “no programming” claim was weak and as a true patriot of Non-Programistan I had to step up. Here is a spreadsheet where you can put in some basic fields. It builds you the Google Spreadsheet headers (you have to cut and paste them in) and with a little simple work on your part in the spreadsheet the HTML is made for you. You have to cut and paste it into a text editor and save it as html. I made this page with it. Now, this version if fairly rough but it works. The whole thing is limited and will only do the sortable table view but it’s a decent start. There’s a lot you could do to expand this to allow mapping, time lines etc. as Exhibit is built to be modular. I might have to learn enough programming to make this work in a web interface some day. Step 1 You put in the data types, headers etc. you want. Step 2 After pasting in the URL headers into a Google spreadsheet you publish it and copy the XML feed and paste it into the […]

Google Forms to Exhibit Example (POC)

So, I’ve managed to create two quick websites for work that are driven by Google’s new form option for getting data into spreadsheets. I’ve put a quick example of a log here. Feel free to enter data etc. It’s up there to play around with and hopefully is simple enough to help people figure out how to do it. One thing I don’t like about the form option. I don’t like that changes I make to the submission form alter my spreadsheet. I might want the form to read “Your name here” while my spreadsheet says {name:text}. I don’t believe there’s any way to do that and it would be much nicer when using this with Exhibit. Instead I have to add another sheet and I use a formula to reference the data in. It’s just =sheet1!A2 in case anyone needs it. Then if I get my mouse in just the right place it turns into cross hairs and I can drag that formula dynamically so that it pastes as =sheet1!A3 and A4 etc. then I can drag it across to create =sheet1B2 etc. That is much better than typing all that in. In a perfect world I’d also be able to apply some css to it but that’s getting a little picky. So the key steps. create spreadsheet and […]