Course in Computer Technology - EDKAJ003

• Title: Course in Computer Technology
• Guaranteed by: Department of science and research (14-260)
• Faculty: Faculty of Medicine in Pilsen
• Actual: from 2022
• Semester: summer
• Points: 0
• E-Credits: 0
• Examination process: summer s.:
• Hours per week, examination: summer s.:0/0, C [HT]
• Capacity: unknown / unknown (unknown)
• Min. number of students: unlimited
• 4EU+: no
• Virtual mobility / capacity: no
• State of the course: taught
• Language: English
• Teaching methods: full-time
• Teaching methods: full-time
• Note: course is intended for doctoral students only
• Guarantor: Mgr. Martin Navrátil

Annotation

Last update: Mgr. Barbora Stachová (07.10.2022)

Introduction to computer typography:
- Text editors, division
- Basic types of fonts and their usage
- Computer security of font, font installation
- Typesetting rules
- Correction of typography mistakes in MS Word

MS Word
- Styles and their usage
- Creation of automatic table of contents
- Headers and footers, foot-notes
- Paging, sections
- Adding graphics into text document – alignment of objects, text-wrapping options
- Tables – creating, formatting
- Bulk messages – preparation for printing or email

MS Excel
- Data formats
- Entering formulas
- Using functions
- Creation and modification of graphs
- Formatting of cells on a worksheet
- Usage of particular functions, e.g. text, logical and statistical functions, etc.
- Grouping and other tools for group data processing
- Contingency tables

MS Excel – descriptive statistics
- Statistics
- Character frequency
- Central tendency
- Characteristics of variability
- COUNTIF and AVERAGEIF functions
- MS Excel add-on – Descriptive statistics
- SUBTOTAL function
- Database in MS Excel – principle, filtering entries
- Database function
- Array formulas
- On-line forms

Risks and safety when using Internet
- E-mail communication
- Social networks – risks
- Protection of PC and other devices
- Safe data deletion
- Copyright Act and materials on the Internet