Course: Fundamentals of Information Technologies

« Back
Course title Fundamentals of Information Technologies
Course code UCHTML/C605
Organizational form of instruction Lecture + Seminary
Level of course Bachelor
Year of study 1
Semester Winter
Number of ECTS credits 4
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Kořínek Tomáš, Ing.
  • Černý Michal, Ing. Ph.D.
  • Brunclík Tomáš, Ing. Ph.D.
  • Gojný Jan, Ing. Ph.D.
  • Schwarz Jiří, Ing. Ph.D.
  • Šindelář Martin, Ing.
  • Tomeš Milan, Ing.
Course content
Basics of operating system usage Word - introduction, typography, tables. Word - equations, drawing / pictures, styles, contents, index, cross-references, citations. Excel - introduction, formats, simple calculations. Excel - advanced calculations and creating graphs. Excel - import data, analytic tools. Excel - a practical example. Creation of the document. Powerpoint - introduction, creating presentation.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Skills training
Learning outcomes
Consolidate the knowledge of students in the use of computer technology, to familiarize them with advanced functions of office software, with selected specialized programs and services that they will be able to use both during their studyig as well as in their further work.
Student after completion of the course will be able to effectively create different types of technical documents with the most advanced instruments in compliance with the typographical conventions and principles to facilitate teamwork. Will be able to process experimental data in a spreadsheet editor, create a chart, perform calculations and solve equations.
Prerequisites
Basic skill with working on Personal Computer, basic knowledge of Microsoft Office 2007 software.

Assessment methods and criteria
Home assignment evaluation, Student performance assessment

To pass test at PC.
Recommended literature
  • Brož, Milan. Microsoft Excel : vzorce, funkce, výpočty. Brno: Computer Press, 2006. ISBN 80-251-1088-5.
  • Pierce, John. Mistrovství v Microsoft Office 2007. Brno: Computer Press, 2008. ISBN 978-80-251-2066-8.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Chemical Technology Clinical Biology and Chemistry (2014) Special and interdisciplinary fields 1 Winter
Faculty of Chemical Technology Economy and Management of Chemical and Food Industry (2016) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Economy and Management of Chemical and Food Industry (2013) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Chemistry and Technical Chemistry (2013) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Clinical Biology and Chemistry (2016) Special and interdisciplinary fields 1 Winter
Faculty of Chemical Technology Inorganic Materials (2013) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Surface Protection of Building and Construction Materials (2016) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Graphic Arts and Printing Technology (2016) Printing, working with paper, film and photography 2 Winter
Faculty of Chemical Technology Chemistry and Technical Chemistry (2016) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Laboratory Assistant (2014) Health service 1 Winter
Faculty of Chemical Technology Inorganic Materials (2016) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Chemistry and Technical Chemistry (2015) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Environment Protection (2016) Ecology and environmental protection 1 Winter
Faculty of Chemical Technology Laboratory Assistant (2016) Health service 1 Winter
Faculty of Chemical Technology Economy and Management of Chemical and Food Industry (2014) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Graphic Arts and Printing Technology (2013) Printing, working with paper, film and photography 2 Winter
Faculty of Chemical Technology Clinical Biology and Chemistry (2013) Special and interdisciplinary fields 1 Winter
Faculty of Chemical Technology Laboratory Assistant (2015) Health service 1 Winter
Faculty of Chemical Technology Economy and Management of Chemical and Food Industry (2015) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Surface Protection of Building and Construction Materials (2014) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Graphic Arts and Printing Technology (2015) Printing, working with paper, film and photography 2 Winter
Faculty of Chemical Technology Inorganic Materials (2015) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Surface Protection of Building and Construction Materials (2015) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Environment Protection (2014) Ecology and environmental protection 1 Winter
Faculty of Chemical Technology Inorganic Materials (2014) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Clinical Biology and Chemistry (2015) Special and interdisciplinary fields 1 Winter
Faculty of Chemical Technology Laboratory Assistant (2013) Health service 1 Winter
Faculty of Chemical Technology Graphic Arts and Printing Technology (2014) Printing, working with paper, film and photography 2 Winter
Faculty of Chemical Technology Chemistry and Technical Chemistry (2014) Engineering chemistry and chemistry of silicates 1 Winter
Faculty of Chemical Technology Environment Protection (2015) Ecology and environmental protection 1 Winter
Faculty of Chemical Technology Environment Protection (2013) Ecology and environmental protection 1 Winter