Developing an innovative reward bin with Excel VBA

Abstract

This research have objectives (1) study problems and requirements school waste management (2) to design and create innovative reward bin (3) evaluate the effectiveness of the innovations that have been developed. First, the research studied information on problems and needs of teacher in waste management from interviews with key informants and non-participating observations of the target schools. Next, take the data obtained for analysis and synthesis. Develop software with Excel VBA, design and create innovative, reward bin. Test the functionality and evaluate the effectiveness of the innovation. The results of the research showed that the innovative hardware designed and built. Test results when dumping each time. The mouse pointer control module can control the mouse pointer to click command buttons to start processing at any time. The software can process the import of basic student information. Calculate reward points and show correctly various results. The overall functionality of the bin supports the disposal of standard plastic bottles of minimum 250 ml and maximum 1500 ml, and is highly integrated with the software. The results of the performance evaluation were at the overall mean of 4.47, which was at a high level.