A Scalable Web Application Framework for Monitoring Energy Usage on Campus

Name: Jack Woods
Affiliation: Oregon State University Sustainability Office
Phone: (530) 852-1430
E-mail: woodjack@oregonstate.edu
Website: http://fa.oregonstate.edu/sustainability//
Knowledge Required: 1. Proficiency in Javascript, PHP, HTML, CSS, and other useful web scripting languages.
2. Experience with AngularJS, Bootstrap, or other front-end frameworks.
3. Knowledge of lightweight, efficient, and event-driven back-end frameworks such as NodeJS and ExpressJS.
4. Familiarity with SQL, MySQL, MongoDB, or other database solutions.
Motivation:     Since Oregon State University’s first Earth Day celebration in 1970, OSU has maintained a steadfast commitment to sustainability. In 2007, President Ed Ray signed the American College and University Presidents Climate Commitment as a charter signatory. Within a couple years, the OSU Sustainability Office produced a strategic plan for carbon emission reduction, called the OSU Climate Plan, which called for full carbon neutrality by 2025. This energy dashboard will aid our ongoing efforts as an institution by providing a medium to distribute responsibility for OSU’s carbon footprint more broadly amongst stakeholders within the university, and the surrounding communities.  It will also help building operators implement best practices in energy management, by applying analytical tools like heat maps and alarms.  This work will help reduce costs for the institution, reducing the strain on tuition and other funding sources.
Description:     The Oregon State University Sustainability Office is tasked with monitoring and recording energy and utility usage across the university. This involves collecting large amounts of raw data from a variety of sources, storing it, displaying it in an easily accessible (yet organized) fashion, and utilizing that information to promote smart, sustainable, data-driven solutions for our energy needs.  
    Although OSU has deployed existing off-the-shelf software, vendor pricing may prevent it from being the permanent solution. That’s why we’re looking for passionate EECS students with full-stack development experience to design, implement, and deploy an end-to-end software solution using scalable, industry-standard website and database frameworks. By deploying an innovative energy dashboard, we hope to empower the OSU community to take responsibility for their carbon footprint and save money by reducing energy costs.
Objectives:     Students will be tasked with creating the software infrastructure to collect at least 5,000 data points daily using Obvius brand AcquiSuite Data Acquisition Servers, classify the data, and efficiently store the information in a database. Additionally, students will be engineering, implementing, and deploying an energy dashboard web application which will be able to:
1. Provide innovative visualizations for energy usage data such as heat maps, charts, graphs, building type comparisons, historical comparisons, etc.
2. Produce downloadable data in Microsoft Excel format.
3. Create interactive tools that can be utilized for outreach (such as energy-reduction competitions, etc)
4. Provide active notification through email “alarms” and/or other means when certain thresholds are exceeded, or other criteria met.
Deliverables:     Students will be asked to design, develop, and deploy web-based energy monitoring software.  The software should be able to be maintained by paid OSU employees (student or permanent employees).
Other comments: This is a very open-ended project. We wish to provide students with the opportunity to explore creative/innovative software solutions for our needs.

   D. Kevin McGrath
   Last modified: Fri Oct 20 09:31:13 2017