Welcome to Collecting and Analysing Data!

Have you ever wondered how your favourite apps, websites, or school projects are created to suit real people? In Information Technology (IT), we do not just make things that look cool to us; we design solutions for known users (real people with specific needs). To do that well, we need to collect clues, understand facts, and turn raw numbers into clear answers.

In this chapter, you will learn how to gather data, crunch numbers using spreadsheets, choose the right software and file formats, and create trustworthy, easy-to-use digital projects. Don't worry if any of this sounds tricky at first—we will break down every single step with simple examples!

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

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

Data: Raw, unorganised facts, numbers, words, or symbols without any context. On its own, data does not tell you much.
Example: The number 38.5 written on a blank piece of paper. Is it a shoe size? A price in pounds? A temperature?

Information: Data that has been processed, organised, or given context so that it has meaning and becomes useful.
Example: "The patient's body temperature is \(38.5\ ^\circ\text{C}\)." Now that number makes complete sense!

A helpful analogy: Think of data like raw ingredients (flour, sugar, and eggs). Information is the baked cake made by mixing and baking them together.

Key Takeaway: Data is raw input; information is meaningful output after data has been processed.

2. The Creative Project Lifecycle

When you build a digital product—like a school website, an interactive presentation, or a sports club data dashboard—you should follow a structured, step-by-step journey called the Project Lifecycle.

Stage 1: Requirements & User Analysis
Find out who will use your product (your audience persona), what they need, what rules or limits you have (constraints), and what will make the project a success (success criteria).

Stage 2: Design & Planning
Sketch out your ideas before touching the computer. You might create wireframes (simple page layouts), mood boards (colour and style ideas), site maps, file folder plans, or data layouts.

Stage 3: Implementation & Tool Selection
Pick the best software applications and devices for the job, then build your digital project by creating, combining, and editing assets.

Stage 4: Testing & Usability Evaluation
Test your product with real users! Check whether it works against your original requirements, ask for feedback, and check whether people with disabilities can use it easily (accessibility testing).

Stage 5: Iteration & Refinement
Improve and polish your product based on user feedback. Iterate simply means repeating steps to make things better.

Memory Trick: Remember R-D-I-T-I → Real Designers Invent Terrific Ideas (Requirements, Design, Implementation, Testing, Iteration).

Key Takeaway: Always plan and test your work instead of jumping straight to the final design.

3. Data Collection Methods and Data Types

Before you can help a user, you need to collect their opinions, measurements, or facts.

Primary vs. Secondary Data

Primary Data: Data you collect first-hand yourself for your specific project.
How to collect it: Online surveys, paper forms, direct interviews, or using electronic sensors and data-loggers (like recording sound levels in a classroom).
Advantage: It is up-to-date and tailored exactly to what you need.

Secondary Data: Data that someone else has already collected and made available.
Where to find it: Open data websites, government archives, or official census records.
Advantage: Saves time and gives you access to huge amounts of information you could not collect alone.

Quantitative vs. Qualitative Data

Quantitative Data: Numerical and measurable data that deals with numbers, counts, and measurements.
Examples: Test scores, shoe sizes, temperature readings, ratings from \(1\) to \(5\).
Best used for: Calculating averages and drawing charts in spreadsheets.

Qualitative Data: Descriptive and non-numerical data that deals with words, feelings, and opinions.
Examples: Written survey comments, interview transcripts, voice recordings.
Best used for: Understanding why users feel a certain way.

Key Takeaway: Use primary and secondary sources to collect both quantitative (numbers) and qualitative (words) data for a complete picture.

4. Organising and Analysing Data with Spreadsheets

Spreadsheets are the ultimate tool for turning raw numbers into clear information.

How Data is Organised

A simple database or spreadsheet table is often called a flat-file structure:
• Field (Column): A single category of information (e.g., First Name, Age, or Score).
• Record (Row): All the details about one single person, object, or event across all fields.

Formulas vs. Functions

Every calculation in a spreadsheet MUST start with an equals sign (\(=\)). Without it, the software treats your formula as plain text!

Basic Formulas: Use standard mathematical symbols:
• Addition: \(+\)
• Subtraction: \(-\)
• Multiplication: \(*\)
• Division: \(/\)
• Exponents (Powers): \(^\)
Example: \(=\text{A}1 + \text{B}1\)

Standard Spreadsheet Functions: Pre-built shortcuts for common tasks:
• \(=\text{SUM}(\text{range})\) – Adds all numbers in the selected range together (e.g., \(=\text{SUM}(\text{A}1:\text{A}10)\)).
• \(=\text{AVERAGE}(\text{range})\) – Calculates the arithmetic mean of the values.
• \(=\text{COUNT}(\text{range})\) – Counts how many cells contain numbers.
• \(=\text{COUNTA}(\text{range})\) – Counts how many cells are not blank (includes words and numbers).
• \(=\text{MAX}(\text{range})\) – Finds the highest (maximum) value.
• \(=\text{MIN}(\text{range})\) – Finds the lowest (minimum) value.
• \(=\text{IF}(\text{logical\_test}, \text{value\_if\_true}, \text{value\_if\_false})\) – Checks if a condition is met and outputs one result if true, and another if false (e.g., \(=\text{IF}(\text{C}2 \ge 50, \text{"Pass"}, \text{"Needs Support"})\)).

