Data Processing and Analysis in Microsoft Excel (SL_133)
About Study Course
Objective
To get acquainted with the capabilities of MS Excel for data processing, display, and analysis. Graduates of the course will acquire the basic skills and knowledge that will allow them to master more complex techniques individually.
Prerequisites
Secondary school background in mathematics and informatics.
Learning outcomes
After completion of this course, the student will demonstrate basic knowledge that allows:
* to recognise terminology used in statistics and basic methods used in different publications;
* to know MS Excel offered data processing tools;
* to know data processing method criterias;
* to correctly interpet the most important statistical indicators.
After completion of this course, the student will demonstrate skills:
* to input and edit data in computer program MS Excel;
* to prepare data for statistical analysis correctly;
* to choose appropriate data provessing methods, incl., are able to do statistical hypothesis testing;
* to statistically analyse research data using computer program MS Excel;
* to create tables and graphs in MS Excel programme with obtained results;
* to describe obtained research results correctly.
After completion of this course, students will be able to argument and make decisions about statistical data processing methods, use them to achieve research aims, using computer program MS Excel, practically use learned statistical basic methods to process research data.
Study course planning
| Study programme | Study semester | Program level | Study course category | Lecturers | Schedule |
|---|---|---|---|---|---|
| Elective courses, C-kursi | 1 | Free choice | Dina Barute |
| Study programme | Study semester | Program level | Study course category | Lecturers | Schedule |
|---|---|---|---|---|---|
| Elective courses, C-kursi | 2 | Free choice | Dina Barute |
