Online forms and spreadsheet as means to support quality measurement by the SERVQUAL method

• Autorzy: Szczęśniak Bartosz

Identyfikatory

DOI

10.29119/1641-3466.2022.161.19

• Języki publikacji: EN

Abstrakty

EN

Purpose: The main purpose of the research is to devise and present a concept for a solution enabling integration of popular off-the-shelf online forms with a tool aligned with the MiRel concept used for quality measurement by application of the SERQUAL method. Design/methodology/approach: The analysis performed by the author comprised various possibilities of using standard features of popular online forms to store data for purposes of the SERVQUAL method. This involved identification of several potential layouts of the master table where the answers previously received are kept. The analysis concerned the data structure applied in the tool designed, as proposed in the literature, in accordance with the MiRel concept, to support the method in question. The elements identified in this structure were the attributes whose values should be entered directly and manually in tables as well as those whose values should be added automatically on the basis of the answers previously received. Solutions were developed to enable automatic data migration from the master table to the tool’s respective tables. Findings: The data required for purposes of the SERVQUAL analysis, supported by a tool created in a spreadsheet according to the MiRel concept, can be successfully stored by means of commonly available online forms. What proves to be problematic is the impossibility of verifying the correctness of the answers in terms of the relevance of individual dimensions, yet in this respect both the verification and potential adjustment of the answers received can be inherent in the mechanism responsible for data migration from the master table to the tool’s tables. A fully functional solution enabling data to be retrieved from the master table and moved to the tool’s tables can be developed using built-in spreadsheet features only, without the need for any code created in any programming language. Practical implications The solution proposed in the paper can be used in practice when measuring quality using the SERVQUAL method. Originality/value: The concept described in the paper is the author’s original solution.

Słowa kluczowe

EN

spreadsheet; database; MiRel; data processing; quality management

PL

arkusz; baza danych; MiRel; przetwarzanie danych; zarządzanie jakością

• Wydawca: Wydawnictwo Politechniki Śląskiej
• Czasopismo: Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska
• Rocznik: 2022
• Tom: z. 161
• Strony: 273--281
• Opis fizyczny: Bibliogr. 22 poz.

Twórcy

autor

Szczęśniak Bartosz

• Silesian University of Technology, Faculty of Organization and Management, Institute of Economics and Informatics

• https://orcid.org/0000-0002-9683-4629

Bibliografia

