Computing
Spreadsheets, web pages, functions, micro:bit, AI and staying safe online.
Skills
- Spreadsheets and formulas
- Making a web page
- Functions (reusable code)
- Controlling a micro:bit
- What is AI and how it learns
- Checking AI answers
- Scams and phishing
- Privacy settings
- Copyright
Lessons
Spreadsheets and formulas
A spreadsheet is a grid of cells, each named by its column letter and row number, like B3. Formulas start with = and calculate automatically when numbers change. Examples: =A1+B1 adds two cells; =SUM(B2:B6) adds a column; =B2*C2 multiplies price by quantity. Tip: Plan a party budget in a spreadsheet and change the numbers.
Making a web page
Web pages are written in HTML. Tags tell the browser what each part is, like a heading or paragraph. Links join pages together. Examples: <h1>My Hobbies</h1> is a big heading; <p>I love football.</p> is a paragraph; <a> tags make links. Tip: Plan your page on paper first: heading, text, picture, links.
Functions (reusable code)
A function is a named block of code that does one job. You write it once and use (call) it whenever you need it. This keeps programs short and tidy. Examples: define drawSquare: repeat 4, move 50, turn 90; Call drawSquare three times in different places; In Scratch, "My Blocks" are functions. Tip: If you copy the same code twice, make it a function.
Controlling a micro:bit
The BBC micro:bit is a small programmable computer. It has a 5 × 5 grid of LED lights, two buttons and sensors, like a motion sensor and a temperature sensor. Examples: On button A pressed: show a heart; On shake: show a random number (a dice); Show the temperature on the LEDs. Tip: Try the free online micro:bit simulator before using a real one.
What is AI and how it learns
Artificial intelligence (AI) is computer software that can do tasks that usually need human thinking. Many AI systems learn by finding patterns in huge amounts of examples, called training data. Examples: An AI shown thousands of cat photos learns to spot cats; Voice assistants turn speech into text; Chatbots write answers based on patterns in text. Tip: Think: what examples would you give an AI to learn to spot apples?
Checking AI answers
AI can sound confident but still make mistakes, or even make things up. Always check important facts in trusted sources, and think about whether the answer makes sense. Examples: Check dates and facts in a book or trusted website; AI might be biased if its training data was; Ask an adult before using AI tools. Tip: Treat AI like a helper, not the final word.
Scams and phishing
Phishing is when someone sends a fake message to trick you into clicking a link or giving away information. Scams often promise prizes or say something is urgent. Examples: "You've won a free phone! Click here"; "Your account will close today, enter your password"; Odd spelling or a strange sender address. Tip: If it seems too good to be true, it probably is. Don't click; tell an adult.
Privacy settings
Privacy settings control who can see what you share and who can contact you. Setting accounts to private and turning off location sharing helps keep you safe. Examples: Set profiles to private; Turn off location in apps and photos; Only accept friend requests from people you know. Tip: Check privacy settings with an adult whenever you start a new app.
Copyright
Copyright means the person who creates something, like a picture, song or story, owns it. You need permission to copy or share their work. Some creators allow reuse with a Creative Commons licence. Examples: Don't copy someone's artwork and say it's yours; Credit the source of pictures in your project; Look for images that are free to reuse. Tip: Always write where you found information and pictures.