ER&L Conference Committee November 8th, 2009
The proposed session will draw on VIVA’s experience to address methods of preparing and presenting use data that allow for the examination of trends over time. The session will address methods of preparing use data for long-term storage and explore PivotTables and PivotCharts as a means of displaying the collected data. The session will also present ways to “batch process” COUNTER compliant use data using Excel and will discuss how non-COUNTER formats can be included in the compiled data. The session will be divided into two portions – a lecture portion and a “hands-on” portion. The hands-on portion will require the provision of computers with Microsoft Excel installed. If a teaching facility with ample computers is not available, it is also possible to run the session as a BYOL (Bring Your Own Laptop) event. This was done successfully at the International Coalition of Library Consortia Spring meeting in April 2009.