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.
11 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
- 8
Computer Networks and Their Types
We find out why computers are connected into networks, what types of network exist (LAN, WAN), the main devices, and what an IP address is.
Chapter 3. Computer Networks and the Web1 min
- 9
HTML: Your First Web Page
We get to know HTML and learn to create a simple web page with a heading, text, a list, a link and a picture using tags.
Chapter 3. Computer Networks and the Web1 min