{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Cover","Contents and Administration","Field Obs. Info.","Field Obs. Items","Debriefing Instructions","Debriefing Form - Enumerators","Debriefing Form - Supervisors","1. Sample","2. Human Resources","3. Outreach and Publicity","4. Logistics","5. IT Infrastructure","6. Tablet Preparation","7. Training","8. Maps","9. Enumeration","10. CAPI Application","Report on Issues","Data on Pilot"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,"The U.S. Census Bureau's"]
[null,null,null,null,null,null,"Tool for Assessing a"]
[null,null,null,null,null,null,"Pilot Electronic Census"]
[null,null,null,null,null,null,"(TAPEC) "]

{"sheet":"Contents and Administration","index":1,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[[42,0,42,12],[41,0,41,12],[31,0,31,12],[39,0,39,12],[40,0,40,12]]}
["Contents "]
[]
["Contents and Administration"]
[]
["Field Observation"]
["Observation Information"]
["Field Observation Items"]
[]
["Debriefing"]
["Debriefing Instructions"]
["Debriefing Form - Enumerators"]
["Debriefing Form - Supervisors"]
[]
["TAPEC Modules"]
["1. Sample"]
["2. Human Resources"]
["3. Outreach and Publicity"]
["4. Logistics"]
["5. IT Infrastructure"]
["6. Tablet Preparation"]
["7. Training"]
["8. Maps"]
["9. Enumeration"]
["10. CAPI Application"]
["Report on Issues "]
[]
["Data on Pilot"]
["Data on Pilot"]
[]
["The TAPEC Kit"]
[]
["The Tool for Assessing a Pilot Electronic Census (TAPEC) has 10 modules and 7 worksheets for an NSO to complete an assessment of a tablet-based pilot census of population and housing."]
["The TAPEC Field Observation Items worksheet draws from the 10 modules.  "]
["The TAPEC includes instructions for debriefing enumerators and supervisors and suggested questions."]
["The TAPEC can compile a Report on Issues once all modules are completed. "]
["The TAPEC includes a Data on Pilot worksheet for information about the overall pilot which records average interview time, refusal and response rates, coverage, etc.   "]
[]
["Administering the TAPEC"]
[]
["The first assessment activity should be field observation of the pilot. The field observer should complete the Field Observation Information and Field Olbservation Items worksheets during the pilot. Field observers should complete one Field Observation Items worksheet for each area observed. If recorded on paper, responses should be entered into the TAPEC after returning from the field. Note: All field observation items are highlighted in green in the modules to enable the observer to transfer the data from the field."]
["The second assessment activity is debriefing of enumerators and supervisors. After the pilot census enumeration is complete, supervisors should debrief with enumerators using the Debriefing Form - Enumerators. Regional managers can debrief with the supervisors using the Debriefing Form - Supervisors. "]
["The third assessment activity is completing the TAPEC modules to compile the Report on Issues. At the headquarters, the NSO should host a meeting of relevant mangers and senior staff to complete all 10 modules of the TAPEC, including input from HR, outreach and publicity, logistics, subject matter specialists, trainers, geographers, IT specialists and programmers, supervisors, and enumerators. Each module may need input from a group of experts. Once, all modules are completed, the Report on Issues can be generated by clicking on the \"Compile Report\" button. Managers should discuss strategies to address the issues flagged in a timely manner prior to the actual census. "]
["The fourth and final assessment activity is completing the Data on Pilot worksheet. This worksheet assists the NSO to complete the information on the details of the pilot operation. At this point the TAPEC should serve as documentation of the pilot census. "]
[]
["Glossary "]
[]
["EA","Enumeration area"]
["IT","Information Technology"]
["HR","Human Resources"]
["HQ","Headquarters"]
["NSO","National Statistics Office"]

{"sheet":"Field Obs. Info.","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
["Observation Information"]
["An observer may observe multiple enumeration areas. For each area observed, the observer should complete a new Field Observation Items worksheet."]
[]
["Name of the observer:"]
[]
[null,"Observation 1","Observation 2","Observation 3"]
["Date of observation:"]
["Province/region of observation:"]
["Village/township of observation:"]
["Enumeration area:"]

{"sheet":"Field Obs. Items","index":3,"n_rows":133,"n_cols":5,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
["Item","Field Observation Items","Y/N/NA/DK","Remarks/Reason why not","Problematic Questions-record number"]
[]
[null,"Human Resources - Payroll"]
[2.8,"Field personnel received their per diem in a timely manner"]
[2.9,"Field personnel received their pay in a timely manner"]
[]
[null,"Logistics - Transportation"]
["4.10","The vehicles are easily identified as part of the pilot census"]
[]
[null,"Logistics - Regional Offices"]
["4.11","Census regional offices were clean "]
["4.12","Census regional offices had reliable electricity/power generators "]
["4.13","Census regional offices were secure (e.g., guards, locked rooms and cabinets for IT equipment, etc.)"]
["4.14","Census materials were properly organized "]
["4.15","Census regional offices had extra materials/tablets (in case of theft or damage)"]
["4.16","Census regional offices had charging stations for tablets and chargers"]
["4.17","Census regional offices had reliable internet connectivity for uploads"]
["4.18","Census regional offices had reliable computers and servers"]
["4.19","Census regional offices had secure and dry storage spaces for census materials"]
[]
[null,"Logistics - Supervisor and Enumerator Kits"]
["4.20","Every supervisor and enumerator had uniform/apron/cap"]
["4.21","Every supervisor and enumerator had a census identification badge"]
["4.22","Every supervisor and enumerator had an official letter that authorizes them to collect data"]
["4.23","Every supervisor and enumerator had a printed manual, if not included in the tablet"]
["4.24","Every supervisor and enumerator had a waterproof bag to carry materials"]
["4.25","Every supervisor and enumerator had a tablet "]
["4.26","Every tablet was in a protective case"]
["4.27","Every supervisor and enumerator had a pencil and notepad"]
["4.28","Enumerators had SIM cards with adequate data plan for communication, if in accordance with NSO plans"]
["4.29","Supervisors had mobile phones to communicate "]
["4.30","Supervisors had SIM cards for tablets with adequate data plan, if in accordance with NSO plans"]
["4.31","Supervisors had supervisory paper and electronic maps"]
["4.32","Every supervisor and enumerator had masks, if the pilot was during COVID-19 "]
[]
[null,"Logistics - Solar Chargers/ Back up power banks"]
["4.33","Every supervisory team had adequate solar chargers/power banks"]
["4.34","Every supervisory team had appropriate power cords and adapters"]
[]
[null,"IT Infrastructure - NSO "]
[5.6,"There were sufficent arrangements to charge the tablets in the field "]
[5.7,"There were sufficent arrangements to charge power banks in the field"]
[]
[null,"IT Infrastructure - Telecom Infrastructure"]
["5.9","Data transmission through the network was problem free in all regions"]
[]
[null,"Tablet Preparation - Tablets"]
["6.5","Tablet synching using Bluetooth worked as designed "]
["6.6","Tablet synching using the internet worked as designed "]
[]
[null,"Maps - Quality"]
["8.1","The EA boundaries followed the physical features as expected"]
["8.3","The physical features were useful boundaries for recognizing demarcation between neighboring EA"]
["8.6","Landmarks were accurate with sufficient coverage to aid in navigation"]
[]
[null,"Enumeration - Preparation for Fieldwork"]
[9.1,"Supervisors and enumerators had tablets that were fully charged at the beginning of their workday"]
[9.1999999999999993,"Supervisors and enumerators kept their tablets safe and clean"]
[9.3000000000000007,"Supervisors and enumerators wore uniforms/apron/caps"]
[9.4,"Supervisors and enumerators wore identification badges"]
[9.5,"Supervisors and enumerators wore their masks during COVID"]
[9.6,"Supervisors and enumerators were assigned the correct EA on the tablet"]
[9.6999999999999993,"If paper maps were provided, GEOIDs were accurate and consistent between supervisor and enumerator maps within a supervisory packet"]
[]
[null,"Enumeration - Interviewing Skills"]
["9.8","Supervisors and enumerators introduced themselves using standard official script"]
[9.9,"Supervisors and enumerators highlighted that respondents data will be protected by legal privacy and confidenciality provisions "]
["9.10","Enumerators got consent from respondents to conduct interview"]
[9.11,"If required, enumerators referred to (pilot) census night"]
[9.1199999999999992,"Enumerator made sure to ask if there were other members in the household at the end of the roster"]
[9.1300000000000008,"Enumerators asked questions verbatim as in the census instrument"]
[9.14,"The respondents asked for clarification for select questions consistently"]
[9.15,"When required, enumerators reworded some questions but kept the same meaning"]
[9.16,"Supervisors and enumerators were well trained in the use of the tablets"]
[9.17,"Before leaving a household, enumerators made sure that they saved the interview"]
["9.18","If interview was only partially completed, enumerators made an appointment with respondents to return"]
[9.19,"If respondent was absent, enumerator followed NSO training guidelines"]
["9.20","Supervisors and enumerators were polite and assumed professional demeanor"]
[9.2100000000000009,"Supervisors and enumerators observed social/physical distancing during interviews during the COVID pandemic"]
[9.2200000000000006,"Supervisors and enumerators were using the official translation to ask the questions in the local language, where appropriate"]
[]
[null,"Enumeration - Team Work"]
[9.23,"Enumerators reported to their supervisor at least once a day"]
[9.24,"Enumerators transmitted their work to the supervisor or HQ as instructed"]
[9.25,"Supervisors walked the boundaries of work unit with their enumerators to ensure they understood their EA boundary, if required according to training protocols"]
[9.26,"Supervisors made sure that enumerators were dropped off at their assigned EA on the first day, if required according to training protocols"]
[9.27,"Supervisors and enumerators made sure that households were associated with the correct EA"]
["9.28","Supervisors spot-checked all team members interviews in the first day or two "]
[9.2899999999999991,"Supervisors were spot-checking their team members interviews as specified in the training protocols"]
["9.30","Supervisors communicate at least once a day with enumerators to address concerns and mentor them"]
[9.31,"Supervisors reported to HQs (or their supervisors) at least once a day"]
[9.32,"If the data collection software generated reports on completion/quality, then supervisors checked daily and acted based on the report"]
[9.33,"The supervisor to enumerator ratio was manageable"]
[9.34,"IT staff were available to troubleshoot issues in the field (e.g., battery life, data transmission, applications, hardware, etc.)   "]
[]
[null,"Enumeration - Effectiveness of Outreach"]
[9.35,"Publicity posters or banners were visible in the pilot census areas"]
[9.36,"Local leaders were aware that their area was part of the pilot census"]
[9.3699999999999992,"Respondents were aware that their area was part of the pilot census"]
[]
[null,"CAPI Application - General"]
[10.1,"Logging into the application was easy"]
[10.199999999999999,"Mapping application was available and loaded in less than a minute in all regions"]
[10.3,"Geocodes and other census level unique identifiers (e.g., individual, household, structure, compound) are linked, properly handled, and behave as expected within and between census appliciations  "]
[10.4,"CAPI-device map accuracy and zoom levels were sufficient and did not cause any difficulties"]
[10.5,"GPS points were captured consistently with guidelines laid out in manual(s)"]
[10.6,"If GPS point was to be captured, it was easy to access designated location in a timely fashion (e.g., entrance to dwelling, central courtyard, along right of way)"]
[10.7,"GPS accuracy was captured with required degree of precision as per manual(s)"]
[10.8,"There were issues with tablets where their batteries lost charge too soon (before manufacturer's specification)"]
["10.9","There were issues with tablets where their screens were freezing"]
["10.10","There were issues with tablets where the sunglare on their screens made it difficult to use"]
["10.11","There were issues with tablets where their touch-screens were not responsive "]
["10.12","There were other issues with tablets that made it difficult to use (specify in remarks)"]
[]
[null,"CAPI Application - Supervisor"]
[10.130000000000001,"The assignment of households through the menu worked as designed"]
[10.14,"If the supervisor application is linked to the map application using GEOIDs, it performed as designed"]
[10.15,"The review of interviews in the supervisory application worked as designed"]
[]
[null,"CAPI Application - Enumerator"]
[10.16,"The enumerator was able to see and work with the assigned EAs smoothly"]
[10.17,"The enumerator was able to see and work with the assigned households smoothly"]
[10.18,"The order of questions worked as designed. Skip patterns worked as expected"]
["10.19","For questions that ask for a number, the programmed range of numerical responses were adequate to record all responses. (Eg, age, number of hh members, number of children, number of mobile phones, etc.)"]
["10.20","The categorical answer options were sufficient to capture all responses"]
[10.210000000000001,"The categorical answer options covered all the major categories in the country (e.g., major religions, ethnicities, etc.)"]
[10.220000000000001,"Navigating to the next screen was smooth (for instance, answer option buttons were not too close to the next screen arrow)"]
[10.23,"Interrupted interview was easy to put on pause and resume at a later time"]
[10.24,"It was easy to add  household members in the houseold listing in the middle of the interview if a mistake had been made by the respondent or interviewer"]
[10.25,"It was easy to drop household members in the houseold listing in the middle of the interview if a mistake had been made by the respondent or interviewer"]
[10.26,"It was easy to navigate the app to go back and correct a response when new information conflicted with a previous response"]
[10.27,"When enumerator encountered a consistency check, the application prompted them to review/revise the response"]
[10.28,"When enumerator encountered a consistency check that needed revision, the application navigated them to correct the screen"]

{"sheet":"Debriefing Instructions","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Debriefing Instructions"]
[null,"Debriefing should ideally be conducted at each level. "]
[]
[null,"Enumerator Debriefing"]
[null,"Supervisors should debrief with enumerators on a daily basis on what worked well, what did not work well, and how it can be improved. In addition, at the end of the pilot, the supervisor should hold a debriefing meeting with all the enumerators on their team. Distribute the enumerator debriefing form ahead of time and have each enumerator fill it out. The responses from each enumerator should be submitted to the central office. "]
[null,"When conducting a debriefing, it is important to make sure everyone has a chance to speak."]
[null,"Ask the 11 questions that are listed in the order that you see. There are some suggested probes just in case some issues are not covered in the discussions."]
[]
[null,"Supervisor Debriefing"]
[null,"Regional supervisors should debrief with team supervisors on a regular basis on what worked well, what did not work well, and how it can be improved. In addition, at the end of the pilot, the regional supervisor should hold a debriefing meeting with all the supervisors in their area. The supervisors should be reporting on enumerator feedback and their own observations. Distribute the supervisor debriefing form ahead of time and have each supervisor fill it out. The responses from each supervisor should be submitted to the central office. "]
[null,"When conducting a debriefing, it is important to make sure everyone has a chance to speak."]
[null,"Ask the 11 questions that are listed in the order that you see. There are some suggested probes just in case some issues are not covered in the discussions."]

{"sheet":"Debriefing Form - Enumerators","index":5,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Debriefing Form (to be filled by enumerators)"]
[]
[]
["Item","Debriefing Questions","Answers"]
[]
[null,"General"]
[1,"What worked well? "]
[]
[2,"What can be improved and how can it be improved? "]
[]
[null,"Mapping and navigation"]
[3,"Were there any issues with mapping and navigation?                        "]
[]
[null,"Cooperation"]
[4,"Did you have any issues with cooperation in the census?"]
[null,"Were there issues with soliciting cooperation from the local leader? (including community leaders and local or military authority)Were there issues with soliciting cooperation with the respondents?"]
[]
[null,"Interviews"]
[5,"Were there any questions that were problematic?"]
[null,"What were some of the questions that respondents had problems answering? Which ones in particular? And in what way? Why? How difficult was it to gather information on age and date of birth? How did the enumerator estimate it when the respondent did not know their age?Which questions seemed burdensome to the respondents? When respondents were reluctant to answer questions, how did they persuade them? Were there any \"types\" of respondents who were not able to be persuaded? Was there any question that respondents were finding difficult to answer because it was missing a major response category?"]
[]
[null,"Security"]
[6,"Did you have any issues related to security?"]
[null,"Did they have any issues of security given they were carrying tablets?Did they have issues related to harrassment from people, dogs, etc? What were they?"]
[]
[null,"Health"]
[7,"Did you experience any health issues during the fieldwork? "]
[null,"Did enumerators fall ill/sick/dehydration while doing fieldwork? If so how did they get treated?If during COVID- did they wear masks and practice social distancing? What were the issues with this?"]
[]
[null,"Tablets and Chargers"]
[8,"Were there any issues with the tablets and chargers?"]
[null,"Were there issues with the tablets? What were the major issues?Were there issues with the tablets? What were the major issues?Were there issues with the chargers? What were the issues?"]
[]
[null,"Payroll"]
[9,"Were there any issues with pay and per diem on time?"]
[null,"Did you receive your non-DSA compensation/payment in a timely manner? If not, what were the problems?Did you receive your per diem/daily subsistence allowance (DSA) in a timely manner? If not, what were the problems?"]
[]
[null,"Supervision"]
[10,"How can the supervision be improved?"]
[]
[]
[null,"Suggestions"]
[11,"Do you have any suggestions that would improve the fieldwork?"]

{"sheet":"Debriefing Form - Supervisors","index":6,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Debriefing Form (to be filled by supervisors)"]
[]
[]
["Item","Debriefing Questions","Answers"]
[]
[null,"General"]
[1,"What worked well? "]
[]
[2,"What can be improved and how can it be improved? "]
[]
[null,"Mapping and navigation"]
[3,"Were there any issues with mapping and navigation?                        "]
[]
[null,"Cooperation"]
[4,"Did you have any issues with cooperation in the census?"]
[null,"Were there issues with soliciting cooperation from the local leader? (including community leaders and local or military authority)Were there issues with soliciting cooperation with the respondents?"]
[]
[null,"Interviews"]
[5,"Were there any questions that were problematic?"]
[null,"What were some of the questions that respondents had problems answering? Which ones in particular? And in what way? Why? How difficult was it to gather information on age and date of birth? How did the enumerator estimate it when the respondent did not know their age?Which questions seemed burdensome to the respondents? When respondents were reluctant to answer questions, how did they persuade them? Were there any \"types\" of respondents who were not able to be persuaded? Was there any question that respondents were finding difficult to answer because it was missing a major response category?"]
[]
[null,"Security"]
[6,"Did you have any issues related to security?"]
[null,"Did they have any issues of security given they were carrying tablets?Did they have issues related to harrassment from people, dogs, etc? What were they?"]
[]
[null,"Health"]
[7,"Did you experience any health issues during the fieldwork? "]
[null,"Did enumerators fall ill/sick/dehydration while doing fieldwork? If so how did they get treated?If during COVID- did they wear masks and practice social distancing? What were the issues with this?"]
[]
[null,"Tablets and Chargers"]
[8,"Were there any issues with the tablets and chargers?"]
[null,"Were there issues with the tablets? What were the major issues?Were there issues with the tablets? What were the major issues?Were there issues with the chargers? What were the issues?"]
[]
[null,"Payroll"]
[9,"Were there any issues with pay and per diem on time?"]
[null,"Did you receive your non-DSA compensation/payment in a timely manner? If not, what were the problems?Did you receive your per diem/daily subsistence allowance (DSA) in a timely manner? If not, what were the problems?"]
[]
[null,"Supervision"]
[10,"How can the supervision be improved?"]
[]
[]
[null,"Suggestions"]
[11,"Do you have any suggestions that would improve the fieldwork?"]

{"sheet":"1. Sample","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Item","Pilot Sample","Y/N/NA/DK","Remarks/Reason why not?"]
[]
[null,"Quality of Sample"]
[1.1000000000000001,"The pilot sample is drawn from the updated mapping/address canvassing exercise"]
[1.2,"The pilot includes a representative sample of regions/provinces"]
[1.3,"The pilot sample includes all variations of most relevant parameters (e.g., ethnicity, immigrant status, etc)"]
[1.4,"The pilot sample includes hard to count populations (e.g., hard to locate, hard to contact, hard to persuade, and hard to interview)"]
[1.5,"The pilot also includes a sample of group quarters/hotels, prisons, etc."]
[1.6,"The pilot sample includes structure identifiers (including street addresses), when available and required "]
[1.7,"Sampling frames and sample designs are reviewed by experts for coverage, efficiency, logistical feasibility, and to determine if the sample size is sufficient for each domain of analysis, including geospatial analysis "]
[1.8," Pilot sample was drawn in a timely manner (before recruitment and pilot training) "]

{"sheet":"2. Human Resources","index":8,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Item","Human Resources","Y/N/NA/DK","Remarks/Reason why not?"]
[]
[null,"Recruitment"]
[2.1,"Fieldwork positions were advertized for recruitment"]
["2.2","Criteria for hiring was objective, based on knowledge and skills"]
["2.3","Selections were based on publicly advertised hiring criteria"]
["2.4","The recruitment was done in a timely manner (before training)"]
["2.5","Sufficient field personnel were recruited to take attrition into consideration "]
["2.6","Field personnel recruited were diverse in terms of gender, ethnicity, region, etc."]
[]
[null,"Payroll"]
[2.7,"Field personnel were registered on the payroll in a timely manner"]
[2.8,"Field personnel received their per diem in a timely manner"]
[2.9,"Field personnel received their pay in a timely manner"]
["2.10","Payroll guidance was clear and implemented accordingly"]
["2.11","Compensation for fieldwork was adequate to retain staff (i.e., pay and per diem were not too low)"]

{"sheet":"3. Outreach and Publicity","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Item","Outreach and Publicity","Y/N/NA/DK","Remarks/Reason why not?"]
[]
[null,"Publicity Campaign"]
[3.1,"The NSO planned a multi-media publicity campaign for the pilot census (e.g., printed media, radio, TV, internet, etc.)"]
[3.2,"The NSO designed a census logo, slogan and/or jingle, and other branding and outreach materials for the pilot"]
[3.3,"The NSO implemented a publicity campaign in all pilot regions"]
[3.4,"The NSO implemented the publicity campaign as planned in all regions"]
[3.5,"The NSO contacted local leaders and high profile members of the community prior to the pilot census to help raise awareness (including hard-to-count populations)"]
[]
[null,"Production of outreach materials"]
[3.6,"All outreach materials were produced in an timely manner"]
[3.7,"All outreach materials were deployed and displayed in an timely manner "]

{"sheet":"4. Logistics","index":10,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Item","Logistics","Y/N/NA/DK","Remarks/Reason why not?"]
[]
[null,"Printing "]
[4.0999999999999996,"The NSO had adequate number of plotters, if printing in-house and paper maps were used"]
[4.2,"The NSO produced maps for supervisors and enumerators in a timely manner, if paper maps were used"]
[4.3,"The NSO distributed printed maps for supervisors and enumerators in a timely manner, if paper maps were used"]
[4.4000000000000004,"The NSO produced training manuals for supervisors and enumerators in a timely manner"]
[4.5,"The NSO distributed training manuals for supervisors and enumerators in a timely manner"]
[]
[null,"Transportation"]
[4.5999999999999996,"The NSO had adequate number and type of vehicles/cycles for supervisors and enumerators in all regions"]
[4.7,"The NSO had arranged for sufficient fuel for the vehicles"]
[4.8,"The NSO had drivers for all the vehicles"]
[4.9000000000000004,"The NSO had procedures for vehicle repair and breakdown"]
["4.10","The vehicles are easily identified as part of the pilot census"]
[]
[null,"Regional Offices"]
["4.11","Census regional offices were clean "]
["4.12","Census regional offices had reliable electricity/power generators "]
["4.13","Census regional offices were secure (e.g., guards, locked rooms and cabinets for IT equipment, etc.)"]
["4.14","Census materials were properly organized "]
["4.15","Census regional offices had extra materials/tablets (in case of theft or damage)"]
["4.16","Census regional offices had charging stations for tablets and chargers"]
["4.17","Census regional offices had reliable internet connectivity for uploads"]
["4.18","Census regional offices had reliable computers and servers"]
["4.19","Census regional offices had secure and dry storage spaces for census materials"]
[]
[null,"Supervisor and Enumerator Kits"]
["4.20","Every supervisor and enumerator had uniform/apron/cap"]
["4.21","Every supervisor and enumerator had a census identification badge"]
["4.22","Every supervisor and enumerator had an official letter that authorizes them to collect data"]
["4.23","Every supervisor and enumerator had a printed manual, if not included in the tablet"]
["4.24","Every supervisor and enumerator had a waterproof bag to carry materials"]
["4.25","Every supervisor and enumerator had a tablet "]
["4.26","Every tablet was in a protective case"]
["4.27","Every supervisor and enumerator had a pencil and notepad"]
["4.28","Enumerators had SIM cards with adequate data plan for communication, if in accordance with NSO plans"]
["4.29","Supervisors had mobile phones to communicate "]
["4.30","Supervisors had SIM cards for tablets with adequate data plan, if in accordance with NSO plans"]
["4.31","Supervisors had supervisory paper and electronic maps"]
["4.32","Every supervisor and enumerator had masks, if the pilot was during COVID-19 "]
[]
[null,"Solar Chargers/ Back up power banks"]
["4.33","Every supervisory team had adequate solar chargers/power banks"]
["4.34","Every supervisory team had appropriate power cords and adapters"]

{"sheet":"5. IT Infrastructure","index":11,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Item","IT Infrastructure","Y/N/NA/DK","Remarks/Reason why not?"]
[]
[null,"NSO "]
[5.0999999999999996,"There was a backup server for pilot census data"]
[5.2,"There was a working generator in the HQs for backup power with adequate fuel"]
[5.3,"The Local Area Network (LAN) at the NSO worked efficiently during the pilot "]
[5.4,"IT conducted a load test to simulate the volume of census data transmission "]
[5.5,"A mobile device management software was installed on the tablets to control application installation"]
[5.6,"There were sufficient arrangements to charge the tablets in the field "]
[5.7,"There were sufficent arrangements to charge power banks in the field"]
[]
[null,"Telecom Infrastructure"]
[5.8,"Contract with telecommunications company was well specified and implemented "]
["5.9","Data transmission through the network was problem free in all regions"]
[]
[null,"Security"]
["5.10","A qualified security consultant was hired to help"]
["5.11","The recommendation of the security consultant were implemented and worked well"]
["5.12","A secure socket layer (SSL) certificate was installed"]
["5.13","A virtual private network (VPN) was set up"]
["5.14","A virtual private network (VPN) was used and worked well"]
["5.15","A private access point name (APN) was set up"]
["5.16","A private access point name (APN) was used and worked well"]

{"sheet":"6. Tablet Preparation","index":12,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Item","Tablet Preparation","Y/N/NA/DK","Remarks/Reason why not?"]
[]
[null,"Tablets"]
["6.1","Auto-update of operating system and third party applications used for data collection was disabled (e.g., CSEntry auto-update was turned off)"]
["6.2","Unnecessary applications and entertainment websites were blocked "]
["6.3","Supervisors and enumerators were prevented from installing applications (had no administrator rights)"]
["6.4","NSO had administrator-level access which could bypass user-created PINs/passwords"]
["6.5","Tablet synching using Bluetooth worked as designed "]
["6.6","Tablet synching using the internet worked as designed "]
["6.7","The data entry application matched the agreed upon version for the pilot census (e.g., CSEntry)"]
["6.8","The web application application at HQ that allows secure transfer of questionnaire matched the agreed upon version for the pilot census (e.g., CSWeb)"]
["6.9","CAPI application was built with correct version of the application agreed for the pilot (e.g. CSPro 7.4.1)"]
["6.10","All tablets were fully charged before distributing for training purposes"]
[6.11,"If the tablets are not new, NSO made sure that batteries lasted for at least 4 hours "]
[6.12,"If the battery life on the tablet was less than 4 hours, NSO replaced battery or tablet or made provisions for frequent charging (e.g., battery pack)"]

{"sheet":"7. Training","index":13,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Item","Training","Y/N/NA/DK","Remarks/Reason why not?"]
[]
[null,"Training Venue and Transportation"]
["7.1","Training venues for pilot census were booked in a timely manner"]
[7.2,"Training rooms for pilot census were large enough to accommodate participants "]
[7.3,"Training venues for pilot census had working projectors/large display screen"]
["7.4","Training venues for pilot census had adequate sound amplification system"]
[7.5,"Training venues for pilot census had adequate number of microphones"]
[7.6,"Training venues for pilot census had audio and video technicians on site"]
["7.7","Training venues had flip charts and markers, chalkboards, etc."]
[7.8,"Training venues had reliable electricity/power generators"]
[7.9,"Training venues had adequate number of power outlets to charge tablets"]
["7.10","Training venues had good security provisions "]
["7.11","If transportation was required during training, adequate arrangements were made"]
["7.12","Adequate lodging and boarding arrangements were made for training participants, when required"]
[]
[null,"Trainers and Training Curriculum "]
["7.13","Training was conducted by NSO subject matter specialists, cartographers, IT specialists, and field managers"]
["7.14","The training curriculum accomodated different styles of learning-auditory, visual, kinesthetic (or hands-on approach) "]
["7.15","The training curriculum covered all the details of the census questionnaire"]
["7.16","The training curriculum covered mapping and navigation"]
["7.17","The training curriculum included instructions on the use of all aspects of the data entry application on the tablet (questionnaire, data synchronization, maps, reading GPS, etc.)"]
["7.18","The training curriculum included enumerator responsibilities with respect to collecting, reviewing, and transmitting data "]
["7.19","The training curriculum included supervisor responsibilities with respect to collecting, reviewing, and transmitting data and supervising enumerators"]
["7.20","The training curriculum included rules for enumerators on professional conduct and engagement with respondents and supervisors"]
["7.21","The training curriculum included rules for supervisors on professional conduct and engagement with enumators, community leaders, respondents and other staff"]
["7.22","The training curriculum included extra time/days for training only supervisors "]
["7.23","The training curriculum highlighted the importance of asking the questions verbatim"]
["7.24","The training curriculum covered estimation of age using various methods when respondents did not know their age (historic calendar, life events, etc.)"]
["7.25","The training curriculum highlighted the importance of asking whether the household had any other members that were not listed at the end of the roster (including checking on any children and infants missed)"]
["7.26","The training curriculum covered handling of tablet (care and basic functions)"]
["7.27","The training curriculum covered basic technical troubleshooting on tablets (try turning it off and on again), dealing with errors with network, collecting GPS, etc."]
["7.28","The training curriculum included exercises at the end of each learning module"]
["7.29","The training curriculum included hands-on practice for enumerators and supervisors, such that everyone has sufficient time to master aspects like interviewing, data synchronization, maps, reading GPS, etc. on the tablet"]
["7.30","The training curriculum included at least two days of mock interviews and field experience"]
["7.31","The training curriculum included opportunities for enumerators and supervisors to participate actively"]
["7.32","The training curriculum included recommendations for dealing with refusals"]
["7.33","The training curriculum included recommendations for dealing with hostile respondents and situations "]
["7.34","If there was a long delay between training and fieldwork for the pilot census, refresher training was provided"]
[]
[null,"Payroll"]
["7.35","Training participants had been registered by HR on the payroll"]
["7.36","Training participants received per diem in a timely manner"]
["7.37","Training participants received their pay in a timely manner"]
["7.38","Training payroll guidance was clear and implemented in accordance"]

{"sheet":"8. Maps","index":14,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Item","Maps","Y/N/NA/DK","Remarks/Reason why not"]
[]
[null,"Quality"]
["8.1","The EA boundaries followed the physical features as expected"]
["8.2","EAs were clearly symbolized and easy to distinguish from other lines on the map"]
["8.3","The physical features were useful boundaries for recognizing demarcation between neighboring EA"]
["8.4","The basemap imagery (if available) was recent enough to provide useful context for navigation and EA recognition"]
["8.5","The resolution/zoom levels provided was sufficient"]
["8.6","Landmarks were accurate with sufficient coverage to aid in navigation"]

{"sheet":"9. Enumeration","index":15,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Item","Enumeration","Y/N/NA/DK","Remarks/Reason why not"]
[]
[null,"Preparation for Fieldwork"]
[9.1,"Supervisors and enumerators had tablets that were fully charged at the beginning of their workday"]
[9.1999999999999993,"Supervisors and enumerators kept their tablets safe and clean"]
[9.3000000000000007,"Supervisors and enumerators wore uniforms/apron/caps"]
[9.4,"Supervisors and enumerators wore identification badges"]
[9.5,"Supervisors and enumerators wore their masks during COVID"]
[9.6,"Supervisors and enumerators were assigned the correct EA on the tablet"]
[9.6999999999999993,"If paper maps were provided, GEOIDs were accurate and consistent between supervisor and enumerator maps within a supervisory packet"]
[]
[null,"Interviewing Skills"]
["9.8","Supervisors and enumerators introduced themselves using standard official script"]
[9.9,"Supervisors and enumerators highlighted that respondents data will be protected by legal privacy and confidenciality provisions "]
["9.10","Enumerators got consent from respondents to conduct interview"]
[9.11,"If required, enumerators referred to (pilot) census night"]
[9.1199999999999992,"Enumerator made sure to ask if there were other members in the household at the end of the roster"]
[9.1300000000000008,"Enumerators asked questions verbatim as in the census instrument"]
[9.14,"The respondents asked for clarification for select questions consistently"]
[9.15,"When required, enumerators reworded some questions but kept the same meaning"]
[9.16,"Supervisors and enumerators were well trained in the use of the tablets"]
[9.17,"Before leaving a household, enumerators made sure that they saved the interview"]
["9.18","If interview was only partially completed, enumerators made an appointment with respondents to return"]
[9.19,"If respondent was absent, enumerator followed NSO training guidelines"]
["9.20","Supervisors and enumerators were polite and assumed professional demeanor"]
[9.2100000000000009,"Supervisors and enumerators observed social/physical distancing during interviews during the COVID pandemic"]
[9.2200000000000006,"Supervisors and enumerators were using the official translation to ask the questions in the local language, where appropriate"]
[]
[null,"Team Work"]
[9.23,"Enumerators reported to their supervisor at least once a day"]
[9.24,"Enumerators transmitted their work to the supervisor or HQ as instructed"]
[9.25,"Supervisors walked the boundaries of work unit with their enumerators to ensure they understood their EA boundary, if required according to training protocols"]
[9.26,"Supervisors made sure that enumerators were dropped off at their assigned EA on the first day, if required according to training protocols"]
[9.27,"Supervisors and enumerators made sure that households were associated with the correct EA"]
["9.28","Supervisors spot-checked all team members interviews in the first day or two "]
[9.2899999999999991,"Supervisors were spot-checking their team members interviews as specified in the training protocols"]
["9.30","Supervisors communicate at least once a day with enumerators to address concerns and mentor them"]
[9.31,"Supervisors reported to HQs (or their supervisors) at least once a day"]
[9.32,"If the data collection software generated reports on completion/quality, then supervisors checked daily and acted based on the report"]
[9.33,"The supervisor to enumerator ratio was manageable"]
[9.34,"IT staff were available to troubleshoot issues in the field (e.g., battery life, data transmission, applications, hardware, etc.)   "]
[]
[null,"Effectiveness of Outreach"]
[9.35,"Publicity posters or banners were visible in the pilot census areas"]
[9.36,"Local leaders were aware that their area was part of the pilot census"]
[9.3699999999999992,"Respondents were aware that their area was part of the pilot census"]

{"sheet":"10. CAPI Application","index":16,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Item","CAPI Application","Y/N/NA/DK","Remarks/Reason why not","Problem Question"]
[]
[null,"General"]
[10.1,"Logging into the application was easy"]
[10.199999999999999,"Mapping application was available and loaded in less than a minute in all regions"]
[10.3,"Geocodes and other census level unique identifiers (e.g., individual, household, structure, compound) are linked, properly handled, and behave as expected within and between census appliciations  "]
[10.4,"CAPI-device map accuracy and zoom levels were sufficient and did not cause any difficulties"]
[10.5,"GPS points were captured consistently with guidelines laid out in manual(s)"]
[10.6,"If GPS point was to be captured, it was easy to access designated location in a timely fashion (e.g., entrance to dwelling, central courtyard, along right of way)"]
[10.7,"GPS accuracy was captured with required degree of precision as per manual(s)"]
[10.8,"There were issues with tablets where their batteries lost charge too soon (before manufacturer's specification)"]
["10.9","There were issues with tablets where their screens were freezing"]
["10.10","There were issues with tablets where the sunglare on their screens made it difficult to use"]
["10.11","There were issues with tablets where their touch-screens were not responsive "]
["10.12","There were other issues with tablets that made it difficult to use (specify in remarks)"]
[]
[null,"Supervisor"]
[10.130000000000001,"The assignment of households through the menu worked as designed"]
[10.14,"If the supervisor application is linked to the map application using GEOIDs, it performed as designed"]
[10.15,"The review of interviews in the supervisory application worked as designed"]
[]
[null,"Enumerator"]
[10.16,"The enumerator was able to see and work with the assigned EAs smoothly"]
[10.17,"The enumerator was able to see and work with the assigned households smoothly"]
[10.18,"The order of questions worked as designed. Skip patterns worked as expected"]
["10.19","For questions that ask for a number, the programmed range of numerical responses were adequate to record all responses. (Eg, age, number of hh members, number of children, number of mobile phones, etc.)"]
["10.20","The categorical answer options were sufficient to capture all responses"]
[10.210000000000001,"The categorical answer options covered all the major categories in the country (e.g., major religions, ethnicities, etc.)"]
[10.220000000000001,"Navigating to the next screen was smooth (for instance, answer option buttons were not too close to the next screen arrow)"]
[10.23,"Interrupted interview was easy to put on pause and resume at a later time"]
[10.24,"It was easy to add  household members in the houseold listing in the middle of the interview if a mistake had been made by the respondent or interviewer"]
[10.25,"It was easy to drop household members in the houseold listing in the middle of the interview if a mistake had been made by the respondent or interviewer"]
[10.26,"It was easy to navigate the app to go back and correct a response when new information conflicted with a previous response"]
[10.27,"When enumerator encountered a consistency check, the application prompted them to review/revise the response"]
[10.28,"When enumerator encountered a consistency check that needed revision, the application navigated them to correct the screen"]

{"sheet":"Report on Issues","index":17,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
["Report on Issues to Address"]
["This page compiles all the responses that were either, 'No\" or \"Don't know\" and the remarks. Click the \"Compile Report\" button to the right to populate the table below."]
["Item","Question","Remarks","Problem Question (10. CAPI App Only)"]
[null,"Items with 'NO' responses"]
[null,"Items with 'DON'T KNOW' responses"]

{"sheet":"Data on Pilot","index":18,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Data on Pilot "]
[]
[null,"Start Date","End Date"]
["Training of trainers "]
["Training of supervisors and enumerators"]
["Pilot census"]
[]
[null,"Total","Urban","Rural","[Region]","[Region]","[Region]"]
["Number of pilot enumeration areas"]
["Number of supervisors"]
["Number of enumerators"]
["Ratio of enumerators to supervisors "]
[]
[null,"Total","Urban","Rural"]
["Average interview time "]
[]
[]
["Interview time histogram (insert from dashboard)"]
[]
[null,"Total","Urban","Rural","[Region]","[Region]","[Region]"]
["Response rate"]
["Refusal rate"]
["Coverage rate"]