Habitat for Humanity

1. Habitat for Humanity National Database Design Review PURDUE UNIVERSITY

2. National Database Team Immanuel Alexander John Horst Anna Kretz Jeff Ross Noah Solomon PURDUE UNIVERSITY Rev. 01 Fall 2004

3. Problem Statement • Problems for HFHI • No centralized survey administration and data collection system. Some local affiliates do their own surveying, but data is not shared. • There is no concrete quantitative data, currently, to show the benefits of the Habitat program to the community, both locally and nationally. • Homeowner information and responses must be securely collected, transferred, and analyzed to be in line with Habitat’s organizational mission. PURDUE UNIVERSITY

4. Methodology • Proposed Solution • Having a centralized secure server database for survey information and homeowner responses • Homeowner ID’s will be requested from the server but will be kept in paper records as to ensure the security of the information being recorded. • The web-based program will consist of three main parts: • A Survey Generator • Homeowner Response Collection\Input • Statistical Analysis PURDUE UNIVERSITY

5. Technical Solution • The current program relies on a single centralized database to hold the surveys, responses, and a list of questions and answers. It also relies on a web application to act as the front end to the database. • HFHI standards are to use Microsoft products. We have adhered to HFHI standards. We are using ASP.net and MS SQL for this tool. PURDUE UNIVERSITY

6. Design Review • Technical Challenges • Skip patterns: How to represent and implement • New tools and Languages: Visual Studio .net, C#, ASP.net, T-SQL • Efficient automatically generated design documents • Other Challenges • Communication PURDUE UNIVERSITY

7. PURDUE UNIVERSITY

8. Login • Functionality is defined by the type of user logging in. • National User: HFHI employee • Local User: HFH local affiliate PURDUE UNIVERSITY

9. Demo • Enter The Site PURDUE UNIVERSITY

10. National Level: Users • 3 Options: Create, Edit, Delete • Stored User Information: • Affiliate Code • Email • Location • Login (Username) • Password (Hash) PURDUE UNIVERSITY

11. Demo PURDUE UNIVERSITY

12. National Level: Surveys • 4 Options: Create, Edit, Freeze, Decommission • Stored Survey Information: • Name • Questions • Response Types • Survey Status PURDUE UNIVERSITY

13. Demo PURDUE UNIVERSITY

14. National Level: Data • 2 Options: View, Download • Key Issues • Downloading text responses • Quantifying text responses PURDUE UNIVERSITY

15. Local Level • 4 Options • Print Survey • Enter Responses • View Data • Edit Profile • Customer name is not stored by the local affiliate • Provides protection of personal information PURDUE UNIVERSITY

16. Automatic Documentation Generation • For our C# code we are using a combination of XML tags and NDoc 1.3, free software. (example) • For our database we are still looking for a solution due to the large price tag on automatic documentation software. (example) • Apex SQL Doc ~ $200 • SQL Help ~ $75 • Others Even more expensive PURDUE UNIVERSITY

17. Communication Status • Habitat For Humanity International • Habitat For Humanity University • Notre Dame • Butler • Ohio State PURDUE UNIVERSITY

18. What is left? • Local User • View Survey • Print Survey • Enter Data • Retrieve Data • National • Manage Data • Overall • Documentation PURDUE UNIVERSITY

19. Any Questions PURDUE UNIVERSITY

20. Thank you PURDUE UNIVERSITY