Web Application Development, Using SQL Commands to Prepare Public Health Statistics for Students in Bachelor of Science Program in Medical Records
Article Sidebar
Main Article Content
Abstract
This research and development study aimed to 1) The situation, problem, and instructional needs regarding the use of SQL commands in compiling public health statistics. 2) Developing a web application for utilizing SQL commands in compiling public health statistics. 3) Evaluating the effectiveness of the web application's use of SQL commands in compiling public health statistics. The study was divided into 3 steps; 1) Studying the situation, problem, and instructional needs regarding the use of SQL commands in compiling public health statistics, involving 9 students and instructors, 2) Developing the web application for utilizing SQL commands in compiling public health statistics based on the results from Step 1 and expert reviews, 3) Studying the effectiveness of the web application, evaluating by 34 students before and after using the application. The research tool was a knowledge quiz and satisfaction assessment form with the content validity of .67 -1.00 and the reliability KR-20 of 0.80 and Cronbach’s Alpha Coefficient 0.83. The data were analyzed using descriptive statistics and Paired t-test. The results of this study were presented as follows. 1) The problem and instructional needs regarding the use of SQL commands in compiling public health statistics include complexity, requiring both SQL and public health knowledge. The instructional materials need to be engaging, clear, and practical. 2) The web application for using SQL commands in compiling public health statistics. Consists of 3 parts: 1) main page for entering the lesson 2) lessons 3) post-test. 3) After using the web application, there was a significant increase in scores (M=12.52, SD=2.67) compared to before (M=7.26, SD=2.21) at a significance level of p<.001. Satisfaction with the web application was high (M=4.22), particularly regarding content (M=4.31) and design (M=4.18). The research found that the web application effectively improved students' SQL command skills. It provides comprehensive content, easy navigation, and convenient access for learning and reviewing SQL lessons anytime, anywhere.
Article Details
References
Jongburanasit, S. (2019). The use of ADDIE Model for the Improvement and Development of Teaching and Learning Chinese Language to Conform with the Learning in the 21st Century. The 2nd National Conference on humanities and social sciences, 667-679. Faculty of Humanities and Social Sciences, Songkhla Rajabhat University.
Ngamwannakorn, C. (2019). Development of a Learning Application on Mobile Device in English for Information Officer. [Yala Rajabhat University]. https://wb.yru.ac.th/handle/yru/5356
Office of the National Education Commission. (2002). National Education Act B.E. 2542 and Amendments (No. 2) B.E. 2545. https://www.bic.moe.go.th/images/stories/ 5Porobor._2542pdf.pdf
Onthuam, Y. (2019). The organization of data for statistics. Journal of Health Research, 1(1), 61–68.
Phongcharoen, C. (2017). Effects of Using Problem Solving Process with Web Application for Education to Enhance Web Programming Ability in Matthayom 5 Students. [Master of Education, Silpakorn University]. http://ithesis-ir.su.ac.th/dspace/bitstream/123456789/1509/1/58257401.pdf
Prewthaisong, K. (2016). Comparison of Learning Achievement of Undergraduate Mechatronics Engineering Students by Learning Online E-learning Course on Fuzzy Logic. Journal of Thonburi University,10(2), 1-7.
Rattapakdee, N. and Nonsila, J. (2021). Development of a LINE Chat bot for Searching Public Health Statistics Definitions and Formulas of Diploma of Medical Record Students. [Bachelor of Public Health Program in Medical Record, Kanchanabhisek College of Medical and Public Health Technology, Faculty of Public Health and Allied Health Sciences, Praboromarajchanok Institute].
Retrieved from https://human.skru.ac.th/husoconference/conf/P7.pdf
Suwanno, P. (2020). The Development of Application Learning in Educational Research on the Android operating system for fourth year Student Yala Rajabhat. E-Journal of Media Innovation and Creative Education, 3(1), 38-49.