DATA GENERATION FOR THE ACQUISITION OF THE UNIVERSITY COURSES OF INFORMATICS AND STATISTICS IN THE HEALTH CARE SPECIALITIES

Oskars Rasnacs, Maris Vitins

Abstract


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.

 


Keywords


data generation; health care; study courses; university informatics and statistics courses

Full Text:

PDF

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

https://www.researchgate.net/publication/332513460_Solving_Linear_Programming_Problems_By_Using_Excel's_Solver

Tanwi, P., Sashank, M., & Kishwar Hayat, K. (2013). Cholesterol: Genetic, Clinical and Natural Implications. Research Journal of Pharmaceutical, Biological and Chemical Sciences. Retrieved from

https://www.researchgate.net/publication/257429583_Cholesterol_Genetic_Clinical_and_Natural_Implications/link/00b49525440cf8676d000000/download

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




DOI: http://dx.doi.org/10.17770/sie2020vol4.4941

Refbacks

  • There are currently no refbacks.