User`s Manual for CBMS StatSimPro 5.0
Contents
1. q AAA AA Amb ess ue I september i 22 o osso CBMS HPQ VN01201101 8 i a I s Dj TT NN TEN DD jim TT AA DO E T DO lle ts Pa 0 I o y PO OO NN NotApplicale PO E T or ocos Norte 0 11 Batanes eta AONevaEda O Pampanga 15 Tarlac AOJMarinduque dna 79797 0 6 22 Antique Capiz Ollloilo O E 8 4ltih 0000004 S Negros Oriental DO aBfNorthemSamar 680011 71 Sama l Southern Leyte CBMS HPQ VN01201101 9 E Sanga 4 v nMt oine 1 120 CI 2 0 Bioder 0000005 O s o yk I yu rynderarten Preparator Grade 3 Grade 6 7 Doo po TT CBMS HPQ VN01201101 10 d hhDorMSin Agriculture Fishery Forestry etc pf Bachelor of Science in Agriculture Agricultural Technology 4 of Science in Fishery and Forestry JI 20 8PBSEinduding 4 5 including Home Eco and PE 00k8h8k8N OOfPhDorMSMusic and other fields 1 Music 0 1 GBlDoctorate or MS Philo Psycho Spanish Library Science ete 1 in spanish Classicali Bachelor of Lit other fields 12. StatSim Import Paths ka Click OK to start Files to import importina of text file OK Path File Name Size Date Modified Cancel Click Cancel to stop 3 CACBMSDatabasei 3114 0800 031409001 hp3 1 0 MB Tue Jun 07 08 32 34 Importing Autn selection Option to Auto select the text file The user can add multiple text files by going to desired Click Add to add a text paths file by browsing the folders Click Remove to remove an added text Clear Click Clear to remove all added text files 3 After selecting the text file files from the auto selection of levels or through specifying the paths click OK to start 4 After the selected files have been imported a window will appear to ask if the user wants to import another set of data Click Yes button to add again using the same process or No if user is already done importing desired text files StatSimPro ee 5 Another window will appear click Yes to start the processing StatSimPro e Do you want to start the processing 6 A window will appear to ask if the user wants to edit the Purok names Recall that in the CSPro based encoding system all puroks are encoded as codes to reduce mismatches in names This step is very crucial because the labels names of the puroks in this section must match their names in the NRDB file since matching of these files is both case and space sensitive 7 Click Yes to edit the Purok names StatSimPro
3. e Do you want to edit the Puroks 10 ynity Base aN S Sy leuo news CBMS 8 Double click on the PurokName or click Edit to change the names After editing all the names click OK Edit sub village Purok xa Region regniD Il CENTRAL LU 030000000 PurokName purokiD cM 03140900101 cane Purok 2 03140900102 Purok 3 03140900103 Purok 4 03140900104 Purok 5 03140900105 Purok 6 03140900106 Purok 10 03140900110 9 The user will now be prompted to select at what level the data will be processed User can select from the label in the first box and click the button to specify the desired geopolitical levels label label element Click OK to start M processing data Cancel Barangay Household stop processing StatSim Select levels to process Selection Region Province Municipality First Box All levels 1 button Select a single level Second Box All are seen here 2nd button Deselect a single level selected levels Highlight the desired ard button Select multiple levels are seen here level to process data 4th button Deselect multiple levels C Processing the 13 1 CBMS Core Indicators 1 The user will be asked if she he wants to process the CBMS core indicators Click Yes to proceed StatSimPro 54 Do you want to process the 13 1 indicators While StatSim is processing you will see the status of the processing activity at the lower left of the p
4. A NA AAA 8 Working for g vernment of another country SS No Approached relatives fred Others specified ee 6 ff 00 yeunglold retired or permanent dsabled 89 DO lg others specified Nee UN TT NL E EMI 7775 uu SS E _ M Mr ooo 1 1 F FBFBF 1FT 0 uu 4lLegal or de facto separation from spouse for at least oneyerr O XX S Gj bandonment of spouse for at least one year po Any other person who solely provides parental care and support to a child provided he sheisadul Any family member who solely assumes the responsibility as head of the family as a result Quo TE A AE s AA s mar CBMS HPQ VN01201101 13 age oo 2220000000 MN I a o 2 o f IN Use of PWD ID 4 PWD_ID_USE 4 2 Use of PWD ID 5 PWD ID USE 5 A SN 2 O _ fRk O OWM O 2 WM O C o CI Na I ING CC Na TT pg CI o i 5 y id HCN Line number referenced to Ine number PAGE UNE 0 00 SNS Doo TO SNS TT E CC id HCN 1999980808842 LL CBMS HPQ VN01201101 14 a AN Re igeratoriFreeer SSC DD kim 911 Gas 06 b eee EISE A 5 RR EP og Be m fi u c s
5. PAMPANGA 035400000 E QOBALUAG 0314030 TARLAC 036900000 socave 0314040 e 4 ZAMBALES 037100000 BULACAN 0314050 22 AURORA 037700000 T 14 f BATAAN 030800000 Osus us 555 BULACAN 031400000 CALUMPT 0314070 H SOUTHERN TAGALOG CALA 1 0214060 Pa V BICOL REGION 050000000 HAGONO 0314090 lt lt H VI WESTERN VISAYAS 0600000 cry OF MAL 0314100 x en VI CENTRAL VISAYAS 0700000 Quant Ao 0314110 Vill EASTERN VISAYAS 0800000 14 u 4 it 4 m The StatSimPro 5 0 interface will now open Database Name Quick Access Toolbar Je 4 gt StatSimPro BULACAN HAGONOY Home Data Stats Indicators Style Ka ore indicators Application o LGU Specific Indicators Button 5 CEMS Composite Index CCI CBMS StatSimPro 5 0 A The PEP CBMS Network Coordinating Team 1 Developed by the PEP CBMS Network Coordinating Team of the Angelo King Institute for Economic and Business Studies with the E financial support of the government of Canada provided through the International Development Research Centre IDRC and the C BM S Canadian international Development Agency CIDA Status Bar PEP CBMS Network Coordinating Team Table View Note When you are opening a configured database you will not need to do the procedures discussed in b to e 1 Application Button shows a menu of file re
6. 10 A 4 A 0 YY 4 ol l como M Malnourished children 0 5 years old or children who are moderately or severely underweight E Employment Number of malnourished children 0 5 years old over number of children 0 5 years old tn Peare and Order Z Source CBMS 2010 2011 4 rr Tn Source CBMS 2010 2011 F i PEP CBMS Network Coordinating Team Users can also view Selected LGU indicators and the CBMS Composite Index automatically computed by the StatSimPro There are 14 basic needs 14 CMS core indicators that each household should meet The CBMS Composite Index CCI is the sum of all unmet needs of the households For example HH 1 have 1 income below poverty threshold 2 have children who are malnourished and 3 have children who are not attending elementary school Thus the CCI of HH 1 is 3 Below is a sample output Note that the list is sorted according to the lowest to the highest CBMS Composite Index LG StatSimPro BULACAN HAGONOY EX Data Stats Indicators Style 6 o CBMS Core Indicators d CBMS Core Indicators Region d CBMS Core Indicators Province CBMS StatSim Pro 5 0 x gl CBMS Core Indicators Municipality CBMS Composite Index CCI Household al CBMS Core Indicators Barangay Average number of unmet needs T gl CBMS Core Indicators Purok 4 CBMS Core Indicators Household Demography hhid region province muni
7. ECO gt gt gt 15996999 LE ii mje r 1 2 A 1 1 g d i kdldid ydrl ybpre anyordidiin CBMS HPQ VN01201101 15 Accidente hitbyavehide sB c sm 0809 id HCN RC e O nina gt gt OfPhilhealth Individually paying ss A QMhiheth Lfeime O A ar sr QN Barangay O XS OfPrivate Organizations NGOS ooo 8 Ahes 0080080 oo O LO CJ ML SE id HCN Ip 1 4 FFducation Scholarship Program ss 12 MmedtProgram 00008v0V 0 O 5 BtMes Spedfy O q k lt t i l CBMS VN01201101 16 a AA Coo OfPrivateOrganizations NGOS ss 1 i P 2 BOs 0048 A OM O AA O EA O EA Volcanic eruption 20 EA s 889un ffe 75 7757S 58 484N0 5 S Ooestfire 0xX0vnN 0 008VN O 200 QN ep UM I id HCN Doo TT Husband line number refrenced to ne number NKUSBAND ONE TT Wife line number refrenced to line number ln IE LINE TT Ne TT pe BE CC UB I du an gedsn TT CBMS HPQ VN01201101 M Level Core HPQ questionnaire Record Crop Record EE Mt o O id HCN FR e 2 specify 2No 00 10 27 O E E I A 3333 id HCN 199999 MN Moe pO Blinsertiride pesticide sprayer Hand tractor A AAA Other equipment AGRIEQUIPTYPE_O Equipment indicator AGRIEQUIPIND SA AAN ANO Oo
8. IN QN IN QN No QN A ooo 2 WM O oo Me O Oo OWM O Coo OMS O 1 CO OO 1 Quo Ooo Ws O oo WM O O Me v 2 OWM O A Me O IN 4 k 5N4 8N io 8448 Eu eu AA IN IN IN RE DISTRICT T Yes HEART Yes M Yes C C B Yes D eee IN CHOLERA Yes TYP 3 Yes HEAT Yes A A Yes ST l Ye H S l Ye S l Ye S l Ye D S l Ye l Ye l Ye H S l Ye S l Ye O O CURE les A AAA A IA NAAA IAN AAA AAN Brgy Health Station Center CURE BRGY A AAA 4444270443 O Z F 2 AE CBMS HPQ VN01201101 2 DR TT fer ga TT D oedwn SB rote water from Ag Afmubemellorborehole S O SEM rate dug well S O Protected water from spring S O Unprotected water from spring S O rr 7534 S S 4Opapi 989820xX047 kx O ters sped dOwnhoserentfrelotwihconsntofowne 000000 GjRent free house and lot with consent of owner SO gt Bllivingin a public space vrith ren 0060606060 Eo 9llivingin a public space without ren IO Other tenuresaus 00 EIN 000 i g ii I Pp RR 5 DR TT DR TT DR TT DR TT NI DR TT A 101 CBMS HPQ VN01201101 3 pa Mixed but predominantly strong pied but predominantly salvaged ss Mixed but predominantly strong po Mixed but predominantly salvaged O IN IN No o QN S 1 I jNo 060 AA
9. Municipality Barangay Purok and Household StatSim Select levels to process label element label element Household hh Purok purok Cancel Region regn Province prov Municipality mun Barangay brgy GO OQ 4 Click OK The following message box will appear StatsimPro LES ES Exported data contained in PA CXCBMSDatabasexSystemsOutputnd NRDB mdb You are now ready to map GBMS Core Indicators using the CBMS NRDB Refer to User s Manual for building the CBMS Database and Poverty Mapping for the steps b Other Processed tables Other processed tables can also be exported and opened in MS Excel From the Home menu select EXPORT then select the name of the desired table The table will automatically open in Excel 16 DATA DICTIONARY FOR CBM S QUESTIONNAIRE VERSION 01201101 3 A REHPQMENT Mik A T Eggs o COREHPQEGGS 00 Others ERE PQ OTHERS 0 S o TT EBENE Sidewalk EEE eme Commerdalfindustrilegricltur l bullding house qu di qiy I 2 gilas iMewewbey O O O D Eh I 707 EE 7 MD CI PO mi 9 OE S I CBMS HPQ VN01201101 1
10. O EE O s CS A A c c id REGN SS SS SSS a a a a aaa ee ee Province id HCN E O Hog Sow A AI A IDUK o o MM 2 2 212 O id HCN E 080829x04x7v7 O 7 z c 3 x x 5 A EE CBMS HPQ VN01201101 21 am id HCN 1 999999 NA A A A ESA CBMS HPQ VN01201101 22
11. OMMO O id HCN EA OE CBMS HPQ VN01201101 18 gt x D FCAGE AREA 0 999999999 Level Core HPQ questionnaire Record Aquatic animals record Dec Zero em Name id URB ural rban id REGN ata Item tem Label rbanity egion rovince id PROV M uncipality City arangay urok ousehold ID Number 5121215 12 22 zie O lt A iw lt To S I d D 220 15 ES mM NjA U1 C ll r2 199999 sz ine number ype ther type qua Indicator Yes 092 1 olume harvested Level Core HPQ questionnaire ata Item tem Label Item Name LM 0kk42742x0h 1 5698898000 UC 00V00 4282 5 0xv00 8 Mf 799 l4 1inms 78hY779 CUX XKmo Sra 7971S S X C C hHoksadlne 0n es O Item Label Item Name 17134 0 2 1000408 KIT TYPE Affiashlight Emergengylight O de O Mie 797 Yy ds CBMS HPQ VN01201101 19 7 7 Mo O Kit Indicator KIT_IND 7793220 O Level Core HPQ questionnaire Record Live Animal AA AE id HCN A 1 s5 x 8x x x s3s3g irl dk 84 5 hr eri o O V 7 IN 5 AAA O id HCN PR 00 n Au O 5 C 8814 X 1 22 00 AAA Level Core HPQ questionnaire Record Milk ED Moji id HCN M es 1 Mw O DO y Oke y O eee ATP CBMS HPQ VN01201101 20 Level Core HPQ questionnaire Record Eggs A
12. StatSim Report 3 StatSim Report4 x Y y E o CBMS Core Indicators gi CBMS Core Indicators Region J a Province BULACAN III CENTRAL LUZON J CBMS Core Indicators Province Health and Nutrition City Municipality HAGONOY CBMS Core Indicators Municipality PRET gl CBMS Core Indicators Barangay Prevalence of Malnutrition Purok Barangay Abulalas gl CBMS Core Indicators Purok B d CBMS Core Indicators Household m Demography Table 1 malnourished children by sex by purok Health and Nutrition i B malnourished children m be d Prevalence of Malnutrition Region malnourished children 0 5 years old E E i H number of children 0 5 years old gt gl Prevalence of Malnutrition Province gl Prevalence of Malnutrition Municipa 1 1 Prevalence of Malnutrition Barangay A LL A ag Prevalence of Malnutrition Purok Abulalas 6 4 3111 1 0 151 29 0 00 240 child deaths 282 D 8 women who died due to pregnancy relat Purok 01 il 220 r op 000 0001 000 240 Nutrition status Purok 02 0 0 op X 90 000 000 000 O Cause of death Purok 03 9 56 4 op 000 0001 X 000 m Housing Purok 04 0 uv op 000 4 000 000 0 Water and Sanitation Purok 05 el 6 8 1 amp w 1d M Te 20 00 000 d i E Purok 06 4 2 2 0 00 00001 000 i m o Basic education and literacy H Income Purok
13. hard drive space Microsoft Windows 98 Me NT 4 0 2000 XP 32 bit Vista 32 bit and 64 bit Windows 7 Microsoft Office 2003 B Installation The step by step installation procedure below will update the existing CBMS encoding system in the computer The installation is quick and simple Steps in installing the software il 2 3 Insert the installation CD provided by the CBMS Team in the computer s CD ROM drive The setup menu will automatically popup If it does not open windows explorer and double click the CD drive where the CD is located and run manage exe The StatSim Pro 5 0 setup will prepare the Installation Wizard StatSim Pro 5 0 InstallShield Wizard Lo ES Preparing Setup b ae Please wait while the InstallShield Wizard prepares the setup 2 StatSim Pro 5 0 Setup is preparing the InstallShield Wizard which will guide you through the rest of the setup process Please wait The Installation Wizard will start Click Next to proceed with the installation CBMS StatSim Pro 5 0 InstallShield Wizard Welcome to the InstallShield Wizard for StatSim Pro 5 0 The InstallShield Wizard will install StatSim Pro 5 0 on pour computer To continue click Next The setup will require the user to accept the agreement upon using the software After agreeing on the terms click Next StatSim Pro 5 0 InstallShield Wizard License Agreement Please read the following license a
14. means specifying the level to be municipal provincial or regional database For this example create a municipal database View selection L Cancel Selection CBMS Database CACBMSDatabasel a LOCOS REGION 010000000 I Municipality muniD Municipality muniD 1 CAGAYAN VALLEY 02000000C I CENTRAL LUZON 030000000 NUEVA ECUA 034900000 PAMPANGA 035400000 TARLAC 036900000 ZAMBALES 037100000 AURORA 037700000 BATAAN 030800000 i 031400000 MA SOUTHERN TAGALOG CALA V BICOL REG ON 050000000 VI WESTERN VISAYAS 0600000 en VII CENTRAL VISAYAS 0700000 Vill EASTERN VISAYAS 0800000 m OO DIO e Click the button View selection From the listed municipalities double click on the name of the municipality and Click OK For this example StatSim database for the municipality of Hagonoy in Bulacan will be created mem adds IA ee eee ee eee eee StatSim Configure the Database ay Municipality View selection Change selection Cancel Selection iw CBMS Database CACBMSDatabase 1 ILOCOS REGION 010000000 j u D A D 5 68 1 CAGAYAN VALLEY 02000000 Apt mai od CENTRAL LUZON 030000000 ancat 0314010 S HAGONOY 031409000 NUEVA ECUA 034900000 QBALAGTAS 0314020 _ a
15. 00501000004 CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 r 0000 d Ord fm z 1 Pecani Deri 03140900501000007 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 ci 0000 E o LGU Specific Indicators CBMS Composite Index CCI 03140900501000008 II CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 Dp 0000 03140900501000011 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 c 0000 03140900501000012 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 S 0000 03140900501000013 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 t 0000 03140900501000038 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 c 0000 03140900501000039 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 O 0000 EEE 03140900501000040 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 O 0000 03140900501000041 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 0000 1 PEP CBMS Network Coordinating Team Users can simultaneously display reports by clicking on the specific sector and indicator then chose the level of data to view Every time the user selects a report q new window will open and display the selected report For example to view the prevalence of malnutrition at the purok level below is the output report that shows data for all puroks of Brgy Abulalas 12 af CBMS 3 amp E S StatSimPro BULACAN HAGONOY vj SH Home Data Stats Indicators Style i 1 statSim Report 2
16. 2No 1 E Engaged in community social amp personal serviceSERVIND LE no Total income from the activity cash SERVINCSH Total income from the activity cash SERVINKND Engaged in transportation storage amp communicatTRNIND D E 0 H Tota neat 1 o I Total income from entrepreneurial acties Total income from entrepreneurial activities KETOTKND 80 5 5 SMS 6 SNS N Doo CONS 00 000000000 1 4 PR I PR ind CBMS HPQ VN01201101 4 A AR 88888558 I PR o as a PO CONS I CONS PR I PR I 0888888558 Do 00088998999988 NN EN 0 RR 00 8888888558 00 SNS 0 8888888558 Not owned and wiEhouE O O O Other tenure in agricultural land AGRILAND TENUR O Area of farm JAGRILAND_AREA AA OA 41 QN O A AA QN O No ooo 2 Oo 20 O NO IN A 1 0695 1 s v77xXxXxn 814O bB 7373272727 IN CBMS HPQ VN01201101 5 eB 10 1 AAA l Garbage dumped to closed pit GARB_CPIT No NG A WM O Once w
17. BULACAN HAGONOY Abulalas Purok 2 a BULACAN HAGONOY Abulalas Purok 3 ES BULACAN HAGONOY Abulalas Purok 3 BULACAN HAGONOY Abulalas Purok 3 14 BULACAN HAGONOY Abulalas Purok4 as BULACAN HAGONOY Abulalas Purok 4 16 BULACAN HAGONOY Abulalas Purok5 BULACAN HAGONOY Abulalas Purok5 18 BULACAN HAGONOY Abulalas Purok5 19 BULACAN HAGONOY Abulalas Purok5 RUIA hulalas Diirnk IRDB Also a summary report shown as below will be displayed in StatSimPro 1 E CBMS Core Indicators LGU Specific Indicators CBMS Composite Index CBMS StatSim Pro 5 0 CBMS Statistics Simulator Merge Match Report Checking Duplicates in Encoded Households household prov mun 2 frequency E mstance CBMS StatSim Pro 5 0 CBMS Statistics Simulator Merge Match Report Checking Duplicates in CBMS NRDB Households m barangay municipality province frequency 15 G Instructions on Exporting Processed CBMS Data a Core Dataset from CBMS StatSimPro to CBMS NRDB After processing the CBMS Core Indicators using the Statistics Simulator StatSim and ensuring that the household IDs in the encoded file and digitized spot map match the processed dataset can now be exported into the NRDB Pro in order to map the CBMS indicators 1 From the Home menu select EXPORT 2 Select Indicators to NRDB Data Stats In v Status Bar 3 Select the following levels to process whichever is applicable
18. HAGONOY The 1341 dimensions of poverty Barangay Palapat Households M itud P rti Tot maie Female Tots maie i DEMOGRAPHY mms RR a mis meme A A A A A maj mj al si xl 25 CE PE we NE om map na CC sl ini il mil m l n sil we w sl sl sil ns nn rol sl s z l mi sul ssl ns T sil l sil ul Til us 50 4 322 156 20 3 20 8 Members 6 15 years old 203 20 5 PEP CBMS Netvvork Coordinating Team If you choose to display the CBMS Core Indicators at the household level below is the sample output D DEH StatSimPro BULACAN HAGONOY x Home Data Stats Indicators Style gt 6 _ Statsim Report1 Statsim Report 2 StatSim Report 3 x M CBMS Core Indicators d CBMS Core Indicators Region gl CBMS Core Indicators Province CBMS StatSim Pro 5 0 d CBMS Core Indicators Municipality CBMS Core Indicators Household l CBMS Core Indicators Barangay The 13 1 dimensions of poverty gl CBMS Core Indicators Purok d CBMS Core Indicators Household Demography hhid region province municipality barangay purokname hen nrdb 1 E 9 unun 03140900501000001 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 0000 E ousing A 5 5 4 Water and Sanitation 03140900501000002 III CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 t O 0000 6 577700 03140900501000003 TII CENTRAL LUZON BULACAN HAGONOY Palapat Purok 1 c 0000 m Employment 031409
19. OOfBachelor of Science in Philosophy Eo SABA in Geology Geophusis etc A EA 10 89 PhD MS Bank g amp Fin BA Cmrs Eco PoliSci PAdmin Soc IWrk Socio etc 90 BBusAd or Comrcii Sci BS in Commerce or Eco SS SES Food Technology A EEE 91B5M ass Comm HRM etc unspecified 000hN 1 991other Field of Study or Degree not specified IN AAN 5 5758X4m 08284xXx87n9NYl Name of organization 1 ORG NAME 1 Type of community organization 1 ORG TYPE 1 v iPtceli 0 Aric BM O A AA CBMS HPQ VN01201101 11 IN NG Norm AA d Beloy Normal severe 0 O a O d n n n n nn ncc B sB B1B uBnB iBaSy Mah 2 s iri 08008 A CA gm O EA A A A Oer O AO O A O O ecember Ml 20052011 E 2 EA 12 A dirarmersForestry Workers and Fishermen 66000004N s Ss Machine Operators and Assemblers O 9lLaborers and Unskilled Workers O Not Applicable 4lEle iricity Gas Steam and Air Conditioning Supply O A EA Transportation and Storage O Accomodation and Food Service Activities O 2 3 E 1 2 3 5 My A 10 11 12 Real Estate Activities Professional Scientific and Technical Activities Administrative and Support Service Activities Activities of Households as Employers Undifferentiated Goods and Services Producing Activites of S No O CBMS HPQ VN01201101 12
20. QU Paseo t ot Sis Ag Bue SN w leuo new CBMS CRDI 3 IDRC User s Manual for CBM S StatSimPro 5 0 October 2011 Prepared by the CBM S Network Coordinating Team Angelo King Institute for Economic and Business Studies This work was carried out by the PEP CBM S Network Coordinating Team with the financial support of the Government of Canada provided through the International Development Research Centre IDRC and the Canadian International Development Agency CIDA De La Salle University AKI Angelo King Institute i ml Farir s Ne User s Manual for CBM S StatsimPro version 5 0 l Introduction This manual contains guidelines and instructions on the use of the CBMS Statistics Simulator StatSimPro version 5 0 designed and customized for the LGU partners of the CBMS Network Coordinating Team The StatSim is a MySQL application developed to simulate simple computations and tabulations usually done using statistical software or other tabulation applications and also to export indicators for use in dissemination such as tables and maps Although this has the mentioned capability this is not intended to replace the use of more sophisticated statistical software like SAS Stata or SPSS A System Configuration It is required that the following system configuration should be met for better and faster processing VV VVVVV Intel Core processor or higher 1GB of RAM SVGA monitor Mouse 100MB of free
21. age Please note that the length of time required in processing the data depends on the size of the file number of text files that the user is processing and the number of selected levels region province municipality barangay purok and households When done the status will now indicate ready or done 11 PI VEN o n N feuope CBMS D Displaying the CBMS Core Indicators To view the data the StatSim contains the tree view of the report tables in the left side of the interface To display the CBMS Core Indicators click on the CBMS Core Indicators in the report view Choose the level of the data you wish to view If you choose to display the CBMS Core Indicators at the barangay level then you will be able to view an output similar to the one displayed below amp Que I Home Data Stats Indicators CBMS Core Indicators al CBMS Core Indicators Region d CBMS Core Indicators Province gl CBMS Core Indicators Municipality d CBMS Core Indicators Barangay gl CBMS Core Indicators Purok l CBMS Core Indicators Household E o Demography m Health and Nutrition E Housing E Water and Sanitation E o Basic education and literacy E o Income EE o Employment m Peace and Order E o LGU Specific Indicators E CBMS Composite Index CCI StatSimPro BULACAN HAGONOY CBMS StatSim Pro 5 0 Province BULACAN III CENTRAL LUZON CBMS Core Indicators Barangay City Municipality
22. arangays with the highest average unmet needs 13 20 CBMS Core Indicators d CBMS Core Indicators Region d CBMS Core Indicators Province CBMS StatSim Pro 5 0 d CBMS Core Indicators Municipality CBMS Composite Index CCD Barangay 4 CBMS Core Indicators Barangay Average number of unmet needs ks gl CBMS Core Indicators Purok i d CBMS Core Indicators Household 4 CBMS Composite Index CCI brevid region province municipality barangay brgy cci Compost Rec CER Megan 031409001 III CENTRAL LUZON BULACAN HAGONOY Abulalas 1 1528 CBMS Composite Index CCI Province d CBMS Composite Index CCI Municipality z d CBMS Composite Index CCT Barangay CBMS Composite Index CCT Purok CBMS Composite Index CCT Household E Customizing Tables Aside from the automatically generated data users can also create their own tables using all variables found the HPQ Kindly refer to Manual on Executing SQL statements to generate CBMS data using Statsim F Matching Households in the Encoded Data and Digitized Barangay Spot Maps Before exporting the processed dataset into the NRDB Pro you should ensure that the households in your encoded data i e text file match with the households in your digitized barangay spot maps To do this do the following 1 2 Click on Data select Matching q 1 J Home Stats Indicators Ww Reset Database Clear HH Edit Thresholds Process Update Conne
23. bulalas 031409001 Click Cancel to O ba 031409003 stop Importina O Mercado 031409004 O Palapat 031409005 O Pugad 031409006 Sagrada Familia 031409007 O San Agustin 031409008 specify the path Q san Isidro 031409009 to import the San Jose 031409011 text file O San Juan 031409012 AA O San Miguel 031409013 O san Nicolas 031409014 031409015 p Option to First box Second box 1 button Select a single barangay Third box PSGC folder List of barangays under 2nd button Deselect a single barangay List of selected structure each municipality 3rd button Select multiple barangays barangays from 4th button Deselect multiple barangays the second box b Specify path The specify path options allow the user to manually select the encoded data similar to opening files using windows explorer 1 In the window click the button Add to open the browser 2 From the browser select the text file Usually as instructed during the training all the text files follow the PSGC folder structure For example in selecting the text file of Brgy Abulalas Hagonoy Bulacan select the text file 031409001 hpq from the folder CACBMSDatabase V03M 44091001 48 QC y Computer HP C CBMSDatabase 03 14 09 Organize New folder YE Favorites m EE Desktop d 001 8 Downloads 002 Recent Places 4 003 du 004 dl Libraries 4 005 Documents 4 007 al Music di 008
24. cipality barangay purokname 5 03140900103000015 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 03 qi Prevalence of Malnutrition Region 03140900101000468 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 o y oe Fra 03140900101000467 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 d Prevalence of Malnutrition Barangay 03140900101000466 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 03140900103000005 CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 03 S 354 women who died due to pregnancy relat 03140900101000461 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 2 5 03140900101000460 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 5 gif Housing 03140900101000456 III CENTRAL LUZON BULACAN HAGONOY Abulalas 01 z p e 03140900101000454 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 T c n 03140900101000451 m CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 m 03140900101000469 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 03140900101000631 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 03140900103000014 III CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 03 PEP CBMS Network Coordinating Team At the purok and higher geopolitical levels the CCI is the average household scores at that level In the example below the average unmet needs of the households in Brgy Abulalas is 1 This number is useful in targeting b
25. ction Processing You will be prompted to open your NRDB file i e file with mdb file extension To do this go to your CBMSDatabase folder locate the file and click Open all Open JC 03 14 CBMS NRDB v 4 Organize v New folder AB Downloads Name D Recent Places 121 Hagonoy mdb 10 Gai Libraries Documents al Music No previev E Pictures available B Videos n E Computer amp HP C cs FACTORY IMAGE D 4 m File name Hagonoy mdb CBMS NRDB MS Access Files v mm A report similar to the one displayed below will be shown in excel Under the last column with the following heading match will appear any of the following codes 1 1 or O Note that Code 1 denotes that the household ID is found in your encoded file but not in the digitized spot map Code 1 on the other hand 14 ATA CBMS denotes that the household ID is found in the digitized spot map but not found in the encoded file Code 0 meanwhile denotes that the household ID match on both files that is the household ID can be found in both the encoded file as well as in the digitized spot map BULACAN HAGONOY Abulalas Purok1 3 BULACAN HAGONOY Abulalas Purok 1 EX BULACAN HAGONOY Abulalas Purok 1 EE BULACAN HAGONOY Abulalas Purok 1 6 BULACAN HAGONOY Abulalas Purok 1 BULACAN HAGONOY Abulalas Purok 1 8 BULACAN HAGONOY Abulalas Purok 2 9 BULACAN HAGONOY Abulalas Purok 2 10
26. er o A Coo OMe O RE O September 1 Ml A A kn lne 0 v0c0 0004v 1 3 O MUgIE 00008 484 VN 12 September 0 O RAR O A x rv flie O Bhut O c A November E 9 O CBMS HPQ VN01201101 6 A AA in supply of water from the irrigation 1 A ESA gt AAA 1 2 M ore resistant to pests and diseases 3 Thepresentcrop does not require much water 10 The present crop enables the member to earn more profit Others Specify A ess 4 The present crop enables the member to earn more profit 1 o Otiersspedy 32 1 8 4iiffettedbytyhhon 0044841 po Affected by extreme hot weather condition S 1 Others specify E EEE Gjoccurrence of oil spill and other pollution I gt BiFrequent occurrenceoftyphoonss OOOO Others specify AR OOOO 2 SEA_LEVEL Decrease gt lan know 14c cc 4Less frequent delivery of tanker truckfnedder OOOO A ESA A CN p A AAA AAA CBMS HPQ VN01201101 7 sd mort A monthsormore S O RN EEE O O 5 0 O Others specify ____ 2 A Oo O A AAA lt lt A A A 1 dd 48X 0 C X 3 3 1 A ano 5 00 V198999 0 4 U0000h l 1 30 Membersumame CM SNAME Son in a Danit in Tav 00 DO ul TT EEE format EEE A E
27. greement carefully This software is specifically developed for the Community Based Monitoring System Survey Processing and 15 provided for free to partner local government units Please be sure that you fully understand the terms accompanying the us of this program and please take full responsibility on the utilization of this software Should you have amy comments or suggestions please contact the developer PEP CBMS Network 10th floor Angelo King International Center Estrada Corner Arellano Streets Malate Manila 632 5262067 cbas beni 146 edu ph cbas network gmai 1 com waw pep net org gt do not accept the terms of the license agreement A pop up screen will appear asking for Customer Information Enter the name of the user as well as the company office name Click Next StatSim Pro 5 0 InstallShield Wizard Customer Information Please enter your information Please enter your name and the name of the company for which you work User Name Company Name InstallShield uc Backus 8 9 StatSim Pro 5 0 InstallShield Wizard Setup Type Select the setup type to install Please select a setup type Complete f All program features will be installed Requires the most disk space Custom Select which program features you want installed Recommended for advanced users InstallShield n Click Install to begin the In
28. lated commands such as Open Print and etc ynity Base ge 2 Quick Access Toolbar a customizable toolbar that displays the frequently used commands 3 Main Tabs display the main features and functions of the system There are 3 main tabs a Home under this tab the user can import and export data show or hide the status bar and manage the report windows b Data this tab is divided into 2 groups related to data management Under this tab the user can manage the created database reprocess or update the imported data match data with digitized households in NRDB and edit thresholds to be used in processing c Stats Indicators enables the user to directly access the HPQ or BPQ crosstabs of CSPro and creat or customize reports other than the automatically generated reports 4 Database Name displays name of the database being accessed 5 ree View shows the hierarchical view of the available reports generated by the system There are 3 categories of automatically generated reports in the tree view namely CBMS Core Indicators LGU Specific Indicators and CBMS composite Index Each category can be expanded to reveal the sub items 6 Status Bar found at the bottom of the user interface It shows the progress of the importing and processing of data 7 Table View displays the reports selected in the tree view B Importing CBMS Data This section will guide you through the process of importing your e
29. ncoded data file into the StatSimPro In the importing process the StatSimPro transforms the encoded data into a database ready for further processing and tabulation 1 To import an encoded barangay data go to Home in the main tab then select Import Data Stats nd i Clipbaard m E Ctrl D Lr Import existing data The user has 2 ways of importing the encoded data one is the option to select the text file through the Auto selection of levels and the other is by the Specify path option Choose Select questionnaire Cancel Household Profile Questionnaire Auto selection of levels i Specify path ity Basey 4 gt SM V Jeuopes CBMS a Auto Selection of levels The geopolitical levels are pre specified following the Philippine Standard Geographic Code PSGO folder structure In the example below the selection starts from the region next is the province followed by the list of municipalities viewed in the first box and all barangays under each municipality The list of barangays can be seen at the second box in the window Selecting the barangays is easy as selection buttons are present between the second and third box The third box contains barangays which have been selected from the second box StatSim Import Paths 3 Click OK to start importing of text file Change selection OK Barangay brgylD Barangay brayiD me O Carilo 031409002 O A
30. o avoid repeating the steps e he application will guide the user through the process through clicks and dialogs e Create a copy of the CBMSdatabase folder in a remote area which will serve as back up Ill Preparing Encoded Data for StatSim Processing A CBMS Database Structure By now the encoders and processors are most likely familiar with the file structure of the CBMS Database However it must still be noted that the general file folder structure of the CBMS Database is CACBMSDatabase Region Province Municipality Barangay The folder structure was designed so that the encoded data are stored by barangay Thus each barangay folders contains the text ASCII file where the household data are stored Recall that the folder names make use of the Philippine Standard Geographic Codes PSGO For instance if the encoded data of interest is Brgy Pila San Pascual Batangas the target file will be C CBMSDatabase 04 10 26 019 041026019 hpq The file path above refers to the folder containing the encoded data 041026019 hpq of Barangay Pila 019 San Pascual 26 in Batangas 10 in Region IVA 04 The folder structure is the same in all computers used for encoding IV Generating Indicators through the CBMS StatSim Pro A Opening the StatSim 1 Starting the StatSim application a Click on the shortcut icon from the desktop da StatSimPro 5 0 gt All Programs c Glick Start click on All Program
31. s seleci CBMS Database and click on StatSimPro 5 0 23 StatSimPro 50 2 Initializing the StatSim database a The Login window will appear For the username default is admin There is no password required Change the database name according to the name of the province and municipality city Example bulacan_hagonoy Click the button OK 3 CBMS StatSimPro Log Information Host localhost Port Username admin Password Database bulacan hagonoy E b Another window will appear saying that the database still does not exist Click Yes to create and initialize the database Note The next time the user will open StatSimPro 5 0 the database is already in the pulldown list StatSimPro 3 Database bulacan hagonoy still does not exist Do you want to create and initiale i c The StatsimPro is a menu and dialog driven application Thus the user only has to click and select from among the options to proceed and generate the desired outputs Statsim is also a customized application for a specific CBMS questionnaire version and local government unit LGU using the said questionnaire version thus all information contained in questionnaire can be derived and processed for the LGU Each questionnaire is differentiated by the HPQ version number Note that this 1 version of StatSimPro 5 0 released October 2011 is specifically for the latest CBMS HPQ version 01201101 d Configuring the database
32. stallation StatSim Pro 5 0 InstallShield Wizard Ready to Install the Program The wizard is ready to begin installation Click Install to begin the installation If you want to review or change any of your installation settings click Back Click Cancel to exit the wizard InstallShield ma A pop up screen will appear informing that the InstallShield Wizard has successfully installed CBMS StatSimPro 5 0 Click Finish StatSim Pro 5 0 InstallShield Wizard InstallShield Wizard Complete The InstallShield Wizard has successfully installed StatSim Pro 5 0 Click Finish to exit the wizard lt Back Finish Cancel writy Base AN VE SM leuo news CBMS Il General instructions e Set up and maintain a computer that will serve as your data repository This computer should store all encoded text files and NRDB files e Before using the StatSim for processing and consolidating your data check first for the accuracy and consistency of your text files e f needed perform concatenation procedure refer to Section lll of the User s Manual for the Computerized Data Encoding System to merge encoded household data from same barangays This is crucial prior to the simulation process e Check the matching of households in the encoded data and digitized spot map using the Household Identification Number Complete matching of households for both datasets must be attained before processing t
Download Pdf Manuals
Related Search