Budgets on My Mind: Changing Budget Allocations to Meet Teaching and Research Needs: University of Washington Case Study

In fall 2017, the University of Washington (UW) Libraries began a multiyear process to examine and update the resources budget structure and allocation model. The budget structure and allocation model at UW Libraries remained fundamentally the same for over 20 years. In that time there has been a shift toward more interdisciplinary research as well as significant changes in scholarly publishing and the acquisition environment for academic libraries. Recognizing that our budget structure and allocation model are no longer aligned with the changes in our environment, UW initiated a process with the goal of developing a model that is better designed to serve students and researchers and allow the libraries to respond nimbly to the challenges and opportunities in the publishing and acquisition environment. This paper will describe our budget review process as a case study, which is intended to be a multiyear phased approach. In the first year, we implemented an environmental scan and survey of library budget structure and allocation practices. We will present a summary of findings from this survey, discuss some conclusions that inform our budget review process, as well as describe trends in academic library budget practices. The UW case study offers insight into one library’s approach to the difficult and sometimes contentious process of making changes to the resources budget structure and allocation model. We hope that we can provide practical ideas that could be implemented at other institutions

Excelling with Excel: Advanced Excel Functions for Collection Analysis

Microsoft Excel offers useful features and formulas that potentially allow acquisitions and collection development librarians to work smarter, not harder. Using journal cancellations as a workplace scenario, the presenters will provide attendees with ideas on how to organize data and complete basic calculations with Excel. The presenters provide examples on how to use several advanced Excel functions including PivotTables, VLOOKUP, and select formulas. They describe the steps for importing and exporting data, combing and comparing data from different sources, and formatting data to communicate more effectively

Return on Investment for Collaborative Collection Development: A Cost-Benefit Evaluation of Consortia Purchasing

This paper describes the cost-benefits and the return on investment of one consortium comprised of five separately administered libraries in the University of Colorado (CU) System. With a long history of collaboration, the libraries have developed an ideal cooperative arrangement for acquiring electronic content that is accessible across all campuses. The size and flexibility of this institution-based consortium allows it to be responsive and successful in collaborating across four campuses despite different sized budgets and unique local and institutional constraints. To demonstrate the value of jointly leveraging library budgets to university administrators, the authors conducted a consortium level cost-benefit analysis and describe the methodology used to quantify return on the university’s investment. This paper addresses both qualitative and quantitative outcomes and underscores how consortial participation has become an essential way of doing business

Advanced Data Analysis: From Excel PivotTables to Microsoft Access

Most librarians run for the hills when they hear about Microsoft Excel PivotTables and relational databases such as Microsoft Access. PivotTables can be a powerful analysis tool. However, Microsoft Access can move beyond PivotTables by exploring more complex relationships between datasets. Building from the morning session, participants learned additional Excel functions including PivotTables and PivotCharts, as well as Access tables, queries, forms, and reports. The session was held in a classroom with computers, so attendees received sample data to create PivotTables, PivotCharts, and their own relational database during this handson workshop. Readers of this proceeding may request sample data for the Excel PivotTable presentation by email correspondence with the lead author ([email protected])

Balancing Bananas: Collection Assessment of Patron‐Driven Acquisitions

The libraries in the University of Colorado (CU) System have been using patron‐driven acquisitions (PDA) to build a shared collection of e‐books for many years. This paper presents our experiences as both early adopters of PDA and libraries with longstanding PDA e‐book programs and describes an analysis of how PDA has impacted collections at each of the libraries in the CU System

Generalized Filtering Decomposition

Session 7International audienc

More than a Number: Unexpected Benefits of Return on Investment Analysis

In 2010–2011, University of Colorado (CU) librarians implemented a multi-campus pilot study to measure the institutional value of library resources used by faculty in their research. The study incorporated quantitative methods including return on investment (ROI), cost benefit analysis (CBA), and citation analysis of journal articles published by faculty; and qualitative methodologies such as in-person interviews with faculty. The study resulted in a CU ROI model that can be used to measure faculty perceptions of value and the economic benefits of electronic journal collections for faculty research in terms of ROI. The CU ROI methodology provides outcomes beyond a single ROI number and led to unexpected benefits for informing collection development decisions and strategies

Ebb and Flow: A Selection to Access Workflow for Consortia PDA

In the traditional workflow for delivering electronic resources to patrons, acquisitions have been the bridge between collection development and cataloging. However, new Patron Driven Acquisitions (PDA) purchasing models have reordered workflows and reemphasized communications. The sequence of activities differs since e-book discovery precedes purchasing activities. Workflow complexities are further exacerbated in a consortia environment. The University of Colorado (CU) system collaborated to implement a consortium PDA pilot with Ingram Academic on the MyiLibrary platform in December 2011. This presentation provides an overview of the pilot program and describes the workflow used for shared selection, cataloging, purchasing, and assessment of e-books among five separate libraries. The presenters provide details on the most salient issues encountered at each phase of the process, such as: selecting pilot subject areas; developing a consortium profile; establishing best-practices for MARC record editing and loading; troubleshooting duplicated e-book titles at individual libraries; resolving invoicing logistics; and designing assessment criteria. It also covers strategies for implementing a PDA program and describes some of the issues that may arise in a consortial PDA program

Near-100% production of the excited Be\u3csup\u3e+\u3c/sup\u3e 1s\u3csup\u3e2\u3c/sup\u3e2p ion from decay of Be 1s2\u3ci\u3es\u3c/i\u3e\u3csup\u3e2\u3c/sup\u3e2p

In examining the decay of photon-produced Be 1s2s2np(1P), n=2,3, we discovered that the vastly predominant decay mode is to the final excited ionic states Be+ 1s2np, rather than the ground state. For n=2, the 2p ion accounts for 95% of the total production, with Be+ 1s23p the other main contributor. For n=3, 3p is predominant, again with a very small fraction of 2s. The result for n=2 occurs as a consequence of the similarity between the 2s and 2p radial wave functions of the excited state, which leads to a cancellation in the amplitude for transition to the 2s ground state

Exploring the Evidence in Evidence-Based Acquisition

This article explores the University of Colorado (CU) Libraries’ experiences with evaluating a patron-driven (PDA) program with Kanopy and an evidence-based (EBA) program with Alexander Street for streaming videos. The article includes a thorough comparison of EBA and PDA models, workflows, and outcomes. Three separately administered libraries within the CU system support campuses of different budgets, student and faculty demographics, programs, and exposure to streaming collections. Lessons in implementing and assessing streaming videos at each library and across the consortia are shared along with details on how to implement similar analysis at other libraries