Software Categories

11.3.1.1 justify the choice of applied software and choice
criteria based on the goals 
11.3.1.2 classify application software

Theory and Tasks 2024 
"Software categories: system and application"

Theory and Tasks 2023 
"Application software"

Software. Examples and types of software

Operating Systems. Types of operating systems.

11.3.1.3 describe the purpose and main functions of operating systems 
11.3.1.4 compare single-user and multi-user operating systems 
11.3.1.5 compare one-task and multitasking operating systems

Theory and Tasks 2022
"Operating Systems"

Theory and Tasks 2020
"Types of operating systems"

OS - Memory manager (youtube)

OS - Process manager (youtube)

OS - Device manager 1 (youtube)

Von Neumann architecture

11.3.2.1 describe the interaction of CPU with peripheral devices

System bus

11.3.2.2 describe the purpose of CPU components,
system bus and main memory
 

Theory and Tasks 2020 
"Von Neumann architecture"

Theory and Tasks 2020
"System bus"

Main memory

11.3.4.1 explain the differences between RAM and ROM memory 

Theory and Tasks 2023 
"RAM vs ROM"

Cache memory. Virtual memory.

11.3.4.3 explain the purpose of cache memory 
11.3.4.2 explain the purpose of virtual memory 

Theory and Tasks 2020
"Cache memory & Virtual memory"

Boolean logic. Logic gates. Truth tables

11.3.3.3 build truth tables AND, OR, NOT, NAND, NOR, XOR

Theory and Tasks 2022
"Boolean logic. Logic gates. Truth tables"

Logic game

Truth Table Generator

Simplifying Boolean expressions

11.3.3.1 distinguish between laws of Boolean logic 

11.3.3.2 simplify logical expressions using the laws of Boolean logic

Theory and Tasks 2022
"Simplifying Boolean expressions"

Circuit Simplification Examples

Laws of Boolean Algebra

DeMorgan’s Theorems

Boolean Expressions Calculator

Simplification (examples)

Classifications and categories of programming languages

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

Theory and Tasks 2020
"High and low-level PL"

Theory and Tasks 2020
"Generation of PL"

Activity "HLL & LLL" (Russian)

Generation of programming languages

High & low-level languages (youtube)

LMC simulator

11.5.1.3 analyze a simple program written in the language of the assembler 

Theory & Tasks 2023
"Programming in Little Man Computer"

LMC online

LMC online 2

Little Man Computer: mini-challenge

Memory addressing modes (BEST)

Trace tables

11.5.1.4 use trace tables to find and verify the correctness of an algorithm

Theory & Tasks 2022
"Trace table"

Create trace table online

Translators

11.5.1.7 analyze the advantages and disadvantages of compilers

11.5.1.8 analyze the advantages and disadvantages of interpreters

Theory & Tasks 2022
"Translators"

SDLC

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 & Tasks 2022
"SDLC"

Theory & Tasks 2023
"Models of SDLC"

Data analysis. 
Compare alternative solutions 

11.2.1.3 describe data collection methods

11.2.1.4 compare different data analysis techniques

11.2.1.5 compare alternative solutions to a problem in order to choose the most effective algorithm

Theory & Tasks 2020
"Data collection methods"

Theory & Tasks 2020
"Alternative solutions"

Your Guide to Qualitative and Quantitative Data Analysis Methods

Practical Project: Analysis

Analysis on Wikibooks and wikibooks2

Плохие и хорошие вопросы в интервью (стр. 47)

Data Flow Diagram

11.2.1.6  use data flow diagrams (DFD) to input, process,   
store and output data in computing systems

Theory & Tasks 2020
"DFD. Levels of DFD"

Example "Levels of DFD"

What is a Data Flow Diagram?

Что такое DFD?

Flowcharts

11.2.1.7 use flow charts to input, process, store, and output data in computing systems

Relational databases

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

Theory & Tasks 2020
"Relational database"

Theory & Tasks 2020
"Data types of DB MySQL"

Theory & Tasks 2020
"Primary key and Composite key"

Practice 2020
"How to create a database and table in phpMyAdmin?"

Types of relationships

Entity Relationship Diagrams

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

Theory & Tasks 2024
"Entity Relationship Diagram (ERD)"

on Wikibooks

Examples of Databases 

Database normalization

11.4.1.5 define the connections between tables in a database(1-3NF)

Theory & Tasks 2020
"Database normalization"

SQL query language.

DDL & DML.

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.5 use SQL SELECT for data selection in more tables

Theory & Tasks 2022
"SQL. Data definition language"

Theory & Tasks 2020
"Data dictionary"