• 1. Aghamolaei, T., Zare, S. (2008). Quality gap of educational services in viewpoints of students in Hormozgan University of medical sciences. BMC Medical Education, Vol. 8(34).
• 2. Carlberg, C. (2009). Microsoft Excel 2007 PL. Analizy biznesowe. Rozwiązania w biznesie. Gliwice: Helion.
• 3. Chatzoglou, P., Chatzoudes, D., Vraimaki, E., Leivaditou, E. (2014). Measuring Citizen Satisfaction Using the SERVQUAL Approach: The Case of the ‘Hellenic Post’. Procedia Economics and Finance, Vol. 9, pp. 349-360.
• 4. Dalrymple, J., Donnelly, M., Wisniewski, M., Curry, A. (1995). Measuring service quality in local government. In: G. Kanji (Ed.), Total Quality Management. Dordrecht: Springer.
• 5. de la Cruz del Río Rama, M., García, J.Á., Rueda-Armengot, C., Pérez, J.L.C. (2014). An Application of SERVQUAL Model in Termas of Chaves. In: M. Peris-Ortiz, J. Álvarez- García (Eds.), Action-Based Quality Management. Cham: Springer.
• 6. Knight, G. (2006). Analyzing Business Data with Excel. Sebastopol: O'Reilly Media.
• 7. Luke, R., Heyns, G. (2020). An analysis of the quality of public transport in Johannesburg, South Africa using an adapted SERVQUAL model. Transportation Research Procedia, Vol. 48, pp. 3562-3576.
• 8. Nowacki, M. (2005). Evaluating a museum as a tourist product using the servqual method. Museum Management and Curatorship, Vol. 20, pp. 235-250.
• 9. Pakdil, F., Aydın, Ö. (2007). Expectations and perceptions in airline services: An analysis using weighted SERVQUAL scores. Journal of Air Transport Management, Vol. 13(4), pp. 229-237.
• 10. Parasuraman, A., Zeithaml, V., Berry, L. (1985). A conceptual model of service quality and its implications for future research. Journal of Marketing, Vol. 49, pp. 41-50.
• 11. Parasuraman, A., Zeithaml, V., Berry, L. (1988). SERVQUAL: A multiple item scale for measuring consumer perceptions of service quality. Journal of Retailing, Vol. 64(1), pp. 12-40.
• 12. Pradela, A. (2015). Quality of Graduates’ Preparation for Labour Market - A ServQual Analysis. Procedia - Social and Behavioral Sciences, Vol. 174, pp. 1671-1677.
• 13. Szczęśniak, B. (2010). Zastosowanie arkusza kalkulacyjnego do wspomagania metody ABC. Zeszyty Naukowe Politechniki Śląskiej, seria Organizacja i Zarządzanie, Vol. 50, pp. 23-33.
• 14. Szczęśniak, B. (2017). Microtools Based on the Relational Data Model - representation of entities in a spreadsheet. 17th International Multidisciplinary Scientific GeoConference SGEM 2017, 17(21), ISBN: 978-619-7408-01-0, 29 June - 5 July, Albena, Bulgaria, pp. 447-454.
• 15. Szczęśniak, B. (2018a). Microtools Based On The Relational Data Model - transition from type II to type I of entity representation. 18th International Multidisciplinary Scientific GeoConference SGEM 2018, 18(2.1), ISBN: 978-619-7408-39-3, 02-08 July, Albena, Bulgaria, pp. 553-560.
• 16. Szczęśniak, B. (2018b). Microtools based on the relational data model - conformity between foreign and primary keys. XV International Conference Multidisciplinary Aspects of Production Engineering (MAPE), 1(1), ISBN: 978-83-65265-25-8, 5-8 September, Zawiercie, Poland, pp. 491-497.
• 17. Szczęśniak, B. (2020a). Microtools based on the relational data model for improvement of information processes - multiplicity of relationships, and mandatory nature of relationships and attributes. In: K.S. Soliman (Ed.), Education Excellence and Innovation Management: a 2025 Vision to Sustain Economic Development during Global Challenges. Proceedings of the 35th International Business Information Management Association Conference (IBIMA), 1-2 April 2020 Seville, Spain, pp. 10537-10544.
• 18. Szczęśniak, B. (2020b). A spreadsheet to support the Suzuki ABCD method. Scientific Papers Of Silesian University Of Technology, Organization And Management Series, Vol. 142, pp. 205-2016.
• 19. Szczęśniak, B. (2021). MiRel concept-conforming tool for supporting service quality measurement by the SERVQUAL method. In: K.S. Soliman (Ed.), Innovation management and information technology impact on global economy in the era of pandemic. Proceedings of the 37th International Business Information Management Association Conference (IBIMA), 30-31 May 2021, Cordoba, Spain, pp. 12207-12218.
• 20. Szczęśniak, B., Molenda, M. (2013). Spreadsheet application supporting the x-r control chart. Conference Proceedings of the 22th Conference Modern Mathematical Methods in Engineering (3mi), ISBN: 978-80-248-3234-0, June 3-5, Horni Lomna, Czech Republic, pp. 128-134.
• 21. Ulewicz, R. (2014). Application of servqual method for evaluation of quality of educational services at the university of higher education. Polish Journal of Management Studies, Vol. 9, pp. 254-264.
• 22. Zeithaml, V., Parasuraman, A., Berry, L. (1990). Delivering quality service. New York: The Free Press.

Uwagi

PL

Opracowanie rekordu ze środków MEiN, umowa nr SONP/SP/546092/2022 w ramach programu "Społeczna odpowiedzialność nauki" - moduł: Popularyzacja nauki i promocja sportu (2022-2023).