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.

This lesson looks at the benefits and limitations of networking and three network topologies: Ring, Bus and Star. During the lesson I get students to act out each topology using balloons/screwed up paper balls to represent the data. There are teacher notes that explain how this works for each topology. Students can complete the network worksheet.

This lesson introduces the CPU (Central Processing Unit) and explains how the clock speed, cache size and number of cores affects the performance of a computer with animated examples. There is a cloze worksheet for students to complete which provides an opportunity to take notes.

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.

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.

This lesson looks at how computer graphics have developed and how a simple 1-bit image can be encoded using binary. Students then have the opportunity to encode and decode their own binary images. They need to be able to convert binary to denary and vice versa before doing this lesson.

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.

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.

This spreadsheet activity task requires students to use the SUM, MIN, MAX and AVERAGE functions to complete the weekly sales figures for their cinema. They can also demonstrate the use of the fill handle to copy down or along formulas. When the formulas have been added they need to answer the questions below it, using the data above. There is an extension activity which requires students to add conditional formatting to highlight which movies are doing better or worse than the average ticket sales. Teacher Ref version (with answers!) included.

An excel spreadsheet that can be played with a class as a quick recap to ensure they can identify and use cell references and understand that the letter (column) goes before the number (row). When I play this with my classes, students take turns in giving a cell reference which I then click on to display the square underneath. You could play this competitively by dividing the class into two teams and seeing who can sink the most battleships.