User`s Manual for CBMS StatSimPro 5.0
Contents
1. 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 NRDB Encoding system and StatSim 4 0 Users can also create or customize reports other than the automatically generated reports using the execute SQL feature 4 Database Name displays name of the database being accessed 5 Tree 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 encoded d2. Home Data Stats Indicators oo ral Municicwity muri E agar j es actas Deawan eocaue Diaci D arimas E caunu ourcwero pong ihai emane mang brary fdiened pma oreg folie fied graji cir OF AL Duanag Va EASTERN Woaves caonoo i a m a Database Name wot m V Status Bar aal Windows Application Button Import Export __ Fites View Window CBMS Core Indicators ci JLACAN HAGONO o x Style t gt d v Other Key Indicators CBMS Composite Index CCI Millennium Development Goals MDGs H Comprehensive Development Plan CDP Tables EEA Climate change Related CCR Indicators bas ww CBMS PEP CBMS Network Coordinating Team Status Bar I CBMS StatSimPro 5 0 lt a Developed by the PEP CBMS Network Coordinating Team of the Angelo King The PEP CBMS Network Coordinating Team Institute for Economic and Business Studies with the financial support of the government of Canada provided through the International Development Research Centre IDRC and the Canadian International Development Agency CIDA Table View ALTA CBMS 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 related commands such as New Print and etc 2 Quick Access Toolbar
3. HAGONOY Abulalas D B Housing 03140900101000456 III CENTRAL LUZON BULACAN HAGONOY Abulalas j DE Water and Sanitation i f f f Q E Basic education and literacy 03140900101000454 III CENTRAL LUZON BULACAN HAGONOY Abulalas l re state i 03140900101000451 III CENTRAL LUZON BULACAN HAGONOY Abulalas 5 D mploymen _ __ __ zE a 03140900101000469 III CENTRAL LUZON BULACAN HAGONOY Abbulalas aE 03140900101000631 III CENTRAL LUZON BULACAN HAGONOY Abulalas 03140900103000014 III CENTRAL LUZON BULACAN HAGONOY Abulalas 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 barangays with the highest average unmet needs CBMs Core Indicators CEMS Composite Index CC gl CBMS Core Indicators Region J CBMS Core Indicators Province J CBMS Core Indicators Municipality J CBMS Core Indicators Barangay gl CBMS Core Indicators Purok J CBMS Core Indicators Household poe J CBMS Composite Index CCT Region J CBMS Composite Index CCI Province brgyid region CBMS StatSim Pro 5 0 CBMS Composite Index CCD Barangay Average number of unmet needs province municipality barangay brgy_cci 03140
4. CBMS Composite Indicators tt Click OK The following message box will appear StatSimPro Exported data contained in oVCBMSDatabase System Output Ind_NRDB mdb Note that all outputs will go to the file Ind_NRDB mdb in the same path C CBMSDatabase System Output d 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 Notes 1 Variables short names are important because the system uses this to make tables It is important to familiarize oneself with the variable names in the data dictionary You cannot tabulate alohanumeric columns This means you could not tabulate texts such as occupation programs perception etc 21 Some commonly used abbreviations acronyms please see data dictionary and list of variable names 1 regn Region code 2 prov Province code 3 mun Municipality code 4 brgy Barangay code 5 purok Purok code 6 hcn household control number ID 7 Prop proportion 8 SWS Safe water supply 9 STF Sanitary toilet facility 10 Death04 Child death 0 4 11 DeathPreg Death due to pregnancy related causes 12 Maln05 Malnutrition 13 Squat Squatters 14 MSH Makeshift housing 15 Povp Poverty 16 Subp Subsistent poverty 17 Fshort Food shortage 18 Unempl15aob Unemployment 15 years old and
5. Stats indicators 4 Status Bar 5 Windows Import Export Fites View Window fA CBMS Core Indicators E 5 a CBMS Core Indicators Region a d CBMS Core Indicators Province fae a CBMS Core Indicators Municipality a CBMS Core Indicators Barangay m al CBMS Core Indicators Purok d CBMS Core Indicators Household Demography Health and Nutrition r Housing Water and Sanitation K Basic education and literacy Income Employment O Peace and Order Other Key Indicators CBMS Composite Index CCI Millennium Development Goals MDGs Comprehensive Development Plan CDP Tables E Climate change Related CCR Indicators O Barangay Profile Questionnaire BPQ Tables Bs Bet Pe oe os 3 H E E 3 J E E F tt CBMS StatSimPro BULACAN HAGONO CBMS StatSim Pro 5 0 CBMS Core Indicators Barangay The 13 1 dimensions of poverty DEMOGRAPHY a Population Province City Municipality Barangay P Average household size Fa Children under 1 year old Children under 5 years old BULACAN Ill CENTRAL LUZON HAGONOY Abulalas Children 0 5 years old 5 Children 6 11 years old Children 6 12 years old PEP CBMS Network Coordinating Team If you choose to display the CBMS Core Indicators at the household level below is the sample output A Ao Ju elni CBMS StatSimPro BULACAN HAGANO C Lo x Home pata
6. in the digitized spot map 18 Province municipality barangay pree hen nrdb match BULACAN HAGONOY Abulalas Purok 1 0 N HAGONOY Abulalas Purok 1 N HAGONOY Abulalas Purok 1 HAGONOY Abulalas Purok 1 ee Abulalas Purok 1 Abulalas Purok 1 Abulalas Purok 2 N HAGONOY Abulalas Purok 2 HAGONOY Abulalas Purok 2 Abulalas Purok 3 Abulalas Purok 3 Abulalas Purok 3 Abulalas Purok 4 Y Abulalas Purok4 Abulalas Purok5 N HAGONOY Abulalas Purok5 E ass Abulalas Purok5 Abulalas Purok 5 WNROMUNFODKFOAWM Wh j de elh e h e hee Pe ehehehe DON Bert 9 Ahnlalas CBMS Core Indicators 8 LGU Specific Indicators i CBMS Composite Index CCD CBMS StatSim Pro 5 0 CBMS Statistics Simulator Merge Match Report Checking Duplicates in Encoded Households prov man aye ee fmm mooo a o uoo 1 o 14 o9 oon o3 o OOO a Cae ee ia o gt oor to fp CBMS StatSim Pro 5 0 CBMS Statistics Simulator Merge Match Report Checking Duplicates in CBMS NRDB Households 19 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 a To export Core indicators Select Core Indicators to
7. programs and files pP y Ft 4 P La Salle Co J f P La Co Initializing the StatSim database 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 38 CBMS StatSimPro exa StatSimPro 5 Log Information Host localhost Port Username admin Password Database bulacan_hagonoy hd cancel _ 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 Ex Database bulacan_hagonoy still does not exist Do you want to create and MD initialize iv Yes i Ne 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 Confi
8. 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 Click on Data select Matching os ee Home Stats Indicators i Reset Database al d 485 Clear HH x Edit Thresholds Process Update Connection 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 TET OV 03 14 CBMS NRDB v 4s Search CBMS NRDE P Organize v New folder z O Downloads A Name j D gt Recent Places 2 Hagonoy mdb 10 Libraries W E Documents a Music No previes Pictures a Videos Computer HP C cow FACTORY_IMAGE D er m r Filename Hagonoy mdb CBMS NRDB MS Access Files Cancel 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 0 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 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
9. 1409007 San Agustin 031409008 San Isidro 031409009 San Jose 031409011 San Juan 031409012 San Miguel 031409013 OSanlicolas 031409014 i 031409015 Option to specify the path to import the text file DO OG 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 2 In the window click the button Add to open the browser 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 hpg from the folder C CBMSDatabase 03 1 4 09 001 a Open GQ gt Computer HP C CBMSDatabase 03 14 09 Organize v New folder Name wr Favorites Ml Desktop J 001 p Downloads i 002 Recent Places i 003 J 004 Ta Libraries 005 Documents J 007 a Music 008 StatSim Import Paths Click OK to start i E importing of text file Files to import OK Path File Name Size Date Modif
10. 4 multi dimensional indicators of poverty the higher the number of CCI the poorer the household is 15 A Ld s StatSimPro BULACAN_HAGONOY Home Data Stats Indicators Style a CBMS Core Indicators a a CBMS Core Indicators Region J a CBMS Core Indicators Province CBMS StatSim Pro 5 0 z 3 J CBMS Core ROMO Municipality CBMS Composite Index CCD Household E CBMS Core icicators Paangay Average number of unmet needs f J CBMS Core Indicators Purok Pods d CBMS Core Indicators Household f Demography hhid region province municipality barangay ta Heath and Nutrition 03140900103000015 II CENTRAL LUZON BULACAN HAGONOY Abulalas 1 4 a malnourished children 5 lt lt Prevalence of Malnutrition Region 03140900101000468 III CENTRAL LUZON BULACAN HAGONOY Abulalas o i Prevalence of Malnutrition Province 03740900101000467 III CENTRAL LUZON BULACAN HAGONOY Abulalas ia p y Prevalence of Malnutrition Municipa n yl Prevalence of Malnutrition Barangay 03140900101000466 III CENTRAL LUZON BULACAN HAGONOY Abulalas m PE M aad 03140900103000005 TII CENTRAL LUZON BULACAN HAGONOY Abulalas g es f i j E women who died due to pregnancy relat 03140900101000461 III CENTRAL LUZON BULACAN HAGONOY Abulalas Nutrition stat mt i i o noin 03140900101000460 III CENTRAL LUZON BULACAN
11. 5 years old gf Prevalence of Malnutrition Province a gp Prevalence of Malnutrition Municipa a Ji Prevalence of Malnutrition Barangay i __ ______ j______ j ____ ____ h __ g e JJ Prevalence of Malnutrition Purok Abulalas PST tt of aaf 2ga 000 E child deaths if II ____f ___ 7 i women who died due to pregnancy relat Purok 01 a zl wm w o o wo o B Nutrition status Purok 02 O of of of of of of oof oof 000 ta Cause of death Purok 03 po 0 00 4 Housing Purok 04 Po 0 00 H Water and Sanitation Purok 05 O e Sl sa a A y l 20 00 0 00 P Purok 06 Po T0001 O Basic education and literacy pr amm Purok 10 D o TT 000 om Malnourished children 0 5 years old or children who are moderately or severely underweight H Employment umber of malnourished children 0 5 years old over number of children 0 5 years old rs Source CBMS 2010 2011 Source CBMS 2010 2011 zl Deare and Order uw PEP CBMS Network Coordinating Team 2 Users can also view the following reports automatically computed by StatSim Pro a Other Key Indicators Automatically generated reports are now available for selected key indicators found in the HPQ Data Sv indies en 5 DEJ Moida Windowt a hipon Esport r Hamr Fran Whew Wirda 4 a CBM Core Indicators E E thes Kry Indicate BULACAN MI in nd atori Province 1 4 amp Beneficiaries of peogram Beneficiaries of pro
12. 9001 III CENTRAL LUZON BULACAN HAGONOY Abulalas 1 1528 S J CBMS Composite Index CCI Municipality Among puroks Purok 04 has the highest average unmet needs j RMS Salni BILAL AM HAGAN ON teh 5 F Status Ear S vynas meet Epor Heme Pies ihe Wingo a CMG Cone Incocators 2 Osher Key Indicators By CAMS Compote Indes CEt E CEMS Componse index OCH Regien a COME Compose Index CER Province F CRR Conspocte Indes OCT Muneipaity a CEMS Composte index CCH Barengey CBMS StatSim Pro 5 0 CEMS Compesite Index OCT Purok Average ninder of urine masdi parckad region province o municipality barangay purokmame porok_eci 03140900106 I CENTRAL LUZON BULACAN HAGONOY Abulalas PorokO6 0 5714 0314090103 I CENTRAL LUZON BULACAN HAGONOY Abulalas Puok 03 0 9706 02140900110 M CENTRAL LUZON BULACAN HAGONOY Abulalns Purok 10 1 0000 02140900108 fl CENTRAL LUZON BULACAN HAGONOY Aias Purok 04 1 1563 03140900101 M CENTRAL LUZON BULACAN HAGONOY Abulalas Purok 01 13793 OF140900107 Ii CENTRAL LUZON BULACAN HAGONOY Abulalac Purok 02 1 5567 01409104 M CENTRAL LUZON BULACAN HAGONOY Abualas Burak 04 10000 CBA Conpocte Indes OCD Heovehold Mitennium Develepenent Goals Miis i iy Comprehendeve Dievtlcpened Plan COP Tabled z i Cemar changi Arlibed COR indie atest E Barangay Prete Questionnave PQ Tables bie aan i adh 16 ap c Millennium Development Goa
13. Fa Ws 4 De ln Bele Acari a CRDI 3E IDRC AKI User s Manual for CBMS StatSimPro 5 0 February 2012 Prepared by the CBMS Network Angelo King Institute for Economic and Business Studies This work was carried out by the PEP Asia CBMS Network with the financial support of the Government of Canada provided through the International Development Research Centre IDRC and the Canadian International Development Agency CIDA QM CBMS User s Manual for CBMS StatSimPro version 5 0 I 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 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 recommended that the following system configuration should be met for better and faster processing Intel Core processor or higher 1GB of RAM SVGA monitor Mouse 1GB of free hard drive space Microsoft Windows XP 32 bit Vista 32 bit and 64 bit Windows 7 Microsoft Office 2003 VVVVVV V B Installation The step by step install
14. NRDB Data Stats Indicators V Status Bar aa Windows 7 Core Indicators to NRDE CBMS Composite Indicators q Millennium Development Goals TI bad Select table h Select the following levels to process whichever is applicable Municipality Barangay Purok and StatSim Select levels to process label element label element Diii Region regn O Household hh Province prov J f Purok purok Municipality mun Barangay brgy r lt 4 Click OK The following message box will appear StatSimPro Exported data contained in OoACBMSDatabase System Output Ind_NRDB mdb OK You are now ready to map CBMS Core Indicators using the CBMS NRDB Refer to User s Manual for building the CBMS Database and Poverty Mapping for the steps b To export CCl select CBMS Composite Indicators _ a Data Stats Indicators v Status Bar 5 Window q Millennium Development Goals gt Select table L al CBMS Composite Index CCD Provin 20 QM CBMS Click OK The following message box will appear StatSimPro Exported data contained in oACBMSDatabase System Output Ind_NRDB mdb OK Note that all outputs will go to the file Ind_NRDB mdb in the same path C CBMSDatabase System Output C To export MDG data select Millennium Development Goals w Data Stats Indicators J Status Bar Window Core Indicators to NRDB
15. Stats Indicators E _ NE Style Reset Database Zi 33e Matching aal A Clear HH ETIE AL Edit Thresholds Connection Processing g K CBMS Core Indicators ie J CBMS Core Indicators Region J CBMS Core Indicators Province y CBMS Core Indicators Municipality d CBMS Core Indicators Barangay s J CBMS Core Indicators Purok CBMS StatSim Pro 5 0 CBMS Core Indicators Household The 13 1 dimensions of poverty d r T r i H Demography hhid l region province municipality barangay hen her E ne ana Nutitiop 03140900101000040 III CENTRAL LUZON BULACAN HAGONOY Abulalas O oi ousing i iaa 22 Water and Sanitation 03140900101000070 TII CENTRAL LUZON BULACAN HAGONOY Abulalas a 001 E e neiii 03140900101000083 III CENTRAL LUZON BULACAN HAGONOY Abulalas 001 P i f i 7 E Employment 03140900101000293 III CENTRAL LUZON BULACAN HAGONOY Abulalas ee 293 00 QP d Ord p JS E a ee et ee i Pe Aerie si 03140900101000294 TII CENTRAL LUZON BULACAN HAGONOY Abulalas 294 00 is CBMS Composite Index CCI 03140900101000295 TII CENTRAL LUZON BULACAN HAGONOY Abulalas oO 295 001 H Millennium Development Goals MDGs yo G Coimpiehenive Developinienk Phan CDP Tables 03140900101000297 III CENTRAL LUZON BULACAN HAGONOY Abulalas Ta 297 H q a RIIT E SEN X ETA TEPA OSE Tatana me a gt DA TA e c9 Climate change Rela
16. above 19 Elem612 Elementary participation 6 12 20 Elem611 Elementary participation 6 11 21 HS1316 High school participation 13 16 22 HS1215 High school participation 12 15 21 Sch616 School participation 6 16 21 Sch615 School participation 6 15 22
17. ata 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 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 H ousehold Profile Questionnaire Auto selection of levels Specify path Auto Selection of levels The geopolitical levels are pre specified following the Philippine Standard Geographic Code PSGC 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 zs Jj Click OK to start importing of text file Change selection OK Barangay brayiD Barangay brgyiD f i Carilo 031409002 Abulalas 031409001 Click Cancel to ba 031409003 stop Importina Mercado 031409004 Palapat 031409005 Pugad 031409006 Sagrada Familia 03
18. ation procedure below will update the existing CBMS encoding system in the computer The installation is quick and simple Steps in installing the software 1 Insert the installation CD provided by the CBMS Team in the computer s CD ROM drive 2 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 3 The StatSim Pro 5 0 setup will prepare the Installation Wizard StatSim Pro 5 0 InstallShield Wizard Preparing Setup os Please wait while the InstallShield Wizard prepares the setup StatSim Pro 5 0 Setup is preparing the InstallShield Wizard which will guide you through the rest of the setup process Please wait 4 The Installation Wizard will start Click Next to proceed with the installation 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 your 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 agreement carefully This software is specifically developed for the Community Based Monitoring System Survey Processing and is provided for free to partner local government units Plea
19. es that the user is processing and the number of selected levels region province municipality barangay purok and households When done the user will be prompted that processing has been completed Also the status bar will now indicate ready or done m StatSimPro a s A Processing has been completed 2 Millennium Development Goals Indicators Localized MDG indicators can also be processed in the StatsimPro 5 0 To generate the table containing MDG indicators go to Data and click Process Update Select Process Millennium Development Goals Stats Indicators 33e Matching A Edit Thresholds l Process update Core Indicators Ind gt Process Other Key Indicators idic gt Process Climate Change Related Indicators aries o Pprogrorrr s of programs Then select the levels to process and click OK StatSim Select levels to process Selection Cancel label element label element Purok purok Barangay brgy Region regn Province Municipality mun Oo oO 3 Other Key Indicators StatSim Pro 5 0 can also process and generate results on other key indicators that are related to programs community participation migration Senior Citizens PWDs Solo parents and others To process these indicators go to Data and click Process Update Select Process Other Key Indicators 12 w Process update Core Indicators Proce
20. gram CENTRAL LUZON JE Types of programs City Municipality HAGONOY ea E rograms Baranga rangay i if Typet of programs Region Types of prog B gay Ba Abulalas jf Types of programs Province B Typet of programs Municspality Table 1 Types of programs by Baranga i amp Comnunety Particapatear ype prog nay gay Housing dwelling i A Migeainon Persons with disability PWD i A Sen Capen Barangay MQ Household health Abulalas i A Memberi of hidgengui Tinker PED Membert with 557055 1 4 Member whe paperi boards bar Euih Pantaad Pamilyang RA Membert whe are solo patents Filipina Progam Househetds by type of garbage collection APs Conditional p QD Entrepreneurial actrvtes Cash Transler l HED CENE Campersite Inder OCT HFA rce pogram e sete Comprehensive oe Program CARP 5 Philhealth OFW f FEFCEMS Network Coordinating Team b CBMS Composite Index There are 14 basic needs 14 CMS core indicators that each household should meet The CBMS Composite Index CCl 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 This index is useful in targeting beneficiaries of programs In terms of the 1
21. guring the database means specifying the level to be municipal provincial or regional database For this example create a municipal database CBMS x _ View selection oe cel Selection CBMS Database C CBMSDatabase a LOCOS REGION 010000000 Municipalty muniD Municipalty muniD ll CAGAYAN VALLEY 02000000C ll CENTRAL LUZON 030000000 NUEVA ECUA 034900000 PAMPANGA 035400000 I TARLAC 036900000 LI ZAMBALES 037100000 AURORA 037700000 LI BATAAN 030800000 VA SOUTHERN TAGALOG CALA 4 V BICOL REGION 050000000 H VI WESTERN VISAYAS 0600000 VII CENTRAL VISAYAS 0700000 Vill EASTERN VISAYAS 0800000 oO 4 m r 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 CENS Dalabaie CACM SDa E HDi LOCS REGGH onioodood p Oi CAGAYAM VALLEY ccbotnd0L Ea CENTRAL LUZON Co0cd00R NUEVA E UA 024900000 D panpana oe0neo0 TARLAC 0000r D ZAuDALES oo IeON D AURORA GITO D BATAAN 03900000 E ee Ava BOUTS TAGALOG CALA filet W RIGO RAGGA O8505000 E Vi WES TAN VISAYAS GBEIGON E Vi CENTRAL VISAYAS GMAODH The StatSimPro 5 0 interface will now open Quick Access Toolbar jd
22. ied EE Click Cancel to stop yg CACBMSDatabaseW3i14 0900 031409001 hpg 1 0 MB Tue Jun OF 06 32 34 es Impo rting Auto selections Option to Auto select the text file Click Add to add a text file by browsing the folders m The user can add multiple text files by going to desired paths i 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 5 Another window will appear click Yes to start the processing StatSimPro 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 10 FRY CBMS 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 E Do you want to edit the Puroks 8 Double click on the PurokName or click Edit to change the name
23. ls CERES Statham Cems Statim Pro 5 0 Province BULACAN Ill CENTRAL LUZON Millennium Development Goals MOGs Barangay City Municipality HAGONOY MDG Indicators using CAMS Barangay Abulalas Millennium Development Goals Gee a el EE a j Male C a Sa Eats ae Fo a a bret Pica r ey aaa eae E a a el a ee Proporion of poputation with income below food teshadi a asf ass j 76 ass Ponty Gap Rata oa o Proportion of papiation whe axpenemced food shomage Employment rate Prevalence of undenenight chikkan under 5 years of age CEMS StatSim Pro 5 0 Comprebensive Development Plan CDP Tables Barangay Sex by Civil Storus Abulolas HAGONOY BULACAN Total 306 293 599 CEMS StatSim Pro 5 0 Comprebensive Development Plan CDP Tables Barangay Sex by Age Group Abulala HAGONOY BULACAN Agriculture Households engaged in agriculture Purok City Municipality HAGONOY Barangay Abulalas Table 1 Households engaged in agriculture by purok 17 aa MA aa CBMS 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
24. n If you want to review or change any of your installation settings click Back Click Cancel to exit the wizard InstallShield es ra Cca 9 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 Cancel 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 Ill of the Users 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 to avoid repeating the steps e The 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 lll Preparing Encoded Data f
25. or 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 C CBMSDatabase lt Region gt lt Province gt lt Municipality gt lt Barangay gt 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 PSGC 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 b Click on the shortcut icon in the Start Menu E StatSimPro 5 0 gt All Programs Search programs and files p o o r C Click Start click on All Programs select CBMS Database and click on StatSimPro 5 0 lt 4 StatSimPro 5 0 x Back Search programs and files p Search
26. s After editing all the names click OK Edit sub village Purok xa Region regniD lll CENTRAL LU 030000000 PurokName purokiD Purok 2 03140900102 ah 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 Click OK to start processing data Barangay i Piik Click Cancel to Household stop processing StatSim Select levels to process Selection label label element Region Province Municipality DO OH First Box All levels are seen here Highlight the desired level to process data 1 button Select a single level 2nd button Deselect a single level 3rd button Select multiple levels 4th button Deselect multiple levels Second Box All selected levels are seen here C Processing CBMS Data 1 1341 Core Indicators The user will be asked if he she wants to process the CBMS core indicators Click Yes to proceed 11 StatSimPro K Q 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 page Please note that the length of time required in processing the data depends on the size of the file number of text fil
27. se be sure that you fully understand the teres accompanying the usage of this program and please take full responsibility on the utilization of this software Should you have any comments or suggestions please contact the developer PEP CEMS Network 10th Floor Angelo King International Center Estrada Corner Arellano Streets Malate Manila 632 5 262067 cbes beni lde edu ph chas network gmai l com waw pep net org accept the terms of the license agreement A 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 Wieerd l 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 StatSim Pro 5 0 InstallShield Wizard Setup Type Select the setup type to install Please select a setup type Complete fe All program features will be installed Requires the most disk space Custom Select which program features you want installed Recommended for advanced users InstallShield re cs 8 Click Install to begin the Installation StatSim Pro 5 0 InstallShield Wizard Ready to Install the Program The wizard is ready to begin installation Click Install to begin the installatio
28. ss Millennium Development Goals Then select the levels to process and click OK StatSim Select levels to process e Lx J label element label element ee Cancel Region regn Purok purok Province prov Barangay brgy Municipality mun COE 4 Climate Change Related Indicators The updated CBMS questionnaire includes climate change related questions All these data can also be processed using StatSim Pro 5 0 To process go to Data and click Process Update Select Process Climate Change Related Indicators Stats Indicatars aac Matching JIL Edit Thresholds W Process update Core Indicators Process Millennium Development Goals Ind Process Other Key Indicators Then select the levels to process and click OK StatSim Select levels to process Selection OK label element label element al Cancel Region regn Purok purok Province prov Barangay brgy Municipality mun oe OO D Displaying the CBMS Data 1 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 13 Home Data
29. ted CCR Indicators 03140900101000298 III CENTRAL LUZON BULACAN HAGONOY Abulalas o 298 00 i Q Barangay Profile Questionnaire BPQ Tables O a 03140900101000300 III CENTRAL LUZON BULACAN HAGONOY Abbulalas 300 001 Cl 03140900101000307 TII CENTRAL LUZON BULACAN HAGONOY Abulalas 307 001 21 fom f Select levels to process r 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 a 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 14 a mica E z StatSimPro BULACAN_HAGONOY 5X gt Home Data Stats Indicators Style g CBMS Core Indicators om t ie J CBMS Core Indicators Region Health d Nutriti Province BULACAN IlI CENTRAL LUZON A ais i i ea an utrition E d CBMS Core Indicato Province l City Municipality HAGONOY E H d CBMS Core Indicators Municipality sg CBMS Core Indicators Barangay Prevalence of Malnutrition Purok Barangay Abulalas m a CBMS Core Indicators Purok i d CBMS Core Indicators Household Demography Table 1 malnourished children by sex by purok 4 Health and Nutrition Pa malnourished children Pe d Prevalence of Malnutrition Region malnourished children 0 5 years old if number of children 0
Download Pdf Manuals
Related Search