Scanner and Barcodes for Attendance

I’d like to set up a system to record attendance at a weekly gathering, as well as retrospectively record attendance from the past 12 months of paper rolls.

We have about 90 names on the books, and average 35 attendees per week. My plan was to buy a cheap barcode scanner, assign a barcode to each name, and use excel to record the weekly attendance. I have zero experience of setting anything up like this but was inspired by something I have seen used in a school library.

Can anyone recommend a cheap scanner or tell me if this would require extra software and/or suggest a better way to do this?

TIA

Comments

  • +1

    Get your mobile phone or barcode scanner around $30 (quick google) then Get the barcodes at woolies, e.g. coke zero = assign to Mr. A, etc. lol.

  • If you're happy to process the attendance list offline (e.g. via MS Excel) a pocket scanner will get the job done
    If you prefer to run live on a notebook then you can choose a cheaper USB scanner. Just need to decide what symbology you'd prefer to use (1D or 2D) and choose a capable scanner/reader.

  • Lots of those "scan to Excel" app in the Play Store, assuming you are on Android and I'm sure there are iOS alternatives. For example Scan to Excel, Scan-IT to Office, etc.

    Just need to give each attendee a unique barcode or QR code, or send them as an image so they can show it on their phone to be scanned at the venue.

  • Use this website to create a barcode.

    https://barcode.tec-it.com/en

    Copy and paste the image to word. The longer the name, the bigger the barcode.

    You can be fancy and create a QR code instead using this website.

    https://qr.io/

    You can buy a corded USB scanner which is just an input device from Officeworks (retail for around $99) but if you plan on using the QR code, make sure the scanner can scan the QR code. The cheap scanners usually just have red bar laser to scan normal barcodes and not QR codes.

  • Hi,

    It depends how important capturing and recording past attendances is.

    If you just want to move on and just keep the paper records you can use https://humanitix.com/au assuming your Events have no attendance fee for free.

    Check-in can be manual, via a Browser or scan QR code from Printed Invite or their Mobile Phone.

  • Website and a QR code login?

    You can use Google sheets and other various Google online tools to just make a QR code they scan and add their name to it and click "attend" and it will save it to a spreadsheet.

    • ^^^ What this guy said.

      we do this at our business for guests to sign in.

      super simple. just google / youtube it.

Login or Join to leave a comment