earticle

논문검색

A Secure Score Report Implemented in a Spreadsheet without Privacy Concerns

초록

영어

Students’ educational records such as exam score and academic achievement should be considered as sensitive information. According to the federal student privacy law, individual scores should not be posted publicly. If a secure online management system is well-equipped in the school, then it is easy to distribute individual data in a privacy preserving way. However, in general, such a centralized system costs high and is not flexible enough to be used for instant score report after each exam. In this paper, we propose a practical way for an instructor to post students’ individual exam scores online in a single file. By implementing a cryptographic hash function together with score data in an MS Excel file, we demonstrate a score report from which allows each student to retrieve his/her score with his/her own password. Based on our worksheet as a template, it is easy for instructors to write their own score reports without relying on any heavy management systems. Since our score report is implemented in MS Excel worksheets, students find out their scores with Excel program or viewers even in their mobile phones without installing any other programs or apps. Also, it is cryptographically as secure as underlying hash function SHA-256.

목차

Abstract
 1. Introduction
 2. Secure Hash Algorithm SHA-256 in an Excel Worksheet
  2.1 Secure Hash Algorithm SHA-256
  2.2 Implementing SHA-256 in an MS Excel
 3. A Score Reporting Example
  3.1 Configuration of Example
  3.2 Encryption and Decryption
  3.3 Running in Mobile Devices
 4. Security Analysis
  4.1. Authentication
  4.2. Encryption
 5. Conclusion
 Acknowledgment

저자정보

  • Dongchang Yoo Department of Mathematics
  • Minyoung Bae Department of Mathematics
  • Yongjin Yeom Department of Mathematics, Department of Financial Information Security Kookmin University

참고문헌

자료제공 : 네이버학술정보

    함께 이용한 논문

      ※ 원문제공기관과의 협약기간이 종료되어 열람이 제한될 수 있습니다.

      0개의 논문이 장바구니에 담겼습니다.