Course in Computer Technology - EDKAJ003
|
|
|
||
Last update: Mgr. Barbora Stachová (07.10.2022)
- 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 |