Libraries Productivity

Healing in the Middle

I went to the doctor yesterday to confirm that my broken foot was healed. He showed me the X-ray and said “My diagnosis is confirmed. That’s always a good feeling.” What I didn’t know is that it was only the evidence of healing that would confirm that I really did have a broken foot. I had always assumed that unless the bone was ripped apart it wasn’t really broken, but a stress fracture isn’t that visible on an X-ray until it’s healed. He explained it more. “Do you see the blurriness here? This is messy, disorganized bone. It will eventually become smooth again, but it will take a few months.”

The metaphor of this struck me so hard that I almost had to laugh. The evidence of healing is the only way you know there was an injury. How much of life is like this? We don’t believe, can’t believe, that anything is wrong, until we come through to the other side and see that messy, disorganized growth has occurred. He also told me “Don’t try to make up for lost time. Take it slow.” This is the piece that consistently eludes me.

I finally made time this morning to read Meredith Farkas’s brilliant series on “Thoughts at Mid-Career”, which I wanted to read for some time but never did. I decided to sit down in a nice bakery around the corner from my house and just read for twenty minutes, which I spent an absurd amount of time justifying that it would ultimately make better use of my time for the rest of day trying to balance errands, an appointment, and work time. Of cour

Coffee and a plum cake for a few minutes.

se, that justification of spending that time to be more productive was pretty ironic, given that Meredith argued persuasively that that line of reasoning is unnecessary, if not damaging. The concept of “mid-career” has been on my mind a lot lately. The Midwest Data Librarians Symposium, which I attended earlier this week (after being on the planning committee even though I am not technically a data librarian) had several discussions of that idea. What does it mean to be mid-career? What does it mean if you are in a specialty that barely existed or didn’t exist when you were in library school, and you have no idea what it will look like by the time you plan to retire? Is it ok to just like your job and be in it for the next 20 years? A lot of people admitted somewhat sheepishly that they liked what they did and didn’t want to change, but felt wrong about that. I suspect that the rhetoric about “millennials are going to change jobs and careers so much!!!” means that you can sit there in your mid-30s, ten years into your same career on your third job and second institution, and think that you missed the mark somewhere. Being in the middle of your career means there is too much room for comparison.

Throughout the thought kept occurring to me that mid-career is highly contextual. You don’t actually know that you are ever in the middle of something. You can think that you are doing something for a certain period of time, and assume that you know what the middle of that will be. But the end can come at any point, or even a lengthy hiatus that puts you off track even if you do eventually return. What you think is the middle may be the high point, and that can be scary if you think there is this other thing you are “supposed” to do, especially if you’re not sure what that thing is. Being open to everything and trying to do everything so you don’t miss anything is one option. It’s often the one I choose, and the one that so many other data librarians at the conference took as well, either by choice or necessity. These are services that libraries are often tacking on to other things, and that means that all the needs are going through one person. But those “needs” are often not truly needs. Certainly, there are jobs that are all-consuming and inflexible, but not so many in academia. Rather, there is an administrative apparatus around nearly everything (and this goes for most jobs outside academia too!) that feels all-consuming and to make work rather than being based on actual needs. I don’t know that I actually believe this, however. I think everyone has their own motivations in planning work or trying to get something done, and those motivations and approaches are not all that understandable to everyone else. “Why would they do this thing that way? That is clearly an inefficient approach to a low priority project.” And it may be, but without a crisis, you end up muddling through things for a long time without stopping, and that builds up until you have the committee to study the committee for committees. I am not being facetious. There are zero institutions of any long standing who have not have had such a committee, and I wrote a whole book about this. (Writing the book is why I haven’t written a blog post in a long time, among other reasons.)

Perhaps being at mid-career means that you have the insight into why certain processes are taking place, and why people would do such a thing. I think you can continue to throw yourself into the mix with vigor that leads to exhaustion and burnout, or treat it with utter disdain and cynicism. We all know people who have gone one of these ways. I am trying to take a lesson from my third metatarsal on my right foot. The evidence of healing proves there was an injury–I wasn’t just imagining the pain or challenge–but the healing will take time. Pursuing that future carefully and thoughtfully is the only thing you can do.

