[CASL-L] April CE Workshops: Excel 2010, Publisher, Google, iCONN, Book Repair, Teaching Tech

[Abery, Kris]

The following Connecticut State Library CE workshops have been scheduled for April 2012. To register access the Connecticut Library Continuing Education Calendar of Events @ http://evanced.info/cslib/evanced/eventcalendar.asp



Excel 2010: From Start to Finish - Apr. 4th, 11th, 18th & 25th (Darien PL)

This series of four half-day classes will bring you from novice to advanced professional.



Participants will attend all four workshop sessions.

Topics include:



Session 1: Apr. 4, 2012

Entering numbers and text into cells

Creating simple formulas

Using functions

Using the fill handle

Formatting sheets for printing



Session 2: Apr. 11, 2012

Creating advanced functions

Naming cells and ranges

Developing formulas using named cells and ranges

Using 3-D functions to calculate across worksheets

Defining absolute and relative references

Creating elapsed time/day formulas



Session 3: Apr. 18, 2012

Constructing databases

Sorting, filtering and subtotaling data

Creating pivot tables



Session 4: Apr. 25, 2012

Working with graphs/charts



Going Google: 15 Tips for Efficient Searching - Apr. 10th (WLSC)

Google has become one of the most popular and powerful search engines on the Internet. We'll look at some of the more advanced search functions available in this user-friendly search engine to enable you to find answers to your questions in as few clicks as possible. Bring some of your more pesky reference questions and put Google to the test.



Publisher 2007 in a Jiffy - Apr. 10th (WLSC)

 Need to make a flyer publicizing your story time or a newsletter for the Library? Microsoft's Publisher allows you to do that and more. In this workshop you will explore Publisher's various templates and wizards. Using this software's many tools, you will create and customize a professional flyer. This class is designed for librarians with limited or no experience with Publisher.



Google+  - Apr. 25th (WLSC)

On June 28th 2011, Google launched its new project: Google Plus. Touted as a tool to make sharing on the web "more like sharing in real life." In this workshop, we will review the features Google+ has to offer. We will also compare similar features in Facebook and discuss the pros and cons between both services.



Useful Websites for Adult Reference - Apr. 25th (WLSC)

 Are you tired of hearing patrons claim they can find everything on the Internet? Well, that may or may not be true. We will look at some of the great websites out in cyber space that may help us answer some of our patrons' basic questions quickly and effectively. We will also investigate library and technology sites to help keep us up to date on the latest issues affecting libraries.



Basic Book Repair: Tools & Techniques - Apr. 26th (MLSC)

Would you like to save money by getting more uses per book? Would you like to keep that out-of-print book in circulation to meet your library patron's needs? Would you like to quickly repair the broken book spine that came in your new book shipment, rather than waiting for a replacement? Many repairs that can extend the life of your library collection are fast and simple, and can be done with easy-to-obtain, inexpensive materials. This workshop is appropriate for a library staff member or volunteer who will be doing book repair. Emphasis will be on simple repairs for the everyday public or school library collection, rather than on archival or long-term preservation techniques.



Topics covered will include:

*Basic book handling and cleaning, and some damage prevention measures

*Materials needed for basic book repair and where to get them

*How to repair a torn page & how to reinsert a loose page or group of pages

*How to reattach a paperback cover

*Some repair options for simple hardcover spine problems

*When to cover, re-sew, encase, or rebind books

*Resources for book repair - websites, brochures, etc.



**HANDS-ON: BRING SOME DAMAGED BOOKS TO SHARE AND REPAIR - Some supplies will be available for sharing. Optionally, you may also bring your own book repair tools to work with, such as scissors, box cutter or Xacto knife, ruler, bone folder, glue stick, and/or glue brush.**



Advanced Book Repair: Hardcover Techniques - Apr. 26th (MLSC)

Would you like to save money by getting more uses per book? Have you already done all the easy repairs and have a shelf left over of difficult broken spines on hardcover books? Do you have staff time to do repair work, rather than budget money to replace or rebind books? This workshop is appropriate for a library staff member or volunteer who has done basic book repair or taken a basic book repair workshop and is ready to try some advanced repair techniques. Emphasis will be on spine repairs for hardcover books, where professional rebinding is not an option due to brittle paper, or lack of access to a bindery or the funds to pay for rebinding. The purpose is on getting books back into circulation, rather than on archival or long-term

preservation techniques, although conservation-friendly reversible repair techniques will be the focus.



Topics covered will include:

Hardcover book construction

Types of hardcover spines

Materials needed for advanced book repair and where to get them

How to repair a cracked or broken spine

How to make a new spine

How to re-attach covers to hardbound books

Hollow-tube spine repair method

Interior hinge repair



**HANDS-ON: ONE BOOK WILL BE PROVIDED TO EACH PARTICIPANT FOR PRACTICE REPAIRS - YOU MAY BRING ADDITIONAL DISCARDED BOOKS TO WORK ON THAT ARE NOT VALUABLE (Hardcover repair workshop books may not be suitable for returning to a library collection - it takes some practice!) Some supplies will be available for sharing. Optionally, you may also bring your own book repair tools to work with, such as scissors, box cutter or Xacto knife, ruler, bone folder, glue stick, and/or glue brush.**



Teaching Technology - Apr. 27th (MLSC)

Have you needed to teach a technology class but didn't know how to start? This half-day workshop will help get you going and help you get beyond the fear factor. We'll discuss the philosophy of teaching adults. Though the emphasis in this workshop will be on teaching technology many of the concepts can be used to teach other skills.



Topics include:

Organizing the information

Conducting the class

Preparing presentation materials

Encouraging participation

Creating handouts






















Kris Abery
Continuing Education Coordinator
Connecticut State Library
Email: Kris.Abery at ct.gov
Tele: 860 704 2206
Facebook: http://www.facebook.com/CTStateLibrary
Twitter: http://twitter.com/#!/LibraryofCT

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mylist.net/archives/casl-l/attachments/20120314/a5789aaf/attachment.html>