Input Devices

Input devices are used to enter data and instructions into a computer system.

Output Devices

Output devices present processed data to the user.

Storage Devices

Internal Components

Ports and Connectors

Operating Systems

An operating system (OS) is system software that manages computer hardware and provides a platform for application software to run. It acts as an intermediary between the user and the hardware.

Key Functions of an OS

• Memory management: allocating RAM to running programs
• Processor management: scheduling tasks for the CPU
• File management: organising, storing, and retrieving files
• Device management: communicating with peripherals through drivers
• User interface: providing a way for users to interact (GUI or command line)
• Security: user accounts, passwords, access control

Application Software

Application software is designed to help users perform specific tasks.

Utility Software

Utility software performs maintenance and housekeeping tasks to keep the computer running efficiently.

Open Source vs Proprietary Software

Software Licensing

Custom vs Off-the-shelf Software

Examples of Embedded Systems

• Washing machines (controlling wash cycles)
• Cars (engine management, ABS braking, airbags)
• Smart home devices (thermostats, doorbells, smart speakers)
• Traffic lights
• Microwave ovens
• Fitness trackers

Mainframe Uses

• Banks (processing millions of transactions per day)
• Government (census data, tax processing)
• Airlines (booking systems)
• Large-scale scientific research

Types of Networks

Network Hardware

Wired vs Wireless

Network Topologies

Client-Server vs Peer-to-Peer

The Internet vs The World Wide Web

• The Internet: a global network of interconnected networks. It is the physical infrastructure (cables, routers, servers) that carries data.
• The World Wide Web (WWW): a collection of web pages and resources accessed using the internet. It uses HTTP/HTTPS protocols and web browsers. The web is a SERVICE that runs ON the internet.
• Other services that use the internet include: email, VoIP, file transfer (FTP), streaming

Cloud Computing

Cloud computing means using remote servers (hosted on the internet) to store, manage, and process data, instead of using your local computer.

Factors to Consider When Choosing a System

Key Technical Specifications

Upgrading vs Buying New

Identifying Your Audience

Before creating anything, you must decide WHO will view your portfolio:

• Teachers/assessors: want to see evidence of your skills and learning
• Potential employers: want to see practical skills and professionalism
• College/university admissions: want to see range and quality of work

Your audience affects the style, language, and level of formality you should use.

Defining the Purpose

• Showcase your best work from the BTEC course
• Demonstrate a range of ICT skills
• Provide evidence for assessment criteria
• Present a professional image of yourself

Content Planning

Plan what to include in your portfolio:

• "About Me" section — who you are, your skills, and your goals
• Best examples of your coursework from each unit
• Screenshots showing your process (not just the final product)
• Reflections on what you learned and how you improved
• Skills summary — what you can do and what software you know

Structure and Navigation

• Create a clear site map or navigation plan BEFORE building
• Use a logical structure: Home, About Me, Projects, Skills, Contact
• Every page should have consistent navigation (menu/navbar)
• Users should be able to reach any page in 2-3 clicks

Design Considerations

• Colour scheme: choose 2-3 complementary colours. Use a colour picker tool to check they work well together. Avoid clashing colours.
• Fonts: use no more than 2-3 fonts. Use one for headings and one for body text. Make sure they are readable.
• Consistency: same layout, colours, and fonts on EVERY page. This looks professional.
• Accessibility: sufficient contrast between text and background. Alt text on images. Clear font sizes (minimum 12pt for body text).
• White space: do not cram everything together. Space helps readability.

Writing an "About Me" Section

• Write in a professional but friendly tone
• Include: your name, school, course, interests related to ICT
• Mention skills you have developed
• Keep it concise — one or two paragraphs
• Include a professional photo (not a selfie with filters)

Documenting Skills and Achievements

• List the software you can use (e.g. Excel, Photoshop, Google Slides)
• Describe what you can do with each tool, not just the name
• Include any certificates, awards, or recognition
• Reference specific projects as evidence of skills

Collecting Evidence

Your portfolio needs to show the PROCESS, not just the final product:

• Screenshots: capture key stages of your work (use Snipping Tool, Print Screen, or Snip & Sketch on Windows)
• Annotated screenshots: add arrows, labels, and text to explain what is happening
• Files: original files (spreadsheets, documents, images) as evidence
• Certificates: any qualifications or course completions
• Feedback: comments from teachers, peers, or clients

Writing Reflections

For each piece of work, write a short reflection covering:

• What went well? What are you proud of?
• What was challenging? How did you overcome it?
• What would you do differently next time?
• What new skills did you develop?

