Lecturer(s)
|
-
Olšan Pavel, Ing. Mgr. Ph.D.
-
Havelka Zbyněk, Ing. 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.
|