A Review of Internal Quality Control Data Management in Clinical Biochemistry Laboratory Using Microsoft Excel
Keywords:
Quality, IQC, Microsoft Excel, Software, Z scoreAbstract
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
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) .
