|
Lecturer(s)
|
-
Chytrý Vlastimil, doc. PhDr. Ph.D.
|
|
Course content
|
First information, information technology, electronic information The second part of the personal computer, computer memory, input and output devices Third 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
|
|
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. The course is designed as an introductory course in the segment of curriculum focused on digital technologies used for study and teaching practice purposes. Its completion is a prerequisite for follow-up courses of this segment. It should be placed as first in the line.
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
|
-
Brož, M. Microsoft Office Excel 2003 Podrobná uživatelská příručka.. CP Books, 2004.
-
Brož, M. Microsoft Office Word 2003 Podrobná uživatelská příručka..
-
Broža P. Instalujeme a konfigurujeme počítač. CP Books. 2005.
-
Č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.
-
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., PECINOVSKÝ, R. Office 2010. Praha, 2011.
-
PECINOVSKÝ, J., PECINOVSKÝ, R. Office 2010. Praha, 2011.
-
Pecinovský, Josef. OpenOffice.org 2.0: kompletní průvodce. Praha, 2006. ISBN 80-247-1016-1.
-
Petr Broža. Vytváříme WWW stránky.
-
ZVÁROVÁ, J.. Základy statistiky pro biomedicínské obory. Praha: Karolinum, 2016. ISBN 978-80-246-3416-6.. 1999.
|