Systems Librarian Job Interview Questions

This, to borrow Jenny Lawson‘s phrase, ‘isn’t a real post’ because I’ve been busy preparing for a very important interview, but I wanted to share a few thought-provoking interview questions I came across this week. What do you think, how would you answer them?

  1. Whats the next big thing in library technology?
  2. If you had a magic wand that could resolve one library/technical issue, what would you fix?
  3. What motivates you to come to work?
  4. What kind of library best attracts patrons to use it?
  5. What makes an ideal librarian?

I ♥ TED

I was introduced to TED (Technology, Entertainment, Design) in one of my first library school classes. We watched a TEDTalk (‘Jimmy Wales on the birth of Wikipedia’ on the all-volunteer nature of the website and the implementation of fact-checking) and I thought it was wonderful that a place exists where free access is given to intellectual presentations and discussion. There is an impressive array of lectures available on the site, but until recently the TED community has been somewhat limited. Two things developed recently that I hope will improve the site’s visibility:

1. TEDTalks for Netflix! I was browsing movies a few weeks ago only to be pleasantly surprised at finding a number of TEDTalks added to the instant library. I found 14 categories with 12 to 20 talks each, opening up the possibility of enjoying a lecture from the couch rather than uncomfortably at a desk. Of course if you don’t have a Netflix account all of the talks are also available for free on the TED website.

2. TED-Ed. This is a new project for educators to build lesson plans around TEDTalks, or use templates that include a video, short quiz, and discussion questions. Browse by subject or choose a series to teach from.

You can also subscribe to the TEDTalks RSS feed to be notified when new videos are added, choose a theme to subscribe to, or browse videos via tags. There’s also a community of users and a forum for ideas, questions and debates (which strikes me as a Yahoo! Answers for intellectuals).

Here are a few library-related videos I found intriguing:

Brewster Kahle builds a free digital library

What we learned from 5 million books

Joshua Prince-Ramus on Seattle’s library

Chip Kidd: Designing books is no laughing matter. OK, it is.

