An Attempt of Preparation of Teaching Materials to Utilize NDB Open Data

Bulletin of Department of General Education, ,Yamaguchi Prefectural University

2

77-82

Tadahiro AZETSU, Naomi MASUNARI, Kumiko SUIZU

In this article, we describe an attempt to prepare teaching materials to efficiently process NDB open data. The teaching materials consist of explanations of NDB open data and instructions of data processing using Visual Basic for Applications (VBA), a programming language that can be used with the spreadsheet software Excel. In addition, the teaching materials allow students to understand the advantages of using VBA by comparing it to working with Excel worksheets. Finally, we asked them to solve VBA-related problems and confirmed their understanding of the teaching materials.