This lesson teaches students about goal seek and how it works in Excel. Students imagine they have just won a million on a "Who wants to be a millionaire?". They use goal seek to work out which country they would rather win the show in. When they have finished, they can then use an online currency converter to find out today's rates and then see how that changes things. This can lead to discussions on how small changes in currency rates can have big impact when transferring money between countries and depending on the ability of your class you can even end up discussing what causes exchange rates to rise and fall - particularly topical at moment given Brexit and the new US President and their impact on the markets.

This is a Revision tool based on the old Blockbusters game format with a gameboard that can be customised with your own questions and can be used as a whole class revision resource or in pairs on their own computers. The player selects the hexagon and the question automatically appears at the bottom of the screen. The answer can be revealed by clicking the “Reveal Answer” button. The hexagon can then be turned blue or white depending on who won the hexagon or black if they got it wrong. The gameboard is currently loaded with GCSE revision computer-related questions but can be changed by clicking on the “Questions” sheet and changing the information. After updating the Questions and Answers, click “Reset Gameboard” to rebuild the gameboard with your new questions and answers. If you have answers starting with the same letter then you can enter two letters to differentiate your answers. This opens the game to more possibilities. Note: This excel spreadsheet uses macros in order to work. Please enable them upon loading the spreadsheet.

This lesson introduces binary and compares it to denary. A method of converting denary to binary is then worked through and there are two worksheet activities for students to complete on binary conversion and arithmetic.

This lesson introduces von Neumann architecture briefly and then focuses on inputs and outputs. Students explore the input and outputs devices that would be used in a self-service checkout and several other scenarios.

This 14-lesson unit of work takes students through the process of creating their own game in Scratch. They start by considering what makes a game successful and then move on to learn gaming concepts like sprite movement, animation, collision detection and variables using Scratch. The lessons directly link to Scratch game resources I have placed in the Barney Game Studio on the Scratch website (http://scratch.mit.edu/studios/1977310/). At the end of their unit, there is a lesson on user testing where they will get the opportunity to peer assess the games they create. They can also create an instruction manual for their game, evaluating the forms and conventions of such documents and using desktop publishing software to create their own.

This spreadsheet tests students ability to make a prediction from a model, create a graph, use the SUM and Goal Seek functions, write an IF statement and use data validation. The last sheet in the spreadsheet contains formulas that indicate when the student has completed each task correctly to help with marking.

Lesson where students learn about the three main storage technologies: optical, magnetic and solid-state. After researching each technology and how it works, they can then apply that knowledge to identify the most appropriate storage technology for each of the given scenarios in the worksheet. There is also an extension worksheet on Cloud storage.

Introduction to AND, OR and NOT gates. Students then complete the truth tables in a worksheet. They can then use the logic.ly website to self-assess whether they got the truth tables correct and create their binary logic gate diagram to program a car safety system.

Short activity that could be used as a starter to encourage students to work through some code snippets in their head and write down the output.

Three pseudocode challenges for Computing students for the festive period! Now with possible solutions/answers.