PřF:Bi3560 Adv. data processing in Excel - Course Information
Bi3560 Advanced data processing in Excel
Faculty of ScienceAutumn 2024
- Extent and Intensity
- 0/2/0. 2 credit(s). Type of Completion: z (credit).
In-person direct teaching - Teacher(s)
- Mgr. Kateřina Kintrová, Ph.D. (seminar tutor)
- Guaranteed by
- Mgr. Kateřina Kintrová, Ph.D.
Department of Botany and Zoology – Biology Section – Faculty of Science
Contact Person: Mgr. Kateřina Kintrová, Ph.D.
Supplier department: Department of Botany and Zoology – Biology Section – Faculty of Science - Timetable
- Mon 14:00–15:50 B09/316
- Course Enrolment Limitations
- The course is only offered to the students of the study fields the course is directly associated with.
The capacity limit for the course is 36 student(s).
Current registration and enrolment status: enrolled: 36/36, only registered: 0/36 - fields of study / plans the course is directly associated with
- Biology with a view to Education (programme PřF, B-UCB) (2)
- Ecological and Evolutionary Biology (programme PřF, B-EKB)
- Course objectives
- To learn various tools in Excel, especially those facilitating a handling with data.
The course does not cover topics of statistical analyses of data. - Learning outcomes
- Student will learn:
- to arrange data to R-software format;
- to import data from other data-formats (e.g. txt);
- useful keyboard shortcuts;
- to insert formulas;
- conditional formatting;
- to create pivot tables;
- to create and modify graphs;
- and maybe more :) - Syllabus
- - to arrange data to R-software format;
- - to import data from other data-formats (e.g. txt);
- - useful keyboard shortcuts;
- - to insert formulas;
- - conditional formatting;
- - to create pivot tables;
- - to create and modify graphs;
- - and maybe more :)
- Teaching methods
- Practicing the skills on real datasets from biology. The course takes place in the computer classroom in Bohunice kampus.
- Assessment methods
- To perform required skills on new data table, for example to arrange data table, to insert formulas, to create pivot tables and to create graph.
- Language of instruction
- Czech
- Further Comments
- The course is taught annually.
- Enrolment Statistics (recent)
- Permalink: https://is.muni.cz/course/sci/autumn2024/Bi3560