scholarly journals Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway

2020 ◽  
Author(s):  
Frances Gunn ◽  
Janice Miller ◽  
Malcolm G Dunlop ◽  
Farhat V N Din ◽  
Yasuko Maeda
Keyword(s):  
Colorectal Cancer ◽  
Data Management ◽  
Management System ◽  
Data Entry ◽  
Large Data ◽  
Data Monitoring ◽  
Data Management System ◽  
Volume Data ◽  
Direct Data ◽  
User Friendly

AbstractPurposeThe COVID-19 pandemic posed an unprecedented challenge to healthcare systems around the world. To mitigate the risks of those referred with possible colorectal cancer during the pandemic we implemented a clinical pathway which required a customised data management system for robust operation. Here, we describe the principal concepts and evaluation of the performance of a spreadsheet-based data management system.MethodsA system was developed using Microsoft Excel® 2007 aiming to retain the spreadsheets inherent intuitiveness of direct data entry. Data was itemised limiting entry errors. Visual Basic for Applications (VBA) was used to construct a user-friendly interface to enhance efficiency of data entry and segregate the data required for operational tasks. This was done with built-in loop-back data entry. Finally data derivation and analysis was performed to facilitate pathway monitoring.ResultsFor a pathway which required rapid implementation and development of a customised data management system, the use of a spreadsheet was advantageous due to its user-friendly direct data entry capability. Its function was enhanced by UserForm and large data handling by data segregation using VBA macros. Data validation and conditional formatting minimised data entry errors. Computation by the COUNT function facilitated live data monitoring on a dashboard. During the three months the pathway ran for, the system processed 36 nodal data points for each of the included 837 patients. Data monitoring confirmed its accuracy.ConclusionLarge volume data management using a spreadsheet system is possible with appropriate data definition and VBA programmed data segregation. Clinicians’ regular input and optimisation made the system adaptable for rapid implementation.

scholarly journals Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway

2021 ◽  
Vol 28 (1) ◽  
pp. e100307
Author(s):  
Janice Miller ◽  
Frances Gunn ◽  
Malcolm G Dunlop ◽  
Farhat VN Din ◽  
Yasuko Maeda
Keyword(s):  
Colorectal Cancer ◽  
Data Management ◽  
Management System ◽  
Data Entry ◽  
Large Data ◽  
Data Management System ◽  
Volume Data ◽  
Visual Basic For Applications ◽  
Resource Limited ◽  
Data Definition

ObjectivesA customised data management system was required for a rapidly implemented COVID-19-adapted colorectal cancer pathway in order to mitigate the risks of delayed and missed diagnoses during the pandemic. We assessed its performance and robustness.MethodsA system was developed using Microsoft Excel (2007) to retain the spreadsheets’ intuitiveness of direct data entry. Visual Basic for Applications (VBA) was used to construct a user-friendly interface to enhance efficiency of data entry and segregate the data for operational tasks.ResultsLarge data segregation was possible using VBA macros. Data validation and conditional formatting minimised data entry errors. Computation by the COUNT function facilitated live data monitoring.ConclusionIt is possible to rapidly implement a makeshift database system with clinicians’ regular input. Large-volume data management using a spreadsheet system is possible with appropriate data definition and VBA-programmed data segregation. The described concept is applicable to any data management system construction requiring speed and flexibility in a resource-limited situation.

scholarly journals Developing a Strategy for Imputing Missing Traffic Volume Data

2010 ◽  
Author(s):  
Mei Chen ◽  
Jingxin Xia ◽  
Rongfang (Rachel) Liu
Keyword(s):  
Data Management ◽  
Management System ◽  
Implementation Strategy ◽  
Traffic Volume ◽  
Data Management System ◽  
Volume Data ◽  
Potential Resource ◽  
Transportation Applications ◽  
Archive Data

