Daftar Ahwal for Archiving and Documentation announces the launch of the first course of the School of Social Data Management and Analysis, an annual school organized by the Societal Indicators program, one of the programs of the Center. The school offers 14 specialized workshops on data management and analysis from a social perspective, each student will then work on a limited information project for a social topic, according to the choice of each trainee.
About Societal Indicators
It works on building and making social databases, indicators and statistical forecasts on social issues and topics in Egypt available. It considers the individual and his relationship with society as the key element in making a social event. The program also develops participatory activities to enhance data analysis and management capabilities and to build information design in a professional manner.
School Objectives:
- Promote capacity building for data management and analysis within civil society.
- Building cadres and building data management and analysis capabilities among the new generation of graduates with interests in the field of social sciences.
- Dissemination of the culture of production and availability of open databases within the Egyptian society.
- Support the provision of job opportunities for the competencies in the field of data management and analysis.
Graduation project: There will be a limited information project for a social subject according to the trainees’ choice, A plan will be set to work on it, develop and finalize it during the training period, and there will be a media space to publish the project of each trainee on the Daftar Ahwal platform with reference (if the trainee agrees to do so).
Graduation certificate: A technical graduation certificate will be issued from Daftar Ahwal in Data, Archiving and Statistics management.
Job Opportunities: according to the 2018 plan only, there will be a “gradual” opportunity to recruit a full-time researcher for the Societal Indicators program (all school workshops are required), the graduation certificate can be used to apply to other workplaces, and there is also the possibility of issuing a nomination letter From Daftar Ahwal management addressed to other civil society organizations if so requested.
Conditions of application:
- A graduate of one of the faculties of social sciences and its branches or has previous work experience in this field (applications from current students are not accepted).
- Age, year of graduation or experience is not required.
- Full-time availability to be able to attend and practical application due to the intensive applied content within each workshop.
- Proficiency in the skills of dealing with “Microsoft office” programs especially Excel (the school is targeted for beginners as well).
- Able to work on data entry and desire to develop it as a minimum of the role.
- Language: Good reading, writing and communication skills in English.
- Have the desire to develop, innovate and care to follow up on societal issues or areas of social and human sciences in Egypt (such as health, education, transport, issues, harassment, child trafficking, and archaeological crimes).
The general framework of the lecture schedule:
| Day | Workshop | Workshop name | Workshop Type | Workshop subject | Trainer | |
| Saturday | 29-Dec | 1 | Introduction to the process of information production: Mechanisms, standards and problems | theoretical | Introduction – Types of sources – Basic variables and metadata – Stages of data collection, input and cleaning and production of information | Asmaa Elgredley |
| Wednesday | 2-Jan | 2 | Skills and means of research and information collection electronically | practical | Information gathering mechanism – skills of using search engines | Yehia Gamal |
| Wednesday | 9- Jan | 3 | Data Entry | practical | Building the information system – coordination of the information system – stages of dealing with information content – Input – Input completion skills | Asmaa Elgredley |
| Saturday | 12-Jan | 4 | Data Cleaning 1 | practical | Filter, Sort and Replace features | Yehia Gamal |
| Saturday | 19-Jan | 5 | Data Cleaning 2 | practical | Separation of variables – Standardization of coordination and conventions – Hierarchy of information construction – Adds countable and uncountable columns – Metadata construction | Asmaa Elgredley |
| Wednesday | 23-Jan | 6 | Information system
assessment | practical | Stages of dismantling and building the information system – Evaluating the information system – Evaluating the sources – Reviewing the information gaps – Statistical Unit Census Standards | Ahmed Atif |
| Saturday | 26-Jan | 7 | Descriptive statistics for
variables 1 | practical | Build a census between two variables | Asmaa Elgredley |
| Wednesday | 30-Jan | 8 | Descriptive statistics for
variables 2 | practical | Build a statistical census between more than two variables and build an advanced statistical system | Asmaa Elgredley |
| Saturday | 2-Feb | 9 | Simplified optical
production | practical | Build graphs of variables – simple skills in visual production | Yehia Gamal |
| Saturday | 9-Feb | 10 | Set up the database
directory | theoretical | Preparation (conceptual framework – methodology and mechanism of information collection – review of sources – criteria for data division – conclusion and hypothesis – problems and challenges) | Asmaa Elgredley |
| Wednesday | 13-Feb | 11 | Archive and manage files | practical | Types of archives – Steps to build an archival system – Indexing criteria – Preparing the archive guide | Hany Fadel |
| Saturday | 16-Feb | 12 | Geographic Information
Systems and Spatial Analysis | practical | Geo-referencing, shape files (point, polygon, and lines), and generating spatial descriptive statistics. | Dr. Neil Ketchley |
| Wednesday | 20-Feb | 13 | Evaluation and free space | practical | Reviewing and evaluating the overall graduation project for each trainee – free space for discussion | Asmaa Elgredley |
Schedule of the stages of advertising, admission and organization of the school:
• Wednesday 21-11 until Wednesday 5-12: publish the announcement and open the door for progress.
• Thursday 6-12 until Sunday 9-12: Inform those selected for the interview phase.
• Monday 10-12 until Saturday 15-12: interview phase.
• Monday 17-12 until Wednesday 19-12: inform those admitted for training.
• Saturday 22-12 to Tuesday 5-2: Training (14 workshops in seven weeks).
To apply to the school, please send your CV and a sample of previous work if available on the following form http://bit.ly/2TDz76d no later than December 5, 2018.
