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 |
|
||
Last update: Mgr. Barbora Stachová (06.05.2024)
Study materials in Moodle application Internet sources: http://www.microsoft.cz Navrátil Martin, Petr Míka: Cloud computing |
|
||
Last update: Mgr. Barbora Stachová (06.05.2024)
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) |