H60276z Computers I

Faculty of Music
Winter 2023
Extent and Intensity
1/1/0. 1 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Marek Kokeš (lecturer)
Guaranteed by
Ing. Marek Kokeš
Music Production Department – Dean’s Office – Faculty of Music – Janáček Academy of Performing Arts
Supplier department: Music Production Department – Dean’s Office – Faculty of Music – Janáček Academy of Performing Arts
Timetable
Wed 8:30–10:05 006
Prerequisites
EVER( H60276l Computers I )
Passing the entrance exam to study music management.
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
During the course, the students will get acquainted with the principles of PC computers, basic peripherals, storage media, Windows OS environment and its settings, they will learn to work with files and folders and share them. They continue to work with office applications MS Office, where they deepen knowledge of MS Word, Excel and PowerPoint. A special part of the course is devoted to creating web pages, understanding and compiling html document code, its semantics and validation for internet search services. It also includes basics of web design followed by cascading style sheets. Students will also learn about open source content management systems, their installation, database import and upload to the server via FTP.
Learning outcomes
Student is able to: -free work with MS Word- create and structure in an advanced way, format, save and otherwise edit document, create custom styles, insert external files, save templates;
- in MS Excel creates tables with advanced formatting, custom filters, formulas (relative and absolute), functions; it controls the creation of various types of graphs and can assess the suitability of their use according to input data. They apply the acquired knowledge in everyday practice;
- Acquire the knowledge of web page coding to address a variety of art projects for vendor promotion or web site error detection, which will significantly speed up the decision-making process;
Syllabus
  • - repetition of basic information about the structure and principles of personal computer hardware, description of input and output peripherals (desktop, tower, laptop, PDA, tablet, components, peripherals, performance, capacity, etc.)
    - personal computer software - general information (operating systems, drivers, antivirus, office software, graphics software, etc.)
    - work and orientation in the Windows operating system (system requirements, moving and copying files, setting display parameters, security, data archiving, FTP, USB, DVD, server, etc.)
    - the principles of working with the Internet, the effective use of tools for working with the Internet (what is the Internet, the browser and its alternatives, security, communication, data storage, email, etc.)
    - Microsoft Office 2010 Office suite (compared to   OpenOffice);
  • - Word 2010 - acquiring detailed knowledge when working with text documents;
  • - Excel 2010 - acquiring detailed knowledge when working with spreadsheets;
  • - tools for converting documents to PDF and working with this format;
  • - introduction to html code, creation of a simple html5 web page with structured content;
  • - document design by CSS;
  • - moving documents to a web server using FTP;
  • - introduction to the most used content management systems (Wordpress, Joomla, Drupal), principles of their operation (PHP, MySQL, JavaScript), their advantages and disadvantages, plugins, widgets, server installation, import / export database;
Literature
  • Dudáček, Karel : Poprvé u počítače, aneb, Začínáme s PC, Kopp, České Budějovice 2009. info
  • Miroslav, Lorenc, Vrbová, Lucie : Informatika pro Arts Management, Oeconomica, Praha 2010. info
  • Pecinovský, Josef : Windows 7: průvodce začínajícího uživatele, Grada, Praha 2010. info
  • Pecinovský, Josef : Office 2010: podrobný průvodce, Grada, Praha 2011. info
  • Pochyla, Martin : Vyhledávání informací a synchronizace dat na Internetu, VŠB-TU, Ostrava 2010. info
Teaching methods (in Czech)
Přednášky a cvičení.
Assessment methods (in Czech)
Zápočet a zkouška.
Language of instruction
Czech
Further comments (probably available only in Czech)
Information on course enrolment limitations: Pro úspěšný zápis předmětu si zaregistrujte též odpovídající předmět v letním semestru (podle předpokladu "EVER")
The course is also listed under the following terms Winter 2013, Winter 2014, Winter 2015, Winter 2016, Winter 2017, Winter 2018, Winter 2019, Winter 2020, Winter 2021, Winter 2022, Winter 2024.
  • Enrolment Statistics (Winter 2023, recent)
  • Permalink: https://is.jamu.cz/course/hf/winter2023/H60276z