Главная | RSS Суббота, 04.04.2020, 10:55

Меню сайта
Форма входа
Логин:
Пароль:
Поиск по сайту

Баннер сайта
Установите мой
баннер себе на сайт

Календарь
«  Апрель 2020  »
ПнВтСрЧтПтСбВс
  12345
6789101112
13141516171819
20212223242526
27282930
 
 

Grade 11 (2019-2020)

 
Материалы для учащихся "Назарбаев Интеллектуальная школа г. Уральска"
Course GCSE ICT ==>
Advanced ICT ==>
Glossary ==>
 
Unit

Topic of lesson. Learning objectives

Presentation, Exercises & etc

Useful materials

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

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

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
 

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 

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 

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

Pagng (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

Test "Logic gates"

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

Полезная материал "Логический вентиль"

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

Logic laws

Worksheet2

Homework

Check yourself

Presentation for the lesson "Karnaugh cards"

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

Presentation for the lesson "HLL & LLL. Generation of PL"

Activity "HLL & LLL" (russian)

Flipchart

Worksheet "Generation of PL"

Homework "LMC"

LMC online

LMC online 2

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 

Homework "Task"

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

Presentation for the lesson "Trace table" Dry Run testing & Trace tables
11.1B

Translators

11.5.1.7 analyze advantages and disadvantages of compilers

11.5.1.8 analyze advantages and disadvantages of interpreters

Presentation for the lesson "Translators"

Test "Compiler vs Interpreter"

 
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

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

Research methods (docx)

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

Presentation for the lesson "DFD"

Example "Levels of DFD"

What is Data Flow Diagram?

Что такое DFD?

11.2A

Relational Database

11.4.1.1 describe relational databases and their purpose

11.4.1.4 define data types when creating a database

11.4.1.2 use the terms attribute, object, index, record, table and tuple to describe databases 

11.4.1.3 explain the difference between primary composite and foreign key

Presentation for the lesson "Relational database"

 
11.2A

ERD

11.4.1.6 define the connections between tables in database

11.4.1.7 create an entity-relationship (ER) model

Presentation for the lesson "ERD"

on Wikibooks

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 "Normalisation"

 
11.2A

SQL

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"

DDL

SQLZOO.NET

 
11.2A

SQL: SELECT, INSERT, UPDATE, DELETE

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

Presentation for the lesson "DML"

 
11.2B

Project work. Data flow diagrams

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

   
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 1-2

Вычислительные модели

Computational models

Presentation for the lesson

Computational models

What is computational thinking? (BBC Bitesize)

Check youself (Test)

11.1A

lesson 3-4

Переменные. Константы.

Типы данных.

Variables. Constants.

Data types

Presentation for the lesson

Activity "Match English terms with Russian equivalents"

Activity "Data types"

File DataTypes.pas

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

File NOD.PAS

Elite Coding Practice
11.1A Data structure. (Array, Record, Enumerated,Sub-range)

File Record.PAS

File Array.PAS

File Enumerated.PAS

File Sub-Range.PAS

Структурированные типы (нестандартное изложение)
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 Turing Machine Presentation for the lesson "Turing machine"

АЛГО2000 (Эмулятор МТ) Скачать

Easiest way to understand Turing Machine

Презентация "Машина Тьюринга - универсальный исполнитель"

Видео Алан Тьюринг
Теория Машина Тьюринга
Машина Тьюринга в школьном курсе

Audio Vocabulary
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"

CSS on wikibooks for the lesson

CSS on w3schools.com for the lesson

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.3C Network. Security of data: data backup, a disk-mirroring strategy, encryption, access rights to data (authorisation)    
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 (практические работы)
 
Поиск по сайту

Наш опрос
С каким языком программирования вы хотели бы работать на уроках информатики?
Всего ответов: 702
Друзья сайта
Система Orphus
Статистика


Онлайн всего: 3
Гостей: 3
Пользователей: 0

Flag Counter
Архив записей

Copyright MyCorp © 2020