Abstract
In the field of Japanese language education, information regarding what is done "in the classroom" such as creating educational tools or materials is actively shared. However, works for "outside the classroom" for improving learning environment has not been discussed in the academic or research communities. Creating class timetables is one of those "outside" works, and it requires skills to manage the information regarding names of the courses, names of the instructors, and locations of the classrooms, while maintaining consistency between those factors. In this paper, a timetable editing tool using MS Excel's VLOOKUP function is introduced for the purpose of reducing the amount of complicated work for creating class timetables.