Tools for Building a Digital Portfolio

Key Steps for Building

1. Set up the site structure (pages matching your plan)
2. Create a consistent navigation menu on every page
3. Add a header/banner with your name and the portfolio title
4. Add content page by page, following your plan
5. Insert and format images (resize, add alt text)
6. Embed media if needed (videos, presentations)
7. Apply consistent formatting (colours, fonts, spacing)
8. Add a footer with your name and date

Formatting Content

• Use headings (H1, H2, H3) to organise content — do not just make text bigger and bold
• Use bullet points and numbered lists for clarity
• Keep paragraphs short (3-4 sentences max)
• Use images to break up long blocks of text
• Align content consistently (left-aligned text is easiest to read)

Testing Your Portfolio

• Check ALL links work — broken links look unprofessional
• Check spelling and grammar on every page
• View on different screen sizes — does it work on mobile?
• Ask someone else to navigate it — can they find everything easily?
• Check images load correctly and are not stretched or pixelated

Getting Feedback

Getting feedback from others is essential for improving your portfolio. Ask:

• Your teacher — expert feedback on content and presentation
• Classmates — they can spot issues you have missed
• Family members — test if someone unfamiliar can navigate it

Useful Feedback Questions

• Is the navigation clear and easy to use?
• Does the design look professional and consistent?
• Is there anything confusing or hard to find?
• Are there any spelling or grammar mistakes?
• Do the images and media load correctly?

Making Improvements

• Log ALL feedback you receive (who said it, what they said)
• Prioritise changes: fix errors first, then improve design
• Take a "before" screenshot, make the change, then take an "after" screenshot
• Explain WHY you made each change

Final Review Checklist

Bitmap (Raster) vs Vector Graphics

Image File Formats

Resolution

• Resolution: the number of pixels in an image, usually expressed as width x height (e.g. 1920 x 1080 pixels)
• PPI (Pixels Per Inch): used for screen display. Higher PPI = sharper image on screen.
• DPI (Dots Per Inch): used for printing. Standard print quality is 300 DPI. Web images are typically 72 PPI.
• Higher resolution = larger file size = more storage needed

Colour Depth

Colour depth (bit depth) determines how many colours each pixel can display:

Image Size and File Size

File size is affected by three factors:

• Resolution: more pixels = bigger file
• Colour depth: more bits per pixel = bigger file
• Compression: lossy compression reduces file size but loses quality; lossless compression reduces file size while keeping quality

Formula: File size = Width x Height x Colour depth (in bits, then divide by 8 for bytes)

Understanding the Client Brief

A client brief is a document from the client (or your teacher playing the role of a client) that outlines what they want. Read it carefully and identify:

• The purpose of the graphic (advert, logo, banner, poster, social media)
• The target audience (age group, interests, demographic)
• The message to communicate
• Any specific requirements (size, colours, text, branding)
• The format and where it will be used (web, print, social media)

Mood Boards

A mood board is a collection of images, colours, textures, fonts, and design ideas that inspire your design. It helps you establish the visual style before starting.

• Include existing designs you admire
• Show colour palettes and font samples
• Can be physical (cut-out collage) or digital (using Canva, Pinterest, or PowerPoint)

Sketches and Wireframes

• Draw rough sketches of your design ideas by hand (at least 2-3 different concepts)
• Annotate your sketches explaining your design choices
• Show where text, images, and shapes will be positioned
• Include dimensions if known

Colour Schemes and Psychology

Legal Considerations

• Copyright: do NOT use images from Google Images without checking the licence. Most images are copyrighted.
• Creative Commons: some images are free to use with conditions (credit the creator, non-commercial use only). Check the specific CC licence.
• Royalty-free: images from sites like Unsplash, Pexels, and Pixabay that are free to use commercially.
• Always record where you got each image from (source/attribution)

Graphics Software Options

Setting Up Your Canvas

• Choose the correct dimensions for your purpose:
  • Web banner: 1200 x 628 pixels (Facebook) or custom
  • A4 print: 2480 x 3508 pixels at 300 DPI
  • Social media post: 1080 x 1080 pixels (Instagram square)
• Set the correct resolution: 72 PPI for screen, 300 DPI for print
• Choose your colour mode: RGB for screen, CMYK for print

Working with Layers

Layers are one of the most important features in image editing. Think of them as transparent sheets stacked on top of each other.

