Library self-service migration at Northbridge Secondary
Northbridge Secondary has 1,150 students and 78 staff. Its library runs three self-checkout kiosks on nine-year-old Windows PCs and one staff desk PC. The kiosks scan barcodes and write to a local Access database; a nightly backup is copied to a USB drive. Kiosk 2 reboots about three times a day, barcode misreads occur on roughly 7% of loans, and the break-time queue reaches 12 minutes. The school is considering a cloud library system: £2,400 per year, with an API to the school MIS, ChromeOS kiosks at £650 each, and RFID tags at £1.20 per item for 18,000 items. The total budget is £9,000. Leaders want a direct changeover in the two-week summer holiday, before a whole-school device handover and exams in week 3. Library staff can attend two hours of training but no overtime is funded. The school broadband is 100/20 Mbps and has failed twice per term.
1. Recommend a changeover strategy and a first-year purchase plan that fit the £9,000 budget. Justify your choices with figures.
Read the worked answer
A full direct changeover with all 18,000 RFID tags would cost 3 × £650 + 18,000 × £1.20 + £2,400 = £1,950 + £21,600 + £2,400 = £25,950, which is £16,950 over budget. A full summer direct changeover is also risky because there would be no parallel running before exams in week 3. A phased pilot is better: buy the cloud subscription (£2,400) and three ChromeOS kiosks (£1,950), keep barcodes, and tag only 3,500 high-circulation items (£4,200). Total = £8,550, leaving £450 for training materials and a spare barcode scanner. Run the new system alongside the old Access database for the first six weeks, with the desk PC as fallback. Roll out RFID to the remaining items in the October half-term, funded from next year's budget. This meets the budget, gives real summer testing, and reduces the risk of losing circulation data before exams.
2. Identify two risks of a direct changeover in the summer holiday and explain a mitigation for each.
Read the worked answer
Risk 1: data migration from Access. The export may contain duplicate borrower IDs, missing due dates or items linked to deleted borrowers, and staff may not discover this until term starts. Mitigation: run at least two trial migrations into a test tenant, reconcile record counts (for example 18,000 items and all active loans), and keep a read-only copy of the old database for six weeks. Risk 2: no fallback during a broadband outage. The cloud system depends on the 100/20 Mbps link, which fails twice a term. A direct changeover in the holiday would leave no trained staff and no manual procedure. Mitigation: write an offline circulation procedure using paper slips and a cached borrower list, test it during the pilot, and keep one old kiosk with a local barcode database until the October half-term. A third risk is that the MIS CSV export does not match the cloud API fields; test this with a sample of 50 students before go-live.
3. Explain whether the school should tag all 18,000 items with RFID in year 1.
Read the worked answer
No. All 18,000 tags cost £21,600, more than twice the entire £9,000 budget, before kiosks and subscription. Partial RFID also creates a mixed workflow: tagged items can use self-checkout, while untagged items must go to the desk or be scanned by barcode, so staff still need both processes. RFID's main benefits - fast multiple-item checkout and shelf inventory - only appear when coverage is near 100%. A better year-1 decision is to keep barcodes, which already exist on every item, and use the pilot to measure whether checkout queue time falls enough to justify RFID later. If leaders insist on RFID, tag the 3,500 most-borrowed items first and evaluate after one term; do not claim the full benefit until all items are tagged.