|
Lecturer(s)
|
-
Chytrý Vlastimil, doc. PhDr. Ph.D.
|
|
Course content
|
1st information, information technology, electronic information 2nd part of the personal computer, computer memory, input and output devices 3rd Basics of the operating system 4th file system, file management 5th Internet as an information and communication space, e-communication 6th World Wide Web, information retrieval and data mining 7th Creating and editing text documents in the modern text editor 8th Structured documents, citation standard references 9th format and content of cells, working with worksheets, workbooks, 10th Conditional Formatting, basic chart types (pie, bar / folded, Line, XY scatter) 11th Insert functions, Nesting, fast function 12th Logical Functions IF, COUNTIF; ROUND
|
|
Learning activities and teaching methods
|
unspecified, unspecified, unspecified, unspecified
- unspecified
- 28 hours per semester
|
|
Learning outcomes
|
The aim of the course is to attain a basic theoretical knowledge and practical skills in developing long structured text documents of the seminar thesis / diploma thesis type. Tools available in the common office packages (especially text editor, spreadsheet editor) and on-line / off-line resources will be used to develop the document and to check the content and formal correctness of the document. The achievement of practical integration of language, professional and digital knowledge and skills. Emphasis will be given to formal linguistic, stylistic, typographic and information correctness.
Students know how to use the digital technology effectively and at the contemporary level of knowledge when developing a structured learned text document of the seminar / qualification thesis type (a document with tables, graphs, pictures, index and a list of quoted literature). Within the UJEP, the student has a functional network access to EDUROAM network and to following online services: STAG, Moodle and the scientific library catalogue.
|
|
Prerequisites
|
1) A default knowledge and skills in information and communication technology at the level of the Czech Framework educational programme for grammar schools (RVP-G). 2) Students should have their own computer device (BYOD concept - notebook, tablet, smartphone etc.) that is already connected to the EDUROAM academic network, see the connection procedure at http://eduroam.ujep.cz/doku.php?id=cs:nastaveni. Computers in the classroom K139 are intended only for those who temporarily do not have their own equipment. 3) Students should have a functional access to the system STAG (online). Students are expected to verify in advance the functionality of their access following the instructions at http://stag.ujep.cz/, menu items "Access Data" and "Enter the system". 4) Students should have a functional access to the LMS Moodle (https://moodle.pf.ujep.cz/). Students are expected to verify in advance the functionality of their access following the instructions at https://moodle.pf.ujep.cz/login/index.php, menu item "Registration for students and course designer."
|
|
Assessment methods and criteria
|
unspecified
Active access, understanding subject matter and application practically.
|
|
Recommended literature
|
-
ČMEJRKOVÁ, S., DANEŠ, F., SVĚTLÁ, J. Jak napsat odborný text. Praha: Leda, 1999. ISBN 80-85927-69-1.
-
KOČIČKA, P. Praktická typografie.. Brno, 2000. ISBN 80-7226-385-4.
-
LAURENČÍK, M. Excel 2010, práce s databázemi a kontingenčními tabulkami, Vyd. 1. Praha, Grada Publishing a.s., 2011. 168 s. ISBN 978-80-247-3986-1.
-
LEIPERT, J., aj. S počítačem do Evropy. Brno : Computer Press, 2007.
-
NAVRÁTIL, P. S počítačem nejen k maturitě, 1. díl.. Kralice na Hané, 2013. ISBN 978-80-7402-152-7.
-
NAVRÁTIL, P. S počítačem nejen k maturitě, 2. díl.. Kralice na Hané, 2013. ISBN 978-80-7402-021-6.
-
Pecinovský, J. Excel v příkladech : řešené úlohy : podrobný průvodce. Praha 2001.
-
PECINOVSKÝ, J. MS Word 2007 Podrobný průvodce. Praha : Grada Publishing, 2007.
-
PECINOVSKÝ, J., PECINOVSKÝ, R. Office 2010. Praha, 2011.
-
PECINOVSKÝ, J., PECINOVSKÝ, R. Office 2010. Praha, 2011.
-
Pecinovský J. Word 2000: podrobný průvodce pokročilého uživatele, Grada, Praha. 2000.
-
PÍSEK, S. Access 2007, GRADA 2007.
-
ZVÁROVÁ, J.. Základy statistiky pro biomedicínské obory. Praha: Karolinum, 2016. ISBN 978-80-246-3416-6.. 1999.
|