As a long-time partner of AYLUS Pearland, light and salt association (LSA) stated their need for a data tracking system in order to better track their volunteer events and classes progress. One of AYLUS Pearland alumni, Aaron Wu, led this project with the internship from LSA. AYLUS members Jonathan Niu, Matthew Niu, Aiden Li, and Katherine Wu joined this project as volunteers. They started from scratch, using Apex Oracle platform, built a database called Innovaflow. This database takes data entry from excel files or manual entry, integrate all the volunteers and members’ information, as well as projects and events information. End users can update database as needed, as a result, various reports and analyses will be output automatically. Because AYLUS has the similar needs for such a database, volunteers also applied same strategy to help AYLUS Pearland built a similar database, and expect to expand to other branches.
Job duties:
Jonathan Niu, Matthew Niu: Design interface, set up database, initial data input, test function, implement data reporting and tracking.
Katherine Wu, Aiden Li: test database function, data entry.
After phase 1, the database can be used for data tracking and analyses. Our next step would be polish more on the reporting, generalize it, link it to google workspace, and adding sign-up information to simplify data entry step.
Reported by: Jonathan Niu
| Volunteers | Service Dates | Hours Per Day | Total Hours |
| Jonathan Niu | 5/12, 5/13, 5/21, 6/9, 6/17 | 3 | 15 |
| Jonathan Niu | 6/16, 6/25, 7/1, 7/9 | 2 | 8 |
| Jonathan Niu | 6/12, 6/13, 6/28, 7/10, 7/16 | 1.5 | 7.5 |
| Matthew Niu | 5/12, 5/13, 5/21, 6/9, 6/17 | 3 | 15 |
| Matthew Niu | 6/16, 6/25, 7/1, 7/9 | 2 | 8 |
| Matthew Niu | 6/12, 6/13, 6/28, 7/10, 7/16 | 1.5 | 7.5 |
| Katherine Wu | 6/12, 6/13, 6/20, 6/28 | 1.5 | 6 |
| Aiden Li | 6/28, 7/9, 7/10, 7/16 | 1.5 | 6 |
