Page 15 - UNL Senior Design Annual Report 2018-19

Senior Design 2018-2019 Year in Review
The Nebraska Environmental Trust is responsible for distributing Nebraska
Lottery money to worthy environmental projects around the state. In the past, grant applications were made on paper and managed using a legacy Microsoft Access system. But in recent years, Senior Design teams have been building an ASP.NET MVC Web application to allow the Trust to move the grant application and management process online. This year’s team added functionality to allow applications to be approved online and introduced some of the functions necessary
to document progress and fund projects after their applications are approved.
The team started the academic year by learning the ropes and making small improvements. A function was added to export contact information to CSV files for mail merges. Filters were added to the internal contact search. Later in 2018, major changes were made. Features were added for grants administrators to approve applications and send letters and emails to project managers. Project managers were given a page to display all their current projects.
This spring, the team introduced functions to allow project managers to create and submit finalized project budgets, and for grants
administrators to approve or reject those budgets. Similar functions were implemented for the creation, submission, approval, and search of disbursements requests. Finally, creation, submission, and approval of matching funds reports was accomplished. The Nebraska Environmental Trust is close to a “paperless” system which fulfills the organization’s environmental commitment.
Sponsor: Nebraska Environmental Trust Project: Grant Management Functions
The Team
Buck Cronk Mark Hollis Thiam Kiat Sim Linlin Chen Jesus Salazar
Squad Lead and Product Manager Development Manager
Developer
Developer
Developer
15