Siirry suoraan sisältöön

Statistics for Managers using MS Excel, part 1 (5 cr)

Code: HBIB0042-3002

General information


Enrollment

03.08.2020 - 30.08.2020

Timing

31.08.2020 - 18.12.2020

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Online learning

Unit

Liiketoimintayksikkö

Teaching languages

  • English

Degree programmes

  • Bachelor's Degree Programme in International Business (AMK)

Teachers

  • Marcin Topolewski
  • Marcin Topolewski

Groups

  • HBI18S1
    Degree Programme in International Business
  • HBI19S1
    Degree Programme in International Business
  • ZJA20SH
    Avoin AMK, lita
  • HBI20VS
    Degree Programme in International Business, vaihto-opiskelu/Exchange studies
  • HBI18K1
    Degree Programme in International Business

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.

Content

Data collection, organizing data, data presentation, descriptive statistics, exploratory data analysis, probability distributions, sampling distributions, confidence interval estimation, fundamentals of hypothesis testing: one sample tests, two-sample tests, analysis of variance, chi-square and nonparametric tests. 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

Data collection, organizing data, data presentation, descriptive statistics, exploratory data analysis, probability distributions, sampling distributions, confidence interval estimation, fundamentals of hypothesis testing: one sample tests, two-sample tests, analysis of variance, chi-square and nonparametric tests.
All with applications in MS Excel.

Further information

Exchange students 20
Avoin AMK (Open UAS) 5

Evaluation scale

0-5

Arviointikriteerit, tyydyttävä (1-2)

Assignments 90%, Written Report 10%.

- 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

-