Hi Juliet,

I've been trying to work out the best way to do this for a while. I was previously giving total student numbers on all modules, but often finding these modules to be on the same programme, meaning I was potentially including the same students twice.

Our planning department creates a weekly module enrolments spreadsheet with a pivot table for all modules and student numbers. I've discovered there is a 'Student name' field, so I've started adding this into the pivot table, copying across all student names from all modules the title appears on into a new Excel sheet. Then I remove duplicates on name and take the remaining number of names as the final sum. This has still been leading to very high quotes in many cases, which is a little frustrating as we know not all students included in the total numbers will actually access the book, but at least we know we're not counting the same student more than once.

It's not always clear from the publisher what the criteria is for student numbers, and whether all modules that list the title must be included, particularly if the title is not listed as essential reading. I don't know if anyone has managed to negotiate a reasonable way to estimate realistic usage when acquiring new POAs?

Kind regards,

Laura

Laura Griffin
Reading List and Digitisation Coordinator
Library Services
University of Roehampton | London | SW15 5SZ
[log in to unmask] | http://www.roehampton.ac.uk/
Tel: +44 (0) 20 8392 3770






-----Original Message-----
From: E-books in academic libraries mailing list <[log in to unmask]> On Behalf Of Juliet Ibbotson
Sent: Friday, June 9, 2023 9:40 AM
To: [log in to unmask]
Subject: Calculating number of students for pricing for Ebook

[You don't often get email from [log in to unmask] Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]

[CAUTION:] This email originated from outside of the University of Roehampton. Do not click on any links or open attachments unless you recognise the sender and know that the content is safe.

Hi all

We are testing the Browns Price On Application option and requesting pricing for some unlimited user titles where the cost is based on the number of students likely to access the book.
We were using total number of students on all modules which included the book on the reading list as our figure, but it is so high, and so many of the prices are correspondingly high.  We know that the same students might be counted on multiple modules so we will be inflating this figure.

Would anyone else be willing to share on or off list how they calculate this number?  we thought we could use

Highest single number of students on a module Average - total number of students divided by number of modules.

Of course after the first year we will know how many students have accessed a text and can base our renewal or cancellation on that figure, but as we are just starting out all of our numbers are estimates.

Many thanks all,

Juliet

[log in to unmask]

########################################################################

To unsubscribe from the LIS-E-BOOKS list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/WA-JISC.exe?SUBED1=LIS-E-BOOKS&A=1

This message was issued to members of http://www.jiscmail.ac.uk/LIS-E-BOOKS, a mailing list hosted by http://www.jiscmail.ac.uk/, terms & conditions are available at https://www.jiscmail.ac.uk/policyandsecurity/


Consider the environment. Please do not print this e-mail unless you really need to.

________________________________

This email and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this email or its attachments.

Internet communications are not guaranteed to be secure or virus-free. University of Roehampton does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses.

Any opinion or other information in this e-mail or its attachments that does not relate to the business of University of Roehampton is personal to the sender and is not given or endorsed by University of Roehampton.

University of Roehampton is the trading name of Roehampton University, a company limited by guarantee incorporated in England under number 5161359. Registered Office: Grove House, Roehampton Lane, London SW15 5PJ. An exempt charity.

########################################################################

To unsubscribe from the LIS-E-BOOKS list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/WA-JISC.exe?SUBED1=LIS-E-BOOKS&A=1

This message was issued to members of www.jiscmail.ac.uk/LIS-E-BOOKS, a mailing list hosted by www.jiscmail.ac.uk, terms & conditions are available at https://www.jiscmail.ac.uk/policyandsecurity/