Informatics · Year 1
Practical lessons platform
36 topics. Each takes ~80 minutes: theory, an interactive demo, guided practice, independent practical work and a final test. Answers are checked automatically.
Sign in to start0Lessons completed
36Lessons remaining
0%Average score
0Learning time (min)
🔒 Locked▶ Not started
🟡 In progress🟢 Completed⭐ Mastered
⏳ Coming soon
Information and Computer Systems
Lessons 1–7
1
Data, information and knowledge base. Data sources. Quality of information
2
Coding, encoding and encryption. Symmetric and asymmetric encryption
3
Verifying data. Visual check and double data entry
4
Hardware. Internal and external devices. Storage devices. System software, drivers
5
Application software. Photo editing software
6
Video editing software. Web page development software
7
User interface controls. Utility software. Custom-written and off-the-shelf software
Sensors and Cybersecurity
Lessons 8–10
8
Sensors: motion, pressure, humidity, temperature and light. Electronic safety
9
Phishing, pharming, vishing, trojan, worm, spyware, rootkit, adware, ransomware. Protection
10
Health and safety (test)
Digital Society and Networks
Lessons 11–14
11
Digital divide: concept, causes and the situation in different countries
12
Computer networks. LAN and WAN. Client-server and peer-to-peer. VPN
13
Intranet and extranet. The internet and its features. Online communication. Mobile networks
14
Video and web conferencing. Impact of video conferencing on society. Zoom
Expert Systems and Data Processing
Lessons 15–18
15
Expert systems. Knowledge base and inference engine
16
User interface. Using expert systems
17
Data processing systems
18
Real-time processing systems. Final check
Spreadsheets
Lessons 19–28
19
Creating a spreadsheet. Managing rows and columns. Spreadsheet security
20
Freezing panes. Formatting. Conditional formatting
21
Formulas and functions. Relative and absolute references
22
Named cells and ranges. Rounding functions
23
Date and time functions. Conditional functions. INDEX and MATCH
24
Conditional statistical functions. Validation rules
25
Data entry validation. Filtering and sorting
26
Pivot tables and charts. Import and export
27
Graphs and charts (test)
28
Modelling. Simulators
Databases
Lessons 29–36
29
Creating a database. Data types and field sizes
30
One-to-one, one-to-many and many-to-many relationships
31
Creating relationships. Flat-file and relational databases
32
Import. Building a relational database. Primary, compound and foreign keys
33
Referential integrity. Validation and verification. Complex, nested and summary queries
34
Static and dynamic parameters. Calculated fields. Sorting. Data entry forms
35
Reports. Export. Normalisation: 1NF, 2NF, 3NF
36
Data dictionary. File management. Management information systems. Final assessment