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, Katherine Wu and Alvin Zheng 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.
After phase 1, the basic function of the database is built, and the database can be used for data tracking and analyses. During the past few months, the volunteers worked on the phase 2 of the project, to add more features. Now we can retrieve information and calculate statistics and generate various reports for client’s need. Our next step is to link it to google workspace, and extend its use to other organizations.
Job duties:
Jonathan Niu, Matthew Niu: Design interface, add new features, test function, implement data reporting, calculate statistics, and generate reports.
Alvin Zheng: test database function, data entry.
Reported by: Jonathan Niu
| Volunteers | Service Dates | Hours Per Day | Total Hours |
| Jonathan Niu | 8/3, 8/7, 8/10, 8/16, 9/1, 9/18, 9/25, 9/29, 10/4, 10/25 | 1 | 10 |
| Matthew Niu | 8/3, 8/7, 8/10, 8/16, 9/1, 9/18, 9/25, 9/29, 10/4, 10/25 | 1 | 10 |
| Alvin Zheng | 9/25, 10/25 | 1 | 2 |
