Skip to Main Content

LibLearnX 2023 Guest Presenters

Trevor Smith (Douglas College)

Extend Your LibAnswers Data with Microsoft Access and Excel

Extend your LibAnswers data with MS Office and gain dynamic insight into your Reference desk reports. Douglas College created a dashboard in Excel to investigate their students’ reference usage over the years. By saving their LibAnswers transactions in a simple database, they used queries to enhance the data with their college’s academic years, terms, other data points which let them see long-term trends in usage. You too can tailor your data to suit your institute’s needs with tools you already have.