Lab Data & Quality
Keep trustworthy lab records, query LIMS data, run QC with Westgard rules, build calibration curves, estimate uncertainty, and work within SOPs, CAPA and accreditation.
Leads to: Biochemist, Biological Technician, Medical Laboratory Technologist, Chemist, Materials Scientist
Before you start
This course builds on Lab Techniques & Instrumentation, Statistics Fundamentals and Spreadsheets for Data Work. Take them first if you are new to the topic.
About this course
An intermediate course for future biochemists, biological technicians, medical laboratory technologists, chemists and materials scientists, about the data and quality systems that make lab results trustworthy. The first module covers records and integrity: writing ALCOA+ notebook entries, how a sample moves through a LIMS or LIS, and querying sample results by batch and date in SQL. The second module covers quality control: Levey-Jennings charts and Westgard rules, calibration curves with LOD and LOQ, and propagating measurement uncertainty. The third module covers quality systems: SOPs, deviations and CAPA, audits and accreditation (ISO/IEC 17025, ISO 15189, CLIA, CAP, GMP and GLP), and deciding when a result may be rejected or repeated. Python and SQL activities are fill-in-the-blank and use only the standard library and SQLite, so no programming background is needed. Every activity is a paper or data exercise. Real lab quality work also depends on supervised training and formal credentials, such as a NAACLS-accredited program and ASCP certification for medical laboratory scientists, and on-the-job GMP training in regulated manufacturing.
Course content
Module 1
Records and Integrity
3 lessons · 1h 39mWrite ALCOA+ notebook entries, trace samples through a LIMS or LIS, and query sample results in SQL.
- 47mLab notebooks and ELNsReading
Write a complete, ALCOA+-compliant notebook entry and know what an electronic lab notebook adds.
- 15mLIMS and LISReading
Trace a sample through a LIMS or LIS, from request and accessioning to review, reporting and storage.
- 37mQuerying sample dataReading
Query lab results by sample, batch and date with SELECT, WHERE, JOIN and GROUP BY.
Module 2
Quality Control
3 lessons · 1h 47mFlag runs with Westgard rules, fit calibration curves with LOD and LOQ, and propagate measurement uncertainty.
- 42mQC charts and Westgard rulesReading
Plot QC on a Levey-Jennings chart and flag runs that break Westgard rules.
- 35mCalibration curvesReading
Fit a calibration curve, check its residuals, and compute the limit of detection and limit of quantitation.
- 30mMeasurement uncertaintyReading
Estimate standard uncertainties and propagate them through a calculation to an expanded uncertainty.
Module 3
Quality Systems
3 lessons · 1h 28mWork within SOPs, write deviations and CAPA, understand audits and accreditation, and handle outliers and repeat testing.
- 48mSOPs, deviations, CAPAReading
Follow controlled SOPs, write a clear deviation report and plan corrective and preventive actions.
- 17mAudits and accreditationReading
Explain ISO/IEC 17025, ISO 15189, CLIA, CAP and GMP audits, and how proficiency testing works.
- 23mOutliers and repeat testingReading
Decide when a result may be rejected, use the Grubbs test correctly, and apply predefined repeat-testing rules.