Community Partnership Database
In 2020, I was contracted by Madison Public Library to develop a database of community partnerships to be a clearing house for all programs and services the library provides or fascilitates in the Madison Community. I worked closely with the library's web developer and participated in the Community Engagement Team meetings, leading weekly focus groups to develop this project. Although I was the sole Drupal developer on this project, its planning, conceptual development, testing, and assessment was highly team based.
Features
- A network of community contacts (individuals) and partners (organizations/community groups) with contact information, demographics, and detailed notes on past and current partnerships.
- An intake form for library staff to submit requests f
Process
- Met with the library's web developer to create a project charter (identify objectives, delivrables, stakeholders, etc.).
- Met with the Madison Library Community Engagement Team to identify scope of project, what data to collect, develop a smaller workgroup.
- Developed entity relationship diagram to plan content relations and table structure.
- Created content types in Drupal, and role for test users to create content.
- Presented database to Community Engagement Team (CET) for review, and then to the library's Strategic Partnerships team.
- Trained library staff on how to use the new database and provided written documentation.
- Continually met with CET work group to discuss what had been working well and what changes would be good to make.
