An excellent teaching resource for ICT / Computing: Number Systems, providing a step-by-step walk though for converting denary (base 10) to binary (base 2) numbers. The application provides two different methods of conversion and allows the user to enter an example number of their choice; the system will then convert their denary value into a binary number, showing the steps taken to do so. This FULL VERSION includes the built in assessment system to test students knowledge of denary to binary conversion. Additionally there is an CERTIFICATE crated automatically at the end of the assessment that can be printed and saved as a record of achievement. Complete details of the application are provided in the attached User Guide document. The resource has been built using Excel 2010 and will be compatible with both Excel 2010 and 2013. The programming for the application is powered by VBA, the application is self-contained and button controlled.

A dynamic resource, excellent as a starter activity or a practice tool for Key Stage 1/2 Maths - Number Systems: Place Value and Ordering. The application has three features: Tens and Units - a random number between 10 and 99 is displayed on screen and a question is displayed asking "How many units?" or "How many Tens?"; Hundreds, Tens and Units - a random number between 100 and 999 is displayed on screen and a question is displayed asking "How many units?", "How many Tens?" or "How may hundreds?"; Hundreds, Tens and Units (2) - a random three digit number, printed using words is displayed on screen. The application has been built using Excel 2010 so is compatible with both Excel 2010 and 2013.

A working clock built into an Excel spreadsheet - can be displayed as both analog and digital. An additional feature has been added allowing you to start and stop the clock. This can be a useful resource to have on hand, helping you keep track of time during lesson activities or to display on the main board.

A dynamic way to display your questionnaire/assessment feedback, with a graph that automatically updates depending on which row you select. For example, in the example image the cursor is placed on the row entitled "I enjoy all of my lessons". The results for this row are then shown in the above graph. You can add as many Items to the application as you want, as long as the data has an Item value it will display on the graph.

Useful for any subject following an end-of-project assessment: enables the user to enter a maximum of 40 students names and their results into the table. When selected the student information is highlighted and the results are graphically displayed on the left of the screen. Additional information is also automatically provided including the average result, class size, the students class ranking as well as the highest and lowest scores. This is an excellent resource for tracking and monitoring students progress in each unit, as well as providing a clear record of progress and development, supporting differentiation when revisiting the topic, aiding the completion of reports and highlighting areas for improvement/revision. This resource has been built using Microsoft Excel 2010 and is compatible with both Excel 2010 and 2013. It uses VBA programming to run the additional features including dynamic selection highlighting and automatic formatting.

Business Studies resource - the top 20 inventions of all time are stored in the application. Type in a possible answer which is then copied to a table to show all your previous guesses - if you are correct the answer will reveal itself on the game board. This is a excellent resource for a group or whole class activity, encouraging all students to participate in guessing the best answer.

This application is a totally customisable version of my "Family Fortune - Top 20 Inventions" application. The default settings have been kept as the top 20 inventions of all time, however in this version you are able to design and implement your own top 20 list. The design process uses custom built userforms, VBA programming and has undergone user testing to ensure ease of use. Simply select the Designer Mode, enter a Title for your game and then add your top 20 list items. When you are done click on Play and you will be able to play and present "your version" of Family Fortunes.

This dynamic checklist can help you to keep track of your workload and those extra jobs. It is designed to be simple to use and to give a clear indication of your progress. The check boxes have been programmed only to appear if you have typed an item into the checklist.

This computing (number systems) lesson introduces students to conversion techniques between denary, binary and ASCII characters, supports calculation for binary to denary values and investigates binary addition and subtraction. Slides 9-11 are the ANSWER SHEETS and are hidden from view - recommended that this is saved as a STAFF version, and a separate STUDENT version is made available without the answer section included. The presentation has practice examples throughout, and an INVESTIGATION segment to stretch students abilities - looking into different number systems and how they are used in the real-world. This is an excellent accompaniment to the BINARY TO DENARY CONVERSION ASSESSMENT available for purchase at http://tinyurl.com/hxxc38j

This can be used for question & answers segments within starters, as well as throughout the lesson to reinforce learning and establish understanding of the lesson topic. Excel spreadsheet using VBA programming and User Forms providing a customisable interface format, allowing you to type or copy & paste a range of student names (maximum 50) onto the worksheet - then following the on-screen instructions to generate a random name selection.

JavaScript Random Name Generator This is a handy resource that loads onto your browser on a new tab. To add your names to the generator you will need to right-click and select Open With … either Notepad or Notepad++. Here you will be able to view the JavaScript code and edit. This is a useful resource for selecting a random student from your class as part of a starter or plenary exercise. Alternatively I have used it as a jumping-off task as part of a Computer Programming lesson, where students recreate the resource practicing their logical thinking skills and enhancing their programming knowledge.

Scratch Incremental Development Lesson This PowerPoint resource walks students through creating: Variables Costumes Operators Broadcast Each activity is fully explained and an exemplar code is displayed for each task

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

Passwords … It is so important to regularly update and change your password, and schools now require you to include uppercase, lowercase and symbols into a password that can be as long as 30 characters! These are easy to forget and you need to place to store them. Time Consuming … Remembering multiple complex passwords is very difficult - especially if you are using unique alphanumeric strings. What takes the most time is creating the password - not wanting it to be too common or easy to guess but not so difficult that it is impossible to remember. The My Passwords Log Book has a Random Password Generator which will create and record the string, saving you time. All the Applications … There are so many applications that you use as a teacher - the number of times I have not only forgotten the password but also the name of the application is almost embarrassing! With My Passwords Log Book you can store the application name, include a hyperlink taking you directly to the site as well the required password.

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.