Chapter 10 - Boolean logic Candidates should be able to: 1 Identify and use the standard symbols for logic gates 2 Define and understand the functions of the logic gates 3 (a) Use logic gates to create given logic circuits from a: (i) problem statement (ii) logic expression (iii) truth table (b) Complete a truth table from a: (i) problem statement (ii) logic expression (iii) logic circuit © Write a logic expression from a: (i) problem statement (ii) logic circuit (iii) truth table Notes and guidance: • See section 4 for logic gate symbols • Including: – NOT – AND – OR – NAND – NOR – XOR (EOR) – the binary output produced from all the possible binary inputs • NOT is a single input gate • All other gates are limited to two inputs • Circuits must be drawn for the statement given, without simplification • Logic circuits will be limited to a maximum of three inputs and one output

Excel Spreadsheets Full Lesson If Statements and Graph **Objectives ** • Understand the use of absolute cell referencing. • Understand the use of simple functions (sum,max,min and average in a spreadsheet. • Understand the use of If statements including the logical, true and false statements. • Understand how calculations can be used as True statements • Understand the use of nested if statements including more than one true statement. • Understand the use of count and sum if functions. • Understand the need the need to present data in a graph format. • Understanding the need to present information in different forms (graphs)

DatabaseStructured Query Language (SQL) What is SQL? SQL stands for Structured Query Language SQL lets you access and manipulate databases What Can SQL do? SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records in a database SQL can update records in a database SQL can delete records from a database SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures, and views Using SQL in Your Web Site To build a web site that shows data from a database, you will need: An RDBMS database program (i.e. MS Access, SQL Server, MySQL) To use a server-side scripting language, like PHP or ASP To use SQL to get the data you want To use HTML / CSS to style the page **What is RDBMS? ** RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.

Describe the purpose of an operating system (You will be required to understand the purpose and function of an operating system and why it is needed. you will not be required to understand how operating system work.) Show understanding of the need for interrupts Show understanding of the basic Von Neumann model for a computer system and the stored program concept (program instructions and data are stored in main memory and instructions are fetched and executed one after another) Describe the stages of the fetch-execute cycle, including the use of registers and buses

Learning objectives : VLOOKUP and HLookUp Understand the use of the Vlookup function Understand the use of absolute cell referencing. Understand the use of an nested if statement. Understand the used of the different count functions. Understand the use of the sumif function.

MS Word Test 1 for Year 7/8 and 9

Show understanding of the difference between: primary, secondary and off-line storage and provide examples of each, such as: Primary: Read Only Memory (ROM) and Random Access Memory (RAM) Secondary: hard disk drive (HDD) and Solid State Drive (SSD); off-line: Digital Versatile Disc (DVD), Compact Disc (CD), Blu-ray disc, USB flash memory and removable HDD Describe the principles of operation of a range of types of storage device and media including magnetic, optical and solid state. Describe how these principles are applied to currently available storage solutions, such as SSDs, HDDs, USB flash memory, DVDs, CDs and Blu-ray discs. Calculate the storage requirement of a file.

Maths assessment 2 in English and Arabic for grade 5

Maths assessment 1 in English and Arabic for grade 5

8.1 Database Concepts 8.2 Database Management System (DBMS) 8.3 Data Definition Language (DDL) and Data Manipulation Language (DML) Show understanding of the limitations of using a file-based approach for the storage and retrieval of data Describe the features of a relational database that address the limitations of a file-based approach Show understanding of and use the terminology associated with a relational database model: Including entity, table, record, field, tuple, attribute, primary key, candidate key, secondary key, foreign key, relationship (one-to-many, one-to-one, many-to-many), referential integrity, indexing Use an entity-relationship (E-R) diagram to document a database design Show understanding of the normalization process: First Normal Form(1NF), Second Normal Form (2NF) and Third Normal Form (3NF) Explain why a given set of database tables are, or are not, in 3NF Produce a normalized database design for a description of a database, a given set of data, or a given set of tables Show understanding of the features provided by a Database Management System (DBMS) that address the issues of a file based approach Including: data management, including maintaining a data dictionary data modelling logical schema data integrity data security, including backup procedures and the use of access rights to individuals / groups of users Show understanding of how software tools found within a DBMS are used in practice, Including the use and purpose of: developer interface query processor Show understanding that DBMS carries out all creation / modification of the database structure using its Data Definition Language (DDL) Show understanding that the DBMS carries out all queries and maintenance of data using its DML Show understanding that the industry standard for both DDL and DML is Structured Query Language (SQL): Understand a given SQL script Understand given SQL (DDL) commands and be able to write simple SQL (DDL) commands using a sub-set of commands Create a database (CREATE DATABASE) Create a table definition (CREATE TABLE), including the creation of attributes with appropriate data types: CHARACTER,VARCHAR(n), BOOLEAN,INTEGER,REAL,DATE,TIME change a table definition (ALTER TABLE) add a primary key to a table (PRIMARY KEY (field)) add a foreign key to a table (FOREIGN KEY (field) REFERENCES Table (Field)) Write an SQL script to query or modify data (DML) which are stored in (at most two) database tables : Queries including SELECT… FROM, WHERE, ORDER BY, GROUP BY, INNER JOIN, SUM, COUNT, AVG Data maintenance including. INSERT INTO, DELETE FROM, UPDATE

Learning Objectives: 12.1 Program Development Life cycle Show understanding of the purpose of a development life cycle Show understanding of the need for different development life cycles depending on the program being developed (Including, waterfall, iterative, rapid application development (RAD) Describe the principles, benefits and drawbacks of each type of life cycle Show understanding of the analysis, design, coding, testing and maintenance stages in the program development life cycle. 12.2 Program Design Use a structure chart to decompose a problem into sub-tasks and express the parameters passed between the various modules / procedures / functions which are part of the algorithm design Describe the purpose of a structure chart Construct a structure chart for a given problem Derive equivalent pseudocode from a structure chart. Show understanding of the purpose of state-transition diagrams to document an algorithm. 12.3 Program Testing and maintenance Show understanding of ways of exposing and avoiding faults in programs. Locate and identify the different types of errors: syntax errors logic errors run-time errors Correct identified errors Show understanding of the methods of testing available and select appropriate data for a given method (Including dry run, walkthrough, white-box, black-box, integration, alpha, beta, acceptance, stub) Show understanding of the need for a test strategy and test plan and their likely contents. Choose appropriate test data for a test plan (Including normal, abnormal and extreme/boundary) Show understanding of the need for continuing maintenance of a system and the differences between each type of maintenance (Including perfective, adaptive, corrective) Analyze an existing program and make amendments to enhance functionality

11.1 Programming Basics 11.2 Constructs 11.3 Structured Programming 11.1 Programming Basics Implement and write pseudocode from a given design presented as either a program flowchart or structured English Write pseudocode statements for: • the declaration of variables and constants • the assignment of values to variables and constants • expressions involving any of the arithmetic or logical operators input from the keyboard and boutput to the console. Use built-in functions and library routines Any functions not given in the pseudocode guide will be provided String manipulation functions will always be given 11.2 Constructs Use pseudocode to write: • an ‘IF’ statement including the ‘ELSE’ clause and nested IF statements • a ‘CASE’ structure • a ‘count-controlled’ loop: • a ‘post-condition’ loop • a ‘pre-condition’ loop Justify why one loop structure may be better suited to solve a problem than the others **11.3 Structured Programming ** Define and use a procedure Explain where in the construction of an algorithm it would be appropriate to use a procedure. Use parameters: A procedure may have none, one or more parameters and A parameter can be passed by reference or by value. Define and use a function Explain where in the construction of an algorithm it is appropriate to use a function. A function is used in an expression, e.g. the return value replaces the call. Use the terminology associated with procedures and functions: including Procedure / function header, procedure / function interface, parameter, argument, return value Write efficient pseudocode

16.1 - Purposes of an Operating System (OS) 16.2 - Translation Software

5.1 Operating System 5.2 Language Translators

Python 3 Sheet from KS3/4 and 5 . From Laurent Pointal (License Creative Commons Attribution 4) . thanks to a wonderful resources from Laurent Pointal (License Creative Commons Attribution 4)

Students should be able to: Roles of the different computers within the network and subnetwork models Benefits and drawbacks of each model Justify the use of a model for a given situation Understand how packets are transmitted between two hosts for a given topology Justify the use of a topology for a given situation Including the use of public and private clouds. Benefits and drawbacks of cloud computing Describe the characteristics of copper cable, fibreoptic cable, radio waves (including WiFi), microwaves, satellites Including switch, server, Network Interface Card (NIC), Wireless Network Interface Card (WNIC), Wireless Access Points (WAP), cables, bridge, repeater Including Carrier Sense Multiple Access / Collision Detection (CSMA / CD) Methods of bit streaming, i.e. real-time and on-demand Importance of bit rates / broadband speed on bit streaming Including modems, PSTN (Public Switched Telephone Network), dedicated lines, cell phone network • format of an IP address including IPv4 and IPv6 • use of subnetting in a network • how an IP address is associated with a device on a network • difference between a public IP address and a private IP address and the implications for security • difference between a static IP address and a dynamic IP address

Attached year 8 python programming practical test 1, 2 and end of term exam Please feel free to leave any comments and rate the review . Thank you Mr. N.T

2.1 Networks including the internet

15.1 Processors, Parallel Processing and Virtual Machines 15.2 Boolean Algebra and Logic Circuits

17.1 Encryption, Encryption Protocols and Digital certificates