I want to sell my car on craigslist, and I want to be able to email people an info sheet. I've already created an Excel spreadsheet with mileage and other statistics, including a couple pictures pasted in. Can you show me how to put arrows and text on the pictures, and how to convert it to a pdf file?
I've been on Yahoo for a few months now. I know that I can get letters from people, and I can reply to letters people send me, but, can I send people letters too?
Of course, both of these are legitimate questions. I was just struck by such different technology experience levels from two patrons who walked up to the reference desk at about the same time.
And the answers are:
Excel's Drawing Toolbar (View > Toolbars > Drawing) allows both of these things. Click the icon that looks like an Arrow to draw an arrow on a picture, use the Line Style to make it thicker, and the Line Color icon to change the color. Then, click the Text Box icon to create a text box wherever you want words to appear. Use the Fill Color and Line Color to make sure it's legible against the picture.
To create a pdf version, we installed PDFcreator on our public computers. It shows up in the printer selection dropdown box, and creates a pdf file patron can then save to disk
Just click the "New" button in the upper left corner of the Inbox.
You may have already seen this, as it was published a few days ago (which on the interwebs is like being over 30), but it is so true that I had to share. And add XKCD to your feed reader.
I was weeding the reference collection when I came across Ready Reference : A Manual for Librarians and Students. It was published in 1984, so I flipped through it thinking the viewpoint of ready reference from 25 years ago might be humorously outdated.
I was wrong. I was 10 when this book was published, but I still use many of the resources author Agnes Ann Hede recommends.
Each chapter in the book is devoted to different types of resources, and describes the best books in each area. As you would expect, most of the book focuses on print:
I did get a laugh from the page comparisons, but it was certainly appropriate for 1984.
However, when I read the Computer section, I was amazed by how relevant it still is. There was no "computers are a difficult fad we just need to humor" mentality. In fact, the language she used is exactly what is commonly used today. She speaks of "getting into" databases, and casually refers to online searching (not on-line searching or "online" searching).
And her characterization and advice concerning balancing print and online resources is as true today as it was then:
[T]o be today's "compleat librarian," you must add to those [print] sources the increasingly abundant resources offered through computer technology.
The sad part is that this advice, 25 years later, is still not being fully embraced by the profession.
I debated, but ultimately weeded this book. As much as I liked it, it certainly was outdated, even though we do have the current copies of many of the print resources it recommends. But take a look to see if your library has this book. And weed your reference collection!
In this funny video, replace "dad" with "library patron" and it's a reference question many librarians know all too well. At least, for the first third of the video - after that, it gets kind of weird and definitely violates the appropriate library behavior policy.
An elderly patron came to the desk and asked about email. She said her grandchildren all wanted her to get an email address, but she didn't know anything about computers.
I took her over to a computer, intending to help her sign up for an email address. However, when the patron said her eyesight was too bad to read the computer screen, I decided to move to our large print workstation.
The "large print" workstation is more or less the same as our regular computers, except that it has a much larger monitor, and it has the Zoomtext software to make reading the screen more comfortable for people with low vision. The other difference is that it is located in our large print room, so the atmosphere is more quiet and calm than the computer area.
We sat down, and I fiddled with the mouse and keyboard to adjust the screen text so it was at a size she could read comfortably. At that point, I sat back and started saying things like "okay, now use the mouse to point the arrow there..." and "type mail.yahoo.com in the white bar..." I could tell the patron was understanding what I was saying, but was still having trouble.
I asked her if the screen was clear enough, and she said,
I can see the words on the screen just fine, but I can't make heads or tails of the keyboard.
It turned out, even though we tricked-out the software, we neglected to make one very important piece of hardware "large print." The keyboard was the same type we used on the regular computers, and the small white-on-black keys were just not something this patron could read.
I brought this up with the library's IT person, and she asked our Friends group to purchase a real low-vision keyboard. It took a few months, but they came through, and we have a new Zoomtext large print keyboard hooked to the large print computer.
It's kind of an embarrassing oversight - at least it was for me when I was trying to help this patron. I don't expect to be able to anticipate every need and requirement, no matter how hard we try - that's why it's important to get feedback from real patrons (and pay attention to it and act on it).
I've seen some patrons using the new keyboard, and the few I've talked to are extremely happy with it. They'd been making due with the old one, and it never occurred to them to ask for something else. I feel better knowing there is one less barrier for these patrons, but one older gentleman summed it up perfectly:
It used to be that typing was a struggle, but now email is actually fun. Or rather, it probably will be when I understand what I'm doing.