USER MANUAL
Contents
1. p Indicators Measured Baseline Year Ea Irrigation system A B C D F 1 Key Indicators SUMMARY REPORT FOR PO FI DEUM i INDICATOR LLILL Irrigation system Year 2009 2012 2014 0 4 Wo of farming households in benefit area No 3 95 300 5 Average land area per household in benefit area ha 2049 0 87 6 Overall Average productivity DS rice t ha a ae T Overall Average productivity WS rice t ha Ss sl 3l o Overall Average productivity DS other main crop t ha T sl 3 9 Overall Average productivity WS other main crop t ha 3 3 3 10 Total WS irrigable area ha 18 8 11 WS rice planted in benefit area ha 3 9 4 12 Other WS crops in benefit area ha J a S 4 13 Scheme WS Cropping intensity 3 al 3l Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 NOTE you must select a year to run the Detail by Wealth Group report If you do not select a year or Sub Project the button will be disabled e g no year selected Select a SubProject Po Pi Deum Select a Year Button disabled detail by Wealth Grou Export Check to activate the 6 8 Export to Head Office Export to Head Office Export to HeadOffice button 6 8 1 Export Using MS Outlook For this to work you must have a correctly operating email address working in your MS Outlook SME Module SubProject Po Pi Deu peer ro r2. Once added surveys can be added for the current survey year and later survev vears To add a household press the Household button The Households form appears First check if the Household has been added Use the SubProject Commune Village and Household drop down is to search for a household 010303 Ponley 01030302 Ponley ORI os E e e Family Name e rie eat preme Name Houseno __ Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 If it does not exist click fi Add New Household The background colour will change to light green indicating we are in New Household mode CISIS by MOWRAM Review Edit Households 010303 Ponley l lt F i pas a ton Ml ito e If you did not really want to add a new household click the the Undo button To add a new household select the SubProject Commune and Village where the household is located Now you can add the Household details in Part 2 of the form CISIS by MOWRAM Review Edit Households Q 010303 Ponley 01030301 Ta vong J Wife Family Name Family Name Selecta survey Year Once you have completed all the fields the Save button will appear CISIS by MOWRAM Review Edit Households 010303 Ponley 01030301 Ta Vong Click to save the Part 2 Enter Details Family Name First Name Family Name First Name Ea bess peo son BE smit
3. This form contains the following subforms Add Edit Sub in sesta cocoa Communes included in this Sub Project gt 010303 Ponley v 010801 Phkoam Dist Comey Villages included in this Sub Proiect P 01030301 Ta Vong J A 01030302 Ponley di be Dw poi Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 To delete the 010303 Ponley commune first select it CISIS by MOWRAM Edit SubPrajects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Sf The black arrowhead indicates which record is selected Add Edit Sub Projects EE o Ce OF Ci Ge a Punley Name Communes included in this Sub Project 010303 Ponley RL 0210303 Ponley v Ml o10801 Phkoam v w Click the black arrowhead It will change in appearance to look like this white arrowhead black background 0 0303 Ponley then press the Delete key on your keyboard You will get this warning Microsoft Office Access Relationships that specify cascading deletes are about to cause 1 records in this table and in related tables to be deleted re vou sure you want to delete these records If you are sure you want to delete the record click Yes ATTENTION Be careful deleting records Deleting a record may delete other information that depends on it For example SubProjects require
4. CISIS DATABASE BME MODULE Benefit Monitoring amp Evaluation USER MANUAL for Sub Projects By Greg Regan Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 afd Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 CISIS DATABASE BME MODULE DOCUMENTATION 1 Terms e CISIS Cambodian Information System on Irrigation Schemes e BME Benefit Monitoring and Evaluation e PPMS An alternative name to BME Project Performance Monitoring System e SubProject a specific collection of Communes and Villages and the households of those villages e Project a specific group of SubProjects e MOWRAM Ministry of Water Resources and Meteorology e MS Access Microsoft Access database software e NWISP North West Irrigation a specific section of MOWRAM e Baseline Year the first survey year for a given SubProject 2 History The original CISIS database was designed to facilitate data collection and reporting on Cambodia s circa 3 000 irrigation schemes It covers areas such as infrastructure management operation agricultural uses distribution network and yearly budgeting The BME Module was designed as an addition to the existing CISIS database Its purpose is to assess the correlation between a improvements in irrigation schemes and b improvements in the quality of life of the communities served by those irrigation schemes This author decided to devel
5. Communes If you delete a Commune the SubProject attached to it will also be deleted The survey data attached to that SubProject will in turn be deleted Safeguards have been built into the software to prevent accidental deletion but ultimately the responsibility belongs to the user Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 5 5 Adding New Records Normally records are added to forms using an Add Record button which may look like one of the following When adding records to some forms the form background colour will change to light green indicating the form is in New Record mode CISIS by MOWRAM Review Edk Households ey Review Edit Households gt Da selecta Household by Code Name SubProject village 01030302 Ponbey Households Men p p Woman 9 9 Husband Family Name i First Name Family Name First Name ol 5 s 5 EG a p a House No p Select a Survey Year v In New Record mode some forms will have an Undo button Use this if you decide to cancel adding the new record d When all the necessary data has been completed for the new record you may see the Save button LI Click this to save the new record The form will return to Normal mode the green background will disappear Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 ADDING RECORDS TO S
6. UBFORMS Let s return to the example illustrated in 5 4 above CISIS by MOWRAM Edit SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Add Edit Sub Projects Oe e toft1 a tia ta Communes included in this Sub Project 010303 Ponley v The Phkoam commune is selected 010801 Phkoam v To add a new village just select the x next vacant row indicated by Click the drop down arrow to see records available for selection Villages included in this Sub Proiect 01080105 0u E 01080108 Svay Sa E 01080110 Thma Koul LEO 01080101 Phkoam 01080102 Yeang Vien 01080103 Yeang 01080104 Ampil 01080105 0u Select a new village from the drop down list 5 6 Saving convention Data changes are saved automatically Unlike MS Word or MS Excel there is no Save button to click after making data changes Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 SUBPROJECT PROCESSES CISIS by MOWRAM CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES MAIN MENU Do you use Outlook CI Import O Edit Review My SubProject Yearly Prices Households Data Entry Suvey Section A Survey Section B Reports View Reports Export CI ort to HeadOffice Database development by www completeexcellence com The SubProject Main Menu pictured above shows SubProject proce
7. __r rw o_o T TI MMEe nici N MAIN MENU Check here to use this method Do you use Outlook Import decente ce en a rr resti Make sure you are connected to the Internet Click MS Outlook will be opened automatically and an email to Head Office will be created with a DataExport zip file attached When the process is finished be sure to click Send All in MS Outlook or the email may stay in your Outbox ard 35 Y oe T Send Receive Send Receive All Send All Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 8 2 Export not using MS Outlook If you do not use MS Outlook for your email do not select Do you use Outlook Do you use Outlook L Import gt per cag nale La n Click CISIS by MOWRAM Data Export Done Data Update to Head Office complete copy of the Export Module has been placed on the Desktop Please email this to your Head Office administrator in MOwWRAM A DataExport zip file will be saved to your desktop e g CISIS BME_SubProjectExportModule_002_Po Pi Deum zip Email this to Head Office WARNING Do not change the name of any zip files created by the BME software Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 9 Restoring a Deleted SubProject It s possible that Head Office may accidently delete your SubProject If this happens you will see this message the nex
8. ce responsible for a given SubProject requires its own spreadsheet These need to be collated somehow b Spreadsheets are easy to corrupt rendering collation difficult c The spreadsheet format does not match that of the paper surveys which increases the likelihood of errors e g data being entered in the wrong field d Volume of information the NWISP Project alone includes 11 SubProjects each of which will survey around 100 households per survey year Each survey has around 200 fields A complete evaluation will require two to three survey years Other Projects are foreseen in future Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 3 Overview of the module A complete description of the BME PPMS can be found in the Annexes A SubProject survey consists of 2 parts 1 Part A one survey per SubProject conducted at the Commune level 2 Part B Household Survey A maximum of 100 households will be surveyed per SubProject which is considered to be statistically relevant One aspect of Part A is to roughly determine the percentage of a SubProjects that could be considered Poor Average and Better Off The households selected for surveying in Part B should then match that same demographic composition Head Office is responsible for i Updating regularly from CISIS ii Maintaining SubProject definition only needs to be established once Project definition only needs to be
9. established once Bank lists where SubProject must contact Head Office to add new banks Recommended Water Standards Email Addresses can only be updated by Head Office SubProjects survey years once a survey year is finished for a SubProject Head Office can deactivate that year to prevent accidental changes to the survey data SubProjects can only add data to survey years determined by Head Office This is set individually for RD 2 0 o each SubProject iii Providing each SubProject with their customized module automated iv Reporting this is completely automated CISIS DATA FLOW rovinces Districts Definitions SubProjects Projects Banks National Water Standards Email Addresses Survey Years Head Office SubProjects ni Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 The SubProjects are responsible for i Verifying that the SubProject Definitions are correct ii Requesting changes to Banks and email addresses iii Survey coordination iv Survey data entry The BME modules have been designed primarily with promoting ease of data entry by the SubProvinces e Software screens are bilingual Khmer English e Data entry screens match the paper format e Data exchange with Head Office is simple e Required data fields cannot be omitted e Data types are controlled e g text cannot be entered in a number field e Calculations that were previously done b
10. este POR bottom ri ght side of the screen Table 42 Start Survey You must complete all tables A1 to A5 in the section 6 6 Survey Section B Household surveys Each survey year each SubProject will have a maximum of 100 household surveys to enter Data Enty 7 To start click CISIS by MOWRAM Review Edit Households on Review Edit Households ENTER HOUSEHOLD SURVEY Select a Household by Code Name SubProject Punley v Commune 010303 Ponley v village 01030301 Ta Vong Find a household by selecting the SubProject Commune and Households Village it belongs pira Select the Household from the Smith Households drop down list House No Start Survey gt Select a survey year then the Start Survey button will appear Click this to start entering data Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 Bi Other Income Sources CISIS DATABASE Table BO Household Information SubProject Punley Province Banteay Maanchey District Banteay Meanchey Commune Ponley Village Ta Vong e Complete all data Year 2009 e Click the button at bottom right to move to the next table Gf Plots Ovmed Total Land in project area ha in section e Continue until you have Poor Average completed all sections B1 to _ Better Of
11. etween Khmer and English by selecting the above control 5 2 Code Name Code Name The official government naming of Provinces Districts Communes and Villages also uses a numbering system When selecting any of these you can switch between i Code view Select a Household by Code O Name commune 010201 Banteay Neang ka village 01020102 Phnum E Households Man Poor Poor Woman Poor Poor w ii Name view Select a Household by O Code Name Village 5 3 Exit To exit forms use the Exit button Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 5 4 Deleting records On many forms you will find this control to delete records Check the Check Box to activate the delete button d it By default the button is disabled shown in grey as shown above This is a safeguard so that the Delete Button is not accidently pressed To activate it check the check box Once activated the delete button will appear in colour Once the delete button is clicked as a further safeguard against accidental deletion the user will be warned normally twice that the record is about to be deleted DELETING RECORDS IN SUB FORMS The process for deleting a record in a subform is different Look at the form below CISIS by MOWRAM Edit SubProjects PA CISIS DATABASE Add Edit Sub Projects Form CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES 2
12. f B8 e NB there is no Table B5 Wealth Group on Table BO is the field that corresponds to the By Wealth Group on the MS Word Summary Report If you see many n a in one of the Wealth Group columns it means no household survey data has been entered for that Wealth Group Contract No NIP LCG Appendix A A Baseline Data Survey Questionnaire jem Indicators Measured Baseline Year Ad Does FWUC use an accounting system ie res or No Percentage of HHS satisfied with FYVUC Financial management system Ag Total O amp M tin last1 fi 3 Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 7 View Report Once you have finished all data entry for a survey year you can run two kinds of reports To go to the Reports screen click View Reports CISIS by MOWRAM CISIS DATABASE Ten CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES ae a A aaa BME Module REPORTS MENU Select a suberoject gioni wt w Select a Year 2009 Reports split by Wealth Group for one PEC p tor one Shows one summary column for each survey year Shows reporting indicators History completed survey year It does not show a split by Wealth Group MNU AL U PLL APPEruUla A A Dastillie Lala SUI VO I a KEY INDICATORS Summary Report Form for Overall Scheme Name of Subproject Po Pi Deum ice com Year of Survey 2009 Baseline Year 2009
13. h Bill Smith funi House No 10 Husband wife household indicates that all required data has been entered Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 Once saved the form returns to Normal mode blue background sehold by Code O Na 010303 Ponley v 01030301 Ta Vong Ra Man Smith Bill Woman Smith Jill O rn OSE ye ar e lf you want to start the survey directly you can select a survey rasan te iii Family Name FirstName Family Name FirstName a le appear aurs Tal Selecta Survey Year 20 v 6 5 Survey Section A You must complete Survey Section A for each SubProject in every survey year In Survey Section A there is only one survey to complete To start click Suvey Section A Survey Section A Punte ooo on oc You must select a SubProject and 2009 Si Survey Year or the Start Survey Start Survey gt button will not appear Click to start the surrvey Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 The first screen of Part A appears CISIS Socio Economeai Table Al CISIS DATABASE Table A1 Ranking Of Wealth Distribution teso d le Pia SubProject une Year 2005 Average M Ms Getter off H Hs e Complete all fields e To move to the next table click the button on the erage apap tara
14. op the BME module as a separate MS Access database because a it was felt that the original database may become stressed once used as multi user database for which it was designed b the BME Module was conceived by NWISP a specific section of MOWRAM At the time of development MOWRAM s IT infrastructure was fragmented and it was not clear that NWISP and the existing CISIS administrators could share a common server As such BME was designed as a separate module However the BME module feeds off geographical information contained in CISIS such as government defined Provinces Districts Communities and Villages This data is passed from CISIS to BME to ensure that the 2 systems remain aligned and that maintenance of this geographical information is not duplicated The information is passed via a data package so that the two systems don t require direct communication e g residing on a common server The two systems can reside in completely separate locations and the data updates CISIS to BME can be done by email or flash drive Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 It should be noted that while BME was conceived by NWISP the module has been designed so that new Projects SubProjects can be added at any time The BME was originally designed as a spreadsheet calculation lt was recognized that this would be difficult to maintain over time a Data entry is decentralized so each MOWRAM Commune Offi
15. sses in their logical sequence 6 1 Import from Head Office From time to time Head Office will email you with a data update which will be attached to the email as a zip file For imports from Head Office and also exports to Head Office you have the choice of using MS Outlook or not If you normally use MS Outlook for your email then you can check the Do you use Outlook option Selecting the Outlook option completely automates the process The BME software will automatically open Outlook search the inbox for Data Export files from Head Office save and then process them Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 To activate the Import button click the check box Pia mport Import from HeadOffice If you are not using Outlook you can save the Data Export zip file to your desktop The BME software will move the zip file to the data subfolder then process it Import from HeadOffice Press the button to run the import process This will update the SubProject BME module with additions or deletions to Provinces Districts Communes and Villages translations banks email addresses and survey years IMPORTANT You must do an Import from Head Office the very first time you install the software The software will not work correctly without it If you do not receive a Data Export file from Head Office you must contact them Gregory D Regan Email greg trader yahoo com a
16. t time you do the Data Import from Head Office see section 6 1 above CISIS by MOWRAM WARNING Data Import Failed Po Pi Deum SubProject has been deleted by Head Office Contact Head Office to restore this SubProject Advise Head Office of this problem Ask them to refer to Section 6 13 Restoring a Deleted SubProject of the Head Office User Manual Run the Export to Head Office procedure see Section 6 8 When they restore your SubProject in the Head Office module they must send you a Data Export and you must run the Import process see Section 6 1 Import from Head Office 6 10 Running Compact and Repair Database You should compact and repair your database regularly This keeps the database running efficiently To do this click here 1 oe JA GG Px a k Home dh Cut acer CISISDA CAMBODIAN INFORI BME CISIS by MOWRAM _ Clipboard 6 11 Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95
17. u Mobile 855 0 25 99 95 6 2 My SubProject check your SubProject Head Office is responsible for setting up the SubProjects that is determining which Communes and Villages are included in the SubProject However it is the responsibility of the Commune Office to check that this is correct To do this click the button to see a report showing your SubProject Communes and Villages e rpt_MySubProject x CISIS DATABASE D CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES EITI RE 1 SubProject Commune Village nemo maps Pte pl eme ASI pmm Kjent m jeu Thursday December 17 2009 Fage lofi If the information on the report is not correct email Head Office with any corrections Note to see the report in Khmer choose the language with the language selector before running the report ol c 6 3 Yearly Prices Next you need to add rice and crop prices for the current survey year This needs to be done for each new survey year added This is used to calculate the value of production and farmers income To add yearly prices click Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 On the yearly prices screen follow the steps 1 to 4 CISIS by MOWRAM Enter Annual Crop Prices Price WS Rice S ton Price DS Rice S ton Price WS Crop 5 ton Price DS Crop S ton 6 4 Households In order to add a household survey you first need to add a household
18. y the user on the previous survey form are now handled by the module e g value of production As for Head Office data collation and reporting are automated 4 Installing the software The software must be installed in the location C Program Files MOWRAM_ BME Overview of the sub folders e Database holds the Front End e BackEnd holds the BackEnd e SupportDocs holds the MS Word and MS Excel reporting templates as well as the Fie Edit View Favorites Tools Help Back Ba P Search Wey Folders Gi Address E C Program Files MOWRAM_BME Database Folders ED MowRAM_BME o G Database 9 BackEnd Di Data D Datadrchive O DataReceived O DataSent 9 DiLAndLibraries QD Instructions ID SubProjectModules ID SupportDocs empty SubProject software template e The Data sub folders are used for data exchange between Head Office and the SubProjects It is imperative to respect the above as the software looks for templates and data in the above specific locations Also the Front End user interface looks for the Back End data tables in the location C Program Files MOWRAM_BME Database BackEnd For an explanation of splitting a database into a Front and Back end see my instructional video prepared for the original CISIS database Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 5 Common Controls Navigation 5 1 Translation You can change the screen text b
Download Pdf Manuals
Related Search