Reproductive Transparency Now (RTN) is a registered 503(c) non-profit, volunteer-run organization that engages in operations focused on protesting and raising awareness about anti-abortion crisis pregnancy centers (CPCs), which create harmful barriers to abortion access in all 50 states. One of RTN’s tasks is to manually record citations from informational pamphlets to identity commonly-cited articles and investigate potential misuse of citations and associated claims. To accelerate this process, TechTeam will create a program that uses scripting, Google Drive/Sheets APIs, and other methods to automatically catalog pamphlets, citations, and any relevant information. If possible within the allotted quarter, TechTeam would also like to provide functionality to generate a visual “network” of the relationships between citations, their authors, and the pamphlets that cite them.

The Love Package Project is a non-profit initiative under Chicago Birthworks that delivers monthly packages for expecting & <2 years postpartum Black mothers and parents across the Chicagoland area. Currently, Love Package receives requests through individual form submissions that must be manually processed. TechTeam will create a centralized database to store form submissions and write a script to automate the process of storing form submissions in this database.

American Veterans for Equal Rights (AVER) is a national charter-based non-profit that is dedicated to the promotion of equal rights for LGBT veterans and active service members. TechTeam will make a website or app that allows veterans to document their stories by recording and uploading videos of themselves speaking. This is currently being done over Google Drive, and AVER is seeking to streamline this through an app that veterans can use to more easily record and submit their videos to be stored in Google Drive.

Genesys Works strives to provide pathways to career success for high school students in underserved communities through skills training, meaningful work experiences, and impactful relationships. It currently uses a service called Hello Insight, a youth program that tracks students’ college and career readiness as well as social and emotional learning. TechTeam will conduct data analysis and generate data visualizations to help Genesys Works understand 1) the rate of improvement of young professionals’ Hello Insight scores 2) the relationship between Hello Insight Scores and training and internship success.

Genesys Works strives to provide pathways to career success for high school students in underserved communities through skills training, meaningful work experiences, and impactful relationships. TechTeam will build an Azure Cloud database and migrate existing data on student degree attainment and enrollment from excel files to the cloud. In the second half of the project, TechTeam will tabularize the data and conduct data analysis on factors contributing to degree attainment and enrollment.

The Anti-Human Trafficking Intelligence Initiative (ATII) is a US-based nonprofit that aims to disrupt the market of human trafficking, child exploitation, and child sexual abuse material (CSAM) through the advancement of prevention, detection, investigation, and reporting mechanisms. The ATII develops methods to collect and use OSINT data (including online businesses, email addresses, phone numbers, postal addresses, domains, names, and accounts) to help financial institutions link suspicious activity alerts to human trafficking and related activities. TechTeam will create an automated parsing tool that scrapes provided links and extracts and cleans data, creating a relational database of intelligence. This involves the following: (1) crawl clear web and dark web sites, using a MySQL database to store information such as usernames, emails, phone numbers (2) extract site info such as domain whois and SSL certificates (3) perform basic analytics with OSINT APIs to find connected information and (4) create a keyword cloud of commonly used keywords between sites and pages.