Information System of Masaryk University 

Course Information

AEA_09 Computer technique IB

Faculty of Arts
Spring 2009

Extent and Intensity

0/2/0. 3 credit(s). Type of Completion: k (colloquium).

Teacher(s)

prof. Mgr. Jiří Macháček, Ph.D. (seminar tutor)
Mgr. Petr Dresler, Ph.D. (seminar tutor)

Supervisor

prof. PhDr. Zdeněk Měřínský, CSc.
Department of Archaeology and Museology - Faculty of Arts
Contact Person: Jitka Dobešová

Timetable of Seminar Groups

AEA_09/A Wed 8:20–9:55 D31, P. Dresler, J. Macháček
AEA_09/B Wed 10:00–11:35 D31, P. Dresler, J. Macháček

Prerequisites (v češtině)

AEA_01 Introduction to Archaeology && AEA_08 Computer Technology IA

Course Enrollment 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 enrollment status: enrolled: 0/32, only registered: 0/32

Fields of study the course is directly associated with

• Archaeology (programme FF, B-GE)
• Archaeology (programme FF, B-HI)
• Archaeology (programme FF, B-HS)

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.

Teaching methods

active work in the seminar, group projects

Assessment methods

Teaching: 2 hours seminar per week Assessment: 2 tests

Follow-Up Courses

• AEA_08 Computer Technology IA

Further comments (probably available only v češtině)

Study Materials
Information on completion of the course: Pro získání zápočtu je třeba aktivní účast na semináři a prokázání základních znalostí o odpřednášených metodách.
The course is taught annually.
Information on course enrollment limitations: 2 seminární skupiny

Teacher's information

Studijní literatura: Macháček, J. (ed.). Počítačová podpora v archeologii 2. Brno - Praha - Plzeň. 2008. Macháček, J. (ed). Počítačová podpora v archeologii. Brno. Masarykova univerzita v Brně. 1997. Neustupný, E. Metoda archeologie. Katedra archeologie - FF ZČU. Plzeň. 2007 Neustupný, E. 1994. Role databází v archeologii. Archeologické rozhledy 46, 121-128.

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 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014.

---

• Enrollment Statistics (Spring 2009, recent)
  
• Permalink: https://is.muni.cz/course/phil/spring2009/AEA_09

---