Software EngineeringEssay Preview: Software EngineeringReport this essayProject 5: Good Neighbors CampaignProject Description:Develop a database to keep track of 20 data points for each of USCs 10,000 employees for the past 10 years (and years to come). This database would need to have the ability to generate reports based on various queries in order to answer questions about donation trends among the University employees.
Team Members:David StarkDavid JengSteven CaoJamal MadniContact:Aggie AfarineshCampaign Finance Manager/Program SpecialistOffice of External RelationsUniversity of Southern California(213) [email protected] 477ЖProject DeliverablesOperational Concept Description1.1 SummaryThe Good Neighbors Campaign (GNC) is an annual giving campaign for the staff and faculty of the University of Southern California. Funds raised by this campaign are granted to nonprofit community organizations located in the University Park and Health Sciences Campus neighborhoods. These funds go toward community development, economic development, health education and support, arts education, and after school programs for children. The University Of Southern California Office Of External Relations (USC OER) is looking for a database that can store all current and historic donations. They would also like a program or system that can streamline data collection as well as generate reports to track campaign effectiveness. Long-term goals include an easy user interface for the donation process.
The system is being built because over the past ten years, the OER has collected a plethora of data and needs an efficient method of interacting and analyzing donation trends. They also would like to have this system implemented for the next campaign drive in fall 2005. At the moment, all data entry is done by hand by a single person. Also, the only way to interact with the database is through one administrators computer. The current process also poses a large potential of human error that could significantly compromise the databases integrity.
The new system will reduce the error and time of data entry. It will generate reports more easily and flexibly as well as inform department heads about the donation of their employees. It will also provide this functionality through a user friendly web interface.
1.1.1 Original Description from ClientThe OER is looking for a database that can integrate all of the donation history for the past ten years. This would include data points for each employee for each of the past ten years. All employee information must be accessed through the payroll department.
1.1.2 Organizational GoalsGoal IdentifierOrganizational GoalIncrease donationsMeasurableSince donations are pledged annually, donations will be measured with respect to previous years.RelevantIncreased donations will provide more funding towards nonprofit organizations located in the University Park and Health Sciences campus neighborhoods that are involved with community development, economic development, health education and support, arts education, and after school programs for children.
Goal IdentifierOrganizational GoalBetter Understanding of Demographic FactorsDescriptionBeing able to categorize donation trends based on a single or combination of factors.MeasurableSince donations are pledged amongst a variety of faculty and staff, demographic factors will include key components such as department, job title, age, salary, tenure, etc.
RelevantHaving a better understanding of demographic factors will aid the Good Neighbors Campaign in planning for future campaigns/projects toward better success in funds raised for nonprofit organizations.
1.1.3 System CapabilitiesOur client needs a fast and efficient database and system that can integrate all of the donation history for the past ten years. Our proposed system will allow for easy data entry and manipulation, user login through a web-interface, report generation, and detailed analysis on donation trends. Unlike the current system in which our client is using, our proposed system will be faster, more efficient, easily maintained, and user friendly.
1.1.4 Key StakeholdersDoris Gallan (System Administrator)Campaign Director/Director of Local Government Relations and Strategic PlanningOffice of External RelationsUniversity of Southern CaliforniaAggie Afarinesh (System Maintainer)Campaign Finance Manager/Program SpecialistOffice of External RelationsUniversity of Southern CaliforniaDevelopersUSC Faculty and Staff (Users)1.1.5 System Boundary and Environment1.2 The Proposed System1.2.1 Project Goals and ConstraintsProject GoalPG-1: Easy to Use and MaintainDescriptionSystem is user friendly and does not require a lot of time to troubleshoot if a problem occurs.MeasurableCount the number of times user must refer to manual to complete certain operations.RelevantEasy for user to analyze donation trends based on demographic
1.2.2 Project Goals and ConstraintsVersion: 1.1.3.1.1 Key StakeholdersEileen Nalton (Manager and Project Coordinator)1.2.2 Primary Goals1.2.3 Secondary Goals1.2.4.1.1 Key Stakeholders(Updated and Revised by the Board)Beth Reedy (Director of Community Programs)1.2.5 System Sustainability 1.2.6 Community Engagement in the System – Planning, R&D and DevelopmentProject Strategy 1.2.7 Community Development & Operations1.2.8.1 Project and Mission 1.2.9 Public and Special Needs1.2.9.1 Project, Planning, R&D and DevelopmentProject Strategy 2.1.1 Community Engagement 1.2.10 Global Outreach (CORE) (Project Management)Project Management, Development and Support 3.2.1 Data Management, Public and Special Needs (Programs)Project Management, Development and Support3.2.2 Information System Development2.2.4 Customer, Local, Regional and Public Services 3.2.4.1 Service 3.2.4.1.1 Project Management project management, development and support projectmanagement, public and special needs projectsData Management.Project Management3.2.4.1 Public and Special Needs3.2.4.1.2 Data management.Project Management.Public Services and Marketing and Sales 3.2.4.2.1 Public and Special NeedsProject Management project management, development and support projectsPublic Services Marketing and Sales 2.1.1.4 Open Web Client Project Management2.1.1.2 Open Web Client project management2.1.1.2 Public and Special NeedsProject Management project management, development and support projectsOpen Web Client Project Management2.1.1.3 Data Management project management, public and special needsProject management, public and special needsData Management2.2.4 Open Web Client project management 2.1.1.4 Public and Special NeedsProject Management project management, development and support projectsData Management3.2 Open Web Client project management 3.1.1 Open Web Client project management3.2 Client projects4.8.1.1 Project Management project management, development and support projectsData Management Projects 3.1.1.2 Open Web Client project management3.2 Client projects4.8.1.2 Project Management project management, development and support projectsData Management Projects 3.1.2 Shared Public Information Project Management3.2.5 Project Management and Development Project Management3.2.5.1 Project Management and Development Project ManagementProject Management Project Project Management/ DevelopmentProject Management Project Management, project support.Project Management 3.2 Server Configuration-CAM (Project Management)3.2.7 Shared Public Information Project Management3.2.8 Project Management and Development Project ManagementProject Management Project Management Project Management Project Management
Public and Special Needs (Programs)
Project