K1AD1_13 Data Analysis Seminar

Faculty of Pharmacy
Spring 2025
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: k (colloquium).
In-person direct teaching
Teacher(s)
Mgr. Sylvie Pavloková, Ph.D. (seminar tutor)
Guaranteed by
Mgr. Sylvie Pavloková, Ph.D.
Department of Pharmaceutical Technology – Departments – Faculty of Pharmacy
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
The subject includes an introduction to MS Excel and basic data analysis methods focusing on the correct interpretation. In teaching, emphasis is placed on student activity, the creativity of data processing with an individual approach, and group discussion. The course also aims to strengthen the competencies related to logical reasoning and the correct and attractive presentation of the acquired knowledge.
Learning outcomes
After completing the course, the student will be able to:
understand the basic menu of MS Excel functions
process experimental data using appropriate organizational, computational and visualization methods
present, interpret, and defend data analysis outputs
Syllabus
  • Writing quantities and units, calculating and writing the result, rounding, basics of typography.
  • Introduction to the spreadsheet editor MS Excel.
  • Data collection and organization.
  • Data sorting and filtering, conditional formatting.
  • Basic descriptive statistics.
  • Basic types of data visualization.
  • Basic functions.
  • Pivot tables.
  • Formatting of graphic outputs.
  • Linear regression and calibration.
  • Analysis of real data: selection of suitable methods of data presentation, interpretation.
  • Processing and presentation of own data.
Literature
    recommended literature
  • PAVLÍK, Tomáš and Ladislav DUŠEK. Biostatistika (Biostatistics). 1st ed. Brno: Akademické nakladatelství CERM, s.r.o Brno, 2012, 131 pp. ISBN 978-80-7204-782-6. info
  • MELOUN, Milan and Jiří MILITKÝ. Kompendium statistického zpracování dat. Vyd. 3., V nakl. Karolinum 1. Praha: Karolinum, 2012, 982 s. ISBN 9788024621968. info
  • BARILLA, Jiří and Pavel SIMR. Microsoft Excel pro techniky a inženýry. Vyd. 1. Brno: Computer Press, 2008, 366 s. ISBN 9788025124215. info
Teaching methods
Seminars. PC exercises. Individual data processing with the subsequent active presentation of outputs.
Assessment methods
Colloquium. Individual data processing in the form of a report with the subsequent active presentation of outputs at the end of the semester and participation in the following group discussion. The purpose is to verify understanding of the subject matter, the ability to apply the knowledge gained in a similar area. Participation in seminars is mandatory; absence is permitted according to MU study and examination regulations.
Language of instruction
Czech
  • Permalink: https://is.muni.cz/course/pharm/spring2025/K1AD1_13