On day 1, I had a Teams meeting with Dr. Summerville to discuss the work I had done over the weekend. What I did was copy all the information, from the questions and answers, of four different donor forms for the WakeMed Mothers’ Milk Bank. We discussed the time it took and knew it was unreasonable to have a volunteer manually read the 2400 forms there are, so we tried to find a pdf to excel converter. All the free converters online made very hard to read sheets so we opted to find converters with a free trial or ones that may be more expensive.
When the mothers donate milk, all their milk is then mixed together and then sent to a lab. If the milk is tested positive for a specific bacteria, it is then disposed of. The goal is to extract data from these forms to then be able to use data analytics to help see what kinds of donors are more at risk of their milk containing a specific bacteria and then make the best possible mixture.