Abstract
Seger formula is important for the students who study a porcelain glaze in a scientific viewpoint. However, seger formula calculation process is complicated and, it takes a long time that students understand it. Then, we created a calculation software for preparation of glaze by Microsoft Excel VBA. In this session, the effective lesson which used this calculation software is introduced.