Category Archives: Tools

Funding Visualization Tool

Libraries are overlooked and underfunded organizations that play a critical role in today’s society by providing free programs, resources, and services to millions of adults, children, and youth everyday around the United States. But many libraries lack the resources and support to innovate and build upon the ways they can meet their communities’ needs.

With support from the John S. and James L. Knight Foundation, Visualizing Funding for Libraries’ Data Tool is developed by Foundation Center to help libraries and their supporters find funding opportunities, increase understanding of funding sources, and track funding trends:

Google Classroom adds analytics

Google has updated its learning management system (LMS), Google Classroom, with new features for differentiated instruction, management of student work and analytics.

As a result of the update, teachers will be able to share assignments, questions or posts with an individual student, a small group or the entire classroom in a move designed to make it easier to differentiate instruction based on individual student needs.

For administrators, the new update will bring Classroom data to Admin Console Reports. Administrator users will now be able to see Classroom metrics on usage, how many posts are being created overall or by individual users.

The company has also updated the Classroom API to improve integrations with other tools, allowing them to “programmatically add materials to coursework or student submissions and can modify existing coursework they’ve created,” according to information released by Google.

More information about that investigation is available at

Library Statistics Standards and Support

Libraries spend considerable amounts of money licensing different types of online content to support their users’ needs. User activity, in relation to this content, needs to be continually assessed to ensure that this money is spent as productively as possible.

COUNTER sets and maintains the standard known as the Code of Practice and ensures that publishers and vendors submit annually to a rigorous independent audit. This ensures that librarians are able to compare usage statistics from different vendors; derive useful metrics such as cost-per-use; make better-informed purchasing decisions; and plan infrastructure more effectively.

Libraries and library consortia are invited to support COUNTER by joining as a member.

Usus  is a community website on library usage, supported by COUNTER.

Google Spreadsheet Add Ons for Data Analysis

Patnab’s blog mentions useful Google Spreadsheet add ons for data analysis (

  • Blockspring
  • Text analysis
  • Text mining
  • Translate my sheet
  • Remove duplicates
  • Power tools
  • Smart autofill
  • Mapping sheets
  • Google analytics
  • Find fuzzy matches

More resources and tips on the statistical use of Google spreadsheets is found at

Project Outcome

Project Outcome ( is a free toolkit offering libraries access to training, data analytics, and standardized surveys that measure outcomes in seven key library service areas. It helps public libraries understand and share the true impact of their services and programs with simple surveys and an easy-to-use process to measure and analyze outcomes.

Its first Annual Report explains survey results, notes what patrons benefited from most, and states what Project Outcome and participating libraries did in the first year to make Project Outcome a success.