813-324-2901
Excel for Technical Services

Excel for Technical Services

TBLC logo
This webinar will demonstrate features of Excel that can make data easier to both read and analyze. Presenter, Karen Kohn, will walk through each step using a report generated from the ILS. The first half of the session will focus on viewing lists of items and ways to manipulate a list for better readability. Participants will learn tips that can make Excel spreadsheets easier to read for those who don’t necessarily work in Excel regularly. The second half of the session will explore ways to transform data for analysis, including: importing fields from one spreadsheet into another, finding duplicates, splitting columns that have multiple values, and using conditional formatting to help visualize data.
 
At the end of this webinar, attendees will be able to:
  • Create filters in Excel and use them to count and sum subsets of a spreadsheet
  • Filter a column in a spreadsheet by text, number, or color
  • Create a pivot table
  • Use formulas to do basic arithmetic in Excel
  • Import data from one spreadsheet into another
  • Use conditional formatting to find duplicates or outlier values, and to create simple data visualizations
  • Split cells that contain multiple values, e.g., multiple ISBNs
Audience:
This session is intended for paraprofessionals and librarians. It is meant for people who don’t necessarily work in Excel regularly, however people in the library who use Excel for analysis will also benefit.
 

Presenter: Karen Kohn is Collections Analysis Librarian at Temple University in Philadelphia, PA and the author of Collection Evaluation in Academic Libraries: A Practical Guide for Librarians (Rowman & Littlefield, 2015). She has published articles in College & Research Libraries, Journal of Academic Librarianship, Journal of Documentation, and Collection Management and presented at the Charleston Library Conference and the Acquisitions Institute at Timberline Lodge. She is the instructor of the online course Introduction to Collection Analysis, offered through Library Juice Academy. She has an MLS from the University of Illinois at Urbana-Champaign and an MA in Sociology from Temple University.

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

FHSLA /TBLC Mental Health Awareness

TBLC logo
No one is immune from the toxic stress caused by the COVID-19 public health crisis. Learn about resources to build resilience to the stressors of daily life, especially during the past year of quarantine and physical distancing, and to better manage your mental health.
 
 
 
Presenter: Ardis Hanson, PhD, MLS, AHIP
Ardis is Assistant Director for Research and Education at the USF Health Libraries and has over 25 years of experience in behavioral health research services and policy. As the former director of the Louis de la Parte Florida Mental Health Institute (FMHI) Research Library, she worked extensively with consumers, family members, and advocates to improve mental health services and patient outcomes.
 
Presenter: Olivia Dileonardo
Olivia DiLeonardo is a Medical Librarian and Narrative Medicine Instructor at Nemours Children’s Hospital and University of Central Florida College of Medicine, where she has led Narrative Medicine instruction for medical students, residents, and faculty since 2014. Olivia holds a Certificate of Professional Achievement in Narrative Medicine from Columbia University.

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

Teaching Better Online Privacy

TBLC logo

Jessamyn West has been helping people with their computers in rural Vermont for 15 years and she’s created a simple privacy toolkit to help people understand the complicated world of online privacy. She’ll share her talk and the resources she uses to support the talk so that more librarians can help their patrons stay safer and more confident online.

Bio: Jessamyn West is a library technologist from Randolph Vermont. She is a nationally known speaker, writer, and educator on the issues facing today’s libraries. Her blog focusing on libraries and politics, Librarian.net, is one of the earliest and longest running librarian websites. She writes a column for Computers in Libraries magazine and is the author of the book Without a Net: Librarians Bridging the Digital Divide. As a librarian without a library, for the past fifteen years she has spent most of her time working with her local community as a hands-on technology educator.

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

Tools for Tense Situations: Reducing Conflicts With Patrons As Libraries Return to the New Normal

TBLC logo

Steve is a leading national expert on library service, safety, and security. He has written 24 books on business, HR, leadership, security, and criminal justice topics. Steve has taught library training programs, both live and online, since 2000.  

