top of page

Scanning Test Results

  • Writer: Isaac Ahn
    Isaac Ahn
  • Aug 31, 2021
  • 1 min read

Yaxuan (Rebecca) Li - Palau, Ministry of Education


Rebecca created an automated system for validated and correcting scanned test data for Palau English Reading Assessment for Palau’s Ministry of Education.



Rebecca worked this summer with Keizy Shiro to streamline the process of collecting and analyzing the test results from the Palau English Reading Assessment (PERA). The tests are taken on 'bubble-format' sheets which are then scanned by optical character reader. The scanned data must be reviewed and cleaned before being loaded for analysis. Rebecca created an automated excel macro to examine the test result data for missing or inaccurate data and if possible, update the missing data. Inaccurate or missing key data (i.e. student ID) is highlighted and must be corrected manually. Rebecca then created a visual representation for the statistics with charts to show pass/fail data across grades and distribution of student performance across each learning objective.




LEARN         SHARE         GROW

Logo No Background.png

© 2023 by Carnegie Mellon University

bottom of page