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.

***Data representation: ** 1.1.1 Binary systems •• recognise the use of binary numbers in computer systems •• convert positive denary integers into binary and positive binary integers into denary (a maximum of 16 bits will be used) •• show understanding of the concept of a byte and how the byte is used to measure memory size •• use binary in computer registers for a given application (such as in robotics, digital instruments and counting systems) 1.1.2 Hexadecimal •• represent positive numbers in hexadecimal notation •• show understanding of the reasons for choosing hexadecimal notation to represent numbers •• convert positive hexadecimal integers to and from denary (a maximum of four hexadecimal digits will be required) •• convert positive hexadecimal integers to and from binary (a maximum of 16 bit binary numbers will be required) •• represent numbers stored in registers and main memory as hexadecimal •• identify current uses of hexadecimal numbers in computing, such as defining colours in Hypertext Markup Language (HTML), Media Access Control (MAC) addresses, assembly languages and machine code, debugging 1.1.3 Data storage •• show understanding that sound (music), pictures, video, text and numbers are stored in different formats •• identify and describe methods of error detection and correction, such as parity checks, check digits, checksums and Automatic Repeat reQuests (ARQ) •• show understanding of the concept of Musical Instrument Digital Interface (MIDI) files, JPEG files, MP3 and MP4 files •• show understanding of the principles of data compression (lossless and lossy) applied to music/video, photos and text files

1 Data Representation Show understanding of binary magnitudes and the difference between binary prefixes and decimal prefixes Understand the difference between and use: •• kibi and kilo •• mebi and mega •• gibi and giga •• tebi and tera Show understanding of the basis of different number systems Use the binary, denary, hexadecimal number bases and Binary Coded Decimal (BCD) and one’s and two’s complement representation for binary numbers Convert an integer value from one number base / representation to another Perform binary addition and subtraction: Using positive and negative binary integers. Show understanding of how overflow can occur. Describe practical applications where Binary Coded Decimal (BCD) and Hexadecimal are used Show understanding of and be able to represent character data in its internal binary form, depending on the character set used Familiar with ASCII (American Standard Code for Information Interchange), extended ASCII and Unicode. Students will not be expected to memorise any particular character codes. Use and understand the terms: pixel, file header, image resolution, screen resolution, colour depth, bit depth Perform calculations to estimate the file size for a bitmap image Show understanding of the effects of changing elements of a bitmap image on the image quality and file size Show understanding of how data for a vector graphic are encoded: Use the terms: drawing object, property, drawing list. Justify the use of a bitmap image or a vector graphic for a given task. 2 Multimedia – Graphics and Sound. Show understanding of how sound is represented and encoded: Use the terms: sampling, sampling rate, sampling resolution, analogue and digital data Show understanding of how data for a bitmapped image are encoded. 3 Compression Show understanding of the need for and examples of the use of compression Show understanding of lossy and lossless compression and justify the use of a method in a given situation. Show understanding of how a text file, bitmap image, vector graphic and sound file can be compressed Including the use of run-length encoding (RLE)

App Inventor is a free, cloud-based service that allows you to make your own mobile apps using a blocks-based programming language. You access App Inventor using a web browser (Chrome, Firefox, Safari). With these beginner-friendly tutorials, you will learn the basics of programming apps for Android and iOS phones and tablets. you can use it for year 7 and 8 Please click the link below to use the tutorial https://appinventor.mit.edu/explore/ai2/tutorials Click the link below to start Beginner Tutorials https://appinventor.mit.edu/explore/ai2/beginner-videos

Create a PowerPoint and a poster including the three parts above including the PC or laptop with the latest technology used on them such as hardware component (for example maximum storage devices HDD, CPU, RAM, Motherboard, ….etc), why some of the PCs or laptops are more expensive than others, what makes them so expensive in term of what ? What are the main Components of a Computer System? Gives and Example of Input and Output devises Gives an example of an Operating Systems After you create a PowerPoint and a poster, you should present and explain at the front of the class your project

Test with question and answer for year 6/7 and 8 -Geometric shapes using python programming turtle graphics

