Interactive Learning Media for Lenses and Their Applications Using Macro Visual Basic in Microsoft PowerPoint

Abstract

There are two types of lenses are used, namely a convex lens and a concave lens. Microscope is a tool that uses two convex lenses as the eyepiece and objective lens because it can form a magnified image. Instead concave lens is usually used as a spectacle lens for nearsightedness patients because the distance of image formed is closer than the distance of the object. Just like a mirror, the image formation by lenses also can be conveniently determined with ray diagrams. Therefore, this research aims to create a simulation of ray diagrams in the process of image formation by lenses and their applications using Macro Visual Basic in Microsoft PowerPoint. Lenses applications made are the microscope simulation and the combined lenses which consist of a concave-convex lens combined and a convex-concave lens combined. This research begins with the preparation of material on the image formation by lenses and their application. Second, made an appearance on the program which consists of a PowerPoint slide, CommandButton, Textbox, OptionButton, Shape and others then wrote programs in Macro Visual Basic procedure to active the command to do. Input of this simulation can be given in the form of object distance, focal point distance of lens and height of objects. The data will be processed according to commands contained in macros procedure to result image distance, image height, image magnification and the properties of image. In addition to result the data, media can also provide output in the form of ray diagrams simulation on the image formation that can be used to assist students understanding the image formation by lenses.