OCCRA
Go to Post She must have known that if she declined the invitation to form an alliance that no one else would be allowed to pick her. (But of course, as any happy husband knows... the wife is always the #1 seed!) - dtengineering [more]
Home
Go Back   Chief Delphi > Competition > Team Organization
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
Reply
Thread Tools Rate Thread Display Modes
  #1   Spotlight this post!  
Unread 05-29-2018, 03:59 PM
vmorgs's Avatar
vmorgs vmorgs is offline
Registered User
FRC #5401 (The Fightin' Robotic Owls)
Team Role: Coach
 
Join Date: Mar 2016
Rookie Year: 2015
Location: Bensalem, PA
Posts: 32
vmorgs is an unknown quantity at this point
Tracking Attendance

My team has a build season attendance requirement...meaning you must attend a set number of build season meetings if you expect to make certain "game day" teams like Pit Team or Drive Team OR of if you except to get excused absences from school for competitions. We also just track attendance at our weekly off-season meetings for safety reasons...so we know who's in or out of the lab/shop at any given time in the event of an emergency or building evacuation.

Our currently method of tracking attendance is a sign in book with paper sign in sheets, but it's a PAIN to manage. After each meeting, someone has to take the book and log the attendance in our team database. So I was wondering--how do other teams track meeting attendance? Do you guys use off the shelf time-clock/attendance software or do you use something in Excel or Access? Any tips or suggestions on how to better track our team's attendance would be greatly appreciated. Thanks!
__________________


Reply With Quote
  #2   Spotlight this post!  
Unread 05-29-2018, 04:04 PM
Jon Stratis's Avatar
Jon Stratis Jon Stratis is offline
Mentor, LRI, MN RPC
FRC #2177 (The Robettes)
Team Role: Mentor
 
Join Date: Feb 2007
Rookie Year: 2006
Location: Minnesota
Posts: 5,009
Jon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond reputeJon Stratis has a reputation beyond repute
Re: Tracking Attendance

We print out a grid that includes the students in each area (mechanical, programming, electrical, business). At the end of each meeting, mentors for those areas go through and mark down how long each person was there. Once a week or so we transfer that into a google sheet that is set up the same way. Add some formulas to the sheet and you're all set!
__________________
LRI: North Star 2012-2016; Lake Superior 2013-2014; MN State Tournament 2013-2014, 2016-2018; Iowa 2017; Northern Lights 2018; Great Northern 2018
Division LRI: Galileo 2016; Tesla 2017; Archimedes 2018
2015: North Star Regional Volunteer of the Year
2016: Lake Superior WFFA
Reply With Quote
  #3   Spotlight this post!  
Unread 05-29-2018, 04:05 PM
Leap's Avatar
Leap Leap is offline
Trying my best, I swear.
AKA: Aidan
FRC #0299 (Valkyrie Robotics), #4159 (CardinalBotics)
Team Role: Mentor
 
Join Date: Mar 2015
Rookie Year: 2013
Location: Santa Cruz, CA
Posts: 186
Leap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond reputeLeap has a reputation beyond repute
Re: Tracking Attendance

Having something set up in the back of the classroom/lab where signing in is as easy as a 6-digit number has been the most efficient for our team. I believe some students on our team a while back developed the program themselves for sign-in. At the beginning of the year, the database is wiped clean, so no users or any info is stored. From the first meeting of the year onward, students put in their student ID numbers and name, creating a new user account on the system. Every time afterwards, entering the number acts as a "punch" in or out, and the system measures the time between.

The information all gets logged in the program, but about bi-weekly someone needs to take the information and manually update our team roster with it. It's been great for measuring time spent at the workshop but a lot still needs to be done by hand.
__________________
Team 299: Mentor (2016 - Present)
Team 4159: Student (2013 - 2016), Mentor (2016 - Present)
Team 5700: Advice-Giver and Party Crasher (2015 - Present)


Reply With Quote
  #4   Spotlight this post!  
Unread 05-29-2018, 04:14 PM
KaranY's Avatar
KaranY KaranY is offline
Brian Maher Fan Club (BMFC) founder
AKA: Karan Yadav
FRC #2791 (Shaker Robotics)
Team Role: Driver
 
Join Date: May 2017
Rookie Year: 2016
Location: Latham, New York
Posts: 263
KaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond repute
Re: Tracking Attendance

We have an online google forms sign-in and sign-out sheet. During the initial meetings and parent meeting in October, students are encouraged to sign up for the hours list. Its accessible to everyone, so students can use their phones to log in hours during meetings.

Our secretary than compiles the hours and posts weekly hours on the door of our main robotics room on an excel spreadsheet. Names highlighted in green are people who so far in the season have met the hours requirement, those in yellow have enough hours to attend our local competition, and those in red don't have enough hours to attend any competitions.
__________________
Team 2791:

2018: Central New York Winners, TVR Finalists, Detroit World Championship Darwin Quarterfinalists, IRI Invite
2017: TVR Winners, NYC Semifinalists, St. Louis World Championship Curie Quarterfinalists, IRI Invite, Ra Cha Cha Ruckus Quarterfinalists, Robot Rumble Winners
2016: TVR Semifinalists, FLR Semifinalists, Robot Rumble Winners, BattleCry Winners
Reply With Quote
  #5   Spotlight this post!  
Unread 05-29-2018, 04:20 PM
AllenGregoryIV's Avatar
AllenGregoryIV AllenGregoryIV is offline
Engineering Coach
AKA: Allen "JAG" Gregory
FRC #3847 (Spectrum)
Team Role: Coach
 
Join Date: Jul 2008
Rookie Year: 2003
Location: Texas
Posts: 3,018
AllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond repute
Send a message via AIM to AllenGregoryIV
Re: Tracking Attendance

also check out this thread

https://www.chiefdelphi.com/forums/s...ight=time+card
__________________

Team 647 | Cyber Wolf Corps | Alumni | 2003-2006 | Shoemaker HS
Team 2587 | DiscoBots | Mentor | 2008-2011 | Rice University / Houston Food Bank
Team 3847 | Spectrum | Coach | 2012-20... | St Agnes Academy
LRI | Alamo Regional | 2014-20...
"Competition has been shown to be useful up to a certain point and no further, but cooperation, which is the thing we must strive for today, begins where competition leaves off." - Franklin D. Roosevelt
Reply With Quote
  #6   Spotlight this post!  
Unread 05-29-2018, 04:29 PM
vmorgs's Avatar
vmorgs vmorgs is offline
Registered User
FRC #5401 (The Fightin' Robotic Owls)
Team Role: Coach
 
Join Date: Mar 2016
Rookie Year: 2015
Location: Bensalem, PA
Posts: 32
vmorgs is an unknown quantity at this point
Re: Tracking Attendance

Quote:
Originally Posted by KaranY View Post
We have an online google forms sign-in and sign-out sheet. During the initial meetings and parent meeting in October, students are encouraged to sign up for the hours list. Its accessible to everyone, so students can use their phones to log in hours during meetings.
Interesting. Do you know how you set this up in Google Forms? We use Google Sheets to house our team database so this would work perfectly with that.
__________________


Reply With Quote
  #7   Spotlight this post!  
Unread 05-29-2018, 05:03 PM
legoguy1000 legoguy1000 is offline
Registered User
FRC #2363 (Triple Helix)
Team Role: Mentor
 
Join Date: Nov 2016
Rookie Year: 2010
Location: Newport News, VA
Posts: 20
legoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to all
Re: Tracking Attendance

I have been working on a all encompassing portal for my team 2363, Triple Helix. The main part is hours tracking, but we have integrating annual registration and tracking of payment of dues, STIMS/TIMS registration, paperwork...., Tracking event registration to the point of tracking who can drive to events, who goes in which car, hotel rooms.... I have integrated Slack for notifications and am working on email as well. I am in the process of making a demo site for people to view, here is the url https://portal-demo.team2363.org. There isn't any data yet but i plan to populate with fake data.
Reply With Quote
  #8   Spotlight this post!  
Unread 05-29-2018, 05:23 PM
vmorgs's Avatar
vmorgs vmorgs is offline
Registered User
FRC #5401 (The Fightin' Robotic Owls)
Team Role: Coach
 
Join Date: Mar 2016
Rookie Year: 2015
Location: Bensalem, PA
Posts: 32
vmorgs is an unknown quantity at this point
Re: Tracking Attendance

Quote:
Originally Posted by legoguy1000 View Post
I have been working on a all encompassing portal for my team 2363, Triple Helix. The main part is hours tracking, but we have integrating annual registration and tracking of payment of dues, STIMS/TIMS registration, paperwork...., Tracking event registration to the point of tracking who can drive to events, who goes in which car, hotel rooms.... I have integrated Slack for notifications and am working on email as well. I am in the process of making a demo site for people to view, here is the url https://portal-demo.team2363.org. There isn't any data yet but i plan to populate with fake data.
That is AMAZIMG! How are you building it?! With what software?! I love it!!!
__________________


Reply With Quote
  #9   Spotlight this post!  
Unread 05-29-2018, 05:44 PM
legoguy1000 legoguy1000 is offline
Registered User
FRC #2363 (Triple Helix)
Team Role: Mentor
 
Join Date: Nov 2016
Rookie Year: 2010
Location: Newport News, VA
Posts: 20
legoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to all
Re: Tracking Attendance

Quote:
Originally Posted by vmorgs View Post
That is AMAZIMG! How are you building it?! With what software?! I love it!!!
Its AngularJs on the front end and PHP (slimphp, Eloquent) API on the back end. Here is my GitHub https://github.com/legoguy1000/FRC-Portal. I'm working on getting data into it now so people can see the interior.

User creds are below
student:
email: martink@sbcglobal.net
pass:user

admin:
email: admin@example.com
pass: admin
Reply With Quote
  #10   Spotlight this post!  
Unread 05-29-2018, 09:01 PM
Pooja Anil's Avatar
Pooja Anil Pooja Anil is offline
Registered User
FRC #3196 (Team SPORK)
Team Role: Mechanical
 
Join Date: May 2016
Rookie Year: 2015
Location: Mooresville, NC
Posts: 90
Pooja Anil is on a distinguished road
Re: Tracking Attendance

A student on the team created this really cool system using old hotel cards (RFID I think but I'm kinda lost on how it works. There's an Arduino somewhere in there). All students and mentors have a card, so as soon as they walk into the shop, they hold it up to this sensor and it checks us in. Same when checking out. And then our team captain walks around and usually fills out her own spreadsheet for attendance. Between the two of those, we have a good attendance system.

To attend competitions, you need to have attended at least 50% of subteam meetings which you are a part of. And you have to be on both an engineering subteam (Mechanical, Electrical, and Programming) and an operations subteam (Marketing/Outreach, Awards, and finance).
__________________
"I Am A Strong Independent Robot And I Don't Need No Human"-Shooter McGavin (2011-2012 Robot)

"I'm Not Crazy, My Reality Is Just Different From Yours"- Cheshire Cat

Reply With Quote
  #11   Spotlight this post!  
Unread 05-29-2018, 09:16 PM
nick4130's Avatar
nick4130 nick4130 is offline
4130 Team Captain
AKA: Nick
FRC #4130 (The Blue Devils)
Team Role: Human Player
 
Join Date: Apr 2015
Rookie Year: 2012
Location: Richmond, Michigan
Posts: 114
nick4130 will become famous soon enough
Re: Tracking Attendance

We have a system that our programming captain created in Python. Each student makes an account with their initials, which then makes a .csv for each student. From there, every time they type in their initials it logged the time that was on the computer for in and out. When the .csv was opened in excel, there was a formula he created to give us a total number of hours, as in our bylaws we judge based on percentage of hours attended compared to hours possible.
__________________
2018 Carson Sub-Division Winner
2018 Detroit Championship Finalist

Reply With Quote
  #12   Spotlight this post!  
Unread 05-30-2018, 05:43 PM
KaranY's Avatar
KaranY KaranY is offline
Brian Maher Fan Club (BMFC) founder
AKA: Karan Yadav
FRC #2791 (Shaker Robotics)
Team Role: Driver
 
Join Date: May 2017
Rookie Year: 2016
Location: Latham, New York
Posts: 263
KaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond reputeKaranY has a reputation beyond repute
Re: Tracking Attendance

Quote:
Originally Posted by vmorgs View Post
Interesting. Do you know how you set this up in Google Forms? We use Google Sheets to house our team database so this would work perfectly with that.
The data goes directly from the forms to a google sheets spreadsheet. Our secretary than manages it and manually updates hours online.
__________________
Team 2791:

2018: Central New York Winners, TVR Finalists, Detroit World Championship Darwin Quarterfinalists, IRI Invite
2017: TVR Winners, NYC Semifinalists, St. Louis World Championship Curie Quarterfinalists, IRI Invite, Ra Cha Cha Ruckus Quarterfinalists, Robot Rumble Winners
2016: TVR Semifinalists, FLR Semifinalists, Robot Rumble Winners, BattleCry Winners
Reply With Quote
  #13   Spotlight this post!  
Unread 05-31-2018, 11:38 AM
tylerc102 tylerc102 is offline
Registered User
AKA: Tyler Carter
FRC #3128 (Aluminum Narwhals)
Team Role: Mentor
 
Join Date: Apr 2014
Rookie Year: 2009
Location: San Diego, California
Posts: 27
tylerc102 is on a distinguished road
Re: Tracking Attendance

Weve used a student programmed solution for awhile, but frankly it was hard to maintain and access reliably.

Now were gonna buy an industrial solution. Its not the price point a lot of teams can afford, but we believe its a small price to pay for reliability and whatnot. https://crownsecurityproducts.com/ti...ime-clock.html
Reply With Quote
  #14   Spotlight this post!  
Unread 09-13-2018, 02:29 PM
legoguy1000 legoguy1000 is offline
Registered User
FRC #2363 (Triple Helix)
Team Role: Mentor
 
Join Date: Nov 2016
Rookie Year: 2010
Location: Newport News, VA
Posts: 20
legoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to alllegoguy1000 is a name known to all
Re: Tracking Attendance

I have been working on a all encompassing portal for my team 2363, Triple Helix. The main part is hours tracking, but we have integrating annual registration and tracking of payment of dues, STIMS/TIMS registration, paperwork...., Tracking event registration to the point of tracking who can drive to events, who goes in which car, hotel rooms.... I have integrated Slack for notifications and am working on email as well. I am in the process of making a demo site for people to view, here is the url https://portal-demo.team2363.org. There isn't any data yet but i plan to populate with fake data.

Right now it pulls users from a google sheet/form that all students/mentors are required to fill out each year. This counts as their annual registration and imports any new students into the system.

User creds for demo are below
student:
email: martink@sbcglobal.net
pass:user

admin:
email: admin@example.com
pass: admin
Reply With Quote
  #15   Spotlight this post!  
Unread 09-13-2018, 02:43 PM
Koko Ed's Avatar
Koko Ed Koko Ed is offline
Serial Volunteer
AKA: Ed Patterson
FRC #0191
 
Join Date: Mar 2002
Rookie Year: 2002
Location: Rochester,NY
Posts: 23,570
Koko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond reputeKoko Ed has a reputation beyond repute
Re: Tracking Attendance

We have a sign in sheet for meetings and for after hours (that has to be signed off by a mentor that the student was actually productive during their time at the site and not playing around on the computer or something). The hours are tallied up at the end of the build season and recorded on the Star Chart with other factors to determine if the student qualifies for travel to events.
__________________
Koko Ed's 2018 FIRST Power Up Tour!
EVENTS: 17 MILES TRAVELED:18.606 miles NEXT EVENTKettering Kickoff.
Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 03:16 PM.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi