Bi3560 Advanced data processing in Excel

Faculty of Science
Autumn 2022
Extent and Intensity
0/2/0. 2 credit(s). Type of Completion: z (credit).
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
Tue 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.
fields of study / plans the course is directly associated with
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 bilogy. 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
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2023, Autumn 2024.
  • Enrolment Statistics (Autumn 2022, recent)
  • Permalink: https://is.muni.cz/course/sci/autumn2022/Bi3560