« January 2015 | Main | March 2015 »

Survey Results in Google Forms

Survey2I learned something new last week! I have been helping Corey Baumann, Delivery Coordinator, create a survey to evaluate their services. If you haven't taken it already, you can take it here until March 10.

We were looking at the spreadsheet and trying to figure out how to best analyze the results. Over 100 of you have already taken the survey so the spreadsheet is huge and awesome! 

Then, we were looking at how to close the survey on March 10 and I saw "Summary of Responses." Could it be? Had I really not known this existed all this time? So, I clicked on it and was amazed with the results. Here's one screenshot from the results so far. Isn't it pretty? 

SurveyResults

 

Can I use that picture of a cute kitten?

cute kitten
This one lives at my house and gave me permission to share her cuteness!

It seems like lots of people have questions about using images on their website, blog, or newsletter (I know I do!).

Where can I find images?
How do I determine what images can be used?
How do I properly credit images?

TechSoup for Libraries has some great posts to help answer these questions and many others!

Open another instance

Taskbar

Easily open a new instance of a program by holding the shift key and clicking the program icon on the taskbar. Great for comparing or copying data between documents!

Design ideas for web images

Unity/Harmony, Composition, Message

As you're staring at a blank canvas in your graphics program of choice, getting ready to design an image for your library's website, do you ever stop and think, "Wow, this is not what I went to school for!"?* Even if your main business is libraries, employing a few design principles will give patrons a better website experience and help "sell" library programs, online resources and collections, and digital services.

Effective visual communication is more than just following a checklist, of course, but you don't have to be an expert to use these design ideas:

Unity/Harmony: Develop a style for the website that includes a limited color palette and a selection of 2-3 versatile, easy-to-read fonts. They will be a foundation for your composition and message rather than a competing distraction from it. (They'll also be a jump start if you're uninspired or in a hurry—some of the decisions are already made.) Examples: Fayetteville Public Library, Salt Lake City Public Library.

Composition: Will you use photos, clip art, or other illustration? Use careful judgment with clip art. If the piece would work nicely in an elementary-school book report, it doesn't belong on your website. When building text into your images, look for pictures with a little space built in, or leave room in a collage of images for adding words. Blank space gives an uncluttered feeling and focuses attention on the details that matter. Examples: Brantford Public Library, Mid-Continent Public Library.

Message: Keep it short—not too many words—especially if they will appear on a small button or a slideshow image rotating every few seconds. In all writing for the web, use a tone that is fun, friendly, and professional, and be sparing in your use of all-caps and exclamation points. Examples: Multnomah County Library, New York Public Library.

Also recommended:

* If you actually did go to art school, I hope you'll weigh in with your thoughts on design for library websites.

Arduino Kit in a Briefcase (with Harder to Lose Pieces)

The Arduino micro-controller has been around for a while now and has become the default go-to for electronics and programming education and Maker projects.  One of the big downsides of Arduino kits has been how easy it is to lose the many little components that come with the kits.

Thanks to Dan Alich, a high school math teacher from North Carolina, that problem is solved with DuinoKit:

DuinoKit-Essential-Project-1

With DuinoKit, the majority of the components are soldered directly to a board, reminiscent of the Radio Shack electronic kits from the '80s, making it nearly impossible to lose all those buttons, lights, and resistors. The whole kit comes inside of a fancy aluminum briefcase and also contains documentation for a number of projects to help you get started.

Computer for programming the Arduino sold seperately.

Website: duinokit.com

Sort by color in Excel

Sort by colorI sort Excel data by value all the time - alphabetically, numerically, and in ascending and descending order.

I also love to to color code cells for a quick visual cue--- so, how did I not know that sorting by cell color is also an option?  (Thanks, Cindy, for cluing me in!)

Here's how:

  1. Select the range of cells you'd like to sort
  2. On the Home tab, select Sort & Filter -> Custom Sort...
  3. For "Sort On", select Cell Color

Sortoptions