VIKBA05 Data Transformation

Faculty of Arts
Autumn 2015
Extent and Intensity
0/2/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
Mgr. Jan Martinek (lecturer)
Bc. Martin Černý (assistant)
Bc. Radek Dobrovolný (assistant)
Bc. Tereza Hájková (assistant)
Mgr. Pavla Martinková (assistant)
Mgr. Hana Tulinská (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. Alžběta Šašinková, Ph.D.
Supplier department: Division of Information and Library Studies – Department of Czech Literature – Faculty of Arts
Timetable
Fri 27. 11. to Fri 18. 12. Fri 15:50–17:25 B2.13, Mon 21. 9. to Fri 20. 11. Fri 15:50–17:25 C33
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 25: Intro session, basic required PC efficiency rundown
    - Oct 2: Typography and semantics
    - Oct 9: Markup languages: HTML, Markdown
    - Oct 16: Plaintext editor 101: find & replace, regular expressions
  • Working with a tabular data
    - Oct 23: Object description
    - Oct 31: Formulas
    - Nov 7: Formulas II.
  • Database
    - Nov 14: Joinin the tables
    - Nov 21: Selecting data
  • Intro to scripting
    - Nov 28: Variables
    - Dec 4: Conditions and loops: if, while, for each
    - Dec 11: Conditions and loops: switch, for
    - 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 2016, Autumn 2017, Autumn 2018, Autumn 2019.
  • Enrolment Statistics (Autumn 2015, recent)
  • Permalink: https://is.muni.cz/course/phil/autumn2015/VIKBA05