The%20Networking%20Home%20for%20Nonprofits

1
The Networking Home for Nonprofits

• Presented by Ryan Amari, Kyle Boorky, Eric
  Czarny, John Ferguson

Department of Computer Science Stonehill
College Easton, MA 02357
2
Background Computer Science Capstone Course

• Most computer science courses are concerned with
  fundamental principles.
• The Capstone course is concerned with real world
  software development and delivery.
• The Capstone course is writing intensive project
  management essay, ethics essay, requirements
  document, design document, user manual.
• The Capstone course is based on a real world
  software development project with a real client.

3
Background Prior Capstone Projects

• Automated Ticketing System
• Automate and streamline Stonehill College Police
  parking ticket process.
• Merit Point Automation System
• Automate and streamline Residence Life Merit
  Point Program for housing lottery.
• This year we wanted to do something a little
  different.

4
Background Computer Science Capstone Project 2007

• The Center for Nonprofit Management
• Recent survey showed that nonprofit organizations
  needed help networking with each other.
• Nonprofits are resource constrained.
• Networking allows nonprofits to share resources.
• Social Networking
• A social network connects people who share
  similar interests, ideas, and goals.
• Examples Facebook, MySpace, Friendster.
• Working with the Center for Nonprofit Management,
  the students in the Computer Science Capstone
  developed NPOnet.

5
What is NPOnet?

• NPOnet is a social networking system that
• Allows local nonprofit organizations to network
  with each other through the use of
• Allows the Center for Nonprofit Management
  collect, analyze, and act on important
  information about local nonprofit organizations,
  including
• Maintaining accurate statistics about nonprofits.
• Analyzing social networks for groups/nonprofits
  of current interest.
• Analyzing shared resources/message boards for
  topics of current interest.

Profiles Events
Affiliates Message Boards
Groups Shared Resources
6
Demo One NPOnet User
7
Demo Two NPOnet Adminstrator
8
The View JSP and JSTL

• lttable width"90" style"margin 10px auto 10px
  auto"gt
• lttrgt
• lttd align"left"gtltstronggtNamelt/stronggtlt/tdgt
• lttd id"group_name"gtltcout value"group.name"
  /gtlt/tdgt
• lt/trgt
• lttrgt
• lttdgtltstronggtDescriptionlt/stronggtlt/tdgt
• lttd id"group_description"gtltcout
  value"group.description"/gtlt/tdgt
• lt/trgt
• lttrgt
• lttd align"left"gtltstronggtOwnerlt/stronggtlt/tdgt
• lttdgtlta href'profile?idltcout
  value"group.ownerID"/gt'gtltcout
  value"group.ownerName"/gtlt/agtlt/tdgt
• lt/trgt
• lttrgt
• lttdgtltstronggtPrivacylt/stronggtlt/tdgt
• lttdgt
• ltcchoosegt
• ltcwhen test"group.isPublic"gtPubliclt/cwhengt
  ltcotherwisegtPrivatelt/cotherwisegt

9
The Controller Business Logic

• public class GroupController implements
  Controller
• protected Log log LogFactory.getLog(getClass())
  
• private GroupDAO groupDAO
• public void setGroupDAO(GroupDAO groupDAO)
• this.groupDAO groupDAO
• public ModelAndView handleRequest(HttpServletRequ
  est request, HttpServletResponse response)
• throws Exception
• MapltString, Objectgt model new
  HashtableltString, Objectgt()
• model.put(group, this,groupDAO.find(request.ge
  tParameter(id)))
• return new ModelAndView(groupView")

10
Servlet Configuration

• ltbean id"loginMapping
• class"org.springframework.web.servlet.handler.Sim
  pleUrlHandlerMapping"gt
• ltproperty name"interceptors"gt
• ltlistgt
• ltref bean"loginInterceptor"/gt
• lt/listgt
• lt/propertygt
• ltproperty name"mappings"gt
• ltpropsgt
• ltprop key"/login"gtloginControllerlt/propgt
• ltprop key"/home"gthomeControllerlt/propgt
• ltprop key"/group"gtgroupControllerlt/propgt
• .
• .
• .
• lt/propsgt
• lt/propertygt
• lt/beangt

11
The Model Data Access Objects

• private static final String INSERT_SQL insert
  into nponet.group
• (name, description, owner_profile_id,
  is_public)
• values (?, ?, ?, ?)
• public void insert(Group group)
• SqlUpdate update new SqlUpdate(dataSource,
  INSERT_SQL)
• update.declareParameter(new SqlParameter(Types.VA
  RCHAR))
• update.declareParameter(new SqlParameter(Types.VA
  RCHAR))
• update.declareParameter(new SqlParameter(Types.IN
  TEGER))
• update.declareParameter(new SqlParameter(Types.BO
  OLEAN))
• update.compile()
• Object parameters new Object
• group.getName(),
• group.getDescription(),
• group.getOwnerID(),
• group.getIsPublic()

12
The Model MySQL Group Table
13
The Model SQL Mapping Queries

• public class GroupMappingQuery extends
  MappingSqlQuery
• public GroupMappingQuery(DataSource
  dataSource)
• super.setDataSource(dataSource)
• protected Object mapRow(ResultSet rs, int i)
  throws SQLException
• Group group new Group()
• group.setDescription(rs.getString("descrip
  tion"))
• group.setId(rs.getInt("id"))
• group.setName(rs.getString("name"))
• group.setOwnerID(rs.getInt("owner_profile_
  id"))
• group.setOwnerName(rs.getString("owner_pro
  file_name"))
• group.setOwnerEmail(rs.getString("owner_em
  ail"))
• group.setIsPublic(rs.getBoolean("is_public
  "))
• group.setMemberCount(rs.getInt("members"))
  
• group.setImageID(rs.getInt("image_id"))
• return group

14
Temporal Analytics

• NPOnet tracks every action that occurs within the
  system.
• NPOnet stores these actions in histories that
  take place over time.

15
Future Work

• Administrative Tools
• Extensible Architecture blogs, wikis, instant
  messaging, more analysis
• Estimated Cost 600 hours for NPOnet at 50/hr is
  30,000
• Grant Opportunities
• Summer Internships

Social Network Analysis
16
Thanks to the Center for Nonprofit Management for
making NPOnet possible.
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)