Party time – tissue paper flowers

What??? Are we on the Martha Stewart blog? Hey I’m a multipurpose librarian and somehow I got a tissue paper flower kick, and now I have to make them for a lot of library parties. It’s OK, as it’s cheap, easy and fun.

You need:

  • Tissue paper in colors appropriate to the party in question. Tissue paper is available at Wal-Mart and hobby/craft stores
  • Scissors: straight, or pinking for zig-zag panache
  • Pipe cleaners (fuzzy wires), green or other colors – available at Wal-Mart and hobby/craft stores
  • Gold metallic ribbon (optional)
  • A large flat surface to work on, a clean floor/carpet is fine.


  1.  Cut the tissue paper into large squares, or rectangles whose proportions aren’t too far off from a square. I usually cut large sheets of tissue paper into quarters, several sheets stacked at a time. Don’t worry about ragged/uneven edges.
  2. Stack 4-5 sheets in a pleasing color sequence.
  3. Accordion-pleat the stack of sheets together, folding one way then the other, pleats about 1/2 inch each. Don’t fold the creases too hard.
  4. Find the middle of the pleated stack and pinch it slightly. Take a pipe cleaner and wrap one end over the top, then twist the end of the pipe cleaner around the other side.
  5. Cut inverted V’s on either end of the pleated stack. At this point you can trim any ragged or uneven edges.
  6. Cut a 6″-8″ length of ribbon and slide it in between the middle pleat on one side of the pipe cleaner, until it comes out enough on the other side that you can pull the ribbon out half way (so the ribbon ends are even). Tie the ribbon in a simple knot. Tightly curl both ends of the ribbon with scissors. You could tie two ribbon lengths to add more curls to the middle of the flower. The curled ribbon looks like stamen or other central flower parts, and hides the pipe cleaner when viewing the flower head-on.
  7. If you have to transport the flowers to another location, leave them like this until they arrive at the intended destination. Unfurled tissue paper flowers are fragile and don’t travel well. Short distances (one room to another) is fine if you gently place them in a box and push the box on a book cart.
  8. Unfurl the petals. Gently fan out the pleats. Then starting with the inner most layer, begin pulling out very gently. I usually pull the first one out pointing forward and making the two halves overlap; the next two sheets are pulled out somewhat but petals curled back moderately; the last one or two sheets curled away. While doing this, arrange the curled ribbons so they’re in the middle of the flower.
  9. Use the long pipe cleaner “stems” to tie down to objects, to create bases, or tie flowers together.

If you’re having trouble visualizing this, try YouTubing tissue paper flowers. I came up with the ribbon bit on my own, but I’m sure others have thought of it before.

Cutting the tissue paper flowers can result in a mess of little paper pieces, so you may want to select a sheet of tissue paper in a color you don’t need, and do all your cutting on top of it. When you’re done you can roll up the sheet with all the little bits inside and dispose of it in one fell swoop.

We have been throwing Cinco de Mayo parties for our student workers every year for the past few years. To make flowers for this party, I use bright colors that go well with the Cinco de Mayo decorations we buy from Party City. The flowers make good table centerpieces. Last year a student tied one in her hair.

The Cinco de Mayo parties are very popular with our students. In addition to catered Mexican food and potluck contributions from the staff, we have a pinata filled with candy and kiddie party favors. Since we started doing Cinco de Mayo for the end-of-year student party, it’s been so popular we haven’t wanted to change the theme.


VM Hosting with Linode

Disclaimer: This is not an ad – I don’t own stock in Linode and I’m not getting a discount.

I wanted to have my own full-featured VM (Virtual Machine) to muck around with. After a misstep or two, I decided to try Linode  (short for Linux Node) and I’m very happy with it. You have your very own Linux machine to play with, in fact you can pick from a large selection of Linux distributions. The documentation is great and so is the technical support. I can use this as a portable Python machine for work (since I can use it from the Reference Desk via PuTTY), for learning, and also for personal stuff like mucking about in Drupal. At $19.95 a month for the basic setup, Linode is a pretty good deal.

If you have ambitions of becoming a Systems Librarian some day, you really ought to be familiar with Linux, UNIX or similar systems. Part of being a Systems Librarian is being a SysAdmin, and the Systems tend to be of the UNIX-flavored variety.


