| 11.1A |
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 2020
"Application software"
|
Software. Examples and types of software
Wikibooks
|
| 11.1A |
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"
|
Wikibooks
OS (youtube)
OS - Memory manager (youtube)
OS - Process manager (youtube)
OS - Device manager 1 (youtube)
|
| 11.1A |
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"
|
Von Neumann architecture and System bus on Wikibooks
Computer organization
System bus design
|
| 11.1A |
Main memory
11.3.4.1 explain the differences between RAM and ROM memory
|
Theory and tasks 2020
"RAM vs ROM"
Exercise "RAM vs ROM"
|
How computer memory works (video)
Difference between RAM and ROM memory
RAM
|
| 11.1A |
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"
|
Wikibooks (manage memory)
virtual memory on teach-ict.com
Virtual memory (pdf)
Memory management
Operating system - Memory management
Paging (teach-ict.com)
Paging and segmentation
Paging, segmentation, virtual memory
|
| 11.1A |
Boolean logic. Logic gates. Truth tables
11.3.3.3 build truth tables AND, OR, NOT, NAND, NOR, XOR
|
Theory and tasks 2020
"Boolean logic. Logic gates. Truth tables"
Check yourself "Logic gates & truth tables"
Check yourself "Define result of truth tables"
|
Logic game
"Logic gate"
Video lesson1
Video Lesson2
Video lesson3
Boolean on www.bbc.co.uk
Truth Table Generator
|
| 11.1A |
Simplification logic 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 2020
"Simplification logic expressions"
|
Circuit Simplification Examples
Laws of Boolean Algebra
DeMorgan’s Theorems
Boolean Expressions Calculator
Simplification (examples)
|
| 11.1B |
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 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)
|
| 11.1B |
LMC simulator
11.5.1.3 analyze a simple program written in the language of assembler
|
Theory & tasks 2020
"Programming in Little Man Computer"
|
LMC online
LMC online 2
Little Man Computer: mini-challenge
Memory addressing modes (BEST)
|
| 11.1B |
Trace tables
11.5.1.4 use trace tables to find and verify the correctness of an algorithm
|
Theory & tasks 2020
"Trace table"
|
Create trace table online
|
| 11.1B |
Translators
11.5.1.7 analyze advantages and disadvantages of compilers
11.5.1.8 analyze advantages and disadvantages of interpreters
|
Theory & tasks 2020
"Translators"
|
|
| 11.1С |
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 2020
"SDLC"
Theory & tasks 2020
"Models of SDLC"
Test "SDLC"
Test "SDLC models"
|
|
| 11.1C |
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)
|
| 11.1C |
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 Data Flow Diagram?
Что такое DFD?
|
| 11.1С |
Flowcharts
11.2.1.7 use flow charts to input, process, store and output data in computing systems
|
Theory & tasks 2020
"Flowcharts" |
|
| 11.2A |
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?"
|
|
| 11.2A |
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 2020
"Entity Relationship Diagram (ERD)"
|
on Wikibooks
Examples of Databases
|
| 11.2A |
Database normalization
11.4.1.5 define the connections between tables in a database(1-3NF)
|
Theory & tasks 2020
"Database normalization"
|
|
| 11.2A |
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"
|
|
| 11.2B |
Unit 11.2B: Designing a new system
SMART objectives
|
"Project work: Design" 2020
Theory & tasks 2020
"SMART objectives"
|
|
| 11.2B |
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
|
Theory & tasks 2020
"Data flow diagram" |
|
| 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
|
Theory & tasks 2020
"Entity Relationship Diagram (ERD)"
Theory & tasks 2020
"Data dictionary"
|
|
| 11.2B |
Project work. Flowcharts of processes
11.2.1.7 use flow charts to input, process, store and output data in computing systems
|
Theory & tasks 2020
"Flowcharts" |
|
| 11.2B |
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
|
| 11.2B |
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
|
|
| 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
|
Theory & tasks 2020
"Intended benefits and Limits of the scope of the solution"
|
|
| 11.2B |
Development frameworks
11.2.2.3 describe the characteristics of a development framework
|
Theory & tasks 2021
"Framework"
PPT "Development framework"
|
|
| 11.3B |
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
|
| 11.3B |
HTML. Forms
11.5.3.2 create forms for data entry using HTML tags
|
Theory & tasks 2021
"Webforms"
|
|
| 11.3B |
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
Дизайн интерфейса веб-страниц
|
| 11.3B |
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
|
PHP presentation of Group 1
PHP Tutorial
PHP Syntax
PHP Variables
PHP echo & print Statements
PHP IF statement
PHP Loops
Algorithm structures
Test
|
|
| 11.3B |
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)
|
| 11.3B |
SQL & PHP. User registration. |
Theory & tasks 2023 "SQL & PHP. User registration"
Research "INSERT INTO"
File testreg.php
|
|
| 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
|
Theory & tasks 2021
"Arrays"
Theory & tasks 2023
"2D arrays (Matrix)"
|
Arrays (Wikibooks) |
| 11.3A |
Bubble sort and Insertion sort
11.5.2.4 write an algorithm /pseudo-code for sorting by insertion and bubble sort
|
Theory & tasks 2021
"Sorting algorithms" |
|
| 11.3A |
Binary search
11.5.2.5 write a pseudo-code of binary search for the solution of a specific problem
|
Theory & tasks 2021
"Search in an array" |
Binary search |
| 11.3A |
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 2021
"Algorithm efficiency"
|
|
| |
|
|
|
| 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
|
Theory & tasks 2021
"Algorithm structures"
|
|
| 11.4А |
Validation and verification
11.1.2.5 explain the difference between the terms verification and validation
|
Theory & tasks 2021
"Validation & Verification"
|
|
| |
|
|
|
| 11.4B |
Data protection
11.1.2.1 explain the difference between the terms security, privacy and data integrity
|
Theory & tasks 2021
"Security, privacy, integrity"
|
|
| 11.4B |
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"
|
|
| 11.4B |
Blockchain technology
11.1.2.6 explain the function and operation of Blockchain technologies
|
Theory & tasks 2021
"Blockchain technology"
|
|
| 11.4B |
Open and closed software
11.1.3.3 describe specifics of closed source software
|
|
|
| 11.4B |
Access restriction
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 risks of using cloud technologies
|
|
|
| 11.4C |
LAN & WAN
11.6.1.1 compare features of local (LAN) and wide-area networks (WAN)
|
Theory & tasks 2020
"LAN & WAN"
|
|
| 11.4C |
Network topology
11.6.1.2 describe the advantages and disadvantages of network topologies bus, ring, star, mesh
|
Theory & tasks 2020
"Network topology"
|
|
| 11.4C |
Network hardware
11.6.1.3 explain the purpose of network equipment
|
Theory & tasks 2021
"Network hardware"
|
|
| 11.4С |
Client-server model
11.6.2.3 know the features of the client-server model
|
Theory & tasks 2021
"Client-server model"
|
|
| 11.4С |
URL
11.6.2.1 describe the role of universal resource locator (URL)
|
Theory & tasks 2021
"URL"
|
|
| 11.4С |
DNS
11.6.2.2 describe the purpose and organization of a domain name system (DNS)
|
Theory & tasks 2021
"DNS"
|
|
| 11.4С |
Network protocols
11.6.3.1 explain the role of protocols in the network (HTTP, FTP, POP3, SMTP, HTTPS, FTPS)
|
Theory & tasks 2021
"Network protocols"
|
|
| 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
|
Theory & tasks 2021
"IP address"
|
|
| |
|
|
|
| |
|
|
Packet Tracer (практические работы) |
