A Study of Code Modification Problems for Excel Operations in Python Programming Learning Assistant System

San Hay Mar Shwe, Nobuo Funabiki, Khaing Hsu Wai, Shune Lae Aung, Wen Chung Kao

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Python programming has gained popularity in various fields due to rich libraries and short coding features. We have developed Programming Learning Assistant System (PLAS) for self-study of Python Programming. Previously, we presented Code Modification Problem (CMP) for studying data visualization operations for data analysis. A CMP instance consists of one source code and two images. One image represents the output of the code, and the other is the output of the answer code from a student and it should be obtained by modifying the given code. The correctness of any answer is verified through string matching with the correct one. In this paper, we present CMP for Excel operations by extending previous works. A hint function is implemented for each CMP instance to assist learners in solving it. We generated 25 CMP instances using Python codes for various Excel operations using pandas and confirmed the validity from the application results to students in Okayama University.

Original languageEnglish
Title of host publication2022 10th International Conference on Information and Education Technology, ICIET 2022
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages209-213
Number of pages5
ISBN (Electronic)9781665480482
DOIs
Publication statusPublished - 2022
Event10th International Conference on Information and Education Technology, ICIET 2022 - Matsue, Japan
Duration: Apr 9 2022Apr 11 2022

Publication series

Name2022 10th International Conference on Information and Education Technology, ICIET 2022

Conference

Conference10th International Conference on Information and Education Technology, ICIET 2022
Country/TerritoryJapan
CityMatsue
Period4/9/224/11/22

Keywords

  • code modification problem
  • Excel operations
  • pandas
  • PLAS
  • python

ASJC Scopus subject areas

  • Computer Networks and Communications
  • Information Systems
  • Information Systems and Management
  • Media Technology
  • Education
  • Communication

Fingerprint

Dive into the research topics of 'A Study of Code Modification Problems for Excel Operations in Python Programming Learning Assistant System'. Together they form a unique fingerprint.

Cite this