Python编程学习辅助系统中Excel操作的代码修改问题研究

2022 10th International Conference on Information and Education Technology (ICIET) Pub Date : 2022-04-09 DOI:10.1109/ICIET55102.2022.9779025

San Hay Mar Shwe, N. Funabiki, Khaing Hsu Wai, Shune Lae Aung, W. Kao

{"title":"Python编程学习辅助系统中Excel操作的代码修改问题研究","authors":"San Hay Mar Shwe, N. Funabiki, Khaing Hsu Wai, Shune Lae Aung, W. Kao","doi":"10.1109/ICIET55102.2022.9779025","DOIUrl":null,"url":null,"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.","PeriodicalId":371262,"journal":{"name":"2022 10th International Conference on Information and Education Technology (ICIET)","volume":"51 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-04-09","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"A Study of Code Modification Problems for Excel Operations in Python Programming Learning Assistant System\",\"authors\":\"San Hay Mar Shwe, N. Funabiki, Khaing Hsu Wai, Shune Lae Aung, W. Kao\",\"doi\":\"10.1109/ICIET55102.2022.9779025\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":371262,\"journal\":{\"name\":\"2022 10th International Conference on Information and Education Technology (ICIET)\",\"volume\":\"51 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-04-09\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2022 10th International Conference on Information and Education Technology (ICIET)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICIET55102.2022.9779025\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 10th International Conference on Information and Education Technology (ICIET)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICIET55102.2022.9779025","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

摘要

由于丰富的库和简短的编码特性，Python编程在各个领域都很受欢迎。我们开发了用于Python编程自学的编程学习辅助系统(PLAS)。在此之前，我们提出了代码修改问题(Code Modification Problem, CMP)来研究数据分析的数据可视化操作。一个CMP实例由一个源代码和两个映像组成。一幅图像代表代码的输出，另一幅图像是学生的答案代码的输出，应该通过修改给定的代码来获得。通过与正确答案的字符串匹配来验证任何答案的正确性。在本文中，我们通过扩展以前的工作，提出了用于Excel操作的CMP。为每个CMP实例实现了一个提示函数，以帮助学习者解决它。我们使用Python代码生成了25个CMP实例，使用pandas进行各种Excel操作，并从应用结果中向冈山大学的学生确认了有效性。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

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

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.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

2022 10th International Conference on Information and Education Technology (ICIET)

自引率

0.00%

发文量