• Creating layers: keep different elements on separate layers (background, text, images, effects)
• Ordering: layers at the top appear in front of layers below
• Opacity: reduce a layer's opacity to make it semi-transparent
• Blending modes: change how layers interact (multiply, screen, overlay)
• Benefits: can edit one element without affecting others, can hide/show layers, can rearrange easily

Selection Tools

Working with Text

• Always put text on its own layer
• Choose readable fonts — avoid overly decorative fonts for body text
• Ensure sufficient contrast between text colour and background
• Consider text hierarchy: headings should be larger and bolder than body text

Basic Editing Techniques

Colour Adjustments

• Brightness: making the image lighter or darker overall
• Contrast: the difference between the lightest and darkest areas. High contrast = vivid; low contrast = flat/washed out.
• Colour balance: adjusting the mix of colours (warmer/cooler tones)
• Saturation: the intensity of colours. Desaturation turns an image towards greyscale.
• Hue: shifting the overall colour (e.g. making blues more purple)

Filters and Effects

• Blur: soften an image or background
• Sharpen: make edges and details clearer
• Noise: add or remove grain/texture
• Drop shadow: add depth to text or objects
• Gradient: smooth colour transitions

Retouching Tools

Compositing and Blending

Compositing means combining elements from multiple images into a single image. This uses layers, selection tools, and blending techniques.

Saving for Different Purposes

Checking Against the Brief

Go back to the original client brief and check your graphic against EVERY requirement:

• Does it match the requested size and format?
• Does it communicate the right message?
• Is it suitable for the target audience?
• Does it include all required elements (text, logo, images)?
• Does it follow any brand guidelines provided?

Gathering Feedback

• Show your graphic to at least 3-4 people
• Ask specific questions: "Is the text readable?" "Does the colour scheme work?" "What does this graphic make you think of?"
• Record their feedback in a table (person, comment, action taken)
• Include people from your target audience if possible

Comparing with Original Plan

• Place your initial sketch next to your final graphic
• Identify what changed during creation and explain WHY
• Discuss whether changes improved or weakened the design

Documenting Changes

For each change you make after feedback:

1. Screenshot the BEFORE version
2. Explain what feedback you received
3. Make the change
4. Screenshot the AFTER version
5. Explain why the change improves the design

Understanding the Task

Before opening Excel, read the brief carefully and identify:

• What data needs to be entered (inputs)?
• What calculations need to be performed (processing)?
• What results/outputs are required (outputs)?
• Who will use the spreadsheet? (their skill level matters)

Input, Processing, Output (IPO)

Every spreadsheet follows the IPO model:

Planning the Layout

• Sketch the spreadsheet layout on paper first
• Label each column and row clearly
• Identify where input cells, formula cells, and output cells will go
• Leave space for charts and summary sections
• Consider using multiple sheets (tabs) for different sections

Data Types

Data Validation

Data validation restricts what data can be entered into a cell, reducing errors.

To set up validation in Excel: Data tab > Data Validation > choose type and set rules.

Conditional Formatting

Conditional formatting automatically changes the appearance of cells based on their values.

• Highlight cells above/below a threshold (e.g. red for scores below 40%)
• Colour scales (gradient from green to red)
• Data bars (mini bar charts within cells)
• Icon sets (arrows, traffic lights)
• To apply: Home tab > Conditional Formatting

Protecting Cells and Sheets

• Cell protection: lock cells containing formulas so users cannot accidentally overwrite them
• Unlock only the cells where users need to enter data
• To protect: Format Cells > Protection tab > tick "Locked", then Review > Protect Sheet
• Sheet protection: add a password to prevent changes to the sheet structure

Named Ranges

A named range assigns a meaningful name to a cell or group of cells, making formulas easier to read.

Instead of: =SUM(B2:B50)
You write: =SUM(SalesTotal)

To create: select cells > type the name in the Name Box (top-left of Excel) > press Enter.

Arithmetic Operators

Essential Functions

IF Function

The IF function performs a logical test and returns one value if TRUE and another if FALSE.

=IF(logical_test, value_if_true, value_if_false)

Example: Grade a student based on score
=IF(B2>=50, "Pass", "Fail")

If B2 is 65 → result is "Pass"
If B2 is 35 → result is "Fail"

Nested IF

A nested IF places one IF function inside another to handle multiple conditions:

=IF(B2>=70, "Distinction",
   IF(B2>=60, "Merit",
     IF(B2>=50, "Pass", "Fail")))

If B2 is 75 → "Distinction"
If B2 is 63 → "Merit"
If B2 is 52 → "Pass"
If B2 is 40 → "Fail"

VLOOKUP

