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 |
Sorting, filtering and charts
PracticalPresent ▶
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
- Sort a table by one column without mixing up the rows.
- Use a filter to show only the rows that match, like one house.
- Choose a bar, line or pie chart for a question, and explain why.
Success criteria
- I can sort the sports-day sheet from highest to lowest score.
- I can filter the sheet to show one house only.
- I can make a chart and say why I chose that type.
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.