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.

JavaScript ID Maker This simple program will generate an alphanumeric string that can be used as a password generator, unit code or as a starter task for a Computing lesson. When you load the script you will be prompted to enter the number of characters you would like displayed. When you press enter the random ID is displayed on screen.

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.

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