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.

-

For the purpose of clarifying the relationship between mortality rate of all causes of death and Mortality rate from malignant neoplasms and lifestyle-related factors and other factors by utilizing the open data of the receipt information / specific medical examination information database (NDB), We examined the health issues of Japan and Yamaguchi Prefecture from the perspective of a registered dietitian. In men, "fasting blood glucose level 110 mg / dL or more", "systolic blood pressure 140 mmHg or more", "drinking more than 2 times on drinking days" and the mortality rate of all causes of death showed an association, and "the frequency of drinking alcohol every day", "drinking more than 2 times on drinking days" and mortality rate from malignant neoplasms showed an association. In women, the mortality rate of all causes of death was associated with "diastolic blood pressure of 90 mmHg or more", "smoking habit", and "weight gain / loss in one year is ± 3 kg or more", and "smoking habit" was mortality rate from malignant neoplasms to malignant neoplasms. Mortality was associated.