An Excel Spreadsheet where you can store you class information and record all of the primary reporting markers (ATT, BEH, EFF, HWK). The spreadsheet allows the user to select a student to display graphical representations for these primary reporting markers. To support your report writing, the spreadsheet auto-generates a report comment based on each students data information - which can be copied and used, or edited for your needs. Additionally, this resource can be very useful during Parent’s Evenings - providing a visual representation of the students progress, and having the report comments to refer to during the meeting.

An introduction resource for British History focusing on the Kings and Queens of England since 1066 and British Prime Ministers. The original challenge for this task allowed students to have 30 days to learn the names and dates of both monarchs and PM's in preparation for a 30 question quiz. The resource is built using PowerPoint and is powered by VBA - the resource collects the users name at the start of the quiz and tracks their score. Throughout the quiz there is feedback depending on the chosen answers, and at the end of the quiz the user is given a percentage score.

A range of countdown timers for use throughout the lesson - starters, main lesson tasks and plenary tasks.

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.

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.

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.

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.

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.