Web-based Interactive Software Engineering (WISE) Columbian Park Zoo Volunteer Management

1. Web-based Interactive SoftwareEngineering (WISE)Columbian Park Zoo Volunteer Management 12.6.2012 Purdue University

2. Team Members Columbian Park Zoo Volunteer Management 2

3. Project Background The Columbian Park Zoo project started in Spring 2012 with Courtney Nave, the Zoo’s Volunteer Coordinator The Zoo Volunteer Management system is looking to improve current performance in data collection and organization, while respecting certain systems Will allow volunteers and administration to work more effectively to benefit the community as a whole Columbian Park Zoo Volunteer Management 3

4. Project Requirements and Design The Zoo Volunteer Management system is looking to improve current performance in data collection and organization, while respecting certain systems Columbian Park Zoo Volunteer Management • Existing Record Keeping • Mailed application • Physical bulletin • Paper timesheets • Reports • Suggested Deliverables • Online volunteer submission form • Fixed schedule management • Kiosk interface for clock-in, clock-out • Normalized Database 4

5. Progress Update Columbian Park Zoo Volunteer Management Mock up the Front End and Back End Add databases for the Application Table Create the Web Form Normalized the Database

6. Columbian Park Zoo Volunteer Management Columbian Park Zoo Volunteer Management

7. System Overview

8. Main Portal Columbian Park Zoo Volunteer Management Administrative Page Database Kiosk System

9. Database Structure Entire system relies on implied relationships among a small set of data. Reduces hours of manual cross-referencing.

11. Yii Framework Columbian Park Zoo Volunteer Management Yii Framework is well documented Auto-generates form Error and execution logging Detailed Stack View Default Yii View

12. Modules Overview Columbian Park Zoo Volunteer Management • Each module is an independent piece of functionality that is assigned to a usergroup • Most modules will belong to administrator/staff groups. • Our project partner wants full control over most aspects and there will be little user-to-user interaction

13. Core System Columbian Park Zoo Volunteer Management This includes all functionality of the core application. Implements application wide settings, database logging, and session management. Consists of the YiiFramework

14. User Management Columbian Park Zoo Volunteer Management All user related items (usergroups, users, etc.) Courtney has full user registration control due to the array of special circumstances that happen between the Application, orientation, and a volunteer’s first shift. Users that will be deleted will go into an “Archived” usergroup.

15. User Profile Columbian Park Zoo Volunteer Management Admin only view containing contact information and other personal information populated from the volunteer application. Contains all user specific data organized by table for convenience.

16. Job, Job Category, Location Management Columbian Park Zoo Volunteer Management Ability to add/update possible Jobs and locations. Used by time clock kiosk Used for organizing reports

17. Volunteer Application Columbian Park Zoo Volunteer Management • Frontend Module: Form for collecting data • Backend Module: Allow an admin to view applications and change the status of the application • GREEN(OK) • YELLOW(Pending) • RED(Denied) • GRAY(Unread)

18. Schedule Management Columbian Park Zoo Volunteer Management Simple CRUD form to add shifts and manage in tabular form. This is the most practical approach since most shifts overlap. They are displayed in groups by days of the week.

19. Shift Management Columbian Park Zoo Volunteer Management Add the ability to view all data from the shifts table and make edit to the in/out time or location. This will also be a simple tabular CRUD implementation.

20. Groups Columbian Park Zoo Volunteer Management • Simple CRUD page to manage groups • Also add a tool to assign admins • Undecided if this should be on the group page or user management page.

21. Missed Shift Checking Columbian Park Zoo Volunteer Management Most challenging module Cross check clock-ins against fixed schedule and not affect users not on the schedule

22. Budget and Resources Columbian Park Zoo Volunteer Management • Annual $10 fee for domain name. • Server hosted locally using existing systems at the Zoo(LAMP Setup) • Kiosks use existing Zoo resources. • Easy Configuration and Maintenance • SQLite also an available option by use of PDO

23. The Next Step… Columbian Park Zoo Volunteer Management • Continue Module Development • Design • Develop • Test • Revise • Prepare Delivery Strategies and DFMEA • Confirmed that project will be initially delivered with all specification met

24. Questions and Suggestions Columbian Park Zoo Volunteer Management • Consider the following core areas: • User Interface • Modular Ability • Database Structure • Deployment Process • Technologies Used