AEA_09 Computer technique IB

Faculty of Arts
Spring 2020
Extent and Intensity
0/0/0. 3 credit(s). Type of Completion: k (colloquium).
Teacher(s)
prof. Mgr. Jiří Macháček, Ph.D. (lecturer)
Mgr. Petr Dresler, Ph.D. (lecturer)
Guaranteed by
prof. Mgr. Jiří Macháček, Ph.D.
Department of Archaeology and Museology – Faculty of Arts
Contact Person: Jitka Šibíčková
Supplier department: Department of Archaeology and Museology – Faculty of Arts
Prerequisites (in Czech)
AEA_01 Introduction to Archaeology && AEA_08 Computer Technology IA && !NOWANY( PAPVA_41 Computer technique IB )
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.

The capacity limit for the course is 32 student(s).
Current registration and enrolment status: enrolled: 0/32, only registered: 0/32
fields of study / plans the course is directly associated with
there are 13 fields of study the course is directly associated with, display
Course objectives
Degree programme: Archaeology Course: Computer Technology I Level: First cycle of the five-year Mgr. programme Language of instruction: Czech Teaching: 4 hours seminar per week Duration: 1 semester Credits: A4 Assessment: 2 tests Course description: Practice with the operating system Windows and with the word processing programme Word. Introduction to working with archaeological databases (the programmes Microsoft Access and Microsoft Excel). Lecturer: Jiří Macháček, Instructor Literature (sel.): To be specified Prerequisite: None
Syllabus
  • 1. Summary of the subject Computer Technology I A 2. Data model of the relational database. Relational tables. Filter and sort data in the relational database. 3. Queries. Creating of queries. Select query. Query Wizard. Queries with join related data sources 4. Reports from database. 5. Import, export a to and from database. 6. Introduction in the work with spreadsheets. Microsoft Excel 7. Cells, columns and rows. Add date into tables. Moving in the tables. 8. Filtering, sorting, and conditionally formatting data 9. Charts. 10. Statistical analysis in Microsoft Excel. Histogram. 11. Working on own database 1. 12. Working on own database 2. 13. Working on own database 3. 14. Working on own database 4. 15. Summary and test.
Literature
  • Macháček, J. (ed). Počítačová podpora v archeologii. Brno. Masarykova univerzita v Brně. 1997.
Assessment methods (in Czech)
Požadavky k zápočtu -aktivní účast na semináři -vytvoření složitější databáze -použití grafů při analýze dat
Language of instruction
Czech
Follow-Up Courses
Further comments (probably available only in Czech)
Information on completion of the course: Pro získání zápočtu je třeba odevzdat semestrální úkol a prokázání základních znalostí o odpřednášených metodách.
The course is taught annually.
Note related to how often the course is taught: forma semestrálního úkolu.
Information on the extent and intensity of the course: samostatná práce.
The course is also listed under the following terms Spring 2000, Spring 2001, Spring 2002, Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Autumn 2020.
  • Enrolment Statistics (Spring 2020, recent)
  • Permalink: https://is.muni.cz/course/phil/spring2020/AEA_09