As libraries re-open their doors to provide service to patrons, we’re all facing uncertainty, apprehension, and stress. This 90-minute webinar session will provide library directors, managers, supervisors, and full and part-time employees with tools to recognize and resolve conflicts between arriving patrons. Getting along in our new post-Pandemic, post-protests world will require patience, empathy, and understanding other points of view without judgment. Library employees and the people we serve will have strong feelings about the current political and economic climate. It’s easy to let emotions get in the way of providing good service.

Here are the topics this 90-minute webinar will cover:

  • What are the challenges we face as we return from a Work From Home status to back to working in and around our library buildings?
  • What safety and security challenges do we face in the wake of more national and local protests in our parks, public spaces, and government buildings?
  • How can managers and supervisors monitor the work culture for conflict, communication, and morale issues?
  • Can supervisors use a step-by-step conflict resolution tool to use to help two disagreeing employees to get along?
  • How to respectfully request that patrons and other library visitors (vendors, delivery, maintenance, janitorial providers) follow Covid-19 safety protocols
  • How do we agree to disagree and have patience and empathy for our patrons or co-workers who have strong feelings about national issues that differ from ours?
  • What safety and security protocols do we need to follow, coming and going and while working in publicly-accessed buildings?
  • How about a little personal and professional stress management?
  • What does the future hold for library employees and what new ways can we provide service to patrons?

Presented by Dr. Steve Albrecht, author, Library Security: Better Communication, Safer Facilities (ALA, 2015) www.DrSteveAlbrecht.com

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

Autism 101 for Libraries: What is Autism Spectrum Disorder and How Can We Help Students and Families at the Library?

TBLC logo

This presentation will address characteristics of Autism Spectrum Disorders (ASD) and how those characteristics manifest in children and adults. The presenter will provide insights into how library staff can support children/adults with ASD based on individual needs. Specific questions from participants will be addressed throughout the presentation.

 

Autism Resources

ASD Resources

Autism Resources: Targeting Autism for Libraries

Slides

Presenter ~ Dr. Mary O’Brian
Dr. Mary O’Brian has worked in the field of special education for more than 35 years. Dr. O’Brian received her bachelors and doctoral degrees in special education. She has worked with children with disabilities in school settings in various roles, including teacher, school psychologist and special education administrator. She also worked with adults in vocational settings. She retired from Illinois State University in 2015 and has continued to work with children and families through consulting work and advocacy.

 

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

FHSLA /TBLC National Autism Awareness Month

TBLC logo

April is World Autism Month and National Autism Awareness Month. Autism Spectrum Disorder (ASD), a neurological and developmental disorder, becomes observable in early childhood and impacts the person throughout their life. With a range of symptoms, how can parents, caregivers, family members, teachers, and community members learn about ASD? Please join us for this session to discuss reliable health-related resources that can assist in understanding and advocating for individuals with ASD.

Slides

Adult Employment: Office of Disability Employment Policy: U.S. Department of Labor

Youth Services Programming: Center for Autism & Related Disabilities (CARD) at USF

Presenter: Mary Katherine (Mary-Kate) Haver
Mary Katherine (Mary-Kate) Haver is the Medical Librarian for the Biomedical Library at H. Lee Moffitt Cancer Center & Research Institute in Tampa. With over ten years of experience in medical librarianship, her professional experience includes working with allied health students, faculty, as well as adult and pediatric clinical staff, patients, their parents and caregivers. Mary-Kate is a Distinguished Member in the Academy of Health Information Professionals (AHIP) of the Medical Library Association (MLA) and holds Level II Specialization in Consumer Health (CHIS).

 

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

Free Online Tools to Increase Your Workflow & Productivity

TBLC logo

Have you ever found a tool or service that made you go “AHA!”? Are there little gems that make your life so much easier that you wonder how you lived without them? This informative webinar is filled with online (and free!) tools that can help you improve your how you work. Come discover a plethora of online tools that you probably haven’t heard of but will be glad that (now) you have.

