Statistics for Managers using MS Excel, part 1 (online)Laajuus (5 cr)
Code: HBIB0042
Credits
5 op
Teaching language
- English
Responsible person
- Marcin Topolewski
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.
Qualifications
-
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.
Enrollment
01.08.2023 - 24.08.2023
Timing
28.08.2023 - 20.05.2024
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
-
HBI23VSBachelor's Degree Programme in International Business, vaihto-opiskelu/Exchange studies
-
ZJK24KHKorkeakoulujen välinen yhteistyö, LITA
-
HBI21S1Degree Programme in International Business
-
ZJA23SHAvoin amk, lita
-
ZJA24KHAvoin AMK, lita
-
HBI22S1Degree Programme in International Business
-
ZJK23SHKorkeakoulujen välinen yhteistyö, LITA
-
ZJA23SHNO2Avoin amk, IB, nonstop 2, verkko
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 places (included in the total capacity)
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
-
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
-
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
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
-
HBI20S1Bachelor's Degree Programme in International Business
-
HBI22VKBachelor's Degree Programme in International Business, vaihto-opiskelu/Exchange studies
-
ZJA22KHAvoin 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 places (included in the total capacity)
Open UAS: 5 (included in the total capacity)
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
-