Library Student Usage - checkins and checkouts

[L.E. Spear]

Our administration wants us to record the date and time students enter the library afterschool and when they leave. We currently use student ID cards with barcodes so we don't have problems like students falsely identifying themselves.

 

Our system uses an EXCEL sheet with a macro that lists the time they entered the library. I need some way of creating an electronic system that would scan them out without creating too much confusion. They want some system that can confirm to a parent how long a student stayed in the library afterschool. We have approx. 600 student entries every day and one librarian afterschool so this is extemely complicated. 

 

Any ideas?

 

Cheers

[Kara Ross]

Hiya-I don't have an answer for you but I read your question and I just wanted to say THANKS for the idea--I have been trying to get a system for swiping student ID cards in place in my middle/high school library for 2 years now. It's hard to monitor each and every student that comes in while teaching/helping/collaborating and teens being teens love to sign in as Darth Vader, Justin Bieber, etc......Hopefully someone else has an answer for you

[L.E. Spear]

If you have a scanner then you can create ann electronic sheet with a basic macrob that automatically scans the card, and enters the date and time. If you want I can send you my basic sheet. ( w/the macro)