鶹Լ

Video summary

This short film explores how data is collected using digital devices in response to questions, and how it is organised into tables, records and fields on a computer system.

The film explores a real life scenario about using data to help run a zoo. It explores how data is collected using digital devices in response to questions, and how it is organised into tables, records and fields on a computer system where is can be shared with other users.

It then shows how this data can be analysed and manipulated to answer questions about the zoo animals.

The film ends by reminding us that mistakes can be made when entering data into a computer system so we always need to check for errors.

This short film is from the 鶹Լ Teach series, Cracking Computing.

Teaching Notes

Data or information is all around us at school and in the wider world, and there are many opportunities to collect and analyse it. It is useful to take notice of when this happens (e.g. during the school registration, when sorting out teams in PE, when borrowing books from the library), and use the correct terminology whenever possible (e.g. database, field, record, chart, graph, table, etc.

It is important that data collection activities start with a relevant question that the data will help to answer. For example:

  • We have some money for new class books, what authors do we prefer?
  • There are always apples left over in the fruit boxes after break, what fruit should we be asking the kitchen to provide to avoid waste?

Tools like spreadsheets are a useful way of creating simple electronic databases that can sort and organise collections of data and produce simple bar charts and line graphs. They may look intimidating but are actually quite straightforward to use and pupils will love the way they automate tasks and allow speedy sorting and filtering.

Other subjects

Science: Electronic data handling tools are useful to support the organisation and analysis of data collected during scientific investigations, such as measuring plant growth in different conditions (line graphs), or measuring the number of paper clips attracted by different types of magnet (bar chart), or measuring the nutritional composition of different foods (pie chart).

Maths: Using computers to support data handling can be part of maths lessons on data handling, once the basic concepts have been covered.

This short film is suitable for teaching:

  • KS2 computing curriculum in England
  • Technologies curriculum area at 2nd Level in Scotland
  • KS2 digital competence framework in Wales
  • KS2 using ICT cross-curricular skill in Northern Ireland

Algorithms. video

This short film for primary schools outlines how algorithms are sets of instructions to make something happen, before explaining further using a recipe analogy.

Algorithms

Computer networks. video

This short film explains computer networks. It looks at different types of computer network and the elements that make up a basic network including clients, servers, switches and hubs.

Computer networks

Creating with computing. video

This short film explores the many creative computing tools we have access to, with a focus on how they are used to create new creative content and media.

Creating with computing

Debugging. video

This short film uses computer games to explain debugging, which is the process of finding and correcting errors in computer programs.

Debugging

Decomposition. video

This short film explains how decomposition involves breaking one big problem down into smaller, more manageable problems that can be tackled step by step.

Decomposition

Input and output. video

This short film gives a brief history of input and output methods with examples, and brings us up to date with examples of familiar input and output devices that we use every day.

Input and output

Logical reasoning. video

This short film outlines logical reasoning as ‘sensible thinking’ when following rules, and explains how a problem with a computer program can be solved using logical reasoning.

Logical reasoning

Repetition. video

This short film for primary schools explains how repetition within computing allows a command to be repeated to make a computer program more efficient.

Repetition

Search technologies. video

This short film gives a brief history of the development of the internet and the invention of the world wide web by Sir Tim Berners-Lee, and explains the role of a search engine.

Search technologies

Selection. video

This short film covers the use of selection in simple computer programs, and shows how this idea of yes/no questions can allow computers to respond to external conditions and select different paths.

Selection

Sequencing. video

This short film covers the concept of sequencing, or making sure things are in the right order, and explores what might happen if things are done in the wrong order, or sequence.

Sequencing

Variables. video

This short film explores how computers use variables to store things that change, like names, numbers and scores.

Variables