Archived ITS-generated data can provide a potential resource for many long-term transportation applications. However, missing and suspicious data are inevitable due to detector and communication malfunctions. This paper presents a comparative analysis of various techniques for imputing missing traffic volume data in the archived data management system in Kentucky. The applicability of the techniques, as well as their reliability in terms of data requirement, is also discussed. An implementation strategy for the Kentucky archive data management system is then developed based on the performance and the applicability/reliability analyses.

scholarly journals G3DMS: Design and Implementation of a Data Management System for the Diagnosis of Genetic Disorders

Healthcare ◽  
2020 ◽  
Vol 8 (3) ◽  
pp. 196 ◽  
Author(s):  
Halima Samra ◽  
Alice Li ◽  
Ben Soh
Keyword(s):  
Data Management ◽  
Health Information ◽  
Management System ◽  
Design Method ◽  
Genetic Disorders ◽  
Genetic Diseases ◽  
Genetic Research ◽  
Health Information System ◽  
Data Entry ◽  
Data Management System

Current health information systems used in genetic research centers and clinics in the Kingdom of Saudi Arabia have failed to enable researchers and health care physicians to utilize genetic and clinical data in their research. In this paper, we aim to design and implement a Genetic Disorders Diagnosis Data Management System (G3DMS) to support clinicians in the process of diagnosing genetic diseases and conducting genetic studies. A case study was undertaken to analyze a health information system in Saudi to understand its design problems via a brainstorming method. We then used the Barker’s system design method and a prototype to validate our proposed system via usability testing. This research has resulted in the development of the G3DMS that comprises: electronic data-capture forms for data entry; a customized query builder to display and modify patient data as well as form research queries; a module that allows historical data to be uploaded in the form of bulk data using a template; export data options to Excel and JavaScript Object Notation (JSON) format; and authorization access for healthcare researchers and clinicians. The G3DMS was implemented in the Princess Al-Jawhara Center of Excellence in Research of Hereditary Disorders, Jeddah, KSA.

scholarly journals IntelliEppi: Intelligent reaction monitoring and holistic data management system for the molecular biology lab

2017 ◽  
Author(s):  
Arthur Neuberger ◽  
Zeeshan Ahmed ◽  
Thomas Dandekar
Keyword(s):  
Molecular Biology ◽  
Data Management ◽  
Management System ◽  
Relevant Information ◽  
Data Management System ◽  
Reaction Monitoring ◽  
Direct Tracking ◽  
2D Data ◽  
User Friendly ◽  
Biology Lab

AbstractDaily alterations of routines and protocols create high, yet so far unmet demands for intelligent reaction monitoring, quality control and data management in molecular biology laboratories. To meet such needs, the “internet of things” is implemented here. We propose an approach which combines direct tracking of lab tubes, reactions and racks with a comprehensive data management system. Reagent tubes in this system are tagged with 2D data matrices or imprinted RFID-chips using a unique identification number. For each tube, individual content and all relevant information based on conducted experimental procedures are stored in an experimental data management system. This information is managed automatically but allow scientists to engage and interfere via user-friendly graphical interface. Tagged tubes are used in connection with a detectable RFID-tagged rack. We show that reaction protocols, HTS storage and complex reactions are easily planned and controlled.

Risk Management on Information Security in ABC Company

2017 ◽  
Vol 4 (1) ◽  
pp. 62-66
Author(s):  
Luyen Ha Nam
Keyword(s):  
Risk Management ◽  
Information Security ◽  
Data Management ◽  
Management System ◽  
Risk Mitigation ◽  
Data Management System ◽  
Data Centre ◽  
Long Time ◽  
Mitigation Action ◽  
Better Than

From long, long time ago until nowadays information still takes a serious position for all aspect of life, fromindividual to organization. In ABC company information is somewhat very sensitive, very important. But how wekeep our information safe, well we have many ways to do that: in hard drive, removable disc etc. with otherorganizations they even have data centre to save their information. The objective of information security is to keep information safe from unwanted access. We applied Risk Mitigation Action framework on our data management system and after several months we have a result far better than before we use it: information more secure, quickly detect incidents, improve internal and external collaboration etc.

Sign in / Sign up

Export Citation Format

Share Document