Habitat for Humanity

1. Habitat for Humanity Design and Delivery Review PURDUE UNIVERSITY

2. Team OrganizationSpring 2004 • National Teams • National Database • Tutorials • State Team – Energy Star(Tutorials Sub-Team) • Local Team – Local Database (Delivered) PURDUE UNIVERSITY

3. Agenda • Design Review • Problem Statement • Methodology • Technical Solutions • Next Steps • Delivery Review • Energy Star • Questions PURDUE UNIVERSITY

4. Design Review National Database (NDB) Headquarters (HQ) Tutorials PURDUE UNIVERSITY

5. National Database Team Philip Chennikkara Albert Hidalgo John Horst Drew May PURDUE UNIVERSITY Rev. 01 Fall 2003

6. Problem Statement • Problems for HFHI • Surveys are given to homeowners only in certain areas to local or state affiliates. • There is no concrete way, 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

7. 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 keep 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

8. Technical Solution • The current program relies on a single centralized database to hold the surveys, responses, and a list of questions and answers. • HFHI standards are to use Microsoft products. We have adhered to HFHI standards. We are using ASP.net and mySQL for this tool. PURDUE UNIVERSITY

9. Demo Enter the website PURDUE UNIVERSITY

10. Statistical Analysis • The team is working with a Notre Dame team for the third phase of the tool. (Statistical Analysis) • We are using Crystal Reports for this portion of the tool. • We have one team member as a liaison to the ND team and is also the Crystal Reports integration member. PURDUE UNIVERSITY

11. Crystal Reports • Fully integrated into Visual Studio 2003.net • Small learning curve and easy of use • Has own powerful selection language • Built-in SQL and Graphing functionality • Query any type of database through many different connection types • Crystal Report Viewer Object has the capability to output reports to Acrobat PDF format PURDUE UNIVERSITY

12. National, State, & Affiliate Needs • National • Aggregate data by National, state, & local affiliate • Trends for each state and HFHI overall • Graphs and plots of data • State • Access to the aggregate data sorted by each local affiliate in the state • State aggregate data • Trends and graphs for local affiliates and entire state • Affiliate • Local affiliates need to be able to see Homeowners (by Id) • Each Homeowners answers for each question per generation • Aggregate Data for there affiliate in text and graphical form PURDUE UNIVERSITY

13. User Interface • System will be accessible via the Internet • The final product will contain Crystal Reports and will be implemented using ASP.Net • User interface will be as intuitive as possible to cater to the audience • System will be full integrated into the report system for easy access. PURDUE UNIVERSITY

14. Next Steps • The NDB team is in the process of integrating the statistical analysis. • Waiting on a completed survey from a professor and Ohio State; He is generating the actual surveys that will be used by HFHI. • Trip planned for April 22/23 to show progress to HFHI and get feedback. PURDUE UNIVERSITY

15. Headquarters Jaime Alexander Jessica Davis Andrew Finch Joe Hoffmann PURDUE UNIVERSITY

16. Problem Statement • The purpose of this project is to help develop a regional office and restore building from pre-construction to post-construction, if feasibility of doing so is determined. • This involves creation of pre-sketches, structure assessment, and blue prints. • Also involved is cost analysis and budget determination. PURDUE UNIVERSITY

17. Project Methodology • Meet with Doug Taylor to determine the needs and wants for the building. • Separated what was necessary and what was a dream. • Investigated some existing structures that have similar structures to what is to be designed. • Researched and developed various designs that meet the buildings needs. PURDUE UNIVERSITY

18. 9 small offices 3 large offices large conference room small conference room 2 restore bathrooms 2 main bathrooms small shower Technical SolutionsWhat the designs need to incorporate • sleeping/first aid room • Prefab area • Warehouse • Paint room • Tool storage • Utilities room • restore PURDUE UNIVERSITY

19. First SketchesPlan 1 PURDUE UNIVERSITY

20. First SketchesPlan 2 PURDUE UNIVERSITY

21. First SketchesPlan 3 PURDUE UNIVERSITY

22. First SketchesPlan 4 PURDUE UNIVERSITY

23. Next Steps • Find out exactly what HFH wants • $$$ - estimate costs of building • Raise money for project • Find out about placement & zoning • HVAC systems • Existing or new building PURDUE UNIVERSITY

24. Next Steps These questions need to be answered: • Can the HQ be built in parts? • Where will we get the money? • Where should it be built? • How much will initial construction cost? • What will monthly costs be after it’s built? PURDUE UNIVERSITY

25. Progress and Current Status • Semester Accomplishments • Developed preliminary sketches • Determined use of the structure • Inspected previous plans to determine the shortcomings of them and how to fix these inadequacies PURDUE UNIVERSITY

26. Tutorials Team Richard Black – Team Leader Aaron Rueth John Hostetler Hannah Mugford PURDUE UNIVERSITY

27. Problem Statement • Affiliates need a professional grade construction tutorial geared towards their volunteer base. • Also wish to improve volunteer efficiency by giving them a solid background in their area of contribution. PURDUE UNIVERSITY

28. Methodology for solving the problem • Currently, the tutorials are an Internet-based multimedia tool. • They incorporate text, pictures, and video to instruct users on how to perform basic volunteer construction tasks. • Volunteer Quick-Reference Card PURDUE UNIVERSITY

29. Technical Solution • Database Development Component • Information Database • W3C compliance • Usability and Scalability • PHP front-end • PHP back-end PURDUE UNIVERSITY

30. PURDUE UNIVERSITY

31. Tutorials Development Component • Level one – basic steps • Level two – in-depth information • Current status PURDUE UNIVERSITY

32. Tutorials Development Component • Existing/future video • Reference card template • Tutorial Generator Tool PURDUE UNIVERSITY

33. Next Steps • Integrate Multimedia into Framing and Painting Tutorials • Get feedback from HFHI in order to narrow our scope and design something they want • Developing a tutorial generator tool PURDUE UNIVERSITY

34. Delivery Review Energy Star PURDUE UNIVERSITY

35. Energy Star Team Delivery Review Richard Black Aaron Rueth PURDUE UNIVERSITY

36. Problem Statement • Energy efficiency across Indiana not known • Efficiency awareness needs improvement PURDUE UNIVERSITY

37. Project Methodology • Determine current status of the homes • 21 home inspections by TSI • Perform analysis to find major causes • Rem/Design • Educate state affiliates • Affiliate resource and link on website • Current status PURDUE UNIVERSITY

38. Energy Star • HERS rating • Model Home has a score of 80 • 1 point for every 5% more/less efficient • 86 is Energy Star Efficient • Analysis performed by licensed inspectors • Scores calculated by REM/Design PURDUE UNIVERSITY

39. Progress • Design of new website • Broke up the information into a readable format • Demonstration of website PURDUE UNIVERSITY

40. Any Questions PURDUE UNIVERSITY

41. Thank you PURDUE UNIVERSITY