1 / 31

Using JUSP with your own data 10 July 2013 Angela Conyers

JUSP webinar. Using JUSP with your own data 10 July 2013 Angela Conyers Evidence Base, Birmingham City University. Outline of session. Using the SCONUL return to show total usage at publisher level Costs per use, costs per FTE, costs per title Costs per use – core and non-core titles

jodie
Download Presentation

Using JUSP with your own data 10 July 2013 Angela Conyers

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. JUSP webinar Using JUSP with your own data 10 July 2013 Angela Conyers Evidence Base, Birmingham City University

  2. Outline of session • Using the SCONUL return to show total usage at publisher level • Costs per use, costs per FTE, costs per title • Costs per use – core and non-core titles • Usage ranges • Adding subjects/budget headings

  3. JUSP reports and presentations • SCONUL returns • List all deals and title counts • JR1 reports excluding backfile usage • Viewing core titles in JUSP reports • Number of titles and requests in various usage ranges • JUSP events and webinars – slides available at http://jusp.mimas.ac.uk/events.html

  4. SCONUL return: total usage for an academic year (1 Aug-31 July)

  5. Cost per use at publisher level • Download the SCONUL return report from JUSP for an academic year as a csv file • Delete all usage columns apart from Frontfile (JR1-JR1a)total • Add a new column and give total costs for each publisher • Add another column with a formula to divide costs by number of requests and fill down

  6. Download the SCONUL return from JUSP and add cost data

  7. How to use the data • Create a bar chart to show cost per use figures for all or selected publishers • Download JUSP reports from earlier years to look at overall usage trends and costs per use • Use these to create a bar chart to show usage trends and costs per use over time

  8. Total downloadsYear-on-year comparison: example taken from University of Aberystwyth

  9. Cost per downloadYear-on-year comparison: example taken from University of Aberystwyth

  10. Cost per FTE at publisher levelAdd another column with FTE student numbers and work out cost per FTE student

  11. How many titles in a deal?

  12. What is the cost per title? • Download ‘list all titles and deals counts’ • Select the deals you take and delete all others • Match up with the publishers in your spreadsheet (watch out for any gaps) • Add an extra column for number of titles • Add another column with a formula to divide costs by number of titles • Fill down the column

  13. Cost per request/ cost per FTE student/cost per title

  14. Spreadsheet of core vs package titles in JUSP Same data, single download

  15. JR1 minus backfile usage – shows all use of current deal

  16. Show core titles first

  17. Working out cost per use – core titles • Download the JR1 report excluding backfile usage • Sort by the first column (core) so that all core titles come first • Remove all usage columns apart from total current • Transfer the core titles to a new worksheet • Add costs against each title • Insert formula to divide costs by number of requests to get ‘cost per use’ for core titles

  18. Cost per use – core titles

  19. Cost per use – non-core titles

  20. Another approach from the OU • Remove monthly columns and others not required • Add in cost data • Calculate cost per use • Sort titles by number of requests • Highlight titles • High use non-subscribed PINK • Low use subscribed ([core] in front of title) GREEN

  21. Adding subjects or funds • Add another column to your core titles spreadsheet and add subjects or funds • Sort by subject/fund – look at different costs per use in different subjects/titles

  22. Core titles by subject or fund

  23. Non-core titles by subject or fund • Look at your non-core titles that come in high usage ranges • Add subjects to those to indicate to subject departments how much use is being made of these additional titles in a deal

  24. E-journal Usage • Use per Title per package: • Number of titles per package with Very High usage (>= 1,000 downloads) • Number of titles per package with High usage • (>= 100 downloads) • Number of titles per package with Medium usage • (11-99 downloads) • Number of titles per package with Low usage • (< 11 downloads) • Number of titles with Zero usage • All costly in staff time!

  25. Number of titles and requests in various usage ranges

  26. Click on a number in the usage ranges report to get a list of titles in that range, including core titles

  27. Usage ranges –trends over time: an example from Cranfield

  28. JUSP community area A place for you: • To share ideas of ways to use JUSP • To give examples of templates or approaches you have used • To share your own presentations and training sessions on using JUSP email ideas to jusp@mimas.ac.uk @juspstats

More Related