(PS, WordPress makes it very easy to embed TEDTalks. Just find a video, click ‘Share’ and paste the shortlink [ ted id=# ] directly into your post, voila!)

Who needs a computer when I have the internet?

Today I’ve been reading up on the Google Chromebook and wondering how long it will be before it’s considered strange to need a computer that does things other than connect to the internet.

The Chromebook, which came out about a year ago, relies almost entirely on cloud computing and gets most of its functionality from online application and supplemental add-ons. Want to write up a project report? Use Google Docs and store it in the cloud. Want to upload and edit photos? Plug in your camera and upload them to your Picasa account. You can’t save files to the hard drive or install new software, but you have the expansive Google product line and the Chrome Web Store full of apps at your disposal.

Tablet use has been on the rise as well, in no small part due to the iPad and the introduction of the Kindle Fire and Nook Tablet, and these devices are very net-centric as well. Some features can be used offline, but most of their functionality requires an internet connection and they don’t have the capability to store files and software.

Chromebooks have not been particularly well received so far among consumers, but Google has partnered with school systems to provide over 27,000 laptops to students. They’ve been cited by teachers as good interactive resources with little need for technical support, and with any files the students create being stored online there’s no need to worry about transferring files between home and school computers. This could also be a valuable asset for libraries who choose to adopt the device as they have tablets.

So I wonder with the trends toward net-centric devices and the enormous leaps that have been made with applications, add-ons and online productivity, is the internet itself the new PC? There are still plenty of things that I need file systems and installable software to do, but it doesn’t seem too far off to think that in a few years operating systems will be more like browsers with bells and whistles and we’ll be computing in the cloud all of the time.

Emma the Catbot

I recently reconnected with my graduate school practicum supervisor, who’s been up to some really cool things that I’d like to share. When I did my practicum at Mentor Public Library, I had the good fortune to work with David Newyear on his ‘pet’ project, Emma the Catbot:

Click the image to check her out 'in person'

She’s an artificial intelligence-powered avatar capable of answering library patrons’ frequently asked questions on the MPL website and in the library on a dedicated computer terminal. Powered by AIML (Artificial Intelligence Markup Language, similar to XML and fun to play with) and loaded with responses to questions like ‘what are the library hours today?’ and ‘where can I find a book on space exploration?’ (for which she’ll refer you to the OPAC and a list of materials), Emma is a great tool to bridge the technology gap for patrons with little computer experience and to entertain as she provides information in a new way. I got to contribute to the project as a graduate student by creating the front-end design for the web page Emma is presented on at the library.

Recently, Emma has grown to earn her own blog and mobile app, and David is working on a new version of the software called infoTabby, for which he’s won the Polaris Innovation in Technology John Iliff Award. He’s currently doing something I can only hope and aspire to in my own career, which is creating a new resource for the librarian arsenal that has the potential to change the face of our profession. Very cool, and a project worth keeping an eye on!

If you’ve got a few minutes, go talk to Emma on the MPL website. You’ll be surprised at how intuitive she is. Don’t forget to ask her about Kaylin ;)

SQL Server 2008 Express and SSMS Install Instructions

I recently applied for a job that would require some knowledge of Structured Query Language and SQL Server, so I decided to do some homework on the subject. I got a book from the library (SQL Demystified, which is a good enough intro but leaves a bit to be desired in terms of readability), started learning about relational databases, and decided to download a free version of the software to play with. Database management is a great skill for the tech-savvy librarian to have, and besides I’ve learned new technologies from books before – everything I know about web design is thanks to the wonderful series of O’Reilly books. What could go wrong?

To sum up a friend’s take on the situation, “Why do you want to learn SQL? So you can be annoyed daily… hourly… by the minute? You are only just beginning to understand the pain of SQL.”

Immediate response: “Pssh, it can’t be that bad.”

Revised response, after spending an entire day on SQL Server 2008 download and setup alone: “Okay, you may have a point.”

Microsoft’s documentation was very poor, there were compatibility issues where there should be none, the files were confusingly named, and the installation wizard was unintuitive at best. I’ve never needed to consult two separate tutorials simply to download a piece of software before, but I won the battle and now I can begin the process of learning the language. SQL doesn’t seem so bad. SQL Server, however, seems like a formidable opponent.

For anyone looking to avoid the frustration I just endured, here’s what I found to install SQL Server 2008 Express and SQL Server Management Studio (SSMS) on my Windows 7 machine:

  1. Make sure your operating system is up to date. Go to Start > All Programs > Windows Update, and make sure the latest Service Pack is installed, otherwise you’ll get an error when you try to install SQL Server.
  2. Go here to download SQL Server 2008 Express (this is the free edition – there’s a 2012 free edition out now, but I went with 2008 because there’s more support and guidance available for the older edition).
  3. The installation wizard’s instructions are fairly self-explanatory, but there are a few configuration steps you’ll need to know to set up your network, which can be found here.
  4. If you do step 3 correctly, SSMS should be installed along with SQL Server 2008, however you can install it separately if you mess up like I did. Go here to download the file, and keep in mind that the installation wizard is exactly like the one for SQL Server 2008 – which confused me until I found this tutorial that guided me through installation.
  5. Now you should be good to go – click Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio. I had an issue connecting to the network (error code 2) and resolved it by revisiting the configuration manager from step 3, clicking ‘SQL Server Services’ on the left-hand column and starting SQL Server, which had for some reason been stopped.

The Over-Qualified Retail Employee

When I graduated from library school, the first thing I did was take a retail cake decorating job in order to pay my student loans and afford to live on my own again while I hunted for library jobs. That search has now been in progress for 18 months, and I’ve noticed a surprisingly high number of people in my situation – college graduates working unskilled positions in retail.

I’m the only MLIS holder I know of at my company, but my peers include those with degrees in computer technology, photography, education, philosophy, business and nursing. They’ve either taken jobs in retail while waiting out a bad job market and trying to find work in their field, or sought higher education after putting in time at the company and realizing that working every weekend and holiday until retirement isn’t their idea of a white picket fence. For one reason or another, though, a lot of us are getting stuck.

Some find jobs in their fields only to suffer a kind of separation anxiety, afraid to leave the retail nest where they’ve racked up time, vacation hours, and most importantly seniority, and they end up working both jobs. It’s a legitimate concern – in the time I’ve spent with my current company, I’ve earned seniority over at least five new-hire decorators. When I find my coveted library job, as happy as I will be to have it, I’ll be instantly shifted to the bottom rung, the most vulnerable place to be in a shaky economy.

Others realize in the midst of their job hunt that their degree hasn’t adequately prepared them for practical experience, and that hiring attitudes have changed from ten or twenty years ago when having a degree sometimes mattered more than the subject studied. You may have a degree in English (a-hem!) but without internships, practicums and connections you’re no more able to earn a living as a writer than if you hadn’t gone to college. One great thing about cake decorating is that anyone with a high school diploma and a willingness to learn can be trained on the job in an apprenticeship program and in just six months work their way up from the minimum wage to skilled laborer status.

Yet another hurdle in escaping retail is complacency – an issue I know very well. For the first few months, I spent my days cake decorating and my evenings job hunting. I was very serious about finding a librarian job and applying what I’d learned in graduate school; plus, decorating hurt my hand and my boss was a nightmare. Then I started to get the swing of things, my techniques improved, I learned cool icing tricks, I built rapport with my coworkers, and I liked how fast the days went when I wasn’t behind a desk. I got complacent and my job hunt slackened. Now that I’m back on my game, the going is tougher and I have to try harder to make up for it.

So what’s the result of an increasing college-educated population in retail? In a nutshell, displacement. There’s someone in the job market right now with a high school diploma and a desire to be a cake decorator, and I’m taking their place. I’ve got an MLIS and I’d love a librarian position, but there’s a more experienced librarian taking my place and waiting for a management position to open up. Perhaps the managing librarian is waiting to retire but is afraid because of the uncertainty of the economy. It all trickles down, creating a situation where overqualified people take the jobs others need, where the average number of college-educated retail employees multiplies, and we end up getting stuck. But hey, at least I can decorate a mean cake now!