Analysis of the labor market in the EU and migration processes 2103-ORP-M-D1ARPM
- https://classroom.google.com/c/MTk0MDQyMTU0MTZa?cjc=wwlwpag
- https://classroom.google.com/c/NjE1MTUxMjkzMzA4?cjc=udnabs5 (term 2023Z)
### Scope of Topics
1. **Contemporary Global Order, Migration, and Work**
- Introduction to the course objectives
- Introduction to labor market analysis and migration issues
**Literature/Materials:**
- Bartosiak J., *The End of the End of History*, New Confederation Publishing, Warsaw 2020. [Preferably the entire book, but definitely the chapter titled *European Empire on Its Knees*]
- Lin J. Y., Nowak A. Z., *New Structural Economics for Less Advanced Countries*, Scientific Publishing House of the Faculty of Management, University of Warsaw, Warsaw 2017. [Read before the first class as an introduction to discussion]
2. **International Regulations in the Labor Market and Their Impact on Employment: ILO, Council of Europe, European Union**
- International labor market regulations
- International migration policy regulations
**Literature/Materials:**
- Nadolska J., *Models of Shaping Social Security in Contemporary Liberal Democracies*, [in:] Nadolska J., Wojtaszczyk K.A., Zamęcki Ł. (eds.), *Democracy. Essence, Ideas, Goals and Their Realization*, ASPRA-JR, Warsaw 2018.
**Useful Normative Acts:**
- ILO Conventions and Recommendations
- European Social Charter and its protocols
- Treaty on European Union, Treaty on the Functioning of the European Union [consolidated texts]
- Directive 2004/38/EC on the right of citizens of the Union and their family members to move and reside freely within the Member States
- Regulation (EC) No 883/2004 on the coordination of social security systems
- Directive 2008/115/EC on common standards and procedures for returning illegally staying third-country nationals
- Directive 2009/50/EC on conditions of entry and residence of third-country nationals for the purposes of highly qualified employment (EU Blue Card)
- Directive 2009/52/EC providing for minimum standards on sanctions and measures against employers of illegally staying third-country nationals
3. **EU and Member States' Employment and Migration Policy Instruments**
- EU policies
- EU policy instruments
- Freedom of movement
- Migration policy
- Size and directions of migratory movements in the EU, including their causes and social, economic, and political impacts
**Literature/Materials:**
- Anioł W., *The European Union as a Social Community*, [in:] K.A. Wojtaszczyk, W. Jakubowski (eds.), *European Studies. Academic Textbook*, vol. 2, PWN, Warsaw 2012.
- Anioł W., Duszczyk M., Zawadzki P.W. (eds.), *Social Europe. Illusion or Reality?*, Aspra-Jr, Warsaw 2011.
- [Consilium: EU Migration Policy](https://www.consilium.europa.eu/pl/policies/eu-migration-policy/)
- [6 priorities of the European Commission for 2019-2024](https://ec.europa.eu/info/strategy/priorities-2019-2024_pl)
- *What Immigration Policy Does Poland Need?*, YT channel "Układ otwarty - Igor Janke" 2.11.2023.
4. **Analysis of Factors Affecting Employment Size and Structure in EU Countries**
- Economic factors: analysis of the relationship between economic policy and employment, impact of macroeconomic factors on the labor market in the EU
- Demographic factors: impact of demographic changes on the labor market in the EU
- Social and political factors: impact of social and political factors on the labor market in the EU
**Literature/Materials:**
- Drabiński A., Wolski J., *Demographics of the European Union - What's Next?*, Wolski o Wojnie 9.03.2023.
- Nadolska J., *The European Social Model in the Face of Globalization, Demography, and the 2008+ Economic Crisis*, [in:] Nadolska J., Wallas T., Wojtaszczyk K.A. (eds.), *With Whom, Where, and Where to? Poland and the EU's Integration Dilemmas*, ASPRA-JR, Warsaw 2018.
- Wróblewski T., *Why the Middle Class is Losing Jobs?*, Freedom Under Renovation #108.
- Zawadzki P.W., *Professional Activity and Employment Structure*, [in:] Żołędowski C., Rysz-Kowalczyk B., Duszczyk M., *A Decade of EU Membership. Social Policy Perspective*, DW Elipsa, Warsaw 2015.
5. **Size and Directions of Migratory Movements in EU Countries, Considering Their Causes and Social, Economic, and Political Impacts**
**Literature/Materials:**
- Current migration statistics - Eurostat
- Wróblewski T., *How Politicians' Thoughtlessness Pushes Europe into a Migration Crisis*, Freedom Under Renovation - WEI #171.
- Zawadzki P.W., *First Consequences of Russia's Invasion of Ukraine for the Polish Labor Market*, [in:] *Russia's Invasion of Ukraine. Society and Politics in Response to the Refugee Crisis in the First Month of the War. Working Paper*, Department of Social Policy.
6. **Data Sources and Indicators Used in Labor Market and Migration Analysis**
- Secondary and primary sources
- National and international sources
- Basic labor market indicators, including LFS and definitions of unemployment, inactivity, and employment
- Labor supply indicators: labor force participation rate, inactivity rate, double inactivity rate, unemployment rate
- Demographic data
- Education data
- Economic development data
**Group Work (4 topics x 3 areas = 12 groups):**
- Unemployment and employment: Poland, EU, world
- Migration flows: Poland, EU, world
- Poverty/exclusion: Poland, EU, world
- Economic indicators (GDP, inflation): Poland, EU, world
**Literature/Materials:**
- Open data: [dane.gov.pl](https://dane.gov.pl/pl)
- Current labor market statistics in Poland (MRiPS)
- [Occupational Barometer](https://barometrzawodow.pl/)
- [PSZ Portal](https://psz.praca.gov.pl/)
- [GUS databases](https://stat.gov.pl/)
- [OECD Employment Outlook 2022](https://www.oecd.org/employment-outlook/2022/)
- [OECD Employment](http://www.oecd.org/employment/)
- [World Bank data](https://data.worldbank.org/country/PL)
- [EUROSTAT](https://ec.europa.eu/eurostat)
- [Labour Force Survey](https://ec.europa.eu/eurostat/web/microdata/european-union-labour-force-survey)
7. **Working on a Social Research Project**
- Paradigms, conceptualization, and operationalization of research
- Research methodology: methods, tools, and techniques of social research
**Literature/Materials:**
- Babbie E., *The Practice of Social Research*, PWN, Warsaw 2007.
- Góra M., Sztanderska U., *Introduction to Local Labor Market Analysis. Guide*, MPiPS, Warsaw 2006.
- Łotocki Ł., *Methodology of Labor Market Research. Some Practical Tips*, Mazovian Labor Market Observatory Bulletin No. 4/2011.
**Supplementary:**
- Szatur-Jaworska B., *Introduction to Methods and Techniques of Social Research*, University of Warsaw Publishing, Warsaw 1988.
- Zawadzki P.W., *Changes in the Labor Market and Economy and the State and Possibilities of Employment in the Chemical Industry*, "Chemia i Biznes" No. 3/2022, EPS Media.
8. **Excel Part 1 – Preparation for Working with Spreadsheets**
- Using Excel from a user perspective: navigation, licensing, installation, keyboard shortcuts
- Naming cells, tables, ribbon/toolbars, templates
9. **Excel Part 2 – Popular Functions and Formulas**
- Logical functions, lookup functions, decision support functions
- Mathematical and statistical functions, array formulas
- Conditional formatting
- Creating rule-based formulas
10. **Excel Part 3 – Data Collection and Preparation**
- Excel as a simple database
- Best practices for creating tables
- Browsing data, auto filters, advanced filter
- Removing duplicates
- Text functions, "text to columns"
- Error and inconsistency removal
11. **Excel Part 4 – Data Visualization, Presenting Results**
- Charts: types and applications
- Chart styles: predefined and custom
- Custom charts
- Charts based on grouped data
- Frequency charts
- Time charts
- Pivot charts [depending on group proficiency]
12. **Excel Part 5 – Basic Statistical Analysis and Inference**
- Analysis Toolpak – activation and usage
- Statistical methodology, basic concepts: population, sample, random variables, hypothesis, statistical significance
- Sampling and data collection principles
- Basics of descriptive statistics: mean, median, variance, standard deviation, skewness, kurtosis
- Frequency, relative frequency, cumulative frequency, quantiles
- Histograms and frequency distributions
- Trend analysis on charts
- Basics of mathematical statistics: probability, distribution, distributions (normal, exponential, Student's t, chi-square)
- Potential data relationships: covariance and correlation – calculation and interpretation
- Trends and forecasting: regression analysis
13. **Application of Artificial Intelligence in Data Analysis and Presentation**
- Concept of Artificial Intelligence (AI)
- AI vs ML
- Development and perspectives of AI
- ChatGPT and other LLMs in data analysis
14. **Introduction to Access [Depending on Group Proficiency]**
- When to use Access vs. Excel?
- Applications and capabilities of Access
- Access database: forms, tables, queries, reports
- Import/export data between Excel and Access
- Basics of using ready-made databases in Access
- Basics of database design
**Alternatively:**
- Quick review/workshop on text editing in MS Word (preparation for work, working with styles, formatting text, footnotes, graphic elements, etc.)
15. **Individual Work: Preparation of a Labor Market Analysis in a Selected EU Member State (not Poland)**
16. **Individual Work: Presentation of the Labor Market Analysis in a Selected EU Member State**
17. **Assessment/Test**
|
Term 2023Z:
not applicable |
Term 2024Z:
1. Contemporary Global Order, Migration, and Work 2. International Labor Market Regulations and Their Impact on Employment: ILO, Council of Europe, European Union 3. EU and Member States' Policy Instruments in Employment and Migration 4. Analysis of Factors Affecting Employment Structure in EU Countries 5. Migration Trends in EU Countries, Causes, and Impacts 6. Data Sources and Indicators in Labor Market and Migration Analysis 7. Working on a Social Research Project 8. Excel Part 1 – Introduction to Working with Spreadsheets 9. Excel Part 2 – Popular Functions and Formulas 10. Excel Part 3 – Data Collection and Preparation 11. Excel Part 4 – Data Visualization and Presentation - Frequency charts 12. Excel Part 5 – Basic Statistical Analysis and Inference 13. Application of Artificial Intelligence in Data Analysis and Presentation 14. Introduction to Access [depending on group proficiency] 14a. Alternatively: Quick review/workshop on text editing in MS Word (preparation for work, working with styles, text formatting, footnotes, graphics, etc.) 15. Individual Work: Preparation of a Labor Market Analysis for a Selected EU Member State (excluding Poland). 16. Individual Work: Presentation of the Labor Market Analysis for a Selected EU Member State. 17. Final Test / Course Completion |
Type of course
Prerequisites (description)
Course coordinators
Learning outcomes
### Learning Outcomes
**Knowledge:**
- **K_W05** - The student knows and understands in practice the tools for obtaining data about social bonds, norms, and rules created in the context of work, as well as the institutions, structures, and organizations they create, within the context of the labor market and data analysis about it.
**Skills:**
- **K_U02** - The student is able to use the acquired knowledge of principles and selected methods of social research to identify the causes and course of social processes and phenomena occurring in the area of work and the labor market, in order to obtain and analyze appropriate data.
- **K_U03** - The student is able to use knowledge and analytical tools to forecast the practical consequences of changes occurring in the area of work, including selecting and applying advanced information and communication techniques for data analysis.
- **K_U05** - The student is able to create written reports of their own research, analyses, and forecasts related to knowledge associated with labor studies, based on collected data.
- **K_U06** - The student is able to publicly present their own research, analyses, and forecasts related to knowledge associated with labor studies, and participate in debates on these topics.
**Social Competences:**
- **K_K02** - The student is ready to critically evaluate the knowledge they possess and consider the opinions of experts in determining priorities for the execution of specific tasks.
- **K_K06** - The student is capable of correctly identifying and resolving dilemmas associated with professions in the area of organizing and managing the labor market, adhering to professional ethics and expecting the same from others.
Assessment criteria
### Course Assessment Criteria
- **Active Participation:** Attendance in classes, active engagement, and the preparation of individual and group assignments are essential for passing the course.
- **Class Activity:** Demonstrating familiarity with the literature, actively participating in class activities (asking questions, answering questions, participating in discussions, etc.).
- **Preparation for Classes:** Knowledge of the assigned readings for literature-based sessions, individual preparation of assignments from class to class, and team preparation of assignments from class to class. Continuous, systematic work is crucial.
- **Final Grade Determination:** The quality of the prepared and presented labor market analysis in a selected EU member state will determine the final grade. [An alternative, agreed upon with the group, may be a knowledge test with a practical task related to the use of appropriate software (e.g., searching, analyzing, and correctly presenting labor market data).]
- **Sanctions:** In case of lack of preparation for classes or insufficient activity, mid-term written tests or a final written test may be administered. In justified cases and after consultation with the instructor, an oral test may be possible.
Practical placement
not applicable
Bibliography
According to the content of the "Description" field
|
Term 2023Z:
not applicable |
Term 2024Z:
According to the content of the "Description"/"Scope of topics" field. |
Notes
|
Term 2023Z:
not applicable |
Term 2024Z:
not applicable |
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: