Technical University of Liberec
Study programmes & Course catalogue
Technical University of Liberec
Česky
Search
FAQ

Course: Basics of information technology

» List of faculties » FP » KIN
Course title Basics of information technology
Course code KIN/ZIT
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Summer
Number of ECTS credits 4
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements Course does not contain work placement
Recommended optional programme components None
Lecturer(s)
  • Semerádová Tereza, Mgr. Ph.D.
  • Skrbek Jan, doc. Ing. Dr.
  • Kubát David, Ing. Ph.D., Ing.Paed.IGIP
  • Nejedlová Dana, Ing. Ph.D.
Course content
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.

Learning activities and teaching methods
unspecified
Learning outcomes
The course introduces students to the basics of computer technology with a focus on individual PC components. Attention is also paid to the principles and technologies of data communications networks and to the services they enable. Students also get familiar with world-wide-web applications and services and ICT security issues. During the seminars, students acquire the advanced knowledge of the most widely used office software - Microsoft Excel and Word.

Prerequisites
unspecified

Assessment methods and criteria
unspecified
Credit requirements: A test consisting of data analysis using MS Excel. Exam: Written and oral examination
Recommended literature
  • 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.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Technical University of Liberec, date of update: 02.05.2024 23:50.