Course: Principles of Computer Technology

« Back
Course title Principles of Computer Technology
Course code AURP/AP1ZT
Organizational form of instruction Lesson
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 3
Language of instruction Czech, English
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Navrátil Petr, Ing. Ph.D.
  • Vojtěšek Jiří, doc. Ing. Ph.D.
Course content
- Basics of working with a computer in the classroom, requirements for the subject. - MS Word - working with styles, creating templates, document formatting. - MS Word - inserting images, cropping, captions, inserting and editing equations, cross-references. - MS Excel - formatting of cells and worksheet, borders, absolute and relative addressing of cells. - MS Excel - inserting functions, solver, matrix operations, creating graphs, regression. - 1st classification - individual work in Word and Excel. - MS PowerPoint - basics of work, inserting pictures, tables, etc. into the presentation, animation. - Basics of presentation, assignment and selection of topics for presentation in PowerPoint. - Presentation of created presentations - evaluation of presentation, 2nd classification. - Creation of static HTML pages - basic document structure, formatting, headings, lists, hypertext links - Creation of static HTML pages - inserting images, creating photo galleries, tables, frames. - Creation of static HTML pages - cascading styles, the procedure for uploading pages to the Internet. - Final thesis assignment - creation of a static web presentation on the assigned topic. - Presentations of created web presentations - 3rd classification. - Credit week, corrective written work.

Learning activities and teaching methods
Exercises on PC, Practice exercises
  • Home preparation for classes - 14 hours per semester
  • Participation in classes - 28 hours per semester
  • Preparation for course credit - 12 hours per semester
prerequisite
Knowledge
Basic knowledge of the personal computer.
Basic knowledge of the personal computer.
learning outcomes
The student will acquire knowledge of the basic concepts of information and communication technologies
The student will acquire knowledge of the basic concepts of information and communication technologies
The student will acquire key competencies for creating documents (seminar work, qualification work) in the MS Office environment.
The student will acquire key competencies for creating documents (seminar work, qualification work) in the MS Office environment.
The student will acquire key competencies for creating documents (seminar work, qualification work) in the MS Office environment
The student will acquire key competencies for creating documents (seminar work, qualification work) in the MS Office environment
The student will get information about the spreadsheet editor (MS Excel)
The student will get information about the spreadsheet editor (MS Excel)
The student will get information about software for creating presentations (MS PowerPoint)
The student will get information about software for creating presentations (MS PowerPoint)
The student will acquire knowledge about basic Internet services and the possibilities of creating static web presentations
The student will acquire knowledge about basic Internet services and the possibilities of creating static web presentations
Skills
The student searches the Internet for information key to studying his field and further expanding his professional competences
The student searches the Internet for information key to studying his field and further expanding his professional competences
The student uses advanced procedures for formatting documents - styles, citations, interactive content, linked links, etc.
The student uses advanced procedures for formatting documents - styles, citations, interactive content, linked links, etc.
The student uses document sharing platforms
The student uses document sharing platforms
The student works with a table editor to the extent necessary for the study of the given field - simple tables and graphs, basic formulas
The student works with a table editor to the extent necessary for the study of the given field - simple tables and graphs, basic formulas
The student works with software for creating presentations to the extent necessary for the study of the given field
The student works with software for creating presentations to the extent necessary for the study of the given field
The student creates simple static web presentations using HTML and CSS
The student creates simple static web presentations using HTML and CSS
teaching methods
Knowledge
Exercises on PC
Exercises on PC
Practice exercises
Practice exercises
assessment methods
Grade (Using a grade system)
Written examination
Written examination
Grade (Using a grade system)
Recommended literature
  • Barksdale, K.; Turner, E.S. HTML Basics. Course Technology, 2005. ISBN 978-0619266264.
  • Laurenčík, M. Excel - pokročilé nástroje: funkce, makra, databáze, kontingenční tabulky, prezentace, příklady. Praha: Grada, 2016. ISBN 978-80-247-5570-0.
  • LAURENČÍK, Marek. Tvorba www stránek v HTML a CSS. Praha: Grada Publishing, 2019. ISBN 978-80-271-2241-7.
  • PECINOVSKÝ, Josef a Rudolf PECINOVSKÝ. Office 2019 : & Office 365 : průvodce uživatele. Praha: Grada Publishing,, 2019. ISBN 978-1-292-06116-0.
  • Písek, S. HTML - tvorba jednoduchých internetových stránek. Praha : Grada, 2006. ISBN 978-80-247-1767-8.
  • Schafer, Steven M. HTML, XHTML a CSS : bible. 1. vyd. Praha : Grada, 2009. ISBN 978-80-247-2850-6.
  • ŽITNIAK, Ján. Microsoft Office 2016: podrobná uživatelská příručka. Brno: Computer Press, 2017. ISBN 978-80-251-4891-4.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester