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

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.

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.

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.

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.