Presenter ~ Laura Solomon
Laura Solomon, MCIW, MLS is the Library Services Manager for the Ohio Public Library Information Network and a W3C-certified front-end web developer. She has been doing web development and design for more than twenty years, in both public libraries and as an independent consultant. She specializes in developing with Drupal. She is a 2010 Library Journal Mover & Shaker. She’s written three books about social media and content marketing, specifically for libraries, and speaks nationally on both these and technology-related topics. As a former children’s librarian, she enjoys bringing the “fun of technology” to audiences and in giving libraries the tools they need to better serve the virtual customer.

 

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

“Let’s Try It!” Library Outreach in a Culture of Yes

TBLC logo

Outreach activities can boost student well-being and enhance positive feelings towards the library. Unfortunately, it is not always obvious how to successfully reach students. In this webinar, UNO Libraries Director of Research and Instruction Services Katie Bishop and Outreach & Instruction Librarian Tammi Owens discuss how a culture of yes at UNO Libraries has allowed them to forge strong relationships with student support services and learning communities and expand library outreach across the university. They will share the non-traditional library services and events that have succeeded and failed, both of which (the succeeding and failing) have worked together to make the department and the library a vibrant, innovative place to work and learn. Finally, they will relate some of the ways attendees can work towards creating a culture of yes at their own libraries that fits into the mission and vision of the library while remaining mindful of workloads.

Presenter ~ Katie Bishop is the Director of Research & Instruction Services and Humanities Librarian at the University of Nebraska Omaha’s Dr. C.C. and Mabel L. Criss Library. Katie leads the RIS department in engaging UNO faculty and students with research and information literacy instruction, coordinates assessment data for the library, and works with library leadership to manage department and collection budgets. She has presented and published on assessing IL instruction, updating library services, and partnering with student support services as part of the second cohort of the ACRL Assessment in Action program. Katie holds a BA in English from the University of Nebraska-Lincoln, an MA in American Studies from the University of Iowa, and an MS in Library and Information Science from the University of Illinois.

Presenter ~ Tammi Owens is the Outreach & Instruction Librarian and an associate professor at the University of Nebraska Omaha’s Dr. C.C. and Mabel L. Criss Library. At Criss Library Tammi is responsible for coordinating, assessing, and continuously improving the first-year writing library information literacy program, leading partnerships with student learning communities, and coordinating outreach events for student stress relief, library awareness, and education. Tammi is the co-author, with Carol Daul-Elhindi, of The 360 Librarian: A Framework for Integrating Mindfulness, Emotional Intelligence, and Critical Reflection in the Workplace, published by ACRL in 2020. She has written and presented at the regional and national level on such topics as library outreach and instruction, language use and user experience, gaming in libraries, and library tutorials. She holds BAs in Religious Studies and Art History from the University of Nebraska Omaha, an MA in Art History, and an MS in Library Science, both from the University of North Carolina-Chapel Hill.

 

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

FHSLA /TBLC Sleep Awareness

TBLC logo

March 14-20, 2021 marks the National Sleep Foundation’s annual Sleep Awareness Week®. This national initiative promotes sleep health by encouraging everyone to consider the impact of sleep on our health and well-being.

From head-to-toe (e.g. snoring to restless leg syndrome), learn about resources to assist with getting a good night’s sleep and offsetting potential health concerns. To learn more about reliable freely available pediatric and adult sleep information resources, please register and join in this session.

Presenter: Mary Katherine (Mary-Kate) Haver
Mary Katherine (Mary-Kate) Haver is the Medical Librarian for the Biomedical Library at H. Lee Moffitt Cancer Center & Research Institute in Tampa. With over ten years of experience in medical librarianship, her professional experience includes working with allied health students, faculty, as well as adult and pediatric clinical staff, patients, their parents and caregivers. Mary-Kate is a Distinguished Member in the Academy of Health Information Professionals (AHIP) of the Medical Library Association (MLA) and holds Level II Specialization in Consumer Health (CHIS).

