資訊科技輔以人工智慧(AI)優化家庭檔案數位化

Information Technology Supplemented by Artificial Intelligence (AI) Optimizes the Digitization of Family Archives

目的：家庭檔案的建立在家庭醫學科門診是一門重要議題，既可了解家庭對健康的影響，尚可作為住院醫師的訓練，目前鮮少有關數位化資料可資使用。

方法：使用關鍵詞 “family archive(s)” OR “family file(s)” OR “家庭檔案”，搜尋PubMed及華藝線上圖書館。使用電腦型號為ASUS筆記型LAPTOP-TSDMU3MP，配備Intel Core i7-1165G7 2.80GHz處理器、32 GB RAM、運行Windows 11、64位元及Microsoft 365軟體之Excel及其VBA，輔以人工智慧(AI)，數位化完成後再使用舊版Excel做測試。

結果：大部分資料皆可使用選單式勾選，使用自訂表單做 “功能面板” 的設計，加入不同的功能按鍵配合程式設計，使用起來更友善。可將看診注意事項及重點註記在儲存格附註上，使得在簡潔的小範圍，即可達到最大的空間應用。利用公式，APGAR score可自動計算、自動評估家庭的功能嚴重度且可使用語音。家譜(Pedigree)製作可使用內建模板(templates)直接作修改，且根據填入性別及婚姻狀況自動完成部分圖形。點擊"改名"會自動修改工作表名稱為個案姓名，可自動形成家庭檔案目錄於第一個工作表(“Index”)，點擊工作表名稱（或個案姓名），即自動連到相應的家庭檔案，且可資快速交叉查詢。

結論：使用Excel數位化的家庭檔案，可在簡潔小範圍，達到最大空間應用、快速交叉搜尋家人及其他資料、APGAR嚴重度判別、疾病篩檢的自動建議、根據性別及婚姻狀況自動連動部分Pedigree等，具有類似AI的自動判別功能，大大提高在臨床上的應用。再者，本文提及的一些資訊科技設計方法，輔以AI技術，可作為自學或初學程式語言者參考。

 

Objectives: Family archives play a crucial role in the practice of family medicine as they not only help physicians examine the influence of family health history on patients but also serve as effective training materials for family medicine residents. However, access to digitalized family archives has remained limited.

Methods: "Family archive(s)" OR "family file(s)" were adopted as keywords to search related papers in PubMed and Airiti Library, using ASUS notebook LAPTOP-TSDMU3MP, equipped with Intel Core i7-1165G7 2.80GHz processor, 32GB RAM, running Windows 11, 64-bit, and Microsoft 365 software’s Excel VBA supplemented by artificial intelligence (AI). The old version of Excel was used to conduct post-digitalization tests.

Results: Most of the data can be selected using menus after design and subsequent optimization. The "function panel" can be used to design a tailored User Form, and different function keys can be programmed to enhance user friendliness. Excel cells are available for transcribing issues requiring attention, helping achieving maximum space efficiency. Formulas are developed, with voice function provided, to automatically calculate the patient’s APGAR score and assess family functions. Pedigree can be drawn and modified directly on built-in templates, and parts of the pedigree diagram can be automatically completed by entering the patient’s sex and marital status. Clicking "Name" will automatically change the worksheet name to that of the patient, forming a family file directory on the first worksheet (Index). Clicking the worksheet name (or the name of the patient) produces the corresponding family file for quick query or modification.

Conclusions: The digitalized family archives by Excel, marked with maximum space efficiency, greatly benefits the clinical practice of family physicians by facilitating an array of AI-like automation functions, including quick identification and cross-reference of the patient’s family data and APGAR assessment of family function, automatic pedigree drawing based the patient’s sex and marital status, and even provision of recommendation for disease screening. Furthermore, some of the information technology design methods mentioned in this article, supplemented by AI technology, can also be used as a reference for self-study or for beginners of programming languages.