This project is designed to work as a time tracker for FIRST robotics teams. Once installed, it can be displayed on a lab computer and students can sign in and out to track their hours. We suggest using a barcode/barcode scanner for the user id etc. It makes the sign in/out process very quick. (Hint: your local grocery store rewards card probably has one!)
This work can be reused and modified by teams but may not be sold. Credit must be given to the original author and any changes must be released under similar licencing.
#Live Example There is a live example running on heroku at http://frctimesheet.herokuapp.com/. The admin user is "admin@900.com" with a password of "zebracorns". An example student user is "test@900.com" with a password of "zebra".
Feel free to create new users and timelogs etc. Please do NOT delete or modify these two users.
Statistics reporting has been implemented in a series of graphs.
Note: For mentors, we suggest setting up a school titled "Mentor". This way you can differentiate between student hours and mentor hours.
The graphs availlable are: Stats By Week:
- Total Hours Per School Per Week
- Average Hours Per Student Per School Per Week
- Total Hours Per Week
- Cumulative Hours
- Total Hours Per School
- Average Hours Per Student Per School
- Number of Students Per School
Forms allows you to add student requirements. They could be (but are not limited to) tool use forms, liability waivers, permission slips, or training on a specific machine. Anything which can have a "yes" or a "no" per student.
The Homepage (Administrators view)
The Sign-In Page
A graph representing the total hours per week. Each school has a different line.
A graph representing the average hours per week. Each school has a different line and it's the total hours/student count.
A graph representing the average hours per school. It's the total hours/student count.
A graph representing the number of students per school.
- PostgreSQL
- Ruby on Rails 5.1.4
I suggest using heroku to host it. It's free (as long as you use no more than 1 thread a month), it allows access from any computer, and has postgres and RoR installed by default.
To install on heroku:
- Pull from git run this command in the command line:
$ git clone [repository url]Note: The repository url can be found on the side of the github page
- Modify code/settings to fit your needs
- Push to Heroku
- Migrate the DB to Heroku: heroku run rake db:migrate
I highly suggest that you install it someplace with remote access. That way time requirements can be checked from anywhere.
- Install Ruby on Rails (I suggest http://rvm.io/)
- Install PostgreSQL (http://www.postgresql.org/)
- Pull down the code and set it up
$ git clone [repository url]Note: The repository url can be found on the side of the github page
$ cd timesheet
$ bundle install
- Modify code/settings to fit your needs (you should probably modify config/database.yml to password protect your database)
- Start the server
$ rails server -p [port] -e productionNote: This app uses the default rails server, you probably want to switch to thin, passenger or unicorn for better options and stability. Heroku has this by default
Note: By default rails uses port 3000, that would make the url on a local machine localhost:3000 by default websites normally run on 80 (http) or 443 (https). Some machines don't allow servers open on these ports and Apache or custom routing tables can be used.
You can leave messages for students which will appear in both their profile and on the login page when they sign in/out. Several color options are available. Messages can be found under the "Users" menu
This allows students to enter their reasons for missing requirements, facilitating communication. Once the hours are made up, admins can mark them as such and the requirements pages will show the requirements as met.
There are some settings which can be changed to adapt this for your team. These can be found in lib/constants.rb
The hour requirements settings can be overridden by creating year specific hour requirements in the App. You can find the links under "Timelogs > Hour Requirements" If no value is put in one of those fields, it will assume there is no requirement for that attribute.
- Description
- The time zone associated with the times. It will determine what times show up, when the end of the day is, etc.
- Variable
- self.TimeZone
- Default
- Eastern Standard Time
- Modification
- Change the string to one of the approved rails timezones.
- To get the timezones, you can run the command rake time:zones:all (computer must have RoR installed)
- More info on getting timezone list: http://codedecoder.wordpress.com/2013/09/09/timezone-in-rails/
- Timezones are also listed below
- Description
- The last possible time to sign out for the day. If a record isn't signed out by then, only 1 minute is credited for the day.
- Variable
- DAY_END
- Default
- 1 am
- Modification
- Change the 1 to correspond with the number of hours after midnight to cut off
- Description
- The minimum number of meetings required from a student during build season. This is used in the student view. Will show true/false >based on meeting the different criteria
- Variable
- BUILD_MEETINGS
- Default
- 2 Meeting
- Modification
- Change the 2 to the number of meetings required
- Description
- The minimum number of meetings required from a student during build season. This is used in the student view. Will show true/false >based on meeting the different criteria
- Variable
- PRE_MEETINGS
- Default
- 1 Meeting
- Modification
- Change the 2 to the number of meetings required
- Description
- A signin email which shows only student login page. Allows a computer to be set up and not monitored without giving access to student data.
- Variable
- DEFAULT_LOGIN
- Default
- "signup@team900.org"
- Modification
- Change the string to the email of an account. (Must register account in system)
- Description
- The team's name.
- Variable
- TEAM_NAME
- Default
- "Zebracorns"
- Modification
- Change the string to the team name.
- Description
- A string representing the team's number. Shows up on the home screen.
- Variable
- TEAM_NUMBER
- Default
- "900"
- Modification
- Change the string to representing the team's number.
- Description
- A string representing the main "grouping" of students. Could be school, group, team, division, or any other descriptor your team uses.
- Variable
- SCHOOL_NAME_REPLACEMENT
- Default
- "School"
- Modification
- Change the string to representing the team's main organizational unit.
- Description
- An integer representing the required hours for freshman.
- Variable
- FRESHMAN_HOURS
- Default
- 6
- Modification
- Change the integer to be your required hours for freshman.
- Description
- An integer representing the required hours for sophomores.
- Variable
- SOPHOMORE_HOURS
- Default
- 8
- Modification
- Change the integer to be your required hours for sophomores.
- Description
- An integer representing the required hours for juniors.
- Variable
- JUNIOR_HOURS
- Default
- 10
- Modification
- Change the integer to be your required hours for juniors.
- Description
- An integer representing the required hours for senior.
- Variable
- SENIOR_HOURS
- Default
- 10
- Modification
- Change the integer to be your required hours for senior.
- Description
- An integer representing the required hours for leadership students.
- Variable
- LEADERSHIP_HOURS
- Default
- 15
- Modification
- Change the integer to be your required hours for leadership students.
- Description
- An integer representing the required hours for preseason.
- Variable
- PRE_HOURS
- Default
- 25
- Modification
- Change the integer to be your required hours for preseason.
- Description
- The default number of flex hours given per year. If set to 0, these panels are hidden from students. Flex hours are hours which don't need to be made up, they can be used when students have tests, sickness, etc. They must be submitted before the week is over.
- Variable
- FLEX_HOURS
- Default
- 15 Hours
- Modification
- Change the 15 to the number of flex hours per year (0 to disable feature)
You now need to be sure that you create "years" before a season starts. A year consists of a start date, end date, and build season start date. The time logs are associated with these years as are the statistics.
-
UTC -11:00
- American Samoa
- International Date Line West
- Midway Island
-
UTC -10:00
- Hawaii
-
UTC -09:00
- Alaska
-
UTC -08:00
- Pacific Time (US & Canada)
- Tijuana
-
UTC -07:00
- Arizona
- Chihuahua
- Mazatlan
- Mountain Time (US & Canada)
-
UTC -06:00
- Central America
- Central Time (US & Canada)
- Guadalajara
- Mexico City
- Monterrey
- Saskatchewan
-
UTC -05:00
- Bogota
- Eastern Time (US & Canada)
- Indiana (East)
- Lima
- Quito
-
UTC -04:30
- Caracas
-
UTC -04:00
- Atlantic Time (Canada)
- Georgetown
- La Paz
- Santiago
-
UTC -03:30
- Newfoundland
-
UTC -03:00
- Brasilia
- Buenos Aires
- Greenland
-
UTC -02:00
- Mid-Atlantic
-
UTC -01:00
- Azores
- Cape Verde Is.
-
UTC +00:00
- Casablanca
- Dublin
- Edinburgh
- Lisbon
- London
- Monrovia
- UTC
-
UTC +01:00
- Amsterdam
- Belgrade
- Berlin
- Bern
- Bratislava
- Brussels
- Budapest
- Copenhagen
- Ljubljana
- Madrid
- Paris
- Prague
- Rome
- Sarajevo
- Skopje
- Stockholm
- Vienna
- Warsaw
- West Central Africa
- Zagreb
-
UTC +02:00
- Athens
- Bucharest
- Cairo
- Harare
- Helsinki
- Istanbul
- Jerusalem
- Kyiv
- Pretoria
- Riga
- Sofia
- Tallinn
- Vilnius
-
UTC +03:00
- Baghdad
- Kuwait
- Minsk
- Nairobi
- Riyadh
-
UTC +03:30
- Tehran
-
UTC +04:00
- Abu Dhabi
- Baku
- Moscow
- Muscat
- St. Petersburg
- Tbilisi
- Volgograd
- Yerevan
-
UTC +04:30
- Kabul
-
UTC +05:00
- Islamabad
- Karachi
- Tashkent
-
UTC +05:30
- Chennai
- Kolkata
- Mumbai
- New Delhi
- Sri Jayawardenepura
-
UTC +05:45
- Kathmandu
-
UTC +06:00
- Almaty
- Astana
- Dhaka
- Ekaterinburg
-
UTC +06:30
- Rangoon
-
UTC +07:00
- Bangkok
- Hanoi
- Jakarta
- Novosibirsk
-
UTC +08:00
- Beijing
- Chongqing
- Hong Kong
- Krasnoyarsk
- Kuala Lumpur
- Perth
- Singapore
- Taipei
- Ulaan Bataar
- Urumqi
-
UTC +09:00
- Irkutsk
- Osaka
- Sapporo
- Seoul
- Tokyo
-
UTC +09:30
- Adelaide
- Darwin
-
UTC +10:00
- Brisbane
- Canberra
- Guam
- Hobart
- Melbourne
- Port Moresby
- Sydney
- Yakutsk
-
UTC +11:00
- New Caledonia
- Vladivostok
-
UTC +12:00
- Auckland
- Fiji
- Kamchatka
- Magadan
- Marshall Is.
- Solomon Is.
- Wellington
-
UTC +13:00
- Nuku'alofa
- Samoa
- Tokelau Is.