ISTE Standard 2d
Software Development
Visual-Basic (VBA)
Click the Image
(You Must Enable Macros)
ISTE Standard 2d
Interactive Instructive PowerPoint on Adaptations Using VBA
During the fall of 2014 I took Software Development (EDTS 670). During this class we learned how to use Visual-Basic (VBA) to write programs to customize PowerPoint presentations for classroom use. The assignment was to create a nonlinear lesson using PowerPoint that allowed for students to take a pretest, select their course of learning, and take a posttest upon completing the lessons. This project met ISTE Standard 2d (Design and Develop Digital-Age Learning Experiences and Assessments), which states, "teachers will provide students with multiple and varied formative and summative assessments aligned with content and technology standards and use resulting data to inform learning and teaching." I was able to meet this standard because the PowerPoint had formative checks in both the pretest and the first lesson’s test. If a student were to receive a passing mark on either of these assessments the content of the lesson would be changed in that the student would be finished with the PowerPoint and would have to see the teacher for further instructions, or if the student did not pass, they would have to progress to a different lesson that presented material in a new way. The final assessment was also used as a summative assessment to determine content mastery.