
Data Management Applied to the Hotel Sector
Code: 107801Credits: 6
| Degree programme | Type | Course |
|---|---|---|
| Hotel Management | FB | 1 |
Contact lecturer
- Name :
- Juan David Vega Baquero
- Email :
- juandavid.vega@uab.cat
Group languages
You can consult this information at the end of the document.
Prerequisites
None
Objectives
At the end of the course, students will be able to:
-
Identify the types of variables suitable for quantitative analysis in hospitality.
-
Collect, analyse and present quantitative and qualitative information in the hospitality industry.
-
Understand the importance of collecting, analysing and presenting statistical data considering gender and sustainability perspectives in the sector.
-
Analyse data, populations and samples, as well as the association between variables to assess the economic dimension of the sector.
-
Interpret statistical results from a critical perspective, taking into account aspects of gender inequality and sustainability in the sector.
-
Understand the main concepts and parameters of descriptive statistics and establish criteria for presenting data analytically and graphically.
-
Identify variables related to hospitality and tourism characterised by randomness and analyse them using basic probabilistic techniques.
-
Apply statistical inference using hypothesis testing and estimation.
-
Perform time series analyses and forecast key hospitality and tourism variables.
-
Assess the advantages and disadvantages of different statistical methods for a given type of observation.
-
Identify key sources of quantitative data in the sector (e.g. publications, surveys, databases, etc.) and know how to use them.
Learning outcomes
- CM09 (Integrate quantitative and qualitative information on the tourism sector in order to assess the economic dimension of tourism in accordance with the Sustainable Development Goals.) Integrate quantitative and qualitative information on the tourism sector in order to assess the economic dimension of tourism in accordance with the Sustainable Development Goals.
- CM10 (Interpret statistical data on the industry for operational decision-making.) Interpret statistical data on the industry for operational decision-making.
- KM09 (Identify variables related to the hotel and restaurant sector characterised by randomness.) Identify variables related to the hotel and restaurant sector characterised by randomness.
- KM10 (Recognise quantitative and qualitative information on the tourism and hotel sector in existing databases.) Recognise quantitative and qualitative information on the tourism and hotel sector in existing databases.
- SM12 (Analyse data, populations, samples, tables and graphics of variables related to the tourism sector.) Analyse data, populations, samples, tables and graphics of variables related to the tourism sector.
- SM13 (Analyse quantitative and qualitative information related to the economic and social dimension of tourism.) Analyse quantitative and qualitative information related to the economic and social dimension of tourism.
Contents
Topic 1: Preliminary concepts
- Basic concepts in statistics.
- Data organisation and presentation: tables and frequency distributions.
- Data collection through questionnaires and tabulation.
- Bar charts, histograms and other graphical representations.
- Sources of qualitative data in tourism and basic methods of integration with quantitative data (for mixed analysis).
- Information systems in tourism:
- Impact of information systems on the sector.
- Examples: PMS, CRS, CRM and BI tools applied to the sector.
Topic 2: Measures of central tendency
- Concepts of mean, median, mode, and quintiles.
- Relationship between measures.
Topic 3: Measures of dispersion and concentration
- Range, interquartile range, variance, standard deviation, coefficient of variation.
- Lorenz curve and Gini coefficient, uses of the Gini in tourism.
- Gender inequality analysis in dispersion and concentration indicators.
Topic 4: Measures of shape
- Measures of skewness and kurtosis.
- Box plot.
Topic 5: Bivariate series
- Definition and graphical representation.
- Central tendency.
- Statistical dispersion.
- Covariance.
Topic 6: Statistical dependence
- Correlation: concept, procedure and application.
- Pearson’s correlation coefficient.
- Fitting linear regressions between two variables.
- Least squares approach.
- Application of dependence analysis to market studies and characteristics of tourism businesses.
Topic 7: Probability
- Operations with probabilities.
- Probability assignment: random variables and their distributions.
Topic 8: Time series
- Definition and graphical representation.
- Components of time series.
- Seasonal variation.
- Seasonal indices.
- Seasonal adjustment.
Learning activities and methodology
| Title | Hours | ECTS | Learning outcomes |
|---|---|---|---|
| Research | 14 | 0.56 | CM09, KM09, SM12, SM13 |
| Case study resolution | 15 | 0.6 | CM09, KM09, KM10, SM12, SM13 |
| Self-directed study | 20 | 0.8 | CM09, CM10, KM09, KM10, SM12, SM13 |
| Solving exercises and problems | 24 | 0.96 | CM09, CM10, SM12, SM13 |
| Theoretical sessions | 43 | 1.72 | CM10, KM09, KM10, SM12 |
| Tutoring | 20 | 0.8 | SM12, SM13 |
The course is structured into three main teaching and learning methods:
1️⃣ Theoretical sessions
During the classes, concepts will be explained theoretically and illustrated with practical applications. Some sessions will encourage active student participation through problem-solving activities related to the sector.
2️⃣ Practical sessions
These sessions will allow students to review and apply the topics covered in the theoretical sessions through exercises, group projects and individual tests carried out during the course. Case studies related to tourism will be worked on, and specific variables of this industry will be analysed.
The teaching staff will provide guidance for the development of a project requiring the use of statistical skills and computer tools. Specialised software will be used whenever possible during these sessions.
3️⃣ Self-directed learning
The Virtual Campus will be used as a complementary resource and as an additional means of communication between the teaching staff and the students. All relevant course materials, including examples and exercises, will be available online.
Each student will be responsible for managing their time to study and solve the proposed problems, as well as for developing a research project based on statistical data from the tourism sector, to be presented at the end of the course.
Assessment
Continuous assessment activities
| Title | Weight | Hours | ECTS | Learning outcomes |
|---|---|---|---|---|
| Individual and group exercises | 40% | 4 | 0.16 | CM09, CM10, KM09, KM10, SM12, SM13 |
| Final project and presentation | 20% | 6 | 0.24 | CM09, KM09, SM12, SM13 |
| Midterm exam 1 | 20% | 2 | 0.08 | CM09, CM10, KM09, KM10 |
| Midterm exam 2 | 20% | 2 | 0.08 | KM09, SM12, SM13 |
Students can choose between continuous assessment or direct access to the final exam (single assessment).
A) Continuous assessment
The continuous assessment system involves the periodic submission of individual and group assignments and the completion of two midterm exams to consolidate the concepts and topics developed during the course. Each midterm exam will count for 20% of the final grade. In order to average the two midterm exam scores, students must achieve a minimum score of 4 points in each exam.
The dates for assignment submissions and midterm exams will be detailed on the Virtual Campus.
Students who do not pass the subject through continuous assessment will be assessed under the single assessment system, with no consideration given to previous marks.
B) Single assessment
The single assessment will consist of a final exam covering the entire syllabus, held on the date and time set in the academic calendar according to the Official Programme of the Centre.
There will be only one type of final exam for all students, with no differentiation between those who have followed continuous assessment and those who have not.
C) Re-assessment
There is no minimum grade required to access the re-assessment. There will be only one type of final exam for all students, with no differentiation between those who have followed continuous assessment and those who have not.
D) Not evaluable
The grade for the subject will be NOT EVALUABLE when the student attends less than half of the assessment activities and/or does not attend the final exam.
IMPORTANT:
In the event of a student committing any irregularity that may lead to a significant variation in the grade awarded to an assessment activity, the student will be given a zero for this activity, regardless of any disciplinary process that may take place. In the event of several irregularities in assessment activities of the same subject, the student will be given a zero as the final grade for this subject.
This subject allows the use of AI technologies as an integral part of the submitted work, provided that the final result reflects a significant contribution from the student in terms of analysis and personal reflection. The student must clearly (i) identify which parts have been generated using AI technology; (ii) specify the tools used; and (iii) include a critical reflection on how these have
influenced the process and final outcome of the activity.
Lack of transparency regarding the use of AI in the assessed activity will be considered academic dishonesty; the corresponding grade may be lowered, or the work may even be awarded a zero. In cases of greater infringement, more serious action may be taken.
Bibliography
Buglear, J. (2010). Stats means business- Statistics with Excel for business, hospitality & tourism (2nd ed.). New York: Elsevier.
Casas Sánchez, J., Martos Gálvez, E., & Tejera Martín, Í. (2011). Estadística aplicada al turismo. Editorial Centro de Estudios Ramón Areces.
Davis, G., & Pecar, B. (2009). Business Statistics using Excel (2nd ed.). Oxford University Press.
Good, P. I., & Hardin, J. W. (2012). Common errors in statistics (and how to avoid them). [Hoboken, N.J.]: John Wiley.
Newbold, P., Carlson, W. L., & Thorne, B. (2013). Statistics for business and economics. Harlow, Essex: Pearson Education.
Parra López, E. (2007). Estadística para turismo. McGraw-Hill España. Disponible en línea
Ross, S. M. (2010). Introductory statistics. Amsterdam: Elsevier: Academic Press.
Rugg, G. (2007). Using statistics: a gentle introduction. Maidenhead: McGraw-Hill.
UNWTO (2010) International Recommendations for Tourism Statistics 2008, Statistics and Tourism Satellite Account, World Tourism Organization, New York. Available online
World Tourism Organization. (2024). International tourism highlights: 2024 edition. World Tourism Organization. https://doi.org/10.18111/9789284425808 - https://www.unwto.org/un-tourism-world-tourism-barometer-data
Yearbook of Tourism Statistics, Data 2014 - 2018, 2020 Edition. (2020). Available online
Software
The course will use Microsoft 365 tools available to students, mainly:
-
Excel, Word, PowerPoint, OneDrive and Teams for data analysis, preparation of reports and presentations, and online collaboration.
-
Forms for data collection through surveys.
-
Other tools recommended by the teaching staff according to the needs of the project or practical activities.
Course groups and languages
The information provided is provisional until November 30. After this date, you will be able to consult the language of each group through this link. To access the information, you will need to enter the course CODE
| Type of teaching | Group | Language | Semester | Shift |
|---|---|---|---|---|
| (TE) Theory | 1 | Catalan/Spanish | second semester | morning-mixed |