WiLSWorld 2015 Workshops

9:00-9:30 Welcome and Coffee

9:30-12:30 Concurrent Workshops

Digitization Basics for Archives and Special Collections – Part 1: Select and Scan
Michael Edmonds, Wisconsin Historical Society, Deputy Administrator, Division of Library-Archives
Josh Hickman, Beloit College, Digital Resources Librarian
Emily Pfotenhauer, WiLS, Recollection Wisconsin Program Manager

This is the first part of a two-part, full-day workshop introducing the core elements of creating digital collections of historic photographs, documents and other archival materials. Part 1 focuses on selecting materials to digitize and the basics of reformatting. We’ll start with some recommendations for planning a successful project and consider how your digital collections can fit into the statewide and national landscape of digital content. We’ll discuss copyright concerns in order to help you answer the question “CAN I put this online?” And we’ll explore the vocabulary of digital images, including pixels, resolution and bit depth as well as tools and best practices for scanning photographs and documents.

SQL 101 — Tables, Queries, and a Little MS Access: A Hands-On Introductory Workshop
Eric Giefer, UW Law School, Director, Information Technology

Join Eric for a hands-on opportunity to learn the basics of SQL! He’ll cover basic SQL language, and some behind the scenes details on what SQL looks like, while at the same time covering how to use MS Access to create and edit queries.

Using Microsoft Access as the tool to build and run your queries, you’ll learn:

• Simple queries selecting data, counting data, and summarizing data.
• How to link tables together to build more sophisticated reports
• How to modify how tables are linked together to pull in information that only exists for some records but not others
• Concepts around database design for understanding of limitations of spreadsheets, why multiple tables are used, and some commentary of things to look for to make your life easier as you work with vendor tables and try to decipher why the vendors database is the way it is.

MS Access is very powerful and we’ll be scratching the surface on what it can do using it to make SQL more accessible. We’ll cover what SQL looks like providing basic understanding of both SQL and how to use MS Access to quickly generate queries to access and compile data. We’ll be focused on tables, queries and SQL in MS Access, the workshop will not cover forms, reports or other advanced MS Access topics.

This workshop will not cover how to do any web programming, or how to setup the database connections. For specific databases, the vendors will provide documentation on how to setup, and depending on security settings on your work machine, your IT folks may have to be involved.

On Target: Marketing and Promoting Your Library and Services
Renee Ettinger, Reference and Instruction Librarian, UW-Green Bay Cofrin Library
Paula Ganyard, Director, UW-Green Bay Cofrin Library
Emily Passey, Assistant Director, Shorewood Public Library

We all struggle with finding ways to make our library and its services visible to our community. We know they are valuable but how do we reach our potential users? This workshop will help you identify your community groups as well as your key services and set you on the path toward creating a promotional campaign to get the word out about the good work that you do.

12:30-1:30 Lunch (on your own)

1:30-4:30 Workshops

Digitization Basics for Archives and Special Collections – Part 2: Store and Share
Catherine Phan, Metadata Librarian, University of Wisconsin Digital Collections Center
Jesse Henderson, Digital Services Librarian, University of Wisconsin Digital Collections Center
Steven Dast, Digital Asset Librarian, University of Wisconsin Digital Collections Center
Bradley Shipps, Continuing Education and Outreach Librarian, Outagamie Waupaca Library System
Jessica Williams, Library Director,  Mount Horeb Public Library

This is the second part of a two-part, full-day workshop introducing the core elements of creating digital collections of historic photographs, documents and other archival materials. Part 2 focuses on sharing your digitized materials with the world and steps you can take to ensure that they’ll remain usable and accessible into the future. We’ll define metadata and why it’s important, and consider approaches to creating descriptive metadata for discovery of historical resources. We’ll examine the issue of digital preservation, including practical steps you can take to preserve your digital content with limited resources. And we’ll think about digitization as a path to community engagement, including reaching out to your community for content and promoting your digital collections to your users.

What’s on your mind? A Social Media Workshop
Melissa McLimans, Digital Services Librarian, UW Digital Collections Center
Emily Passey, Assistant Director, Shorewood Public Library
Vicki Tobias, Media Archivist, UW-Madison Archives

Do you “do social media” for your library, but want to know how to do it better?  You have lots of great things to share, but how and to whom?  And why?  This workshop will help you create an engaging social media presence through activities to identify your audience and your community social media partners, develop a social media strategy, and craft interesting communications to draw in your library users and stakeholders.

Register today!