Databases

Information

  • Place: ARTEHIS, University of Burgundy, Dijon, France
  • Language: French
  • Semesters: spring 2015, spring 2016
  • Open to: Licence 3 of Archaeology

Objectives

The objective of this course is to present the use of databases and descriptive statistics in archaeology. At the end, students will be led to design different types of databases for different objectives (e.g. inventory, bibliography, management, research). They will also be able to create descriptive tables and graphs of quantitative and qualitative data. Databases will be created in MS Access, the statistics will be performed in MS Excel and in freely available PAST software.

CaptureBDD4.PNG

Presentations

  • 1. Databases. Introduction to databases in MS Access, types of variables, tables, importations, forms (1, 2 and 3 levels)  pdf
  • 2-4. Databases. Exercises with forms (1, 2, and 3 levels)  pdf
  • 6. Introduction of statistics for archaeologists. Descriptive statistics, distributions, central tendencies, variance, standard deviation, coefficient of variation pdf
  • 7. Exam. Written exam pdf