|
Lecturer(s)
|
-
Friebel Ludvík, Ing. Ph.D.
-
Beránek Ladislav, prof. Ing. CSc., MBA
-
Remeš Radim, Mgr. Ph.D.
|
|
Course content
|
Lectures: 1 - introduction to the course, assignments; basic terminology 2 - hardware - platforms 3 - hardware - PC 4 - operating systems 5 - network 6 - Internet 7 - software 8 - text processing 9 - advanced text processing 10 - introduction to spreadsheet processing 11 - spreadsheet processing - elementary data processing 12 - spreadsheet processing - solving managerial problems 13 - macros and modules Seminars: 1 - introduction to the course, assignments; basic terminology 2 - information and communication technology on the university network 3 - Internet services 4 - operating system services 5 - text processing 6 - advanced text processing 7 - spreadsheet environment 8 - formulas, addressing 9 - functions 10 - graphic expressions of results 11 - pivot tables and graphs 12 - optimisation in spreadsheets 13 - macros and modules
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Demonstration, E-learning
|
|
Learning outcomes
|
The course of Informatics has two main objectives. The first one is to introduce students to the basic terminology, and to obtain basic overview about information technology. The latter is focus on the basic skills in text processor and spreadsheet calculator. The seminars are specialised on the problems related to managerial area.
Students will understand the basic terminology and obtain skills for use of a text processor and spreadsheet calculator.
|
|
Prerequisites
|
The course has no prerequisities.
|
|
Assessment methods and criteria
|
Combined exam, Test
Credit Requirements: Obtaining at least 8 points out of 12 in two credit tests (each of them is worth a maximum of 6 points). Examination Requirements: Theoretical exam concerned with lectures. The final mark is based on the results of credit tests and a final examination.
|
|
Recommended literature
|
-
Curtis, F. D. Microsoft Excel 2010 Step by Step. Seatle: Microsoft Press, 2010. ISBN 0735626944.
-
Smart, M. Learn Excel 2007 Essential Skills with the Smart Method: Courseware Tutorial for Self-Instruction to Beginner and Intermediate Level. New York: The Smart Method Ltd., 2008. ISBN 0955459923.
-
Walkenbach, J. Excel 2010 Formulas. Boston: Wiley, 2010. ISBN 0470475366.
-
Wempen, F. Using Microsoft Office Word 2007. London: Que, 2007. ISBN 078973608X.
|