Lectures (topics): 1. History of computer technologies, basic elements, von Neumann diagram. 2. Computers - classification, parameters, modularity, personal computers. 3. Processors (RISC / CISC, features), internal memory (RAM / ROM, static / dynamic), cache function. 4. External PC memory (magnetic, optical, semiconductor). Principles, functions, utilization. 5. Communications in PC - signal transmissions, interface. 6. Selected I / O devices, imaging equipment, printing technology. 7. Acquisition and digitization of input multimedia data. 8. PC software, classification, licenses, methods of acquisition, utilization. 9. Fundamentals of computer communications, computer networks PAN, LAN, MAN, WAN, transmission media, wireless communication. 10. Communication protocols, elements of computer networks. Safety and protection of transmission networks. 11. Internet - characteristics and development, addressing, basic services, WWW, information retrieval. Intranet, Extranet. 12. Compatibility in ICT, Prospective ICT Technologies. 13. Smart technology for IoT, positioning systems - principles, utilization. 14. Security threats. Cyber protection and information security principles. Seminars (themes): 1. MS Excel: formatting, series, lock, comment, hyperlinks, formulas, graphs. 2. MS Excel: matrix formulas, cell area names, dynamic pivot table, histogram matrix formulas, and Analytical Tools add-in. 3. MS Excel: solving different types of tasks using Solver. 4. MS Excel: working with large lists, sorting and filtering them, pivot table. 5. MS Excel: Solution Search and Solver applied to production planning and transport task. 6. MS Word: styles, creation of large documents, partitions. 7. MS Word: multilevel chapters, insertion of charts, tables, equations, cross-reference, content.
|
-
BARILLA, J., P. SIMR a K. SÝKOROVÁ. Microsoft Excel 2016: podrobná uživatelská příručka. Brno, Computer Press, 2016. ISBN 978-80-251-4838-9.
-
LAUDON, K. C. a J. P. LAUDON. Management Information Systems: Managing the Digital Firm. London, Pearson Education, 2017. ISBN 978-01-346-3971-0.
-
MYŠKA, K. a M. MUNZAR. Základní hardware a software, operační systém. Hradec Králové, Gaudeamus, 2014. ISBN 978-80-7435-456-4.
-
NAVARRŮ, M. Excel 2016: podrobný průvodce uživatele. Praha, Grada Publishing, 2016. ISBN 978-80-271-0193-1.
-
PECINOVSKÝ, Josef a Rudolf PECINOVSKÝ. Office 2016: průvodce uživatele. Praha: Grada, 2016. ISBN 978-80-247-5691-2.
-
WHITE, R. a T. E. DOWNS. How Computers Work: The Evolution of Technology. Indianopolis, Que Publishing, 214. ISBN 978-07-897-4984-0.
|