Training Courses

This two-day workshop is designed to provide participants with the knowledge and practical skills needed to leverage Excel for analyzing and interpreting data in analytical chemistry. The workshop focuses on essential and advanced Excel functions and their applications in real- world chemical data analysis, such as method validation, measurement uncertainty, error propagation, and statistical methods tailored for laboratory work. Through hands-on exercises and real-world examples, attendees will explore methods for visualizing data, calculating descriptive statistics, conducting hypothesis testing, and handling complex data sets using Excel’s built-in tools and custom formulas. This workshop is particularly beneficial for professionals and students in chemistry, environmental science, biology, or related fields who need to enhance their data analysis skills for laboratory and research applications. The course will also cover techniques to automate calculations and error analysis, allowing participants to streamline their data workflows. By the end of the workshop, participants will have the confidence and expertise to apply Excel effectively in their daily analytical tasks, improving accuracy, productivity, and data interpretation in scientific research.

Course Content

• Overview of Excel Interface
• Data Entry and Formatting
• Importing and Exporting Data
• Calculating Key Statistical Parameters
• Using Formulas and Functions
• Creating Graphs for Data Representation
• Trendlines and Calibration Curves
• Introduction to Excel Data Analysis AddIns
• Data Cleaning Techniques
• Outlier Detection in Experimental Data
• Correlation and Covariance Analysis
• Regression Analysis in Analytical Chemistry
• Advanced Curve Fitting
• T-test (Paired and Unpaired)
• Z-test for Large Sample Comparisons
• ANOVA Single Factor & Two Factor (With/Without Replication)
• F-Test Two Samples for Variances

Course Content

1) Basic Tools and Operations of Laboratory Experiments

• handling and care of basic laboratory instruments
• analytical balances, glassware, pH meter, preparation of standard solutions, instrument uncertainty

2) Workplace Safety

• prevention, PPE, waste management, biohazards and chemical waste

3) Data collection and simple statistics

• units of measurements
• significant figures

4) Validation for Instrumental Analysis

• performance characteristics (accuracy, precision, LOD, LOQ, selectivity, sensitivity, bias and variance, linear and dynamic ranges, repeatability, reproducibility, system stability and robustness).

Course Content

• Basic statistics for risk in conformity assessment
• ISO 17025: 2017 requirements on reporting statement of conformity
• Decision rules
• Process and approaches in conformity assessment
• Hypothesis (significance) testing
• Reporting statement of conformity

Course Content

• General QA principles in accreditation
• Introduction to QA and QC for laboratories
• Personnel qualifications and training
• Internal quality audits and quality review
• Reference materials and traceability
• Method validation and verification
• Proficiency testing
• Measurement uncertainty General QC procedures in testing
• Replicate analysis
• Spike recovery analysis with certified references materials
• Instrument performance and calibration
• Use of control charts

*eligible for 10 CEP Points by DOSH

*eligible for 12 CPD Hours by EiMAS

Course Content

Topic 1: Overview of Management of Chemicals

1. Chemicals discovered or made
2. Chemicals used in Industries and laboratories
3. Hazards in the workplace
4. Causes of accident in workplace
5. Chemical health risk assessment
6. Safe management of chemicals

Topic 2: Local Laws & Regulations on Chemical Substances

1. General outlines of Local laws : • Factories & Machinery Act 1967 • Pesticides Act 1994 • Environmental Quality Act 1974 and Regulations 2005 • Poisons Act 1952 and Regulations
2. OSHA 1994 (Occupational Safety and Health Act 1994) a. USECHH Reg.2000 b. Class Regulation

Topic 3: Management of Chemicals – Cradle to Grave concept.

1. Introduction to management of chemicals
2. State the concept of Cradle to Grave:
   i. Manufacturing & Production
   ii. Chemical Purchasing
   iii. Transportation; and vital information on • HAZCHEM code
   iv. Receiving & Internal Transportation
   v. Storage
   vi. Usage and Handling
   vii. Disposal
3. Explain elements of “From the Cradle to the Grave” concept.
4. Explain other control strategies

Topic 4: Overview of Chemical Wastes / Laboratory wastes

1. Introduction
2. Explain the types of waste
3. Environmental issues
4. Definition of hazardous wastes
5. Explain the characteristics of wastes
6. Environmental & health effects of hazardous waste

Topic 5: Local laws & Regulations on Chemical Wastes / Laboratory wastes

1. Waste (Under EQA 1974)
2. Environmental Quality (Industrial Effluent) Regulations 2009
3. Hazardous Waste Management [Under EQ (Scheduled Wastes) Regulations 2005]

Topic 6: Wastes Management

1. Introduction to waste management plan
2. Wastes minimization, source reduction reuse and recycle
3. Types of wastes a. Industrial wastes
4. Storage of Schedule Wastes
5. Industrial Effluent Treatment Systems
   i. Chemical treatment
   ii. Biological treatment
   iii. Anaerobic treatment
6. Waste disposal by:
   i. Incineration of scheduled wastes
   ii. Solidification
   iii. Secure landfill

Course Content

• Sampling Statistics
• General Procedures of Estimation Uncertainties in Chemical Measurements by the GUM & the EURACHEM principles
• Basic Procedures for MU with worked examples and exercises
• Worked examples of MU by component-by-component approach
• Strategy in implementing MU in Chemical Laboratory
• Recent International Development of MU for Chemical Analysis

*eligible for 10 CEP Points by DOSH

*eligible for 12 CPD Hours by EiMAS

Course Content

This two-day intensive training program on “MS 1042:2023 Safety in Laboratory” is designed to provide participants with a comprehensive understanding of the safety standards and best practices in laboratory environments. The course will cover essential aspects of laboratory safety, including hazard identification, risk assessment, safe handling of chemicals, biological safety, fire safety, and emergency response. Participants will gain the knowledge and skills necessary to ensure a safe and compliant laboratory environment, in accordance with the MS 1042:2023 standard.

Course Content

• SAMM Requirements for Internal Audit
• Overview of the Internal Audit Process
• Audit Schedule
• Audit planning
• Development of auditors skills
• Conducting an Audit
• The Audit Report and Follow-up

Course Content

This training brings practical guidance for laboratories to organize interlaboratory comparisons (ILCs)
with a small number of participants (n = 2–7) which is not normally arranged by a proficiency testing
provider. The methodological guideline aims to provide practical approaches following the technical
requirements of organizing a small ILC.
Topics covered:

• ISO 17025 and laboratory accreditation requirements on ILC
• Design of small ILC
• Preparation of test items
• Distribution of ILC test items
• Statistical evaluation of the results
• Participation report

Course Content

• Approaches to method validation
• Performance characteristic of a method
• Documentation and use of method validation data
• Use of method validation data for quantification of measurement uncertainty and conformity assessment

Course Content

• ISO 17025 requirements and SAMM Policy on proficiency testing (PT)
• Organisation of PT schemes
• Statistics in PT performance evaluation
• Root cause analysis for poor performance
• Corrective actions

Course Content

• Introduction to Method Validation
• SAMM Scheme
• Descriptive Statistics
• Outlier Tests – Dixon, Grubb and Cochran
• Standard error of the mean
• Confidence Intervals
• Significance Testing, the Student t-test, F-test, one-way ANOVA, Analysis of Variance, Linear Regression, Standard Curve & its Confidence Intervals, Determination of method’s measurement uncertainty

Course Content

• Introduction
• General requirements
• Structural requirements
• Resource requirements
• Process requirements
• Management systems requirements