Statistics for Managers using MS Excel, part 2 (5 cr)
Code: HBIS1504-3004
General information
Enrollment
07.02.2022 - 28.02.2022
Timing
14.02.2022 - 27.05.2022
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Online learning
Unit
School of Business
Teaching languages
- English
Seats
0 - 50
Degree programmes
- Bachelor's Degree Programme in International Business
Teachers
- Marcin Topolewski
Groups
-
HBI19S1Degree Programme in International Business
-
HBI20S1Bachelor's Degree Programme in International Business
-
HBI22VKBachelor's Degree Programme in International Business, vaihto-opiskelu/Exchange studies
Objective
The student is able to use basic statistical methods and techniques of data processing and analyzing, which is: collecting, presenting and describing data, applying proper statistical techniques for hypothesis testing about relationship between variables. The student understands the basic concepts in quantitative data analysis. The course will focus on practical applications with MS Excel.
JAMK Competences:
1. Learning to learn-
You develop critical and analytical mindset that helps you to study and review existing knowledge in the light of relevant learning resources and learning methods; incentivizes you to acquire new knowledge; and develops your intellectual capabilities to seek conclusions and draw inferences in various contexts.
To achieve this competence, you will:
- learn to formulate relevant questions and seek information,
- review relevant theoretical, and empirical literature to comprehend diverse perspectives and evaluate, and interpret arguments and counter-arguments,
- understand new developments in your field of study and make informed decisions based thereon.
- acquire the researcher’s mindset to problematize, explore and understand real-life phenomena especially in the academic track system.
2. Proactive development-
You develop solutions in the light of current as well as anticipated situations and challenges in business by applying knowledge, critical reasoning and analytical skills. You ensure that these solutions are feasible, relevant, creative, user-friendly, and sustainable as well as underline active cooperation amongst different actors.
To achieve this competence, you will:
- apply existing knowledge and utilize relevant research methods including digital technology in development projects,
- interpret new evidence in the light of existing body of knowledge, make comparisons and draw inferences,
- express your intellectual contribution through scientific or professional writings,
- understand utility, creativity, viability, scalability, and sustainability of new solutions.
IB competence:
7. Responsible international business management-
You develop your intellectual capabilities to seek conclusions and draw inferences in an international environment to become responsible manager. You develop creative and insightful solutions to solve complex business problems both in the present and the future with explicit emphasis on local and international standards of ethics, responsibility, and sustainability and implications on various stakeholders.
To achieve this competence, you will:
- study developments in your discipline in the international learning milieu and understand various aspects of responsible business management including global business trends and competitive landscape.
- derive and interpret new evidence and compare them with the existing body of knowledge in the global context to draw useful inferences,
- critically assess the implications of actions and decision of the international organizations.
- understand the impact of the of the actions and decisions on the community, in general, and specific stakeholders, in particular.
- understand core aspects of people management in the international business environment.
IBCRI: Skills in Critical and Analytical Understanding: Critically review, analyze and understand information available from academic and professional business sources.
IBBUS: Applied Business Skills: Apply disciplinary and interdisciplinary knowledge to analyze business challenges and global trends to propose or put into action practical business solutions based on the findings.
Content
Probability, Discrete Probability Distributions, Continuous Distributions, Simple Linear Regression, Introduction to Multiple Regression, Multiple Regression, Model Building, Time-Series Forecasting, A Roadmap for Analyzing Data, Statistical Applications in Quality Management, Decision Making.
All with applications in MS Excel.
Location and time
100% virtual, self paced course.
Oppimateriaali ja suositeltava kirjallisuus
Video lectures and tutorials
PowerPoint slides
MS Excel applications
Literature:
Statistics for Managers using MS Excel, Global Edition, 8/E, David M. Levine, David F Stephan, Kathryn A. Szabat, 2018
Data Analysis with SPSS: A First Course in Applied Statistics (4th Edition) Stephen A. Sweet, Karen Grace-Martin, 2012
Teaching methods
100% virtual course. Distant learning.
Introductory meeting, video lectures and tutorials, homework exercises and assignments.
Exam schedules
Assignments or/and projects. Deadlines to be announced at the beginning of the course.
Vaihtoehtoiset suoritustavat
No
Student workload
Video lectures 30h, virtual study 15h, assignments 15h, independent study 15h.
Content scheduling
Probability, Discrete Probability Distributions, Continuous Distributions, Simple Linear Regression, Introduction to Multiple Regression, Multiple Regression, Model Building, Time-Series Forecasting, A Roadmap for Analyzing Data, Statistical Applications in Quality Management, Decision Making.
All with applications in MS Excel.
Further information
Exchange students: 20 places (included in the total capacity)
Open UAS: 5 (included in the total capacity)
Evaluation scale
0-5
Arviointikriteerit, tyydyttävä (1-2)
Assignments 100%:
- Sufficient (1) - The student shows only a sufficient understanding of the subject and of relevant theories and methods and fails to show a convincing ability to apply the knowledge to real life situation nor to communicate the concepts in an effective manner.
- Satisfactory (2) - The students knowledge covers restricted part of concepts and theories related to the subject and has deficiencies in showing the ability to apply them in assignments. Communication skills need improvement.
JAMK Competences:
1. Learning to learn-
You develop critical and analytical mindset that helps you to study and review existing knowledge in the light of relevant learning resources and learning methods; incentivizes you to acquire new knowledge; and develops your intellectual capabilities to seek conclusions and draw inferences in various contexts.
To achieve this competence, you will:
- learn to formulate relevant questions and seek information,
- review relevant theoretical, and empirical literature to comprehend diverse perspectives and evaluate, and interpret arguments and counter-arguments,
- understand new developments in your field of study and make informed decisions based thereon.
- acquire the researcher’s mindset to problematize, explore and understand real-life phenomena especially in the academic track system.
2. Proactive development-
You develop solutions in the light of current as well as anticipated situations and challenges in business by applying knowledge, critical reasoning and analytical skills. You ensure that these solutions are feasible, relevant, creative, user-friendly, and sustainable as well as underline active cooperation amongst different actors.
To achieve this competence, you will:
- apply existing knowledge and utilize relevant research methods including digital technology in development projects,
- interpret new evidence in the light of existing body of knowledge, make comparisons and draw inferences,
- express your intellectual contribution through scientific or professional writings,
- understand utility, creativity, viability, scalability, and sustainability of new solutions.
IB competence:
7. Responsible international business management-
You develop your intellectual capabilities to seek conclusions and draw inferences in an international environment to become responsible manager. You develop creative and insightful solutions to solve complex business problems both in the present and the future with explicit emphasis on local and international standards of ethics, responsibility, and sustainability and implications on various stakeholders.
To achieve this competence, you will:
- study developments in your discipline in the international learning milieu and understand various aspects of responsible business management including global business trends and competitive landscape.
- derive and interpret new evidence and compare them with the existing body of knowledge in the global context to draw useful inferences,
- critically assess the implications of actions and decision of the international organizations.
- understand the impact of the of the actions and decisions on the community, in general, and specific stakeholders, in particular.
- understand core aspects of people management in the international business environment.
Arviointikriteerit, hyvä (3-4)
- Good (3) The students knowledge covers major parts of concepts and theories related to the subject. The student´s ability to apply the knowledge to assignments shows need for improvement, as well as there is room for improvement in oral and written communication.
- Very Good (4) - The student shows good knowledge of the subject fundamentals and concepts and is able to communicate these in an effective way.
JAMK Competences:
1. Learning to learn-
You develop critical and analytical mindset that helps you to study and review existing knowledge in the light of relevant learning resources and learning methods; incentivizes you to acquire new knowledge; and develops your intellectual capabilities to seek conclusions and draw inferences in various contexts.
To achieve this competence, you will:
- learn to formulate relevant questions and seek information,
- review relevant theoretical, and empirical literature to comprehend diverse perspectives and evaluate, and interpret arguments and counter-arguments,
- understand new developments in your field of study and make informed decisions based thereon.
- acquire the researcher’s mindset to problematize, explore and understand real-life phenomena especially in the academic track system.
2. Proactive development-
You develop solutions in the light of current as well as anticipated situations and challenges in business by applying knowledge, critical reasoning and analytical skills. You ensure that these solutions are feasible, relevant, creative, user-friendly, and sustainable as well as underline active cooperation amongst different actors.
To achieve this competence, you will:
- apply existing knowledge and utilize relevant research methods including digital technology in development projects,
- interpret new evidence in the light of existing body of knowledge, make comparisons and draw inferences,
- express your intellectual contribution through scientific or professional writings,
- understand utility, creativity, viability, scalability, and sustainability of new solutions.
IB competence:
7. Responsible international business management-
You develop your intellectual capabilities to seek conclusions and draw inferences in an international environment to become responsible manager. You develop creative and insightful solutions to solve complex business problems both in the present and the future with explicit emphasis on local and international standards of ethics, responsibility, and sustainability and implications on various stakeholders.
To achieve this competence, you will:
- study developments in your discipline in the international learning milieu and understand various aspects of responsible business management including global business trends and competitive landscape.
- derive and interpret new evidence and compare them with the existing body of knowledge in the global context to draw useful inferences,
- critically assess the implications of actions and decision of the international organizations.
- understand the impact of the of the actions and decisions on the community, in general, and specific stakeholders, in particular.
- understand core aspects of people management in the international business environment.
Assessment criteria, excellent (5)
- Excellent (5) - The student shows exceptional theoretical knowledge of fundamentals of the subject. The student demonstrates the ability to apply the knowledge to assignments and presentations with excellent written and oral communications skills.
JAMK Competences:
1. Learning to learn-
You develop critical and analytical mindset that helps you to study and review existing knowledge in the light of relevant learning resources and learning methods; incentivizes you to acquire new knowledge; and develops your intellectual capabilities to seek conclusions and draw inferences in various contexts.
To achieve this competence, you will:
- learn to formulate relevant questions and seek information,
- review relevant theoretical, and empirical literature to comprehend diverse perspectives and evaluate, and interpret arguments and counter-arguments,
- understand new developments in your field of study and make informed decisions based thereon.
- acquire the researcher’s mindset to problematize, explore and understand real-life phenomena especially in the academic track system.
2. Proactive development-
You develop solutions in the light of current as well as anticipated situations and challenges in business by applying knowledge, critical reasoning and analytical skills. You ensure that these solutions are feasible, relevant, creative, user-friendly, and sustainable as well as underline active cooperation amongst different actors.
To achieve this competence, you will:
- apply existing knowledge and utilize relevant research methods including digital technology in development projects,
- interpret new evidence in the light of existing body of knowledge, make comparisons and draw inferences,
- express your intellectual contribution through scientific or professional writings,
- understand utility, creativity, viability, scalability, and sustainability of new solutions.
IB competence:
7. Responsible international business management-
You develop your intellectual capabilities to seek conclusions and draw inferences in an international environment to become responsible manager. You develop creative and insightful solutions to solve complex business problems both in the present and the future with explicit emphasis on local and international standards of ethics, responsibility, and sustainability and implications on various stakeholders.
To achieve this competence, you will:
- study developments in your discipline in the international learning milieu and understand various aspects of responsible business management including global business trends and competitive landscape.
- derive and interpret new evidence and compare them with the existing body of knowledge in the global context to draw useful inferences,
- critically assess the implications of actions and decision of the international organizations.
- understand the impact of the of the actions and decisions on the community, in general, and specific stakeholders, in particular.
- understand core aspects of people management in the international business environment.
Assessment criteria, approved/failed
The general criteria of the competences that the Bachelor's Degrees awarded by Finnish Universities of Applied Sciences provide can be found on JAMK's web pages (http://www.jamk.fi/english/forstudents/studyguide). The learning outcomes of individual courses are assessed in relation to the objectives of the course concerned. Assessment is based on knowledge, skills and competence in accordance with the National and European Qualifications Framework, level 6. Grades are from 0 to 5.
Qualifications
Statistics for Managers using MS Excel, part 1