Course: Fundamentals of Information Technologies

« Back
Course title Fundamentals of Information Technologies
Course code UCHTML/C605
Organizational form of instruction Lecture + Seminar
Level of course Bachelor
Year of study 2
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) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Chemical Technology Study plan (Version): Clinical Biology and Chemistry (2014) Category: Special and interdisciplinary fields 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Economy and Management of Chemical and Food Industry (2016) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Economy and Management of Chemical and Food Industry (2013) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Chemistry and Technical Chemistry (2013) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Clinical Biology and Chemistry (2016) Category: Special and interdisciplinary fields 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Inorganic Materials (2013) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Surface Protection of Building and Construction Materials (2016) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Graphic Arts and Printing Technology (2016) Category: Printing, working with paper, film and photography 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Chemistry and Technical Chemistry (2016) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Laboratory Assistant (2014) Category: Health service 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Inorganic Materials (2016) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Chemistry and Technical Chemistry (2015) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Environment Protection (2016) Category: Ecology and environmental protection 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Laboratory Assistant (2016) Category: Health service 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Economy and Management of Chemical and Food Industry (2014) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Graphic Arts and Printing Technology (2013) Category: Printing, working with paper, film and photography 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Clinical Biology and Chemistry (2013) Category: Special and interdisciplinary fields 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Laboratory Assistant (2015) Category: Health service 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Economy and Management of Chemical and Food Industry (2015) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Surface Protection of Building and Construction Materials (2014) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Graphic Arts and Printing Technology (2015) Category: Printing, working with paper, film and photography 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Inorganic Materials (2015) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Surface Protection of Building and Construction Materials (2015) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Environment Protection (2014) Category: Ecology and environmental protection 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Inorganic Materials (2014) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Clinical Biology and Chemistry (2015) Category: Special and interdisciplinary fields 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Laboratory Assistant (2013) Category: Health service 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Graphic Arts and Printing Technology (2014) Category: Printing, working with paper, film and photography 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Chemistry and Technical Chemistry (2014) Category: Engineering chemistry and chemistry of silicates 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Environment Protection (2015) Category: Ecology and environmental protection 1 Recommended year of study:1, Recommended semester: Winter
Faculty: Faculty of Chemical Technology Study plan (Version): Environment Protection (2013) Category: Ecology and environmental protection 1 Recommended year of study:1, Recommended semester: Winter