VLOOKUP (Vertical Lookup) searches for a value in the first column of a table and returns a value from another column in the same row.

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

lookup_value  = what you are searching for
table_array   = the table to search in
col_index_num = which column to return (1st column = 1)
range_lookup  = FALSE for exact match, TRUE for approximate

Step-by-Step VLOOKUP Example

Scenario: You have a product code in cell A2 and want to look up its price from a price list in cells F2:H20.

=VLOOKUP(A2, F2:H20, 3, FALSE)

A2       = the product code to search for
F2:H20   = the table containing product codes (col 1),
           names (col 2), and prices (col 3)
3        = return the value from the 3rd column (price)
FALSE    = find an EXACT match only

CONCATENATE / &

Joins text from multiple cells into one:

=CONCATENATE(A2, " ", B2)
   or
=A2 & " " & B2

If A2 = "John" and B2 = "Smith"
Result: "John Smith"

Date Functions

Absolute References ($)

When you copy a formula, cell references normally change (relative references). An absolute reference uses the $ sign to lock a reference so it does NOT change when copied.

Relative: =A1*B1  (changes when copied)
Absolute: =A1*$B$1 (B1 stays fixed when copied)

$B$1 = both column and row locked
$B1  = column locked, row changes
B$1  = column changes, row locked

Use case: A VAT rate in cell B1 (e.g. 20%)
Formula: =A2*$B$1
When copied down, A2 changes to A3, A4...
but $B$1 always stays as B1

Choosing the Right Chart Type

Formatting Charts

• Chart title: clear, descriptive title (e.g. "Monthly Sales Revenue January-December 2025")
• Axis labels: label the X and Y axes with what they represent and units
• Legend: include a legend if there are multiple data series
• Colours: use contrasting colours for different data series. Avoid 3D effects — they distort data.
• Data labels: optionally show exact values on the chart

Trendlines

A trendline is a line added to a chart to show the general direction of the data (upward trend, downward trend, or flat). Useful for spotting patterns and making predictions.

Creating a Test Plan

A test plan is a structured document that lists all the tests you will carry out to check your spreadsheet works correctly.

Test Plan Table Format

Types of Test Data

Documenting Test Results

• Fill in the "Actual Result" column after performing each test
• Take a screenshot showing the test being performed
• If a test fails, explain what went wrong and how you fixed it
• Re-test after fixing to confirm the issue is resolved

Evaluation

A good evaluation considers:

• Does the spreadsheet meet ALL requirements from the brief?
• What works well?
• What could be improved?
• Is it easy for the target user to use?
• Did you get feedback from others? What did they say?
• If you had more time, what would you add or change?

Grade Boundaries

BTEC First uses four grade levels:

How Grades are Calculated (Points System)

Each unit grade is converted to points. Your overall qualification grade is based on the total points across all units.

Internal vs External Assessment

Verification and Moderation

• Internal verification: another teacher in your school checks a sample of work to ensure consistent marking
• External moderation (Standards Verification): Pearson sends a representative to check a sample of student work to ensure national standards are met
• This is why your work must be your own — the verifier may ask you questions about it

Screenshot Techniques

• Windows Snipping Tool / Snip & Sketch: Win+Shift+S to capture a specific area
• Print Screen: captures the entire screen. Paste into Paint or Word.
• Alt+Print Screen: captures only the active window
• Always crop screenshots to show only the relevant content

Annotating Screenshots

A screenshot without explanation is almost worthless. Always add:

• Arrows pointing to key features
• Text boxes explaining what is being shown
• Numbered steps for processes
• Highlighting (circles, boxes) around important areas
• Use Microsoft Word's Insert > Shapes to annotate, or use Snip & Sketch's built-in tools

Explaining Your Choices — the WHY

The biggest difference between a Pass and a Merit/Distinction is EXPLANATION.

Planning Evidence

• Hand-drawn sketches and wireframes (photograph them)
• Mind maps showing your ideas
• Written plans listing what you will create
• Mood boards (for graphics units)
• IPO tables (for spreadsheet units)

Review and Evaluation

A strong evaluation is honest and specific:

• Refer back to the original brief — did you meet every requirement?
• Be specific about what worked well: "The VLOOKUP function correctly returns the product price when a valid product code is entered"
• Be honest about weaknesses: "The chart labels are difficult to read at small sizes — I would increase the font size if I had more time"
• Suggest specific improvements, not vague ones

Meeting ALL Criteria

