That clears things up. Duplicating the app/sheet seems to be the best option as each school that takes on the app would need their own spreadsheet and the ability to share their own link to the app across all the users in the school.
Thanks to all who contributed, I hope that one day I have knowledge to pass on here as well