Course: Processing of Experimental Data

» List of faculties » PRF » KEB
Course title Processing of Experimental Data
Course code KEB/ZEXD
Organizational form of instruction Seminary
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 3
Language of instruction Czech
Status of course Compulsory, Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Grúz Jiří, Mgr. Ph.D.
Course content
Principle of spreadsheets, summary of common software, data handling in Excel, formulas, absolute and relative cell references, functions and operators, conditional format, regression and statistical methods, t-test, heatmaps, calibration curve, multivariate analysis, cluster analysis, histograms, contingency tables, macros, graphs, data transfer among Word, Excel and PowerPoint, graphic filetypes, text processing in Word, tables.

Learning activities and teaching methods
Lecture
Learning outcomes
Principle of data handling in Excel. Basics of data processing.
Student should be able to (after attending the course): - evaluate data from biological experiments
Prerequisites
unspecified

Assessment methods and criteria
Student performance

80% fruitfulness on imposition
Recommended literature
  • Pecinovský, J. (2004). Excel 2002 - podrobný průvodce pokročilého uživatele. Grada Publishing.
  • Pecinovský, J. (2004). Excel 2002 - podrobný průvodce začínajícího uživatele. Grada Publishing.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Science Study plan (Version): Experimental Biology - Specialization in Experimental Biology of Plants (2021) Category: Biology courses 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Science Study plan (Version): Experimental Biology - Specialization in Experimental Biology (2021) Category: Biology courses 2 Recommended year of study:2, Recommended semester: Winter