Statistics for Managers using MS Excel, part 1 (online) (5 cr)
Code: HBIB0042-3005
General information
Enrollment
01.08.2022 - 25.08.2022
Timing
29.08.2022 - 21.12.2022
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Unit
School of Business
Teaching languages
- English
Seats
0 - 50
Degree programmes
- Bachelor's Degree Programme in International Business
Teachers
- Marcin Topolewski
Groups
-
HBI21S1Degree Programme in International Business
-
HBI20S1Bachelor's Degree Programme in International Business
-
ZJA22SHAvoin AMK, lita
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.
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
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.
Materials
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.
Completion alternatives
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
Assessment criteria, satisfactory (1)
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.
Assessment criteria, good (3)
- 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.
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.
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
-