Common Spreadsheet Pitfalls to Avoid

Mistake 1: Writing cell ranges with a hyphen like \(A1-A10\) instead of a colon \(A1:A10\). A hyphen tells the spreadsheet to subtract cell \(A10\) from \(A1\)!
Mistake 2: Typing static numbers (like \(=\text{SUM}(10 + 20)\)) instead of cell references (like \(=\text{SUM}(\text{A}1:\text{A}2)\)). Using cell references means your totals update automatically whenever the data changes.

Visualising Data: Choosing the Right Chart

A chart helps users understand patterns instantly. Picking the wrong chart can confuse your audience!

• Bar / Column Chart: Best for comparing separate (discrete) categories (e.g., favourite school subjects, sales per month).
• Line Graph: Best for showing continuous data and trends over time (e.g., temperature changes over \(24\) hours).
• Pie Chart: Best for showing parts or proportions of a whole (best kept to \(\le 6\) slices so it stays easy to read).
• Scatter Plot: Best for showing the relationship or correlation between two continuous variables (e.g., revision hours vs. exam marks).

Key Takeaway: Spreadsheets organise data into fields and records. Use functions like \(=\text{SUM}()\) and pick the right chart for your data type.

5. Selecting and Combining Applications & File Formats

Real-world projects require you to combine different tools across different devices—such as creating a graph in a spreadsheet, editing a photo in an image editor, and importing both into a presentation or website.

Choosing the Right File Format

Using the wrong file format can ruin your project's quality or make file sizes too large.

Data & Text Formats:
• .csv (Comma-Separated Values): A lightweight, universal plain text format where commas separate data fields. Ideal for moving table data between different software programs.
• .xlsx: Standard spreadsheet format supporting formulas, formatting, and charts.
• .txt: Basic plain text with no formatting.

Image Formats:
• .png: Lossless compression, supports transparent backgrounds. Excellent for logos, icons, and sharp diagrams.
• .jpg / .jpeg: Lossy compression (smaller file size). Great for complex photographs, but does not support transparency and loses quality if compressed too much.
• .svg: Scalable Vector Graphics. Made of mathematical lines and shapes, meaning it can be enlarged to any size without becoming pixelated or blurry!

Audio, Video, and Document Formats:
• .mp3: Compressed audio, perfect for background music or podcasts on web pages.
• .wav: High-quality, uncompressed audio with larger file sizes.
• .mp4: Standard compressed video format supported across almost all modern devices.
• .html / .css: Web document structure and styling files.
• .pdf: Preserves the exact visual layout across any computer or printer.

Key Takeaway: Match your tool and file format to the media type. Use .png or .svg for clean logos, .jpg for photos, and .csv for sharing data.

6. Meeting User Needs, Usability, and Trustworthiness

A digital project is only successful if your target audience can easily use it, understand it, and trust it.

Visual Design Principles

• Alignment: Lining up text and pictures neatly to create order.
• Contrast: Using light text on dark backgrounds (or dark text on light backgrounds) so everything is easy to read.
• Visual Hierarchy: Making the most important things larger or bolder so the user's eye is drawn to them first.
• Consistency: Using the same colour scheme, fonts, and button styles across every page.
• Whitespace: Leaving empty space around items so the screen does not feel cluttered or overwhelming.

Usability & Accessibility (Inclusivity)

Usability (User Experience / UX): How intuitive and simple a product is to navigate. Good usability reduces cognitive load (mental effort) for the user.
Accessibility: Making sure people of all abilities, including those with visual, hearing, or motor impairments, can use your digital product.
Key accessibility features:
• Adding alt text (alternative text descriptions) to images so screen readers can describe them to visually impaired users.
• Ensuring high contrast between text and background.
• Providing closed captions or subtitles for video and audio.
• Making pages keyboard-navigable for users who cannot use a mouse.

Trustworthiness, Privacy, and Legal Rules

• UK GDPR / Data Protection Act 2018: When collecting user data, you must get clear consent, collect only what is strictly necessary, keep it secure, and respect user privacy.
• Copyright & Intellectual Property: You cannot simply copy images, music, or text from the internet without permission. Always look for open licences such as Creative Commons and give proper credit (attribution) to the original creator.

Key Takeaway: Design with your user in mind: make your work clear, accessible to everyone, and legally compliant with data privacy and copyright laws.

7. Quick Review & Summary Checklist

Before completing any creative IT project, ask yourself these quick check questions:
• Did I identify my user's needs? (Did I gather primary/secondary data to guide my design?)
• Did I process my data correctly? (Did I use formulas like \(=\text{SUM}()\) or \(=\text{AVERAGE}()\) and choose the right chart?)
• Did I pick the right file formats? (e.g., .svg/.png for clear graphics, .csv for tables, .mp4 for video?)
• Is my design accessible and usable? (High contrast, clear layout, alt text on images?)
• Is my project trustworthy? (Respecting UK GDPR rules and giving credit for Creative Commons resources?)