How to use Excel for research work (3 cr)
Code: LT00BK81-3006
General information
Enrollment
03.06.2024 - 23.08.2024
Timing
02.09.2024 - 30.11.2024
Credits
3 op
Virtual proportion (cr)
3 op
Teaching languages
- Finnish
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.)
Education groups
- Open UAS (Doesn't apply to degree student)
- Cross studies
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)
Evaluation scale
1-5
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.