Fair Districts Georgia
A web application for Fair Districts GA admins to view information regarding volunteers, campaigns, newspapers, and legislators to make it more efficient to organize specific campaign initiatives.
About Project
We are developing a web application for Fair Districts GA to view information regarding volunteers, campaigns, newspapers, and legislators to make it more efficient for admins. Currently, admins are having to manually filter through multiple Excel spreadsheets, each with a large volume of data, to find information on how a volunteer will be writing a letter to their legislator on a specific cause. The goal of this project is to fix this issue by developing a database application to manage Fair District GA's Letter to the Editor program, which will reduce the time spent manually managing and navigating through the current system.
Our Client
Fair Districts Georgia
Fair Districts GA is a non-partisan, non-profit organization that works to encourage a fair and transparent redistricting process in Georgia. Their focus is to fight gerrymandering; the practice of drawing legislative district lines to favor one group over another. Their ultimate goal is to reform Georgia’s process for drawing state and federal electoral maps.
Our Process
Product Scope
Client Goals 🥅
The goal of the project is to develop a database application to manage Fair District GA's Letter to the Editor program, which will reduce the time spent manually managing the current system. This will increase the rate at which the nonprofit can report to volunteers and send out letter assignments and thereby increase volunteer enthusiasm and engagement and Letter to the Editor publication rates by 75%.
End-User Goals ⚽
As an end user for this web application, I want to be able to simply and effectively filter through the information I need to assign volunteers their specific letter writing assignments. This will save me a lot of time as I won't have to manually sort through the letter writing information, leaving me more time to make impactful changes to our legal system.
Technology 💻
The product technology is a database system with five different datasets: newspapers (name, editor, email), volunteers (name, role - subscriber or contributor, zip code), counties, legislators (house or senate, party, district, any special committee involvement), and letters (letters sent, containing information about who sent it, when it was sent, whether it was published). It includes a filtering system to search and sort data by attributes, and a front-end CRUD application to access and manage items in database, and a rating algorithm for newspaper data based on how many times they are published, their circulation rate, their stand locations and digital availability, their price, etc.
Our Solution
Key Features
Campaign Select
This page allows the user to select what campaign that they're assigning volunteers to and what newspapers/publications are associated with the campaign.
Volunteer Database
This database keeps track of all the volunteers associated with the program along with their information and allows admins to edit their information as needed.
Campaign Details
This feature allows admins to set up campaign details including the name of it, a general description field for any information the admins think is necessary, and a date feature.
