FCSC DIPLOMA PROFESSIONAL PROFILE 2:
Synopses

DATA AND FIELD MANAGEMENT
FCSC Diploma Module 2.1
Data collection design and operation

•  Introduction to data collection design and operation
•  Target populations, sampling frames, and coverage error - censuses versus surveys, populations and frames, coverage properties of sampling frames, alternative frames for the target population
•  Sources of error in statistical operations - sampling and non-sampling errors, non-response, coverage, measurement, and processing errors
•  Sampling surveys - an overview of sample designs, longitudinal surveys versus cross-sectional surveys
•  Modes of data collection - personal interviews, postal surveys, phone surveys, web surveys
•  Issues related to data collection methods - self-completion questionnaires, degrees of interviewer involvement, degrees of privacy
•  Mixed mode surveys
•  Choosing the most appropriate method of data collection
•  Survey interviewing - types of interview, increasing response rate and data quality, and tips and techniques
•  Managing fieldwork - organisation of data collection, public relations, preparation of data collection procedures, listing, conducting interviews and monitoring quality
•  Formulation and classification of questions
•  Evaluating survey questions
•  Making questionnaires suitable for data processing and analysis
•  Post-collection processing of survey data - introduction, coding, entering numerical data into files, editing

FCSC Diploma Module 2.2
Data quality management

•  Definition of quality in statistics
•  European statistics code of practice (ESCoP)
•  Main concepts of quality dimensions
•  Product quality and quality reporting
•  Tools for measuring product quality
•  Process quality
•  Tools for measuring process quality components - brainstorming, current best methods, technical tools, auditing, and benchmarking
•  Introduction to quality management and quality frameworks
•  Quality assessment framework (QAF)
•  Common assessment framework (CAF)
•  Total quality management (TQM)
•  European foundation for quality management (EFQM)
•  Balanced scorecard management tool (BSC)
•  International standards organisation (ISO9001)
•  Tools for measuring perceptions of various actors - self-assessments, auditing, customer satisfaction, public opinion, and staff opinion
•  Strategic management and policy

FCSC Diploma Module 2.3
Statistical survey planning and questionnaire design

•  Introduction to statistical surveys
•  Data collection with surveys - planning the steps of a statistical survey, overview of sampling designs, and sources of non-sampling error in statistical surveys
•  The cognitive model in answering questions - objectives, the general model of comprehension-retrieval-judgment-reporting
•  The conceptional frame in questionnaire design - objectives-concepts-definitions, stratification and methods for conceptualisation and operationalisation, questionnaire schemes, designing the variables and having an analysis plan, and the impact of data collection modes on the questionnaire
•  Writing the questions in questionnaire design - principles for writing questions, types of question, question formats, measurement scales, response categories, question phrasing, and designing questionnaire flow
•  Visual design in questionnaire design - visual design elements, emotional level of visual design, and functional level of visual design
•  Methods for testing the questionnaire - pre-field testing methods, field testing methods, and post-field testing methods
•  Specificities of electronic surveys - web survey methodology, electronic questionnaire design and implementation, transition to electronic questionnaires, electronic questionnaire structure, layout, and functionality and usability testing

FCSC Diploma Module 2.4
Data storage and retrieval

•  Relational database management systems (RDBMS)
•  Data normalisation
•  Database design
•  Create, read, update, delete (CRUD) operations
•  Creation of views
•  Online transaction processing (OLTP) and online analytical programming (OLAP) databases
•  The role of data warehouses as a support for analytics
•  Multidimensional models and the architecture of data warehouses
•  Implementation of the extract, transform, load (ETL) pipeline to retrieve data from the OLTP layers to OLAP layers
•  Complex OLAP operations to support the analytics process over the data cube abstraction
•  The main challenges of storing big data
•  The impact of big data  solutions in different technological applications
FCSC DIPLOMA
PROFILE 2:
Synopses

DATA AND FIELD MANAGEMENT
FCSC Diploma Module 2.1
Data collection design and operation

•  Introduction to data collection design and operation
•  Target populations, sampling frames, and coverage error - censuses versus surveys, populations and frames, coverage properties of sampling frames, alternative frames for the target population
•  Sources of error in statistical operations - sampling and non-sampling errors, non-response, coverage, measurement, and processing errors
•  Sampling surveys - an overview of sample designs, longitudinal surveys versus cross-sectional surveys
•  Modes of data collection - personal interviews, postal surveys, phone surveys, web surveys
•  Issues related to data collection methods - self-completion questionnaires, degrees of interviewer involvement, degrees of privacy
•  Mixed mode surveys
•  Choosing the most appropriate method of data collection
•  Survey interviewing - types of interview, increasing response rate and data quality, and tips and techniques
•  Managing fieldwork - organisation of data collection, public relations, preparation of data collection procedures, listing, conducting interviews and monitoring quality
•  Formulation and classification of questions
•  Evaluating survey questions
•  Making questionnaires suitable for data processing and analysis
•  Post-collection processing of survey data - introduction, coding, entering numerical data into files, editing

FCSC Diploma Module 2.2
Data quality management

•  Definition of quality in statistics
•  European statistics code of practice (ESCoP)
•  Main concepts of quality dimensions
•  Product quality and quality reporting
•  Tools for measuring product quality
•  Process quality
•  Tools for measuring process quality components - brainstorming, current best methods, technical tools, auditing, and benchmarking
•  Introduction to quality management and quality frameworks
•  Quality assessment framework (QAF)
•  Common assessment framework (CAF)
•  Total quality management (TQM)
•  European foundation for quality management (EFQM)
•  Balanced scorecard management tool (BSC)
•  International standards organisation (ISO9001)
•  Tools for measuring perceptions of various actors - self-assessments, auditing, customer satisfaction, public opinion, and staff opinion
•  Strategic management and policy

FCSC Diploma Module 2.3
Statistical survey planning and questionnaire design

•  Introduction to statistical surveys
•  Data collection with surveys - planning the steps of a statistical survey, overview of sampling designs, and sources of non-sampling error in statistical surveys
•  The cognitive model in answering questions - objectives, the general model of comprehension-retrieval-judgment-reporting
•  The conceptional frame in questionnaire design - objectives-concepts-definitions, stratification and methods for conceptualisation and operationalisation, questionnaire schemes, designing the variables and having an analysis plan, and the impact of data collection modes on the questionnaire
•  Writing the questions in questionnaire design - principles for writing questions, types of question, question formats, measurement scales, response categories, question phrasing, and designing questionnaire flow
•  Visual design in questionnaire design - visual design elements, emotional level of visual design, and functional level of visual design
•  Methods for testing the questionnaire - pre-field testing methods, field testing methods, and post-field testing methods
•  Specificities of electronic surveys - web survey methodology, electronic questionnaire design and implementation, transition to electronic questionnaires, electronic questionnaire structure, layout, and functionality and usability testing

FCSC Diploma Module 2.4
Data storage and retrieval

•  Relational database management systems (RDBMS)
•  Data normalisation
•  Database design
•  Create, read, update, delete (CRUD) operations
•  Creation of views
•  Online transaction processing (OLTP) and online analytical programming (OLAP) databases
•  The role of data warehouses as a support for analytics
•  Multidimensional models and the architecture of data warehouses
•  Implementation of the extract, transform, load (ETL) pipeline to retrieve data from the OLTP layers to OLAP layers
•  Complex OLAP operations to support the analytics process over the data cube abstraction
•  The main challenges of storing big data
•  The impact of big data solutions in different technological applications
FCSC DIPLOMA