Course syllabus PZD - Application of IT (FA - WS 2020/2021)


     Czech          English          


Course code:
PZD
Course title in Czech:
Application of IT
Course title in English:
Application of IT
Semester:
WS 2020/2021
Mode of completion and number of credits: Fulfillment of requirements (4 credits)
Mode of delivery and timetabled classes:
full-time, 2/2 (hours of lectures per week / hours of seminars per week)
Level of course: bachelor
Course type:
optional
Type of delivery:
usual
Mode of delivery for our mobility students abroad: -- item not defined --
Language of instruction: Czech
Course supervisor:
Ing. Michal Šustr, Ph.D.
Course supervising department:
Faculty:
Teachers: Ing. Michal Šustr, Ph.D. (examiner, instructor, lecturer, supervisor)
Prerequisites:
none
 
Timetable in this semester:
-- item not defined --
 
Aim of the course and learning outcomes:
Acquiring of the main knowledges and skills in computer technique. Achievment of elementary independence in operation with computer equipement, operating system and main programme enviromnent. Knowledges of the main algoritms used in data processing.
 
Course content:
1.
Theoretical introduction to computer technology (allowance 2/2)
 
a.Basic concepts
b.
History of Computing
c.
How to Care of Computer - Maintenance, Installation, Cleaning

2.
Fundamentals of operating systems (allowance 2/2)
 
a.
OS X and mobile OS
b.
Windows (text and graphical user interface)
c.
Principles of operating systems, benefits and ways of communicating with the user

3.
Hardware and software maintenance (allowance 2/2)
 
a.Antivirus
b.Optimize registers and temporary files
c.Software update

4.
Computer software (allowance 2/2)
 
a.
Table Processors. MS Excel
b.Text processing and basic typography. MS Word
c.
Presentation. MS Powerpoint
d.basic file formats

5.
Fundamentals of Computer Networking and the Internet (allowance 2/2)
 
a.
Wifi access
b.
Cloud
c.VPN

6.Possibilities of using embedded functions in spreadsheets (allowance 2/2)
7.Advanced techniques to work with spreadsheet tools (allowance 2/2)
8.
E-learning and distance learning opportunities (allowance 2/2)
9.
Current trends in the use of information technology (allowance 2/2)
10.Computer networks. Technology, services, applications (allowance 2/2)
11.
Publish and share documents on the Web (allowance 1/1)
 
a.
Preparation of an electronic presentation and poster

12.
The technique of writing professional papers (allowance 2/2)
 
a.
Basic structure of technical documentation, writing of mathematical equations, tables
b.
Visualization of experimental data

13.
Detailed instructions and recommendations for writing, editing and requisites of the final work (allowance 2/2)
14.
Security data on the Internet (allowance 1/1)
Learning activities and teaching methods:
Type of teaching methodDaily attendance
lecture
25 h
practice25 h
consultation
4 h
preparation of presentation
14 h
writing of seminar paper
40 h
Total
108 h
 
Assessment methods:
Solution and oral defence of the real data processing problem. Solution of the problem is presented as seminar work in the format of the programme Word. Document must contain problem description, explanantion of the solution, tables and graphs of the input and output data and result discussion. Document style must be equal to the diploma thesis of the AF MENDELU.
 
Assessment criteria ratio:
Requirement type
Daily attendance
Total
0 %
 
Recomended reading and other learning resources:
Basic:
PECINOVSKÝ, J. Microsoft Word 2003 : podrobný průvodce začínajícího uživatele. 1st ed. Praha: Grada Publishing, 2004. 227 p. Průvodce. ISBN 80-247-0791-8.
PECINOVSKÝ, J. -- PECINOVSKÝ, R. Word 2007 pro pokročilé. 1st ed. Praha: Grada, 2009. 236 p. Průvodce. ISBN 978-80-247-2859-9.
ŠIMEK, T. Počítáme v Excelu. Praha: Grada, 2007. 200 p. ISBN 978-80-247-1769-2.
HENDL, J. Přehled statistických metod zpracování dat. Praha: Portál, 2004. 250 p. ISBN 978-80-7367-482-3.
BARILLA, J. et al. Microsoft Office 2010: podrobná uživatelská příručka. 1st ed. Brno: Computer Press, 2010. 491 p. Podrobná uživatelská příručka. ISBN 978-80-251-3222-7.
DANNHOFEROVÁ, J. -- SIMR, P. -- PÍRKOVÁ, K. -- BARILLA, J. Microsoft Office 2010 - Podrobná uživatelská příručka. Brno: Computer Press, a.s., 2010. 491 p. ISBN 978-80-251-3222-7.

Recommended:
MELOUN, M. -- MILITKÝ, J. Kompendium statistického zpracování dat: metody a řešené úlohy. 2nd ed. Praha: Academia, 2006. 982 p. ISBN 80-200-1396-2.
WALKENBACH, J. Excel 2007 Bible. USA: John Wiley, 2007. 300 p. ISBN 978-0-470-04403-2.
LINOFF, G. -- BERRY, M. Data Mining Techniques: For Marketing, Sales, and Customer Relationship Management. USA: John Willey, 2004. 400 p. ISBN 978-0-471-47064-9.
COX, J. -- PREPPERNAU, J. Microsoft Office Word 2007 Step by Step. USA: Microsoft, 2007. 400 p. ISBN 0-7356-2302-3.
KOLEKTIV, K. Word 2003.  [online]. 2009. URL: http://word-navod.sweb.cz/.
VOSTÁREK, M. Excel 2003.  [online]. 2006. URL: http://www.humanitas.cz/storage_edutexts/excel_2003.pdf?PHPSESSID=ef6be9191a2a240329d28b37742dd962.
COOK, W. Po stopách obchodního cestujícího : matematika na hranicích možností. Praha: Argo, 2012. ISBN 978-80-7363-412-4.

Course listed in study plans for this semester:
-- item not defined --
 
Course listed in previous semesters: WS 2019/2020, WS 2018/2019, WS 2017/2018, WS 2016/2017, WS 2015/2016, WS 2014/2015 (and older)
Teaching place: Brno


Last modification made by Ing. Michal Karhánek on 05/19/2020.

Type of output: