Design and implement a database solution for tracking supplies, finished products and volunteer interaction to deliver PPE to hospitals.
The Research and Impact Team from UNC-Chapel Hill's Innovate Carolina department are pivoting our custom Network Database to support our campus makerspace team and volunteer's in producing visor face shields for UNC Hospitals. Pivoting to a production-base operation from a teaching/learning environment, we are working to track supplies and costs as well as create an end-to-end log of volunteer interaction with the parts and finished shields in case of infection or breakage - products can be identified after delivery if an issue arises.
What is the need are you focusing on?
Sample visor face shield
UNC Hospitals asked our BeAM @ UNC (Be A Maker) network to help bridge the gap in PPE. The BeAM staff evaluated options and determined that visor face shields would be the most effective (cost, time) product for them to make. Within just a few weeks, supplies are sourced, a design made and approved by healthcare workers, volunteers recruited by the School of Medicine student team, and shields are being produced.