Using website for Creating and Managing Database

From TechCampGlobal
Jump to: navigation, search

Group 18

Project Title:

Using website for Creating and Managing Database

Project Participants:

Tapan Parekh, Alkesh Raval, Gaurav Kandel, Ashish Raval, Robin Chaurasiya

NGO Project Lead:

Gaurav Kandel

Technologist Project Lead:

Tapan Parekh

Project Presenter:

Alkesh Raval and Robin Chaurasiya

Group Number:

18


Problem Set Format

Problem sets and solutions provide a method that details everything you need to get support to a critical problem to which an NGO or a grassroots organization faces.

No records

  • Record of beneficiaries
  • Communicating donors
  • Sharing current data
  • Connecting the right message to the right audience
  • Complete records including background
  • Managing virtual Volunteers and their Time
  • Database of trainers by
    • #skills
    • #speciality
    • #time
    • -Database of Partners by
    • #location
    • #Area of expertise
- Mothership - Database of Database

Database of donors and Volunteers by interest vice -versa


Summary of the Problem

This is a description of the problem situation. What kind of people mission better if this problem is solved?

In core the summary of the problem would be,

“A Challenge to adequately communicate the needs, wants and desires of our organization to the different stake holders, volunteers, donors, etc “

The inability to create and maintain a holistic system to meet the needs of all stake holders.

Frustration and helplessness of team members, volunteers in trying to navigate non-existent system and processes.

Inadequate website which fails to address all of the concerns.

A desperate need for a technology or a set of system and processes which helps our non-profit organizations to

SAVE

  • TIME
  • EFFORT
  • MONEY
  • ENVIRONMENT

Summary of the Proposed Solution

This should provide an outline of the basic need that would solve the above problem.

A Solution which incorporates Point of Contact, templates and forms for all the below stake holders.

Sample:

Stakeholders Point of Contact Templates Forms
Donor/Grants
Proposal and Reports
Volunteer
Team Member
Report Template
Beneficiaries
Well Wishers / Partners
Media


Donors

  • Summary of beneficiaries using a email template (Donor Report Template)
  • Annual Reports

Volunteers

  • Opportunity listing
  • Application Procedures
  • Well defined
  • Clear TASK
  • Events
  • Templates
  1. Reports
  2. forms
  3. press release
  4. Survey Forms to find what next ?

Beneficiaries

  • Forms
  • Audio Notice Board
  • Toll Free Number
  • IVR - Interactive Voice Response

Team Members

  • Agenda, Schdule, Calendar
  • All contact details
  • Task List
  • Work Flow
  • SOP – Standard Operating Procedure (E.g. Informing Family, press Release etc. )

Well wishers and Partners

  • News letter or another similar template

Media

  • Resources
  • Press Kit
  • Press relases
  • Photos
  • Media Links of the org


Technology to Solve the Problem

Areas of technology that you believe have the potential to solve this problem? (eg mobile devices, social networks, geospatial technology, etc.). As the proposed solution could be used?

  • A simple to use and maintain, holistic system, to meet the needs of all stake holders.

IMMEDIATE ACTIONs/SOLUTIONS

  • Start Creating forms at Google Docs/Drive, Forms Using Drop Box
  • Google Applications

ADVANCED SOLUTIONS

  • IVR - Interactive Voice Response
  • CRM E.g. www.civicrm.org
  • SMS Based Solution – Frontline SMS


Existing solutions or relevant links

What other information could help technologists working on this idea?


Follow-on Actions

Once a potential solution has been developed, what is your plan of action to implement it? Should arise as a series of steps and goals, preferably together with actions assigned to a specific group of people.

  • Integrating Google aaplications to the organizations email
  • Collaborative projects on the technology solutions
  • Review and update the website