Charts
| Chart | Use it for | Example |
|---|---|---|
| Bar | Comparing categories | Votes per club |
| Line | Change over time | Temperature each hour |
| Pie | Parts of one whole | How you spend 24 hours |
| Scatter | Is there a link? | Revision hours vs score |
Visualising; correlation vs causation
TheoryPresent ▶
What this lesson covers
Topic 18 Data, spreadsheets and AI
KS3 Computing · Data is raw facts. Information is data with meaning. Spreadsheets calculate, databases store and search, and AI learns patterns from examples.
Managing DataCambridge Lower Secondary Computing 0860
You will learn to
- Choose a bar, line, pie or scatter chart to fit a question, and explain the choice.
- Make a scatter chart of two columns and describe the pattern: positive, negative or none.
- Explain why a correlation does not prove that one thing causes the other.
- Identify a hidden third factor, like hot sunny weather behind ice cream sales and sunburn.
Success criteria
- I can make a scatter chart with both axes labelled.
- I can describe a correlation in one sentence: 'As … goes up, … goes up (or down).'
- I can explain the ice cream and sunburn link without saying one causes the other.
Key words
Say each word, then read what it means. Every one is in the glossary too.
- Formula
- A spreadsheet calculation. Always starts with =.
- Function
- A subroutine that returns a value.
- Record / field
- One row in a database table: everything stored about one thing.
- Primary key
- A field whose value is unique for every record.
- SQL
- Structured Query Language: asks databases questions.
- Machine learning
- The computer finds rules itself from labelled examples.
The explanation
Read it here, or open the study page below to go one step at a time with things to try.
Study it
Open the study page and go one step at a time.
Check yourself
One question at a time. The reason shows after each answer.
Saved on this device.