coding Libraries

Summer Reading Program Form: SO SIMPLE

Last time I posted I was still months away from having a baby, now I have a four month old. Time to get back into blogging. I have some things specifically about babies and being a working mother and so on, but those will have to wait.

A few weeks ago I asked around on Twitter about creating leaderboards, but couldn’t find a lot out there that worked for exactly what I needed. I was trying to make a simple application for a staff summer reading program that would allow participants to register the pages they’ve read and leave reviews, but without a lot of bureaucracy and overhead. The main tool I found was Leaderboarded, which was interesting, but way too much for the very simple thing I was trying to do. While I could have created a form on our website using Drupal or one of our PHP forms, I figured that the much easier solution would be to use a Google Form, since otherwise it would have been very difficult for the people running the program to monitor participation unless I built an entire web application, which was overkill for a temporary program.

After poking around a bit, I found this super simple solution from David Hay at the Elk Island Public Schools (in Alberta!) Technology blog. Create a form in Google Forms that asks for a name, and then any points to which the student is entitled. Then use pivot tables with the spreadsheet to get totals, and use charts to visualize these. This was very simple, and I also appreciated his script that copies formulas to the last row of the spreadsheet as people add new entries. This of course assumes you have a unique key of a person’s name added the same way each time, which for a small group of people for a short amount of time is probably a reasonable assumption.

Here’s what I ended up with. You won’t be able to complete the form without Loyola email address (to hopefully prevent spam), but here’s what happens. Most of the time people will just be entering the pages they read last, and won’t need to add anything else. They will fill in that information, and then submit the form. But if they’ve finished a book, they can leave a review for more points. Clicking the “Did you finish a book?” radio button will take them to page 2, which is below. They can fill in author and title only, or add a review for 50 points. They also get an additional 10 points for checking the book out of the LUC libraries.



On the back end, this form records to a spreadsheet. The points are added up in an additional column I added to the spreadsheet. It adds in additional points for the challenges to the pages read using conditionals, which I’d not really used in Google Forms before. They work just as you would expect.

=C2 [pages read]+(if(J2[LUC libraries]="Yes",10[condition if true],0[condition if false])+if(isblank(I2)[review box],0[condition if true],50[condition if false))

Then I use a series of pivot tables and charts to add up the total points for each person (which we will use internally for entering participants in a raffle and determining the overall winner) and departmental points, which we will use to cheer on departments and try to make them compete against each other. To check for the individuals who are ahead, I use a pivot table with a row grouped by name with the sum of total points, and the same thing for departments. Then I made a bar graph sorted by total to make a departmental leaderboard to post on the website, which you can see here (as of publication it’s blank since the program hasn’t started yet).

Since everything is stored in an online form, the group who is running this program will be able to make edits to the form and the data if they need to, and copy the reviews out of the spreadsheet to post on the library’s blog. Very simple, and not using a database when a spreadsheet will do!




Suzanne Briet: Antelopes can be documents

In honor of Ada Lovelace Day, #LibTechWomen is blogging about one of the great early library and information science theorists, Suzanne Briet. You can read all our blog posts on Twitter using the hash tag #briet. In a shocking but not surprising turn of events, a recent textbook gave Paul Otlet credit for the one thing that everyone should be able to remember from the first semester of library school: a wild antelope is not a document, but an antelope in a zoo is, since it was collected, cataloged, and provides evidence. Unfortunately textbooks have a way of perpetuating wrong information from generation to generation, and critical thinking and research skills are woefully lacking. So, we are remembering Madame Documentation on a day dedicated to remembering and celebrating women in STEM fields.

My personal forever favorite tribute to Suzanne Briet comes in the form of a critical puppet show put on by the Self Preservation Working Group at the Read/Write Library. Watch and enjoy.