This resource looks at binary data and contains an Excel workbook with macros to enable recolouring/checking the colour of cells. A series of binary numbers are given in a rectangular grid of cells on the left when the workbook is first opened. Students are required to recolour the original binary grid, to show the...

The cs4fn magazine is a magazine on the fun side of all things to do with computer science. The authors write up computing research in a fun and accessible way that puts across their enthusiasm for the subject. Unplugged computing, computational thinking and practical applications of computers in many areas are...

"Computing isn't about computers" - this quote from one of the CS4FN authors, Paul Curzon, should give you an idea about the resources in this collection. Designed to inspire, these activities are about people, solving puzzles, creativity, changing the future and, most of all, having fun. Magic tricks, philosophy,...

These two lessons use the context of the scoring system of Ultimate frisbee to help students see a real-life use of how spreadsheets and data handling can assist a sporting context.  

Lesson 1 shows...

This task is a real-world example of how spreadsheets can be utilised effectively to simplify data handling and calculation tasks.

Pupils are provided with information about the number of items being transported in a lorry and their individual value. Pupils have to create a spreadsheet to calculate the total...

This resource, aimed at lower ability Key Stage 4 students, introduces the concept of data compression, specifically Run Length Encoding. Students are asked to use an online tool to convert names into binary (ASCII), this binary data is then subjected to Run Length Encoding and encoded binary compared to the...

In this resource, the students are asked to look at various aspects of data security. In part this covers cyber security but it also looks at data integrity and ensuring that users data does not become corrupt through various means. There are a variety of activities provided, and all of the necessary resources are...

This task is a real-world example of how spreadsheets can be utilised effectively to simplify data handling and calculation tasks.

Pupils are provided with information about the numbers of items in stock in a warehouse and the weekly sales of the items over a month. This task requires pupils to add the stock...

This lesson consists of a presentation on Data Representation, looking at how binary numbers work (and concludes with an exercise in converting binary numbers to denary). Students consider primitive monitors with q bit colour depth, represented characters and other data. before investigating how coloured images are...

This resource consists of 2 A3 Active Learning worksheets which could be used to either introduce and record information about data representation, or as a revision tool. There are plenty of activities across the two pages that would allow students to either recap work they have previously covered or to research...

This resource contains a number of activities and worksheets to support the topic of binary numbers. The content looks first at binary numbers, how they represent denary numbers, converting between the two, binary addition and using two's complement to represent negative numbers and thus perform subtraction. These...

This short homework or worksheet activity describes how a bitmapped image has been stored in a file, including the encodings used in binary to represent the 4 colours which make up the image, and the height and width of the image. The data is all given in binary format. Students are then expected to recreate the...

This resource consists of a presentation and some supporting materials to enable students to research and create their own presentation around the ideas that there are Ethical, Legal and Environmental Issues surrounding the use of ICT in Business and Educational surroundings. The presentation sets the scene,...

A teacher produced workbook containing activities focused solely on database parts. The resource consists of a section on databases, a discussion of the pros and cons of flat file databases versus relational databases  which leads into how to create tables, insert data into them and then interact with them using...

A series of 20 activities related to Data Representation in the GCSE Syllabus. Activities include worksheets on Binary (including addition, shifting and conversions), character encoding systems, various aspects of how audio files are created and stored, Huffman Tree encodings, Denary and Hexadecimal conversions,...