• Print out the unit assessment criteria and tick them off as you complete each one
• Each criterion starts with a command word (describe, explain, evaluate) — make sure your evidence matches
• If even ONE Pass criterion is missing, you cannot pass the unit
• You must meet ALL Pass criteria before Merit criteria count, and ALL Merit before Distinction

The Biggest Mistakes Students Make

File Naming Best Practice

Good: Unit2_Hardware_Research_JSmith.docx
Good: Unit6_Logo_Final_v3.png
Good: Unit9_SalesSpreadsheet_Tested.xlsx

Bad: Document1.docx
Bad: untitled.png
Bad: New Microsoft Excel Worksheet.xlsx

Folder Structure

BTEC ICT/
  Unit 1 - The Online World/
    Revision Notes/
    Practice Exams/
  Unit 2 - Technology Systems/
    Research/
    Final Portfolio/
  Unit 3 - Digital Portfolio/
    Planning/
    Content/
    Final Version/
  Unit 6 - Digital Graphics/
    Mood Board/
    Sketches/
    Working Files/
    Final Graphics/
  Unit 9 - Spreadsheets/
    Planning/
    Spreadsheet Files/
    Testing/
    Final Submission/

Before the Exam

• Revise using these notes — tick off topics as you feel confident
• Complete the practice quiz on the Unit 1 tab
• Practice with past papers (available from your teacher or the Pearson website)
• Create flashcards for key terms
• Teach a topic to someone else — if you can explain it, you understand it
• Get a good night's sleep before the exam

During the Exam

• Read the question carefully — underline the command word (define, describe, explain, discuss, evaluate)
• Check the marks — the number of marks tells you how many points to make
• Use technical vocabulary — "encryption" not "scrambling", "phishing" not "fake emails"
• Apply to the scenario — if the question describes a business, reference that business in your answer
• Time management — 1 hour for 50 marks = roughly 1 minute per mark
• Do not leave blanks — always write something, even if you are unsure
• Check your answers — use any remaining time to review

Command Words Reminder

Definition

A database is an organised collection of structured data, stored electronically so it can be easily accessed, managed, and updated. Databases are used everywhere — schools store student records, hospitals store patient information, and online shops store product catalogues.

Flat File vs Relational Databases

Key Terminology

