|
|
Main menu for Browse IS/STAG
Course info
KVD / ICTP
:
Course description
Department/Unit / Abbreviation
|
KVD
/
ICTP
|
Academic Year
|
2023/2024
|
Academic Year
|
2023/2024
|
Title
|
ICT for helping professions
|
Form of course completion
|
Pre-Exam Credit
|
Form of course completion
|
Pre-Exam Credit
|
Accredited / Credits
|
Yes,
2
Cred.
|
Type of completion
|
Combined
|
Type of completion
|
Combined
|
Time requirements
|
Seminar
2
[Hours/Week]
|
Course credit prior to examination
|
No
|
Course credit prior to examination
|
No
|
Automatic acceptance of credit before examination
|
No
|
Included in study average
|
NO
|
Language of instruction
|
Czech
|
Occ/max
|
|
|
|
Automatic acceptance of credit before examination
|
No
|
Summer semester
|
34 / -
|
24 / -
|
0 / -
|
Included in study average
|
NO
|
Winter semester
|
0 / -
|
0 / -
|
0 / -
|
Repeated registration
|
NO
|
Repeated registration
|
NO
|
Timetable
|
Yes
|
Semester taught
|
Winter + Summer
|
Semester taught
|
Winter + Summer
|
Minimum (B + C) students
|
not determined
|
Optional course |
Yes
|
Optional course
|
Yes
|
Language of instruction
|
Czech
|
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:
|
The aim of the course is to introduce students to data processing using digital technologies for assisting professions.
|
Requirements on student
|
Active participation in the seminar in solving practical examples that can be used in teaching different educational areas.
Fulfillment of practical tests.
|
Content
|
File formats of spreadsheet data.
Import and export of spreadsheet data.
Forms and their creation with a direct link to spreadsheets and calculators.
Options and ways of displaying, formatting, and conditional formatting of spreadsheet data.
Sort, filter, and table data summaries.
Addressing, counting operations, formulas, functions.
Table data analysis.
Graphs and representations of table data,
Operations with text values, search operations, and work with value generation.
PivotTables.
Work with industry databases.
|
Activities
|
|
Fields of study
|
|
Guarantors and lecturers
|
|
Literature
|
-
Basic:
LAURENČÍK, Marek. Excel - pokročilé nástroje: funkce, marka, databáze, kontingenční tabulky, prezentace, příklady. Praha, 2016. ISBN 978-80-247-5570-0.
-
Recommended:
Calc Guide: Work with Spreadsheets
-
Recommended:
Holzner, S. a N. Holzner. Google Docs 4 everyone. Indianapolis, 2009. ISBN 07-897-3936-4.
-
Recommended:
Navrátil, P. a M. Jiříček. OpenOffice.org Calc. Kralice na Hané: Computer Media, 2007. ISBN 978-80-86686-74-5.
-
Recommended:
OČENÁŠEK, Vladimír et al. Řešené příklady pro MS Excel 2013: podle konceptu European Computer Driving Licence - Advanced (profesionální uživatelské znalosti a dovednosti). Praha, 2015. ISBN 978-80-87994-55-9.
-
Recommended:
Pecinovský, Josef. 333 tipů a triků pro Microsoft Excel 2013 : [sbírka nejužitečnějších postupů a řešení]. 1. vyd. Brno : Computer Press, 2014. ISBN 978-80-251-4130-4.
-
On-line library catalogues
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Preparation for comprehensive test (10-40)
|
34
|
Contact hours
|
26
|
Total
|
60
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
explain basic concepts related to creating tables on a computer. |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
create and manipulate folders and files. |
perform basic edits in the spreadsheet. |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
use digital technologies in the field of data management at least at the basic level according to the DigComp 2.1 framework. |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
explain the principles used to retrieve, view, organize, format, analyze, represent and store table data in one commercial and several freely available program tools. |
Skills - skills resulting from the course: |
to process data efficiently using program tools called spreadsheets. |
to verify the principles of table data processing on practical examples, which will enable them to acquire the working methods leading to the effective use of that type of software in the field of study of the field of study or branch combination and subsequently in the teaching practice |
use the supported modules and functions of the selected spreadsheet program to find the optimal solution to partial problems arising from the topic being discussed |
Competences - competences resulting from the course: |
N/A |
N/A |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Test |
Continuous assessment |
Skills - skills achieved by taking this course are verified by the following means: |
Test |
Skills demonstration during practicum |
Continuous assessment |
Competences - competence achieved by taking this course are verified by the following means: |
Test |
Skills demonstration during practicum |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Seminar |
Multimedia supported teaching |
Skills - the following training methods are used to achieve the required skills: |
Skills demonstration |
Competences - the following training methods are used to achieve the required competences: |
Task-based study method |
|
|
|
|