1. Background
The Central Agency for Public Mobilization and Statistics (CAPMAS) is the official source of comprehensive statistical data in Egypt, playing a crucial role in national planning and development. 4In its ongoing efforts to enhance data processing and analysis capabilities, CAPMAS, with the support of the United Nations Population Fund (UNFPA) and United Nations Children's Fund (UNICEF), is seeking to strengthen the technical skills of its staff in utilizing specialized statistical software.ย
CAPMAS is going to conduct the Egyptian Family Health Survey (EFHS) this year. With this regard, CAPMAS is seeking support in recruiting a CSPro Expert to provide theoretical training, facilitate practical experience for the CAPMAS team (10-15 employees), covering all functionalities of the package as well as modifying the previously designed questionnaire and test it.
CSPro (Census and Survey Processing System) is a public domain software package developed by the U.S. Census Bureau that is widely used by statistical agencies for entering, editing, tabulating, and disseminating census and survey data. 6Given its robust features and widespread adoption in national statistical offices globally, enhancing CAPMAS staff proficiency in CSPro is essential for efficient and high-quality data management.
2. Purpose of the Assignment
The main purpose of this consultancy is to enhance the technical capacity of CAPMAS staff in using CSPro for various stages of survey and census data processing, from data entry and validation to tabulation and dissemination. The expert will design and deliver a comprehensive training program tailored to the specific needs and current skill levels of CAPMAS personnel. This includes providing theoretical training, facilitating practical experience for 10-15 CAPMAS employees, and assisting in the modification and testing of a previously designed questionnaire for the EFHS.
3. Objectives of the Assignment
The key objectives of this consultancy are to:ย ย
Assess the current CSPro knowledge and skill levels of CAPMAS staff.ย ย Design and develop a comprehensive training curriculum on CSPro, covering its core functionalities and advanced applications.ย ย Deliver hands-on training to CAPMAS staff on CSPro, including practical exercises and real-world case studies relevant to CAPMAS operations.ย ย Provide technical guidance and mentorship to CAPMAS staff to address specific challenges and enhance their ability to apply CSPro effectively.ย ย Facilitate practical experience for the CAPMAS team in applying CSPro skills. Share relevant resources and materials with CAPMAS team preferably in Arabic Support CAPMAS team in modifying a previously designed CSPro questionnaire and testing it for the upcoming EFHS. Support the development of internal capacities within CAPMAS for ongoing CSPro support and future training initiatives. Address all the relevant needs and questions of CAPMAS trainees. Introduction to CSPro and its architecture.ย ย Data entry application design (CSPro Data Entry).ย ย Data validation and editing (CSPro Batch Editing).ย ย Data processing and manipulation.ย ย Tabulation and data aggregation (CSPro Tabulation).ย ย Exporting data to other statistical software (e.g., SPSS, Stata).ย ย Best practices for CSPro project management and documentation.ย ย4. Scope of Work
Under the overall guidance of CAPMAS leadership and in close collaboration with UNFPA and UNICEF, the Expert will undertake the following tasks:ย ย
Phase 1: Needs Assessment and Curriculum Development (3 working days)ย ย
Conduct a needs assessment among targeted CAPMAS staff to identify existing CSPro knowledge gaps and specific training requirements.ย ย Based on the needs assessment, design a detailed CSPro training curriculum, including learning objectives, modules, content outlines, and practical exercises.ย ย The curriculum should cover:ย ย Develop or adapt training materials, including presentations, user manuals, and exercise datasets.ย ยPhase 2: Training Delivery and Practical Application (12 working days)ย ย
Deliver interactive and practical training sessions to CAPMAS staff (10-15 employees).ย The training should be structured to allow for hands-on application of concepts.ย ย Provide individualized support and troubleshooting for participants during practical sessions.ย ย Facilitate discussions and knowledge sharing among participants to foster a collaborative learning environment.ย ย Conduct pre- and post-training assessments to measure knowledge acquisition and skill improvement.ย ย Guide the CAPMAS team in modifying the previously designed EFHS questionnaire in CSPro and assist with testing its functionality and data capability.Phase 3: Post-Training Support and Recommendations (5 working days)ย ย
5. Deliverables
The consultant will be responsible for delivering the following outputs:ย ย
30% will be paid upon submission and UNFPA approval of: Inception Report: Detailing the methodology for needs assessment, proposed training curriculum, work plan with timelines, and initial thoughts on training materials.ย (Within 5 working days of contract signing)ย ย CSPro Training Curriculum and Materials: Complete set of developed or adapted training modules, presentations, user guides, and practical exercise datasets. (Prior to the commencement of training delivery)ย ย Modified and Tested EFHS Questionnaire: Documentation of the modifications made to the questionnaire and results of testing. 30% will be paid upon submission and UNFPA approval of: Training Completion Report: Documenting the training sessions conducted, participant attendance, pre/post-assessment results, and overall training effectiveness.ย (Within 1 week after the completion of training delivery)ย ย 40% will be paid upon submission and UNFPA approval of: Final Consultancy Report: Comprehensive report including a detailed overview of the assignment, findings from needs assessment, challenges and lessons learned, and actionable recommendations for strengthening CAPMAS's CSPro capabilities and data processing workflows. 45(Within 2 weeks of the completion of the assignment)ย ย6. Required Expertise and Qualifications (Individual Consultant)
The successful candidate will possess the following qualifications:ย ย
Education: Advanced university degree (Master's or higher) in Statistics, Demography, Computer Science, Information Technology, Social Sciences, or a related field.ย ย Experience: Minimum of 7 years of proven professional experience in data processing for surveys and censuses, with a strong focus on using CSPro.ย ย Demonstrated experience in designing and delivering technical training programs, particularly in statistical software, for national statistical offices or similar governmental institutions.ย ย Extensive practical experience in all aspects of CSPro, including data entry application development, batch editing, data manipulation, and tabulation.ย ย Familiarity with data quality assurance processes and international standards for statistical data.ย ย Prior experience working with UN agencies or in development contexts, especially in the MENA region, is an asset. 53 Experience in questionnaire design and testing using CSPro. Expert-level proficiency in CSPro.ย ย Strong understanding of survey and census methodologies.ย ย Proficiency in other statistical software (e.g., SPSS, Stata, R) is a plus.ย ย Technical Skills: Language: Arabic and knowledge of English is an advantageย Competencies: Strong analytical and problem-solving skills.ย ย Excellent communication, presentation, and interpersonal skillsย Ability to work independently and as part of a team in a multicultural environment.ย ย Results-oriented and committed to delivering high-quality outputs within agreed timelines.ย ยThe selected consultant would be required to deliver an Inception Report, the complete CSPro Training Curriculum and Materials, the Modified and Tested EFHS Questionnaire, a Training Completion Report, and a Final Consultancy Report. Physical presence in Cairo, Egypt, for the training delivery phase would be expected, with limited flexibility for remote work during preparation and reporting, subject to agreement.ย
7. Duration and Working Schedule
The consultancy is expected to be for a total of 20 working days, spread over a period of 3 months.ย The exact working schedule will be agreed upon with CAPMAS, UNFPA and UNICEF upon commencement of the assignment.ย The consultant is expected to be physically present in Cairo, Egypt for the training delivery phase, with flexibility for remote work during the preparation and reporting phases, subject to agreement.ย ย
8. Reporting and Supervisory Arrangements
The consultant will work under the overall guidance of the CAPMAS leadership and the direct and the UNFPA Population and Development Analyst and UNICEF Child Rights Monitoring Specialist in Egypt.ย Regular progress updates and meetings will be held with the supervisory team.ย ย
9. Inputs / Services to be Provided by CAPMAS
Access to relevant CAPMAS data, systems, and personnel for needs assessment and training purposes. Training venue, equipment (computers, projector), and necessary logistical support during the training sessions.ย The previously designed EFHS questionnaire for modification and testing.10. Application Process
Interested candidates are requested to submit the following documents:ย
Curriculum Vitae (CV): Highlighting relevant experience and qualifications.ย ย Cover Letter: Expressing interest in the consultancy and outlining how the skills and experience align with the TOR.ย Technical Proposal: A brief outline (max. 2 pages) of the proposed approach to conduct the needs assessment, design the curriculum, and deliver the training, including how they will address the questionnaire modification and practical experience requirements.ย ย Financial Proposal: Daily professional fee in Egyptian pounds.ย ย