|
|
Main menu for Browse IS/STAG
Course info
KPV / PVT
:
Course description
Department/Unit / Abbreviation
|
KPV
/
PVT
|
Academic Year
|
2023/2024
|
Academic Year
|
2023/2024
|
Title
|
Computer Skills 1
|
Form of course completion
|
Pre-Exam Credit
|
Form of course completion
|
Pre-Exam Credit
|
Accredited / Credits
|
Yes,
3
Cred.
|
Type of completion
|
-
|
Type of completion
|
-
|
Time requirements
|
Tutorial
3
[Hours/Week]
|
Course credit prior to examination
|
No
|
Course credit prior to examination
|
No
|
Automatic acceptance of credit before examination
|
Yes in the case of a previous evaluation 4 nebo nic.
|
Included in study average
|
NO
|
Language of instruction
|
Czech, English
|
Occ/max
|
|
|
|
Automatic acceptance of credit before examination
|
Yes in the case of a previous evaluation 4 nebo nic.
|
Summer semester
|
0 / -
|
0 / -
|
0 / -
|
Included in study average
|
NO
|
Winter semester
|
37 / -
|
0 / -
|
173 / -
|
Repeated registration
|
NO
|
Repeated registration
|
NO
|
Timetable
|
Yes
|
Semester taught
|
Winter semester
|
Semester taught
|
Winter semester
|
Minimum (B + C) students
|
10
|
Optional course |
Yes
|
Optional course
|
Yes
|
Language of instruction
|
Czech, English
|
Internship duration
|
0
|
No. of hours of on-premise lessons |
|
Evaluation scale |
S|N |
Periodicity |
každý rok
|
Periodicita upřesnění |
|
Fundamental theoretical course |
No
|
Fundamental course |
No
|
Fundamental theoretical course |
No
|
Evaluation scale |
S|N |
Substituted course
|
None
|
Preclusive courses
|
N/A
|
Prerequisite courses
|
N/A
|
Informally recommended courses
|
N/A
|
Courses depending on this Course
|
N/A
|
Histogram of students' grades over the years:
Graphic PNG
,
XLS
|
Course objectives:
|
Aims are to equip the student with basic knowledge of working with office packages. Emphasis is placed on working with technical documentation (e.g. form of semestral work, automation of activities), calculations using tabular processors (e.g. mathematical calculations, graphs) and creating a presenting results (e.g. creating a presentation).
|
Requirements on student
|
A student has to complete a project using office productivity software to obtain credits in this course. The project contains a text part processed in the text editor and a calculation part processed using spreadsheet according to the specific task. The project is completed with the presentation of the results using the presentation software.
|
Content
|
The course is focused on a practical processing of a technical documents, calculations using a spreadsheet and creating the presentation containing processed results. The MS Office apllications (Word, Excel and Powerpoint) is used in the course.
1. Organization of the course
2. Tasks in MS Word (styles - creation, editing, copying)
3. Tasks in MS Word (fields, building blocks, galleries, equations, cross-references, headers - linking with style, footer ...)
4. Tasks in MS Word (extraction of images into folders, sections, contents, sources ...) + consultation of individual task processed by MS Word
5. Tasks in MS Excel (MS Excel functionalities, series, custom lists, relative and absolute addressing, cell format)
6. Tasks in MS Excel (naming of a range, sheets, reference, formatting using condition)
7. Tasks in MS Excel (table style, data import, charts)
8. Tasks in MS Excel (operators, processing an examples) + consulting of an individual task processed by MS Excel
9. Tasks in MS PowerPoint (templates, fields, smart art, theme, layout)
10. Tasks in MS PowerPoint (animation, grouping and separating of objects, assigning of action to an object)
11. Tasks in MS PowerPoint (slide layout, processing examples) + consulting of an individual task in MS PowerPoint
12. Presentation of semester work
13. Presentation of semester work
|
Activities
|
|
Fields of study
|
Studentům jsou k dispozici studijní materiály umístěné ve vytvořeném týmu v rámci aplikace MS Teams. Tyto materiály jsou následně využity pro osvojení teoretických a praktických poznatků využitelných při řešení příkladů realizovaných během cvičení.
|
Guarantors and lecturers
|
-
Guarantors:
Doc. Ing. Pavel Raška, Ph.D. (100%),
-
Tutorial lecturer:
Ing. Miroslav Bednář (100%),
Ing. Jitka Bláhová (100%),
Ing. Tomáš Broum, Ph.D. (100%),
Doc. Ing. Milan Edl, Ph.D. (25%),
Doc. Ing. Petr Hořejší, Ph.D. (25%),
Ing. Ilona Kačerová, Ph.D. (100%),
Ing. Matěj Krňoul (100%),
Ing. Bc. Miroslav Malaga, Ph.D. (100%),
Doc. Ing. Pavel Raška, Ph.D. (50%),
Ing. Filip Rybnikár (100%),
Ing. Lukáš Veszprémi (100%),
Ing. David Ženíšek (100%),
|
Literature
|
-
Basic:
Navarrů Miroslav. Excel 2019. Grada, 2019. ISBN 978-80-247-2026-5.
-
Basic:
Karel Klatovský. Powerpoint 2016 nejen pro školy. Computer Media, 2016. ISBN 978-80-7402-251-7.
-
Basic:
Karel Klatovský. WORD 2016 nejen pro školy. Computer Media, 2016. ISBN 978-80-7402-249-4.
-
Extending:
Pecinovský Josef, Pecinovský Rudolf. Office 2019 - Průvodce uživatele. Grada, 2019. ISBN 978-80-247-2303-7.
-
Recommended:
Pecinovský, Josef; Pecinovský, Rudolf. Excel 2010 : podrobný průvodce. 1. vyd. Praha : Grada, 2010. ISBN 978-80-247-3496-5.
-
Recommended:
Klatovský, Karel. Microsoft PowerPoint 2010 nejen pro školy. Vyd. 1. Kralice na Hané : Computer Media, 2010. ISBN 978-80-7402-077-3.
-
Recommended:
Pírková, Kateřina. Microsoft Word 2010 : podrobná uživatelská příručka. Vyd. 1. Brno : Computer Press, 2010. ISBN 978-80-251-3033-9.
-
On-line library catalogues
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Contact hours
|
39
|
Individual project (40)
|
40
|
Total
|
79
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
to know the basic operations in the operating system |
to know the basics of working with the Internet |
to know the basic functionality of the computer |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
have basic operating system skills |
have basic internet skills |
have basic PC skills |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
N/A |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
to know the basic functionality of MS Word |
to know the basic functionality of MS Excel |
to know the basic functionality of MS Powerpoint |
describe a technical problem using the office productivity software |
Skills - skills resulting from the course: |
work with the office productivity software |
prepare a presentation |
process a larger-scale document |
Competences - competences resulting from the course: |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Continuous assessment |
Skills - skills achieved by taking this course are verified by the following means: |
Seminar work |
Individual presentation at a seminar |
Competences - competence achieved by taking this course are verified by the following means: |
Seminar work |
Individual presentation at a seminar |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Lecture with visual aids |
E-learning |
Multimedia supported teaching |
Students' portfolio |
Discussion |
Interactive lecture |
Self-study of literature |
One-to-One tutorial |
Individual study |
Collaborative instruction |
Skills - the following training methods are used to achieve the required skills: |
Practicum |
Skills demonstration |
Interactive lecture |
Students' portfolio |
E-learning |
Lecture with visual aids |
Multimedia supported teaching |
Task-based study method |
Individual study |
Self-study of literature |
One-to-One tutorial |
Competences - the following training methods are used to achieve the required competences: |
Task-based study method |
Individual study |
E-learning |
Self-study of literature |
Multimedia supported teaching |
|
|
|
|