Informatics — Grade 8
Spreadsheets, formulas and charts, databases, computer networks, HTML/CSS and the binary number system.
- 11 topics
- 4 chapters
- 11 min
Topics
Topics are grouped into chapters and listed in reading order.
7 topics
- 1
Cells, Rows and Columns
A spreadsheet is used to enter data and calculate with it. We learn what columns, rows, cells and ranges are, and how a cell address is written.
Chapter 1. Spreadsheets1 min
- 2
Formulas and Functions
The main strength of a spreadsheet is automatic calculation. We learn to write formulas, use cell addresses and work with the SUM, AVERAGE, MAX and MIN functions.
Chapter 1. Spreadsheets1 min
- 3
Charts and Graphs
We learn to show the numbers in a table visually with charts: how to create them, tell the types apart and choose the right one.
Chapter 1. Spreadsheets1 min
- 4
Sorting and Filtering Data
We learn to put data in order in a spreadsheet and to show only the rows we need.
Chapter 1. Spreadsheets1 min
- 5
Databases: Tables and Records
A database is an organized collection of related data. We learn about tables, fields, records and key fields, as well as sorting and filtering.
Chapter 2. Databases1 min
- 6
Searching and Queries in a Database
We learn how to write a query to find the records we need in a database, using conditions and sorting.
Chapter 2. Databases1 min
- 7
Primary Keys and Relationships Between Tables
We learn about the primary key that identifies a record uniquely and how linking tables helps avoid repeating data.
Chapter 2. Databases1 min