Course module: Database quality control

Course title: Database quality control
Course code:  
Subject areas (Curriculum): IT, Database, QA/QC,
Duration: 1 day
Short description: Introduce QAssurance /QControl and respective measure from the soil science domain to course participants.
Moderators: JS (Jorge) Mendes de Jesus and JGB (Johan) Leenaars
Target audience: Soil Scientist concerned with Data Quality Assessment / Quality Control.
Requirements: Computer, Internet Connection
Programme: 4 blocks of 1.5h

  • 1) Introduction to QA/QC
  • 2) Simple vs. Complex Validation in Soil Science
  • 3) Exercise: Simple and Complex QA
  • 4) Exercise: Simple and Complex QC
Objective: Course participants at the end of the day should be able to design QA/QC rules in the soil science domain, implement and able to apply them on soil science data sets.
Software / materials: Excel, PGAdmin, SQL interface into a local soil Database
Case studies: NA
Literature: NA
Minimum number of participants: 5
Maximum number of participants: 10