TE2RC_VT3 Applied Computer Technology 3

Faculty of Education
Autumn 2014
Extent and Intensity
0/0/0. 10 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Martin Dosedla, Ph.D. (seminar tutor)
Guaranteed by
doc. PhDr. Zdeněk Friedmann, CSc.
Department of Technical Education and Information Science – Faculty of Education
Contact Person: Gabriela Jančíková
Supplier department: Department of Technical Education and Information Science – Faculty of Education
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
At the end of this course the student will be able to: work independently with a suite of office applications; create and edit tables and charts, and process it self; explain and distinguish the principles of databases; use database systems to design their own databases, including their interfaces; samostgatně use office applications and their interconnections;
Syllabus
  • 1st The package of office programs.
  • 2nd Table editors - introduction.
  • 3rd Table editors - formulas, functions, formats cells.
  • 4th Table editors - the creation of the table.
  • 5th Table editors - formatting the table.
  • 6th Table editors - the creation of the chart.
  • 7th Table editors - finishing the table and work with   sheets.
  • 8th Table editors - More features.
  • 9th Editor databases - an introduction and basic functions.
  • 10th Editor databases - and questions session.
  • 11th Editor databases - the creation of forms.
  • 12th Editor databases - Creation Group.
Literature
  • MACDONALD, Matthew. Excel 2007 : chybějící manuál. 1. vyd. Praha: Grada, 2008, 826 s. ISBN 9788024721958. info
  • PÍSEK, Slavoj. Access 2007 : podrobný průvodce. 1. vyd. Praha: Grada, 2007, 197 s. ISBN 9788024719672. URL info
  • ČEŠKOVÁ, Martina. Excel 2003. 1. vyd. Praha: Grada, 2004, 116 s. ISBN 8024707004. info
Teaching methods
theoretical training, work independently and exercise
Assessment methods
The development work in spreadsheets and simple database.
Language of instruction
Czech
Further comments (probably available only in Czech)
The course is taught annually.
The course is taught: in blocks.
Information on the extent and intensity of the course: 25 hodin.
Teacher's information
http://www.ped.muni.cz/wtech/
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 2015, Autumn 2016, Autumn 2017, Autumn 2018, Autumn 2019, Autumn 2022, Autumn 2023, Autumn 2024.
  • Enrolment Statistics (Autumn 2014, recent)
  • Permalink: https://is.muni.cz/course/ped/autumn2014/TE2RC_VT3