Blockly programming for Year 6 and 7 Blockly is a client-side library for the programming language JavaScript for creating block-based visual programming languages and editors. A project of Google, it is free and open-source software released under the Apache License 2.0. It typically runs in a web browser, and visually resembles the language Scratch. https://blockly.games/

In this chapter you will learn about: 1.3.3 Input devices •• describe the principles of operation (how each device works) of these input devices: 2D and 3D scanners, barcode readers, Quick Response (QR) code readers, digital cameras, keyboards, mice, touch screens, interactive whiteboards, microphones. •• describe how these principles are applied to real-life scenarios, for example: scanning of passports at airports, barcode readers at supermarket checkouts, and touch screens on mobile devices. •• describe how a range of sensors can be used to input data into a computer system, including light, temperature, magnetic field, gas, pressure, moisture, humidity, pH and motion •• describe how these sensors are used in real-life scenarios, for example: street lights, security devices, pollution control, games, and household and industrial applications. 1.3.4 Output device •• describe the principles of operation of the following output devices: inkjet, laser and 3D printers; 2D and 3D cutters; speakers and headphones; actuators; flat-panel display screens, such as Liquid Crystal Display (LCD) and Light-Emitting Diodes (LED) display; LCD projectors and Digital Light Projectors (DLP). •• describe how these principles are applied to real-life scenarios, for example: printing single items on demand or in large volumes; use of small screens on mobile devices.

4.1 Central Processing Unit (CPU) Architecture: Show understanding of the basic Von Neumann model for a computer system and the stored program concept Show understanding of the purpose and role of registers, including the difference between general purpose and special purpose registers. Special purpose registers including: • Program Counter (PC) • Memory Data Register (MDR) • Memory Address Register (MAR) • The Accumulator (ACC) • Index Register (IX) • Current Instruction Register (CIR) • Status Register Show understanding of the purpose and roles of the Arithmetic and Logic Unit (ALU), Control Unit (CU) and system clock, Immediate Access Store (IAS) Show understanding of how data are transferred between various components of the computer system using the address bus, data bus and control bus 4.2: Assembly Language: Show understanding of the relationship between assembly language and machine code. Describe the different stages of the assembly process for a two-pass assembler Trace a given simple assembly language program Show understanding that a set of instructions are grouped Including the following groups: Data movement Input and output of data Arithmetic operations Unconditional and conditional instructions Compare instructions Show understanding of the different modes of addressing Including Immediate, direct, indirect, indexed, relative 4.3: Bit manipulation: Show understanding of and perform binary shifts logical, arithmetic and cyclic Left shift, right shift Show understanding of how bit manipulation can be used to monitor / control a device Carry out bit manipulation operations Test and set a bit (using bit masking)

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

AS/ A Level Computer Science TEST 1 with Answer

IGCSE Year 10 and 11 Computer Science TEST 1 and 2 with answers

ICT - Year 7 - Practical END OF YEAR EXAMINATION ( Microsoft Word and PowerPoint and EoY Revision Microsoft Word Revision for Year 7 End of Year Exam– Practical Activities Powerpoint Revision for Year 7 for the End of Year Exam

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.

Declare and use one-dimensional arrays, for example: A[1:n] Show understanding of the use of one-dimensional arrays, including the use of a variable as an index in an array Read or write values in an array using a FOR … TO … NEXT loop

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

For all Teacher attached a student project for you attention: Please before you solve any pre-release material for students. It is better to let them try to solve it first. please give this project to your student for a period of a month therefore you can measure students progress and attainment. IGCSE Pre- release material for Computer Science paper 2 - Student Project Attached the Pre-release material for paper 2 exams , Please ask the students to open the PDF and watch the video and it will give students a starting point how to solve task 1/2/3 for this year exam. Thank you But before that. student should start attempting pre-release paper 2 for last year May/June 2021, Please ask the student to go straight to slide 11 and do the last year exam paper 2 May/June 2021 , Students will find the questions/answers and the python programming code for task 1 / 2 and 3 . I included python programming code for last year paper 2 exams for task 1/2/3 . Please make sure students practice using last year exam paper 2 before they start solving this year paper 2 . Thank you Ask the students to solve and provide the following three tasks for this year exam: pseudo code and python programming for Task 1 pseudo code and python programming for Task 2 pseudo code and python programming for Task 3