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

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...

Full description

Saved in:
Bibliographic Details
Published in:BMJ health & care informatics 2021-07, Vol.28 (1), p.e100307
Main Authors: Miller, Janice, Gunn, Frances, Dunlop, Malcolm G, Din, Farhat VN, Maeda, Yasuko
Format: Article
Language:English
Subjects:
Colorectal cancer
Colorectal Neoplasms - prevention & control
Coronaviruses
COVID-19
Critical Pathways
Data entry
Data Management
Databases, Factual
Early Detection of Cancer
Health informatics
Humans
Implementer Report
Pandemics
Patients
Software
Time Factors
User-Computer Interface
Citations: Items that this one cites
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by
cites cdi_FETCH-LOGICAL-b524t-cf5a3b29496c48290a63a216fa4ec47fa14e69de4d49794e29a031219626d6443
container_end_page
container_issue 1
container_start_page e100307
container_title BMJ health & care informatics
container_volume 28
creator Miller, Janice
Gunn, Frances
Dunlop, Malcolm G
Din, Farhat VN
Maeda, Yasuko
description 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.
doi_str_mv 10.1136/bmjhci-2020-100307
format article
fullrecord <record><control><sourceid>proquest_doaj_</sourceid><recordid>TN_cdi_doaj_primary_oai_doaj_org_article_c5ca55d7dc2848d4a54dfe4a2b71a033</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><doaj_id>oai_doaj_org_article_c5ca55d7dc2848d4a54dfe4a2b71a033</doaj_id><sourcerecordid>2583081118</sourcerecordid><originalsourceid>FETCH-LOGICAL-b524t-cf5a3b29496c48290a63a216fa4ec47fa14e69de4d49794e29a031219626d6443</originalsourceid><addsrcrecordid>eNqNkk1v1DAQhiMEolXpH-CAInHhktbfiS9IaMvHSpV6Aa7WxJ7sZpXEwU5a7b_H25Sl7QFx8th-3lczozfL3lJyQSlXl3W_29q2YISRghLCSfkiO2WKs8NNv3xUn2TnMe4IIYwJoXj5OjvhIpW0rE4ze4W32Pmxx2HKfZNDbuc4-b6N6HIHE-Q9DLDB-_-4jxP2eeND4lY3P9dXBdUFOBinRFvf-YB2gi63MFgM-QjT9g72b7JXDXQRzx_Os-zHl8_fV9-K65uv69Wn66KWTEyFbSTwmmmhlRUV0wQUB0ZVAwKtKBugApV2KJzQpRbINBBOGdWKKaeE4GfZevF1HnZmDG0PYW88tOb-wYeNgTC1tkNjpQUpXeksq0TlBEjhGhTA6pImV568Pi5e41z36GwaP0D3xPTpz9BuzcbfmoqVkkuVDD48GAT_a8Y4mbRTi10HA_o5GiYlYUrIkiX0_TN05-cwpFUlquKkopRWiWILZYOPMWBzbIYSc4iEWSJhDpEwSySS6N3jMY6SPwFIQLEASfx_hhd_-WOb_xD8BtKezs0</addsrcrecordid><sourcetype>Open Website</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>2583081118</pqid></control><display><type>article</type><title>Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway</title><source>BMJ Open Access Journals</source><source>Open Access: PubMed Central</source><creator>Miller, Janice ; Gunn, Frances ; Dunlop, Malcolm G ; Din, Farhat VN ; Maeda, Yasuko</creator><creatorcontrib>Miller, Janice ; Gunn, Frances ; Dunlop, Malcolm G ; Din, Farhat VN ; Maeda, Yasuko</creatorcontrib><description>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.</description><identifier>ISSN: 2632-1009</identifier><identifier>EISSN: 2632-1009</identifier><identifier>DOI: 10.1136/bmjhci-2020-100307</identifier><identifier>PMID: 34244178</identifier><language>eng</language><publisher>England: BMJ Publishing Group Ltd</publisher><subject>Colorectal cancer ; Colorectal Neoplasms - prevention &amp; control ; Coronaviruses ; COVID-19 ; Critical Pathways ; Data entry ; Data Management ; Databases, Factual ; Early Detection of Cancer ; Health informatics ; Humans ; Implementer Report ; Pandemics ; Patients ; Software ; Time Factors ; User-Computer Interface</subject><ispartof>BMJ health &amp; care informatics, 2021-07, Vol.28 (1), p.e100307</ispartof><rights>Author(s) (or their employer(s)) 2021. Re-use permitted under CC BY-NC. No commercial re-use. See rights and permissions. Published by BMJ.</rights><rights>2021 Author(s) (or their employer(s)) 2021. Re-use permitted under CC BY-NC. No commercial re-use. See rights and permissions. Published by BMJ. http://creativecommons.org/licenses/by-nc/4.0/ This is an open access article distributed in accordance with the Creative Commons Attribution Non Commercial (CC BY-NC 4.0) license, which permits others to distribute, remix, adapt, build upon this work non-commercially, and license their derivative works on different terms, provided the original work is properly cited, appropriate credit is given, any changes made indicated, and the use is non-commercial. See: http://creativecommons.org/licenses/by-nc/4.0/ . Notwithstanding the ProQuest Terms and Conditions, you may use this content in accordance with the terms of the License.</rights><rights>Author(s) (or their employer(s)) 2021. Re-use permitted under CC BY-NC. No commercial re-use. See rights and permissions. Published by BMJ. 2021</rights><lds50>peer_reviewed</lds50><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed><cites>FETCH-LOGICAL-b524t-cf5a3b29496c48290a63a216fa4ec47fa14e69de4d49794e29a031219626d6443</cites><orcidid>0000-0002-0119-7736</orcidid></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://informatics.bmj.com/content/28/1/e100307.full.pdf$$EPDF$$P50$$Gbmj$$Hfree_for_read</linktopdf><linktohtml>$$Uhttps://informatics.bmj.com/content/28/1/e100307.full$$EHTML$$P50$$Gbmj$$Hfree_for_read</linktohtml><link.rule.ids>230,314,727,780,784,885,27549,27550,27924,27925,53791,53793,55350,77601,77632,77660,77686</link.rule.ids><backlink>$$Uhttps://www.ncbi.nlm.nih.gov/pubmed/34244178$$D View this record in MEDLINE/PubMed$$Hfree_for_read</backlink></links><search><creatorcontrib>Miller, Janice</creatorcontrib><creatorcontrib>Gunn, Frances</creatorcontrib><creatorcontrib>Dunlop, Malcolm G</creatorcontrib><creatorcontrib>Din, Farhat VN</creatorcontrib><creatorcontrib>Maeda, Yasuko</creatorcontrib><title>Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway</title><title>BMJ health &amp; care informatics</title><addtitle>BMJ Health Care Inform</addtitle><addtitle>BMJ Health Care Inform</addtitle><description>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.</description><subject>Colorectal cancer</subject><subject>Colorectal Neoplasms - prevention &amp; control</subject><subject>Coronaviruses</subject><subject>COVID-19</subject><subject>Critical Pathways</subject><subject>Data entry</subject><subject>Data Management</subject><subject>Databases, Factual</subject><subject>Early Detection of Cancer</subject><subject>Health informatics</subject><subject>Humans</subject><subject>Implementer Report</subject><subject>Pandemics</subject><subject>Patients</subject><subject>Software</subject><subject>Time Factors</subject><subject>User-Computer Interface</subject><issn>2632-1009</issn><issn>2632-1009</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2021</creationdate><recordtype>article</recordtype><sourceid>9YT</sourceid><sourceid>DOA</sourceid><recordid>eNqNkk1v1DAQhiMEolXpH-CAInHhktbfiS9IaMvHSpV6Aa7WxJ7sZpXEwU5a7b_H25Sl7QFx8th-3lczozfL3lJyQSlXl3W_29q2YISRghLCSfkiO2WKs8NNv3xUn2TnMe4IIYwJoXj5OjvhIpW0rE4ze4W32Pmxx2HKfZNDbuc4-b6N6HIHE-Q9DLDB-_-4jxP2eeND4lY3P9dXBdUFOBinRFvf-YB2gi63MFgM-QjT9g72b7JXDXQRzx_Os-zHl8_fV9-K65uv69Wn66KWTEyFbSTwmmmhlRUV0wQUB0ZVAwKtKBugApV2KJzQpRbINBBOGdWKKaeE4GfZevF1HnZmDG0PYW88tOb-wYeNgTC1tkNjpQUpXeksq0TlBEjhGhTA6pImV568Pi5e41z36GwaP0D3xPTpz9BuzcbfmoqVkkuVDD48GAT_a8Y4mbRTi10HA_o5GiYlYUrIkiX0_TN05-cwpFUlquKkopRWiWILZYOPMWBzbIYSc4iEWSJhDpEwSySS6N3jMY6SPwFIQLEASfx_hhd_-WOb_xD8BtKezs0</recordid><startdate>20210709</startdate><enddate>20210709</enddate><creator>Miller, Janice</creator><creator>Gunn, Frances</creator><creator>Dunlop, Malcolm G</creator><creator>Din, Farhat VN</creator><creator>Maeda, Yasuko</creator><general>BMJ Publishing Group Ltd</general><general>BMJ Publishing Group LTD</general><general>BMJ Publishing Group</general><scope>9YT</scope><scope>ACMMV</scope><scope>CGR</scope><scope>CUY</scope><scope>CVF</scope><scope>ECM</scope><scope>EIF</scope><scope>NPM</scope><scope>AAYXX</scope><scope>CITATION</scope><scope>3V.</scope><scope>7RV</scope><scope>7X7</scope><scope>7XB</scope><scope>88C</scope><scope>8C1</scope><scope>8FI</scope><scope>8FJ</scope><scope>8FK</scope><scope>ABUWG</scope><scope>AFKRA</scope><scope>BENPR</scope><scope>CCPQU</scope><scope>FYUFA</scope><scope>GHDGH</scope><scope>K9.</scope><scope>KB0</scope><scope>M0S</scope><scope>M0T</scope><scope>NAPCQ</scope><scope>PQEST</scope><scope>PQQKQ</scope><scope>PQUKI</scope><scope>PRINS</scope><scope>7X8</scope><scope>5PM</scope><scope>DOA</scope><orcidid>https://orcid.org/0000-0002-0119-7736</orcidid></search><sort><creationdate>20210709</creationdate><title>Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway</title><author>Miller, Janice ; Gunn, Frances ; Dunlop, Malcolm G ; Din, Farhat VN ; Maeda, Yasuko</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-b524t-cf5a3b29496c48290a63a216fa4ec47fa14e69de4d49794e29a031219626d6443</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2021</creationdate><topic>Colorectal cancer</topic><topic>Colorectal Neoplasms - prevention &amp; control</topic><topic>Coronaviruses</topic><topic>COVID-19</topic><topic>Critical Pathways</topic><topic>Data entry</topic><topic>Data Management</topic><topic>Databases, Factual</topic><topic>Early Detection of Cancer</topic><topic>Health informatics</topic><topic>Humans</topic><topic>Implementer Report</topic><topic>Pandemics</topic><topic>Patients</topic><topic>Software</topic><topic>Time Factors</topic><topic>User-Computer Interface</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Miller, Janice</creatorcontrib><creatorcontrib>Gunn, Frances</creatorcontrib><creatorcontrib>Dunlop, Malcolm G</creatorcontrib><creatorcontrib>Din, Farhat VN</creatorcontrib><creatorcontrib>Maeda, Yasuko</creatorcontrib><collection>BMJ Open Access Journals</collection><collection>BMJ Journals:Open Access</collection><collection>Medline</collection><collection>MEDLINE</collection><collection>MEDLINE (Ovid)</collection><collection>MEDLINE</collection><collection>MEDLINE</collection><collection>PubMed</collection><collection>CrossRef</collection><collection>ProQuest Central (Corporate)</collection><collection>ProQuest Nursing &amp; Allied Health Database</collection><collection>ProQuest Health &amp; Medical Collection</collection><collection>ProQuest Central (purchase pre-March 2016)</collection><collection>Healthcare Administration Database (Alumni)</collection><collection>Public Health Database</collection><collection>Hospital Premium Collection</collection><collection>Hospital Premium Collection (Alumni Edition)</collection><collection>ProQuest Central (Alumni) (purchase pre-March 2016)</collection><collection>ProQuest Central (Alumni)</collection><collection>ProQuest Central</collection><collection>ProQuest Central</collection><collection>ProQuest One Community College</collection><collection>Health Research Premium Collection</collection><collection>Health Research Premium Collection (Alumni)</collection><collection>ProQuest Health &amp; Medical Complete (Alumni)</collection><collection>Nursing &amp; Allied Health Database (Alumni Edition)</collection><collection>Health &amp; Medical Collection (Alumni Edition)</collection><collection>Healthcare Administration Database</collection><collection>Nursing &amp; Allied Health Premium</collection><collection>ProQuest One Academic Eastern Edition (DO NOT USE)</collection><collection>ProQuest One Academic</collection><collection>ProQuest One Academic UKI Edition</collection><collection>ProQuest Central China</collection><collection>MEDLINE - Academic</collection><collection>PubMed Central (Full Participant titles)</collection><collection>DOAJ Directory of Open Access Journals</collection><jtitle>BMJ health &amp; care informatics</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Miller, Janice</au><au>Gunn, Frances</au><au>Dunlop, Malcolm G</au><au>Din, Farhat VN</au><au>Maeda, Yasuko</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway</atitle><jtitle>BMJ health &amp; care informatics</jtitle><stitle>BMJ Health Care Inform</stitle><addtitle>BMJ Health Care Inform</addtitle><date>2021-07-09</date><risdate>2021</risdate><volume>28</volume><issue>1</issue><spage>e100307</spage><pages>e100307-</pages><issn>2632-1009</issn><eissn>2632-1009</eissn><abstract>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.</abstract><cop>England</cop><pub>BMJ Publishing Group Ltd</pub><pmid>34244178</pmid><doi>10.1136/bmjhci-2020-100307</doi><orcidid>https://orcid.org/0000-0002-0119-7736</orcidid><oa>free_for_read</oa></addata></record>
fulltext fulltext
identifier ISSN: 2632-1009
ispartof BMJ health & care informatics, 2021-07, Vol.28 (1), p.e100307
issn 2632-1009
2632-1009
language eng
recordid cdi_doaj_primary_oai_doaj_org_article_c5ca55d7dc2848d4a54dfe4a2b71a033
source BMJ Open Access Journals; Open Access: PubMed Central
subjects Colorectal cancer
Colorectal Neoplasms - prevention & control
Coronaviruses
COVID-19
Critical Pathways
Data entry
Data Management
Databases, Factual
Early Detection of Cancer
Health informatics
Humans
Implementer Report
Pandemics
Patients
Software
Time Factors
User-Computer Interface
title Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-06T19%3A57%3A04IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_doaj_&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Development%20of%20a%20customised%20data%20management%20system%20for%20a%20COVID-19-adapted%20colorectal%20cancer%20pathway&rft.jtitle=BMJ%20health%20&%20care%20informatics&rft.au=Miller,%20Janice&rft.date=2021-07-09&rft.volume=28&rft.issue=1&rft.spage=e100307&rft.pages=e100307-&rft.issn=2632-1009&rft.eissn=2632-1009&rft_id=info:doi/10.1136/bmjhci-2020-100307&rft_dat=%3Cproquest_doaj_%3E2583081118%3C/proquest_doaj_%3E%3Cgrp_id%3Ecdi_FETCH-LOGICAL-b524t-cf5a3b29496c48290a63a216fa4ec47fa14e69de4d49794e29a031219626d6443%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_pqid=2583081118&rft_id=info:pmid/34244178&rfr_iscdi=true