VIKBA05 Data Transformation

Faculty of Arts
Autumn 2017
Extent and Intensity
0/2/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
Mgr. Jan Martinek (lecturer)
Bc. Radek Dobrovolný (assistant)
Guaranteed by
PhDr. Petr Škyřík, Ph.D.
Division of Information and Library Studies – Department of Czech Literature – Faculty of Arts
Contact Person: Mgr. Sabina Kubisová
Supplier department: Division of Information and Library Studies – Department of Czech Literature – Faculty of Arts
Timetable
Fri 15:50–17:25 zruseno Aula FAVU
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
The goal of the course is to understand the potential of the personal computer in everyday work life. PCs are commonly used to input and consume information (be it any text, music, video, multimedia or interactive content). This course focuses on the missing part in the list: transformation of the information.

Students will lear how information in the computer is structured, how to semantically structure the information and how to work with this structure: in a text editor, spreadsheet processor, database and with simple scripts.

Course is taught in a hybrid form – students read assigned texts and work on their homework before a mandatory seminar lecture, where the results, problems and other details are discussed.
Syllabus
  • Working with text
    - Sep 23: Intro session, basic required PC efficiency rundown
    - Sep 30: Typography and semantics
    - Oct 7: Markup languages: HTML, Markdown
    - Oct 14: Plaintext editor 101: find & replace, regular expressions
  • Working with a tabular data
    - Oct 21: Object description
    - Oct 29: Formulas
  • Database
    - Nov 4: Joinin the tables
    - Nov 11. Selecting data
  • Intro to scripting
    - Nov 18: First steps
    - Nov 28: Variables and for loop
    - Dec 4: Conditions
    - Dec 11: Working with text
    - Dec 18: Final session
Literature
    required literature
  • Bueno, Carlos. Lauren Ipsum: a story about computer science and other improbable things. ISBN 978-1-59327-574-7. William Pollock, San Francisco 2014.
  • PECINA, Martin. Knihy a typografie. 2. vyd., rozš. Brno: Host, 2012, 308 s. ISBN 9788072948130. info
    not specified
  • Google.com. (n.d.). Retrieved September 10, 2015, from http://www.google.com
Teaching methods
- e-learning
- peer assesment
- mandatory seminar lectures
Assessment methods
peer assesment, final test
Language of instruction
Czech
Further Comments
Study Materials
The course is also listed under the following terms Autumn 2004, Autumn 2005, Autumn 2006, Autumn 2007, Autumn 2008, Autumn 2009, Autumn 2010, Autumn 2011, Autumn 2012, Autumn 2013, Autumn 2014, Autumn 2015, Autumn 2016, Autumn 2018, Autumn 2019.
  • Enrolment Statistics (Autumn 2017, recent)
  • Permalink: https://is.muni.cz/course/phil/autumn2017/VIKBA05