A Review of Internal Quality Control Data Management in Clinical Biochemistry Laboratory Using Microsoft Excel

Authors

  • Sunmeet Matkar Senior Executive, Arbor Biotech Research Ltd, Mumbai, Maharashtra, India. http://orcid.org/0000-0003-4201-1923
  • Akshay Matkar Senior Software Developer, Datamatics Global Services Limited, Mumbai, Maharashtra, India.
  • Pratibha Varpe Assistant Professor, D. G. Ruparel College of Arts, Science and Commerce, Mumbai, Maharashtra, India

Keywords:

Quality, IQC, Microsoft Excel, Software, Z score

Abstract

Background: A clinical biochemistry laboratory generates large quantity of numerical data due to implementation of Internal Quality Control (IQC). Aim: To develop a simple procedure for management of IQC data in a clinical biochemistry laboratory.

Methodology: Microsoft Excel (version 2013) was used to design a proforma comprising tabular and graphical components to handle IQC data. This proforma was used to record values of control sera, convert them into z scores and represent them on a Levy-Jennings (LJ) chart for ease of interpretation. Other methods of IQC data management were reviewed and a comparison was drawn between all methods.

Results: Review of various methods of managing IQC data reveal that the current method is most suitable for laboratories using multiple instruments and multiple levels of controls.

Conclusion: IQC data could be effectively managed using the Microsoft Excel software due to its ability perform calculations and represent data graphically.

How to cite this article: Matkar S, Matkar A, Varpe P. A Review of Internal Quality Control Data Management in Clinical Biochemistry Laboratory Using Microsoft Excel. J Adv Res Qual Control Mgmt 2017; 2(2): 1-5. 

References

1. Lock R J, My Approach to Internal Quality Control in a Clinical Immunology Laboratory, J Clin Pathol. 2006; 59(7): 681–684.
2. Kinns H, Pitkin S, Housley D, Freedman DB, Internal quality control: Best Practice, J Clin Pathol. 2013; 66(12):1027-32.
3. Teitz NW. (1999). Teitz Textbook of Clinical Chemistry, 3rd Edition, WB Saunders: 384-418.
4. Kringle RO, Bogovich M. (1999). Textbook of Clinical Chemistry 3rd Edition WB Saunders: 265-309.
5. Tata Memorial Centre, Hematopathology Department, Proceedings HPC 2010, and Statistical Quality Control. (Accessed March 2015).
6. Laboratory Automated Quality Control Systems, (Accessed March 2015) .

Published

2017-09-14

How to Cite

Matkar, S., Matkar, A., & Varpe, P. (2017). A Review of Internal Quality Control Data Management in Clinical Biochemistry Laboratory Using Microsoft Excel. Journal of Advanced Research in Quality Control & Management, 2(2), 1-5. Retrieved from https://adrjournalshouse.com/index.php/Journal-QualityControl-Mgt/article/view/719