Learning Objectives: Understand how to control Excel using VBA Be able to update and change the VBA code Test how effective your completed user form is Resource Image Links: TES Resources - VBA Lesson: Excel Spreadsheet TES Resources - VBA Lesson: User Form Interface TES Resources - VBA Lesson: VBA Code How to Use this Resource: Resource Description Differentiation Opportunities: The level of difficulty (1-9) for completing the various tasks are provided in the link below: TES Resources - VBA Lesson: Differentiation

Unit 1 - Fundamentals of IT Revision Activity Booklet This revision resource has been developed for students preparing for the Unit 1 exam in January. The activity workbook contains overviews, questions and activities for all five Learning Objectives (LO1 - LO5) and a practice Unit 1 exam. To support students independent revision all the answers for the questions, activities and practice exam are also included at the end of the workbook. This resource is suitable for both remote and on-site study, and is an invaluable resource to support students as they prepare for their exam.

Create an Interactive Quiz using PowerPoint and VBA 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 … Fun and Informative Lesson … 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.

Using MySQL in Microsoft Access This resource includes two worksheets containing nine tasks, a template evidence document for the students to print-screen and explain the work they have done and an excel export of the YouthOrg Access Database. You will need to create a new Access document and import the spreadsheet data in order to use the resource. This is an engaging task that works well as both an independent activity and in small groups. To complete the worksheet tasks and update the evidence document can take between 2-3 lessons.