| 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  "Application software"
Presentation for the lesson "Software Categories"
|
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 "Operating Systems"
Theory and tasks "Types of operating systems"
Presentation for the lesson "OS. Types of OS"
Lesson on Bilimland "Types of OS"
Test "Operating system"
|
wikibooks
OS (youtube)
OS - Memory manager (youtube)
OS - Process manager (youtube)
OS - Process manager 2 (youtube)
OS - Device manager 1 (youtube)
OS - Device manager 2 (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
"Von Neumann architecture"
Theory and tasks
"System bus"
Presentation for the lesson "Von Neumann architecture. System bus"
Bonus. Presentation "CPU"
Presentation for the lesson "System bus
|
Von Neumann architecture and System bus on wikibooks
Computer organisation
System bus design
|
| 11.1A |
Main memory
11.3.4.1 explain the differences between RAM and ROM memory
|
Theory and tasks
"RAM vs ROM"
Presentation for the lesson "Main memory"
Handout for student "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
"Cache memory & Virtual memory"
Presentation for the lesson "Cache memory. Virtual memory"
Online board "Cache memory & Virtual memory"
|
wikibooks (manage memory)
virtual memory on teach-ict.com
Virtual memory (pdf)
Memory managment
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
"Boolean logic. Logic gates. Truth tables"
Build logic curcuit online Logic.ly
Biuld logic curcuit (drawing)
Check yourself "Logic gates & truth tables"
Check yourself "Define result of truth tables"
|
Boolean algebra
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
"Simplification logic expressions"
Presentation for the lesson "Karnaugh cards"
Wikibooks
|
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
"High and low level PL"
Theory and tasks
"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
"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
"Trace table"
OLD Presentation for the lesson "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
"Translators"
OLD Presentation for the lesson "Translators"
|
|
| 11.1C |
Project. Analysis |
Structure for course work |
|
| 11.1С |
SDLC
11.2.1.1 explain the life cycle stages used in the solving of problems
11.2.1.2 analyse the advantages and disadvantages of cyclical,
waterfall and spiral models
|
Theory & tasks
"SDLC"
Theory & tasks
"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
"Data collection methods"
Theory & tasks
"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
"DFD. Levels of DFD"
Presentation for the lesson "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
"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
|
Presentation for the lesson "Relational database" |
|
| 11.2A |
Types of relationships
Entity Relationship Diagrams
11.4.1.6 define the connections between tables in database
11.4.1.3 explain the difference between primary composite and foreign key
11.4.1.7 create an entity-relationship (ER) model
|
Presentation for the lesson "ERD" |
on Wikibooks
Examples of Databases
|
| 11.2A |
Database normalisation
11.4.1.5 define the connections between tables in database(1-3NF)
|
Presentation for the lesson "Database. Normalisation"
Normalisation for students
Activity "Database Normalisation"
|
|
| 11.2A |
SQL query language.
DDL & DML.
11.4.2.1 explain the purpose of 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
|
Presentation for the lesson "SQL. DDL. DML"
Presentation for the lesson "DML"
DDL
SQLZOO.NET
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| 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
|
Activity "Data types (MySQL)" |
|
| 11.2B |
Project work. Flowcharts of processes
11.2.1.7 use flow charts to input, process, store and output data in computing systems
|
|
|
| 11.2B |
Prototype
11.2.2.4 discuss the advantages and disadvantages of using prototypes when developing solutions
|
Prototyping
|
Prototype: pros & cons (video)
|
| |
|
|
|
| 11.2B |
Hardware & software requirements |
Research
|
|
| 11.2B |
Development frameworks |
PPT "Development framework"
|
|
| |
|
|
|
| 11.3B |
HTML. Structure of html-document
11.5.3.1 create a site using basic HTML tags
|
Presentation & homework
Online course
Text for file table.html
|
HTML on w3schools.com
Web-page constraction on wikibooks
HTML & CSS on wikibooks
Download Brackets
Online HTML and CSS editor http://dabblet.com/
|
| 11.3B |
HTML. Images and hyperlinks
11.5.3.1 create a site using basic HTML tags
|
HTML Images
HTML Links
|
|
| 11.3B |
HTML. Forms
11.5.3.2 create forms for data entry using HTML tags
|
HTML Forms |
|
| 11.3B |
CSS. Tags <DIV>, <SPAN>
11.5.3.3 use the CSS stylesheet when creating a site
11.5.3.1 create a site using basic HTML tags
|
HTML <div> Tag
HTML <span> Tag
CSS Tutorial
|
|
| 11/3B |
Script language (PHP)
11.5.3.8 use script language to provide interactivity
11.5.3.6 use various algorithmic structures in 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
|
|
| |
|
|
|
| |
1D, 2D Arrays
11.5.2.1 use the technical terms associated with arrays including upper and lower bounds
11.5.2.2 select a suitable data structure for a given task (1D or 2D array)
11.5.2.3 write program code using 1D and 2D arrays
|
Presentation for the lesson
"1D and 2D Arrays" (previous version)
|
Arrays (wikibooks) |
| |
Bubble sort and Insertion sort
|
Flipchart Sort arrays
|
|
| |
Binary search
11.5.2.5 write a pseudo-code of binary search for the solution of a specific problem
|
Flipchart Binary search
Presentation Binary search
Test youself
|
Binary search |
| |
Algorithm efficiency |
Big-O notation
Time and space algorithm efficiency
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
|
|
|
|
|
11.1A
lesson 3-4
|
Переменные. Константы.
Типы данных.
Variables. Constants.
Data types
|
Presentation for the lesson
Activity "Match English terms with Russian equivalents"
Activity "Data types"
Test "Constants, variables and data types"
|
Constants and Variables
Variables on Wikibooks
Data types on Wikibooks
Типы данных в Delphi
Правила хорошего программирования
Советы по стилю кода
|
| 11.1A |
Data types. Types of algorithms. Problem solving. |
Presentation for the lesson
|
|
| |
|
|
|
| 11.1A |
Subroutines: Procedures and Functions |
Presentation for the lesson "Random numbers. Subroutines"
Activity "Define terms"
|
Random number generation (wikibooks)
Subroutines (wikibooks)
Local and global variables (wikibooks)
|
| 11.1C |
Fetch-Execute cycle |
Presentation for the lesson "Fetch-Execute cycle"
Bonus. Presentation "Fetch-Execute cycle"
Activity "Registers. Terms and definitions"
|
Video "Fetch-Execute cycle"
Online scheme of work Fetch-Execute cycle
|
| |
|
|
|
| 11.2A |
Compilers & Interpreters |
Презентация к уроку "Уровни языков программирования. Трансляторы"
|
Compilers vs Interpreters – An overview of the differences
Трансляция кода
О компиляторах, интерпретаторах и байт-коде
Video: "Compilers and intepreters"
|
| 11.2A |
Debugging |
Presentation for lesson
Test "Programming software and the IDE"
Task 1
Task 2
Task 3
Task 4
|
Debugging
Video "Errors, Debugging, Trace table"
Test data
Run-time errors
|
| 11.2A |
Sort arrays |
Presentation for lesson
Test "Sorting"
|
wikibooks
visualisation sort
|
| 11.2A |
Binary Searching |
Presentation for lesson
Test "Searching"
Linear & binary search
Presentation of Linear & Binary search |
wikibooks
Binary search (khan academy)
|
| 11.2B |
Database |
Presentation for the lesson "Database"
Presentation for the lesson "Primary key & Composite key"
Presentation for the lesson "Types of Validation in Database"
Activity1 "Recollect (Remember) basic elements of database"
Tasks "Terms & definitions"
|
Introducing databases (bbc.co.uk)
Databases on wikibooks
Databases (teach-ict.com)
Data types in database
Валидация данных в Access
Data Handling: Validation
|
| 11.2B |
Relational Database. ER-diagram
|
Presentation for the lesson "Relational database"
Table "Countries"
Table "Cities"
|
Tutorial "DBMS"
|
| 11.2B |
Queries. SQL-queries |
Presentation for the lesson "Queries in DBMS" |
sqlzoo.net
Практическая работа
Online course SQL: Select
|
| 11.2С |
ASCII & Unicode |
Presentation for the lesson "ASCII & Unicode" |
|
| 11.2C |
Data representation. Real numbers. Positive and negative |
Presentation for the lesson "Representation negative numbers"
Activity "Binary_conversions"
|
Online calculator "Two's compliment" |
| 11.2C |
Fixed point real numbers |
Presentation for the lesson "Representation fixed point numbers" |
|
| 11.2C |
Floating point real numbers |
Presentation for the lesson "Representation floating point numbers" |
Floating point binary
Floating point numbers on wikibooks
|
| 11.3A |
CSS. Three types. |
Presentation for the lesson "CSS"
|
Book CSS
Дизайн интерфейса веб-страниц
|
| 11.3A |
HTML. Forms. |
Web form on w3schools.com for the lesson
|
|
| 11.3A |
Methods of creating web-sites. CMS & WYSIWYG. |
Presentation "Methods of creating web-sites"
Presentation "WYSIWYG Serif Web-plus"
Online task "Web site design. Key words"
Practice "Basic Web Design"
|
Serif Web-Plus (видео)
Serif Web-plus (tutorial)
WYSIWYG (wikipedia)
WIX.COM (WYSIWIG online)
Popular CMS
|
| 11.3А |
PHP |
Презентация "Создание БД в PHPMyAdmin" (не доработано)
Презентация "Запросы SQL. DDL & DML"
Презентация "Запись данных с формы в таблицу БД"
Презентация "Выбор и вывод записей из таблиц БД"
|
Создание регистрации на сайте
User registration system (video)
|
| 11.3A |
SQL & PHP. User registration. |
Presentation for the lesson "SQL & PHP. User registration"
Research "INSERT INTO"
File testreg.php
|
|
| 11.3B |
Project. Analysis |
Presentation for the lesson "Project. Analysis"
Presentation for the lesson "Coursework. Describtion of problem"
Filled outline proposal forms
Outline proposal form (template)
|
|
| 11.3C |
Network. LAN and WAN.
Internet, Intranet and WWW.
Topology
|
Presentation for the lesson "Network. LAN and WAN. Internet, Intranet and WWW. Topology"
Activity "Компьютерные сети"
Activity "Network"
Play the Game "Topology"
Test "What is the network?"
|
|
| 11.3C |
Network. Network components. URI, URL, URN. IP-addresses. DNS. |
Presentation for the lesson "Network. NIC, Modem. Client-Server & P2P. URI, URL, URN"
Presentation for the lesson "Network. Web-browser and Web-server. IP-addresses. DNS"
|
IGCSE "Networking hardware" |
| 11.3C |
Network. Protocols. TCP/IP stack. |
Presentation for the lesson "Protocols. TCP/IP stack"
|
|
| 11.4A |
System optimization. Virtualization |
Presentation for the lesson "Virtual machine" (rus) |
Virtual machine
Virtual machine (teach-ict.com)
Virtual machine (bbc.co.uk)
Provision of virtual machine
|
| 11.4C |
Copyright and plagiarism.
Open and close software.
|
Test Software concepts |
Copyright law
Copyright and plagiarism
Copyright on teach-ict.com
Open and proprietary software
|
| 11.4C |
Biometrics.
DRM.
|
|
Biometrics on teach-ict.com
Biometrics
Biometrics on bbc.com
Legislation and copyright issues (DRM)
|
| |
|
|
Packet Tracer (практические работы) |
