How to use Excel for research work (3cr)
Code: LT00BK81-3006
General information
- Enrollment
- 03.06.2024 - 23.08.2024
- Registration for the implementation has ended.
- Timing
- 02.09.2024 - 30.11.2024
- Implementation has ended.
- Number of ECTS credits allocated
- 3 cr
- Local portion
- 0 cr
- Virtual portion
- 3 cr
- Mode of delivery
- Distance learning
- Campus
- SeAMK Seinäjoki, Frami
- Teaching languages
- Finnish
- Seats
- 0 - 40
- Degree programmes
- Bachelor of Business Administration, Business Management
- Teachers
- Leo Sippola
- Scheduling groups
- Avoin AMK (Ei koske tutkinto-opiskelijaa) (Size: 3 . Open UAS : 3.)
- Ristiinopiskelu (Size: 0 . Open UAS : 0.)
- Small groups
- Open UAS (Doesn't apply to degree student)
- Cross studies
- Course
- LT00BK81
Evaluation scale
1-5
Objective
The student is able to use Excel, especially for various quantitative studies. The student learns to calculate different statistical indicators for the whole material and different groups. He/she is able to produce distributions of variables in tables and graphs. He/she learns to create cross-tabulations. The student is able to filter the data to get the desired summary of the variables. (He/she knows how to use Excel's Pivot function.) He/she gets an idea of the relationships of variables and how to look at their dependencies. He/she gets the basics in statistical testing.
Content
Excel basics, key figures and statistical concepts, one-dimensional distributions, two-dimensional distributions and statistical tests. (Everything is based on doing tasks)
Assessment criteria, satisfactory (1)
The student has passed the Excel tasks successfully, but she/he needs guidance to solve the tasks on time and completed correctly.
Assessment criteria, good (3)
The student has demonstrated mastery of Excel by completing tasks in a timely and careful manner.
Assessment criteria, excellent (5)
The student has demonstrated mastery of Excel by performing tasks independently and accurately. She/he knows how to apply Excel in many ways.