One of my life-long, serious faults is procrastination.  That should be qualified with adding that I mostly get the important stuff done on time, but often wait until the last minute. I pay my bills on time, authorize time sheets before the deadline, etc. Seems like it would be better to be super-organized and not feel anxiety about last-minute tasks.

Here’s a Lifehacker post on procrastination. I like the Pomodoro technique where one sets a timer and does work until time is up, then you take a break as a reward. I think the real point is that you’re distracted from anxiety and pressure with the timer, allowing you to get some work done as you get past emotional blockages or whatever’s obstructing you.

The Lifehacker article mentions apps for blocking distracting websites like Facebook, which can serve as easy ways to procrastinate. I’m not a Facebook addict so that wouldn’t work for me. However I must admit the constant email notifications can really throw me. Especially when I’m transitioning to another task and an email pops up that I want to reply to — after I hit send, I’m left with that “What was I doing?” feeling. Maybe I should turn off email notification in Outlook?

This Chronicle of Education article on structured procrastination is also interesting. The author recommends setting up some long-term task as the one to concentrate procrastination on, so the shorter-term jobs get done.

I really should try to implement one or more of these strategies but I have to check my email …

Trying to understand RDA and FRBR

Library folks, including myself, have been attending group Webinars from Lyrasis on RDA. The latest one was this morning.

Firstly, the classes are held at such a time that because of time zone issues, here in Colorado they usually start at 8 AM. Some of the organizing librarians have gracefully provided bagels and coffee. Hey Lyrasis, you’ll be in trouble if you start expanding into the Pacific time zone!

Secondly, I am finding RDA rather confusing. Back when I was in library school when RDA was still on the distant horizon, it seemed like it would be a radical change from AACR2. But now it mostly feels like a lot of tweaking to AACR2.  And some RDA chapters aren’t even written yet! We wondered if philosophical verbiage was just being larded onto the traditional MARC structure.

Maybe the change isn’t that radical because we’re still tied to MARC format? What will happen with the proposed Bibliographic Framework?

Another point of confusion is the FRBR terminology of Entity, Work, Expression, Manifestation and Item.  The  teacher for this Webinar series, Christee Pascale, is a good speaker but she breezes through with these terms and after awhile it starts flying over our heads.

Here’s a helpful LIS Wiki page on the subject:

Here are a couple of possibly helpful resources from Library of Congress:

What is FRBR?  A conceptual model for the bibliographic universe / Barbara Tillett

FRBR Quiz 1: FRBR Terminology

If you really, really want to know more about the background leading up to FRBR, here’s a book chapter on the history of cataloging. “FRBR and the History of Cataloging” / William Denton from Understanding FRBR: What it is and How It Will Affect Our Retrieval Tools. Ed. by Arlene G. Taylor. Libraries Unlimited. 2007.

Excel file import tricks for the file-weary

If you work a lot with library title lists in Excel, you may have noticed a couple problems in the course of using the Import Wizard:

  • Diacritics get mangled, requiring multiple “find and replace” runs to fix the mess after the fact. Unless, of course, you remember to switch from ANSI to UTF-8 on the first screen of the Import Wizard.
  • Long ID numbers get turned into scientific notation, losing their uniqueness and thus their value. Also ISSN numbers beginning with “0” may lose their leading zero. A holding statement of (1990) may translate into -1990. It’s a real pain to click on each column and select Text individually.

It turns out you can at least set Excel to default to UTF-8 (Unicode) and there’s a quicker way to turn all your columns into text format, eliminating the annoying treatment that Excel does to number-like strings that aren’t really just plain integers.

Set the default character coding to UTF-8: (this worked for me on Excel 2007. For files where you get gobbledygook in UTF-8, change it back to ANSI).

STUFF: MISCELLANEOUS TOPICS ALL VAGUELY RELATED TO SCIENCE by Luke Miller. Change default text import origin type in Excel.

(Not for the faint of heart if you’re afraid to change registry values!)

Quick way to turn all columns into text while in the Import Wizard:

Allen Wyatt’s EXCELTIPS (Ribbon Interface). Faster Text File Conversions.

Basically, when you’re on the column screen, click on the first column while holding shift, scroll the columns all the way to the right so all the columns are highlighted, then select Text as the column data format.  If you have some “real numbers” you can always change them back later.

“Introduction to Database Concepts” part 1: The Four Steps of Database Design

