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
Suicide Prevention and Crisis Services of Yolo County, or SPYC for short, is a non-profit whose mission is to provide crisis intervention and prevention to the residents of Yolo County. They also aim to provide education and community outreach to these residents as well.
The Problem : SPYC currently acts as a home base for those concerned about crises regarding themselves or their loves ones. They provide numerous crisis phone lines for the general public, teens, and evens schools. As a result, they require a clean and comprehensible website in case of emergency.
The Solution Include’s team developed a modern, streamlined website for the Suicide Prevention and Crisis Services of Yolo County. We made it much easier for those in emergency to access available phone lines, as well as find volunteering opportunities and events concerning the group.
Project Leads: Akhil Mehra
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