Trying to find Attendance Tracking Software

We use a fork of GrizzlyTime called FalconHours. We got it running on a RPi 3 and the whole system sits at the entrance of our shop. It’s been super convenient so far!

Setup pic: https://photos.app.goo.gl/jH7YicX7ZZVpyUUi9

We use ChopShopSignIn, which has the students (and mentors!) scan a barcode or QR code that has their name encoded into it. It stores sign in/out into a CSV file that can be queried and manipulated at will. I don’t know much about pivot tables or how that part works, unfortunately.

There’s also an Android app that (shameless plug) I wrote to provide a shortcut so people don’t have to scroll through all their pictures and folders to find their QR code and can have it saved on their phone.

My university actually has an iris scanner hooked up to a raspberry pi where you can scan into the dining hall without needing your card. Might be a fun project for a student to work on in the off-season. Iris scanners are great since you always carry around your eyeballs, and you don’t need to install anything!

We used this last year for students and mentors. Easy and worked great :+1:

I’m a big fan of Team Culture! Not sure if you can find it on the App Store, but it’s free and works pretty well once you get the hang of it

I wrote the Python variant of this that 294 has been running on a old rPi for the past few years.

Hehe we do have a nice Raspberry Pi setup. Unfortunately I’ve already left for college in Indiana but I can ask our new Head of Programming to y’all about it’s function. A boiled down version of it is that it scans in and out all our School ID cards and we are only allotted one “manual” log sheet if we ever forget to scan in to log hours.

The geek solutions are great - we can do THIS to make it easier.

But please check the local laws! In some places it may be illegal for us to collect biometric data (e.g. fingerprints or iris scans) for anyone under-age. In the U.S. this would generally be at the state level.

Sometimes it seems like we need a role on FRC teams for legal consulting.

1 Like

We use Tsheets. It is a commercial time tracking and scheduling software. Enough features to keep any data junkies happy. It has a app for smart phones so you can log in from anywhere you can get a signal.

Last year my team piloted a Windows app I wrote for our team which was supposed to run on Windows 10 IoT on a Raspberry Pi, but due to performance issues, was regulated to running on a laptop. Students checked in/out using a USB-RFID scanner with their student IDs. It was convenient because rather than make up a new list of IDs arbitrarily, we just reused the school’s existing ID structure.

The app was written in C# which tracked the data in our teams G Suite environment using Google Sheets (as a poor mans database). It was definitely a pet project which was useful enough during the build season, but could use some improvements including being able to track time spent outside of the build room at community events, etc.

If anyone is curious to look at the source code, I have it up on GitHub. The limiting factor for this particular setup is it doesn’t run outside of our team’s G Suite environment due to needing a Google Sheets API key which isn’t readily available unless you are a member of an organization. I’d be happy to answer any questions about the source code if there are any interested parties.

Future considerations for a better app include using AWS to house the database and application and have the client side simply send data to the server.

After doing our timekeeping on paper for many years, we started doing it on a computer for a couple seasons using the Beach Cities Robotics program mentioned above. Overall that worked okay, but it wasn’t optimal.

Three seasons ago, we bought an Acroprint Biotouch time clock which has a fingerprint scanner. It was a couple hundred dollars. Not free but not too crazy. It works great for us. We store it in a locked cabinet overnight, and then we can quickly pull it out to use when we’re in the shop. The fingerprint scanning works pretty well, so it goes pretty fast when a bunch of students need to clock in/out all at once.

The main drawback is that the students can’t see their times whenever they want. We have to regularly download the Excel file from the Acroprint, print it out, and post it on the door.

Hi there! Author of GrizzlyTime here.
GrizzlyTime is quite configurable, account creation is fast and takes less than a minute per person. Its compatible with barcode readers as well. The ID system is customizable, and all information is presented in an easy to read google sheet.

Because it uses google sheets, you can then share a read only version of the sheet to whomever you want.

The price to set it up? Internet and a Computer!

1 Like

Here’s an example of the statistics GrizzlyTime can provide.
These statistics are generated automatically, and individual student stats can be accessed by navigating to the “Date Log” page.

2 Likes

We did a RFID tag system with a USB RFID reader hooked to a vintage Classmate PC.
The original system tried to update a google spreadsheet in real-time. We had several issues with that so we refactored it to write to a local db and then export/upload the data to a google sheet once a day. All the reporting is done from that master google sheet.

Wayyy late to the party, but we’re in the process of developing a solution on 1902 for the upcoming season. It’s a Python/Django webapp, with a web interface to view data and an Android app that we use for checkin. It’s a little more involved to get set up than other solutions posted here, since ideally one would need a server to host it on (although hosting it locally over LAN should be possible too) and enough technical know-how to modify it to suit your needs, but it fits our needs well and I would be remiss if I didn’t share!

The base functionality is there, and we’re in the process of building features on top of it. It currently integrates with our Google Calendar and Slack workspace.

Feel free to fork it and play around (especially if you have Python/Django experience), and reach out if you have any questions!

Python/Django Webserver
Android Checkin App

1 Like

And you can only checkin when you are at the meeting? Not anywhere else?

Is your team part of a school? if so do students have an School ID card?

My college’s student organizations office was experimenting around with loaning out card readers to student organizations who wanted to track attendance

our college IDs were fancy RFID enabled cards though, so it might not be the solution for you, but it is certainly a quick and easy solution for checking in and out of a meeting.

https://chadk.co/qhi5

Here is a video of my team’s sign in sheet. You can punch in in just a few seconds. We are going to have a computer with a touch screen dedicated to this (in the past it has been someone’s computer)

Updates to it need to come but it works pretty well

And you can only checkin when you are at the meeting? Not anywhere else?

The app is running on a tablet that we keep in our front room (where our paper sign-in sheet was until this year). If you’re not physically with the tablet (or one of our lead mentors’ phones), you can’t sign in. The app is open source and our students are encouraged to look through it and/or improve it, but it needs an API key to punch in or out.

1 Like

Could others sign others in?