Manual for Manual for CBMS Statistics Simulator (StatSimSGE
Contents
1. Cancel li To edit the details of a category select the specific category Click the green arrow and select Edit Change the details that needed to be changed iii To delete a category select the category to be deleted Click the green arrow and select delete 14 b Sectors The procedure for adding Sectors is the same as adding Categories Below is an example i Adding sectors 1 Open Wizard Select the Category Click the green arrow beside the pulldown list for Sector Click Add Example Under the LGU specific indicators category user will add a sector xi Selection Category ILGU Specific Indicators V Sector VI Display S Indicator Edit FZ Delete Yv Customize gt Description Custom Indicators 2 Choose the category Indicate the Sector short name full name of the sector and description Example Under LGU Specific Indicators the sector short name is agri the name of the sector is Agriculture and description entered Agricultural data Click OK CBMS Indicator Simulator Edit Indicators Add sector Leu Specific Indicators Cancel Sector short name Sector Description Agricultural data 3 A window will pop up asking if the user really wants to add the sector Click Yes if sure StatSimSGE xi A Are you sure you want to add Agriculture 4 Another window will open indicating the sector had been added stetsimsce2. bray povp A r brgy progtype CBMS Statistics Simulator bray prov migr Average HH Income by Tenure Status bray regvote Average Household Income by Tenure Status bray roof brgy_sci tenure average hh bray sector broy_squat status income brgy subp 1 33511 043314 broy tenur 2 51069 600000 bray toil bray_totpop 4 36692 635135 bray_totwage 6 18093 750000 brgy unempl1 Sab broy_victer 24 CBMS 4 Using Interlinks There are times that you need to get information for your table from two or more tables This would need interlinking in order to integrate information from at least two tables When you select two or more sources in the table customizer the button Interlinks will be activated This would prompt the user to integrate the two tables through linking CBMS Indicator Simulator poverty For parent geolevel OK Household v Add Edit Remove Cancel Table Poverty and ownership of refrigerator Poverty and ownership of refrigerator v Short name pov ref Source s Selected Source s Simple Composit Ge hh i Household indic Simple Composit CBMS Core Indi Simple Composit Simple Compost lt For example if you would like to display household poverty status and ownership of a refrigerator The poverty status can be taken from the table hh Corelnd while the ownership of assets can be found from the
3. File View Data Stats Indicators Help CBMS Statistics Simulator Simple Composite Indicator StatSimSG E 4 0 The PEP CBMS Network Coordinating Team Developed under the PEP CBMS Project of the Angelo King Institute for Economic and Business Studies with the aid of a grant from the international Development Research Centre IDRO Ottawa Canada 1 Data Tab The Data tab in the left side of the StatSim contains all the data that the program had automatically computed The computed tables are named by each level and the data it contains Clicking a table shows the variable names and data StatSimSGE File View Data Stats Indicators Help M broy_hhwdeathpreg g 2 be bees Jihwlabfor CBMS Statistics Simulator ra CBMS Statistics Simulator brgp_hiwmaindS ARR brgyid region province municipality barangay brgy hhwmaln05 brgy hhwmem05 brgy hhwmaln0 prop Barangay 175908002 IVE SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 26 123 21 1382 Broy_HHwMainos Brgy_hhwMem05 Broy_HHwMaln05_Prop M bray hhwmemo1d M broy_hhwmemd5 MA bray hhwmemo d nA bores bkusineuni Dala For example the table brgy hhmaln05 shows the brgyid region province municipality barangay number of households with children 0 5 years old who are malnourished brgy hhmaln05 number of households with children 0 5 years old brgy hhwmem05 and proportion of households with children 0 5 years old who are malnourishe
4. table hh ind In order to come up with a table containing these indicators user must interlink the two tables To make the tables relate to each other do the following 1 Click Interlinks The following dialog box will appear CBMS StatSim Linker poverty Link tables Lx 1 hh ind with HH_Corelnd Link columns Eli peni prem Remove Close 2 Do the following a Inthe Left pulldown list select hh ind and hh Corelnd in the Right b In the Left column select hen and also hen nrdb in the Right This would make the linker match household IDs in hh ind and in Ah Corelnd 3 Click Add 4 Add additional linkages depending on the unigueness For instance if your barangay utilizes ID s unigue within puroks you must add linking between purok codes purok You could see that in the variables expressions builder sources could be either hh ind or hh Corelnd Hence you could make the table harness information from the two tables and eventually display the household s poverty status and ownership of an asset 25 CBMS Sample output E StatSimSGE File View Data Stats Indicators Help eg Report 6 Map W T hh coreind hh coreind household nrdb CBMS Statistics Simulator hh ind Poverty and ownership of refrigerator RD hh sci Poverty and ownership of refrigerator hh totpop household nrdb nesi hh poverty ownership hp agrieguip
5. ROMBLOP MAGDIWE Tampayan Tabuk Tul 12 ROMBLONMMAGDIWA Dulangan Bantigue 13 ROMBLONMMAGDIWA Poblacion Baybay 14 ROMBLOP MAGDIWA Jao asan__llawod 15 ROMBLONMAGDIW Ambulong Pier Tabuk 16 ROMBLONMMAGDIWA Ipil Pisi 17 ROMBLOP MAGDIWZ Agsao Proper Ags 18 ROMBLOF MAGDIWE Silum Proper Silt 19 ROMBLOK MAGDIW Tampayan Tabuk Tul 10 ma le m mk eee eh eh b umi ond unb d mA OOOOOO o a s gt ia Yo ee be Las la bee A He ka bo laja la b omib M m o o o 22 AM umi mmih Under the last column with the following heading match will appear any of the following codes 1 1 or 0 1 denotes that the household ID is found in your encoded file but not in the digitized spot map 1 denotes that the household ID is found in the digitized spot map but not found in the encoded file 0 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 i In the example since you are only matching the text file of your barangay in this case Brgy Agutay with your mdb file you can disregard what the report is stating for the other barangays To do this follow the following steps 1 On your Excel file click Data 2 Click Filter 3 Select AutoFilter EJ Microsoft Excel hh Corelnd Household NRDB csv set File Edit View Insert Format Tools Data Window Help ia 24 dA ii iy ji i Arial 10 B Z U J40
6. click on hp mem b In Type use Value c In Alias type sex You can repeat this in the Label d Under Column select sex e Click Add To filter only children ages 0 5 a Under Source click on hpq_mem b In Type use lt Where gt c Under Column select age yr The operator will be activated Select lt In the last box type 5 so that the list will only contain children will age_yr lt 5 years old 20 all CBMS d Click Add CBMS StatSim Expression Builder malnourished children Build Source Type hpq_mem Where Alias AS Column Label an 9 To filter only children ages 0 5 who are malnourished a Under Source click on hpq_mem b In Type use lt Where gt c Under Column select mnutind The operator will be activated Select gt In the last box type 3 so that the list will only contain children whose nutritional status is 3 and 4 which means moderately and severely malnourished respectively d Click Add 10 You can replicate this if you would like other information about the household xi Click Close and OK in the next dialog xii You can now display the list of malnourished children To do this here are the steps 1 In the wizard select a Category CBMS core indicators b Sector Health and Nutrition c Indicator malnourished children 2 Click the green arrow and select Display 3 From the list select the newly created table
7. C Reset Alt R ti Di A CBM process and update Alt F8 A LGL A Sin pers Alt M 2 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 Open Look in lo CBMS NADB c EJ Name Size Type Date Mor B Magdiwang1 mdb 2 504KB Microsoft Office Acc 9 9 2007 My Recent Zla 5 332KB Microsoft Office Acc 8 15 200 Documents A E 21 Magdiwang orig mdb 2 504 KB Microsoft Office Acc 4 20 200 Desktop My Documents My Computer lt 2 File name Magdiwang mdb My Network Filesoftype CBMS NRDB MS Access Files mdb z Cancel Places Open as read only 26 A window will appear verifying that the user is matching data from the encoded and digitized CBMS StatSim Match data with Magdiwang Match data Master encoded An excel file as well as a report in the statsim will open The MS excel will be displayed similar to the one shown here tn le mi ajo TE mi mai rovince imunicipalit barangay puroknamehcn nrdb match 2 ROMBLOMMAGDIWZ Agutay Molobago 3 ROMBLOP MAGDIWZ Dulangan Bantigue ROMBLOP MAGDIVYZ Poblacion Baybay ROMBLOP MAGDIWA Jao asan Ilawod 6 ROMBLONMAGDIWZ Ambulong Pier Tabuk 7 ROMBLORMAGDIWA Ipil Pisi 8 ROMBLOMMAGDIWAAgsao Proper Ags _9 ROMBLOPMAGDIWZ Agutay Proper Agt 10 ROMBLOK MAGDIWA Silum Proper Silt 11
8. CBMS Core Indicators select Health and Nutrition and choose the indicator malnourished children Then left click on the green arrow button and click Customize and select Table 17 CEMS Indicator Simulator Wizard k x CEMS Core Indicators bd Sector Health and Nutrition Indicator malnourished children Display add Description Edit Delete A dialog box similar to the one displayed below will be shown CBMS Indicator Simulator HHs without access to safe water For table parent geolevel OK K ll Table Short name Under For table parent geolevel select Member Note that you do this because the indicator is at the member level iv Click on the Add button A dialog box similar to the one displayed below will appear vi I List of malnourished children ages 0 5 ye Cancel Parent table GeoLevel Member Short name maln05 Description List of malnourished children ages 0 5 years ola On the dialog box do the following 1 Under Table type List of malnourished children ages 0 5 years old 2 Under Short Name type maln05 3 Under Description type List of malnourished children ages 0 5 years old Note that some of the information is arbitrary Click on OK A dialog box will appear asking you if you want to add the definition of List of malnourished children ages 0 5 years old Click Y
9. List of malnourished children StatSim malnourished children Prevalence of Malnutrition Region Prevalence of Malnutrition Municipality Prevalence of Malnutrition Barangay Cancel Prevalence of Malnutrition Purok List of malnourished children 4 Here is the output fie Yew Date Maubos Heb Oe 62 P Cons Coe iioii S ir le CBMS Statistics Simulator a A Sr Compu rekon Livi of malnourished childern List gf maleouriihad chil r m heurehobl A u logy purek UNRATE firriname age sex EEREREEREEES g wmz 01 Lira x O O U O Q 17 101 vith u Ol Os mu U NE 12 1l idi 21 b Aggregates Aside from generating lists you can also use the CBMS StatSim to display aggregates For example you may follow the following step by step process in generating an output that can display the Average Household Income by Type of Tenure Status Add an indicator with the ff specifications 1 On Category click on the pull down list and click on CBMS Core Indicators 2 On Sector click on the pull down list and click on Water and Sanitation 3 On the box adjacent to Indicator Short Name type AvgHHincTenure Again note that the short name should be one word only 4 On the box under Description type Average Household Income by Tenure Status CBMS Indicator Simulator Edit Indicators Edit indicator Category CBMS Core Indicators v Sector Indicator
10. P d etnies of ref hpa aguarescatch hp aguarestend 01 0001 Poor 0 E hpa aguarestenddist 01 0002 Poor 0 hpa asset o 01 0003 Por 0 ED hpa business 01 0004 Poor 0 hpa couple no Megi 01 0005 Por 0 hpa crop 01 0006 Non poor 0 hp cropdist sk o hpa death 01 0007 Poor 0 A hpa expmem 01 0008 Poor 0 hpa handicap L tea hh 01 0009 Por 0 pa landparcel 01 0010 Poor 0 hp Istock hp mem 01 0012 Non poor 0 hpa ofw 01 0013 Poor 0 hpa prog jih Saky 01 0014 Poor 0 hpq_unipar 01 0015 Poor 0 4 hpa wage z g listsenior 01 0016 Poor 0 manos 01 0017 Poor 0 mem di To 01 001 Poor 0 mun 01 0019 Non poor 0 mun_hhwdeathos k mun hhwdeathpreg 01 0020 Poor 0 D mun hhwlabfor 01 0021 Poor 0 k mun_hhwmmainos mun hhwmemotd 01 0022 Poor 0 o mun hhwmem0 01 0023 Poor 0 mun hhwmemo d mun hhwmem10ab 01 0024 Non poor 0 0 A mun hhwmem1316 01 0025 Poor A mun_hhwmem 12 V 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 Click on Data select Matching shortcut Alt M StatSimSGE File View SEE Stats Indicators Help DB Clear Households Alt
11. 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 8 AL CBMS Each questionnaire is differentiated by the HPQ version number For example the latest version of the HPQ and BPQ are 10200704 and 5200703 respectively Check both labels and Click OK StatSim Select definitions mo lU 14 Household Profile Questionnaire 1020070400 14 Barangay Profile Questionnaire 520070301 d Configuring the database means specifying the level to be municipal provincial or regional database For this example create a municipal database StatSim Configure the Database Vil CENTRAL VISAYAS 07000000 A a JE VI EASTERN VISAYAS 0800000C U CAGATAN V V UEONANNNNI A B CONTIGAL LU OM lt eadaadood IX ZAMBOANGA PENINSULA 0300 MA SOUTHERN TAGALOG CALAE X NORTHERN MINDANAO 100000 VE COL rea Sees XI DAVAO REGION 110000000 Vi CENTRAL VISAVAS 01000000 XII SOCCSKSARGEN 1 20000000 YE EASTERN VGAVAS 000000 NCR NATIONAL CAPITAL REGION np ete rat CAR CORDILLERA ADMINISTRATIVI s DAV REDI 440000008 ARMM AUTONOMUS REGION IN MU sil S00 CSR ARGEM 1 30000000 XIII CARAGA 160000000 MGR NAMOMAL CAPITAL REM VB SOUTHERN TAGALOG MIMAR AR CCRHTA FRA ADRES TRATI AFi ALJTOHOMLIE REGION IH MU MARINDUQUE 174000000 x CARAGA 1a O
12. on the box next to it c Under Column select totin Total Income d Under Alias and label type Average HH income e Click on Add The variable on Total Income is now added as a variable 23 CBMS CBMS StatSim Expression Builder Average HH Income by Toil Build Source Type hpa hh Expression ave Alias AS Column average HH income htn sd Label Average HH income Advanced Advanced edit Add Remove Update Close Variables expressions 12 To group the averages a Go back to Source and click on hpq_hh b Under Type select Group By c Under Column select tenure d Click on Add 13 Click Close 14 Click OK on the CBMS Indicator Simulator 15 You can now display the Average income by tenure status To do this here are the steps a Inthe wizard select I Category CBMS core indicators li Sector Housing iii Indicator Average HH income by Tenure Status b Click the green arrow and select Display 16 From the list select the newly created table Average HH income by Tenure Status StatSim Average HH Income by Tenure Status Average HH Income by Tenure Status v Average HH Income by Tenure Status AvgHHincTenure Cancel Average Household Income by Tenure Status 17 Click on Ok The following output will now be displayed amp StatSimSGE File View Data Stats Indicators Help De BY Be Data dj Report Map
13. paths file by browsing the folders Remove Click Remove to remove an added text Click Clear to remove all added text files 2 After selecting the text file files from the auto selection of levels or through specifying the paths click OK to start and while fetching a window will appear indicating Statsim fetch Processing 3 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 StatSim A Do you want to import another set of Files 4 Another window will appear click Yes to start the processing StatSim A Do vou wank to start the processing 5 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 are both case and space sensitive Click Yes to edit the Purok names StatSim A Do you wank to edit the Puroks 79 6 Double click on the PurokName to change the names After editing all the names click OK Edit sub village Purok Region regniD ive SOUTHE 170000000 PurokName 17590800201 17590800202 17590800203 17590800204
14. short name AvgHHincTenure Indicator Average HH Income by Tenure Status Description Average Household Income by Tenure Status Click on OK A dialog box will appear asking if you want to add Average HH Income by Tenure Status Click on Yes A dialog box will again appear confirming that Average HH Income by Tenure Status has been added On the Indicator Simulator Wizard you will notice that Average HH Income by Tenure Status is now part of the Indicator pull down list as shown below po nom CBMS Indicator Simulator Wizard Selection Category CBMS Core Indicators 2 Sector Housing v 2 Indicator Average HH Income by Tenure Status Construction materials of wall Construction materials of roof Average HH Income by Tenure Status li Now you could link to and customize for the newly defined indicator To do this do the following Click on Average HH Income by Tenure Status and click the arrow adjacent to it Select Customize and then click on Table Under for table parent geolevel select Household Click on the Add button A dialog box similar to the one displayed below will appear oS 22 CBMS Indicator Simulator Edit table Table Parent table GeoLevell Household v Short name c Description 5 Do the following in the dialog a Under Table type Average HH Income by Tenure Status b Under Short Name type AvgHHincTenure c Unde
15. the statsim For the example list of malnourished children do the following 1 To display barangay name a Under Source click on hpg mem b In Type use Value c In Alias type brgy You can repeat this in the Label d Under Column select brgy which contains information on the barangay name To display purok name Under Source click on hpq_mem In Type use Value In Alias type Purok You can repeat this in the Label Under Co umn select purok which contains information on the purok name Click Add DSO Do To display household ID a Under Source click on hp mem b In Type use Value c In Alias type household id You can repeat this in the Label d Under Column select hen which contains information on the household ID e Click Add To display surname of child a Under Source click on hpq_mem b In Type use Value c In Alias type surname You can repeat this in the Label d Under Column select msname e Click Add To display first name of child a Under Source click on hpq_mem b In Type use Value c In Alias type firstname You can repeat this in the Label d Under Column select mfname e Click Add To display age of child a Under Source click on hpq_mem b In Type use Value c In Alias type age You can repeat this in the Label d Under Column select age_yr e Click Add To display sex of child a Under Source
16. v fe 4 Select the name of the barangay that you are processing o The last column labeled match shows 0 values indicating that your encoded data matches your digitized spotmap 6 In this example we have a mismatch HH 1 was encoded in purok Molobago but was digitized to parent purok Proper Agutay 2 EJ Microsoft Excel hh Corelnd Household NRDB ee pa pr mie me i oB LU EEE Al fe province ET ii NE MK NE MM IM ME KU Fee n oadd en edema 2 ROMBLOMMAGDIWAAgutay Molobago 9 ROMBLOMMAGDIWAAgutay Proper Agt 2265 ROMBLOMMAGDIWZA Agutay Molobago 2266 ROMBLONM MAGDIWA Agutay Molobago 2267 ROMBLON MAGDIWF Agutay Molobago 2268 ROMBLONMAGDIWZ Agutay Molobago 2269 ROMBLOP MAGDIWZ Agutay Molobago 2270 ROMBLOM MAGDIWAAgutay Molobago 2271 ROMBLON MAGDIWZ Agutay Molobago 2272 ROMBLONMAGDIWA Agutay Molobago 2273 ROMBLONMAGDIWZ Agutay Molobago 2274 ROMBLOM MAGDIWZ Agutay Molobago 2275 ROMBLONMAGDIWZ Agutay Molobago 2276 ROMBLOM MAGDIWAAgutay Molobago 2277 ROMBLONMAGDIWZ Agutay Molobago 2278 ROMBLON MAGDIWA Agutay Molobago 2279 ROMBLOM MAGDIWZ Agutay Molobago 2280 ROMBLOM MAGDIWZ Agutay Molobago 2281 ROMBLON MAGDIWA Agutay Molobago 2282 ROMBLONM MAGDIWA Agutay Molobago 2283 ROMBLON MAGDIWZ Agutay Molobago 2284 ROMBLONMAGDIWZ Agutay Molobago 2285 ROMBLOM MAGDIW Agutay Molobago 2286 ROMBLONMAGDIWZ Agutay Molobago 2287 ROMBLONMAGDIWZ Agutay Molobago 2288 ROMBLONMAGDIWA Agutay Molobago 2289 ROMBLONMAGDI
17. 7 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 StatSim Select levels to process Click OK to start processing data 3 purok V Household hh prov Z Municipality mun 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 3rd 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 StatSim A Do vou want to process the 13 1 indicators While StatSim is processing you will see the status of the processing activity at the bottom of the page Please note that the length of time reguired 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 se AL CBMS D Displaying the CBMS Core Indicators To view the data the StatSim contains the tree view of the data and report tables Data and Report Tabs in the left side of the interface S StatSimSGE a BX
18. 8002010013 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 13 013 6 175908002010014 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay S 14 014 7 tay 175908002010015 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agu 15 015 4 175908002010016 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay UO 16 016 3 175908002010017 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 17 017 2 175908002010018 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 18 018 5 175908002010019 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 19 019 3 175908002010020 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 20 020 2 x 11 Qa RI CBMS Users can also choose to display one indicator at a time only by clicking on the specific sector and indicator then chose the level of data to view For this example the user opted to see prevalence of malnutrition at the purok level The output view shows data for 4 puroks of Brgy Agutay amp StatSimSGE File View Data Stats Indicators Help D a bel 282332 s CBMS Core Indicators 4 CBMS Core Indicators Region 4 CBMS Core Indicators Province 4 CBMS Core Indicators Municipality 4 CBMS Core Indicators Barangay 4 CBMS Core Indicators Purok 4 CBMS Core Indicators Household Demography s Health and Nutrition s MA malnourished children 4 Prevalence of Malnutrition Region d Prevalenc
19. ATA s ma ane hhid region province municipality barangay purokname hhhead hen hen nrdb hh totmem 4 CBMS Core Indicators Household r 4 8 Demography 175908002010001 IVE SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 1 001 2 B se and Nutrition 175908002010002 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 2 002 7 ousing Water and Sanitation 175908002010003 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 3 003 10 i education and literacy 175908002010004 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 4 004 9 income ga Employment 175908002010005 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 5 005 2 Peace and Order 175908002010006 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay S 6 006 1 Partial crosstabulation of households pO Partial prosstebulatiom ur membara 175908002010007 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay S 7 007 2 pects 2 u f f om I Income distribution against core indicators 175908002010008 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 8 008 5 M LGU Specific Indicators S ih Simple Composite indicator 175908002010009 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay a 9 003 8 175908002010010 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay a 10 010 8 ta 175908002010012 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay O 12 012 1 17590
20. CBMS Encoding System ream 2007 m WinZip 1 Uninstall CBMS Database Encoding System 3 0 MySQL Query Brows FA Yahoo Messenger User s Manual for Computerized Data Encoding fm CBMS Database User s Manual for Digitizing Maps ArcYiew GIS 3 2 a Apple Software Update Internet Explorer w MSN A Outlook Express DE Microsoft office Exce Microsoft Office Wor p Remote Assistance 7 x 6 CSPro 3 3 Windows Media Player X windows Messenger U ETUE windows Movie Maker Log Off 0 Turn OFF Computer 2 le English U S X J start gt Ig wind Oil User 8 inbox J NSCB CSPr H CBMS icon in the Start Menu 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 romblon_magdiwang Click the button OK H CBMS StatSim 4 0 WE The CBMS Statsim localhost Log information 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 StatSim the database is already in the pulldown list StatsimSGE c The Statsim 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
21. CCIDENTAL MINDORO 175100 OMB SOUTHERN avec a ORIENTAL MINDORO 175200001 PALAWAN 175300000 PIROMBLON 175300000 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 Magdiwang in Romblon will be created StatSim Configure the Database MAGDIVANG 175908000 1759020 1759030 1759040 1759050 1759060 1758070 1759090 1759100 4759110 1759120 1759130 1758140 175015 gt OE HE EO EH ee RK The StatSim interface will now open StatSimSGE nj Data Report p A CBMS Core indicators LGU Specific indicators CBMS Statistics Simulator StatSimSGE 4 0 Smole Composte indicator The PEP CBMS Network Coordinating Team Developed by the PEP CBMS Network Coordinating Team of the Angelo King 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 Note When you are opening a configured database you will not need to do the procedure discussed in b to e B Importing CBMS Data This section will guide you through the process of importing your encoded data file into the StatSim In the importing process the StatSim transforms the encoded data into a database ready for further processing and tabulati
22. IS JOEL E BANCOLITA JUAN PAULO M FAJARDO MARSMATH A BARIS JR ALELLIE B SOBREVINAS JEREMY L DE JESUS ERICA PAULA S SIOSON NOVEE LOR C LEYSO Research Staff Inquiries regarding this CBMS work may be sent to CBMS Network Coordinating Team Angelo King Institute for Economic and Business Studies 10th Floor Angelo King International Center Estrada Corner Arellano Avenue Malate Manila Philippines 1004 Tel No 632 5262067 632 524 8888 loc 274 Fax No 632 5262067 E mail coms dls csb edu ph cbms net gmail com Website www pep net org 4
23. Indicators x imi Add Sector ven CS Delete Customize gt Indicator Description The 13 1 Comnunity Based Monitoring System Core Indicators 13 municipality barangay purok or household StatSim CBMS Core Indicators eame Core Indicators Region OK CBME Core Indicators Province CBMS Core Indicators Municipality CBMS Core Indicators Barangay CAMS Core Indicators Purok Cancel QM PRI CBMS The user will be prompted to choose at what level to display the CBMS Core Indicators region province Results are the same as in Section D 2 Automatically generated indicator tables also follow the same procedure 2 Categories Sectors and Indicators a Categories There are 3 default categories in the StatSim These are CBMS Core Indicators LGU Specific Indicators and Simple Composite Index I If the user wants to add another category here are the steps 1 Open Wizard Click the green arrow beside the pulldown list for Category Click Add 2 Indicate the Category short name full name of the category and description Click OK when done CBMS Indicator Simulator Wizard x Selection Category Sector Indicator Description Delete Customize 1 VI m Display Q Edit CBMS Indicator Simulator Edit Indicators Add category Category short name Category UN Description
24. JA 2 Ba in Kla Mis a CRDI JE IDRC AKI Manual for Manual for CBMS Statistics Simulator StatSimSGE version 4 0 Prepared by the CBMS Network Coordinating Team of the Angelo King Institute for Economic and Business Studies This work was carried out by the PEP CBMS 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 User s Manual for CBMS Statistics Simulator StatSimSGE version 4 0 I Introduction This manual contains guidelines and instructions on the use of the CBMS Statistics Simulator StatSimSGE version 4 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 VVVVVVV Pentium IV processor or equivalent 256MB of RAM SVGA monitor Mouse 80MB of free hard drive space Microsoft Windows 98 Me NT 4 0 2000 XP or 32 bi
25. NG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG barangay purokname gutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Agutay Molobago Molobago Molobago Molobago Molobago Molobago Proper Agutay Proper Agutay Proper Agutay Proper Agutay Proper Agutay Proper Agutay Proper Agutay Proper Agutay Proper Agutay z O am S O o Proper Agutay Proper Agutay Proper Agutay Proper Agutay Proper Agutay Proper Agutay SF o SN o S O fea SO O SO O SO O SG O 5a CO fall AG E a a pe At the purok and higher geopolitical levels the SCI is the average household scores at that level In the example below the average unmet needs of the households in Brgy Agutay is 3 This number is useful in targeting barangays with the highest average unmet needs 12 gt StatSimSGE File View Data Stats Indicators Help Dek 30 3 A Map s A CBMS Core Indicators gt d CEMS Core Indicators Region G BMS Statistics Simulator 4 CBMS Core Indicators Province Simple Composite Indicator Barangay 4 CBMS Core Indicators Municipality Integration of the 13 1 indicators fo idenfifp the poor 4 CBMS Core Indicators Barangay 4 CBMS Core Indicators Purok brgyid ray mw municipali
26. WZ Agutay Molobago x CO 4 GI 0 BU ND ah A ad gt U MN OD FLN O 0 Ma font i i 0000000000000 N I 7 Tocorrect this we need to find if the error is in the encoding or in the digitizing 8 In this example the user were able to identify the mistake was in the digitized file The error committed was in parenting the digitized household id in a different parent purokname To resolve cases such as this go to the nrdb file and correct the parenting by changing the purok as parent feature of that household If however the mistake was in parenting in the encoding file it can be resolved by going to the concerned household record s persistent items section in the encoding system and correct the parenting by changing the purok in the persistent items to the appropriate purok 9 Once this is done you can repeat the steps above and the matching report should now indicate that the household IDs in both the encoded file and the digitized spot map match VI Instructions on Exporting Processed CBMS Core Dataset from CBMS StatSim 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 From the File menu select EXPORT 2 Select Core In
27. as egal CBMS Core Indicators Barangay City Municipality MAGDIWANG A CBMS Core Indicators Municipality The 13 1 dimensions of poverty Barangay Agutay CBMS Core Indicators Barangay 4 CBMS Core Indicators Purok A CBMS Core Indicators Household Households Population Income distribution against core indicators MD LGU Specific Indicators Simple Composite Indicator A Demography k Health and Nutrition Indicator ma PRAP Proportion Housing 5 9 Water and Sanitation Total Male Female Total Male Female Basic education and literacy i Income DEMOGRAPHY Employment gv Am E 1 E o Partial crosstabulation of households 71 en yeas r ne a a Tas es naj CENE A NE KT NIKI MEJNIKI METI mc cti 11 CO U w el to O w HEALTH AND NUTRITION O dt I 1 6 2 1 1 0 9 1 0 0 8 children 0 5 year old who died 2 If you choose to display the CBMS Core Indicators at the household level below is the sample output gt StatSimSGE File View Data Stats Indicators Help Ceo eels CBMS Core Indicators 4 CBMS Core Indicators Region d CBMS Core Indicators Province d CBMS Core Indicators Municipality 4 CBMS Core Indicators Barangay CBMS Statistics Simulator CBMS Core Indicators Household The 13 dimensions of poverty 4 CBMS Core Indicators Purok 1 EFAAAAAAAITAAAI TTTTA GATTI MNA A TON CR TR AA MAR nr mar DELMATA
28. barangay brgy sci 4 CBMS Core Indicators Household i 4 me Milna aE Demography 175908002 IVE SOUTHERN TAGALOG MIMAROPA ROMBLON MAGDIWANG Agutay 2 7273 s Health and Nutrition s M malnourished children 4 Prevalence of Malnutrition Region 4 Prevalence of Malnutrition Province E Customizing Indicator Tables Aside from the automatically generated data users can also create their own tables using all variables found the HPQ Customization involves familiarization of the data dictionary and variable names Annex A of this manual 1 The CBMS Indicator Simulator Wizard Open the Indicator Simulator Wizard by clicking the Stats Indicators in the main menu and select Wizard shortcut Ctrl W The following dialog box will be displayed CBMS Indicator Simulator Wizard Selection Category Sector i 2 Indicator i 2 Description met The data automatically generated users access through the report tab can also be displayed the wizard The first pulldown list shows the categories by default it shows 3 categories Selection Category v LGU Specific Indicators Simple Composite Indicator 2 To display the CBMS Core Indicators for a chosen level click on the pull down list and select CBMS Core Indicators Afterwards click on the green arrow adjacent to the pull down list and click Display CBMS Indicator Simulator Wizard Selection Category CBMS Core
29. d brgy hhmaln05 Please refer to the Annex 1 for the data dictionary and list of variable names The table can be copied to other software such as excel or word etc To do this click Ctrl A select all then right click and click copy then paste to the desired program Another option is to right click in the output view and select the option Export to Microsoft Excel CBMS Statistics Simulator CBMS Statistics Simulator brey hhumalnos Select All brevid region Create Shortcut Add to Favorites View Source Encoding Print Refresh Select All Print Export to Microsoft Excel Properties or 10 QM CBMS 2 Reports Tab The Report tab shows ready made tables that can be printed right away or attached to documents As compared to the Data tab the reports generated here does not contain variable names as column headings but are properly titled so that it can be easily understood 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 f StatSimSGE File view Data Stats Indicators Help 1717 mel 2 ROMBLON IVB SOUTHERN s CBMS Core Indicators CBMS Statistics Simulator Province TAGALOG MIMAROPA CBMS Core Indicators Regi ET CEMS Sealy De
30. dicators for CBMS NRDB A StatSimSGE Aa View Data Stats Indicators Help New Ctrl N amp Open Ctrl 0 Ime 1 Import Ctrl I Map Core Indicators for CBMS NRDB z Select data Print Setup H Checkin Exit mau 59 JC 3 Select the following levels to process whichever is applicable Municipality Barangay Purok and Household 28 4 StatSim Select levels to process Selection Click OK The following message box will appear StatSimSGE A Exported data contained in C CBMSDatabase System Output Ind_NRDB mdb You are now ready to map CBMS Core Indicators using the CBMS NRDB Notes 1 3 Every table need not to have its own exclusive indicator For instance proportion of households without access to safe water is distributed to several indicator tables household purok barangay municipality province and region Hence you do not need to add an indicator whenever a new table must be made You must link this table to the related indicator The above examples only exhibit the whole process Short names are important because the system uses this to make tables Although it is arbitrarily set by users this must be set such that it could tell what it contains You can tabulate alphanumeric columns This means you could tabulate texts such as occupation programs perception etc Some commonly used abbreviations acronyms please see Annex 1 to view data dicti
31. e of Malnutrition Province 4 Prevalence of Malnutrition Municipality 4 Prevalence of Malnutrition Barangay PB Prevalence of Malnutrition Purok RD child deaths women who died due to pregnancy related ce nutrition status M Cause of death Housing Water and Sanitation Basic education and literacy M Income Employment Health and Nutrition Prevalence of Malnutrition Purok number of children 0 5 years old Province City Municipality Barangay Malnourished children 0 5 years old or children who are moderately or severely underweight Number of malnourished children 0 5 years old over number of children 0 5 years old Source CAMS Survey ROMBLON IVB SOUTHERN TAGALOG MIMAROPA MAGDIWANG Agutay Table 1 malnourished children by sex by purok malnourished children 0 5 years old Agutay 24 w 120 a 5 19 16 1 14 42 15 83 a 5 EB ES SS A ES CE BE 55 ProperAgutay 90 saj j ejl 3af 5 se 6s2 1067 Caamag s 2 4 o o es oo 769 Tiailan GO 625 Users can also view Selected LGU indicators and the Simple Composite Index automatically computed by the StatSim There are 14 basic needs 14 CMS core indicators that each household should meet The Simple Composite Index SCI 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 malnour
32. es A dialog box will again appear confirming that it has been added You will then be directed to the Indicator Simulator for List of malnourished children ages 0 5 years old You will notice that under Table you can now select List of malnourished children ages 0 5 years old 18 vii Under Plausible Source s select hpg mem label Member Record and click on the arrow pointing to the box on the selected sources User will be asked if he she would want to add Member Record as plausible source of the table The plausible sources in the bottom left side of the window are tables which can be from raw data or from processed data Added tables such as the list that the user is about to add will eventually be a plausible source of data Note that in this stage you are selecting the sources where information about the indicator could be found User will be notified that the source was added CEMS Indicator Simulator malnourished children J xX For parentigeolevel Member r Add Edit Remove Cancel Table List of malnourished children ages 0 5 yea List of malnourished children ages 0 5 ye Short name maln Selected Sources Wages Record Member Record j J Household Reco ii Member Household Purok Raramniiau variables Expression Interlink viii To define contents of your table click on Variables Expressions ix A dialog box similar to the one dis
33. hort name is farming the name of the sector is Farming Activities and description Farming Activities Click OK 16 CBMS Indicator Simulator Edit Indicators Add indicator Category Leu Specific Indicators Cancel Sector Agricultu re Indicator short name Indicator Farming Activities Description Farming Activities of households 3 A window will pop up asking if the user really wants to add the indicator Click Yes if sure Oe 4 A dre you sure you want bo add Farmina Activities DB 4 Another window will open indicating the indicator had been added 8 5 Tocheck if the user had added the sector name choose the category and sector names Click the pulldown list beside indicators The latest added Indicator can be seen at the bottom of the list ii To edit the details of an indicator select the specific indicator Click the green arrow and select Edit Change the details that needed to be changed li To delete an indicator select the category and sector then select the indicator to be deleted Click the green arrow and select delete 3 Tables a Lists For targeting of beneficiaries it is important to list who should be beneficiaries of certain programs Example for a supplemental feeding program the list of malnourished children should be listed as primary beneficiaries of this program Here are the steps to produce this list I Under the category
34. i A Agriculture added 5 To check if the user had added the sector name choose the category name Click the pulldown list beside sectors The latest added Sector can be seen at the bottom of the list 15 V nd CBMS x Selection Category LGU Specific Indicators V Sector Household roles Migration Agriculture Description Custom Indicators To edit the details of a sector select the specific sector Click the green arrow and select Edit Change the details that needed to be changed To delete a sector select the category then select the sector to be deleted Click the green arrow and select delete dre you sure you want to delete Agriculture Deleting this will lead to deletion of its children contents 1 w Indicators Adding Indicators 1 Open Wizard Select the Category and Sector Click the green arrow beside the pulldown list for Indicator Click Add Example Under the LGU specific indicators category and Agriculture Sector user will add an indicator xi Selection Category LGU Specific Indicators V Sector Agriculture V Indicator KO Display Z Description Edit Agricultural data bagi Customize 2 Choose the category and sector Indicate the Indicator short name full name of the indicator and description Example Under LGU Specific Indicators select the sector Agriculture The indicator s
35. ished and 3 have children who are not attending elementary school Thus the SCI of HH 1 is 3 Below is a sample output Note that the list is sorted according to the lowest to the highest SCI amp StatSimSGE File View Data Stats Indicators Help a bi 4 RMS V s A CBMS Core Indicators 4 CBMS Core Indicators Region 4 CBMS Core Indicators Province d CBMS Core Indicators Municipality 4 CBMS Core Indicators Barangay 4 CBMS Core Indicators Purok d CBMS Core Indicators Household Demography s Health and Nutrition sA malnourished children 4 Prevalence of Malnutrition Region 4 Prevalence of Malnutrition Province 4 Prevalence of Malnutrition Municipality 4 Prevalence of Malnutrition Barangay Prevalence of Malnutrition Purok child deaths women who died due to pregnancy related ce nutrition status Cause of death Housing Water and Sanitation A Basic education and literacy Income Employment M Peace and Order Partial crosstabulation of households o Partial crosstabulation of members Income distribution against core indicators M LGU Specific Indicators B Simple Composite Indicator d Simple Composite Indicator Region d Simple Composite Indicator Province 4 Simple Composite Indicator Municipality 4 Simple Composite Indicator Barangay 4 Simple Composite Indicator Purok 4 Simple Composite Indicator Household CBMS Statistics Simu
36. lator Simple Composite Indicator Household Integration of the 13 indicators to identifp the poor hhid region province 175908002010006 IVE SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002010024 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002010030 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002010042 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002010045 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002010046 IVE SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020068 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020069 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020073 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020074 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020079 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020084 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020087 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020088 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020091 IVE SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020093 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020099 IVE SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020101 IVE SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020133 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020142 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON 175908002020143 IVB SOUTHERN TAGALOG MIMAROPA ROMBLON municipality MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWANG MAGDIWA
37. on 1 To import an encoded barangay data go to File in the main menu then select Import StatSimSGE a5 view Data Stats Indicat New Ctrl N Open Ctrl O Export s Print Setup tate Exit 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 select questionnaire Household Profile Questionnaire 6 Auto selection of levels S C Specify path Cancel a 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 Click OK to start importing Change selection Kk 3 of text file Selection Cancel brgylD 175908002 specify Click Cancel to OD Ambulong 175908003 path W Dulangan 175908004 O pil 175908005 Jao asan 175908006 Poblacion 175908007 Silum 175908008 174908003 st
38. onary and list of variable names regn Region code prov Province code mun Municipality code brgy Barangay code purok Purok code hcn household control number ID Prop proportion SWS Safe water supply STF Sanitary toilet facility Death05 Child death 0 5 DeathPreg Death due to pregnancy related causes Maln05 Malnutrition Sguat Sguatters MSH Makeshift housing Povp Poverty Subp Subsistent poverty Fshort Food shortage Unempl15ab Unemployment 15 years old and above Elem612 Elementary participation 6 12 HS1316 High school participation 13 16 Sch616 School participation 6 16 29 ANNEX 1 DATA DICTIONARY AND LIST OF VARIABLE NAMES mu gt 30 hpg hh radio Own Radio cassette ref car 31 hpg hh supfcsh Receipts from abroad cash 32 hp hh carpind Received CARP program 33 hpg hh nsch616 Number of mems 6 16 years old who are attending c BMS 34 hpg mem org name 1 Name of organization 1 C BMS 35 hp crime regn Region c BMS 36 hp ofw brgy Barangay c BMS 37 hpg handicap regn Region mu mu aS T KT 7 TNI gt gt 38 hp crop crop line Line number mun urb mu gt c BMS 39 hpg aguaeguip aguaeguiptype Eguipment c BMS 40 THE CBMS NETWORK COORDINATING TEAM DR CELIA M REYES CBMS Network Leader ANNE BERNADETTE E MANDAP JASMINDA A QUILIT
39. op Importina Option to specify the path to import the text file 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 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 Agutay Magdiwang Romblon select the text file 175908002 hpg from the folder C CBMSDatabase 1 7 59 08 002 Look In gt 002 r 4 My Recent Documents z Desktop aust L My Documents My R ecent Documents 4 My Computer cee CEMS C i 4 a CBMSDatabase zi O 17 Desktop 58 LZ 08 Le o E com las 1 1 StatSim Import Paths EJ Click OK to start importing of text file Files to import O Date Modified Click Cancel to stop sd CACEMSDatabaseki PASEVOENIO2M 75908002 txt 1759080024xt 17MB Sat Feb 16 Importing Auto selection i Option to Auto select the text file The user can add multiple text files by going to desired Click Add to add a text
40. played below will appear The type only determines what kind of component is needed 1 Expression mostly done to get Source Only the sources CBMS StatSim Expression Builder HHs without access to safe water EJ selected from the previous procedure are available are Build Saurce Type aggregates counts averages etc source for the table 2 Value used to display only the value Column Alias Names that will appear E in the table Variables can be aliases 3 Group by used to divide the observations into classes or groups This is always used whenever counts or and aggregates are used 4 Where used to filter the tabulation or listing Label This contains the meaning or description of the Advanced aliases variables used TTT Column Contains all the variables include in the selected source Advanced edit For mysal commands od Click Close when all desired variables ne 101 PEANG me were added to the list source type alias column and labels click Add to include in the list of variables in the table Remove Used when user wish to remove the added variable in the list Update Select a variable and modify specifications and updated to edit in the list 19 a ITY CBMS x In building the table the variables must be added one at a time Thus the user is advised to draft a dummy table first before actual building a table in
41. r Description type Average Household Income by Tenure Status 6 Click on Ok 7 A dialog box will appear asking you if you want to add the definition of Average HH Income by Tenure Status Click Yes A dialog box will again appear confirming that it has been added You will then be directed to the Indicator Simulator for Average HH Income by Tenure Status You will notice that under Table you can now select Average HH Income by Tenure Status 8 Under Plausible Source s select hpg hh label Household Record and click on the arrow pointing to the box on the selected sources CBMS Indicator Simulator Average HH Income by Tenure Status For parentigeolevel OK Household v Add Edit Remove Cancel Table Average Household Income by Tenure Sta Average HH Income by Tenure Status Short name AvgHHincTenure Source s Selected Source s Crime Record Household Reco Asset Record Wages Record Member Record Member Variables Expression 9 Click on Variables Expressions to select the components of the table 10 To display types of tenure stats Under Source click on hpq_hh Under Type select Value Under Column select tenure Under Alias and label type Tenure Status Click on Add The variable on Tenure Status is now added as a variable panow 11 To display average household income a Source click on hpq_hh b Under Type select Expression and click on AVG Average
42. rized Data Encoding System to merge encoded household data from same barangays This is crucial prior to the simulation process nado CBMS 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 lll 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 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 computer
43. s used for encoding IV Generating Indicators through the CBMS Statistics Simulator StatSim A Opening the StatSim 1 Starting the StatSim application a Click on the shortcut icon from the desktop CBMs Statistics Simulator b Click on the shortcut icon in the Start Menu NRDR Pra 3 My Music e Shortcut to PI My Computer LVIEWPRO FXE 4 My Network Places E CBMS Encoding System Control Panel je CBMS Statistics JJ Simulator 4 Set Program Access and Defauts Ed Intercocied State 9 3 zi Printers and Faxes Krosoft Office Access Help and Support Search 77 Run 38 U U a L L L c Click Start click on All Programs select CBMS Database and click on CBMS Statistics Simulator Lo Microsoft Office Out m iTunes E Crosstab a z gt S m j DE Pro Microsoft Office Uninstall StatSim 3 0 E Mozilla Firefox Uninstall CBMS Database 3 0 38 shortcut to f ildi i indi T MySQL U M for Building the CBMS NRDB and CBMS indicat ee a yso TE User s Manual for Building the and mapping indicators Natural Resources Database v User s Manual for Statistics Simulator E s Encoding Syf A Nero 8 CBMS Statistics Simulator CBMS Statistics a OuickTime g CSPro Crosstab for CBMS Simulator 4 Seagate Crystal Reports g BPQ Crosstab A Startup 3 CBMs Statistics Simulator 4 rien Stata 9 a Stata 9 HPO Crosstab V Microsoft Office Acce m WinRAR
44. t Vista 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 guick and simple Steps in installing the software 1 2 eS Insert the installation CD provided by the CBMS Team in the computers 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 A welcome screen will appear Click Next The setup will require the user to accept the agreement upon using the software After agreeing on the terms click Next 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 The user will be prompted to select a set up type Select Complete and Click Next Click Install to begin the Installation A pop up screen will appear informing that the InstallShield Wizard has successfully installed CBMS StatSimSGE 4 0 Click Finish II General instructions Set up and maintain a computer that will serve as your data repository This computer should store all encoded text files and NRDB files Before using the StatSim for processing and consolidating your data check first for the accuracy and consistency of your text files If needed perform concatenation procedure refer to Section III of the Users Manual for the Compute
Download Pdf Manuals
Related Search