Welcome to the World of Data and Information!

Have you ever wondered how weather forecasters know it is going to rain, or how your school library keeps track of hundreds of books? They all use Information Technology (IT) to collect, organise, and make sense of the world around us.

In this guide, you will learn how we turn simple numbers and words into useful information, how to use cool tools like sensors and spreadsheets, and how to combine different programs to create presentations and reports. Don't worry if some of this seems new or tricky at first — we will break everything down step by step!

1. Data vs. Information: What is the Difference?

People often mix up the words data and information, but they mean two very different things in Computing!

What is Data?
Data is raw, unorganised facts, numbers, words, or measurements that do not have any meaning on their own.
Examples of raw data: 21, true, 15:00, blue.
If someone walked up to you and just shouted "21!", you would have no idea what they meant. Is it 21 apples? 21 miles per hour? 21 degrees?

What is Information?
Information is data that has been sorted, organised, and given context so that it makes sense and tells us something useful.
Example of information: "The classroom temperature was 21°C at 15:00." Now the number 21 has meaning!

A Helpful Analogy: The Cake Recipe
Think of data like raw baking ingredients: a bowl of flour, an egg, and a block of butter sitting on the counter. On their own, they are just raw items.
Think of information like the delicious baked cake! When you mix the ingredients together and bake them in an oven, you get something meaningful and complete.

Quick Summary:
• Data = Raw, unorganised facts without context.
• Information = Data that has been processed and given meaning.

2. Sorting with Branching Databases

When you have a collection of objects (like animals, shapes, or mini-beasts), how do you identify them? We use a tool called a branching database.

A branching database is a visual sorting tool that uses a tree-like structure of yes/no questions to split a group of items into smaller and smaller groups until each item is on its own.

Key Concepts to Know:

• Attributes: These are the properties, characteristics, or features of an item (for example: has wings, has 4 legs, is red).
• Binary Questions: A binary question is a question that can have only two possible answers: Yes or No.

How to Build a Good Branching Database:

1. Look closely at your items and find an attribute that some have, but others do not.
2. Ask an unambiguous yes/no question (e.g., "Does it have feathers?").
3. Follow the Yes path for items with that feature, and the No path for items without it.
4. Keep asking new yes/no questions for each group until every single object has its own unique place at the end of a branch.

Top Tip to Avoid Mistakes:
Never use vague or opinion questions like "Is it big?" or open questions like "What colour is it?". Always ask clear, factual questions like "Does it have more than 4 legs?".

3. Data Logging: Collecting Data Automatically

Imagine your teacher asked you to measure the temperature of the school playground every 10 seconds for 24 hours without sleeping. That would be impossible for a human! Luckily, computers can do this easily using sensors and data loggers.

What is a Data Logger?
A data logger is a special digital device connected to sensors (input tools) that measures and records physical changes in the environment automatically over time.

Common Types of Sensors:

• Temperature sensor: Measures how hot or cold it is.
• Light sensor: Measures light intensity (how bright or dark it is).
• Sound sensor: Measures volume levels (noise in decibels).

Important Data Logging Vocabulary:

• Data Point: A single measurement recorded at one specific moment in time (e.g., 18°C at 10:00 AM).
• Data Set: A complete collection of related data points gathered during an experiment.
• Logging Interval: The time gap or frequency between each measurement (for example, taking a reading every 5 seconds, every 10 minutes, or once an hour).

Why are Data Loggers Better Than Humans for Certain Jobs?

• They can record measurements over long periods (like overnight or over a weekend).
• They can take hundreds of readings per second (high-frequency recording).
• They can be placed in remote, tiny, or dangerous places (like inside a freezer or at the top of a weather mast).
• They are extremely accurate and never forget to take a reading!

4. Organising with Flat-File Databases

Once you have gathered lots of data about people, places, or things, you need a way to store and search it easily. A flat-file database is a digital database that stores information in a single two-dimensional table made of rows and columns.

The Two Main Building Blocks:

• Field (Column): A single category or type of data. Every item in the column contains the same kind of detail.
Examples of fields: First Name, Age, Favourite Colour, Pet Type.
• Record (Row): A complete set of information about one single person, animal, or object across all the fields.

Memory Trick to Never Forget:
• Field = Fence post (stands up tall like a column).
• Record = Running track (runs flat across from left to right like a row).

Things You Can Do with a Database:

• Sorting: Putting your records into a specific order.
— Alphabetical order (\(\text{A to Z}\) or \(\text{Z to A}\)).
— Numerical order: Ascending (smallest to largest, e.g., \(1 \rightarrow 10\)) or Descending (largest to smallest, e.g., \(10 \rightarrow 1\)).
• Searching / Filtering: Asking the database a question (a query) to show only the records that match specific rules.
Example search rule: Show all records where \(\text{Age} > 10\) AND \(\text{Pet} = \text{"Dog"}\).

5. Spreadsheets: Calculating, Modelling, and Graphing

A spreadsheet is an interactive computer program used to store numbers, perform mathematical calculations automatically, and turn data into clear graphs.

The Structure of a Spreadsheet:

• A spreadsheet is made of a grid of columns and rows.
• Columns are labelled with Letters (\(\text{A, B, C...}\)).
• Rows are labelled with Numbers (\(1, 2, 3...\)).
• Cell: A single box where a column and a row meet.
• Cell Reference: The unique name/address of a cell, written with the column letter first and then the row number (for example, \(\text{B4}\) is the cell in column \(\text{B}\), row \(4\)).

The Golden Rule of Spreadsheet Formulas:

Every formula in a spreadsheet MUST start with an equals sign (\(=\))!
If you type \(10 + 5\) into a cell without the equals sign, the spreadsheet treats it as plain text words. When you type \(=10 + 5\), the spreadsheet knows it must calculate the answer: \(15\)!

Basic Arithmetic Operators in Spreadsheets:

• Addition: \(+\) (e.g., \(=A1 + B1\))
• Subtraction: \(-\) (e.g., \(=A1 - B1\))
• Multiplication: \(*\) (e.g., \(=A1 * B1\)) — Note: we use an asterisk, not an 'x'!
• Division: \(/\) (e.g., \(=A1 / B1\)) — Note: we use a forward slash!

Special Functions:

Instead of adding up fifty cells one by one, spreadsheets give us powerful built-in shortcuts called functions:
• \(=SUM(\dots)\): Adds together a whole range of numbers.
Example: \(=SUM(A1:A10)\) adds all numbers from cell \(\text{A1}\) down to \(\text{A10}\).
• \(=AVERAGE(\dots)\): Calculates the arithmetic mean (the average) of a range of numbers.
Example: \(=AVERAGE(B1:B5)\) finds the average of cells \(\text{B1}\) to \(\text{B5}\).

6. Selecting, Combining, and Presenting (The IT Pipeline)

In real life, you don't just use one program. Digital devices and different types of software work best when you combine them to complete a project!

Step 1: Selecting the Right Tool for the Job

• To collect data: Use a data logger or an online survey form.
• To organise and calculate data: Use a spreadsheet or a database.
• To present findings to an audience: Use presentation software (slide decks), word processors, or desktop publishing tools.

Step 2: Choosing the Right Chart or Graph

When presenting data visually, choosing the wrong chart can confuse your audience. Here is how to pick the perfect one:

• Line Graph: Best for showing continuous change over time (e.g., how playground temperature changes hour by hour over a day).
• Bar Chart: Best for comparing discrete categories or groups (e.g., favourite fruits of pupils in Year 5).
• Pie Chart: Best for showing proportions of a whole (percentages of a total group).

Step 3: Combining Software (Integration)

You can move your work between programs to build an amazing final report:
1. Export the data from your data logger into a spreadsheet.
2. Calculate totals and averages using \(=SUM\) and \(=AVERAGE\).
3. Create a clear bar chart or line graph inside the spreadsheet.
4. Copy and paste / embed the chart and tables into a word-processed document or presentation slide deck.
5. Add titles, labels, clear explanations, and images so your audience understands your results clearly!

Quick Review: Top Mistakes to Avoid!

1. Mistake: Forgetting the equals sign (\(=\)) in a spreadsheet calculation.
Fix: Always start every calculation with \(=\) so the computer knows to do math!

2. Mistake: Mixing up fields and records in a database.
Fix: Remember that fields go downwards in columns (categories), and records go sideways in rows (individual items).

3. Mistake: Using a line graph for separate categories.
Fix: Use a bar chart for categories (like pets or colours) and a line graph only for changes over time (like temperature or height over weeks).

4. Mistake: Asking subjective questions in a branching database (like "Is it cute?").
Fix: Ask precise, binary yes/no questions based on clear physical attributes (like "Does it have fur?").