Course Description (Water Quality Data Management and Modeling)
This 3-day course is designed to give water professionals hands-on experience applying AquaChem to projects requiring geochemical data interpretation and management of water data.
The study of water chemistry data involves a large number of numerical and graphical techniques, which are not readily available with standard Office software such as MS Excel. AquaChem offers an extensive but easy-to-use numerical and graphical toolset for efficient analysis of most water chemistry data sets. In this course you will be given detailed background information on how to apply these methods in order to track down the formation history of the studied water samples. You will also learn how to document and present your findings efficiently.
For complex geochemical modeling problems, AquaChem offers a seamless interface to the USGS code PHREEQC, the ‘de facto’ standard in this field. You will learn how to apply this software to simple problems in order to quantify your hypothesis. Additionally, you will receive an overview of more complex modeling capabilities of PHREEQC. Attendees are encouraged to bring their own datasets, which they will be able to convert into the AquaChem database and interpret during the course.
Managing Water Quality Data
Storing and managing water quality data represents a major challenge, in particular if you have large volumes of data stored in various file formats. Understanding the data and maximizing the use of your data management system will be discussed.
Quality Control and Statistics
Analytical lab results tend to appear accurate and indisputable. However, many sources of error can be introduced to a sample throughout the sample collection and delivery process. This section of the course covers the principles of quality control and the role of a database in this process.
Effective Use of Data Plots
It is difficult to present and understand water quality data when presented in tabulated or spreadsheet formats. Data plots represent a more effective method to detect patterns and identify trends in data. As a plotting tool, AquaChem will be used to create a wide variety of standard water quality data plots.
Geochemical Modeling using PHREEQC
The effects of changing geochemical conditions caused by landfills, wastewater, injection wells, mine tailings,etc. have a non-intuitive effect on dissolved concentrations in groundwater. Geochemical modeling using PHREEQC can be used to help anticipate these changes.
Course Software:AquaChem(used as a standard for the UK Environment Agency and US Office of Surface Mining), and PHREEQC
Course Objectives and Benefits
From hands-on experience, you will learn...
-
How to effectively apply AquaChem to water quality analysis projects
-
How to create your own hydrochemistry database
-
Basic understanding of rock/water interactions
-
How to quickly generate data plots and prepare professional reports from water quality data analysis
-
What to look for when evaluating data quality
-
How to solve geochemmical modeling problems using PHREEQC
Earn SWS CEU's
Schlumberger Water Services offers Continuing Education Units (CEUs) toward the successful participation and completion of this professional training courses. All of our training courses are developed to ensure the participants are exposed and challenged through various hands-on lab exercises and exposure to theoretical concepts. We pride ourselves in offering a comprehensive learning experience and provide attendees with a Certification of Completion which includes 2.4 CEU's for completing this course.
Course Topics
-
Fundamentals of managing water quality data
-
Concepts and benefits of relational databases applied to water chemistry data
-
Importing water quality data from various data sources into a relational database
-
Assessing the quality of lab data, identifying trends, and performing statistical calculations
-
Detection & interpretation of exceedence values
-
Understanding and dealing with detection limits
-
Interpretation techniques (Rock Source Detection)
-
Identifying water types and aquifer composition
-
Calculation of saturation indicies or pH
-
Plotting spatial patterns of water quality data
-
Introduction to the USGS modeling code PHREEQC
-
Learning the use of AquaChem and PHREEQC
|