TE2RC_VT3 Applied Computer Technology 3

Faculty of Education
autumn 2009
Extent and Intensity
0/0/0. 10 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Martin Dosedla, Ph.D. (seminar tutor)
Supervisor
doc. PhDr. Zdeněk Friedmann, CSc.
Department of Technical Education and Information Science - Faculty of Education
Contact Person: Gabriela Jančíková
Course Enrollment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
Fields of study 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
  • ČEŠKOVÁ, Martina. Excel 2003. 1. vyd. Praha: Grada, 2004. 116 s. ISBN 80-247-0700-4. info
  • MACDONALD, Matthew. Excel 2007 :chybějící manuál. 1. vyd. Praha: Grada, 2008. 826 s. ISBN 978-80-247-2195. info
  • Access 2007 :podrobný průvodce. Edited by Slavoj Písek. 1. vyd. Praha: Grada, 2007. 197 s. ISBN 978-80-247-1967. info
Teaching methods
theoretical training, work independently and exercise
Assessment methods
The development work in spreadsheets and simple database.
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/
1. PÍSEK, S.: Access 2000. Praha: Grada, 1999. 1. vydání. 116 s. 2. PÍSEK, S.: Access 2002. Praha: Grada, 2002. 1. vydání. 216 s. 3. BROŽ, M.: Excel 2000. Praha: ComputerPress, 2002. 1. vydání. 258 s. 4. PECINOVSKÝ, J.: Excel 2002. Praha: Grada, 2002. 1. vydání. 212 s. 5. PECINOVSKÝ, J. – PECINOVSKÝ, R.: Excel 97. Praha: Grada, 1997. 1. vydání. 272 s. 6. MĚSTECKÝ, P.: MS Office 2000 & XP. Praha: ComputerPress, 2002. 1. vydání. 411 s. 7. MAGERA, I. – ŠIMEK, T.: MS Office 2000. Praha: ComputerPress, 2001. 1. vydání. 399 s. 8. HYNEK, D. – A KOL.: MS Office 97. Praha: Grada, 1997. 1. vydání. 384 s. 9. PECINOVSKÝ, J.: Office XP. Praha: Grada, 2002. 1. vydání. 432 s. 10. VORÁČEK, R.: Slovník počítačových pojmů a zkratek. Praha: Fortuna, 1998. 2. vydání. 183 s. 11. KŘÍŽ, J.: Velký frekvenční slovník počítačů 2003. Praha: Montanex, 2002. 1 vydání. 510 s. 12. NAVRÁTIL, P.: S počítačem nejen k maturitě – 1. díl. Kralice na Hané: Computer Media, 2004. 5. vydání. 175 s. ISBN: 80-86686-19-1. 13. NAVRÁTIL, P.: S počítačem nejen k maturitě – 2. díl. Kralice na Hané: Computer Media, 2004. 5. vydání. 175 s. ISBN: 80-86686-19-1.
The course is also listed under the following terms Autumn 2004, Autumn 2005, Autumn 2006, Autumn 2007, Autumn 2008, autumn 2010, autumn 2011, autumn 2012, autumn 2013.
  • Enrollment Statistics (autumn 2009, recent)
  • Permalink: https://is.muni.cz/course/ped/autumn2009/TE2RC_VT3

Other references: 

Go to top | Current date and time: 23. 5. 2013 17:17, Week 21 (odd)

Contact: istech(zavináč/atsign)fi(tečka/dot)muni(tečka/dot)cz, Office for Studies, access rights administrators, is-technicians, e-technicians, IT support | learn more about Information System