TE2MP_CVT4 Practical Applied Computer Technology 4

Faculty of Education
Autumn 2009
Extent and Intensity
0/0/2. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Martin Dosedla, Ph.D. (seminar tutor)
Guaranteed by
Ing. Martin Dosedla, Ph.D.
Department of Technical Education and Information Science – Faculty of Education
Contact Person: Gabriela Jančíková
Course Enrolment Limitations
The course is also offered to the students of the fields other than those 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;
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: every week.
Teacher's information
http://www.ped.muni.cz/wtech/
The course is also listed under the following terms Autumn 2005, Autumn 2006, Autumn 2007, Autumn 2008.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/ped/autumn2009/TE2MP_CVT4