[Development of an Information Aggregation System for a Multidisciplinary Team in Medical Education].

Abstract

Purpose: Typically, grades are compiled using spreadsheet software, and the file is then emailed with the password sent in a separate email. The government has pointed out that this method does not provide robust security. Introducing a new system is difficult due to the psychological factor of status quo bias. Therefore, we devised a new grade compilation system that uses spreadsheet software that can be easily implemented. The research aims to develop an automatic grade compilation system that implements RSA encryption.

Methods: As Excel's specifications do not allow for the display of more than 16 significant digits, we devised a method of applying modular exponentiation to modular arithmetic. The time required for encryption was measured five times and the average value was calculated.

Results: The time required for encryption was approximately 2.3 seconds, and RSA encryption is highly secure, it has the advantage of being able to distribute files with e-mail, and a paperless workflow could be established.

Conclusion: The developed system is highly secure and can be sent via email, and its automation is effective as a means of preventing disputes caused by human error.