Presenter: Ardis Hanson, PhD, MLS, AHIP
Ardis is Assistant Director for Research and Education at the USF Health Libraries and has over 25 years of experience in behavioral health research services and policy. As the former director of the Louis de la Parte Florida Mental Health Institute (FMHI) Research Library, she worked extensively with consumers, family members, and advocates to improve mental health services and patient outcomes.

Presenter:  Nicole Sondermann
Nicole Sondermann, CCSH, RPSGT, RST. Nicole is a board-certified sleep educator and polysomnographic technologist with Johns Hopkins All Children’s Hospital Sleep Center in St. Petersburg Florida. Nicole has been providing sleep and wakefulness education through corporate and community outreach programs for over a decade. Along with providing general information on sleep health, Nicole provides resources to her audience to allow them to better educated themselves on how to improve their sleep.

 

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.

Excel for Technical Services

Navigating the ACRL’s Visual Literacy Competency Standards Today and Beyond

TBLC logo

Libraries have traditionally focused on teaching their patrons how to find text based resources, however, in our increasingly visual world there is a growing demand for visual literacy skills and abilities. What is unique about visual literacy concerns? How can understanding the ACRL’s Visual Literacy Competency Standards for Higher Education assist librarians and their patrons to operate both professionally and personally? This webinar will answer these questions and more by providing attendees with examples of how to integrate the visual literacy standards and emerging trends into their daily library practice. Additionally, the presenters will share a list of helpful online resources and share a select bibliography.

 

Presener ~ Millicent Fullmer
Millicent Fullmer is the Acquisitions and Cataloging Librarian at the University of San Diego. She is also the subject librarian for art and art history. Originally from New Zealand, she holds an MLIS from the Pratt Institute in New York, a BA Honors in Art History from Canterbury University (NZ), and a BA in Art History and Religious Studies from Victoria University (NZ). Previously, she has been a special collections cataloger at Columbia University’s Avery Library, and a visual resources curator at Vanderbilt University as well as internships in several museums. Fullmer currently co-chairs the ACRL Visual Literacy Standards Task Force and her research interests include visual literacy, art and indigenous librarianship.

Presenter ~ Tiffany Saulter
Tiffany Saulter is an Accessibility Consultant at Deque University, where she coaches and helps train others on making their websites and other digital assets accessible. She received her MLIS from Indiana University, a MA in Art History from the University of Miami (with a focus in contemporary video and film art), and a BA in Digital Art from Stetson University. Previously, she worked as a Product & Application Support Specialist at Artstor and a Pauline A. Young Librarian, in the Special Collections & Archives Department of the University of Delaware Libraries. Tiffany is currently a co-chair of the ACRL Visual Literacy Standards Task Force and her research interests include archival metadata trends, identity politics and popular culture.

Presenter ~ Stephanie Beene
Stephanie Beene is the University of New Mexico’s Fine Arts Librarian for Art, Architecture, and Planning, where she supports the teaching, learning, and research of students and faculty within the Art Department in the College of Fine Arts, as well as the School of Architecture and Planning. Stephanie received an MSIS from the University of Texas at Austin, an MA in Art History (with a focus on Contemporary Borderlands Artists and Identity Politics) from the University of California, Riverside, and a BA in Art and Art History from Colorado State University. Before coming to UNM, Stephanie worked at Lewis & Clark College and as an instructor at the k-12 and undergraduate levels.  She has worked as an educator, librarian, and visual resources curator, and within museums, archives, galleries, libraries, and non-profits before landing at UNM. Stephanie’s research interests include visual literacy as it relates to lifelong learning; information literacy frameworks as they relate to how we make sense of personal and professional information; and the politics of identity within social justice work, whether as teachers, learners, activists, or creators.

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.