Fair District Georgia

A web application for Fair Districts GA admins to view information regarding volunteers, campaigns, newspapers, and legislators to make it more efficient for admins.

Fair District Georgia

About Project

Fair District Georgia

We are developing a web application for Fair Districts GA admins 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 the current system.

Fair District

Our Client

Fair District 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 change on 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

Our Team

Reflection 💬

undefined