In my previous post, I mentioned why it’s a good idea to freshen up on database concepts and recommended the first chapter of a Springer ebook, Pro SQL Server 2008 Relational Database Design and Implementation.  Louis Davidson,  Kevin Kline,  Scott Klein,  Kurt Windisch. 2008. Springer. ISBN: 978-1-4302-0866-2 (Print) 978-1-4302-0867-9 (Online).  So far it’s a very readable book with great real-world examples and a sprinkling of humor.

Chapter 1: Introduction to Database Concepts.

It’s recommended that one design a database with a proper understanding of the underlying concepts, despite urgent calls to come up with a usable product right away.

Database Design Phases

Consider future data needs. Plan carefully at the outset to avoid difficult changes and maintenance down the road.

Steps of database design process as defined in this book:

  1. Conceptual
    The conceptual phase is the high-level discovery and analysis of the entities and business rules involved with the data under consideration. This is where you determine your high-level data requirements.  Note that no tables or other practical database structure is designed in this phase.

    • Entities are the “People, places, and things” (p.4) required by the design. They are usually nouns. In the library context entities might be users, library locations and items in the catalog.
    • Business rules can be thought of as processes and rules of operation, such as the definition of specific user groups and their renewal periods, or the format of the ISBN.  Business rules can be very detailed or very broad, or anywhere in between. Conditional rules are possible; these may have to be implemented outside of the database itself.
  2. Logical
    The logical phase is where the designs from the conceptual phase become a blueprint. There is still no detailed tables or any practical database design in this phase.The following are defined in this phase:

    • Entities. “People, places and things”. Examples: patron, book, library branch.
    • Attributes for each entity. Attributes are qualities of the entity. Examples: patron name, patron type, patron ID.
    • Normalization (explained later in book)
    • Candidate keys. Candidate keys are potentially unique attributes of instances of entities. Keys are how the database accesses specific instances. Examples: patron ID, ISBN number.
    • Relationships and cardinalities (explained later in book)
    • Domains. The datatype for each attribute, and whether the data must be present or NULL is acceptable.
  3. Implementation

    This is where the rubber hits the road — the information from the previous phase is applied to a platform-specific database with data types, tables, constraints, and triggers. One should not stray far from the original design, data and integrity constraints that were defined in previous phases.Database security is an essential part of implementation. DW notes that most relational databases are used with SQL, which is vulnerable to SQL-injection attacks. Do not allow for damaging or embarrassing hacks by leaving the back door open.

  4. Physical

    The so-called physical phase is where consideration is given to physical storage methods and for performance-tuning. In the case of VMs (Virtual Machines) and the Cloud, one may not worry too much about physical storage space, but performance may still be an issue.

Learning about relational databases

In the course of looking for information on data cleaning and data structure, and not getting much out of the Introduction to Database Management course, I found that the first chapter of this Springer ebook looked promising.

Pro SQL Server 2008 Relational Database Design and Implementation. Louis Davidson, Kevin Kline, Kurt Windisch. Springer, 2008. ISBN: 978-1-4302-0866-2 (Print) 978-1-4302-0867-9 (Online).

You’re probably asking yourself, why should an ordinary non-Systems librarian concern herself with databases? And how can this software-specific book from 2008 help?

I’ve been gradually coming to the conclusion that librarians, at least ones involved with technical services and electronic resources, should have some passing knowledge of data and how it is commonly structured for the following reasons:

  1. Understand the underlying workings of the ILS, of most Web pages and apps, software in general.
  2. Structure data and accompanying workflows in a mindful and enlightened fashion.
  3. Better understand and communicate with I.T. folks.

Number 2 is foremost in my mind lately, pondering how to flesh out consistent, efficient, updated workflows. Also, if I want to delve more into Python again, could I make use of a relational database to, say, manage SUSHI input?  Even though we may all be heading down the path to nonrelational datastores (NoSQL) like Redis, it is useful to examine how data is traditionally structured. The higher level aspect of design is especially interesting to me.

As to this particular book, Chapter 1: Introduction to Database Concepts is just what it says, and a good one at that. In my next post, I will summarize the first part of the chapter.

(Non) adventures in data cleaning

