Part One: User Functions

Logging in to the NGO Database

To connect to the NGO Database, enter the URL http://cdc.khmer.biz/ngo into the web browser. The first screen of the NGO Database application is the Log-in Screen. To log-in as a guest user, select the "Visitors" icon on the log-in screen (Figure 1).

Figure 1: Logging-in as Guest/Visitor

A guest/visitor will be able to view all of the data, and will be able to sort the data and generate reports, but will not be permitted to edit any of the project records. NGOs who log-in with user name and password will also be able to access the full range of viewing and reporting functions (they will also be able to edit the details of their own project, see Part II).

After logging-in, the user is automatically directed to the opening screen of the NGO Database (Figure 2).

Figure 2: Opening Screen

The user then has several options (indicated in Figure 2):

Search for and view a project or portfolio (by NGO, sector, province, province , thematic maker, CSDGs,NSPPF, TWG, etc)
Limit the search by NGO/Project status (all, Active, Closed, Not-Reported)
View a pre-defined report (project profiles, source of fund by projects, source of fund by NGOs)

By selecting from the menu bar, the user can:

View a list of projects
View a list of NGOs
Design and generate a report
Summary Information (Number of NGOs, Number of On-going Projects, etc…)
Document (Questionnaire form, Manual, annex/glossary)
Contact the Database Administrator and Provide feedback and suggestions regarding the NGO Database

Options 1-7 are described in the following sections (9 is self-explanatory).

Searching for a Project of Portfolio

The following options are available in the "Search Project by" area of the main screen (area marked "1" in Figure 2):

NGO
NGO Type (Foreign / Cambodian NGO)
NGO Status (Active / Closed / Not-Reported)
Project Status (On-going / Completed / Suspended / Pipeline)
Province
Duration (clusters projects into duration of less than one year; 1-3 years etc)
Type of Assistance (Free-Standing TC; Investment Project/Program etc)
Project’s MOU
Sector/Sub-Sector (see Annex Two for a listing of all sectors and sub-sectors)
Thematic Marker
Cambodia Sustainable Development Goals
National Social Protection Policy Framework (NSPPF)
Technical Working Groups (the 19 TWGs administered by RGC)

Clicking on each of the respective options will result in the data presentation (in the area marked "1a" in Figure 2) changing to present the required format.

Clicking on the desired category (in the area marked "1a" in Figure 2) will then direct the user to a list of projects in that category. By scrolling and clicking on the active part of the list, a project record can be viewed, providing more detailed information.

Limiting a Search by NGO/Project Status

The user can restrict a search by NGO status or project status by clicking on the status bar (in the area marked "2" in Figure 2). This allows the user to view all NGOs/projects, or some combination of those that are Active, those that have been Closed or those that have been Not Reported.

Viewing a Pre-defined Report

The user can apply filters to some of the main searches that have been prepared as pre-defined reports so that data on a particular development partner can be extracted more easily.

In the area marked "3" in Figure 2, the user is invited to select from four pre-defined report formats:

Project Summary Report
List of Source of Funds By Projects
List of Source of Funds By NGO

The user then selects the “Type Of NGO” that is required, together with the appropriate Year and Report Option (see Figure 3). For example, the user only wishes to view List of Source of Funds of Foreign NGOs in 2008.

Figure 3: Pre-defined Report criteria

The NGOs’ Source of Funds records (by Type and Year) that are required should then be selected. They will be made available on a separate page. The user can scroll through the records using the "1-2-3…" bars at the top and bottom of the page.

The records can also be printed by selecting the print icon . NGOs’ Source of Funds reports can also be exported to Excel by clicking on the export icon .

To support dialogue at Project level, pre-defined Project profiles have also been produced, by selecting the “List of Source of Funds By Project”.

Viewing a List of Projects

The "List of Projects" in the menu bar (the area marked "4" in Figure 2) can be used to quickly select the whole list of projects (sorted by category of NGO’s acronym). They can then be filtered by NGO’s acronym and by Project Status so that data on a particular NGO can be extracted more easily (see Figure 4).

Figure 4: A List of Projects may be further defined by Project Status or NGO’s Acronym

The user can then scroll through the records using the "1-2-3-…" bars at the top and bottom of the page. Project records can also be printed by selecting the print icon.

Viewing a List of NGOs

The "List of NGOs" in the menu bar (the area marked "5" in Figure 2) can be used to quickly select the whole list of NGOs (sorted by category of NGO’s acronym, NGO Type, NGO Status, etc...). They can then be filtered by NGO Type, NGO Status and by first letter of NGO acronym or NGO name so that data on a particular NGO can be extracted more easily (see Figure 5).

Figure 5: A List of NGOs may be further defined by NGO Status or NGO Type

Designing and Generating a Report

If at any point in time the user selects the "Reports" feature (area marked "6" in Figure 2) from the menu bar, they will be returned to the main screen where reports can be defined and viewed.

The NGO Database main screen provides three options for obtaining reports:

The “Search Project By” feature of the main screen (area marked "1" in Figure 2), which is described in section 2, above.

The Pre-Defined Reports (area marked "3" in Figure 2), described in section 4, above.

The "Design Your Own Report" feature (area marked "6" in Figure 2), which is the most versatile reporting tool (described below).

The "Design Your Own Report" feature permits the user to filter all data criteria according to their own preferences. This process is conducted by simply checking the relevant boxes in the "criteria" section of the report screen. This includes, for example, data on NGO/Type of assistance/Province, etc...

The type of information required according to the search criteria is then selected by checking the appropriate boxes in the "Display Columns" section of the report screen (see Figure 5, below). This includes financial information, project name, start/completion dates, type of assistance etc. as well as main criteria such as NGO name, sector etc. Further filtering according to project status, viewing only on-going projects for example, can be defined by checking the relevant status boxes at the top of the page.

Figure 6: Selection of Report Criteria

Once the criteria have been selected, the user should click the "Search" button located at both the top and bottom of the page. The Report can then be viewed. If the report requires further tailoring, the report screen should be closed and further customization made in the report design page.

Details of individual projects included in the report can be viewed by clicking on the project, which results in the Project Summary Sheet appearing.

Reports can be printed by clicking the icon or, exported or copied to an Excel worksheet (click the icon) for further analysis.