DATA GENERATION FOR THE ACQUISITION OF THE UNIVERSITY COURSES OF INFORMATICS AND STATISTICS IN THE HEALTH CARE SPECIALITIES
DOI:
https://doi.org/10.17770/sie2020vol4.4941Keywords:
data generation, health care, study courses, university informatics and statistics coursesAbstract
The authors of the present article are investigating the influence of the data generation in the university courses of informatics and statistics (UCIS) on the acquisition of both the UCIS and other study courses in the health care specialities. First of all, the authors inquired students in order to find out their attitude to the UCIS. The inquiry results show evidence that an important role in the acquisition of UCIS has the work/study material – data. The UCIS work/study material can be associated with various branches, including health care. The data of the health care patients are of a special status. Their use is strictly regulated/limited.by legislation. The authors of the present article offer an acceptable solution – data associated with the health care patients are generated from the parameters of statistics of scientific publications. Investigations were performed in the Red Cross Medical College of Rīga Stradiņš University (RCMC of RSU). It was found out that the data generation resulted in higher marks both in UCIS and many other study courses. In this article, the authors present proposals how to generate data comparatively easy, apply traditional MS Excel generation tools as well as tools of Goal Seek and Solver.
References
053. Excel Solver. Retrieved from http://web.mit.edu/15.053/www/Excel_Solver.pdf
An Introduction to Spreadsheet Optimization Using Excel Solver. Retrieved from: http://www.meiss.com/download/Spreadsheet-Optimization-Solver.pdf
Aviñó, L., Ruffini, M., & Gavaldà, R. (2018). Generating Synthetic but Plausible Healthcare Record Datasets. arXiv preprint arXiv:1807.01514.
Chandrakantha, L. (2014). Using Excel Solver In Optimization Problems. ResearchGate. Retrieved from:
https://www.researchgate.net/publication/267557388_USING_EXCEL_SOLVER_IN_OPTIMIZATION_PROBLEMS
Excel Goal Seek Function. Retrieved from: http://www.ce.memphis.edu/1112/notes/excel/Excel_goal_seek.pdf
Ezeokwelume, O.V. (2016). Solving Linear Programming Problems and Transportation Problems using Excel Solver. International Journal of Scientific & Engineering Research, Volume 7, 9. Retrieved from: https://www.ijser.org/researchpaper/Solving-Linear-Programming-Problems-and-Transportation-Problems-using-Excel-Solver.pdf
Guerrero, H. (2010). Excel Data Analysis. Chapter 9 Solver, Scenarios, and Goal Seek Tools. Springer – Verlag Berlin Heidelberg. Retrieved from:
http://jlarrosa.tripod.com/solver.pdf
Hartmane, I., Mikazans, I., Ivdra, I., & Derveniece, A. (2018). Evaluation of Clinical Efficacy and Safety in Treatment of Patients with Moderate and Severe Forms of Psoriasis with Combined Low Dose Methotrexate and Narrow Band UVB Therapy. Rīga Stradiņš University, Collection of Scientific Papers 2017, Research articles in medicine & pharmacy. Retrieved from:
https://www.rsu.lv/sites/default/files/book_download/rsu_research_articles_med_pharm_2017.pdf
Heidemann, B.E., Koopal, C., Bots, M.L., Asselbergs, F.W., Westerink, J., & Visseren, F L.J. (2019). Remnant cholesterol increases the risk for recurrent vascular events independent of LDL-cholesterol in patients with clinical manifest vascular disease. European Heart Journal, 40, Issue Supplement_1. DOI: https://doi.org/10.1093/eurheartj/ehz746.0013
Janssen I.J. & Dundurs J. (2018). Influence of Noise in Ambulance Vehicles on Emergency Service Personnel in North Germany and Latvia. Rīga Stradiņš University, Collection of Scientific Papers 2017, Research articles in medicine & pharmacy. Retrieved from: https://www.rsu.lv/sites/default/files/book_download/rsu_research_articles_med_pharm_2017.pdf
Kalnina, L., Selga, G., Sauka, M., & Larins ,V. (2018). Assessment of Fat Mass Index and Fat-Free Mass Index in Young Athletes. Rīga Stradiņš University, Collection of Scientific Papers 2017, Research articles in medicine & pharmacy. Retrieved from https://www.rsu.lv/sites/default/files/book_download/rsu_research_articles_med_pharm_2017.pdf
Mickevica, E., Margaliks, M., & Mamaja, B. (2018). Safety and Efficacy of Narcotrend Controlled Sedation with Dexmedetomidine vs. Propofol during Elective Colonoscopy. Rīga Stradiņš University, Collection of Scientific Papers 2017, Research articles in medicine & pharmacy. Retrieved from https://www.rsu.lv/sites/default/files/book_download/rsu_research_articles_med_pharm_2017.pdf
Nelson, L.S. & Nelson, E.C. (2014). Excel Data Analysis for Dummies. Retrieved from: http://excelpro.ir/wp-content/uploads/2015/12/Excel-Data-Analysis-for-Dummies.pdf
Saleh, S.A. & Latif, T.I. (2008). Solving Linear Programming Problems By Using Excel’s Solver. ResearchGate. Retrieved from
Tanwi, P., Sashank, M., & Kishwar Hayat, K. (2013). Cholesterol: Genetic, Clinical and Natural Implications. Research Journal of Pharmaceutical, Biological and Chemical Sciences. Retrieved from
Wray, B. (2015). Excel Solver Tutorial: Wilmington Wood Products. Gebauer/Matthews: MIS 213 Hands-on Tutorials and Cases, Spring. Retrieved from: http://csbapp.uncw.edu/sibonac/mis313/docs/project10.pdf