Course: Informatics

« Back
Course title Informatics
Course code KZT/INF
Organizational form of instruction Lesson
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 3
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)
  • Olšan Pavel, Mgr. Ph.D.
  • Havelka Zbyněk, Mgr. Ph.D.
Course content
1 - Introduction, basic terms 2 - Informatics, information and data 3- PC technical stuff 4 - additional devices 5 - communication and webs 6 - operational systems 7 - Internet, email, WWW 8 - text editors and processors, typographic rules 9 - 10 formatting of a document, styles, templates 11 - charts 12 - functions, charts, pivot tables 13 - join of office applications 14 - HTML, WWW principles

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming)
  • Preparation for classes - 10 hours per semester
  • Semestral paper - 20 hours per semester
  • Preparation for exam - 25 hours per semester
  • Preparation for credit - 15 hours per semester
  • Class attendance - 28 hours per semester
Learning outcomes
Informatics, information and data. Visual interface of Windows NT. Internet, Email and WWW. Basic text editors, basic typographic rules. Introduction into Word, basics of work with the text. Working with objects at Word, formatting of a document, styles and charts. A chart and its options. Introduction to Excel, the philosophy of working in Excel, basics operations, functions, charts and formatting. Work with lists, sorting, automatic filters, summaries, pivot tables. MS Office- join of applications (OLE and DDE). HTML and making them at Word. Antivirus and compression programs.
The student is able to apply the knowledge, received during the study, specified in the part: Content of the syllabus.
Prerequisites
basic knowledge of IT

Assessment methods and criteria
Test

Participation of a student at seminars and a seminar paper.
Recommended literature
  • Brož, M. Microsoft Excel: Vzorce, funkce a výpočty. COMPUTER PRESS, 2011. ISBN 978-80-251-3267-8.
  • PECINOVSKÝ, J. Office 2007 - podrobný průvodce. Grada, 2007.
  • PECINOVSKÝ, J. OpenOffice.org 2.0 - kompletní průvodce. Grada, 2006.
  • PIERCE, J. a kol. Mistrovství v Microsoft Office 2007. Computer Press, 2008.
  • TYSON, Herb. Word 2010 Bible. Wiley, 2010. ISBN 978-0470591840.
  • Walkenbach, John. Excel 2010 Bible. Wiley, 2010. ISBN 978-0470474877.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Agriculture Study plan (Version): Agricultural and handling technology: trade, service and services (2016) Category: Agriculture and forestry 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Agriculture Study plan (Version): Agricultural and handling technology: trade, service and services (2016) Category: Agriculture and forestry 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Agriculture Study plan (Version): Agricultural and handling technology: trade, service and services (2016) Category: Agriculture and forestry 2 Recommended year of study:2, Recommended semester: Winter