|
Lecturer(s)
|
-
Friebel Ludvík, Ing. Ph.D.
|
|
Course content
|
1. Basic terminology 2. Hardware - platforms 3. Operating systems 4. Network and internet 5. Software 6. Text processing - finalizing of the document 7. Text processing - automaticaly generatet texts (registers, lists, table of content, mail mergint) 8. Spreadsheet calculator - spreadsheet environment 9. Spreadsheet calculator - formulas, addressing 10. Spreadsheet calculator - functions 11. Spreadsheet calculator - graphic expressions of results 12. Spreadsheet calculator - pivot tables and graphs 13. Spreadsheet calculator - optimisation in spreadsheets 14. Spreadsheet calculator - macros and modules
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Demonstration, E-learning
- Semestral paper
- 25 hours per semester
- Class attendance
- 42 hours per semester
- Preparation for classes
- 28 hours per semester
- Preparation for credit
- 20 hours per semester
- Preparation for exam
- 25 hours per semester
|
|
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 task, homework is for 4 points, test us for 8 points. Examination Requirements: Theoretical exam concerned with lectures. The final mark is based on the results of credit works and a final examination. The course is supported with LMS Moodle.
|
|
Recommended literature
|
-
Frye, C. Microsoft Excel 2016 Step by Step. Redmond: Microsoft Press, 2016, 2016. ISBN 978-0-7356-9880-2.
-
Lambert, J. Microsoft Word 2016 Step By Step. Redmond: Microsoft Press, 2015, 2015. ISBN 978-0-7356-9777-5.
-
Walkenbach, J. Excel 2010 Formulas. Boston: Wiley, 2010. ISBN 0470475366.
|