Managing school inventory without a spreadsheet
In most schools, lending equipment looks the same: a spreadsheet on a network drive, a notebook next to the storage cupboard, and one colleague who knows where everything is. That works — until the colleague goes on leave.
Why lending spreadsheets fail
It is rarely down to carelessness. It comes down to three things a table structurally cannot do:
- Two people at once. Whoever has the file open blocks it. Whoever copies it creates a second version of the truth.
- Future availability. A list shows what is out right now. It does not answer whether the projector is free for project week in three weeks.
- Handovers. Which case holds which charging cables, and who has the spare key, is written nowhere. It lives in one person's head.
The damage does not show on the day of the loan. It shows six months later: equipment nobody missed until it was needed.
What a durable process needs
A lending process that survives a change of staff needs four things — and no more.
- An inventory with unique numbers. Every device gets a number and a label. Without that, every later reconciliation is guesswork.
- Requests from a verified email address. Borrowers confirm their address by double opt-in. It sounds bureaucratic and it removes most of the follow-up questions.
- An automatic availability check. The system knows what is booked when, and refuses double bookings outright.
- A complete history. Not to hold anything over anyone, but so your successor can see what happened over the last two years.
How to actually start
The usual mistake is to begin with the entire school inventory. That takes weeks, never finishes, and the motivation is gone long before the end.
Better: one collection, two weeks. Take the area where things go wrong most often — usually the iPad cases or the AV equipment. Catalogue only that, put QR labels on it, and run every handout through the system for two weeks.
After that you know two things: whether the process fits your day, and how long cataloguing really takes per device. Only then is it worth tackling the rest.
What about data protection?
Lending records are personal data — including pupils'. Three points that matter in practice:
- Data minimisation. A loan needs a name, an email address and a date range. Nothing else.
- Retention. Decide up front how long a completed loan stays in the history.
- Processing agreement. If you use an external platform, you need a DPA under Art. 28 GDPR. With CampusVerleih it is available for download, no request needed.
CampusVerleih is built for exactly this workflow — and free forever up to 100 items, no credit card, no contract. That covers a collection or an AV inventory. Start for free.