11.3.3.1 distinguish between laws of Boolean logic
11.3.3.2 simplify logical expressions using the laws of Boolean logic

11.5.1.1 distinguish between generations of programming languages
11.5.1.2 classify programming languages into low and high-level
11.5.1.5 analyze advantages and disadvantages of high-level languages
11.5.1.6 analyze the advantages and disadvantages of low-level languages

11.2.1.1 explain the life cycle stages used in the solving of problems
11.2.1.2 analyze the advantages and disadvantages of cyclical, waterfall, and spiral models

Theory and Tasks 2022 
"SDLC"
Theory and Tasks 2024 
"Models of SDLC"

11.4.1.1 describe relational databases and their purpose
11.4.1.2 use the terms attribute, object, index, record, table, and tuple to describe databases
11.4.1.4 define data types when creating a database
11.4.1.3 explain the difference between primary, composite, and foreign key

11.4.1.6 define the connections between tables in a database
11.4.1.3 explain the difference between primary composite and foreign key
11.4.1.7 create an entity-relationship (ER) model

11.4.2.1 explain the purpose of the data dictionary
11.4.2.2 compare the data definition language (DDL), and the data manipulation language (DML) 
11.4.2.3 describe the basic SQL queries for working with tables in a database: CREATE, ALTER, and DROP
11.4.2.4 describe the basic SQL queries for working with one table in a database: SELECT, UPDATE, INSERT, and DELETE
11.4.2.5 use SQL SELECT for data selection in more tables

"SQL. Data Definition Language"

Theory and Tasks 2021 
"Data dictionary"

Theory and Tasks 2021 
"SQL. Data Manipulation Language"

Practice 2022 
"Create MySQL database. Add a new record. Select, update, and delete data"

11.2B Designing a new system
SMART objectives

11.2B Project work. ERD. Data dictionary
11.4.1.4 define data types when creating a database
11.4.1.7 create an entity-relationship (ER) model

11.2B Prototyping
11.2.2.4 discuss the advantages and disadvantages of using prototypes when developing solutions

11.2.2.7 define minimum requirements for hardware when implementing solutions
11.3.1.5 justify their choice of applied software and choice criteria based on the goals 

11.2B Intended benefits and Limits of the scope of the solution
11.2.2.1 analyse the advantages of a new system 
11.2.2.2 analyse the restrictions of a new system 

11.3B HTML. Structure of HTML-document

11.5.3.1 create a site using basic HTML tags

11.5.3.2 create forms for data entry using HTML tags

11.3B CSS. Tags <DIV>, <SPAN>

11.5.3.3 use the CSS stylesheet when creating a site

11.5.3.8 use script language to provide interactivity
11.5.3.6 use various algorithmic structures in a scripting language

"Algorithmic structures"

Theory & Tasks 2023 
"Script language"

11.3B PHP & MySQL database. Connect to database

11.5.3.4 use script language to connect a database 

Создание регистрации на сайте

User registration system (video)

11.3A 1D, 2D Arrays

11.5.2.1 use the technical terms associated with arrays including upper and lower bounds 

11.5.2.3 write program code using 1D and 2D arrays 

"Arrays"

Theory & Tasks 2023
"2D arrays (Matrix)"

11.5.2.4 write an algorithm /pseudo-code for sorting by insertion and bubble sort  

11.3A Binary search

11.5.2.5 write a pseudo-code of binary search for the solution of a specific problem

11.5.2.6 to understand the time-efficiency of algorithms 

11.5.2.7 to understand the space-efficiency of algorithms 

11.4A Basic algorithmic structure

11.5.3.9 write a program code using a basic algorithmic "sequential" structure when developing a project  

11.5.3.10 write a program code using a basic algorithmic "branching" structure when developing a project  

11.5.3.11 write a program code using a basic algorithmic "loop" structure when developing a project 

11.1.2.5 explain the difference between the terms verification and validation

11.4A Good programming style

11.5.3.12 follow the rules of good programming style when writing a program code

11.1.2.1 explain the difference between the terms security, privacy, and data integrity

11.4B Data backup and Disk mirroring

11.1.2.3 describe data protection measures such as data backup and disk mirroring 

11.1.2.4 describe data protection measures such as encryption and access rights to data (authorization)

"Encryption"

Theory & Tasks 2023
"Access rights"

11.4B Blockchain technology

11.1.2.6 explain the function and operation of Blockchain technologies

11.1.3.2 describe the specifics of open-source software

11.1.3.3 describe the specifics of closed-source software

11.4B Copyright

11.1.3.1 follow the copyright law when developing applications

11.1.3.4 restrict access to data made available through the Internet using a variety of methods

11.4B Cloud technologies

11.1.3.5 evaluate the risks of using cloud technologies 

11.6.1.1 compare features of local (LAN) and wide-area networks (WAN)

11.4С Network topology

11.6.1.2 describe the advantages and disadvantages of network topologies bus, ring, star, mesh

11.6.1.3 explain the purpose of network equipment

11.4С Client-server model

11.6.2.3 know the features of the client-server model

11.6.2.1 describe the role of universal resource locator (URL)

11.4С DNS
11.6.2.2 describe the purpose and organization of a domain name system (DNS)

11.6.3.1 explain the role of protocols in the network (HTTP, FTP, POP3, SMTP, HTTPS, FTPS)

11.4С IP address
11.6.3.2 explain the format of an IP address and how an IP address is associated with a device on a network