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 2023
• Semester: summer
• Points: 0
• E-Credits: 0
• Examination process: summer s.:
• Hours per week, examination: summer s.:0/6, C [HS]
• 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
• Note: course is intended for doctoral students only
• Guarantor: Mgr. Martin Navrátil

Annotation

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

Last update: Stachová Barbora, Mgr. (07.10.2022)

Literature

Study materials in Moodle application: https://moodle.lfp.cuni.cz/enrol/index.php?id=319
Internet sources:
http://www.microsoft.cz
Navrátil Martin, Petr Míka: Cloud computing <http://mefanet.lfp.cuni.cz/clanky.php?aid=509>. ISSN 1804-4409.

Last update: Stachová Barbora, Mgr. (25.06.2024)

Syllabus

MS Word 2010:styles, using styles - generating automatic content, headers and footers, notes, footnotes, pagination, sections, inserting graphic elements into a text document - alignment of objects, text wrapping, tables - creating, formatting, mass correspondence - preparing a mass letter for print or electronic mail, Spreadsheet calculator MS Excel 2010:data formats, inserting formulas, using functions, creating and editing charts, formatting, cells on a worksheet, use of specific functions e.g. text, logic, statistics etc., summaries etc. tools for bulk data processing, contingency tables)

Last update: Stachová Barbora, Mgr. (06.05.2024)