One of the biggest repetitive headaches in my job is matching and manipulating title lists from various sources such as the ILS, link resolver, and vendors. These lists have different columns in different places, and the titles are often spelled out differently from list to list. When you are trying to determine if you have the correct title list in one system by comparing with another title list, it gets really hairy, really fast.


  • Initial articles (The, An, A, etc.)
    The Journal of Something Something vs. Journal of Something Something
  • Ampersand and “And”
    British Journal of Flotsam and Jetsam vs. British Journal of Flotsam & Jetsam
  • Acronyms
    BFG: Big Frilled Gar vs. Big Frilled Gar vs B.F.G. vs. BFG
  • Punctuation
    BFG: Big Frilled Gar vs. BFG : Big Frilled Gar vs. BFG. Big Frilled Gar
  • Proceedings and ConferencesProceedings of the Association of Silly Walkers vs. Association of Silly Walkers: Proceedings

Today I endeavored to find books, articles, websites, or anything that might shed light on theory and best practices. Unfortunately I couldn’t even find the right terminology. “Normalization” doesn’t mean the same thing in the computer world as title normalization might mean to a librarian. After Google failed, I tried some targeted searching but didn’t find much (Code4Lib, Stack Overflow, LISTA with full text). “Data cleaning” for the business world entails cleaning up your customer list, such as addresses and names.

Well here is the most helpful thing I’ve found today, and it’s only practical tips in Excel, but something is better than nothing:

Top ten ways to clean your data (in Excel) from Microsoft

I have done a lot of data manipulation in Python, both with codes attacking csv or tsv files and on-the-fly IDLE stuff. Well you can do some of it in Excel. I still think the string slicing in Python is more efficient though. More on this subject later!

Self-education for free (or cheap)

Feel like you need to brush up on, or learn completely new areas? In this era, librarians have many tools for self-education. To learn more about a subject area you’re liaison to, or to learn a programming language, or be able to understand what your colleagues are talking about, or computing concepts that would help you do your job better, the following may be hepful. (and maybe lead to more lucrative positions/promotions in the future?)

  • Books and ebooks through your library
    • Don’t discount the availability of learning materials that you can access right now through your place of employment (print and e books) or public library. I have found a great source in our Springer e-books collection, and also the “Very Short Introduction to …” print book series from Oxford. Interlibrary Loan is always an option.
    • One caveat: computer-related books tend to go out of date quickly as new versions of software are released, so try to get the most recent editions and be prepared for occasional glitches when something doesn’t work quite right because you’re using a different version than the author(s) did.
  • MOOCs and other online learning systems
    • MOOCs (Massive Open Online Courses) by Coursera, and many others are providing classes that are either ongoing scheduled classes or self-directed learning. These are typically free and unaccredited options that you can try without much investment or consequence if you don’t like a particular class. I initially signed up for a Coursera class on Algorithms but quickly found it was too difficult and out of my league (and too theoretical). I am about to sign up for a Saylor class on databases — if it’s too advanced, I’ll opt out. No harm, no foul, no money lost.
    • For self-directed online learning on computer-related topics (without the homework or exams), try and CodeAcademy.
  • Take a “real” class.
    Does your institution allow you to take classes for free or cheap? What about local options? What about departments you liaise to — can you sit in on a professor’s class for one semester? (Clear that with your boss first!)
  • Rampant Googling and Wiki-ing.
    There is no reason to be confused about terms or concepts when you can pop them into Google or Wikipedia and Read All About It. When in conversation with people who are talking in technical terms that I don’t understand, I try to make written or mental notes and look up the mysterious stuff later. For my learning style, this can help me gain at least superficial understanding and create a foundation for deeper learning later on. [Use your information literacy powers to determine if you’re reading credible sources.]
  • Educational videos.
    Khan Academy and others have many free educational videos on the web, why not take advantage of them? The ubiquity of comments helps with information literacy concerns, as you will note if somebody has left out something of import.Incidentally if you need to learn anything “mundane” from how to crochet to how to chop an onion efficiently, YouTube probably has several dozen videos on the subject.

New York Times article on dubious Open Access journals and fake conferences

Scientific Articles Accepted (Personal Checks, Too)

Gina Kolata. April 7, 2013.

” … some researchers are now raising the alarm about what they see as the proliferation of online journals that will print seemingly anything for a fee. They warn that nonexperts doing online research will have trouble distinguishing credible research from junk …”

See Jeff Beall’s Scholarly Open Access blog for more info.