PAPVA_41 Computer technique IB

Faculty of Arts
Spring 2014
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. (seminar tutor)
Guaranteed by
prof. PhDr. Zdeněk Měřínský, CSc.
Department of Archaeology and Museology – Faculty of Arts
Contact Person: Mgr. Lucie Valášková
Supplier department: Department of Archaeology and Museology – Faculty of Arts
Timetable
Tue 9:10–10:45 L11
Prerequisites (in Czech)
PAPVA_40 Computer Technology IA
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
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
  • Počítačová podpora v archeologii. Edited by Jiří Macháček. 1. vyd. Brno: Masarykova univerzita, 1997, 258 s. : i. ISBN 80-210-1562-4. info
Teaching methods
ctive work in the seminar, group projects
Assessment methods
Teaching: 2 hours seminar per week Assessment: 2 tests
Language of instruction
Czech
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.
The course is also listed under the following terms Spring 2011, Spring 2012, Spring 2013, Spring 2015, Spring 2016.
  • Enrolment Statistics (Spring 2014, recent)
  • Permalink: https://is.muni.cz/course/phil/spring2014/PAPVA_41