Theory & Tasks 2022
"SQL. Data manipulation language"

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

Unit 11.2B: Designing a new system

SMART objectives

"Project work: Design" 2020

Theory & Tasks 2020
"SMART objectives"

Project work. Designing a new system

11.2.1.6 use data flow diagrams (DFD) to input, process, store, and output data in computing systems

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

Theory & Tasks 2020
"Entity Relationship Diagram (ERD)"

Theory & Tasks 2020
"Data dictionary"

Project work. Flowcharts of processes

11.2.1.7 use flow charts to input, process, store, and output data in computing systems

Prototype

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

Theory & Tasks 2020
"Prototyping"

What is modular design?

Multimedia design

Modular design on Wikibooks

Hardware & software requirements

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 

Theory & Tasks 2020
"Hardware & software requirements"

Research

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 

Theory & Tasks 2020
"Intended benefits and Limits of the scope of the solution"

Development frameworks

11.2.2.3 describe the characteristics of a development framework 

Theory & Tasks 2021
"Framework"

PPT "Development framework"

HTML. Structure of HTML-document

11.5.3.1 create a site using basic HTML tags

Theory & Tasks 2021
"Web development. HTML"

HTML <div> Tag

HTML <span> Tag

Online course 

Text for file table.html

Web-page construction on Wikibooks
HTML & CSS on Wikibooks

Download Brackets 

HTML. Forms

11.5.3.2 create forms for data entry using HTML tags

Theory & Tasks 2021
"Webforms"

CSS. Tags <DIV>, <SPAN>

11.5.3.3 use the CSS stylesheet when creating a site

Theory & Tasks 2023 
"CSS. Types of CSS"

CSS Tutorial

Book CSS

Дизайн интерфейса веб-страниц

Script language (PHP)

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

Theory & Tasks 2023 
"Algorithmic structures"

Theory & Tasks 2023 
"Script language"

PHP presentation of Group 1

PHP Tutorial

PHP Syntax

PHP Variables

PHP echo & print Statements

PHP IF statement

PHP Loops

Algorithm structures 

Test

PHP & MySQL database. Connect to database

11.5.3.4 use script language to connect a database 

Theory & Tasks 2023 
"Connect to database"

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

User registration system (video)

Theory & Tasks 2024 
"SQL & PHP. User registration"

Research "INSERT INTO"

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 

Theory & Tasks 2021
"Arrays"

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

Arrays (Wikibooks)

Bubble sort and Insertion sort

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

Binary search

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

Theory & Tasks 2024
"Search in an array"

Binary search

Algorithm efficiency

11.5.2.6 to understand the time-efficiency of algorithms 

11.5.2.7 to understand the space-efficiency of algorithms 

Theory & Tasks 2024
"Algorithm efficiency"

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 

Theory & Tasks 2021
"Algorithm structures" 

Validation and verification

11.1.2.5 explain the difference between the terms verification and validation

Theory & Tasks 2023
"Validation & Verification"

Good programming style

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

Data protection

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

Theory & Tasks 2021
"Security, privacy, integrity"

Data backup and Disk mirroring

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

Theory & Tasks 2021
"Data backup and Disk mirroring"

11.4B

Encryption. Authorization

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

Theory & Tasks 2021
"Encryption"

Theory & Tasks 2023
"Access rights"

Blockchain technology

11.1.2.6 explain the function and operation of Blockchain technologies

Theory & Tasks 2021
"Blockchain technology"

Open and closed software

11.1.3.2 describe the specifics of open-source software

11.1.3.3 describe the specifics of closed-source software

Theory & Tasks 2023
"Open and closed software"

Copyright

11.1.3.1 follow the copyright law when developing applications

Theory & Tasks 2023
"Understanding copyright law"

Access restriction

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

Theory & Tasks 2023
"Access restriction"

Cloud technologies

11.1.3.5 evaluate the risks of using cloud technologies 

Theory & Tasks 2023
"Cloud technologies"

LAN & WAN

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

Theory & Tasks 2020
"LAN & WAN"

Network topology

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

Theory & Tasks 2020
"Network topology"

Network hardware

11.6.1.3 explain the purpose of network equipment

Theory & Tasks 2021
"Network hardware"

Client-server model

11.6.2.3 know the features of the client-server model

Theory & Tasks 2024
"Client-server model"

URL

11.6.2.1 describe the role of universal resource locator (URL)

Theory & Tasks 2023
"URL"

DNS

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

Theory & Tasks 2021
"DNS"

Network protocols

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

Theory & Tasks 2023
"Network protocols"

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

Theory & Tasks 2021
"IP address"

Packet Tracer (практические работы)