Information Technology
1755-F2-TECHI-J
The aim of the course is to familiarize students with basic features of MS Excel which can be used for the analysis and visual representation of biomedical data: using formulae, Excel built-in mathematical, statistical, logical and text functions and creating and modifying charts. During the tutorials and lectures students are also familiarized with the basic concepts related to databases on the example of MS Access database.
Total student workload
1. Obligatory hours realized with the teacher participation:
- laboratories participation (including the analysis of case studies, clinical and randomized test results) – 30 hours,
- consultations participation, including scientific and research consultations – 2 hours,
Total obligatory hours realized with the teacher participation: 32 hours, which corresponds to 1.28 ECTS point.
2. Student workload balance:
- laboratories participation (including the analysis of case studies, clinical and randomized test results) – 30 hours,
- consultations participation, including scientific and research consultations – 2 hours, ,
- preparation for laboratories – 8 hours,
- preparation for test – 10 hours.
A total work amount: 50 hours, which corresponds to 2.00 ECTS point.
3. Workload related to conducting research:
- not applicable
4. Time required for the preparation and participation in evaluating process:
- preparation for test – 10 hours,
- participation in evaluating process- 2 hours
Total time required for the preparation and participation in evaluating process: 12 hours, which corresponds to 0.48 ECTS point.
Learning outcomes - knowledge
The graduate knows and understands:
W1: basic rules for entering data into Excel, creating formulas, addressing cells, creating cell names and ranges of cells - K_B.W26
W2: basic rules for formatting text in Word software: paragraph formatting, formatting using styles, chapter numbering, inserting headers and footers, cross-references, table of contents - K_B.W26
W3: functions of MS Access system objects such as tables, queries, forms and reports - K_B.W27
Learning outcomes - skills
The graduate is able to:
U1. enter data into the MS Excel spreadsheet - K_B.U12
U2: construct formulas in MS Excel (including array formulas), address cells, create cell names, create data series in MS Excel sheets and format sheet cells - K_B.U12
U3. use selected mathematical, statistical, date and time, textual and logical functions of the MS Excel package for the presentation and analysis of biomedical data - K_B.U12
U4. select and use the appropriate form of graphical data presentation - K_B.U12
U5. create a simple database project in MS Access - K_B.U12
U6. carry out text formatting in Word software: paragraph formatting, formatting using styles, chapter numbering, inserting headers and footers, links, table of contents - K_B.U12
Learning outcomes - social competencies
Student:
K1: draw conclusions based on their measurements or observation- K_B.K8
Teaching methods
Lectures:
• not applicable
Laboratory tutorials:
• computer laboratory
• classical problem-oriented method
• discussion
Seminars:
• not applicable
Exploratory teaching methods
- practical
- project work
Type of course
compulsory course
Prerequisites
Basics of Information Technology at secondary school level
Course coordinators
Assessment criteria
Credit conditions for the course and assessment criteria:
Laboratories:
Tutorials – practical performance of tutorials and test results.
Absence on lectures and laboratory classes can be worked off by performing the task designated by teacher.
In the case of tests obtained results are converted to the grades according to the following scale:
Percent of points Grade
90-100% 5.0
80-89% 4.5
70-79% 4
60-69% 3.5
50-59% 3
0-49% 2
Practical placement
Additional information
Additional information (registration calendar, class conductors,
localization and schedules of classes), might be available in the USOSweb system: