Included in this download is …
- Full Lesson Plan
- Starter Activity Worksheet
- VBA_Quiz_START which should be made available to students at the beginning of the lesson
- VBA_Quiz_SlideShow_MACRO is the lesson presentation detailing each step of the Quiz
- VBA_Quiz_Code_WS is a support worksheet for students who are struggling with the task (full code)
- VBA_Quiz_FINAL is a completed VBA Quiz with a name request, 3 questions and a results page
I have delivered this lesson multiple times and it is always a popular activity, with students able to choose their own quiz topic and design their own questions. Most of the time this activity has stretched over 2 lessons, allowing students who struggle with coding to catch-up, whilst the more gifted students are able to develop and enhance their quiz.