AEA_09 Computer technique IB

Faculty of Arts
Spring 2017
Extent and Intensity
0/2/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
Timetable
Tue 7:30–9:05 L11
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 6 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.
Teaching methods
active work in the seminar, group projects
Assessment methods
Teaching: 2 hours seminar per week Assessment: 2 tests
Language of instruction
Czech
Follow-Up Courses
Further comments (probably available only in Czech)
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 enrolment limitations: 2 seminární skupiny
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 2018, Spring 2019, Spring 2020, Autumn 2020.
  • Enrolment Statistics (Spring 2017, recent)
  • Permalink: https://is.muni.cz/course/phil/spring2017/AEA_09