Charles Explorer logo
🇬🇧

Course in Computer Technology

Class at Faculty of Medicine in Pilsen |
EDKAJ003

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