During Spring Quarter 2017, three of our development teams worked with three local non-profits to create new websites. We worked with the organizations to produce a website that met each of their needs. Below you can read a bit about each of the projects that we have completed.
FARM Davis is a non-profit organization located in Davis, CA. FARM Davis assists low-income and homeless populations by donating crops grown on donated land using volunteer labor and sustainable farming practices.
The Problem : FARM Davis approached #include with a problem regarding data. Their existing system for recording donations utilized dense excel spreadsheets that were hard to keep track of and difficult to analyze. The data was stored on a local network, so data had to be brought to and entered on local computers.
The Solution #include introduced a solution for FARM Davis in the form of a web application called the FARM Davis Crop Tracker. The Crop Tracker allows FARM Davis to record donation information from any device with an internet connection, and stores the information in a SQL database that allows information to easily and quickly be queried. The application is built on Ruby on Rails and provides features such as user authentication and categorization of crops.
Project Leads: Otto Chen and Austen Winters
UC PLASMA provides seed capital, working spaces, and a plethora of networking opportunities to the Davis startup community. Their 12 week incubator culminates with Demo Day, where ventures pitch to a large audience of qualified investors for a top prize of $5,000.
Our Solution Developing a clean, modern website for PLASMA's 2018-19 program. The finished product can be found here
Project Lead: Megan Brown
GRID Alternatives, headquartered in Oakland, CA, is a non-profit solar installer with regional offices throughout California, and in NY, DC, Colorado, and Nicaragua, whose mission is to make renewable energy technology and job training accessible to underserved communities. GRID designs and installs photovoltaic solar electric systems for the homes of qualifying families at no cost, while training job trainees and volunteers in solar installation skills.
The Problem : The GRID Alternatives North Valley regional office, covering territory throughout northern California from the Sacramento area to the Oregon border, wanted to understand how they could better characterize and inform their outreach and community service by gaining more insight on client, volunteer, and staff demographics. They wanted to compare the demographic profiles of GRID program participants by census tract with the demographic profiles of the regions they serve from the most recent U.S. Census, focusing on factors such as race/ethnicity, gender, age, and more.
The Solution The #include team provided a solution that followed a step-by-step analysis of each census tract, completed for each specified variable. We quantified a value for each demographic factor as a function of the respective factor from the official U.S. Census. We also looked at average energy savings due to the installed solar-electric system for GRID clients within each census tract considered. The results of this analysis will help GRID Alternatives gain a better understanding of how effectively they are serving within various regions, optimize their outreach and training methods for clients, trainees, staff, and other supporters, and support the community in an even more robust way by implementing their mission of making renewable energy accessible for everyone.
Project Leads: Sailesh Patnala and Stephan Zharkov