• Table — a collection of related data organised into rows and columns (e.g. a Customers table, a Products table)
• Record — a single row in a table, representing one complete entry (e.g. one customer's details)
• Field — a single column in a table, representing one category of data (e.g. Surname, Date of Birth)

Example Table: Students

In this example: StudentID, FirstName, Surname, DateOfBirth, FormGroup are the fields. Each row (e.g. Aoife Murphy's details) is a record.

Data Types

Primary Key

A primary key is a field (or combination of fields) that uniquely identifies every record in a table. No two records can have the same primary key value, and it cannot be left blank (null).

• Examples: StudentID, ISBN, OrderNumber, NationalInsuranceNumber
• Often an AutoNumber field is used to guarantee uniqueness

Foreign Key

A foreign key is a field in one table that links to the primary key of another table. It creates a relationship between the two tables.

Example: In an Orders table, the CustomerID field is a foreign key that links to the CustomerID primary key in the Customers table.

Types of Relationship

Referential Integrity

Referential integrity means you cannot add a foreign key value that does not exist in the related primary key table. For example, you cannot create an order for CustomerID 999 if that customer does not exist in the Customers table. This prevents orphan records and keeps data consistent.

What is a Query?

A query is a request to retrieve, filter, or manipulate data from a database. In Microsoft Access, you can create queries using the visual Query Design view or by writing SQL (Structured Query Language).

Basic SQL Syntax

SELECT FieldName1, FieldName2
FROM TableName
WHERE Condition
ORDER BY FieldName ASC;

SQL Keywords Explained

SQL Examples

Find all students in form 8A:

SELECT FirstName, Surname
FROM Students
WHERE FormGroup = '8A'
ORDER BY Surname ASC;

Find products costing more than 10 pounds:

SELECT ProductName, Price
FROM Products
WHERE Price > 10
ORDER BY Price DESC;

Using AND / OR for multiple conditions:

SELECT FirstName, Surname, FormGroup
FROM Students
WHERE FormGroup = '8A' AND Surname LIKE 'M%';

The LIKE keyword with % is a wildcard — 'M%' means "starts with M".

Forms

A form provides a user-friendly interface for entering and editing data. Instead of typing directly into a table (which risks errors), forms can include:

• Drop-down lists — limit choices to valid options
• Input masks — force data into a specific format (e.g. phone number)
• Validation rules — reject invalid data automatically
• Labels and instructions — guide the user on what to enter
• Navigation buttons — move between records easily

Reports

A report is a formatted, printable summary of data from a database. Reports are used to present information clearly for an audience. Features include:

• Grouped data (e.g. orders grouped by customer)
• Calculated fields (e.g. totals, averages, counts)
• Headers and footers with titles, dates, page numbers
• Sorting and filtering to show specific subsets of data

Database Design Considerations

• Normalisation — the process of organising data to reduce redundancy. Split data into separate tables and link with relationships.
• Data integrity — ensuring data is accurate, consistent, and not corrupted. Achieved through validation, data types, and referential integrity.
• Validation — rules that check data is reasonable (e.g. a date of birth cannot be in the future, a quantity cannot be negative).
• Verification — checking data has been entered correctly (e.g. double entry, proofreading, visual check).
• Security — passwords to access the database, user permissions (read-only vs edit), encryption of sensitive data, regular backups.

What is HTML?

HTML (HyperText Markup Language) is the standard language for creating web pages. It uses tags (enclosed in angle brackets) to define the structure and content of a page. HTML is NOT a programming language — it is a markup language.

Basic Page Structure

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>My Web Page</title>
</head>
<body>
    <h1>Welcome to My Page</h1>
    <p>This is a paragraph of text.</p>
</body>
</html>

Common HTML Tags

HTML Table Example

<table border="1">
    <tr>
        <th>Name</th>
        <th>Age</th>
    </tr>
    <tr>
        <td>Aoife</td>
        <td>14</td>
    </tr>
</table>

HTML Forms

<form action="submit.php" method="post">
    <label for="name">Name:</label>
    <input type="text" id="name" name="name">

    <label for="email">Email:</label>
    <input type="email" id="email" name="email">

    <label for="msg">Message:</label>
    <textarea id="msg" name="msg"></textarea>

    <input type="submit" value="Send">
</form>

What is CSS?

CSS (Cascading Style Sheets) controls the visual presentation of a web page — colours, fonts, spacing, layout. CSS is kept separate from HTML to follow the principle of separation of concerns (structure vs presentation).

Three Ways to Add CSS

CSS Selectors

Common CSS Properties

body {
    font-family: Arial, sans-serif;  /* Font */
    background-color: #f0f0f0;       /* Background colour */
    color: #333333;                   /* Text colour */
    margin: 0;                        /* Space outside element */
    padding: 20px;                    /* Space inside element */
}

h1 {
    color: #e94560;                   /* Heading colour */
    border-bottom: 2px solid #ccc;    /* Bottom border */
    padding-bottom: 10px;             /* Space above border */
    text-align: center;               /* Centre the text */
}

.card {
    background: white;
    border: 1px solid #ddd;
    padding: 16px;
    margin-bottom: 12px;
    border-radius: 4px;               /* Rounded corners */
}

The Box Model

Every HTML element is treated as a box with four layers:

• Content — the actual text or image
• Padding — space between content and border
• Border — a visible line around the element
• Margin — space outside the border, separating it from other elements

Page Layout Concepts

• Header — top of the page, usually contains the logo, site name, and navigation
• Navigation (nav) — links to other pages on the site, often a horizontal menu bar or sidebar
• Main content area — the primary information for that page
• Sidebar — additional content alongside the main area (related links, ads, filters)
• Footer — bottom of the page, contains copyright, contact info, legal links

Testing Websites

Before publishing, websites must be thoroughly tested:

Accessibility Basics

• Alt text — every image must have an alt attribute describing the image for screen readers and when images fail to load
• Semantic HTML — use meaningful tags like <header>, <nav>, <main>, <footer>, <article> instead of generic <div> everywhere
• Colour contrast — ensure text is readable against the background (dark text on light background or vice versa)
• Keyboard navigation — users who cannot use a mouse must be able to navigate using Tab and Enter keys
• Font size — text should be resizable and not too small

Website Hosting

• Web hosting — a service that stores your website files on a server so they are accessible on the internet 24/7
• Domain name — the human-readable address (e.g. www.example.com) that maps to the server's IP address via DNS
• Web server — a computer running software (like Apache or Nginx) that delivers web pages to browsers when requested
• FTP (File Transfer Protocol) — used to upload website files from your computer to the web server
• Free hosting options exist (e.g. GitHub Pages) but paid hosting provides more features, storage, and reliability

Definition

Programming is the process of writing instructions (code) that a computer can execute to perform a specific task. A program is a set of these instructions, and a programming language is the formal language used to write them.

Why Learn Programming?

• Develop problem-solving and logical thinking skills
• Automate repetitive tasks
• Create websites, apps, games, and software
• Understand how the technology around you works
• Programming skills are in high demand across many industries

Choosing a Programming Language

The Three Basic Constructs

All programs, no matter how complex, are built from three fundamental constructs:

1. Sequence

Sequence means instructions are executed one after another, in order, from top to bottom.

# Python - Sequence example
name = input("What is your name? ")
print("Hello, " + name)
print("Welcome to the program!")

2. Selection (Decisions)

Selection means the program chooses which path to follow based on a condition (IF...THEN...ELSE).

# Python - Selection example
age = int(input("Enter your age: "))
if age >= 18:
    print("You are an adult.")
elif age >= 13:
    print("You are a teenager.")
else:
    print("You are a child.")

3. Iteration (Loops)

Iteration means repeating a block of code. There are two main types:

# FOR loop — prints 1 to 5
for i in range(1, 6):
    print(i)

# WHILE loop — keeps asking until correct
password = ""
while password != "secret123":
    password = input("Enter password: ")
print("Access granted!")

Variables

A variable is a named storage location in the computer's memory that holds a value. The value can change while the program runs.

# Creating variables in Python
name = "Callum"          # String (text)
age = 14                  # Integer (whole number)
height = 1.65             # Float (decimal number)
is_student = True         # Boolean (True/False)

Data Types in Programming

Input and Output

# INPUT — getting data from the user
name = input("Enter your name: ")
age = int(input("Enter your age: "))

# OUTPUT — displaying results to the user
print("Your name is " + name)
print("Next year you will be", age + 1)

Flowcharts

A flowchart is a visual diagram that shows the steps in an algorithm using standard symbols:

Pseudocode

Pseudocode is a way of writing an algorithm in structured English. It looks like code but is not tied to any specific programming language. It helps you plan your logic before writing actual code.

BEGIN
    OUTPUT "Enter a number: "
    INPUT number
    IF number > 0 THEN
        OUTPUT "Positive"
    ELSE IF number < 0 THEN
        OUTPUT "Negative"
    ELSE
        OUTPUT "Zero"
    ENDIF
END

Pseudocode for a Loop

BEGIN
    SET total = 0
    FOR i = 1 TO 10
        INPUT mark
        total = total + mark
    NEXT i
    average = total / 10
    OUTPUT "Average mark is: " + average
END

Types of Error

Debugging Techniques

• Trace table — manually track variable values through each line of code to find where it goes wrong
• Print statements — add print() at key points to see what values variables hold
• Commenting out code — temporarily disable lines to isolate the problem
• Reading error messages — they tell you the line number and type of error
• Breakpoints — pause the program at a specific line and step through code one line at a time (in an IDE)

Test Data

What is AI?

Artificial Intelligence (AI) refers to computer systems that can perform tasks that normally require human intelligence — such as recognising speech, making decisions, translating languages, and identifying objects in images.

Machine Learning

Machine learning is a branch of AI where computers learn from data and improve over time without being explicitly programmed for every scenario. The system is trained on large datasets and finds patterns.

• Training data — the examples the system learns from (e.g. thousands of photos of cats and dogs)
• Model — the pattern or rules the system discovers from the training data
• Prediction — using the model to classify new, unseen data (e.g. "this new photo is a cat")

Practical AI Applications

What is IoT?

The Internet of Things (IoT) refers to everyday physical objects ("things") that are connected to the internet, allowing them to collect and exchange data. These devices contain sensors, processors, and network connectivity.

IoT Examples

Benefits and Risks of IoT

What is Blockchain?

A blockchain is a digital ledger (record book) where transactions are recorded across many computers in a way that makes it extremely difficult to alter past records. Each block contains a set of transactions and a link to the previous block, forming a chain.

Key Features

• Decentralised — no single person or organisation controls it; copies exist on thousands of computers
• Immutable — once a block is added, it cannot be changed or deleted
• Transparent — all participants can see the transaction history
• Secure — uses advanced cryptography (hashing) to protect data

Uses of Blockchain

Augmented Reality (AR)

Augmented Reality overlays digital content (images, text, 3D models) onto the real world, viewed through a phone, tablet, or headset. The real environment is still visible.

• Examples: Pokemon Go, Snapchat filters, IKEA Place (preview furniture in your room), Google Maps AR navigation
• Uses: education (anatomy overlays), retail (virtual try-on), maintenance (step-by-step repair guides)

Virtual Reality (VR)

Virtual Reality creates a completely immersive digital environment. The user wears a headset that blocks out the real world entirely.

• Examples: Meta Quest, PlayStation VR, HTC Vive
• Uses: gaming, training simulations (pilots, surgeons), virtual tourism, therapy (treating phobias)

AR vs VR Comparison

5G and Future Connectivity

5G is the fifth generation of mobile network technology, offering significantly faster speeds, lower latency (delay), and the ability to connect many more devices simultaneously.

5G enables: real-time remote surgery, autonomous vehicles, massive IoT deployments, seamless cloud gaming, and high-quality video streaming on the move.

Positive Impacts

• New job roles — AI engineers, data scientists, IoT technicians, cybersecurity analysts, drone operators
• Improved healthcare — faster diagnosis, remote monitoring, personalised treatment plans
• Education — VR field trips, AI tutoring, personalised learning paths
• Environment — smart energy systems, precision agriculture reducing waste, remote working reducing commuting
• Accessibility — voice assistants help visually impaired users, real-time translation breaks language barriers

Negative Impacts

• Job displacement — automation replacing repetitive jobs (factory workers, cashiers, drivers)
• Digital divide — not everyone has access to new technology, widening inequality
• Privacy erosion — more devices collecting more data about our lives
• AI bias — AI systems can reflect and amplify biases present in their training data
• Cybersecurity threats — more connected devices means a larger attack surface for hackers
• Misinformation — AI-generated deepfakes and fake content becoming harder to detect

Common Video Formats

Key Concepts

• Codec — software that compresses (encodes) and decompresses (decodes) video. Common codecs: H.264, H.265 (HEVC)
• Resolution — the number of pixels (e.g. 1920x1080 = Full HD, 3840x2160 = 4K). Higher resolution = sharper image but larger file
• Frame rate — frames per second (fps). Standard is 24-30fps; 60fps gives smoother motion
• Bit rate — the amount of data processed per second. Higher bit rate = better quality but bigger file

The Editing Timeline

Video editing software uses a timeline — a horizontal bar representing the duration of your project. You drag clips, audio, and effects onto the timeline and arrange them in order.

• Video track — where video clips are placed
• Audio track — where music, voiceover, and sound effects are placed
• Playhead — the marker that shows the current position in the timeline

Key Editing Techniques

Common Video Editing Software

Audio Editing Basics

• Recording — capture voice or sounds using a microphone. Record in a quiet environment to minimise background noise.
• Trimming — remove silence, mistakes, or unwanted sections from the beginning and end
• Normalisation — automatically adjust the volume so the loudest part reaches a standard level
• Noise reduction — remove background hiss, hum, or ambient noise
• Fade in / fade out — gradually increase or decrease volume at the start or end

Free audio editing software: Audacity (cross-platform, widely used in schools)

Common Audio Formats

Compression for Web and Streaming

Compression reduces file size so files can be downloaded and streamed faster. There are two types:

Multimedia Project Planning

Before creating any multimedia product, you must plan thoroughly. Good planning saves time and leads to a better final product.

• Client brief — a document from the client describing what they want, the target audience, purpose, and constraints
• Target audience — who will use/view the product? This affects style, language, tone, and content
• Purpose — why is the product being created? (inform, entertain, educate, promote, persuade)
• Requirements — file format, duration, resolution, platform, budget, deadline
• Assets list — all the files you need: video clips, images, audio, graphics, fonts

Storyboarding

A storyboard is a visual plan that maps out each scene or section of a video/animation before production begins. Each frame typically includes:

• Scene number — the order of scenes
• Sketch/image — a rough drawing of what will appear on screen
• Description — what is happening in the scene
• Dialogue/narration — any spoken words
• Audio/music — background music or sound effects
• Duration — how long the scene lasts
• Camera/transition — camera angle, movement, and transition to next scene

Review and Feedback

• Get feedback from your target audience — do they understand the message?
• Review against the original brief — does it meet all the requirements?
• Test on different devices — does it play correctly on phone, tablet, and computer?
• Check file sizes — are they appropriate for the delivery method (web, email, USB)?

What Each Grade Level Requires

BTEC assignments are marked against specific criteria. Each criterion has a command word that tells you exactly what depth of response is expected. Understanding this is the single most important skill for achieving higher grades.

Command Words in Detail

Pass-Level Command Words

Merit-Level Command Words

Distinction-Level Command Words

How to Move from Pass to Merit to Distinction

Here is the same topic answered at all three levels, so you can see exactly what changes:

Topic: Benefits of cloud storage for a small business

Common Mistakes That Keep Students at Pass Level